Calculator - Monthly

Sukanya Samriddhi Account Excel Calculator

Input ParametersOutput ParametersRate of Interest9.10%Sukanya Samriddhi CalculatorMaturity Value30,356,413Monthly Investment50000Year 1MonthDepositBalanceInterestApr50,00050,000379May50,000100,000758Jun50,000150,0001,138Jul50,000200,0001,517Aug50,000250,0001,896Sep50,000300,0002,275Oct50,000350,0002,654Nov50,000400,0003,033Dec50,000450,0003,413Jan50,000500,0003,792Feb50,000550,0004,171Mar50,000600,0004,550Year End Balance629,57529,575

Year 2MonthDepositBalanceInterestApr50,000679,5755,153May50,000729,5755,533Jun50,000779,5755,912Jul50,000829,5756,291Aug50,000879,5756,670Sep50,000929,5757,049Oct50,000979,5757,428Nov50,0001,029,5757,808Dec50,0001,079,5758,187Jan50,0001,129,5758,566Feb50,0001,179,5758,945Mar50,0001,229,5759,324Year End Balance1,316,44186,866

Year 3MonthDepositBalanceInterestApr50,0001,366,44110,362May50,0001,416,44110,741Jun50,0001,466,44111,121Jul50,0001,516,44111,500Aug50,0001,566,44111,879Sep50,0001,616,44112,258Oct50,0001,666,44112,637Nov50,0001,716,44113,016Dec50,0001,766,44113,396Jan50,0001,816,44113,775Feb50,0001,866,44114,154Mar50,0001,916,44114,533Year End Balance2,065,812149,371

Year 4MonthDepositBalanceInterestApr50,0002,115,81216,045May50,0002,165,81216,424Jun50,0002,215,81216,803Jul50,0002,265,81217,182Aug50,0002,315,81217,562Sep50,0002,365,81217,941Oct50,0002,415,81218,320Nov50,0002,465,81218,699Dec50,0002,515,81219,078Jan50,0002,565,81219,457Feb50,0002,615,81219,837Mar50,0002,665,81220,216Year End Balance2,883,376217,564

Year 5MonthDepositBalanceInterestApr50,0002,933,37622,245May50,0002,983,37622,624Jun50,0003,033,37623,003Jul50,0003,083,37623,382Aug50,0003,133,37623,761Sep50,0003,183,37624,141Oct50,0003,233,37624,520Nov50,0003,283,37624,899Dec50,0003,333,37625,278Jan50,0003,383,37625,657Feb50,0003,433,37626,036Mar50,0003,483,37626,416Year End Balance3,775,339291,962

Year 6MonthDepositBalanceInterestApr50,0003,825,33929,009May50,0003,875,33929,388Jun50,0003,925,33929,767Jul50,0003,975,33930,146Aug50,0004,025,33930,525Sep50,0004,075,33930,905Oct50,0004,125,33931,284Nov50,0004,175,33931,663Dec50,0004,225,33932,042Jan50,0004,275,33932,421Feb50,0004,325,33932,800Mar50,0004,375,33933,180Year End Balance4,748,469373,131

Year 7MonthDepositBalanceInterestApr50,0004,798,46936,388May50,0004,848,46936,768Jun50,0004,898,46937,147Jul50,0004,948,46937,526Aug50,0004,998,46937,905Sep50,0005,048,46938,284Oct50,0005,098,46938,663Nov50,0005,148,46939,043Dec50,0005,198,46939,422Jan50,0005,248,46939,801Feb50,0005,298,46940,180Mar50,0005,348,46940,559Year End Balance5,810,155461,686

Year 8MonthDepositBalanceInterestApr50,0005,860,15544,440May50,0005,910,15544,819Jun50,0005,960,15545,198Jul50,0006,010,15545,577Aug50,0006,060,15545,956Sep50,0006,110,15546,335Oct50,0006,160,15546,715Nov50,0006,210,15547,094Dec50,0006,260,15547,473Jan50,0006,310,15547,852Feb50,0006,360,15548,231Mar50,0006,410,15548,610Year End Balance6,968,454558,299

