THE SMARTMONEY
COLLEGE SAVINGS
WORKSHEET CALCULATOR
Enter data regarding your college cost factors from the tables on the Financial Analysis page.
Use THE TAB Key to move down the worksheet.
Click the Reset Button to run another example.
Expected College Costs
Enter Amount Here (Table 1)
How much have you saved on your own.
Enter Amount Saved Here
How much will your savings be worth when you are ready to enter college. Chose a figure from the Lump-Sum-Multiplier Table 2
Enter Multiplier Here (Table 2)
Value of Savings Calculated Here
What do you expect to receive from family members and other sources before you start college
Enter Expected Amount Here
How close are you to your goal
This Amount is Calculated Here
How much do you still need?
Amount Required is Calculate Here
WHERE DO YOU GO FROM HERE
For this section we assume that you are putting your money in a tax advantaged 529 plan with an annual return of 8 percent. We also assume that that you keep contributing and earning these returns through your sophomore year.
Required Monthly Savings
Enter Divisor (Table 3)
Each month you will need to contribute:
The browser does not support JavaScript. The calculations created using
ExcelEverywhere
will not work. Please access the web page using another browser.