Sukanya Samriddhi (SSY) Calculator Excel
Project your daughter’s Sukanya Samriddhi account at the current 8.2% rate — deposits for 15 years, maturity at 21 years, with interest continuing through the gap years. Yearly or monthly deposits, the exact min-balance interest, and an EEE-status year-wise passbook.
Download Excel — FreeNo signup. No email required. Direct download.What you get
Sheet-by-sheet overview
Workbook contents (3 sheets)
- Cover — The Sukanya Samriddhi Account Scheme, 2019 rules — rate, eligibility, deposit period, maturity and EEE tax status.
- SSY Calculator — Yearly deposit model with editable deposit years and maturity years and a full year-wise passbook.
- Monthly Deposit — Twelve equal monthly deposits with the exact minimum-balance interest, year by year.
How to use
- Open the SSY Calculator sheet and enter your annual deposit (up to Rs 1,50,000).
- Confirm the interest rate and, if needed, the deposit-years and maturity-years cells (default 15 and 21).
- Read the maturity value, total invested and total interest, plus the year-wise passbook.
- Notice that years 16 to 21 carry no deposit but still earn interest.
- If you deposit monthly, switch to the Monthly Deposit sheet for the exact min-balance figure.
How the Sukanya Samriddhi account works
An SSY account is opened for a girl child before she turns 10. Deposits are made for 15 years from opening, but the account does not mature until 21 years — so for the last six years no contribution is required yet the balance keeps earning interest. This two-stage structure is exactly why a simple annuity formula gets SSY wrong, and why this workbook models the deposit years and the gap years separately.
Yearly versus monthly deposits
A deposit made at the start of the year earns a full year of interest; twelve monthly instalments earn interest only from the month each is paid, under the minimum-balance rule. For the same annual amount the monthly route ends a little lower, and both are shown so you can compare.
Withdrawal and closure
Up to 50% of the prior-year balance may be withdrawn after the girl turns 18 for higher education, and the account can be closed on her marriage after 18. These options are not modelled in the projection, which assumes the account runs to full maturity without withdrawals.
Useful for
Parents planning a daughter’s education or marriage corpus; advisers illustrating the power of a 21-year tax-free compounding window; and anyone wanting an offline SSY passbook for their records.
Frequently asked questions
Why does the account run for 21 years if deposits stop at 15?
SSY rules require deposits for 15 years from opening, but the account matures only 21 years from opening. During years 16 to 21 no deposit is needed, yet the accumulated balance continues to earn interest — the workbook handles both phases.
What is the maximum I can deposit?
Rs 1,50,000 per financial year across all SSY accounts for the child, with a minimum of Rs 250. Deposits qualify for Section 80C under the old tax regime, and the interest and maturity are fully tax-exempt.
Why do annual and monthly maturities differ?
A start-of-year deposit earns a full year of interest; monthly deposits earn interest only from when each instalment is paid, under the min-balance rule. For the same yearly amount the monthly figure is slightly lower — both are shown.