Documentation
Shelly Cashman Excel 2019 | Module 9: SAM Project 1
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
Baseball Basketball Lacrosse Soccer Volleyball
Registration fee $ 129 $ 278 $ 119 $ 149 $ 119
Weeks per session 2 4 2 4 2
Minimum campers 15 10 - 0 16 10
Equipment fee $ 200 $ 180 $ 200 $ 175 $ 175
Revenue ERROR:#VALUE! $ 4,580 $ - 0 $ 5,184 $ 2,940
Counselors 3 3 2 2 2
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 session ERROR:#VALUE! $ 2,880 $ (1,105) $ 3,959 $ 1,845
Per week ERROR:#VALUE! $ 720 $ (553) $ 990 $ 923
Per camper ERROR:#VALUE! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
Average revenue
Per session ERROR:#VALUE!
Per week ERROR:#NAME?
Per camper ERROR:#VALUE!
Private Lessons
Private Lessons
Baseball Basketball Lacrosse Soccer Volleyball
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 day 10 12 10 12 15
Enrolled campers per day 9 10 7 12 8
Coaching fee per person $ 75 $ 80 $ 80 $ 80 $ 75
Average profit per session $ 135 $ 235 $ 60 $ 390 $ 115
Average profit per camper $ XXXXXXXXXX $ XXXXXXXXXX $ 8.57 $ XXXXXXXXXX $ XXXXXXXXXX
Revised Fees
Revised Fees
Baseball Basketball Lacrosse Soccer Volleyball
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 day 10 12 10 12 15
Enrolled campers per day 9 10 7 12 8
Coaching fee per person $ 75 $ 80 $ 80 $ 80 $ 75
Average profit per session $ 135 $ 235 $ 60 $ 390 $ 115
Average profit per camper $ XXXXXXXXXX $ XXXXXXXXXX $ 8.57 $ XXXXXXXXXX $ XXXXXXXXXX
Games
Games
Game Schedule
Baseball Basketball Lacrosse Soccer Volleyball Total
Friday games 0 0 0 0 0 0
Saturday games 0 0 0 0 0 0
Games per week 0 0 0 0 0 0
Games - Profit Analysis
Baseball Basketball Lacrosse Soccer Volleyball Total
Profit per Friday game $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX
Subtotal profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 - 0
Profit per Saturday game $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX 185.00
Subtotal profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 - 0
Total weekly profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Practices
Baseball Basketball Total
Friday practice 0 0 0
Saturday practice 0 0 0
Practices per week 0 0 0
Maximum weekly profit model
Documentation
Shelly Cashman Excel 2019 | Module 4: SAM Project 1
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 Calculato
New House Mortgage Calculato
Loan Payment Calculator Scenarios Bank 1 Bank 2 Bank 3
Date 10/1/21 Rate 4.32% Loan Amount $ - 0 $ - 0 $ 337,500
Property Beecher Street Term in Months 360 Annual Interest Rate 4.40% 4.56% 4.56%
Price $ 350,000 Monthly Payment Monthly Interest Rate 0.37% 0.38% 0.38%
Down Payment $ 35,000 Total Interest Loan Period in Years 30 30 20
Loan Amount Total Cost Loan Period in Months 360 360 240
Start Date 1/5/22 1/5/22 1/5/22
Varying Interest Rates and Terms Monthly Payment $ (1,500) $ (1,500)
Rate Number of Months Future Value $0.00 $1,151,573.10
180 240 360
4.00% Cu
ent 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
Cu
ent Listings
Location Street Type Sq Ft Asking In Budget?
West Beecher Street Single family 2,985 $ 350,000 Yes
West Kenyon Road Single family 2,550 $ 340,000 Yes
East Greenwood Blvd Single family 2,875 $ 365,000 No
Northwest Parkway Avenue Condo 2,468 $ 375,000 No
East Everdale Drive Single family 3,050 $ 370,000 No
Southwest Lacrosse Street Townhouse 2,180 $ 369,000 No
West Holland Lane Single family 3,100 $ 380,000 No
Northeast Bernadine Court Condo 2,395 $ 350,000 Yes
East River Crest Way Townhouse 3,000 $ 367,000 No
Car Loan
Car Loan
Year: 2021
Loan Details Loan Summary
Loan amount $27,500.00 Scheduled payment $619.08
Annual interest rate 3.85% Scheduled number of payments 48
Loan period in years 4 Actual number of payments 13
Number of payments per year 12 Total early payments ERROR:#VALUE!
Start date of loan 2/1/21 Total interest $919.45
Total paid $29,715.83
Optional extra payments $120.00
Pmt No Payment Date Beg Balance Payment Amt Extra Payment Total Payment Principal Interest Ending Balance Cumulative Interest
1 2/1/21 $27,500.00 $619.08 $120.00 $739.08 $650.85 $88.23 $26,849.15 $88.23
2 3/1/21 $26,849.15 $619.08 $120.00 $739.08 $652.94 $86.14 $26,196.21 $174.37
3 4/1/21 $26,196.21 $619.08 $120.00 $739.08 $655.03 $84.05 $25,541.18 $258.42
4 5/1/21 $25,541.18 $619.08 $120.00 $739.08 $657.14 $81.94 $24,884.04 $340.36
5 6/1/21 $24,884.04 $619.08 $120.00 $739.08 $659.24 $79.84 $24,224.80 $420.20
6 7/1/21 $24,224.80 $619.08 $120.00 $739.08 $661.36 $77.72 $23,563.44 $497.92
7 8/1/21 $23,563.44 $619.08 $120.00 $739.08 $663.48 $75.60 $22,899.96 $573.52
8 9/1/21 $22,899.96 $619.08 $120.00 $739.08 $665.61 $73.47 $22,234.35 $646.99
9 10/1/21 $22,234.35 $619.08 $120.00 $739.08 $667.74 $71.34 $21,566.61 $718.32
10 11/1/21 $21,566.61 $619.08 $120.00 $739.08 $669.89 $69.19 $20,896.72 $787.52
11 12/1/21 $20,896.72 $619.08 $120.00 $739.08 $672.04 $67.04 $20,224.68 $854.56
12 1/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 Balance 44228 44256 44287 44317 44348 44378 44409 44440 44470 44501 44531 44562 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX Cumulative Interest 44228 44256 44287 44317 44348 44378 44409 44440 44470 44501 44531 44562 XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX XXXXXXXXXX