Years Before Child Begins College: Your Savings Contribution per Month: Current Balance of Any College Savings: Expected Annual Investment Return (After Taxes, Fees, etc.): Cost of College Today, per Year: Expected Inflation Rate for College Expenses: … And 13 Years From Now: Cost of Year #1 of College: Cost of Year #2 of College: Cost of Year #3 of College: Cost of Year #4 of College: Total Cost of 4 Years of College: Your Total Contributions to Savings (w/out Interest): Estimated Total Savings in 13 Years (w/Interest):
$ $
13.0 250.00 1,302.00 4.00% 6,000.00 6.00%
$
$12,798 $13,565 $14,379 $15,242 $55,984 $40,302 $53,231
NOTE: The figures shown in this spreadsheet are meant as rough estimates only. You should consult with a qualified professional before making any financial decisions based on this data.
making any financial
COLLEGE SAVINGS:
Estimated Annual Cashflow Chart
YEAR # 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 SAVINGS STARTING BALANCE 1,302.00 4,474.08 7,773.04 11,203.96 14,772.12 18,483.01 22,342.33 26,356.02 30,530.26 34,871.47 39,386.33 44,081.79 48,965.06 54,043.66 46,015.93 36,868.53 26,508.75 14,837.30 YOUR ANNUAL CONTRIBUTIONS $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 ACCOUNT EARNINGS $ 172.08 $ 298.96 $ 430.92 $ 568.16 $ 710.88 $ 859.32 $ 1,013.69 $ 1,174.24 $ 1,341.21 $ 1,514.86 $ 1,695.45 $ 1,883.27 $ 2,078.60 $ 1,769.84 $ 1,418.02 $ 1,019.57 $ 570.67 $ 67.23 COLLEGE PAID $ $ $ $ $ $ $ $ $ $ $ $ $ $ 12,797.57 $ 13,565.42 $ 14,379.35 $ 15,242.11 $ 16,156.64 YEAR END BALANCE $ 4,474.08 $ 7,773.04 $ 11,203.96 $ 14,772.12 $ 18,483.01 $ 22,342.33 $ 26,356.02 $ 30,530.26 $ 34,871.47 $ 39,386.33 $ 44,081.79 $ 48,965.06 $ 54,043.66 $ 46,015.93 $ 36,868.53 $ 26,508.75 $ 14,837.30 $ 1,747.89
YEAR 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
College Year #1 College Year #2 College Year #3 College Year #4 College Year #5