Excel Spreadsheet

College Savings

You must be logged in to download this document
Reviews
Shared by: cindyrella perillo
Stats
views:
278
downloads:
13
rating:
not rated
reviews:
0
posted:
1/21/2008
language:
English
pages:
0
Years Before Child Begins College: 13.0 Your Savings Contribution per Month: 250.00 $ Current Balance of Any College Savings: 1,302.00 $ Expected Annual Investment Return (After Taxes, Fees, etc.): 4.00% Cost of College Today, per Year: 6,000.00 $ Expected Inflation Rate for College Expenses: 6.00% … And 13 Years From Now: Cost of Year #1 of College: $12,798 Cost of Year #2 of College: $13,565 Cost of Year #3 of College: $14,379 Cost of Year #4 of College: $15,242 Total Cost of 4 Years of College: $55,984 Your Total Contributions to Savings (w/out Interest): $40,302 Estimated Total Savings in 13 Years (w/Interest): $53,231 College Savings Estimator NOTE: The figures shown in this spreadsheet are meant as rough estimates only. You should consuul with a qualified professional before making any financial decisions based on this data.spreadsheet are only. You should consuul professional before making any financial SAVINGS YOUR YEAR STARTING ANNUAL ACCOUNT COLLEGE YEAR YEAR # BALANCE CONTRIBUTIONS EARNINGS PAID END BALANCE 2008 1 1,302.00 $ 3,000.00 $ 172.08 $ -$ 4,474.08 $ 2009 2 4,474.08 $ 3,000.00 $ 298.96 $ -$ 7,773.04 $ 2010 3 7,773.04 $ 3,000.00 $ 430.92 $ -$ 11,203.96 $ 2011 4 11,203.96 $ 3,000.00 $ 568.16 $ -$ 14,772.12 $ 2012 5 14,772.12 $ 3,000.00 $ 710.88 $ -$ 18,483.01 $ 2013 6 18,483.01 $ 3,000.00 $ 859.32 $ -$ 22,342.33 $ 2014 7 22,342.33 $ 3,000.00 $ 1,013.69 $ -$ 26,356.02 $ 2015 8 26,356.02 $ 3,000.00 $ 1,174.24 $ -$ 30,530.26 $ 2016 9 30,530.26 $ 3,000.00 $ 1,341.21 $ -$ 34,871.47 $ 2017 10 34,871.47 $ 3,000.00 $ 1,514.86 $ -$ 39,386.33 $ 2018 11 39,386.33 $ 3,000.00 $ 1,695.45 $ -$ 44,081.79 $ 2019 12 44,081.79 $ 3,000.00 $ 1,883.27 $ -$ 48,965.06 $ 2020 13 48,965.06 $ 3,000.00 $ 2,078.60 $ -$ 54,043.66 $ 2021 14 54,043.66 $ 3,000.00 $ 1,769.84 $ 12,797.57 $ 46,015.93 $ 2022 15 46,015.93 $ 3,000.00 $ 1,418.02 $ 13,565.42 $ 36,868.53 $ 2023 16 36,868.53 $ 3,000.00 $ 1,019.57 $ 14,379.35 $ 26,508.75 $ 2024 17 26,508.75 $ 3,000.00 $ 570.67 $ 15,242.11 $ 14,837.30 $ 2025 18 14,837.30 $ 3,000.00 $ 67.23 $ 16,156.64 $ 1,747.89 $ COLLEGE SAVINGS: Estimated Annual Cashflow ChartCollege Year #1 College Year #2 College Year #3 College Year #4 College Year #5
Related docs
Other docs by cindyrella per...
processing pears budget calculator
Views: 334  |  Downloads: 17
pears farm bosc enterprise budget calculator
Views: 251  |  Downloads: 0
Computational Corporate Finance Calculations
Views: 473  |  Downloads: 51
wheat ORGANIC ENTERPRISE BUDGET
Views: 364  |  Downloads: 2
vidal grape farm enterprise budget calculator
Views: 277  |  Downloads: 3
The Building Rent Calculator
Views: 552  |  Downloads: 21
swine farm enterprise budget calculator
Views: 353  |  Downloads: 7
sweetcorn farm enterprise budget calculator
Views: 295  |  Downloads: 0