SC_EX19_9b_FATEMATUZZAHARA_1.xlsx
Documentation Shelly Cashman Excel 2019 | Module 9: SAM Project 1b Green Lake Sports Camp FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING Author:FATEMATUZ ZAHARA Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Teams Summer Teams BaseballBasketballLacrosseSoccerVolleyball Registration fee$ 129$ 278$ 119$ 149$ 119 Weeks per session24242 Minimum campers1510- 01610 Equipment fee$ 200$ 180$ 200$ 175$ 175 RevenueERROR:#VALUE!$ 4,580$ - 0$ 5,184$ 2,940 Counselors33222 Counselor cost$ 535$ 535$ 500$ 550$ 500 Supplies cost$ 125$ 95$ 105$ 125$ 95 Expenses$ 1,730$ 1,700$ 1,105$ 1,225$ 1,095 Revenue stats Per sessionERROR:#VALUE!$ 2,880$ (1,105)$ 3,959$ 1,845 Per weekERROR:#VALUE!$ 720$ (553)$ 990$ 923 Per camperERROR:#VALUE!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0! Average revenue Per sessionERROR:#VALUE! Per weekERROR:#NAME? Per camperERROR:#VALUE! Private Lessons Private Lessons BaseballBasketballLacrosseSoccerVolleyball Coach cost per day$ 420$ 480$ 400$ 475$ 400 Equipment cost$ 120$ 85$ 100$ 95$ 85 Total cost$ 540$ 565$ 500$ 570$ 485 Maximum campers per day1012101215 Enrolled campers per day9107128 Coaching fee per person$ 75$ 80$ 80$ 80$ 75 Average profit per session$ 135$ 235$ 60$ 390$ 115 Average profit per camper$ 15.00$ 23.50$ 8.57$ 32.50$ 14.38 Revised Fees Revised Fees BaseballBasketballLacrosseSoccerVolleyball Coach cost per day$ 420$ 480$ 400$ 475$ 400 Equipment cost$ 120$ 85$ 100$ 95$ 85 Total cost$ 540$ 565$ 500$ 570$ 485 Maximum campers per day1012101215 Enrolled campers per day9107128 Coaching fee per person$ 75$ 80$ 80$ 80$ 75 Average profit per session$ 135$ 235$ 60$ 390$ 115 Average profit per camper$ 15.00$ 23.50$ 8.57$ 32.50$ 14.38 Games Games Game Schedule BaseballBasketballLacrosseSoccerVolleyballTotal Friday games000000 Saturday games000000 Games per week000000 Games - Profit Analysis BaseballBasketballLacrosseSoccerVolleyballTotal Profit per Friday game$ 25.00$ 35.00$ 20.00$ 30.00$ 25.00$ 135.00 Subtotal profit$ - 0$ - 0$ - 0$ - 0$ - 0- 0 Profit per Saturday game$ 35.00$ 45.00$ 30.00$ 40.00$ 35.00185.00 Subtotal profit$ - 0$ - 0$ - 0$ - 0$ - 0- 0 Total weekly profit$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0 Practices BaseballBasketballTotal Friday practice000 Saturday practice000 Practices per week000 Maximum weekly profit model Documentation Shelly Cashman Excel 2019 | Module 4: SAM Project 1b Ramos Family Home Purchase CREATE A LOAN ANALYSIS Author:FATEMATUZ ZAHARA Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Mortgage Calculator New House Mortgage Calculator Loan Payment CalculatorScenariosBank 1Bank 2Bank 3 Date10/1/21Rate4.32%Loan Amount$ - 0$ - 0$ 337,500 PropertyBeecher StreetTerm in Months360Annual Interest Rate4.40%4.56%4.56% Price$ 350,000Monthly PaymentMonthly Interest Rate0.37%0.38%0.38% Down Payment$ 35,000Total InterestLoan Period in Years303020 Loan AmountTotal CostLoan Period in Months360360240 Start Date1/5/221/5/221/5/22 Varying Interest Rates and TermsMonthly Payment$ (1,500)$ (1,500) RateNumber of MonthsFuture Value$0.00$1,151,573.10 180240360 4.00%Current Rent$ 1,500 4.08%Monthly House Payment$ - 0 4.16% 4.24% 4.32% 4.40% 4.48% 4.56% 4.64% 4.72% 4.80% 4.88% 4.96% Listings Home Details Current Listings LocationStreetTypeSq FtAskingIn Budget? WestBeecher StreetSingle family2,985$ 350,000Yes WestKenyon RoadSingle family2,550$ 340,000Yes EastGreenwood BlvdSingle family2,875$ 365,000No NorthwestParkway AvenueCondo2,468$ 375,000No EastEverdale DriveSingle family3,050$ 370,000No SouthwestLacrosse StreetTownhouse2,180$ 369,000No WestHolland LaneSingle family3,100$ 380,000No NortheastBernadine CourtCondo2,395$ 350,000Yes EastRiver Crest WayTownhouse3,000$ 367,000No Car Loan Car Loan Year:2021 Loan DetailsLoan Summary Loan amount$27,500.00Scheduled payment$619.08 Annual interest rate3.85%Scheduled number of payments48 Loan period in years4Actual number of payments13 Number of payments per year12Total early paymentsERROR:#VALUE! Start date of loan2/1/21Total interest$919.45 Total paid$29,715.83 Optional extra payments$120.00 Pmt NoPayment DateBeg BalancePayment AmtExtra PaymentTotal PaymentPrincipalInterestEnding BalanceCumulative Interest 12/1/21$27,500.00$619.08$120.00$739.08$650.85$88.23$26,849.15$88.23 23/1/21$26,849.15$619.08$120.00$739.08$652.94$86.14$26,196.21$174.37 34/1/21$26,196.21$619.08$120.00$739.08$655.03$84.05$25,541.18$258.42 45/1/21$25,541.18$619.08$120.00$739.08$657.14$81.94$24,884.04$340.36 56/1/21$24,884.04$619.08$120.00$739.08$659.24$79.84$24,224.80$420.20 67/1/21$24,224.80$619.08$120.00$739.08$661.36$77.72$23,563.44$497.92 78/1/21$23,563.44$619.08$120.00$739.08$663.48$75.60$22,899.96$573.52 89/1/21$22,899.96$619.08$120.00$739.08$665.61$73.47$22,234.35$646.99 910/1/21$22,234.35$619.08$120.00$739.08$667.74$71.34$21,566.61$718.32 1011/1/21$21,566.61$619.08$120.00$739.08$669.89$69.19$20,896.72$787.52 1112/1/21$20,896.72$619.08$120.00$739.08$672.04$67.04$20,224.68$854.56 121/1/22$20,224.68$619.08$120.00$739.08$674.19$64.89$19,550.49$919.45 Ending Balance and Cumulative Interest Ending Balance44228442564428744317443484437844409444404447044501445314456226849.14933682839226196.21052777910525541.1768733841224884.04165268128424224.7981231453623563.43952061884222899.95905924255222234.34993138601221566.605307577620896.71833643446720224.68214459225119550.489836634541Cumulative Interest44228442564428744317443484437844409444404447044501445314456288.229166666666671174.37018745565777258.41636289894905340.36097203438976420.19727233674223497.91849964850024573.51786811048567646.98857009222218718.32377612208563787.5166348172304854.56027281329102919.44779469385787