ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
College-input colleges in cellsABCDEFGHI
2
Current Cost of College$10,000.00$20,000.00$30,000.00$40,000.00$50,000.00$60,000.00$70,000.00$80,000.00$90,000.00
3
Annual Rate of Increase in Tuition3%3%3%3%3%3%3%3%3%
4
Years until college222222222
5
Loan Rate5%5%5%5%5%6%5%5%5%
6
Fin Aid/Contribution before loan$5,000$5,000$5,000$5,000$5,000$5,000$5,000$5,000$5,000
7
8
Do not change cells below this line
9
Yearly Cost
10
Cost in year 1$11,025.00$22,050.00$33,075.00$44,100.00$55,125.00$67,416.00$77,175.00$88,200.00$99,225.00
11
Cost in year 2$11,576.25$23,152.50$34,728.75$46,305.00$57,881.25$71,460.96$81,033.75$92,610.00$104,186.25
12
Cost in year 3$12,155.06$24,310.13$36,465.19$48,620.25$60,775.31$75,748.62$85,085.44$97,240.50$109,395.56
13
Cost in year 4$12,762.82$25,525.63$38,288.45$51,051.26$63,814.08$80,293.53$89,339.71$102,102.53$114,865.34
14
15
Total Cost over 4 years$47,519.13$95,038.26$142,557.38$190,076.51$237,595.64$294,919.11$332,633.90$380,153.03$427,672.15
16
17
Monthly Payments
18
Loan payment for 5 years$802.39$1,699.13$2,595.88$3,492.62$4,389.37$5,604.95$6,182.86$7,079.60$7,976.34
19
Loan payment for 10 years$450.98$955.00$1,459.01$1,963.02$2,467.04$3,218.70$3,475.07$3,979.08$4,483.09
20
Loan payment for 15 years$336.24$712.02$1,087.80$1,463.57$1,839.35$2,446.50$2,590.91$2,966.69$3,342.46
21
Loan payment for 20 years$280.61$594.21$907.82$1,221.42$1,535.03$2,077.07$2,162.24$2,475.84$2,789.45
22
Loan payment for 25 years$248.56$526.35$804.15$1,081.94$1,359.73$1,867.95$1,915.32$2,193.11$2,470.90
23
Loan payment for 30 years$228.25$483.34$738.44$993.53$1,248.62$1,738.21$1,758.81$2,013.90$2,269.00
24
25
Total Cost of Loan Parments
26
Total cost for loan over 5 years$48,143.30$101,947.98$155,752.65$209,557.33$263,362.00$336,296.92$370,971.35$424,776.02$478,580.70
27
Total cost for loan over 10 years$54,117.76$114,599.45$175,081.14$235,562.83$296,044.52$386,243.58$417,007.90$477,489.59$537,971.28
28
Total cost for loan over 15 years$60,522.94$128,163.02$195,803.11$263,443.19$331,083.27$440,370.40$466,363.44$534,003.52$601,643.60
29
Total cost for loan over 20 years$67,345.78$142,611.03$217,876.28$293,141.54$368,406.79$498,496.94$518,937.29$594,202.54$669,467.79
30
Total cost for loan over 25 years$74,568.78$157,906.40$241,244.03$324,581.66$407,919.29$560,385.87$574,594.54$657,932.17$741,269.79
31
Total cost for loan over 30 years$82,170.67$174,004.14$265,837.60$357,671.07$449,504.53$625,756.16$633,171.46$725,004.92$816,838.38
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100