Please fill all required fields
[This is to test whether you are a human visitor and to prevent automated spam submissions.]
Enter the Number as displayed below
Education Equal Installments
Education Growing Savings
Inputs in
blue
Commentary
Child 1
Child 2
Current Age (Yrs)
Use the current age rounded up to a whole number
Age when education starts (Yrs)
Age when education ends (Years)
Current annual price of the education
The price today for the education you are looking at.
Children education money already saved
Money already saved for education.
School Fees Inflation
The rate of inflation in your country (5% here as an example but change it)
Return above school inflation
A return you expect your investments to deliver (to be conservative keep below 3%). Use a negative number if you think school inflation is higher then returns
Total return
Conclusion
Savings required
Annual
Monthly
The money you need to put away now to ensure that you will be able to fund the education by contributing the same amount every month of their education life
Total savings required
Now go to the next tab and see what is required if you are willing to increase your savings amount each year
Child 1
Child 2
Combined
Inflation Factor
Year
Years from now
Age Child
School Fees to pay
PV of school fees
Annual savings till end of education
Savings Open Balance
Annual Savings
Education Exp
Interest/ Earnings
Closing Balance
Age Child
School Fees to pay
PV of school fees
Annual savings till end of education
Savings Open Balance
Annual Savings
Education Exp
Interest/ Earnings
Closing Balance
Savings Open Balance
Annual Savings
Education Exp
Interest/ Earnings
Closing Balance
1.00
0
Inputs in light blue
Commentary
Child 1
Child 2
Current Age (Yrs)
From the previous tab
Age when education starts (Yrs)
From the previous tab
Age when education ends (Years)
From the previous tab
Current annual price of the education
From the previous tab
Children education money already saved
From the previous tab
School Fees Inflation
From the previous tab
Return above school inflation
From the previous tab
Total return
Escalation on savings per year
How much you will increase your savings by each year
Conclusion
Savings required
Annual
Monthly
Total savings per year
Change the annual number as see what the results below shows. Start with the Equal Installments number shown below and reduce it from there (with a spreadsheet you can goalseek this).
Minimum on the savings account
Change escalation or annual savings above until you get this number as close to zero as possible
Remaining in investments at end
Depending on your profile you may actually have a positive balance, perhaps for a wedding?
Summary Results:
Equal Installment Savings
Minimum
At End of education
Total
Child 1
Child 2
Inflation Factor
Year
years from now
Savings Open Balance
Annual Savings
Education Exp
Interest/ Earnings
Closing Balance
Age Child
School Fees to pay
PV of school fees
Age Child
School Fees to pay
PV of school fees
1.00
0
The browser does not support JavaScript. The calculations created using
SpreadsheetConverter
will not work. Please access the web page using another browser.