PPF Calculator Excel — Maturity & Passbook
Project your Public Provident Fund balance year by year at the current 7.1% rate. Choose a yearly lump-sum or equal monthly deposits, see the exact min-balance interest, and model 5-year extensions beyond the 15-year term — all in a transparent, EEE-status passbook.
Download Excel — FreeNo signup. No email required. Direct download.What you get
Sheet-by-sheet overview
Workbook contents (3 sheets)
- Cover — The PPF Scheme 2019 rules — rate, deposit limits, lock-in, the min-balance interest rule and EEE tax status.
- PPF Calculator — Yearly lump-sum model with a start or end-of-year toggle and a year-wise passbook that supports extensions.
- Monthly Deposit — Twelve equal monthly deposits with the exact minimum-balance interest, year by year.
How to use
- Open the PPF Calculator sheet and enter your annual deposit (up to Rs 1,50,000).
- Confirm the interest rate and set the tenure — 15 years, or more if you are modelling extensions.
- Choose start-of-year or end-of-year deposit timing from the dropdown.
- Read the maturity value, total invested and total interest, plus the full year-wise passbook.
- If you invest monthly instead, switch to the Monthly Deposit sheet for the exact min-balance figure.
How PPF interest is actually calculated
PPF interest is computed each month on the lowest balance between the close of the 5th and the end of the month, then credited once a year on 31 March. The practical takeaway is simple: deposit on or before the 5th to earn interest for that month. A single lump-sum paid early in April therefore earns the most, which is why the annual and monthly sheets can show different maturity values for the same yearly amount.
Lump-sum versus monthly
A yearly lump-sum deposited at the start of the financial year earns a full year of interest on the whole amount. Twelve equal monthly deposits earn interest only from the month each instalment lands, so the monthly route ends slightly lower for the same annual contribution. Both are modelled here so you can see the gap for your own numbers.
Extending beyond 15 years
After the 15-year lock-in, a PPF account can be extended indefinitely in blocks of five years, with or without further deposits. Because the passbook in this workbook is not capped at 15 rows, you can simply raise the tenure and watch the corpus keep compounding tax-free.
Useful for
Salaried savers planning a tax-free retirement corpus; advisers comparing PPF against other 80C options; and anyone who wants an offline record of their PPF passbook year by year.
Frequently asked questions
Why does the deposit date matter?
Interest each month is calculated on the lowest balance between the 5th and the month-end. A deposit made on or before the 5th counts for that month; later than the 5th and it earns interest only from the next month. Deposit early to maximise returns.
Why do the annual and monthly sheets give different maturities?
A start-of-year lump-sum earns a full year of interest on the entire amount, while monthly deposits earn interest only from when each instalment is paid. For the same Rs 1.5 lakh a year, the monthly route ends a little lower — both figures are shown.
Can I model extensions past 15 years?
Yes. The passbook runs well beyond 15 years, so just increase the tenure to model the account extended in 5-year blocks, with or without fresh contributions.