Child Education Goal Calculator

Higher education costs rise every year, so the amount you need is much more than the fee today. A ₹25 lakh course, with costs rising 8% a year, will cost ₹67,99,059 in 13 years. To meet that at an assumed 12% return, a child who is 5 today needs a SIP of ₹18,086 a month, starting now. Enter your own child’s age, the cost today and what you have saved below. These are projections based on assumptions that you can change, not guaranteed results.

Monthly SIP needed (year 1)₹18,086
Cost of the education in 13 years₹67,99,059
Your current savings, grown₹0
Amount still to build₹67,99,059
Total you invest through the SIP₹28,21,416
  1. Cost in 13 years = ₹25,00,000 × (1 + 8 ÷ 100)^13 = ₹67,99,059
  2. Savings grown = ₹0 × (1 + 12 ÷ 100)^13 = ₹0
  3. Amount to build = ₹67,99,059 − ₹0 = ₹67,99,059; SIP of ₹18,086 a month at 12% reaches ₹67,99,091
How the goal is met
  • Your SIP contributions: ₹28,21,416 (41.5%)
  • Growth on the SIP: ₹39,77,675 (58.5%)
Year-by-year plan (education cost rising 8% a year, returns 12% a year)
Child’s ageMonthly SIPTotal investedFund value at year end
Age 6₹18,086₹2,17,032₹2,31,670
Age 7₹18,086₹4,34,064₹4,92,721
Age 8₹18,086₹6,51,096₹7,86,879
Age 9₹18,086₹8,68,128₹11,18,345
Age 10₹18,086₹10,85,160₹14,91,848
Age 11₹18,086₹13,02,192₹19,12,722
Age 12₹18,086₹15,19,224₹23,86,972
Age 13₹18,086₹17,36,256₹29,21,369
Age 14₹18,086₹19,53,288₹35,23,542
Age 15₹18,086₹21,70,320₹42,02,085
Age 16₹18,086₹23,87,352₹49,66,684
Age 17₹18,086₹26,04,384₹58,28,253
Age 18₹18,086₹28,21,416₹67,99,091

Read the guide: Child Education Planning in India: How Much SIP Do You Need and When to Start?

How to use the child education goal calculator

  1. Enter your child’s age and the age at which the money will be needed.
  2. Enter what the course would cost if your child started today, including fees and living costs.
  3. Enter how fast you think education costs will rise and the return you expect on your investment. Try a few values to see the range.
  4. Enter any savings you already have for this goal, and a yearly raise if you plan to increase your SIP. Read the SIP you need and the year-by-year plan.

Formula

Future cost = Cost today × (1 + education inflation ÷ 100)years

Savings grown = Current savings × (1 + return ÷ 100)years

Amount to build = Future cost − Savings grown

The SIP is paid at the start of each month and earns the monthly return (yearly return ÷ 12). If you choose a yearly raise, the SIP goes up by that percentage each year. The calculator finds the starting SIP whose value at the goal date equals the amount to build, and rounds it up to the next rupee.

Worked examples

A ₹25 lakh course, child aged 5

With 8% education inflation, the course costs ₹67,99,059 in 13 years. At a 12% return, you need a SIP of ₹18,086 a month and invest ₹28,21,416 in total.

Savings already in hand

If you already have ₹2,00,000 set aside, it grows to ₹8,72,699 by the goal date. The amount left to build drops to ₹59,26,361 and the SIP falls to ₹15,765 a month.

Raising the SIP 10% every year

A SIP that rises 10% a year can start at only ₹11,213 a month and still reach the same goal. You invest more in total, ₹32,99,700, but the first years are easier.

Higher education inflation

If costs rise 10% a year instead of 8%, the same course costs ₹86,30,678 and the SIP needed rises to ₹22,959 a month. The inflation you assume matters a lot.

Starting later

For a ₹15 lakh course with a child aged 10, the cost in 8 years is ₹27,76,395 and the SIP needed is ₹17,189 a month. A shorter time means a higher SIP for a smaller goal.

Common mistakes to avoid

  • Using today’s fee as the goal. Education costs rise every year, so the future amount is far higher.
  • Assuming a high return will definitely happen. Equity returns are not guaranteed, so test a lower return and keep a buffer.
  • Waiting. Every year you delay raises the SIP you need and reduces what compounding can do.
  • Keeping money for a goal less than 3 to 5 years away fully in equity. Move it into safer options as the date gets close.
  • Forgetting other costs such as hostel, travel and exams, or the possibility of studying abroad, which is priced in a foreign currency.

Frequently asked questions

How much should I save for my child’s education?

It depends on the course, the date and the return. Estimate the cost today, grow it with education inflation, and use this calculator to find the monthly SIP. Revisit the plan every year.

What education inflation should I assume?

There is no single official figure, and it differs by course and country. Many planners use a rate higher than general inflation. Try several values, such as 6%, 8% and 10%, to see the range.

Is a SIP a good way to save for a child’s education?

A SIP in equity funds can suit goals that are more than about 7 years away, but returns are not guaranteed. Nearer goals need safer options. See the SIP calculator and the step-up SIP calculator.

What if I already have savings?

Enter them. The calculator grows them to the goal date and reduces the SIP you need.

Are there special schemes for a girl child?

Yes. Sukanya Samriddhi Yojana is a government scheme for a girl child. See the Sukanya Samriddhi Yojana calculator for its rules and rate.

Should I also buy insurance for this goal?

A term life policy can protect the goal if the earning parent dies. It is separate from the investment plan. Do not mix the two.

Estimate only. This tool is for education and planning and is not financial, tax or legal advice. Real loans, GST filings and tax returns depend on your full circumstances. See our disclaimer.

Sources: SEBI Investor Website — investor education · AMFI — Association of Mutual Funds in India

About the author. Thomas M is a Registered Investment Adviser (South Carolina) who launched his own financial advisory firm in 2010.