How it works
Each monthly deposit earns from the month it is made until maturity, so the first deposit earns for the whole term and the last for one month. The total is the sum of every deposit compounded for its own remaining period.
The rate handling is where care is needed. Recurring deposits compound quarterly, so the monthly rate is the one that compounds up to the quarterly rate — the cube root of it — rather than the annual rate divided by twelve. At 6.7% that is 0.555242% a month against 0.558333%, and applying the wrong one inflates a five-year maturity value.
More detail
Getting that right is what makes ₹5,000 a month for sixty months at 6.7% land in the range published post office maturity tables quote. The frequency scenario above shows how much the convention itself is worth.
The schedule groups deposits by year so you can see interest overtaking the pace of the deposits, which is the point at which a recurring deposit starts working for you rather than merely holding your money.
To deposit one sum instead of saving monthly, use the fixed deposit calculator.
For the market-linked version of the same monthly habit, see the SIP calculator.
To work out what you can commit each month, try the savings rate calculator.