{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["PPF Calculator","Goal Calculator","PPF Tracker","Post 15 yearsTracker ","Interest Rate History"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":8,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PPF Calculator","index":0,"n_rows":250,"n_cols":25,"rows_kept":250,"cut":false,"hidden":false,"merged":[[1,3,2,14],[7,12,7,13],[7,4,7,5],[7,7,7,10],[8,7,8,9],[12,4,14,5],[203,7,203,10],[219,7,219,10],[91,7,91,10],[11,7,11,10],[27,7,27,10],[59,7,59,10],[43,7,43,10],[75,7,75,10],[235,7,235,10],[107,7,107,10],[123,7,123,10],[139,7,139,10],[155,7,155,10],[171,7,171,10],[187,7,187,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4000000]
[null,null,null,"PPF Calculator"]
[]
[null,null,null,null,null,null,null,"Prepared by: Karthikeyan Chellappa"]
[]
[]
[]
[null,null,null,null,"Input Parameters",null,null,"Calculations",null,null,null,null,"Output Values"]
[null,null,null,null,"Investment Frequency","Monthly",null,"PPF Interest Rate",null,null,8.6999999999999994E-2,null,"Maturity Amount",{"$f":"J250","v":4000000.0000000112}]
[null,null,null,null,"Investment Amount",11100.295724080675]
[]
[null,null,null,null,null,null,null,"Year 1"]
[null,null,null,null,{"$f":"IF(AND(F9=\"Monthly\",F10*12>=150000),\"Warning: Annual Investment should not exceed 1.5 lakh\",IF(AND(F9=\"Quarterly\",F10*4>150000),\"Warning: Annual Investment should not exceed 1.5 lakh\",IF(AND(F9=\"Half-Yearly\",F10*2>150000),\"Warning: Annual Investment should not exceed 1.5 lakh\",IF(AND(F9=\"Annual\",F10>150000),\"Warning: Annual Investment should not exceed 1.5 lakh\",\"\"))))","v":""},null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I14","v":11100.295724080675},{"$f":"J14*$K$9/12","v":80.477143999584897}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I15+J14","v":22200.591448161351},160.95428799916979]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I16+J15","v":33300.88717224203},241.43143199875468]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},44401.182896322702,321.90857599833959]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},55501.478620403373,402.38571999792447]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},66601.774344484045,482.86286399750929]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},77702.070068564717,563.34000799709418]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},88802.365792645389,643.81715199667906]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},99902.661516726061,724.29429599626383]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},111002.95724080673,804.77143999584871]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},122103.2529648874,885.24858399543371]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},133203.54868896809,965.72572799501859]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J25+SUM(K14:K25)","v":139480.76592093572}]
[]
[null,null,null,null,null,null,null,"Year 2"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I30+J26","v":150581.06164501639},{"$f":"J30*$K$9/12","v":1091.7126969263688}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I31+J30","v":161681.35736909707},1172.1898409259536]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I32+J31","v":172781.65309317774},1252.6669849255384]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},183881.94881725841,1333.1441289251234]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},194982.24454133908,1413.6212729247081]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},206082.54026541975,1494.0984169242931]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},217182.83598950043,1574.5755609238779]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},228283.1317135811,1655.0527049234627]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},239383.42743766177,1735.5298489230479]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},250483.72316174244,1816.0069929226327]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},261584.01888582311,1896.4841369222174]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},272684.31460990378,1976.9612809218024]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J41+SUM(K30:K41)","v":291096.35847699281}]
[]
[null,null,null,null,null,null,null,"Year 3"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I46+J42","v":302196.65420107351},{"$f":"J46*$K$9/12","v":2190.9257429577829}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I47+J46","v":313296.94992515421},2271.4028869573681]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I48+J47","v":324397.24564923492},2351.8800309569529]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},335497.54137331562,2432.3571749565381]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},346597.83709739632,2512.8343189561233]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},357698.13282147702,2593.3114629557081]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},368798.42854555772,2673.7886069552933]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},379898.72426963842,2754.2657509548785]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},390999.01999371912,2834.7428949544633]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},402099.31571779982,2915.2200389540485]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},413199.61144188052,2995.6971829536337]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},424299.90716596122,3076.1743269532185]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J57+SUM(K46:K57)","v":455902.50758542726}]
[]
[null,null,null,null,null,null,null,"Year 4"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I62+J58","v":467002.80330950796},{"$f":"J62*$K$9/12","v":3385.7703239939324}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I63+J62","v":478103.09903358866},3466.2474679935171]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I64+J63","v":489203.39475766936},3546.7246119931024]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},500303.69048175006,3627.2017559926876]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},511403.98620583076,3707.6788999922724]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},522504.28192991146,3788.1560439918576]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},533604.57765399211,3868.6331879914428]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},544704.87337807275,3949.1103319910271]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},555805.16910215339,4029.5874759906114]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},566905.46482623403,4110.0646199901967]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},578005.76055031468,4190.5417639897814]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},589106.05627439532,4271.0189079893653]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J73+SUM(K62:K73)","v":635046.79166629515}]
[]
[null,null,null,null,null,null,null,"Year 5"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I78+J74","v":646147.08739037579},{"$f":"J78*$K$9/12","v":4684.5663835802243}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I79+J78","v":657247.38311445643},4765.0435275798091]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I80+J79","v":668347.67883853707},4845.5206715793929]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},679447.97456261772,4925.9978155789786]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},690548.27028669836,5006.4749595785624]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},701648.566010779,5086.9521035781472]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},712748.86173485965,5167.429247577732]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},723849.15745894029,5247.9063915773168]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},734949.45318302093,5328.3835355769015]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},746049.74890710157,5408.8606795764863]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},757150.04463118222,5489.3378235760711]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},768250.34035526286,5569.8149675756549]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J89+SUM(K78:K89)","v":829776.62846219819}]
[]
[null,null,null,null,null,null,null,"Year 6"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I94+J90","v":840876.92418627883},{"$f":"J94*$K$9/12","v":6096.3577003505206}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I95+J94","v":851977.21991035948},6176.8348443501054]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I96+J95","v":863077.51563444012},6257.3119883496902]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},874177.81135852076,6337.7891323492759]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},885278.1070826014,6418.2662763488597]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},896378.40280668205,6498.7434203484445]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},907478.69853076269,6579.2205643480293]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},918578.99425484333,6659.6977083476131]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},929679.28997892397,6740.1748523471979]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},940779.58570300462,6820.6519963467836]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},951879.88142708526,6901.1291403463683]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},962980.1771511659,6981.6062843459522]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J105+SUM(K94:K105)","v":1041447.9610593447}]
[]
[null,null,null,null,null,null,null,"Year 7"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I110+J106","v":1052548.2567834253},{"$f":"J110*$K$9/12","v":7630.9748616798324}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I111+J110","v":1063648.552507506},7711.4520056794181]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I112+J111","v":1074748.8482315866},7791.9291496790029]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1085849.1439556673,7872.4062936785876]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1096949.4396797479,7952.8834376781715]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1108049.7354038286,8033.3605816777563]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},1119150.0311279092,8113.837725677341]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1130250.3268519898,8194.3148696769258]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1141350.6225760705,8274.7920136765115]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1152450.9183001511,8355.2691576760953]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1163551.2140242318,8435.7463016756792]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1174651.5097483124,8516.2234456752649]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J121+SUM(K110:K121)","v":1271534.699592443}]
[]
[null,null,null,null,null,null,null,"Year 8"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I126+J122","v":1282634.9953165236},{"$f":"J126*$K$9/12","v":9299.1037160447959}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I127+J126","v":1293735.2910406042},9379.5808600443797]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I128+J127","v":1304835.5867646849},9460.0580040439654]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1315935.8824887655,9540.5351480435493]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1327036.1782128462,9621.0122920431331]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1338136.4739369268,9701.4894360427188]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},1349236.7696610074,9781.9665800423045]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1360337.0653850881,9862.4437240418883]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1371437.3611091687,9942.9208680414722]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1382537.6568332494,10023.398012041058]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1393637.95255733,10103.875156040642]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1404738.2482814107,10184.352300040226]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J137+SUM(K126:K137)","v":1521638.9843779209}]
[]
[null,null,null,null,null,null,null,"Year 9"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I142+J138","v":1532739.2801020015},{"$f":"J142*$K$9/12","v":11112.359780739511}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I143+J142","v":1543839.5758260821},11192.836924739095]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I144+J143","v":1554939.8715501628},11273.314068738679]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1566040.1672742434,11353.791212738264]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1577140.4629983241,11434.268356737848]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1588240.7587224047,11514.745500737432]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},1599341.0544464854,11595.222644737018]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1610441.350170566,11675.699788736603]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1621541.6458946466,11756.176932736189]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1632641.9416187273,11836.654076735773]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1643742.2373428079,11917.131220735357]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1654842.5330668886,11997.608364734942]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J153+SUM(K142:K153)","v":1793502.3419397352}]
[]
[null,null,null,null,null,null,null,"Year 10"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I158+J154","v":1804602.6376638159},{"$f":"J158*$K$9/12","v":13083.369123062665}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I159+J158","v":1815702.9333878965},13163.846267062248]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I160+J159","v":1826803.2291119772},13244.323411061834]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1837903.5248360578,13324.800555061418]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1849003.8205601384,13405.277699061002]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1860104.1162842191,13485.754843060588]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},1871204.4120082997,13566.231987060171]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1882304.7077323804,13646.709131059755]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1893405.003456461,13727.186275059341]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},1904505.2991805417,13807.663419058927]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1915605.5949046223,13888.140563058512]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},1926705.8906287029,13968.617707058096]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J169+SUM(K158:K169)","v":2089017.8116094274}]
[]
[null,null,null,null,null,null,null,"Year 11"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I174+J170","v":2100118.1073335083},{"$f":"J174*$K$9/12","v":15225.856278167934}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I175+J174","v":2111218.4030575892},15306.33342216752]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I176+J175","v":2122318.6987816701},15386.810566167107]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},2133418.9945057509,15467.287710166695]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2144519.2902298318,15547.76485416628]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2155619.5859539127,15628.241998165866]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},2166719.8816779936,15708.719142165452]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2177820.1774020744,15789.196286165039]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2188920.4731261553,15869.673430164627]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},2200020.7688502362,15950.15057416421]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2211121.0645743171,16030.627718163798]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2222221.360298398,16111.104862163384]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J185+SUM(K174:K185)","v":2410243.127140386}]
[]
[null,null,null,null,null,null,null,"Year 12"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I190+J186","v":2421343.4228644669},{"$f":"J190*$K$9/12","v":17554.739815767385}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I191+J190","v":2432443.7185885478},17635.216959766971]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I192+J191","v":2443544.0143126287},17715.694103766557]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},2454644.3100367095,17796.171247766142]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2465744.6057607904,17876.648391765728]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2476844.9014848713,17957.125535765317]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},2487945.1972089522,18037.602679764903]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2499045.492933033,18118.079823764489]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2510145.7886571139,18198.556967764074]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},2521246.0843811948,18279.03411176366]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2532346.3801052757,18359.511255763249]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2543446.6758293565,18439.988399762831]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J201+SUM(K190:K201)","v":2759415.0451225378}]
[]
[null,null,null,null,null,null,null,"Year 13"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I206+J202","v":2770515.3408466186},{"$f":"J206*$K$9/12","v":20086.236221137984}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I207+J206","v":2781615.6365706995},20166.71336513757]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I208+J207","v":2792715.9322947804},20247.190509137155]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},2803816.2280188613,20327.667653136745]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2814916.5237429421,20408.144797136327]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2826016.819467023,20488.621941135916]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},2837117.1151911039,20569.099085135502]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2848217.4109151848,20649.576229135087]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2859317.7066392656,20730.053373134677]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},2870418.0023633465,20810.530517134259]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2881518.2980874274,20891.007661133848]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},2892618.5938115083,20971.484805133434]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J217+SUM(K206:K217)","v":3138964.9199691368}]
[]
[null,null,null,null,null,null,null,"Year 14"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I222+J218","v":3150065.2156932177},{"$f":"J222*$K$9/12","v":22837.972813775825}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I223+J222","v":3161165.5114172986},22918.449957775414]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I224+J223","v":3172265.8071413795},22998.927101775]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},3183366.1028654603,23079.404245774585]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3194466.3985895412,23159.881389774175]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3205566.6943136221,23240.35853377376]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},3216666.990037703,23320.835677773342]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3227767.2857617838,23401.312821772928]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3238867.5814858647,23481.789965772517]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},3249967.8772099456,23562.267109772103]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3261068.1729340265,23642.744253771689]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3272168.4686581073,23723.221397771278]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J233+SUM(K222:K233)","v":3551535.63392739}]
[]
[null,null,null,null,null,null,null,"Year 15"]
[null,null,null,null,null,null,null,"Month","Deposit","Balance","Interest"]
[null,null,null,null,null,null,null,"Apr",{"$f":"$F$10","v":11100.295724080675},{"$f":"I238+J234","v":3562635.9296514709},{"$f":"J238*$K$9/12","v":25829.110489973162}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I239+J238","v":3573736.2253755517},25909.587633972751]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},{"$f":"I240+J239","v":3584836.5210996326},25990.064777972337]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},3595936.8168237135,26070.541921971919]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3607037.1125477944,26151.019065971504]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3618137.4082718752,26231.496209971094]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":11100.295724080675},3629237.7039959561,26311.973353970679]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3640337.999720037,26392.450497970265]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3651438.2954441179,26472.927641969854]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":11100.295724080675},3662538.5911681987,26553.40478596944]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3673638.8868922796,26633.881929969026]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":11100.295724080675},3684739.1826163605,26714.359073968615]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J249+SUM(K238:K249)","v":4000000.0000000112}]

