Savings Plan and Future Cost Estimation for Bennington College

Savings Plan and Future Cost Estimation

Estimated Annual Cost in 2040	$204,251
Monthly savings required	$1,617

How much will it cost to send your child to Bennington College in 18 years and how much do you need to save?  A 4 year degree is estimated to be priced at $817,005.56 for students enrolling in 2040 if tuition increases average 5% per year until then.   Assuming you have no current college savings, monthly deposits of $1,616.82 into a 529 or other college savings plan earning and after tax or tax exempt return of 7% will be necessary to achieve this balance.

Assumptions

Current Annual Cost	$78,764.00
Years until enrollment	18
Annual Tuition Increase	5%
Current Savings	$0.00
After Tax Return on Savings	7%
Years of enrollment	4

Current Savings Shortfall

Planned Savings Balance

College Savings Schedule

Month	Begin	Deposit	Withdraw	Interest	End
1	$0.00	$1,616.82	$0.00	$0.00	$1,616.82
2	$1,616.82	$1,616.82	$0.00	$9.14	$3,242.78
3	$3,242.78	$1,616.82	$0.00	$18.34	$4,877.94
4	$4,877.94	$1,616.82	$0.00	$27.58	$6,522.34
5	$6,522.34	$1,616.82	$0.00	$36.88	$8,176.04
6	$8,176.04	$1,616.82	$0.00	$46.23	$9,839.09
7	$9,839.09	$1,616.82	$0.00	$55.63	$11,511.54
8	$11,511.54	$1,616.82	$0.00	$65.09	$13,193.45
9	$13,193.45	$1,616.82	$0.00	$74.60	$14,884.87
10	$14,884.87	$1,616.82	$0.00	$84.16	$16,585.85
11	$16,585.85	$1,616.82	$0.00	$93.78	$18,296.45
12	$18,296.45	$1,616.82	$0.00	$103.45	$20,016.72
13	$20,016.72	$1,616.82	$0.00	$113.18	$21,746.72
14	$21,746.72	$1,616.82	$0.00	$122.96	$23,486.50
15	$23,486.50	$1,616.82	$0.00	$132.80	$25,236.12
16	$25,236.12	$1,616.82	$0.00	$142.69	$26,995.63
17	$26,995.63	$1,616.82	$0.00	$152.64	$28,765.09
18	$28,765.09	$1,616.82	$0.00	$162.64	$30,544.55
19	$30,544.55	$1,616.82	$0.00	$172.70	$32,334.07
20	$32,334.07	$1,616.82	$0.00	$182.82	$34,133.71
21	$34,133.71	$1,616.82	$0.00	$193.00	$35,943.53
22	$35,943.53	$1,616.82	$0.00	$203.23	$37,763.58
23	$37,763.58	$1,616.82	$0.00	$213.52	$39,593.92
24	$39,593.92	$1,616.82	$0.00	$223.87	$41,434.61
25	$41,434.61	$1,616.82	$0.00	$234.28	$43,285.71
26	$43,285.71	$1,616.82	$0.00	$244.74	$45,147.27
27	$45,147.27	$1,616.82	$0.00	$255.27	$47,019.36
28	$47,019.36	$1,616.82	$0.00	$265.85	$48,902.03
29	$48,902.03	$1,616.82	$0.00	$276.50	$50,795.35
30	$50,795.35	$1,616.82	$0.00	$287.20	$52,699.37
31	$52,699.37	$1,616.82	$0.00	$297.97	$54,614.16
32	$54,614.16	$1,616.82	$0.00	$308.80	$56,539.78
33	$56,539.78	$1,616.82	$0.00	$319.68	$58,476.28
34	$58,476.28	$1,616.82	$0.00	$330.63	$60,423.73
35	$60,423.73	$1,616.82	$0.00	$341.64	$62,382.19
36	$62,382.19	$1,616.82	$0.00	$352.72	$64,351.73
37	$64,351.73	$1,616.82	$0.00	$363.85	$66,332.40
38	$66,332.40	$1,616.82	$0.00	$375.05	$68,324.27
39	$68,324.27	$1,616.82	$0.00	$386.32	$70,327.41
40	$70,327.41	$1,616.82	$0.00	$397.64	$72,341.87
41	$72,341.87	$1,616.82	$0.00	$409.03	$74,367.72
42	$74,367.72	$1,616.82	$0.00	$420.49	$76,405.03
43	$76,405.03	$1,616.82	$0.00	$432.01	$78,453.86
44	$78,453.86	$1,616.82	$0.00	$443.59	$80,514.27
45	$80,514.27	$1,616.82	$0.00	$455.24	$82,586.33
46	$82,586.33	$1,616.82	$0.00	$466.96	$84,670.11
47	$84,670.11	$1,616.82	$0.00	$478.74	$86,765.67
48	$86,765.67	$1,616.82	$0.00	$490.59	$88,873.08
49	$88,873.08	$1,616.82	$0.00	$502.50	$90,992.40
50	$90,992.40	$1,616.82	$0.00	$514.48	$93,123.70
51	$93,123.70	$1,616.82	$0.00	$526.53	$95,267.05
52	$95,267.05	$1,616.82	$0.00	$538.65	$97,422.52
53	$97,422.52	$1,616.82	$0.00	$550.84	$99,590.18
54	$99,590.18	$1,616.82	$0.00	$563.10	$101,770.10
55	$101,770.10	$1,616.82	$0.00	$575.42	$103,962.34
56	$103,962.34	$1,616.82	$0.00	$587.82	$106,166.98
57	$106,166.98	$1,616.82	$0.00	$600.28	$108,384.08
58	$108,384.08	$1,616.82	$0.00	$612.82	$110,613.72
59	$110,613.72	$1,616.82	$0.00	$625.43	$112,855.97
60	$112,855.97	$1,616.82	$0.00	$638.10	$115,110.89
61	$115,110.89	$1,616.82	$0.00	$650.85	$117,378.56
62	$117,378.56	$1,616.82	$0.00	$663.68	$119,659.06
63	$119,659.06	$1,616.82	$0.00	$676.57	$121,952.45
64	$121,952.45	$1,616.82	$0.00	$689.54	$124,258.81
65	$124,258.81	$1,616.82	$0.00	$702.58	$126,578.21
66	$126,578.21	$1,616.82	$0.00	$715.69	$128,910.72
67	$128,910.72	$1,616.82	$0.00	$728.88	$131,256.42
68	$131,256.42	$1,616.82	$0.00	$742.14	$133,615.38
69	$133,615.38	$1,616.82	$0.00	$755.48	$135,987.68
70	$135,987.68	$1,616.82	$0.00	$768.89	$138,373.39
71	$138,373.39	$1,616.82	$0.00	$782.38	$140,772.59
72	$140,772.59	$1,616.82	$0.00	$795.95	$143,185.36
73	$143,185.36	$1,616.82	$0.00	$809.59	$145,611.77
74	$145,611.77	$1,616.82	$0.00	$823.31	$148,051.90
75	$148,051.90	$1,616.82	$0.00	$837.11	$150,505.83
76	$150,505.83	$1,616.82	$0.00	$850.98	$152,973.63
77	$152,973.63	$1,616.82	$0.00	$864.94	$155,455.39
78	$155,455.39	$1,616.82	$0.00	$878.97	$157,951.18
79	$157,951.18	$1,616.82	$0.00	$893.08	$160,461.08
80	$160,461.08	$1,616.82	$0.00	$907.27	$162,985.17
81	$162,985.17	$1,616.82	$0.00	$921.54	$165,523.53
82	$165,523.53	$1,616.82	$0.00	$935.89	$168,076.24
83	$168,076.24	$1,616.82	$0.00	$950.33	$170,643.39
84	$170,643.39	$1,616.82	$0.00	$964.84	$173,225.05
85	$173,225.05	$1,616.82	$0.00	$979.44	$175,821.31
86	$175,821.31	$1,616.82	$0.00	$994.12	$178,432.25
87	$178,432.25	$1,616.82	$0.00	$1,008.88	$181,057.95
88	$181,057.95	$1,616.82	$0.00	$1,023.73	$183,698.50
89	$183,698.50	$1,616.82	$0.00	$1,038.66	$186,353.98
90	$186,353.98	$1,616.82	$0.00	$1,053.67	$189,024.47
91	$189,024.47	$1,616.82	$0.00	$1,068.77	$191,710.06
92	$191,710.06	$1,616.82	$0.00	$1,083.96	$194,410.84
93	$194,410.84	$1,616.82	$0.00	$1,099.23	$197,126.89
94	$197,126.89	$1,616.82	$0.00	$1,114.58	$199,858.29
95	$199,858.29	$1,616.82	$0.00	$1,130.03	$202,605.14
96	$202,605.14	$1,616.82	$0.00	$1,145.56	$205,367.52
97	$205,367.52	$1,616.82	$0.00	$1,161.18	$208,145.52
98	$208,145.52	$1,616.82	$0.00	$1,176.89	$210,939.23
99	$210,939.23	$1,616.82	$0.00	$1,192.68	$213,748.73
100	$213,748.73	$1,616.82	$0.00	$1,208.57	$216,574.12
101	$216,574.12	$1,616.82	$0.00	$1,224.54	$219,415.48
102	$219,415.48	$1,616.82	$0.00	$1,240.61	$222,272.91
103	$222,272.91	$1,616.82	$0.00	$1,256.76	$225,146.49
104	$225,146.49	$1,616.82	$0.00	$1,273.01	$228,036.32
105	$228,036.32	$1,616.82	$0.00	$1,289.35	$230,942.49
106	$230,942.49	$1,616.82	$0.00	$1,305.78	$233,865.09
107	$233,865.09	$1,616.82	$0.00	$1,322.31	$236,804.22
108	$236,804.22	$1,616.82	$0.00	$1,338.93	$239,759.97
109	$239,759.97	$1,616.82	$0.00	$1,355.64	$242,732.43
110	$242,732.43	$1,616.82	$0.00	$1,372.44	$245,721.69
111	$245,721.69	$1,616.82	$0.00	$1,389.35	$248,727.86
112	$248,727.86	$1,616.82	$0.00	$1,406.34	$251,751.02
113	$251,751.02	$1,616.82	$0.00	$1,423.44	$254,791.28
114	$254,791.28	$1,616.82	$0.00	$1,440.63	$257,848.73
115	$257,848.73	$1,616.82	$0.00	$1,457.91	$260,923.46
116	$260,923.46	$1,616.82	$0.00	$1,475.30	$264,015.58
117	$264,015.58	$1,616.82	$0.00	$1,492.78	$267,125.18
118	$267,125.18	$1,616.82	$0.00	$1,510.36	$270,252.36
119	$270,252.36	$1,616.82	$0.00	$1,528.05	$273,397.23
120	$273,397.23	$1,616.82	$0.00	$1,545.83	$276,559.88
121	$276,559.88	$1,616.82	$0.00	$1,563.71	$279,740.41
122	$279,740.41	$1,616.82	$0.00	$1,581.69	$282,938.92
123	$282,938.92	$1,616.82	$0.00	$1,599.78	$286,155.52
124	$286,155.52	$1,616.82	$0.00	$1,617.96	$289,390.30
125	$289,390.30	$1,616.82	$0.00	$1,636.25	$292,643.37
126	$292,643.37	$1,616.82	$0.00	$1,654.65	$295,914.84
127	$295,914.84	$1,616.82	$0.00	$1,673.15	$299,204.81
128	$299,204.81	$1,616.82	$0.00	$1,691.75	$302,513.38
129	$302,513.38	$1,616.82	$0.00	$1,710.45	$305,840.65
130	$305,840.65	$1,616.82	$0.00	$1,729.27	$309,186.74
131	$309,186.74	$1,616.82	$0.00	$1,748.19	$312,551.75
132	$312,551.75	$1,616.82	$0.00	$1,767.21	$315,935.78
133	$315,935.78	$1,616.82	$0.00	$1,786.35	$319,338.95
134	$319,338.95	$1,616.82	$0.00	$1,805.59	$322,761.36
135	$322,761.36	$1,616.82	$0.00	$1,824.94	$326,203.12
136	$326,203.12	$1,616.82	$0.00	$1,844.40	$329,664.34
137	$329,664.34	$1,616.82	$0.00	$1,863.97	$333,145.13
138	$333,145.13	$1,616.82	$0.00	$1,883.65	$336,645.60
139	$336,645.60	$1,616.82	$0.00	$1,903.44	$340,165.86
140	$340,165.86	$1,616.82	$0.00	$1,923.35	$343,706.03
141	$343,706.03	$1,616.82	$0.00	$1,943.36	$347,266.21
142	$347,266.21	$1,616.82	$0.00	$1,963.49	$350,846.52
143	$350,846.52	$1,616.82	$0.00	$1,983.74	$354,447.08
144	$354,447.08	$1,616.82	$0.00	$2,004.10	$358,068.00
145	$358,068.00	$1,616.82	$0.00	$2,024.57	$361,709.39
146	$361,709.39	$1,616.82	$0.00	$2,045.16	$365,371.37
147	$365,371.37	$1,616.82	$0.00	$2,065.86	$369,054.05
148	$369,054.05	$1,616.82	$0.00	$2,086.69	$372,757.56
149	$372,757.56	$1,616.82	$0.00	$2,107.63	$376,482.01
150	$376,482.01	$1,616.82	$0.00	$2,128.68	$380,227.51
151	$380,227.51	$1,616.82	$0.00	$2,149.86	$383,994.19
152	$383,994.19	$1,616.82	$0.00	$2,171.16	$387,782.17
153	$387,782.17	$1,616.82	$0.00	$2,192.58	$391,591.57
154	$391,591.57	$1,616.82	$0.00	$2,214.12	$395,422.51
155	$395,422.51	$1,616.82	$0.00	$2,235.78	$399,275.11
156	$399,275.11	$1,616.82	$0.00	$2,257.56	$403,149.49
157	$403,149.49	$1,616.82	$0.00	$2,279.47	$407,045.78
158	$407,045.78	$1,616.82	$0.00	$2,301.50	$410,964.10
159	$410,964.10	$1,616.82	$0.00	$2,323.65	$414,904.57
160	$414,904.57	$1,616.82	$0.00	$2,345.93	$418,867.32
161	$418,867.32	$1,616.82	$0.00	$2,368.34	$422,852.48
162	$422,852.48	$1,616.82	$0.00	$2,390.87	$426,860.17
163	$426,860.17	$1,616.82	$0.00	$2,413.53	$430,890.52
164	$430,890.52	$1,616.82	$0.00	$2,436.32	$434,943.66
165	$434,943.66	$1,616.82	$0.00	$2,459.23	$439,019.71
166	$439,019.71	$1,616.82	$0.00	$2,482.28	$443,118.81
167	$443,118.81	$1,616.82	$0.00	$2,505.46	$447,241.09
168	$447,241.09	$1,616.82	$0.00	$2,528.77	$451,386.68
169	$451,386.68	$1,616.82	$0.00	$2,552.21	$455,555.71
170	$455,555.71	$1,616.82	$0.00	$2,575.78	$459,748.31
171	$459,748.31	$1,616.82	$0.00	$2,599.48	$463,964.61
172	$463,964.61	$1,616.82	$0.00	$2,623.32	$468,204.75
173	$468,204.75	$1,616.82	$0.00	$2,647.30	$472,468.87
174	$472,468.87	$1,616.82	$0.00	$2,671.41	$476,757.10
175	$476,757.10	$1,616.82	$0.00	$2,695.65	$481,069.57
176	$481,069.57	$1,616.82	$0.00	$2,720.04	$485,406.43
177	$485,406.43	$1,616.82	$0.00	$2,744.56	$489,767.81
178	$489,767.81	$1,616.82	$0.00	$2,769.22	$494,153.85
179	$494,153.85	$1,616.82	$0.00	$2,794.02	$498,564.69
180	$498,564.69	$1,616.82	$0.00	$2,818.96	$503,000.47
181	$503,000.47	$1,616.82	$0.00	$2,844.04	$507,461.33
182	$507,461.33	$1,616.82	$0.00	$2,869.26	$511,947.41
183	$511,947.41	$1,616.82	$0.00	$2,894.63	$516,458.86
184	$516,458.86	$1,616.82	$0.00	$2,920.13	$520,995.81
185	$520,995.81	$1,616.82	$0.00	$2,945.79	$525,558.42
186	$525,558.42	$1,616.82	$0.00	$2,971.58	$530,146.82
187	$530,146.82	$1,616.82	$0.00	$2,997.53	$534,761.17
188	$534,761.17	$1,616.82	$0.00	$3,023.62	$539,401.61
189	$539,401.61	$1,616.82	$0.00	$3,049.86	$544,068.29
190	$544,068.29	$1,616.82	$0.00	$3,076.24	$548,761.35
191	$548,761.35	$1,616.82	$0.00	$3,102.78	$553,480.95
192	$553,480.95	$1,616.82	$0.00	$3,129.46	$558,227.23
193	$558,227.23	$1,616.82	$0.00	$3,156.30	$563,000.35
194	$563,000.35	$1,616.82	$0.00	$3,183.29	$567,800.46
195	$567,800.46	$1,616.82	$0.00	$3,210.43	$572,627.71
196	$572,627.71	$1,616.82	$0.00	$3,237.72	$577,482.25
197	$577,482.25	$1,616.82	$0.00	$3,265.17	$582,364.24
198	$582,364.24	$1,616.82	$0.00	$3,292.77	$587,273.83
199	$587,273.83	$1,616.82	$0.00	$3,320.53	$592,211.18
200	$592,211.18	$1,616.82	$0.00	$3,348.45	$597,176.45
201	$597,176.45	$1,616.82	$0.00	$3,376.52	$602,169.79
202	$602,169.79	$1,616.82	$0.00	$3,404.76	$607,191.37
203	$607,191.37	$1,616.82	$0.00	$3,433.15	$612,241.34
204	$612,241.34	$1,616.82	$0.00	$3,461.70	$617,319.86
205	$617,319.86	$1,616.82	$0.00	$3,490.42	$622,427.10
206	$622,427.10	$1,616.82	$0.00	$3,519.29	$627,563.21
207	$627,563.21	$1,616.82	$0.00	$3,548.33	$632,728.36
208	$632,728.36	$1,616.82	$0.00	$3,577.54	$637,922.72
209	$637,922.72	$1,616.82	$0.00	$3,606.91	$643,146.45
210	$643,146.45	$1,616.82	$0.00	$3,636.44	$648,399.71
211	$648,399.71	$1,616.82	$0.00	$3,666.15	$653,682.68
212	$653,682.68	$1,616.82	$0.00	$3,696.02	$658,995.52
213	$658,995.52	$1,616.82	$0.00	$3,726.06	$664,338.40
214	$664,338.40	$1,616.82	$0.00	$3,756.27	$669,711.49
215	$669,711.49	$1,616.82	$0.00	$3,786.65	$675,114.96
216	$675,114.96	$1,616.82	$0.00	$3,817.20	$680,548.98
217	$680,548.98	$1,616.82	$189,554.96	$3,847.92	$496,458.76
218	$496,458.76	$1,616.82	$0.00	$2,807.05	$500,882.63
219	$500,882.63	$1,616.82	$0.00	$2,832.06	$505,331.51
220	$505,331.51	$1,616.82	$0.00	$2,857.22	$509,805.55
221	$509,805.55	$1,616.82	$0.00	$2,882.51	$514,304.88
222	$514,304.88	$1,616.82	$0.00	$2,907.95	$518,829.65
223	$518,829.65	$1,616.82	$0.00	$2,933.54	$523,380.01
224	$523,380.01	$1,616.82	$0.00	$2,959.27	$527,956.10
225	$527,956.10	$1,616.82	$0.00	$2,985.14	$532,558.06
226	$532,558.06	$1,616.82	$0.00	$3,011.16	$537,186.04
227	$537,186.04	$1,616.82	$0.00	$3,037.33	$541,840.19
228	$541,840.19	$1,616.82	$0.00	$3,063.64	$546,520.65
229	$546,520.65	$1,616.82	$199,032.71	$3,090.11	$352,194.87
230	$352,194.87	$1,616.82	$0.00	$1,991.36	$355,803.05
231	$355,803.05	$1,616.82	$0.00	$2,011.76	$359,431.63
232	$359,431.63	$1,616.82	$0.00	$2,032.28	$363,080.73
233	$363,080.73	$1,616.82	$0.00	$2,052.91	$366,750.46
234	$366,750.46	$1,616.82	$0.00	$2,073.66	$370,440.94
235	$370,440.94	$1,616.82	$0.00	$2,094.53	$374,152.29
236	$374,152.29	$1,616.82	$0.00	$2,115.51	$377,884.62
237	$377,884.62	$1,616.82	$0.00	$2,136.61	$381,638.05
238	$381,638.05	$1,616.82	$0.00	$2,157.84	$385,412.71
239	$385,412.71	$1,616.82	$0.00	$2,179.18	$389,208.71
240	$389,208.71	$1,616.82	$0.00	$2,200.64	$393,026.17
241	$393,026.17	$1,616.82	$208,984.34	$2,222.23	$187,880.88
242	$187,880.88	$1,616.82	$0.00	$1,062.31	$190,560.01
243	$190,560.01	$1,616.82	$0.00	$1,077.45	$193,254.28
244	$193,254.28	$1,616.82	$0.00	$1,092.69	$195,963.79
245	$195,963.79	$1,616.82	$0.00	$1,108.01	$198,688.62
246	$198,688.62	$1,616.82	$0.00	$1,123.41	$201,428.85
247	$201,428.85	$1,616.82	$0.00	$1,138.91	$204,184.58
248	$204,184.58	$1,616.82	$0.00	$1,154.49	$206,955.89
249	$206,955.89	$1,616.82	$0.00	$1,170.16	$209,742.87
250	$209,742.87	$1,616.82	$0.00	$1,185.92	$212,545.61
251	$212,545.61	$1,616.82	$0.00	$1,201.76	$215,364.19
252	$215,364.19	$1,616.82	$0.00	$1,217.70	$218,198.71
253	$218,198.71	$0.00	$219,433.56	$1,233.73	($1.12)