Planning for a Child's Education: How the Calculator Works
This calculator estimates what a course that costs a given amount today will cost when the child reaches the age entered, and the monthly SIP that would build that amount at the return entered, after counting what has already been saved. The inflation rate and the return are the reader's assumptions; the calculator does not predict either.
The Method
The future cost is today's cost grown at the education inflation rate for each year until the course starts. Existing savings are grown at the return entered. The gap between the two is spread over a monthly SIP, invested at the start of each month and compounded monthly at the same return.
With the default inputs (a child of 5, a course starting at 18, a cost of Rs 15 lakh today, 8% education inflation, a 12% return and Rs 2 lakh already saved), the course costs Rs 40.79 lakh in 13 years. The Rs 2 lakh grows to Rs 8.73 lakh, leaving a gap of Rs 32.07 lakh, which needs a SIP of Rs 8,530 a month; the total paid in is Rs 15.31 lakh. With no existing savings, the same course needs Rs 7,831 a month from birth (when it would cost Rs 59.94 lakh at 18), Rs 10,852 a month from age 5 and Rs 17,188 a month from age 10.
Education Inflation
There is no single official index of education costs, and fees vary widely between institutions and courses. The calculator applies one rate every year. At 10% a year, a fee of Rs 1 lakh a year today becomes Rs 2.59 lakh a year in 10 years and Rs 6.73 lakh a year in 20 years. For a course abroad, the cost is in a foreign currency, so changes in the exchange rate add to or reduce the rupee cost; the calculator does not model the currency separately, so the rate entered has to cover both.
Savings Options and Their Rules
Mutual funds. Returns are market-linked and not guaranteed. Units of tax-saving (ELSS) schemes count towards the Rs 1,50,000 deduction in section 123 of the Income-tax Act, 2025 under Schedule XV, paragraph 1(m), and carry a lock-in.
Public Provident Fund and Sukanya Samriddhi Yojana. Contributions to the Public Provident Fund count under paragraph 1(e) of Schedule XV, and deposits in a notified scheme for a girl child, such as the Sukanya Samriddhi Yojana, under paragraph 1(h). The government notifies the interest rate on both each quarter, and each scheme's rules set the deposit limits, the maturity and when partial withdrawals are allowed, including for education.
Tuition fees. Tuition fees paid to a university, college, school or other educational institution in India for the full-time education of up to two children also count under paragraph 1(q), excluding development fees and donations. All the section 123 deductions are available only under the old regime; the new regime in section 202 does not allow them.
NPS. NPS is a retirement account, and PFRDA's regulations limit withdrawals before exit. The Tier II account, which a subscriber can open alongside, allows withdrawals.
Education Loans
Under the old regime, the whole of the interest paid on a loan for higher education from a bank or a notified financial institution is deductible under section 129 of the Income-tax Act, 2025, for the tax year in which interest is first paid and the seven tax years after it. The new regime does not allow the deduction. The calculator does not model a loan; the gap it shows is the amount still to be saved.