What ₹20 lakh becomes by 2042
Rahul and Shreya Banerjee live in Dum Dum, Kolkata. Their daughter Mira turned two this year. They don't know what she will study. For planning, they have picked a four-year course at a private college and added hostel and living costs: about ₹20 lakh at today's prices. That is their working figure. Yours may be ₹8 lakh or ₹80 lakh, and the calculator takes any number.
Fees don't stand still for 16 years. How fast they rise is the biggest unknown in the whole plan:
| If costs rise by | ₹20 lakh becomes, in 2042 | Monthly SIP from now |
|---|---|---|
| 3.4% a year | ₹34.15 L | ₹7,138 |
| 4% | ₹37.46 L | ₹7,830 |
| 6% (used here) | ₹50.81 L | ₹10,620 |
| 8% | ₹68.52 L | ₹14,323 |
| 10% | ₹91.90 L | ₹19,210 |
The first row is the official figure: the government's consumer price index put education inflation at about 3.4% in the year to January 2026. Individual colleges can raise fees faster than that, and often in jumps. We use 6%, well above the official figure, to leave room. If you think 8% is safer, the bill becomes ₹68.52 lakh, and the calculator will redo everything else.
The monthly number: ₹10,620
To have ₹50.81 lakh in 2042, Rahul and Shreya need to invest ₹10,620 a month for 16 years. That is ₹20.39 lakh of their own money, with growth doing the rest. It assumes the fund earns 12% a year while Mira is small, and 7% a year in the last three years, when the money is moved somewhere steadier. More on that below.
| Mira's age | Put in so far | Fund value | The course would cost |
|---|---|---|---|
| 4 | ₹2.55 L | ₹2.87 L | ₹22.47 L |
| 8 | ₹7.65 L | ₹11.00 L | ₹28.37 L |
| 12 | ₹12.74 L | ₹23.79 L | ₹35.82 L |
| 15 | ₹16.57 L | ₹38.00 L | ₹42.66 L |
| 18 | ₹20.39 L | ₹50.81 L | ₹50.81 L |
A rule of thumb falls out of this. On these assumptions, every ₹1 lakh the course costs today needs about ₹530 a month from the age of two.
₹20.39 lakh of their money becomes ₹50.81 lakh of college. The other ₹30 lakh is sixteen years of growth.
What waiting costs
The bill is fixed. If they start later, the only thing that changes is how much of it has to come out of their own pocket:
| They start when Mira is | Monthly SIP | Put in by 2042 |
|---|---|---|
| 2 | ₹10,620 | ₹20.39 L |
| 5 | ₹16,156 | ₹25.20 L |
| 8 | ₹25,684 | ₹30.82 L |
| 10 | ₹36,452 | ₹34.99 L |
| 12 | ₹54,749 | ₹39.42 L |
| 14 | ₹91,271 | ₹43.81 L |
Waiting until she starts school at five adds about ₹5,500 a month. Waiting until eight more than doubles the amount. By fourteen it is ₹91,271 a month, and most of the bill is being paid straight out of salary.
If ₹10,620 is too much today, they can start lower and raise it each year. ₹8,030 a month now, raised 5% every year, reaches the same ₹50.81 lakh. The last instalments are ₹16,693 a month.
A date that can't move
Retirement can be pushed back a year if markets are bad. College can't. Mira's admission will be in 2042 whatever the Nifty is doing that summer. That is why this plan moves the money out of equity in the last three years.
Suppose they don't. With everything in equity until the end, at 12% a year, they need only ₹9,309 a month. Now let markets fall 30% in the final year. Falls of that size have happened: the Nifty 50 lost more than half between January and October 2008, and more than a third in early 2020.
All in equity to the end
₹9,309 a month
- Works if the last year is a normal one
- After a 30% fall in the final year: ₹31.94 lakh in hand
- Short by ₹18.87 lakh, 37% of the bill
Safer funds for the last 3 years
₹10,620 a month
- ₹38 lakh already built when Mira is 15
- The money is no longer in shares if the fall comes
- ₹50.81 lakh, on the assumptions used
The steadier plan costs ₹1,311 a month more. That is the price of knowing the fee can be paid in a bad year.
In practice, from about three years before the first fee is due, new instalments go into short-term debt or liquid funds, and the equity already built is moved across in stages, not on one day. The 7% used here for those years is an assumption, as the 12% is.
- Fix the date first. Count the years to the first fee, not to the 18th birthday. Money for the second year of the course has a year longer.
- Check the bill every two or three years. Colleges publish their fees. Replace the guess with the real number as it changes.
- Keep it apart from retirement money. A fund with one job and one date is easier to protect than a common pool.
