Advisor Version Education Planners – Version 2005.01c

All data entry cell characters are shown in dark red.

The Advisor Version contains three education planners. The first education spreadsheet that is intended to allow the user to illustrate educational costs for an individual child. The other two spreadsheets will allow you to enter up to four children at a time.

Data Entry:

Student’s Name : Enter the student’s name .

Student’s Birthdate : Enter the student’s date of birth.

Month of year in which school starts : This entry is for the purpose of establishing the point in each year at which you wish to have funds available for educational expenses at beginning of each academic school year. Most education institutions begin in August, so it is likely that you will typically enter 8 (for August) in this cell. This value will be transposed to the other columns for the multi-child education worksheets so all columns use the same start month point of reference.

Year in which school starts : Enter the start year of the student’s school experience. You can enter a separate start year for all columns on the worksheet. In the case where a student in already in school, you will simply enter the year of the beginning of the next academic year.

Years of School : Enter the number of academic years for which you are planning.

Systematic Saving Through What Date : Enter the date through which you expect the saving contributions to be made.

Inflation Assumption : Enter the assumed inflation rate of education costs.

Investment Earning Assumption : Enter the assumed investment earning assumption.

Annual Education Costs (Today’s Dollars) : Enter in today’s dollars the total cost of one academic year.

Current Savings Balance Allocated to Goal : Enter any savings currently allocated for educational costs for each respective child.

The model then calculates the monthly savings needed to achieve the goal, as well as what lump sum in addition to the current savings would satisfy the savings need. Annual education costs in future dollars are displayed in the bottom section of the worksheet.