College Savings Calculator

Name Child's Name

Totals as of Year …
Current Age of Child 2 Total Costs
Initial Savings 1,000.00 Total Interest Earned
Annual Interest Rate 0.00% Total Invested

Scheduled Deposits Solving For Zero

Years to Make Deposits 8 Year of Last Payment
Deposit Amount 100.00 Last Payment
Deposit Frequency Monthly Prior Year Balance
Additional Annual Deposits 0.00 NET

$10,000 End-of-Year Balance

$5,000 Frequency Periods
Annually 1
$-
- - Pre K
Semi-Annually
1 2 3 4 5 6 7 8
29 10 11 12 C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 -
$(5,000) Quarterly 4
Bi-Monthly 6
$(10,000)
Monthly 12
$(15,000) Semi-Monthly 24
Bi-Weekly 26
$(20,000)
Weekly 52
$(25,000) Daily 365
Grade
Yearly Schedule
School Costs This Interest Scheduled Extra Annual
Year Age Year Year Earned Deposits Deposits
1 2 - 0.00 1,200.00
2 3 - 150.00 0.00 1,200.00
3 4 Pre 150.00 0.00 1,200.00
4 5 K 150.00 0.00 1,200.00
5 6 1 150.00 0.00 1,200.00
6 7 2 400.00 0.00 1,200.00
7 8 3 500.00 0.00 1,200.00
8 9 4 1,000.00 0.00 1,200.00
9 10 5 1,000.00 0.00 0.00
10 11 6 1,000.00 0.00 0.00
11 12 7 2,000.00 0.00 0.00
12 13 8 6,000.00 0.00 0.00
13 14 9 6,500.00 0.00 0.00
14 15 10 7,000.00 0.00 0.00
15 16 11 7,500.00 0.00 0.00
16 17 12 0.00 0.00
17 18 C-1 0.00 0.00
18 19 C-2 0.00 0.00
19 20 C-3 0.00 0.00
20 21 C-4 0.00 0.00
21 22 C-5 0.00 0.00
22 23 C-6 0.00 0.00
23 24 C-7 0.00 0.00
24 25 C-8 0.00 0.00
25 26 - 0.00 0.00
 15
$ 33,500.00
$ -
$ 10,600.00

Solving For Zero Balance

15
$ 7,500.00
$ (15,400.00)
$ (22,900.00)

6 7 8 9 10 11 12 C-1 C-2 C-3 C-4 C-5 C-6 C-7 C-8 -

Grade

End of Year
Balance
2,200.00
3,250.00
4,300.00
5,350.00
6,400.00
7,200.00
7,900.00
8,100.00
7,100.00
6,100.00
4,100.00
(1,900.00)
(8,400.00)
(15,400.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
(22,900.00)
HELP

Instructions For Using This Template

structions For Using This Template
For this school and college savings calculator, consider year t as starting at the beginning of the
school year (in August for example). The child's age should correspond with the start of the school
year.

Enter the Total Costs for the specified School Year in the Yearly Schedule (yellow colored cells).
These are assumed to be withdrawals taken at the beginning of the year.

Enter any extra annual deposits you may be planning either as regular scheduled annual deposits or
manually in the Yearly Schedule. Annual deposits are applied at the end of the year.

Enter the number of Years to Make Deposits, the Deposit Amount and the Deposit Frequency.

Taxes on interest earned are not taken into account, so use an after-tax annual interest rate.

You can make a copy of this worksheet for creating savings plan for other children or saving an
example of a particular plan. Look up how to Copy a Worksheet in the Help system.

The calculator is initially set up to calculate the Deposit Amount automatically. However, if you know
the deposit amount but want to solve for some other input value, then enter your deposit amount and
then use Goal Seek or Solver to set the NET value to Zero by changing one of the other inputs.