sukanya samriddhi calculator from sapost

39
Input in Yellow Input Parameters Rate of Interest 9.10% Sukanya Sam Monthly Investment 1200 Month Deposit Apr 1,200 May 1,200 un 1,200 ul 1,200 Au! 1,200 "ep 1,200 #ct 1,200 $ov 1,200 ec 1,200 an 1,200 &e' 1,200 Mar 1,200 Year End Balance Month Deposit Apr 1,200 May 1,200 un 1,200 ul 1,200 Au! 1,200 "ep 1,200 #ct 1,200 $ov 1,200 ec 1,200 an 1,200 &e' 1,200 Mar 1,200 Year End Balance Month Deposit Apr 1,200

Upload: prakasavi

Post on 02-Nov-2015

219 views

Category:

Documents


0 download

DESCRIPTION

Sukanya Samriddhi Calculator From SAPOST

TRANSCRIPT

Calculator - MonthlyInput in Yellow cellInput ParametersOutput ParametersRate of Interest9.10%Sukanya Samriddhi CalculatorMaturity Value728,554Monthly Investment1200Year 1MonthDepositBalanceInterestApr1,2001,2009May1,2002,40018Jun1,2003,60027Jul1,2004,80036Aug1,2006,00046Sep1,2007,20055Oct1,2008,40064Nov1,2009,60073Dec1,20010,80082Jan1,20012,00091Feb1,20013,200100Mar1,20014,400109Year End Balance15,110710

Year 2MonthDepositBalanceInterestApr1,20016,310124May1,20017,510133Jun1,20018,710142Jul1,20019,910151Aug1,20021,110160Sep1,20022,310169Oct1,20023,510178Nov1,20024,710187Dec1,20025,910196Jan1,20027,110206Feb1,20028,310215Mar1,20029,510224Year End Balance31,5952,085

Year 3MonthDepositBalanceInterestApr1,20032,795249May1,20033,995258Jun1,20035,195267Jul1,20036,395276Aug1,20037,595285Sep1,20038,795294Oct1,20039,995303Nov1,20041,195312Dec1,20042,395321Jan1,20043,595331Feb1,20044,795340Mar1,20045,995349Year End Balance49,5793,585

Year 4MonthDepositBalanceInterestApr1,20050,779385May1,20051,979394Jun1,20053,179403Jul1,20054,379412Aug1,20055,579421Sep1,20056,779431Oct1,20057,979440Nov1,20059,179449Dec1,20060,379458Jan1,20061,579467Feb1,20062,779476Mar1,20063,979485Year End Balance69,2015,222

Year 5MonthDepositBalanceInterestApr1,20070,401534May1,20071,601543Jun1,20072,801552Jul1,20074,001561Aug1,20075,201570Sep1,20076,401579Oct1,20077,601588Nov1,20078,801598Dec1,20080,001607Jan1,20081,201616Feb1,20082,401625Mar1,20083,601634Year End Balance90,6087,007

Year 6MonthDepositBalanceInterestApr1,20091,808696May1,20093,008705Jun1,20094,208714Jul1,20095,408724Aug1,20096,608733Sep1,20097,808742Oct1,20099,008751Nov1,200100,208760Dec1,200101,408769Jan1,200102,608778Feb1,200103,808787Mar1,200105,008796Year End Balance113,9638,955

Year 7MonthDepositBalanceInterestApr1,200115,163873May1,200116,363882Jun1,200117,563892Jul1,200118,763901Aug1,200119,963910Sep1,200121,163919Oct1,200122,363928Nov1,200123,563937Dec1,200124,763946Jan1,200125,963955Feb1,200127,163964Mar1,200128,363973Year End Balance139,44411,080

Year 8MonthDepositBalanceInterestApr1,200140,6441,067May1,200141,8441,076Jun1,200143,0441,085Jul1,200144,2441,094Aug1,200145,4441,103Sep1,200146,6441,112Oct1,200147,8441,121Nov1,200149,0441,130Dec1,200150,2441,139Jan1,200151,4441,148Feb1,200152,6441,158Mar1,200153,8441,167Year End Balance167,24313,399

Year 9MonthDepositBalanceInterestApr1,200168,4431,277May1,200169,6431,286Jun1,200170,8431,296Jul1,200172,0431,305Aug1,200173,2431,314Sep1,200174,4431,323Oct1,200175,6431,332Nov1,200176,8431,341Dec1,200178,0431,350Jan1,200179,2431,359Feb1,200180,4431,368Mar1,200181,6431,377Year End Balance197,57215,929

Year 10MonthDepositBalanceInterestApr1,200198,7721,507May1,200199,9721,516Jun1,200201,1721,526Jul1,200202,3721,535Aug1,200203,5721,544Sep1,200204,7721,553Oct1,200205,9721,562Nov1,200207,1721,571Dec1,200208,3721,580Jan1,200209,5721,589Feb1,200210,7721,598Mar1,200211,9721,607Year End Balance230,66118,689