Year 9MonthDepositBalanceInterestApr50,0007,018,45453,223May50,0007,068,45453,602Jun50,0007,118,45453,982Jul50,0007,168,45454,361Aug50,0007,218,45454,740Sep50,0007,268,45455,119Oct50,0007,318,45455,498Nov50,0007,368,45455,877Dec50,0007,418,45456,257Jan50,0007,468,45456,636Feb50,0007,518,45457,015Mar50,0007,568,45457,394Year End Balance8,232,159663,704

Year 10MonthDepositBalanceInterestApr50,0008,282,15962,806May50,0008,332,15963,186Jun50,0008,382,15963,565Jul50,0008,432,15963,944Aug50,0008,482,15964,323Sep50,0008,532,15964,702Oct50,0008,582,15965,081Nov50,0008,632,15965,461Dec50,0008,682,15965,840Jan50,0008,732,15966,219Feb50,0008,782,15966,598Mar50,0008,832,15966,977Year End Balance9,610,860778,701

Year 11MonthDepositBalanceInterestApr50,0009,660,86073,262May50,0009,710,86073,641Jun50,0009,760,86074,020Jul50,0009,810,86074,399Aug50,0009,860,86074,778Sep50,0009,910,86075,157Oct50,0009,960,86075,537Nov50,00010,010,86075,916Dec50,00010,060,86076,295Jan50,00010,110,86076,674Feb50,00010,160,86077,053Mar50,00010,210,86077,432Year End Balance11,115,023904,163

Year 12MonthDepositBalanceInterestApr50,00011,165,02384,668May50,00011,215,02385,047Jun50,00011,265,02385,426Jul50,00011,315,02385,806Aug50,00011,365,02386,185Sep50,00011,415,02386,564Oct50,00011,465,02386,943Nov50,00011,515,02387,322Dec50,00011,565,02387,701Jan50,00011,615,02388,081Feb50,00011,665,02388,460Mar50,00011,715,02388,839Year End Balance12,756,0661,041,042

Year 13MonthDepositBalanceInterestApr50,00012,806,06697,113May50,00012,856,06697,492Jun50,00012,906,06697,871Jul50,00012,956,06698,250Aug50,00013,006,06698,629Sep50,00013,056,06699,008Oct50,00013,106,06699,388Nov50,00013,156,06699,767Dec50,00013,206,066100,146Jan50,00013,256,066100,525Feb50,00013,306,066100,904Mar50,00013,356,066101,283Year End Balance14,546,4421,190,377

Year 14MonthDepositBalanceInterestApr50,00014,596,442110,690May50,00014,646,442111,069Jun50,00014,696,442111,448Jul50,00014,746,442111,827Aug50,00014,796,442112,206Sep50,00014,846,442112,586Oct50,00014,896,442112,965Nov50,00014,946,442113,344Dec50,00014,996,442113,723Jan50,00015,046,442114,102Feb50,00015,096,442114,481Mar50,00015,146,442114,861Year End Balance16,499,7441,353,301

