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
 
    
 
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
   
Powered By SpreadsheetConverter