Year 11MonthDepositBalanceInterestApr1,200231,8611,758May1,200233,0611,767Jun1,200234,2611,776Jul1,200235,4611,786Aug1,200236,6611,795Sep1,200237,8611,804Oct1,200239,0611,813Nov1,200240,2611,822Dec1,200241,4611,831Jan1,200242,6611,840Feb1,200243,8611,849Mar1,200245,0611,858Year End Balance266,76121,700

Year 12MonthDepositBalanceInterestApr1,200267,9612,032May1,200269,1612,041Jun1,200270,3612,050Jul1,200271,5612,059Aug1,200272,7612,068Sep1,200273,9612,078Oct1,200275,1612,087Nov1,200276,3612,096Dec1,200277,5612,105Jan1,200278,7612,114Feb1,200279,9612,123Mar1,200281,1612,132Year End Balance306,14624,985

Year 13MonthDepositBalanceInterestApr1,200307,3462,331May1,200308,5462,340Jun1,200309,7462,349Jul1,200310,9462,358Aug1,200312,1462,367Sep1,200313,3462,376Oct1,200314,5462,385Nov1,200315,7462,394Dec1,200316,9462,404Jan1,200318,1462,413Feb1,200319,3462,422Mar1,200320,5462,431Year End Balance349,11528,569

Year 14MonthDepositBalanceInterestApr1,200350,3152,657May1,200351,5152,666Jun1,200352,7152,675Jul1,200353,9152,684Aug1,200355,1152,693Sep1,200356,3152,702Oct1,200357,5152,711Nov1,200358,7152,720Dec1,200359,9152,729Jan1,200361,1152,738Feb1,200362,3152,748Mar1,200363,5152,757Year End Balance395,99432,479

Year 15MonthDepositBalanceInterestApr0395,9943,003May0395,9943,003Jun0395,9943,003Jul0395,9943,003Aug0395,9943,003Sep0395,9943,003Oct0395,9943,003Nov0395,9943,003Dec0395,9943,003Jan0395,9943,003Feb0395,9943,003Mar0395,9943,003Year End Balance432,02936,035Year 16MonthDepositBalanceInterestApr0432,0293,276May0432,0293,276Jun0432,0293,276Jul0432,0293,276Aug0432,0293,276Sep0432,0293,276Oct0432,0293,276Nov0432,0293,276Dec0432,0293,276Jan0432,0293,276Feb0432,0293,276Mar0432,0293,276Year End Balance471,34439,315Year 17MonthDepositBalanceInterestApr0471,3443,574May0471,3443,574Jun0471,3443,574Jul0471,3443,574Aug0471,3443,574Sep0471,3443,574Oct0471,3443,574Nov0471,3443,574Dec0471,3443,574Jan0471,3443,574Feb0471,3443,574Mar0471,3443,574Year End Balance514,23642,892Year 18MonthDepositBalanceInterestApr0514,2363,900May0514,2363,900Jun0514,2363,900Jul0514,2363,900Aug0514,2363,900Sep0514,2363,900Oct0514,2363,900Nov0514,2363,900Dec0514,2363,900Jan0514,2363,900Feb0514,2363,900Mar0514,2363,900Year End Balance561,03246,795Year 19MonthDepositBalanceInterestApr0561,0324,254May0561,0324,254Jun0561,0324,254Jul0561,0324,254Aug0561,0324,254Sep0561,0324,254Oct0561,0324,254Nov0561,0324,254Dec0561,0324,254Jan0561,0324,254Feb0561,0324,254Mar0561,0324,254Year End Balance612,08651,054Year 20MonthDepositBalanceInterestApr0612,0864,642May0612,0864,642Jun0612,0864,642Jul0612,0864,642Aug0612,0864,642Sep0612,0864,642Oct0612,0864,642Nov0612,0864,642Dec0612,0864,642Jan0612,0864,642Feb0612,0864,642Mar0612,0864,642Year End Balance667,78555,700Year 21MonthDepositBalanceInterestApr0667,7855,064May0667,7855,064Jun0667,7855,064Jul0667,7855,064Aug0667,7855,064Sep0667,7855,064Oct0667,7855,064Nov0667,7855,064Dec0667,7855,064Jan0667,7855,064Feb0667,7855,064Mar0667,7855,064Year End Balance728,55460,768

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

Sukanya Samriddhihttp://sapost.blogspot.comSukanya Samriddhi CalculatorYearAge of Girl ChildOpening BalanceMonthly ContributionYearly ContributionIntrest Rate @9.1%Closing Balance20151-120014,40071015,1102016215,110120014,4002,08531,5952017331,595120014,4003,58549,5792018449,579120014,4005,22269,2012019569,201120014,4007,00790,6082020690,608120014,4008,955113,96320217113,963120014,40011,080139,44420228139,444120014,40013,399167,24320239167,243120014,40015,929197,572202410197,572120014,40018,689230,661202511230,661120014,40021,700266,761202612266,761120014,40024,985306,146202713306,146120014,40028,569349,115202814349,115120014,40032,479395,994202915395,994--36,035432,029203016432,029--39,315471,344203117471,344--42,892514,236203218514,236--46,795561,032203319561,032--51,054612,086203420612,086--55,700667,785203521667,785--60,768728,554