{"sheet":"Goal Calculator","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Goal Calculator",null,null,null,null,null,null,null,null,null,null,{"$f":"'PPF Calculator'!F9","v":"Monthly"},null,"Monthly",12]
["Determine the fixed investment need to obtain a certina maturity value",null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(N1:O4,MATCH(L1,N1:N4,0),2)","v":12},null,"Quarterly",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Half-yearly",2]
["Step 1 ","Enter maturity value required",null,null,4000000,"Enter current investment limit",null,null,150000,null,null,null,null,"Annual",1]
[]
["Step 2","Go to PPF Calculator sheet. Select investment frequency and the interest rate"]
[]
["Step 3"]
[]
[]
["Fixed investment amount for the selected is",null,null,null,null,11100.295724080675]
[{"$f":"IF(F11*L2>I4, \"Answer is above investment limit. Choose lower maturity value and repeat step 3\",\"\")","v":""}]

{"sheet":"PPF Tracker","index":2,"n_rows":250,"n_cols":30,"rows_kept":250,"cut":false,"hidden":false,"merged":[[91,9,91,12],[1,3,2,18],[7,4,7,5],[7,16,7,17],[11,9,11,12],[27,9,27,12],[43,9,43,12],[59,9,59,12],[75,9,75,12],[203,9,203,12],[219,9,219,12],[235,9,235,12],[107,9,107,12],[123,9,123,12],[139,9,139,12],[155,9,155,12],[171,9,171,12],[187,9,187,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"before 5th"]
[null,null,null,"PPF Tracker",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"after 5th"]
[]
[null,null,null,null,null,null,null,null,null,"Note: The tracker assumes that the same interest rate is applicable throughout the financial year"]
[null,null,null,null,"Enter data only in green cells",null,null,null,null,"In F.Y.2011-12,2 interest rates were applicable-8% till November 2011 and 8.6% after that.\n"]
[null,null,null,null,null,null,null,null,null,"You will need to make suitable modifications in the interest column cells to reflect this"]
[null,null,null,null,null,null,null,null,null,"Send  me an email if you need help with this"]
[null,null,null,null,null,null,null,null,null,"Balance on March 31st of current year"]
[null,null,null,null,null,null,null,null,null,"Set as zero for new accounts"]
[]
[]
[null,null,null,null,"* For existing account, \"Year 1\"",null,null,null,null,"Year 1*"]
[null,null,null,null,"simply refers to first year of tracking",null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,null,"PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$M$9+IF(H14=\"before 5th\",K14,0)","v":5000},{"$f":"L14*$P$14/12","v":36.249999999999993},null,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,"before 5th",null,"May",5000,{"$f":"SUM($K$14:K14)+$M$9+IF(H15=\"before 5th\",K15,0)","v":10000},{"$f":"L15*$P$14/12","v":72.499999999999986},null,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$14:K15)+$M$9+IF(H16=\"before 5th\",K16,0)","v":15000},108.75,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$14:K16)+$M$9+IF(H17=\"before 5th\",K17,0)","v":20000},144.99999999999997,null,null,{"$f":"IF(SUM(K14:K25)>P16,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$14:K17)+$M$9+IF(H18=\"before 5th\",K18,0)","v":25000},181.25]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$14:K18)+$M$9+IF(H19=\"before 5th\",K19,0)","v":30000},217.5]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$14:K19)+$M$9+IF(H20=\"before 5th\",K20,0)","v":35000},253.75]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$14:K20)+$M$9+IF(H21=\"before 5th\",K21,0)","v":40000},289.99999999999994]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$14:K21)+$M$9+IF(H22=\"before 5th\",K22,0)","v":45000},326.24999999999994]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$14:K22)+$M$9+IF(H23=\"before 5th\",K23,0)","v":50000},362.5]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$14:K23)+$M$9+IF(H24=\"before 5th\",K24,0)","v":55000},398.75]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$14:K24)+$M$9+IF(H25=\"before 5th\",K25,0)","v":60000},435]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K14:K25)+SUM(M14:M25)+M9","v":62827.5}]
[]
[null,null,null,null,null,null,null,null,null,"Year 2"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,null,"PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$26+IF(H30=\"before 5th\",K30,0)","v":67827.5},{"$f":"L30*$P$30/12","v":491.74937499999993},null,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,"before 5th",null,"May",5000,{"$f":"SUM($K$30:K30)+$L$26+IF(H31=\"before 5th\",K31,0)","v":72827.5},{"$f":"L31*$P$30/12","v":527.99937499999999},null,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$30:K31)+$L$26+IF(H32=\"before 5th\",K32,0)","v":77827.5},564.24937499999999,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$30:K32)+$L$26+IF(H33=\"before 5th\",K33,0)","v":82827.5},600.49937499999999,null,null,{"$f":"IF(SUM(K30:K41)>P32,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$30:K33)+$L$26+IF(H34=\"before 5th\",K34,0)","v":87827.5},636.74937499999999]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$30:K34)+$L$26+IF(H35=\"before 5th\",K35,0)","v":92827.5},672.99937499999999]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$30:K35)+$L$26+IF(H36=\"before 5th\",K36,0)","v":97827.5},709.24937499999999]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$30:K36)+$L$26+IF(H37=\"before 5th\",K37,0)","v":102827.5},745.49937499999999]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$30:K37)+$L$26+IF(H38=\"before 5th\",K38,0)","v":107827.5},781.74937499999987]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$30:K38)+$L$26+IF(H39=\"before 5th\",K39,0)","v":112827.5},817.99937499999987]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$30:K39)+$L$26+IF(H40=\"before 5th\",K40,0)","v":117827.5},854.24937499999987]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$30:K40)+$L$26+IF(H41=\"before 5th\",K41,0)","v":122827.5},890.49937499999987]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K30:K41)+SUM(M30:M41)+L26","v":131120.99249999999}]
[]
[null,null,null,{"$f":"IF($M$9=0,\"Loan available for new accounts\",\"\")","v":"Loan available for new accounts"},null,null,null,null,null,"Year 3"]
[null,null,null,{"$f":"IF($M$9=0,\"Loan amount available\",\"\")","v":"Loan amount available"},null,{"$f":"IF($M$9=0,25%*L26,\"\")","v":15706.875},null,"Deposited",null,"Month","Deposit","Balance","Interest",null,null,"PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$42+IF(H46=\"before 5th\",K46,0)","v":136120.99249999999},{"$f":"L46*$P$46/12","v":986.8771956249999},null,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,"before 5th",null,"May",5000,{"$f":"SUM($K$46:K46)+$L$42+IF(H47=\"before 5th\",K47,0)","v":141120.99249999999},{"$f":"L47*$P$46/12","v":1023.1271956249999},null,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$46:K47)+$L$42+IF(H48=\"before 5th\",K48,0)","v":146120.99249999999},1059.377195625,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$46:K48)+$L$42+IF(H49=\"before 5th\",K49,0)","v":151120.99249999999},1095.627195625,null,null,{"$f":"IF(SUM(K46:K57)>P48,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$46:K49)+$L$42+IF(H50=\"before 5th\",K50,0)","v":156120.99249999999},1131.877195625]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$46:K50)+$L$42+IF(H51=\"before 5th\",K51,0)","v":161120.99249999999},1168.127195625]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$46:K51)+$L$42+IF(H52=\"before 5th\",K52,0)","v":166120.99249999999},1204.377195625]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$46:K52)+$L$42+IF(H53=\"before 5th\",K53,0)","v":171120.99249999999},1240.627195625]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$46:K53)+$L$42+IF(H54=\"before 5th\",K54,0)","v":176120.99249999999},1276.8771956249998]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$46:K54)+$L$42+IF(H55=\"before 5th\",K55,0)","v":181120.99249999999},1313.1271956249998]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$46:K55)+$L$42+IF(H56=\"before 5th\",K56,0)","v":186120.99249999999},1349.3771956249998]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$46:K56)+$L$42+IF(H57=\"before 5th\",K57,0)","v":191120.99249999999},1385.627195625]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K46:K57)+SUM(M46:M57)+L42","v":205356.01884749997}]
[]
[null,null,null,{"$f":"IF($M$9=0,\"Loan available for new accounts\",\"\")","v":"Loan available for new accounts"},null,null,null,null,null,"Year 4"]
[null,null,null,{"$f":"IF($M$9=0,\"Loan amount available\",\"\")","v":"Loan amount available"},null,{"$f":"IF($M$9=0,25%*L42,\"\")","v":32780.248124999998},null,"Deposited",null,"Month","Deposit","Balance","Interest",null,null,"PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$58+IF(H62=\"before 5th\",K62,0)","v":210356.01884749997},{"$f":"L62*$P$62/12","v":1525.0811366443747},null,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,"before 5th",null,"May",5000,{"$f":"SUM($K$62:K62)+$L$58+IF(H63=\"before 5th\",K63,0)","v":215356.01884749997},{"$f":"L63*$P$62/12","v":1561.3311366443747},null,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$62:K63)+$L$58+IF(H64=\"before 5th\",K64,0)","v":220356.01884749997},1597.5811366443747,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$62:K64)+$L$58+IF(H65=\"before 5th\",K65,0)","v":225356.01884749997},1633.8311366443747,null,null,{"$f":"IF(SUM(K62:K73)>P64,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$62:K65)+$L$58+IF(H66=\"before 5th\",K66,0)","v":230356.01884749997},1670.0811366443747]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$62:K66)+$L$58+IF(H67=\"before 5th\",K67,0)","v":235356.01884749997},1706.3311366443747]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$62:K67)+$L$58+IF(H68=\"before 5th\",K68,0)","v":240356.01884749997},1742.5811366443747]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$62:K68)+$L$58+IF(H69=\"before 5th\",K69,0)","v":245356.01884749997},1778.8311366443747]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$62:K69)+$L$58+IF(H70=\"before 5th\",K70,0)","v":250356.01884749997},1815.0811366443747]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$62:K70)+$L$58+IF(H71=\"before 5th\",K71,0)","v":255356.01884749997},1851.3311366443747]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$62:K71)+$L$58+IF(H72=\"before 5th\",K72,0)","v":260356.01884749997},1887.5811366443747]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$62:K72)+$L$58+IF(H73=\"before 5th\",K73,0)","v":265356.01884749997},1923.8311366443747]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K62:K73)+SUM(M62:M73)+L58","v":286049.49248723243}]
[]
[null,null,null,{"$f":"IF($M$9=0,\"Loan available for new accounts\",\"\")","v":"Loan available for new accounts"},null,null,null,null,null,"Year 5"]
[null,null,null,{"$f":"IF($M$9=0,\"Loan amount available\",\"\")","v":"Loan amount available"},null,{"$f":"IF($M$9=0,25%*L58,\"\")","v":51339.004711874994},null,"Deposited",null,"Month","Deposit","Balance","Interest",null,null,"PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$74+IF(H78=\"before 5th\",K78,0)","v":291049.49248723243},{"$f":"L78*$P$78/12","v":2110.1088205324349},null,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,"before 5th",null,"May",5000,{"$f":"SUM($K$78:K78)+$L$74+IF(H79=\"before 5th\",K79,0)","v":296049.49248723243},{"$f":"L79*$P$78/12","v":2146.3588205324349},null,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$78:K79)+$L$74+IF(H80=\"before 5th\",K80,0)","v":301049.49248723243},2182.6088205324349,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$78:K80)+$L$74+IF(H81=\"before 5th\",K81,0)","v":306049.49248723243},2218.8588205324349,null,null,{"$f":"IF(SUM(K78:K89)>P80,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$78:K81)+$L$74+IF(H82=\"before 5th\",K82,0)","v":311049.49248723243},2255.1088205324349]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$78:K82)+$L$74+IF(H83=\"before 5th\",K83,0)","v":316049.49248723243},2291.3588205324349]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$78:K83)+$L$74+IF(H84=\"before 5th\",K84,0)","v":321049.49248723243},2327.6088205324349]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$78:K84)+$L$74+IF(H85=\"before 5th\",K85,0)","v":326049.49248723243},2363.8588205324349]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$78:K85)+$L$74+IF(H86=\"before 5th\",K86,0)","v":331049.49248723243},2400.1088205324349]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$78:K86)+$L$74+IF(H87=\"before 5th\",K87,0)","v":336049.49248723243},2436.3588205324349]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$78:K87)+$L$74+IF(H88=\"before 5th\",K88,0)","v":341049.49248723243},2472.6088205324349]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$78:K88)+$L$74+IF(H89=\"before 5th\",K89,0)","v":346049.49248723243},2508.8588205324349]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K78:K89)+SUM(M78:M89)+L74","v":373763.29833362164}]
[]
[null,null,null,{"$f":"IF($M$9=0,\"Loan available for new accounts\",\"\")","v":"Loan available for new accounts"},null,null,null,null,null,"Year 6"]
[null,null,null,{"$f":"IF($M$9=0,\"Loan amount available\",\"\")","v":"Loan amount available"},null,{"$f":"IF($M$9=0,25%*L74,\"\")","v":71512.373121808108},null,"Deposited",null,"Month","Deposit","Balance","Interest",null,null,"PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$90+IF(H94=\"before 5th\",K94,0)","v":378763.29833362164},{"$f":"L94*$P$94/12","v":2746.0339129187564},null,null,8.6999999999999994E-2]
[null,null,null,null,null,null,null,"before 5th",null,"May",5000,{"$f":"SUM($K$94:K94)+$L$90+IF(H95=\"before 5th\",K95,0)","v":383763.29833362164},{"$f":"L95*$P$94/12","v":2782.2839129187564},null,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$94:K95)+$L$90+IF(H96=\"before 5th\",K96,0)","v":388763.29833362164},2818.5339129187564,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$94:K96)+$L$90+IF(H97=\"before 5th\",K97,0)","v":393763.29833362164},2854.7839129187564,null,null,{"$f":"IF(SUM(K94:K105)>P96,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$94:K97)+$L$90+IF(H98=\"before 5th\",K98,0)","v":398763.29833362164},2891.0339129187564]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$94:K98)+$L$90+IF(H99=\"before 5th\",K99,0)","v":403763.29833362164},2927.2839129187564]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$94:K99)+$L$90+IF(H100=\"before 5th\",K100,0)","v":408763.29833362164},2963.5339129187564]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$94:K100)+$L$90+IF(H101=\"before 5th\",K101,0)","v":413763.29833362164},2999.7839129187564]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$94:K101)+$L$90+IF(H102=\"before 5th\",K102,0)","v":418763.29833362164},3036.0339129187564]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$94:K102)+$L$90+IF(H103=\"before 5th\",K103,0)","v":423763.29833362164},3072.2839129187564]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$94:K103)+$L$90+IF(H104=\"before 5th\",K104,0)","v":428763.29833362164},3108.5339129187564]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$94:K104)+$L$90+IF(H105=\"before 5th\",K105,0)","v":433763.29833362164},3144.7839129187564]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K94:K105)+SUM(M94:M105)+L90","v":469108.20528864674}]
[]
[null,null,null,null,null,null,null,null,null,"Year 7",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$106+IF(H110=\"before 5th\",K110,0)","v":474108.20528864674},{"$f":"L110*$P$110/12","v":3437.2844883426883},{"$f":"IF(O110=MAX($O$110:$O$121),O110,IF(N109=MAX($O$110:$O$121),N109,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L106,L58),\"\")","v":102678.00942374999},null,"before 5th",null,"May",5000,{"$f":"SUM($K$110:K110)+$L$106+IF(H111=\"before 5th\",K111,0)","v":479108.20528864674},{"$f":"L111*$P$110/12","v":3473.5344883426883},0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$110:K111)+$L$106+IF(H112=\"before 5th\",K112,0)","v":484108.20528864674},3509.7844883426883,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$110:K112)+$L$106+IF(H113=\"before 5th\",K113,0)","v":489108.20528864674},3546.0344883426883,0,null,{"$f":"IF(SUM(K110:K121)>P112,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$110:K113)+$L$106+IF(H114=\"before 5th\",K114,0)","v":494108.20528864674},3582.2844883426883,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$110:K114)+$L$106+IF(H115=\"before 5th\",K115,0)","v":499108.20528864674},3618.5344883426883,0,null,{"$f":"IF(N122>F111,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$110:K115)+$L$106+IF(H116=\"before 5th\",K116,0)","v":504108.20528864674},3654.7844883426883,{"$f":"IF(O116=MAX($O$110:$O$121),O116,IF(N115=MAX($O$110:$O$121),N115,0))","v":0}]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$110:K116)+$L$106+IF(H117=\"before 5th\",K117,0)","v":509108.20528864674},3691.0344883426883,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$110:K117)+$L$106+IF(H118=\"before 5th\",K118,0)","v":514108.20528864674},3727.2844883426883,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$110:K118)+$L$106+IF(H119=\"before 5th\",K119,0)","v":519108.20528864674},3763.5344883426883,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$110:K119)+$L$106+IF(H120=\"before 5th\",K120,0)","v":524108.20528864674},3799.7844883426883,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$110:K120)+$L$106+IF(H121=\"before 5th\",K121,0)","v":529108.20528864674},3836.0344883426883,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K110:K121)+SUM(M110:M121)+L106-N122","v":572748.11914875894},null,{"$f":"MAX(O110:O121)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 8",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$122+IF(H126=\"before 5th\",K126,0)","v":577748.11914875894},{"$f":"L126*$P$126/12","v":4188.6738638285015},{"$f":"IF(O126=MAX($O$126:$O$137),O126,IF(N125=MAX($O$126:$O$137),N125,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L122,L74),\"\")","v":143024.74624361622},null,"before 5th",null,"May",5000,{"$f":"SUM($K$126:K126)+$L$122+IF(H127=\"before 5th\",K127,0)","v":582748.11914875894},{"$f":"L127*$P$126/12","v":4224.9238638285015},{"$f":"IF(O127=MAX($O$126:$O$137),O127,IF(N126=MAX($O$126:$O$137),N126,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$126:K127)+$L$122+IF(H128=\"before 5th\",K128,0)","v":587748.11914875894},4261.1738638285015,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$126:K128)+$L$122+IF(H129=\"before 5th\",K129,0)","v":592748.11914875894},4297.4238638285015,0,null,{"$f":"IF(SUM(K126:K137)>P128,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$126:K129)+$L$122+IF(H130=\"before 5th\",K130,0)","v":597748.11914875894},4333.6738638285015,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$126:K130)+$L$122+IF(H131=\"before 5th\",K131,0)","v":602748.11914875894},4369.9238638285015,0,null,{"$f":"IF(N138>F127,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$126:K131)+$L$122+IF(H132=\"before 5th\",K132,0)","v":607748.11914875894},4406.1738638285015,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$126:K132)+$L$122+IF(H133=\"before 5th\",K133,0)","v":612748.11914875894},4442.4238638285015,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$126:K133)+$L$122+IF(H134=\"before 5th\",K134,0)","v":617748.11914875894},4478.6738638285015,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$126:K134)+$L$122+IF(H135=\"before 5th\",K135,0)","v":622748.11914875894},4514.9238638285015,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$126:K135)+$L$122+IF(H136=\"before 5th\",K136,0)","v":627748.11914875894},4551.1738638285015,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$126:K136)+$L$122+IF(H137=\"before 5th\",K137,0)","v":632748.11914875894},4587.4238638285015,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K126:K137)+SUM(M126:M137)+L122-N138","v":685404.70551470097},null,{"$f":"MAX(O126:O137)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 9",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$138+IF(H142=\"before 5th\",K142,0)","v":690404.70551470097},{"$f":"L142*$P$142/12","v":5005.4341149815818},{"$f":"IF(O142=MAX($O$142:$O$153),O142,IF(N141=MAX($O$142:$O$153),N141,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L138,L90),\"\")","v":186881.64916681082},null,"before 5th",null,"May",5000,{"$f":"SUM($K$142:K142)+$L$138+IF(H143=\"before 5th\",K143,0)","v":695404.70551470097},{"$f":"L143*$P$142/12","v":5041.6841149815818},{"$f":"IF(O143=MAX($O$142:$O$153),O143,IF(N142=MAX($O$142:$O$153),N142,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$142:K143)+$L$138+IF(H144=\"before 5th\",K144,0)","v":700404.70551470097},5077.9341149815818,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$142:K144)+$L$138+IF(H145=\"before 5th\",K145,0)","v":705404.70551470097},5114.1841149815818,0,null,{"$f":"IF(SUM(K142:K153)>P144,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$142:K145)+$L$138+IF(H146=\"before 5th\",K146,0)","v":710404.70551470097},5150.4341149815818,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$142:K146)+$L$138+IF(H147=\"before 5th\",K147,0)","v":715404.70551470097},5186.6841149815818,0,null,{"$f":"IF(N154>F143,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$142:K147)+$L$138+IF(H148=\"before 5th\",K148,0)","v":720404.70551470097},5222.9341149815818,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$142:K148)+$L$138+IF(H149=\"before 5th\",K149,0)","v":725404.70551470097},5259.1841149815818,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$142:K149)+$L$138+IF(H150=\"before 5th\",K150,0)","v":730404.70551470097},5295.4341149815818,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$142:K150)+$L$138+IF(H151=\"before 5th\",K151,0)","v":735404.70551470097},5331.6841149815818,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$142:K151)+$L$138+IF(H152=\"before 5th\",K152,0)","v":740404.70551470097},5367.9341149815818,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$142:K152)+$L$138+IF(H153=\"before 5th\",K153,0)","v":745404.70551470097},5404.1841149815818,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K142:K153)+SUM(M142:M153)+L138-N154","v":807862.41489447991},null,{"$f":"MAX(O142:O153)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 10",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$154+IF(H158=\"before 5th\",K158,0)","v":812862.41489447991},{"$f":"L158*$P$158/12","v":5893.2525079849793},{"$f":"IF(O158=MAX($O$158:$O$169),O158,IF(N157=MAX($O$158:$O$169),N157,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L154,L106),\"\")","v":234554.10264432337},null,"before 5th",null,"May",5000,{"$f":"SUM($K$158:K158)+$L$154+IF(H159=\"before 5th\",K159,0)","v":817862.41489447991},{"$f":"L159*$P$158/12","v":5929.5025079849793},{"$f":"IF(O159=MAX($O$158:$O$169),O159,IF(N158=MAX($O$158:$O$169),N158,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$158:K159)+$L$154+IF(H160=\"before 5th\",K160,0)","v":822862.41489447991},5965.7525079849793,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$158:K160)+$L$154+IF(H161=\"before 5th\",K161,0)","v":827862.41489447991},6002.0025079849793,0,null,{"$f":"IF(SUM(K158:K169)>P160,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$158:K161)+$L$154+IF(H162=\"before 5th\",K162,0)","v":832862.41489447991},6038.2525079849793,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$158:K162)+$L$154+IF(H163=\"before 5th\",K163,0)","v":837862.41489447991},6074.5025079849793,0,null,{"$f":"IF(N170>F159,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$158:K163)+$L$154+IF(H164=\"before 5th\",K164,0)","v":842862.41489447991},6110.7525079849793,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$158:K164)+$L$154+IF(H165=\"before 5th\",K165,0)","v":847862.41489447991},6147.0025079849793,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$158:K165)+$L$154+IF(H166=\"before 5th\",K166,0)","v":852862.41489447991},6183.2525079849793,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$158:K166)+$L$154+IF(H167=\"before 5th\",K167,0)","v":857862.41489447991},6219.5025079849793,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$158:K167)+$L$154+IF(H168=\"before 5th\",K168,0)","v":862862.41489447991},6255.7525079849793,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$158:K168)+$L$154+IF(H169=\"before 5th\",K169,0)","v":867862.41489447991},6292.0025079849793,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K158:K169)+SUM(M158:M169)+L154-N170","v":940973.94499029964},null,{"$f":"MAX(O158:O169)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 11",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$170+IF(H174=\"before 5th\",K174,0)","v":945973.94499029964},{"$f":"L174*$P$174/12","v":6858.3111011796718},{"$f":"IF(O174=MAX($O$174:$O$185),O174,IF(N173=MAX($O$174:$O$185),N173,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L170,L122),\"\")","v":286374.05957437947},null,"before 5th",null,"May",5000,{"$f":"SUM($K$174:K174)+$L$170+IF(H175=\"before 5th\",K175,0)","v":950973.94499029964},{"$f":"L175*$P$174/12","v":6894.5611011796718},{"$f":"IF(O175=MAX($O$174:$O$185),O175,IF(N174=MAX($O$174:$O$185),N174,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$174:K175)+$L$170+IF(H176=\"before 5th\",K176,0)","v":955973.94499029964},6930.8111011796718,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$174:K176)+$L$170+IF(H177=\"before 5th\",K177,0)","v":960973.94499029964},6967.0611011796718,0,null,{"$f":"IF(SUM(K174:K185)>P176,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$174:K177)+$L$170+IF(H178=\"before 5th\",K178,0)","v":965973.94499029964},7003.3111011796718,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$174:K178)+$L$170+IF(H179=\"before 5th\",K179,0)","v":970973.94499029964},7039.5611011796718,0,null,{"$f":"IF(N186>F175,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$174:K179)+$L$170+IF(H180=\"before 5th\",K180,0)","v":975973.94499029964},7075.8111011796718,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$174:K180)+$L$170+IF(H181=\"before 5th\",K181,0)","v":980973.94499029964},7112.0611011796718,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$174:K181)+$L$170+IF(H182=\"before 5th\",K182,0)","v":985973.94499029964},7148.3111011796718,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$174:K182)+$L$170+IF(H183=\"before 5th\",K183,0)","v":990973.94499029964},7184.5611011796718,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$174:K183)+$L$170+IF(H184=\"before 5th\",K184,0)","v":995973.94499029964},7220.8111011796718,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$174:K184)+$L$170+IF(H185=\"before 5th\",K185,0)","v":1000973.9449902996},7257.0611011796718,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K174:K185)+SUM(M174:M185)+L170-N186","v":1085666.1782044556},null,{"$f":"MAX(O174:O185)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 12",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$186+IF(H190=\"before 5th\",K190,0)","v":1090666.1782044556},{"$f":"L190*$P$190/12","v":7907.3297919823026},{"$f":"IF(O190=MAX($O$190:$O$201),O190,IF(N189=MAX($O$190:$O$201),N189,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L186,L138),\"\")","v":342702.35275735048},null,"before 5th",null,"May",5000,{"$f":"SUM($K$190:K190)+$L$186+IF(H191=\"before 5th\",K191,0)","v":1095666.1782044556},{"$f":"L191*$P$190/12","v":7943.5797919823026},{"$f":"IF(O191=MAX($O$190:$O$201),O191,IF(N190=MAX($O$190:$O$201),N190,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$190:K191)+$L$186+IF(H192=\"before 5th\",K192,0)","v":1100666.1782044556},7979.8297919823026,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$190:K192)+$L$186+IF(H193=\"before 5th\",K193,0)","v":1105666.1782044556},8016.0797919823026,0,null,{"$f":"IF(SUM(K190:K201)>P192,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$190:K193)+$L$186+IF(H194=\"before 5th\",K194,0)","v":1110666.1782044556},8052.3297919823026,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$190:K194)+$L$186+IF(H195=\"before 5th\",K195,0)","v":1115666.1782044556},8088.5797919823026,0,null,{"$f":"IF(N202>F191,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$190:K195)+$L$186+IF(H196=\"before 5th\",K196,0)","v":1120666.1782044556},8124.8297919823026,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$190:K196)+$L$186+IF(H197=\"before 5th\",K197,0)","v":1125666.1782044556},8161.0797919823026,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$190:K197)+$L$186+IF(H198=\"before 5th\",K198,0)","v":1130666.1782044556},8197.3297919823035,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$190:K198)+$L$186+IF(H199=\"before 5th\",K199,0)","v":1135666.1782044556},8233.5797919823035,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$190:K199)+$L$186+IF(H200=\"before 5th\",K200,0)","v":1140666.1782044556},8269.8297919823035,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$190:K200)+$L$186+IF(H201=\"before 5th\",K201,0)","v":1145666.1782044556},8306.0797919823035,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K190:K201)+SUM(M190:M201)+L186-N202","v":1242946.6357082434},null,{"$f":"MAX(O190:O201)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 13",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$202+IF(H206=\"before 5th\",K206,0)","v":1247946.6357082434},{"$f":"L206*$P$206/12","v":9047.6131088847633},{"$f":"IF(O206=MAX($O$206:$O$217),O206,IF(N205=MAX($O$206:$O$217),N205,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L202,L154),\"\")","v":403931.20744723995},null,"before 5th",null,"May",5000,{"$f":"SUM($K$206:K206)+$L$202+IF(H207=\"before 5th\",K207,0)","v":1252946.6357082434},{"$f":"L207*$P$206/12","v":9083.8631088847633},{"$f":"IF(O207=MAX($O$206:$O$217),O207,IF(N206=MAX($O$206:$O$217),N206,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$206:K207)+$L$202+IF(H208=\"before 5th\",K208,0)","v":1257946.6357082434},9120.1131088847633,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$206:K208)+$L$202+IF(H209=\"before 5th\",K209,0)","v":1262946.6357082434},9156.3631088847633,0,null,{"$f":"IF(SUM(K206:K217)>P208,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$206:K209)+$L$202+IF(H210=\"before 5th\",K210,0)","v":1267946.6357082434},9192.6131088847633,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$206:K210)+$L$202+IF(H211=\"before 5th\",K211,0)","v":1272946.6357082434},9228.8631088847633,0,null,{"$f":"IF(N218>F207,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$206:K211)+$L$202+IF(H212=\"before 5th\",K212,0)","v":1277946.6357082434},9265.1131088847633,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$206:K212)+$L$202+IF(H213=\"before 5th\",K213,0)","v":1282946.6357082434},9301.3631088847633,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$206:K213)+$L$202+IF(H214=\"before 5th\",K214,0)","v":1287946.6357082434},9337.6131088847633,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$206:K214)+$L$202+IF(H215=\"before 5th\",K215,0)","v":1292946.6357082434},9373.8631088847633,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$206:K215)+$L$202+IF(H216=\"before 5th\",K216,0)","v":1297946.6357082434},9410.1131088847633,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$206:K216)+$L$202+IF(H217=\"before 5th\",K217,0)","v":1302946.6357082434},9446.3631088847633,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K206:K217)+SUM(M206:M217)+L202-N218","v":1413910.4930148604},null,{"$f":"MAX(O206:O217)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 14",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$218+IF(H222=\"before 5th\",K222,0)","v":1418910.4930148604},{"$f":"L222*$P$222/12","v":10287.101074357737},{"$f":"IF(O222=MAX($O$222:$O$233),O222,IF(N221=MAX($O$222:$O$233),N221,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L218,L170),\"\")","v":470486.97249514982},null,"before 5th",null,"May",5000,{"$f":"SUM($K$222:K222)+$L$218+IF(H223=\"before 5th\",K223,0)","v":1423910.4930148604},{"$f":"L223*$P$222/12","v":10323.351074357737},{"$f":"IF(O223=MAX($O$222:$O$233),O223,IF(N222=MAX($O$222:$O$233),N222,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$222:K223)+$L$218+IF(H224=\"before 5th\",K224,0)","v":1428910.4930148604},10359.601074357737,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$222:K224)+$L$218+IF(H225=\"before 5th\",K225,0)","v":1433910.4930148604},10395.851074357737,0,null,{"$f":"IF(SUM(K222:K233)>P224,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$222:K225)+$L$218+IF(H226=\"before 5th\",K226,0)","v":1438910.4930148604},10432.101074357737,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$222:K226)+$L$218+IF(H227=\"before 5th\",K227,0)","v":1443910.4930148604},10468.351074357737,0,null,{"$f":"IF(N234>F223,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$222:K227)+$L$218+IF(H228=\"before 5th\",K228,0)","v":1448910.4930148604},10504.601074357737,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$222:K228)+$L$218+IF(H229=\"before 5th\",K229,0)","v":1453910.4930148604},10540.851074357737,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$222:K229)+$L$218+IF(H230=\"before 5th\",K230,0)","v":1458910.4930148604},10577.101074357737,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$222:K230)+$L$218+IF(H231=\"before 5th\",K231,0)","v":1463910.4930148604},10613.351074357737,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$222:K231)+$L$218+IF(H232=\"before 5th\",K232,0)","v":1468910.4930148604},10649.601074357737,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$222:K232)+$L$218+IF(H233=\"before 5th\",K233,0)","v":1473910.4930148604},10685.851074357737,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K222:K233)+SUM(M222:M233)+L218-N234","v":1599748.2059071532},null,{"$f":"MAX(O222:O233)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Year 15",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$234+IF(H238=\"before 5th\",K238,0)","v":1604748.2059071532},{"$f":"L238*$P$238/12","v":11634.42449282686},{"$f":"IF(O238=MAX($O$238:$O$249),O238,IF(N237=MAX($O$238:$O$249),N237,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"IF($M$9=0,50%*MIN(L234,L186),\"\")","v":542833.08910222782},null,"before 5th",null,"May",5000,{"$f":"SUM($K$238:K238)+$L$234+IF(H239=\"before 5th\",K239,0)","v":1609748.2059071532},{"$f":"L239*$P$238/12","v":11670.67449282686},{"$f":"IF(O239=MAX($O$238:$O$249),O239,IF(N238=MAX($O$238:$O$249),N238,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$238:K239)+$L$234+IF(H240=\"before 5th\",K240,0)","v":1614748.2059071532},11706.92449282686,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$238:K240)+$L$234+IF(H241=\"before 5th\",K241,0)","v":1619748.2059071532},11743.17449282686,0,null,{"$f":"IF(SUM(K238:K249)>P240,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$238:K241)+$L$234+IF(H242=\"before 5th\",K242,0)","v":1624748.2059071532},11779.42449282686,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$238:K242)+$L$234+IF(H243=\"before 5th\",K243,0)","v":1629748.2059071532},11815.67449282686,0,null,{"$f":"IF(N250>F239,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$238:K243)+$L$234+IF(H244=\"before 5th\",K244,0)","v":1634748.2059071532},11851.92449282686,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$238:K244)+$L$234+IF(H245=\"before 5th\",K245,0)","v":1639748.2059071532},11888.17449282686,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$238:K245)+$L$234+IF(H246=\"before 5th\",K246,0)","v":1644748.2059071532},11924.42449282686,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$238:K246)+$L$234+IF(H247=\"before 5th\",K247,0)","v":1649748.2059071532},11960.67449282686,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$238:K247)+$L$234+IF(H248=\"before 5th\",K248,0)","v":1654748.2059071532},11996.92449282686,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$238:K248)+$L$234+IF(H249=\"before 5th\",K249,0)","v":1659748.2059071532},12033.17449282686,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K238:K249)+SUM(M238:M249)+L234-N250","v":1801753.7998210755},null,{"$f":"MAX(O238:O249)","v":0}]