Year 15MonthDepositBalanceInterestApr016,499,744125,123May016,499,744125,123Jun016,499,744125,123Jul016,499,744125,123Aug016,499,744125,123Sep016,499,744125,123Oct016,499,744125,123Nov016,499,744125,123Dec016,499,744125,123Jan016,499,744125,123Feb016,499,744125,123Mar016,499,744125,123Year End Balance18,001,2201,501,477Year 16MonthDepositBalanceInterestApr018,001,220136,509May018,001,220136,509Jun018,001,220136,509Jul018,001,220136,509Aug018,001,220136,509Sep018,001,220136,509Oct018,001,220136,509Nov018,001,220136,509Dec018,001,220136,509Jan018,001,220136,509Feb018,001,220136,509Mar018,001,220136,509Year End Balance19,639,3321,638,111Year 17MonthDepositBalanceInterestApr019,639,332148,932May019,639,332148,932Jun019,639,332148,932Jul019,639,332148,932Aug019,639,332148,932Sep019,639,332148,932Oct019,639,332148,932Nov019,639,332148,932Dec019,639,332148,932Jan019,639,332148,932Feb019,639,332148,932Mar019,639,332148,932Year End Balance21,426,5111,787,179Year 18MonthDepositBalanceInterestApr021,426,511162,484May021,426,511162,484Jun021,426,511162,484Jul021,426,511162,484Aug021,426,511162,484Sep021,426,511162,484Oct021,426,511162,484Nov021,426,511162,484Dec021,426,511162,484Jan021,426,511162,484Feb021,426,511162,484Mar021,426,511162,484Year End Balance23,376,3231,949,812Year 19MonthDepositBalanceInterestApr023,376,323177,270May023,376,323177,270Jun023,376,323177,270Jul023,376,323177,270Aug023,376,323177,270Sep023,376,323177,270Oct023,376,323177,270Nov023,376,323177,270Dec023,376,323177,270Jan023,376,323177,270Feb023,376,323177,270Mar023,376,323177,270Year End Balance25,503,5692,127,245Year 20MonthDepositBalanceInterestApr025,503,569193,402May025,503,569193,402Jun025,503,569193,402Jul025,503,569193,402Aug025,503,569193,402Sep025,503,569193,402Oct025,503,569193,402Nov025,503,569193,402Dec025,503,569193,402Jan025,503,569193,402Feb025,503,569193,402Mar025,503,569193,402Year End Balance27,824,3932,320,825Year 21MonthDepositBalanceInterestApr027,824,393211,002May027,824,393211,002Jun027,824,393211,002Jul027,824,393211,002Aug027,824,393211,002Sep027,824,393211,002Oct027,824,393211,002Nov027,824,393211,002Dec027,824,393211,002Jan027,824,393211,002Feb027,824,393211,002Mar027,824,393211,002Year End Balance30,356,4132,532,020

Sukanya Samriddhi

Sukanya Samriddhi CalculatorYearAge of Girl ChildOpening BalanceMonthly ContributionYearly ContributionIntrest Rate @9.1%Closing Balance20151-50000600,00029,575629,57520162629,57550000600,00086,8661,316,441201731,316,44150000600,000149,3712,065,812201842,065,81250000600,000217,5642,883,376201952,883,37650000600,000291,9623,775,339202063,775,33950000600,000373,1314,748,469202174,748,46950000600,000461,6865,810,155202285,810,15550000600,000558,2996,968,454202396,968,45450000600,000663,7048,232,1592024108,232,15950000600,000778,7019,610,8602025119,610,86050000600,000904,16311,115,02320261211,115,02350000600,0001,041,04212,756,06620271312,756,06650000600,0001,190,37714,546,44220281414,546,44250000600,0001,353,30116,499,74420291516,499,744--1,501,47718,001,22020301618,001,220--1,638,11119,639,33220311719,639,332--1,787,17921,426,51120321821,426,511--1,949,81223,376,32320331923,376,323--2,127,24525,503,56920342025,503,569--2,320,82527,824,39320352127,824,393--2,532,02030,356,413http://moneyexcel.com

Calculator - Yearly

Input ParametersOutput ParametersRate of Interest9.10%Sukanya Samriddhi CalculatorMaturity Value7,890,763Yearly Investment150000Year 1MonthDepositBalanceInterestApr150,000150,0001,138May150,0001,138Jun150,0001,138Jul150,0001,138Aug150,0001,138Sep150,0001,138Oct150,0001,138Nov150,0001,138Dec150,0001,138Jan150,0001,138Feb150,0001,138Mar150,0001,138Year End Balance163,65013,650

