sukanya samriddhi excel calculator download

34
Sukanya Samriddhi Ac Input Parameters Rate of Interest 9.10% Sukanya Sam Monthly Investment 50000 Month Deposit Apr 50,000 May 50,000 Jun 50,000 Jul 50,000 Aug 50,000 Sep 50,000 Oct 50,000 Nov 50,000 Dec 50,000 Jan 50,000 Feb 50,000 Mar 50,000 Year End Balance Month Deposit Apr 50,000 May 50,000 Jun 50,000 Jul 50,000 Aug 50,000 Sep 50,000 Oct 50,000 Nov 50,000 Dec 50,000 Jan 50,000 Feb 50,000 Mar 50,000 Year End Balance Month Deposit Apr 50,000 May 50,000 Jun 50,000

Upload: rajeshkumar

Post on 16-Dec-2015

47 views

Category:

Documents


4 download

DESCRIPTION

Sukanya Samriddhi Excel Calculator

TRANSCRIPT

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