We have designed the excel based Sukanya Samriddhi Yojana Calculator which calculates the maturity amount and return on investment for your investment. The scheme was launched in 2015 and since then has become is very popular deposit scheme for girl child especially focusing on their higher education and marriage.
Sukanya Samriddhi Calculator Rules
Below are some basic rules for SSY Account:
- Sukanya Samriddhi Account can be opened in any post office and designated branches of authorised banks.
- This account can be opened only for girl child who is below 10 years of age (as of account opening date) by their natural or legal guardian
- The account can only be opened for 2 girl children. Third account can be opened in exceptional cases where the depositor was blessed with 3 girl children at the first birth or twin girl children at the second birth.
- Only resident Indians are eligible to open Sukanya Samriddhi Account.
- Investment in this scheme is eligible for income tax benefit under section 80C.
- Partial withdrawal up to 50% is allowed for the higher study of girl child after 18 years of age.
How To Download Sukanya Samriddhi Yojana [SSY] Calculator 2021
Download Sukanya Samriddhi Yojana Calculator
Sukanya Samriddhi Yojana – Investment Rules
The deposit has to be made for first 14 years from the year of account opening. The account matures either from 21 years from the date of account opening or when the girl is married, whichever is earlier.
- Maximum Deposit limit per financial year per account is Rs 1.5 Lakh
- You need to deposit minimum Rs 250 per account per year to keep it active
- The interest rate is declared every quarter by Government of India
- The interest is compounded annually
- For calculation of interest only lowest balance from the close of tenth day to end of month would be considered. This means you should deposit money before 10th of month to get interest in that month.
Sukanya Samriddhi Yojana Calculator
How does Sukanya Samriddhi Yojana Calculator work?
The Sukanya Samriddhi Account Calculator is easy to use. The calculator looks like in the picture below. You can only input orange cells. All you need is to fill up the SSY account opening year and annual contribution.
In case the yearly contribution varies over time, you can edit that too. The interest rate for Sukanya Samriddhi Yojana is revised every quarter. I would recommend taking average for a year and put it in “Average Annual Interest Rate”. This will give you approximate value of the maturity amount. As shown in the example below, if you deposit Rs 1.5 lakhs every year for 14 years, you can expect to get Rs 72 lakhs at maturity (assuming 8.5% interest every year)
| Financial year | Opening Balance | Yearly Contribution | Average Annual Intrest Rate | Annual Interest | Closing Balance |
| 2015-16 | 0 | 150,000 | 9.20% | 13,800 | 163,800 |
| 2016-17 | 163,800 | 150,000 | 8.55% | 26,830 | 340,630 |
| 2017-18 | 340,630 | 150,000 | 8.28% | 40,600 | 531,230 |
| 2018-19 | 531,230 | 150,000 | 8.30% | 56,542 | 737,772 |
| 2019-20 | 737,772 | 150,000 | 8.50% | 75,461 | 963,232 |
| 2020-21 | 963,232 | 150,000 | 8.50% | 94,625 | 1,207,857 |
| 2021-22 | 1,207,857 | 150,000 | 8.50% | 115,418 | 1,473,275 |
| 2022-23 | 1,473,275 | 150,000 | 8.50% | 137,978 | 1,761,253 |
| 2023-24 | 1,761,253 | 150,000 | 8.50% | 162,457 | 2,073,710 |
| 2024-25 | 2,073,710 | 150,000 | 8.50% | 189,015 | 2,412,725 |
| 2025-26 | 2,412,725 | 150,000 | 8.50% | 217,832 | 2,780,557 |
| 2026-27 | 2,780,557 | 150,000 | 8.50% | 249,097 | 3,179,654 |
| 2027-28 | 3,179,654 | 150,000 | 8.50% | 283,021 | 3,612,674 |
| 2028-29 | 3,612,674 | 150,000 | 8.50% | 319,827 | 4,082,502 |
| 2029-30 | 4,082,502 | x | 8.50% | 347,013 | 4,429,514 |
| 2030-31 | 4,429,514 | x | 8.50% | 376,509 | 4,806,023 |
| 2031-32 | 4,806,023 | x | 8.50% | 408,512 | 5,214,535 |
| 2032-33 | 5,214,535 | x | 8.50% | 443,235 | 5,657,771 |
| 2033-34 | 5,657,771 | x | 8.50% | 480,910 | 6,138,681 |
| 2034-35 | 6,138,681 | x | 8.50% | 521,788 | 6,660,469 |
| 2035-36 | 6,660,469 | x | 8.50% | 566,140 | 7,226,609 |
Following are the assumptions for the calculator:
- The amount is deposited on start of every financial year.
- The example has 1.5 lakhs contribution every year, but can be edited in the calculator.
- The contribution happens for 14 years and is withdrawn on completion of 21 years
- Interest rate is taken as 8.5% for future years (can be changed in the calculator)