Year 2MonthDepositBalanceInterestApr150,000313,6502,379May313,6502,379Jun313,6502,379Jul313,6502,379Aug313,6502,379Sep313,6502,379Oct313,6502,379Nov313,6502,379Dec313,6502,379Jan313,6502,379Feb313,6502,379Mar313,6502,379Year End Balance342,19228,542

Year 3MonthDepositBalanceInterestApr150,000492,1923,732May492,1923,732Jun492,1923,732Jul492,1923,732Aug492,1923,732Sep492,1923,732Oct492,1923,732Nov492,1923,732Dec492,1923,732Jan492,1923,732Feb492,1923,732Mar492,1923,732Year End Balance536,98244,789

Year 4MonthDepositBalanceInterestApr150,000686,9825,210May686,9825,210Jun686,9825,210Jul686,9825,210Aug686,9825,210Sep686,9825,210Oct686,9825,210Nov686,9825,210Dec686,9825,210Jan686,9825,210Feb686,9825,210Mar686,9825,210Year End Balance749,49762,515

Year 5MonthDepositBalanceInterestApr150,000899,4976,821May899,4976,821Jun899,4976,821Jul899,4976,821Aug899,4976,821Sep899,4976,821Oct899,4976,821Nov899,4976,821Dec899,4976,821Jan899,4976,821Feb899,4976,821Mar899,4976,821Year End Balance981,35181,854

Year 6MonthDepositBalanceInterestApr150,0001,131,3518,579May1,131,3518,579Jun1,131,3518,579Jul1,131,3518,579Aug1,131,3518,579Sep1,131,3518,579Oct1,131,3518,579Nov1,131,3518,579Dec1,131,3518,579Jan1,131,3518,579Feb1,131,3518,579Mar1,131,3518,579Year End Balance1,234,304102,953

Year 7MonthDepositBalanceInterestApr150,0001,384,30410,498May1,384,30410,498Jun1,384,30410,498Jul1,384,30410,498Aug1,384,30410,498Sep1,384,30410,498Oct1,384,30410,498Nov1,384,30410,498Dec1,384,30410,498Jan1,384,30410,498Feb1,384,30410,498Mar1,384,30410,498Year End Balance1,510,276125,972

Year 8MonthDepositBalanceInterestApr150,0001,660,27612,590May1,660,27612,590Jun1,660,27612,590Jul1,660,27612,590Aug1,660,27612,590Sep1,660,27612,590Oct1,660,27612,590Nov1,660,27612,590Dec1,660,27612,590Jan1,660,27612,590Feb1,660,27612,590Mar1,660,27612,590Year End Balance1,811,361151,085

Year 9MonthDepositBalanceInterestApr150,0001,961,36114,874May1,961,36114,874Jun1,961,36114,874Jul1,961,36114,874Aug1,961,36114,874Sep1,961,36114,874Oct1,961,36114,874Nov1,961,36114,874Dec1,961,36114,874Jan1,961,36114,874Feb1,961,36114,874Mar1,961,36114,874Year End Balance2,139,845178,484

Year 10MonthDepositBalanceInterestApr150,0002,289,84517,365May2,289,84517,365Jun2,289,84517,365Jul2,289,84517,365Aug2,289,84517,365Sep2,289,84517,365Oct2,289,84517,365Nov2,289,84517,365Dec2,289,84517,365Jan2,289,84517,365Feb2,289,84517,365Mar2,289,84517,365Year End Balance2,498,221208,376

Year 11MonthDepositBalanceInterestApr150,0002,648,22120,082May2,648,22120,082Jun2,648,22120,082Jul2,648,22120,082Aug2,648,22120,082Sep2,648,22120,082Oct2,648,22120,082Nov2,648,22120,082Dec2,648,22120,082Jan2,648,22120,082Feb2,648,22120,082Mar2,648,22120,082Year End Balance2,889,209240,988

