| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | ||||||||
2 | ||||||||
3 | COLLEGE TUITION COMPARISION SPREADSHEET | |||||||
4 | INSTRUCTIONS: | |||||||
5 | 1. Click on the File Tab above. | |||||||
6 | 2. Click "Make A Copy" from the dropdown menu. | |||||||
7 | 3. Rename the document and choose a folder in which to save your copy. | |||||||
8 | 4. Follow the instructions below. | |||||||
9 | ||||||||
10 | ||||||||
11 | Example | Institution #1 | Institution #2 | Institution #3 | Institution #4 | |||
12 | 1. Enter School Name Here—> | Central State | Michigan | K College | Albion | MSU | ||
13 | 2. Total Estimated Annual Tuition (Use a negative/minus "-" sign) | -$5,000 | -$14,973 | -$46,840 | -$43,048 | -$14,063 | ||
14 | 3. Total Estimated Annual Room and Board (Use a negative/minus "-" sign) | -$10,000 | -$14,874 | -$10,640 | -$13,428 | -$13,178 | ||
15 | 4. Total Estimated Annual Travel (flights home, etc) (Use a negative "-" sign) | -$1,000 | $0 | $0 | $0 | $0 | ||
16 | 5. Number of years you will enroll in school. | 4 | 5 | 4 | 4 | 4 | ||
17 | Total Estimated Costs | -$64,000 | -$149,235 | -$229,920 | -$225,904 | -$108,964 | ||
18 | ||||||||
19 | 6. Amount Received in Scholarships Over Entirety of Degree | $15,000 | $62,870 | $153,320 | $151,320 | $0 | ||
20 | 7. Total Amount You Can Pay Out of Pocket Over Entirety of Degree | $10,000 | $80,892 | $75,000 | $75,000 | $76,252 | ||
21 | ||||||||
22 | Amount Taken out in Loans (Automatically Filled In) | $39,000 | $5,473 | $1,600 | -$416 | $32,712 | ||
23 | 8. Interest Rate | 8.00% | 5.00% | 5.00% | 5.00% | |||
24 | 9. Length of Loan In Months (Enter 10-30 years) | 48 | 120 | 120 | 120 | |||
25 | Length of Loan in Years (Automatically Filled In) | 4 | 10 | 10 | 0 | 10 | ||
26 | Minimum Monthly Payment (Automatically Filled In) | $952 | $58 | $17 | #NUM! | $347 | ||
27 | ||||||||
28 | Total Interest Paid | $6,701 | $1,493 | $436 | $0 | $8,923 | ||
29 | TOTAL AMOUNT YOU WILL LIKELY PAY | $45,701 | $6,966 | $2,036 | -$416 | $41,635 | ||
30 | ||||||||
31 | ||||||||