Scribd Logo
Upload

Welcome to Scribd!

  • 67 views

    Sukanya Samruddhi Returns Calculator

    Uploaded by

    leningandhan.s
    This document shows an Excel calculator for a Sukanya Samriddhi Account invested in for 14 and 21 years. For a 14 year investment of Rs. 36,000 annually, the accumulated value would be Rs. 18.94 lakhs. For a 21 year investment of Rs. 150,000 annually, the accumulated value would be Rs. 94.01 lakhs. The calculator tracks the opening balance, yearly investment, interest earned at 9.1% annually, and closing balance for each year of the investment period.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Sukanya Samruddhi Returns Calculator

    Uploaded by

    leningandhan.s
    67 views3 pages
    This document shows an Excel calculator for a Sukanya Samriddhi Account invested in for 14 and 21 years. For a 14 year investment of Rs. 36,000 annually, the accumulated value would be Rs. 18.94 lakhs. For a 21 year investment of Rs. 150,000 annually, the accumulated value would be Rs. 94.01 lakhs. The calculator tracks the opening balance, yearly investment, interest earned at 9.1% annually, and closing balance for each year of the investment period.

    Original Description:

    India's largest female child saving scheme Sukanya Samruddhi account

    Original Title

    Sukanya Samruddhi returns calculator

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document shows an Excel calculator for a Sukanya Samriddhi Account invested in for 14 and 21 years. For a 14 year investment of Rs. 36,000 annually, the accumulated value would be Rs. 18.94 lakhs. For a 21 year investment of Rs. 150,000 annually, the accumulated value would be Rs. 94.01 lakhs. The calculator tracks the opening balance, yearly investment, interest earned at 9.1% annually, and closing balance for each year of the investment period.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    67 views3 pages

    Sukanya Samruddhi Returns Calculator

    Uploaded by

    leningandhan.s
    This document shows an Excel calculator for a Sukanya Samriddhi Account invested in for 14 and 21 years. For a 14 year investment of Rs. 36,000 annually, the accumulated value would be Rs. 18.94 lakhs. For a 21 year investment of Rs. 150,000 annually, the accumulated value would be Rs. 94.01 lakhs. The calculator tracks the opening balance, yearly investment, interest earned at 9.1% annually, and closing balance for each year of the investment period.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    Sukanya Samriddhi Account - Excel Calculator

    Yearly investment 36,000


    Yrs of investment 14 Yrs

    Your accumulated value would be Rs 18.94 Lakhs


    Interest @ 9.1% at
    Year Interest Rate Opening balance Yearly investment the end of the
    1 9.10% 0 36,000 year
    3,276
    2 9.10% 39,276 36,000 6,850
    3 9.10% 82,126 36,000 10,749
    4 9.10% 128,876 36,000 15,004
    5 9.10% 179,879 36,000 19,645
    6 9.10% 235,524 36,000 24,709
    7 9.10% 296,233 36,000 30,233
    8 9.10% 362,466 36,000 36,260
    9 9.10% 434,727 36,000 42,836
    10 9.10% 513,563 36,000 50,010
    11 9.10% 599,573 36,000 57,837
    12 9.10% 693,410 36,000 66,376
    13 9.10% 795,786 36,000 75,693
    14 9.10% 907,479 36,000 85,857
    15 9.10% 1,029,336 0 93,670
    16 9.10% 1,123,005 0 102,193
    17 9.10% 1,225,199 0 111,493
    18 9.10% 1,336,692 0 121,639
    19 9.10% 1,458,331 0 132,708
    20 9.10% 1,591,039 0 144,785
    21 9.10% 1,735,823 0 157,960
    Assuming that this is invested at the beginning of the year
    lculator Sukanya Samriddhi Account - Excel Calcu
    Yearly investment 150,000
    Yrs of investment 21 Yrs

    8.94 Lakhs Your accumulated value would be Rs 94.0


    Balance at the end Year Interest Rate Opening balance
    of the year
    39,276 1 9.10% 0
    82,126 2 9.10% 163,650
    128,876 3 9.10% 342,192
    179,879 4 9.10% 536,982
    235,524 5 9.10% 749,497
    296,233 6 9.10% 981,351
    362,466 7 9.10% 1,234,304
    434,727 8 9.10% 1,510,276
    513,563 9 9.10% 1,811,361
    599,573 10 9.10% 2,139,845
    693,410 11 9.10% 2,498,221
    795,786 12 9.10% 2,889,209
    907,479 13 9.10% 3,315,777
    1,029,336 14 9.10% 3,781,162
    1,123,005 15 9.10% 4,288,898
    1,225,199 16 9.10% 4,842,838
    1,336,692 17 9.10% 5,447,186
    1,458,331 18 9.10% 6,106,530
    1,591,039 19 9.10% 6,825,874
    1,735,823 20 9.10% 7,610,679
    1,893,783 21 9.10% 8,466,901
    Assuming that this is invested at the beginning of the year
    dhi Account - Excel Calculator

    value would be Rs 94.01 Lakhs


    Interest @ 9.1% at Balance at the end
    Yearly investment the end of the of the year
    150,000 year
    13,650 163,650
    150,000 28,542 342,192
    150,000 44,789 536,982
    150,000 62,515 749,497
    150,000 81,854 981,351
    150,000 102,953 1,234,304
    150,000 125,972 1,510,276
    150,000 151,085 1,811,361
    150,000 178,484 2,139,845
    150,000 208,376 2,498,221
    150,000 240,988 2,889,209
    150,000 276,568 3,315,777
    150,000 315,386 3,781,162
    150,000 357,736 4,288,898
    150,000 403,940 4,842,838
    150,000 454,348 5,447,186
    150,000 509,344 6,106,530
    150,000 569,344 6,825,874
    150,000 634,805 7,610,679
    150,000 706,222 8,466,901
    150,000 784,138 9,401,039

    You might also like