Year 12MonthDepositBalanceInterestApr150,0003,039,20923,047May3,039,20923,047Jun3,039,20923,047Jul3,039,20923,047Aug3,039,20923,047Sep3,039,20923,047Oct3,039,20923,047Nov3,039,20923,047Dec3,039,20923,047Jan3,039,20923,047Feb3,039,20923,047Mar3,039,20923,047Year End Balance3,315,777276,568

Year 13MonthDepositBalanceInterestApr150,0003,465,77726,282May3,465,77726,282Jun3,465,77726,282Jul3,465,77726,282Aug3,465,77726,282Sep3,465,77726,282Oct3,465,77726,282Nov3,465,77726,282Dec3,465,77726,282Jan3,465,77726,282Feb3,465,77726,282Mar3,465,77726,282Year End Balance3,781,162315,386

Year 14MonthDepositBalanceInterestApr150,0003,931,16229,811May3,931,16229,811Jun3,931,16229,811Jul3,931,16229,811Aug3,931,16229,811Sep3,931,16229,811Oct3,931,16229,811Nov3,931,16229,811Dec3,931,16229,811Jan3,931,16229,811Feb3,931,16229,811Mar3,931,16229,811Year End Balance4,288,898357,736

Year 15MonthDepositBalanceInterestApr04,288,89832,524May04,288,89832,524Jun04,288,89832,524Jul04,288,89832,524Aug04,288,89832,524Sep04,288,89832,524Oct04,288,89832,524Nov04,288,89832,524Dec04,288,89832,524Jan04,288,89832,524Feb04,288,89832,524Mar04,288,89832,524Year End Balance4,679,188390,290Year 16MonthDepositBalanceInterestApr04,679,18835,484May04,679,18835,484Jun04,679,18835,484Jul04,679,18835,484Aug04,679,18835,484Sep04,679,18835,484Oct04,679,18835,484Nov04,679,18835,484Dec04,679,18835,484Jan04,679,18835,484Feb04,679,18835,484Mar04,679,18835,484Year End Balance5,104,994425,806Year 17MonthDepositBalanceInterestApr05,104,99438,713May05,104,99438,713Jun05,104,99438,713Jul05,104,99438,713Aug05,104,99438,713Sep05,104,99438,713Oct05,104,99438,713Nov05,104,99438,713Dec05,104,99438,713Jan05,104,99438,713Feb05,104,99438,713Mar05,104,99438,713Year End Balance5,569,548464,554Year 18MonthDepositBalanceInterestApr05,569,54842,236May05,569,54842,236Jun05,569,54842,236Jul05,569,54842,236Aug05,569,54842,236Sep05,569,54842,236Oct05,569,54842,236Nov05,569,54842,236Dec05,569,54842,236Jan05,569,54842,236Feb05,569,54842,236Mar05,569,54842,236Year End Balance6,076,377506,829Year 19MonthDepositBalanceInterestApr06,076,37746,079May06,076,37746,079Jun06,076,37746,079Jul06,076,37746,079Aug06,076,37746,079Sep06,076,37746,079Oct06,076,37746,079Nov06,076,37746,079Dec06,076,37746,079Jan06,076,37746,079Feb06,076,37746,079Mar06,076,37746,079Year End Balance6,629,328552,950Year 20MonthDepositBalanceInterestApr06,629,32850,272May06,629,32850,272Jun06,629,32850,272Jul06,629,32850,272Aug06,629,32850,272Sep06,629,32850,272Oct06,629,32850,272Nov06,629,32850,272Dec06,629,32850,272Jan06,629,32850,272Feb06,629,32850,272Mar06,629,32850,272Year End Balance7,232,597603,269Year 21MonthDepositBalanceInterestApr07,232,59754,847May07,232,59754,847Jun07,232,59754,847Jul07,232,59754,847Aug07,232,59754,847Sep07,232,59754,847Oct07,232,59754,847Nov07,232,59754,847Dec07,232,59754,847Jan07,232,59754,847Feb07,232,59754,847Mar07,232,59754,847Year End Balance7,890,763658,166