{"sheet":"Post 15 yearsTracker ","index":3,"n_rows":171,"n_cols":30,"rows_kept":171,"cut":false,"hidden":false,"merged":[[60,9,60,12],[156,9,156,12],[76,9,76,12],[92,9,92,12],[108,9,108,12],[124,9,124,12],[140,9,140,12],[1,3,2,18],[7,4,7,5],[7,16,7,17],[12,9,12,12],[28,9,28,12],[44,9,44,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"before 5th"]
[null,null,null,"Use this sheet to track your PPF if you have extended it at the end of the 15 year period",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"after 5th"]
[]
[null,null,null,null,null,null,null,null,null,"Note: The tracker assumes that the same interest rate is applicable throughout the financial year"]
[null,null,null,null,"Enter data only in green cells",null,null,null,null,"In F.Y.2011-12,2 interest rates were applicable-8% till November 2011 and 8.6% after that.\n"]
[null,null,null,null,null,null,null,null,null,"You will need to make suitable modifications in the interest column cells to reflect this"]
[null,null,null,null,null,null,null,null,null,"Send  me an email if you need help with this"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Balance at the start of 5Y extension block"]
[null,null,null,null,null,null,null,null,null,null,null,469108]
[]
[null,null,null,null,null,null,null,null,null,"1st Extension Year 1",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$11+IF(H15=\"before 5th\",K15,0)","v":474108},{"$f":"L15*$P$15/12","v":3437.2829999999999},{"$f":"IF(O15=MAX($O$15:$O$26),O15,IF(N14=MAX($O$15:$O$26),N14,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$11","v":281464.8},null,"before 5th",null,"May",5000,{"$f":"SUM($K$15:K15)+$L$11+IF(H16=\"before 5th\",K16,0)","v":479108},3473.5329999999999,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$15:K16)+$L$11+IF(H17=\"before 5th\",K17,0)","v":484108},3509.7829999999999,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$15:K17)+$L$11+IF(H18=\"before 5th\",K18,0)","v":489108},3546.0329999999999,0,null,{"$f":"IF(SUM(K15:K26)>P17,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$15:K18)+$L$11+IF(H19=\"before 5th\",K19,0)","v":494108},3582.2829999999999,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$15:K19)+$L$11+IF(H20=\"before 5th\",K20,0)","v":499108},3618.5329999999999,0,null,{"$f":"IF(N27>F16,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$15:K20)+$L$11+IF(H21=\"before 5th\",K21,0)","v":504108},3654.7829999999994,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$15:K21)+$L$11+IF(H22=\"before 5th\",K22,0)","v":509108},3691.0329999999994,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$15:K22)+$L$11+IF(H23=\"before 5th\",K23,0)","v":514108},3727.2829999999994,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$15:K23)+$L$11+IF(H24=\"before 5th\",K24,0)","v":519108},3763.5329999999994,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$15:K24)+$L$11+IF(H25=\"before 5th\",K25,0)","v":524108},3799.7829999999994,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$15:K25)+$L$11+IF(H26=\"before 5th\",K26,0)","v":529108},3836.0329999999994,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K15:K26)+SUM(M15:M26)+L11-N27","v":572747.89599999995},null,{"$f":"MAX(O15:O26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"1st Extension Year 2",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$27+IF(H31=\"before 5th\",K31,0)","v":577747.89599999995},{"$f":"L31*$P$31/12","v":4188.6722459999992},{"$f":"IF(O31=MAX($O$31:$O$42),O31,IF(N30=MAX($O$31:$O$42),N30,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$11","v":281464.8},null,"before 5th",null,"May",5000,{"$f":"SUM($K$31:K31)+$L$27+IF(H32=\"before 5th\",K32,0)","v":582747.89599999995},4224.9222459999992,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$31:K32)+$L$27+IF(H33=\"before 5th\",K33,0)","v":587747.89599999995},4261.1722459999992,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$31:K33)+$L$27+IF(H34=\"before 5th\",K34,0)","v":592747.89599999995},4297.4222459999992,0,null,{"$f":"IF(SUM(K31:K42)>P33,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$31:K34)+$L$27+IF(H35=\"before 5th\",K35,0)","v":597747.89599999995},4333.6722459999992,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$31:K35)+$L$27+IF(H36=\"before 5th\",K36,0)","v":602747.89599999995},4369.9222459999992,0,null,{"$f":"IF(N43>F32,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$31:K36)+$L$27+IF(H37=\"before 5th\",K37,0)","v":607747.89599999995},4406.1722459999992,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$31:K37)+$L$27+IF(H38=\"before 5th\",K38,0)","v":612747.89599999995},4442.4222459999992,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$31:K38)+$L$27+IF(H39=\"before 5th\",K39,0)","v":617747.89599999995},4478.6722459999992,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$31:K39)+$L$27+IF(H40=\"before 5th\",K40,0)","v":622747.89599999995},4514.9222459999992,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$31:K40)+$L$27+IF(H41=\"before 5th\",K41,0)","v":627747.89599999995},4551.1722459999992,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$31:K41)+$L$27+IF(H42=\"before 5th\",K42,0)","v":632747.89599999995},4587.4222459999992,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K31:K42)+SUM(M31:M42)+L27-N43","v":685404.46295199997},null,{"$f":"MAX(O31:O42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"1st Extension Year 3",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$43+IF(H47=\"before 5th\",K47,0)","v":690404.46295199997},{"$f":"L47*$P$47/12","v":5005.4323564019996},{"$f":"IF(O47=MAX($O$47:$O$58),O47,IF(N46=MAX($O$47:$O$58),N46,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$11","v":281464.8},null,"before 5th",null,"May",5000,{"$f":"SUM($K$47:K47)+$L$43+IF(H48=\"before 5th\",K48,0)","v":695404.46295199997},5041.6823564019996,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$47:K48)+$L$43+IF(H49=\"before 5th\",K49,0)","v":700404.46295199997},5077.9323564019996,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$47:K49)+$L$43+IF(H50=\"before 5th\",K50,0)","v":705404.46295199997},5114.1823564019996,0,null,{"$f":"IF(SUM(K47:K58)>P49,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$47:K50)+$L$43+IF(H51=\"before 5th\",K51,0)","v":710404.46295199997},5150.4323564019996,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$47:K51)+$L$43+IF(H52=\"before 5th\",K52,0)","v":715404.46295199997},5186.6823564019996,0,null,{"$f":"IF(N59>F48,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$47:K52)+$L$43+IF(H53=\"before 5th\",K53,0)","v":720404.46295199997},5222.9323564019996,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$47:K53)+$L$43+IF(H54=\"before 5th\",K54,0)","v":725404.46295199997},5259.1823564019996,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$47:K54)+$L$43+IF(H55=\"before 5th\",K55,0)","v":730404.46295199997},5295.4323564019996,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$47:K55)+$L$43+IF(H56=\"before 5th\",K56,0)","v":735404.46295199997},5331.6823564019996,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$47:K56)+$L$43+IF(H57=\"before 5th\",K57,0)","v":740404.46295199997},5367.9323564019996,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$47:K57)+$L$43+IF(H58=\"before 5th\",K58,0)","v":745404.46295199997},5404.1823564019996,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K47:K58)+SUM(M47:M58)+L43-N59","v":807862.15122882393},null,{"$f":"MAX(O47:O58)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"1st Extension Year 4",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$59+IF(H63=\"before 5th\",K63,0)","v":812862.15122882393},{"$f":"L63*$P$63/12","v":5893.2505964089733},{"$f":"IF(O63=MAX($O$63:$O$74),O63,IF(N62=MAX($O$63:$O$74),N62,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$11","v":281464.8},null,"before 5th",null,"May",5000,{"$f":"SUM($K$63:K63)+$L$59+IF(H64=\"before 5th\",K64,0)","v":817862.15122882393},5929.5005964089733,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$63:K64)+$L$59+IF(H65=\"before 5th\",K65,0)","v":822862.15122882393},5965.7505964089733,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$63:K65)+$L$59+IF(H66=\"before 5th\",K66,0)","v":827862.15122882393},6002.0005964089733,0,null,{"$f":"IF(SUM(K63:K74)>P65,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$63:K66)+$L$59+IF(H67=\"before 5th\",K67,0)","v":832862.15122882393},6038.2505964089733,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$63:K67)+$L$59+IF(H68=\"before 5th\",K68,0)","v":837862.15122882393},6074.5005964089733,0,null,{"$f":"IF(N75>F64,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$63:K68)+$L$59+IF(H69=\"before 5th\",K69,0)","v":842862.15122882393},6110.7505964089733,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$63:K69)+$L$59+IF(H70=\"before 5th\",K70,0)","v":847862.15122882393},6147.0005964089733,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$63:K70)+$L$59+IF(H71=\"before 5th\",K71,0)","v":852862.15122882393},6183.2505964089733,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$63:K71)+$L$59+IF(H72=\"before 5th\",K72,0)","v":857862.15122882393},6219.5005964089733,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$63:K72)+$L$59+IF(H73=\"before 5th\",K73,0)","v":862862.15122882393},6255.7505964089733,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$63:K73)+$L$59+IF(H74=\"before 5th\",K74,0)","v":867862.15122882393},6292.0005964089733,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K63:K74)+SUM(M63:M74)+L59-N75","v":940973.65838573163},null,{"$f":"MAX(O63:O74)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"1st Extension Year 5",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$75+IF(H79=\"before 5th\",K79,0)","v":945973.65838573163},{"$f":"L79*$P$79/12","v":6858.3090232965542},{"$f":"IF(O79=MAX($O$79:$O$90),O79,IF(N78=MAX($O$79:$O$90),N78,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$11","v":281464.8},null,"before 5th",null,"May",5000,{"$f":"SUM($K$79:K79)+$L$75+IF(H80=\"before 5th\",K80,0)","v":950973.65838573163},6894.5590232965542,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$79:K80)+$L$75+IF(H81=\"before 5th\",K81,0)","v":955973.65838573163},6930.8090232965542,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$79:K81)+$L$75+IF(H82=\"before 5th\",K82,0)","v":960973.65838573163},6967.0590232965542,0,null,{"$f":"IF(SUM(K79:K90)>P81,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$79:K82)+$L$75+IF(H83=\"before 5th\",K83,0)","v":965973.65838573163},7003.3090232965542,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$79:K83)+$L$75+IF(H84=\"before 5th\",K84,0)","v":970973.65838573163},7039.5590232965542,0,null,{"$f":"IF(N91>F80,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$79:K84)+$L$75+IF(H85=\"before 5th\",K85,0)","v":975973.65838573163},7075.8090232965542,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$79:K85)+$L$75+IF(H86=\"before 5th\",K86,0)","v":980973.65838573163},7112.0590232965542,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$79:K86)+$L$75+IF(H87=\"before 5th\",K87,0)","v":985973.65838573163},7148.3090232965542,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$79:K87)+$L$75+IF(H88=\"before 5th\",K88,0)","v":990973.65838573163},7184.5590232965542,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$79:K88)+$L$75+IF(H89=\"before 5th\",K89,0)","v":995973.65838573163},7220.8090232965542,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$79:K89)+$L$75+IF(H90=\"before 5th\",K90,0)","v":1000973.6583857316},7257.0590232965542,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K79:K90)+SUM(M79:M90)+L75-N91","v":1085665.8666652902},null,{"$f":"MAX(O79:O90)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"2nd Extension Year 1",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$91+IF(H95=\"before 5th\",K95,0)","v":1090665.8666652902},{"$f":"L95*$P$95/12","v":7907.3275333233532},{"$f":"IF(O95=MAX($O$95:$O$106),O95,IF(N94=MAX($O$95:$O$106),N94,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$91","v":651399.51999917405},null,"before 5th",null,"May",5000,{"$f":"SUM($K$95:K95)+$L$91+IF(H96=\"before 5th\",K96,0)","v":1095665.8666652902},7943.5775333233532,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$95:K96)+$L$91+IF(H97=\"before 5th\",K97,0)","v":1100665.8666652902},7979.8275333233532,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$95:K97)+$L$91+IF(H98=\"before 5th\",K98,0)","v":1105665.8666652902},8016.0775333233532,0,null,{"$f":"IF(SUM(K95:K106)>P97,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$95:K98)+$L$91+IF(H99=\"before 5th\",K99,0)","v":1110665.8666652902},8052.3275333233532,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$95:K99)+$L$91+IF(H100=\"before 5th\",K100,0)","v":1115665.8666652902},8088.5775333233532,0,null,{"$f":"IF(N107>F96,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$95:K100)+$L$91+IF(H101=\"before 5th\",K101,0)","v":1120665.8666652902},8124.8275333233532,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$95:K101)+$L$91+IF(H102=\"before 5th\",K102,0)","v":1125665.8666652902},8161.0775333233532,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$95:K102)+$L$91+IF(H103=\"before 5th\",K103,0)","v":1130665.8666652902},8197.3275333233523,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$95:K103)+$L$91+IF(H104=\"before 5th\",K104,0)","v":1135665.8666652902},8233.5775333233523,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$95:K104)+$L$91+IF(H105=\"before 5th\",K105,0)","v":1140665.8666652902},8269.8275333233523,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$95:K105)+$L$91+IF(H106=\"before 5th\",K106,0)","v":1145665.8666652902},8306.0775333233523,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K95:K106)+SUM(M95:M106)+L91-N107","v":1242946.2970651705},null,{"$f":"MAX(O95:O106)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"2nd Extension Year 2",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$107+IF(H111=\"before 5th\",K111,0)","v":1247946.2970651705},{"$f":"L111*$P$111/12","v":9047.6106537224859},{"$f":"IF(O111=MAX($O$111:$O$122),O111,IF(N110=MAX($O$111:$O$122),N110,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$91","v":651399.51999917405},null,"before 5th",null,"May",5000,{"$f":"SUM($K$111:K111)+$L$107+IF(H112=\"before 5th\",K112,0)","v":1252946.2970651705},9083.8606537224859,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$111:K112)+$L$107+IF(H113=\"before 5th\",K113,0)","v":1257946.2970651705},9120.1106537224859,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$111:K113)+$L$107+IF(H114=\"before 5th\",K114,0)","v":1262946.2970651705},9156.3606537224859,0,null,{"$f":"IF(SUM(K111:K122)>P113,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$111:K114)+$L$107+IF(H115=\"before 5th\",K115,0)","v":1267946.2970651705},9192.6106537224859,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$111:K115)+$L$107+IF(H116=\"before 5th\",K116,0)","v":1272946.2970651705},9228.8606537224859,0,null,{"$f":"IF(N123>F112,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$111:K116)+$L$107+IF(H117=\"before 5th\",K117,0)","v":1277946.2970651705},9265.1106537224859,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$111:K117)+$L$107+IF(H118=\"before 5th\",K118,0)","v":1282946.2970651705},9301.3606537224859,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$111:K118)+$L$107+IF(H119=\"before 5th\",K119,0)","v":1287946.2970651705},9337.6106537224859,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$111:K119)+$L$107+IF(H120=\"before 5th\",K120,0)","v":1292946.2970651705},9373.8606537224859,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$111:K120)+$L$107+IF(H121=\"before 5th\",K121,0)","v":1297946.2970651705},9410.1106537224859,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$111:K121)+$L$107+IF(H122=\"before 5th\",K122,0)","v":1302946.2970651705},9446.3606537224859,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K111:K122)+SUM(M111:M122)+L107-N123","v":1413910.1249098403},null,{"$f":"MAX(O111:O122)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"2nd Extension Year 3",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$123+IF(H127=\"before 5th\",K127,0)","v":1418910.1249098403},{"$f":"L127*$P$127/12","v":10287.098405596342},{"$f":"IF(O127=MAX($O$127:$O$138),O127,IF(N126=MAX($O$127:$O$138),N126,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$91","v":651399.51999917405},null,"before 5th",null,"May",5000,{"$f":"SUM($K$127:K127)+$L$123+IF(H128=\"before 5th\",K128,0)","v":1423910.1249098403},10323.348405596342,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$127:K128)+$L$123+IF(H129=\"before 5th\",K129,0)","v":1428910.1249098403},10359.598405596342,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$127:K129)+$L$123+IF(H130=\"before 5th\",K130,0)","v":1433910.1249098403},10395.848405596342,0,null,{"$f":"IF(SUM(K127:K138)>P129,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$127:K130)+$L$123+IF(H131=\"before 5th\",K131,0)","v":1438910.1249098403},10432.098405596342,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$127:K131)+$L$123+IF(H132=\"before 5th\",K132,0)","v":1443910.1249098403},10468.348405596342,0,null,{"$f":"IF(N139>F128,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$127:K132)+$L$123+IF(H133=\"before 5th\",K133,0)","v":1448910.1249098403},10504.598405596342,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$127:K133)+$L$123+IF(H134=\"before 5th\",K134,0)","v":1453910.1249098403},10540.848405596342,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$127:K134)+$L$123+IF(H135=\"before 5th\",K135,0)","v":1458910.1249098403},10577.098405596342,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$127:K135)+$L$123+IF(H136=\"before 5th\",K136,0)","v":1463910.1249098403},10613.348405596342,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$127:K136)+$L$123+IF(H137=\"before 5th\",K137,0)","v":1468910.1249098403},10649.598405596342,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$127:K137)+$L$123+IF(H138=\"before 5th\",K138,0)","v":1473910.1249098403},10685.848405596342,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K127:K138)+SUM(M127:M138)+L123-N139","v":1599747.8057769963},null,{"$f":"MAX(O127:O138)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"2nd Extension Year 4",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$139+IF(H143=\"before 5th\",K143,0)","v":1604747.8057769963},{"$f":"L143*$P$143/12","v":11634.421591883221},{"$f":"IF(O143=MAX($O$143:$O$154),O143,IF(N142=MAX($O$143:$O$154),N142,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$91","v":651399.51999917405},null,"before 5th",null,"May",5000,{"$f":"SUM($K$143:K143)+$L$139+IF(H144=\"before 5th\",K144,0)","v":1609747.8057769963},11670.671591883221,0,null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$143:K144)+$L$139+IF(H145=\"before 5th\",K145,0)","v":1614747.8057769963},11706.921591883221,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$143:K145)+$L$139+IF(H146=\"before 5th\",K146,0)","v":1619747.8057769963},11743.171591883221,0,null,{"$f":"IF(SUM(K143:K154)>P145,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$143:K146)+$L$139+IF(H147=\"before 5th\",K147,0)","v":1624747.8057769963},11779.421591883221,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$143:K147)+$L$139+IF(H148=\"before 5th\",K148,0)","v":1629747.8057769963},11815.671591883221,0,null,{"$f":"IF(N155>F144,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$143:K148)+$L$139+IF(H149=\"before 5th\",K149,0)","v":1634747.8057769963},11851.921591883221,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$143:K149)+$L$139+IF(H150=\"before 5th\",K150,0)","v":1639747.8057769963},11888.171591883221,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$143:K150)+$L$139+IF(H151=\"before 5th\",K151,0)","v":1644747.8057769963},11924.421591883221,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$143:K151)+$L$139+IF(H152=\"before 5th\",K152,0)","v":1649747.8057769963},11960.671591883221,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$143:K152)+$L$139+IF(H153=\"before 5th\",K153,0)","v":1654747.8057769963},11996.921591883221,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$143:K153)+$L$139+IF(H154=\"before 5th\",K154,0)","v":1659747.8057769963},12033.171591883221,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K143:K154)+SUM(M143:M154)+L139-N155","v":1801753.3648795949},null,{"$f":"MAX(O143:O154)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"2nd Extension Year 5",null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,null,"Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal","PPF Interest Rate"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$155+IF(H159=\"before 5th\",K159,0)","v":1806753.3648795949},{"$f":"L159*$P$143/12","v":13098.961895377062},{"$f":"IF(O159=MAX($O$159:$O$170),O159,IF(N158=MAX($O$159:$O$170),N158,0))","v":0},null,8.6999999999999994E-2]
[null,null,null,{"$f":"IF($M$9=0,\"Withdrawal limit\",\"\")","v":"Withdrawal limit"},null,{"$f":"60%*$L$91","v":651399.51999917405},null,"before 5th",null,"May",5000,{"$f":"SUM($K$159:K159)+$L$155+IF(H160=\"before 5th\",K160,0)","v":1811753.3648795949},13135.211895377062,{"$f":"IF(O160=MAX($O$159:$O$170),O160,IF(N159=MAX($O$159:$O$170),N159,0))","v":0},null,"PPF investment limit"]
[null,null,null,null,null,null,null,"before 5th",null,"Jun",5000,{"$f":"SUM($K$159:K160)+$L$155+IF(H161=\"before 5th\",K161,0)","v":1816753.3648795949},13171.461895377062,0,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",5000,{"$f":"SUM($K$159:K161)+$L$155+IF(H162=\"before 5th\",K162,0)","v":1821753.3648795949},13207.711895377062,0,null,{"$f":"IF(SUM(K159:K170)>P161,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Aug",5000,{"$f":"SUM($K$159:K162)+$L$155+IF(H163=\"before 5th\",K163,0)","v":1826753.3648795949},13243.961895377062,0]
[null,null,null,null,null,null,null,"before 5th",null,"Sep",5000,{"$f":"SUM($K$159:K163)+$L$155+IF(H164=\"before 5th\",K164,0)","v":1831753.3648795949},13280.211895377062,0,null,{"$f":"IF(N171>F160,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",5000,{"$f":"SUM($K$159:K164)+$L$155+IF(H165=\"before 5th\",K165,0)","v":1836753.3648795949},13316.461895377062,0]
[null,null,null,null,null,null,null,"before 5th",null,"Nov",5000,{"$f":"SUM($K$159:K165)+$L$155+IF(H166=\"before 5th\",K166,0)","v":1841753.3648795949},13352.711895377062,0]
[null,null,null,null,null,null,null,"before 5th",null,"Dec",5000,{"$f":"SUM($K$159:K166)+$L$155+IF(H167=\"before 5th\",K167,0)","v":1846753.3648795949},13388.961895377062,0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",5000,{"$f":"SUM($K$159:K167)+$L$155+IF(H168=\"before 5th\",K168,0)","v":1851753.3648795949},13425.211895377062,0]
[null,null,null,null,null,null,null,"before 5th",null,"Feb",5000,{"$f":"SUM($K$159:K168)+$L$155+IF(H169=\"before 5th\",K169,0)","v":1856753.3648795949},13461.461895377062,0]
[null,null,null,null,null,null,null,"before 5th",null,"Mar",5000,{"$f":"SUM($K$159:K169)+$L$155+IF(H170=\"before 5th\",K170,0)","v":1861753.3648795949},13497.711895377062,0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K159:K170)+SUM(M159:M170)+L155-N171","v":2021333.4076241197},null,{"$f":"MAX(O159:O170)","v":0}]

{"sheet":"Interest Rate History","index":4,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Source:"]
[null,null,null,null,null,null,null,null,null,"http://finotax.com/ppf/calculator"]