{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["PPF Calculator","Goal Calculator","PPF Matuirty date Calculation","PPF Tracker","Post 15 yearsTracker "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":[[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],[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],[1,3,2,14],[7,12,7,13],[7,4,7,5],[7,7,7,10],[8,7,8,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30000]
[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":29999.999999999236}]
[null,null,null,null,"Investment Amount",83.252217930602711]
[]
[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":83.252217930602711},{"$f":"I14","v":83.252217930602711},{"$f":"J14*$K$9/12","v":0.60357857999686959}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I15+J14","v":166.50443586120542},1.2071571599937392]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I16+J15","v":249.75665379180813},1.8107357399906088]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},333.00887172241084,2.4143143199874784]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},416.26108965301353,3.0178928999843477]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},499.51330758361621,3.6214714799812171]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},582.76552551421889,4.2250500599780869]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},666.01774344482158,4.8286286399749558]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},749.26996137542426,5.4322072199718257]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},832.52217930602694,6.0357857999686955]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},915.77439723662962,6.6393643799655644]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},999.02661516723231,7.2429429599624342]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J25+SUM(K14:K25)","v":1046.1057444069882}]
[]
[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":83.252217930602711},{"$f":"I30+J26","v":1129.3579623375908},{"$f":"J30*$K$9/12","v":8.1878452269475321}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I31+J30","v":1212.6101802681935},8.7914238069444028]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I32+J31","v":1295.8623981987962},9.3950023869412718]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},1379.1146161293989,9.9985809669381407]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},1462.3668340600016,10.602159546935011]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},1545.6190519906042,11.205738126931879]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},1628.8712699212069,11.809316706928749]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},1712.1234878518096,12.412895286925618]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},1795.3757057824123,13.016473866922489]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},1878.627923713015,13.620052446919358]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},1961.8801416436177,14.223631026916228]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},2045.1323595742203,14.827209606913096]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J41+SUM(K30:K41)","v":2183.2226885773839}]
[]
[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":83.252217930602711},{"$f":"I46+J42","v":2266.4749065079868},{"$f":"J46*$K$9/12","v":16.431943072182904}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I47+J46","v":2349.7271244385897},17.035521652179774]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I48+J47","v":2432.9793423691926},17.639100232176645]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},2516.2315602997955,18.242678812173516]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},2599.4837782303985,18.846257392170386]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},2682.7359961610014,19.449835972167261]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},2765.9882140916043,20.053414552164131]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},2849.2404320222072,20.656993132161002]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},2932.4926499528101,21.260571712157873]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},3015.744867883413,21.864150292154743]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},3098.9970858140159,22.467728872151614]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},3182.2493037446188,23.071307452148485]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J57+SUM(K46:K57)","v":3419.2688068906073}]
[]
[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":83.252217930602711},{"$f":"I62+J58","v":3502.5210248212102},{"$f":"J62*$K$9/12","v":25.39327742995377}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I63+J62","v":3585.7732427518131},25.996856009950644]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I64+J63","v":3669.025460682416},26.600434589947515]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},3752.2776786130189,27.204013169944385]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},3835.5298965436218,27.807591749941256]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},3918.7821144742247,28.411170329938127]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},4002.0343324048276,29.014748909934998]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},4085.2865503354305,29.618327489931868]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},4168.538768266033,30.221906069928735]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},4251.7909861966355,30.825484649925603]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},4335.0432041272379,31.429063229922473]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},4418.2954220578404,32.03264180991934]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J73+SUM(K62:K73)","v":4762.850937497079}]
[]
[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":83.252217930602711},{"$f":"I78+J74","v":4846.1031554276815},{"$f":"J78*$K$9/12","v":35.134247876850687}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I79+J78","v":4929.3553733582839},35.737826456847557]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I80+J79","v":5012.6075912888864},36.341405036844428]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},5095.8598092194889,36.944983616841292]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},5179.1120271500913,37.548562196838155]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},5262.3642450806938,38.152140776835026]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},5345.6164630112962,38.755719356831897]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},5428.8686809418987,39.35929793682876]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},5512.1208988725011,39.962876516825631]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},5595.3731168031036,40.566455096822502]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},5678.625334733706,41.170033676819365]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},5761.8775526643085,41.773612256816236]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J89+SUM(K78:K89)","v":6223.3247134663097}]
[]
[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":83.252217930602711},{"$f":"I94+J90","v":6306.5769313969122},{"$f":"J94*$K$9/12","v":45.722682752627613}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I95+J94","v":6389.8291493275146},46.326261332624476]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I96+J95","v":6473.0813672581171},46.92983991262134]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},6556.3335851887196,47.53341849261821]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},6639.585803119322,48.136997072615081]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},6722.8380210499245,48.740575652611945]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},6806.0902389805269,49.344154232608815]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},6889.3424569111294,49.947732812605686]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},6972.5946748417318,50.55131139260255]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},7055.8468927723343,51.15488997259942]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},7139.0991107029367,51.758468552596291]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},7222.3513286335392,52.362047132593155]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J105+SUM(K94:K105)","v":7810.8597079448637}]
[]
[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":83.252217930602711},{"$f":"I110+J106","v":7894.1119258754661},{"$f":"J110*$K$9/12","v":57.232311462597124}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I111+J110","v":7977.3641438060686},57.835890042593995]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I112+J111","v":8060.616361736671},58.439468622590859]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},8143.8685796672735,59.043047202587729]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},8227.1207975978759,59.6466257825846]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},8310.3730155284793,60.250204362581478]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},8393.6252334590827,60.853782942578341]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},8476.877451389686,61.457361522575219]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},8560.1296693202894,62.06094010257209]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},8643.3818872508928,62.664518682568968]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},8726.6341051814961,63.268097262565846]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},8809.8863231120995,63.871675842562716]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J121+SUM(K110:K121)","v":9536.5102469430585}]
[]
[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":83.252217930602711},{"$f":"I126+J122","v":9619.7624648736619},{"$f":"J126*$K$9/12","v":69.74327787033404}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I127+J126","v":9703.0146828042652},70.346856450330918]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I128+J127","v":9786.2669007348686},70.950435030327796]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},9869.519118665472,71.554013610324674]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},9952.7713365960753,72.157592190321537]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},10036.023554526679,72.761170770318415]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},10119.275772457282,73.364749350315293]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},10202.527990387885,73.968327930312157]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},10285.780208318489,74.571906510309034]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},10369.032426249092,75.175485090305912]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},10452.284644179696,75.77906367030279]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},10535.536862110299,76.382642250299668]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J137+SUM(K126:K137)","v":11412.292382834101}]
[]
[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":83.252217930602711},{"$f":"I142+J138","v":11495.544600764704},{"$f":"J142*$K$9/12","v":83.342698355544101}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I143+J142","v":11578.796818695308},83.946276935540979]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I144+J143","v":11662.049036625911},84.549855515537857]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},11745.301254556514,85.15343409553472]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},11828.553472487118,85.757012675531598]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},11911.805690417721,86.360591255528462]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},11995.057908348324,86.964169835525354]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},12078.310126278928,87.567748415522217]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},12161.562344209531,88.171326995519095]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},12244.814562140135,88.774905575515973]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},12328.066780070738,89.378484155512851]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},12411.318998001341,89.982062735509714]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J153+SUM(K142:K153)","v":13451.267564547665}]
[]
[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":83.252217930602711},{"$f":"I158+J154","v":13534.519782478268},{"$f":"J158*$K$9/12","v":98.125268422967437}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I159+J158","v":13617.772000408871},98.728847002964315]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I160+J159","v":13701.024218339475},99.332425582961193]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},13784.276436270078,99.936004162958056]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},13867.528654200682,100.53958274295495]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},13950.780872131285,101.14316132295181]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},14034.033090061888,101.74673990294868]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},14117.285307992492,102.35031848294555]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},14200.537525923095,102.95389706294243]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},14283.789743853698,103.55747564293931]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},14367.041961784302,104.16105422293617]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},14450.294179714905,104.76463280293306]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J169+SUM(K158:K169)","v":15667.633587070308}]
[]
[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":83.252217930602711},{"$f":"I174+J170","v":15750.885805000911},{"$f":"J174*$K$9/12","v":114.19392208625659}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I175+J174","v":15834.138022931515},114.79750066625347]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I176+J175","v":15917.390240862118},115.40107924625035]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},16000.642458792721,116.00465782624723]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},16083.894676723325,116.60823640624409]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},16167.146894653928,117.21181498624098]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},16250.399112584531,117.81539356623784]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},16333.651330515135,118.41897214623471]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},16416.903548445738,119.0225507262316]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},16500.155766376341,119.62612930622846]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},16583.407984306945,120.22970788622534]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},16666.660202237548,120.83328646622222]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J185+SUM(K174:K185)","v":18076.823453552421}]
[]
[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":83.252217930602711},{"$f":"I190+J186","v":18160.075671483024},{"$f":"J190*$K$9/12","v":131.66054861825191}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I191+J190","v":18243.327889413627},132.26412719824879]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I192+J191","v":18326.580107344231},132.86770577824566]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},18409.832325274834,133.47128435824254]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},18493.084543205438,134.07486293823942]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},18576.336761136041,134.67844151823627]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},18659.588979066644,135.28202009823318]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},18742.841196997248,135.88559867823002]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},18826.093414927851,136.4891772582269]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},18909.345632858454,137.09275583822378]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},18992.597850789058,137.69633441822066]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},19075.850068719661,138.29991299821754]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J201+SUM(K190:K201)","v":20695.612838418478}]
[]
[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":83.252217930602711},{"$f":"I206+J202","v":20778.865056349081},{"$f":"J206*$K$9/12","v":150.64677165853081}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I207+J206","v":20862.117274279684},151.25035023852772]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I208+J207","v":20945.369492210288},151.85392881852457]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},21028.621710140891,152.45750739852144]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},21111.873928071494,153.06108597851832]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},21195.126146002098,153.6646645585152]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},21278.378363932701,154.26824313851208]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},21361.630581863305,154.87182171850895]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},21444.882799793908,155.47540029850583]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},21528.135017724511,156.07897887850268]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},21611.387235655115,156.68255745849959]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},21694.639453585718,157.28613603849644]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J217+SUM(K206:K217)","v":23542.236899767882}]
[]
[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":83.252217930602711},{"$f":"I222+J218","v":23625.489117698486},{"$f":"J222*$K$9/12","v":171.28479610331399}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I223+J222","v":23708.741335629089},171.88837468331087]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I224+J223","v":23791.993553559692},172.49195326330775]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},23875.245771490296,173.09553184330466]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},23958.497989420899,173.69911042330151]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},24041.750207351502,174.30268900329838]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},24125.002425282106,174.90626758329526]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},24208.254643212709,175.50984616329211]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},24291.506861143313,176.11342474328899]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},24374.759079073916,176.71700332328589]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},24458.011297004519,177.32058190328277]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},24541.263514935123,177.92416048327962]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J233+SUM(K222:K233)","v":26636.517254454684}]
[]
[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":83.252217930602711},{"$f":"I238+J234","v":26719.769472385287},{"$f":"J238*$K$9/12","v":193.7183286747933}]
[null,null,null,null,null,null,null,"May",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I239+J238","v":26803.021690315891},194.32190725479018]
[null,null,null,null,null,null,null,"Jun",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},{"$f":"I240+J239","v":26886.273908246494},194.92548583478708]
[null,null,null,null,null,null,null,"Jul",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},26969.526126177097,195.52906441478396]
[null,null,null,null,null,null,null,"Aug",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},27052.778344107701,196.13264299478081]
[null,null,null,null,null,null,null,"Sep",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},27136.030562038304,196.73622157477769]
[null,null,null,null,null,null,null,"Oct",{"$f":"IF($F$9<>\"Annual\",$F$10,0)","v":83.252217930602711},27219.282779968908,197.33980015477457]
[null,null,null,null,null,null,null,"Nov",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},27302.534997899511,197.94337873477141]
[null,null,null,null,null,null,null,"Dec",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},27385.787215830114,198.54695731476832]
[null,null,null,null,null,null,null,"Jan",{"$f":"IF(OR($F$9=\"Monthly\",$F$9=\"Quarterly\"),$F$10,0)","v":83.252217930602711},27469.039433760718,199.1505358947652]
[null,null,null,null,null,null,null,"Feb",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},27552.291651691321,199.75411447476208]
[null,null,null,null,null,null,null,"Mar",{"$f":"IF($F$9=\"Monthly\",$F$10,0)","v":83.252217930602711},27635.543869621924,200.35769305475893]
[null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"J249+SUM(K238:K249)","v":29999.999999999236}]

{"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 certain  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,30000,"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,83.252217930602711]
[{"$f":"IF(F11*L2>I4, \"Answer is above investment limit. Choose lower maturity value and repeat step 3\",\"\")","v":""}]

{"sheet":"PPF Matuirty date Calculation","index":2,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[8,9,17,9],[5,10,8,10],[19,3,19,8],[20,9,25,9]]}
[]
[null,null,null,null,null,"Year","Financial Year"]
["Date when account was opened","2015-04-01",null,"2016-03-31",{"$f":"IF(MONTH(B3)<=3,YEAR(B3),YEAR(B3)+1)","v":2016},0,{"$f":"CONCATENATE(\"FY \",H3,\" - \",I3)","v":"FY 2015 - 2016"},{"$f":"IF(MONTH(B3)<=3,YEAR(B3)-1,YEAR(B3))","v":2015},{"$f":"H3+1","v":2016}]
[null,null,null,"2016-03-31",{"$f":"E3+1","v":2017},{"$f":"F3+1","v":1},{"$f":"CONCATENATE(\"FY \",H4,\" - \",I4)","v":"FY 2016 - 2017"},{"$f":"H3+1","v":2016},{"$f":"I3+1","v":2017}]
["Date of maturity",{"$f":"DATE(E18,4,1)","v":"2031-04-01"},null,"2016-03-31",2018,2,"FY 2017 - 2018",2017,2018]
["If you wish to extend it has to be done before",null,null,"2016-03-31",2019,3,"FY 2018 - 2019",2018,2019,null,"Loan eligibility"]
[null,{"$f":"DATE(YEAR(B5),3,31)","v":"2031-03-31"},null,"2016-03-31",2020,4,"FY 2019 - 2020",2019,2020]
[null,null,null,"2016-03-31",2021,5,"FY 2020 - 2021",2020,2021]
["Date when account was extended",{"$f":"B5","v":"2031-04-01"},null,"2016-03-31",2022,6,"FY 2021 - 2022",2021,2022,"Withdrawl possible"]
[null,null,null,"2016-03-31",2023,7,"FY 2022 - 2023",2022,2023]
["Date of maturity",{"$f":"DATE(E26,4,1)","v":"2036-04-01"},null,"2016-03-31",2024,8,"FY 2023 - 2024",2023,2024]
[null,null,null,"2016-03-31",2025,9,"FY 2024 - 2025",2024,2025]
[null,null,null,"2016-03-31",2026,10,"FY 2025 - 2026",2025,2026]
[null,null,null,"2016-03-31",2027,11,"FY 2026 - 2027",2026,2027]
[null,null,null,"2016-03-31",2028,12,"FY 2027 - 2028",2027,2028]
[null,null,null,"2016-03-31",2029,13,"FY 2028 - 2029",2028,2029]
[null,null,null,"2016-03-31",2030,14,"FY 2029 - 2030",2029,2030]
[null,null,null,"2016-03-31",2031,15,"FY 2030 - 2031",2030,2031]
[]
[null,null,null,"For Extension only"]
[null,null,null,null,null,"Year","Financial Year",null,null,"Withdrawl possible = 60% of last FY balance"]
[null,null,null,"2016-03-31",{"$f":"YEAR(B9)+1","v":2032},1,{"$f":"CONCATENATE(\"FY \",H22,\" - \",I22)","v":"FY 2031 - 2032"},{"$f":"YEAR(B9)","v":2031},{"$f":"H22+1","v":2032}]
[null,null,null,"2016-03-31",{"$f":"E22+1","v":2033},2,{"$f":"CONCATENATE(\"FY \",H23,\" - \",I23)","v":"FY 2032 - 2033"},{"$f":"H22+1","v":2032},2033]
[null,null,null,"2016-03-31",2034,3,{"$f":"CONCATENATE(\"FY \",H24,\" - \",I24)","v":"FY 2033 - 2034"},2033,2034]
[null,null,null,"2016-03-31",2035,4,{"$f":"CONCATENATE(\"FY \",H25,\" - \",I25)","v":"FY 2034 - 2035"},2034,2035]
[null,null,null,"2016-03-31",2036,5,{"$f":"CONCATENATE(\"FY \",H26,\" - \",I26)","v":"FY 2035 - 2036"},2035,2036]

{"sheet":"PPF Tracker","index":3,"n_rows":330,"n_cols":30,"rows_kept":330,"cut":false,"hidden":false,"merged":[[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],[170,4,170,18],[186,4,186,18],[202,4,202,18],[218,4,218,18],[234,4,234,18],[154,4,154,18],[138,4,138,18],[43,9,43,12],[59,9,59,12],[75,9,75,12],[5,9,5,11],[42,4,42,18],[26,4,26,18],[10,4,10,18],[1,3,2,18],[7,4,7,5],[7,16,7,17],[11,9,11,12],[27,9,27,12],[122,4,122,18],[106,4,106,18],[90,4,90,18],[74,4,74,18],[58,4,58,18],[91,9,91,12],[250,4,250,18],[251,9,251,12],[266,4,266,18],[267,9,267,12],[282,4,282,18],[283,9,283,12],[298,4,298,18],[299,9,299,12],[314,4,314,18],[315,9,315,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,"Enter data only in green cells",null,null,null,null,"Account opening date ",null,null,{"$f":"'PPF Matuirty date Calculation'!B3","v":"2015-04-01"},null,"This has to be entered in \"PPF Matuirty date Calculation\" sheet"]
[null,null,null,null,null,null,null,null,null,"Maturity Date",null,null,{"$f":"'PPF Matuirty date Calculation'!B5","v":"2031-04-01"}]
[]
[null,null,null,null,null,null,null,null,null,"Balance on March 31st of",null,null,2016]
[null,null,null,null,null,null,null,null,null,"Set as zero for new accounts",null,null,121212]
[]
[null,null,null,null,{"$f":"IF(DATE(MID(J12,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J12,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D10+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J12,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":1},null,null,null,null,1,{"$f":"CONCATENATE(\"FY \",$M$8+I12-1,\" - \",$M$8+I12)","v":"FY 2016 - 2017"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J12,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D12,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J12,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"1th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D12>=3,D12<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D12>=3,D12<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D13=\"Loan amount available\",25%*#REF!,\"\")),\"\",IF(D13=\"Loan amount available\",25%*#REF!,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J12,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")","v":"No withdrawal possible"}]
[null,null,null,null,null,null,8.1000000000000003E-2,"before 5th",null,"Apr",5000,{"$f":"$M$9+IF(H14=\"before 5th\",K14,0)","v":126212},{"$f":"L14*G14/12","v":851.93100000000004}]
[null,null,null,null,null,null,{"$f":"G14","v":8.1000000000000003E-2},"before 5th",null,"May",5000,{"$f":"SUM($K$14:K14)+$M$9+IF(H15=\"before 5th\",K15,0)","v":131212},{"$f":"L15*G15/12","v":885.68100000000004},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G15","v":8.1000000000000003E-2},"before 5th",null,"Jun",5000,{"$f":"SUM($K$14:K15)+$M$9+IF(H16=\"before 5th\",K16,0)","v":136212},919.43100000000004,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":141212},0,null,null,{"$f":"IF(SUM(K14:K25)>P16,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G17","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$14:K17)+$M$9+IF(H18=\"before 5th\",K18,0)","v":146212},0]
[null,null,null,null,null,null,{"$f":"G18","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$14:K18)+$M$9+IF(H19=\"before 5th\",K19,0)","v":151212},0,null,null,{"$f":"IF(N26>Q13,\"Withdrawal is above limit\",\"\")","v":""}]
[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":156212},0]
[null,null,null,null,null,null,{"$f":"G20","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$14:K20)+$M$9+IF(H21=\"before 5th\",K21,0)","v":161212},0]
[null,null,null,null,null,null,{"$f":"G21","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$14:K21)+$M$9+IF(H22=\"before 5th\",K22,0)","v":166212},0]
[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":171212},0]
[null,null,null,null,null,null,{"$f":"G23","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$14:K23)+$M$9+IF(H24=\"before 5th\",K24,0)","v":176212},0]
[null,null,null,null,null,null,{"$f":"G24","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$14:K24)+$M$9+IF(H25=\"before 5th\",K25,0)","v":181212},0]
[null,null,null,{"$f":"D12","v":1},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K14:K25)+SUM(M14:M25)+M9-N26","v":183869.04300000001},null,{"$f":"O14","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J28,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J28,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D26+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J28,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":2},null,null,null,null,2,{"$f":"CONCATENATE(\"FY \",$M$8+I28-1,\" - \",$M$8+I28)","v":"FY 2017 - 2018"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J28,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D28,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J28,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"2th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D28>=3,D28<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D28>=3,D28<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D29=\"Loan amount available\",25%*L10,\"\")),\"\",IF(D29=\"Loan amount available\",25%*L10,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J28,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J28,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"No withdrawal possible"}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$26+IF(H30=\"before 5th\",K30,0)","v":183869.04300000001},{"$f":"L30*G30/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$30:K30)+$L$26+IF(H31=\"before 5th\",K31,0)","v":183869.04300000001},{"$f":"L31*G31/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G31","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$30:K31)+$L$26+IF(H32=\"before 5th\",K32,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$30:K32)+$L$26+IF(H33=\"before 5th\",K33,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K30:K41)>P32,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G33","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$30:K33)+$L$26+IF(H34=\"before 5th\",K34,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G34","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$30:K34)+$L$26+IF(H35=\"before 5th\",K35,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N42>Q29,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$30:K35)+$L$26+IF(H36=\"before 5th\",K36,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G36","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$30:K36)+$L$26+IF(H37=\"before 5th\",K37,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G37","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$30:K37)+$L$26+IF(H38=\"before 5th\",K38,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$30:K38)+$L$26+IF(H39=\"before 5th\",K39,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G39","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$30:K39)+$L$26+IF(H40=\"before 5th\",K40,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G40","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$30:K40)+$L$26+IF(H41=\"before 5th\",K41,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D28","v":2},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K30:K41)+SUM(M30:M41)+L26-N42","v":183869.04300000001},null,{"$f":"O30","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J44,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J44,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D42+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J44,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":3},null,null,null,null,{"$f":"I28+1","v":3},{"$f":"CONCATENATE(\"FY \",$M$8+I44-1,\" - \",$M$8+I44)","v":"FY 2018 - 2019"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J44,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D44,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J44,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"3th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D44>=3,D44<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D44>=3,D44<=6),\"Loan amount available\",\"\"))","v":"Loan amount available"},{"$f":"IF(ISERROR(IF(E45=\"Loan amount available\",25%*L26,\"\")),\"\",IF(E45=\"Loan amount available\",25%*L26,\"\"))","v":45967.260750000001},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J44,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J44,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"No withdrawal possible"}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$42+IF(H46=\"before 5th\",K46,0)","v":183869.04300000001},{"$f":"L46*G46/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$46:K46)+$L$42+IF(H47=\"before 5th\",K47,0)","v":183869.04300000001},{"$f":"L47*G47/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G47","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$46:K47)+$L$42+IF(H48=\"before 5th\",K48,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$46:K48)+$L$42+IF(H49=\"before 5th\",K49,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K46:K57)>P48,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G49","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$46:K49)+$L$42+IF(H50=\"before 5th\",K50,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G50","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$46:K50)+$L$42+IF(H51=\"before 5th\",K51,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N58>Q45,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$46:K51)+$L$42+IF(H52=\"before 5th\",K52,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G52","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$46:K52)+$L$42+IF(H53=\"before 5th\",K53,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G53","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$46:K53)+$L$42+IF(H54=\"before 5th\",K54,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$46:K54)+$L$42+IF(H55=\"before 5th\",K55,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G55","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$46:K55)+$L$42+IF(H56=\"before 5th\",K56,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G56","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$46:K56)+$L$42+IF(H57=\"before 5th\",K57,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D44","v":3},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K46:K57)+SUM(M46:M57)+L42-N58","v":183869.04300000001},null,{"$f":"O46","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J60,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J60,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D58+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J60,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":4},null,null,null,null,{"$f":"I44+1","v":4},{"$f":"CONCATENATE(\"FY \",$M$8+I60-1,\" - \",$M$8+I60)","v":"FY 2019 - 2020"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J60,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D60,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J60,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"4th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D60>=3,D60<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D60>=3,D60<=6),\"Loan amount available\",\"\"))","v":"Loan amount available"},{"$f":"IF(ISERROR(IF(E61=\"Loan amount available\",25%*L42,\"\")),\"\",IF(E61=\"Loan amount available\",25%*L42,\"\"))","v":45967.260750000001},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J60,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J60,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"No withdrawal possible"}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$58+IF(H62=\"before 5th\",K62,0)","v":183869.04300000001},{"$f":"L62*G62/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$62:K62)+$L$58+IF(H63=\"before 5th\",K63,0)","v":183869.04300000001},{"$f":"L63*G63/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G63","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$62:K63)+$L$58+IF(H64=\"before 5th\",K64,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$62:K64)+$L$58+IF(H65=\"before 5th\",K65,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K62:K73)>P64,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G65","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$62:K65)+$L$58+IF(H66=\"before 5th\",K66,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G66","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$62:K66)+$L$58+IF(H67=\"before 5th\",K67,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N74>Q61,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$62:K67)+$L$58+IF(H68=\"before 5th\",K68,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G68","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$62:K68)+$L$58+IF(H69=\"before 5th\",K69,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G69","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$62:K69)+$L$58+IF(H70=\"before 5th\",K70,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$62:K70)+$L$58+IF(H71=\"before 5th\",K71,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G71","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$62:K71)+$L$58+IF(H72=\"before 5th\",K72,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G72","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$62:K72)+$L$58+IF(H73=\"before 5th\",K73,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D60","v":4},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K62:K73)+SUM(M62:M73)+L58-N74","v":183869.04300000001},null,{"$f":"O62","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J76,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J76,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D74+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J76,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":5},null,null,null,null,{"$f":"I60+1","v":5},{"$f":"CONCATENATE(\"FY \",$M$8+I76-1,\" - \",$M$8+I76)","v":"FY 2020 - 2021"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J76,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D76,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J76,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"5th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D76>=3,D76<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D76>=3,D76<=6),\"Loan amount available\",\"\"))","v":"Loan amount available"},{"$f":"IF(ISERROR(IF(D77=\"Loan amount available\",25%*L58,\"\")),\"\",IF(D77=\"Loan amount available\",25%*L58,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J76,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J76,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"No withdrawal possible"},{"$f":"IF(O77=\"no withdrawal limit\",\"\",IF(O77=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":""},{"$f":"IF(O77=\"no withdrawal limit\",\"\",IF(O77=\"No withdrawal possible\",\"\",50%*MIN(L74,L26)))","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$74+IF(H78=\"before 5th\",K78,0)","v":183869.04300000001},{"$f":"L78*G78/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$78:K78)+$L$74+IF(H79=\"before 5th\",K79,0)","v":183869.04300000001},{"$f":"L79*G79/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G79","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$78:K79)+$L$74+IF(H80=\"before 5th\",K80,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$78:K80)+$L$74+IF(H81=\"before 5th\",K81,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K78:K89)>P80,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G81","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$78:K81)+$L$74+IF(H82=\"before 5th\",K82,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G82","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$78:K82)+$L$74+IF(H83=\"before 5th\",K83,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N90>Q77,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$78:K83)+$L$74+IF(H84=\"before 5th\",K84,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G84","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$78:K84)+$L$74+IF(H85=\"before 5th\",K85,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G85","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$78:K85)+$L$74+IF(H86=\"before 5th\",K86,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$78:K86)+$L$74+IF(H87=\"before 5th\",K87,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G87","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$78:K87)+$L$74+IF(H88=\"before 5th\",K88,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G88","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$78:K88)+$L$74+IF(H89=\"before 5th\",K89,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D76","v":5},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K78:K89)+SUM(M78:M89)+L74-N90","v":183869.04300000001},null,{"$f":"O78","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J92,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J92,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D90+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J92,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":6},null,null,null,null,{"$f":"I76+1","v":6},{"$f":"CONCATENATE(\"FY \",$M$8+I92-1,\" - \",$M$8+I92)","v":"FY 2021 - 2022"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J92,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D92,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J92,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"6th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D92>=3,D92<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D92>=3,D92<=6),\"Loan amount available\",\"\"))","v":"Loan amount available"},{"$f":"IF(ISERROR(IF(D93=\"Loan amount available\",25%*L74,\"\")),\"\",IF(D93=\"Loan amount available\",25%*L74,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J92,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J92,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O93=\"no withdrawal limit\",\"\",IF(O93=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O93=\"no withdrawal limit\",\"\",IF(O93=\"No withdrawal possible\",\"\",50%*MIN(L90,L42)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$90+IF(H94=\"before 5th\",K94,0)","v":183869.04300000001},{"$f":"L94*G94/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$94:K94)+$L$90+IF(H95=\"before 5th\",K95,0)","v":183869.04300000001},{"$f":"L95*G95/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G95","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$94:K95)+$L$90+IF(H96=\"before 5th\",K96,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$94:K96)+$L$90+IF(H97=\"before 5th\",K97,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K94:K105)>P96,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G97","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$94:K97)+$L$90+IF(H98=\"before 5th\",K98,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G98","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$94:K98)+$L$90+IF(H99=\"before 5th\",K99,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N106>Q93,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$94:K99)+$L$90+IF(H100=\"before 5th\",K100,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G100","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$94:K100)+$L$90+IF(H101=\"before 5th\",K101,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G101","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$94:K101)+$L$90+IF(H102=\"before 5th\",K102,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$94:K102)+$L$90+IF(H103=\"before 5th\",K103,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G103","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$94:K103)+$L$90+IF(H104=\"before 5th\",K104,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G104","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$94:K104)+$L$90+IF(H105=\"before 5th\",K105,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D92","v":6},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K94:K105)+SUM(M94:M105)+L90-N106","v":183869.04300000001},null,{"$f":"O94","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J108,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J108,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D106+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J108,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":7},null,null,null,null,{"$f":"I92+1","v":7},{"$f":"CONCATENATE(\"FY \",$M$8+I108-1,\" - \",$M$8+I108)","v":"FY 2022 - 2023"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J108,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D108,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J108,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"7th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D108>=3,D108<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D108>=3,D108<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D109=\"Loan amount available\",25%*L90,\"\")),\"\",IF(D109=\"Loan amount available\",25%*L90,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J108,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J108,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O109=\"no withdrawal limit\",\"\",IF(O109=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O109=\"no withdrawal limit\",\"\",IF(O109=\"No withdrawal possible\",\"\",50%*MIN(L106,L58)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$106+IF(H110=\"before 5th\",K110,0)","v":183869.04300000001},{"$f":"L110*G110/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$110:K110)+$L$106+IF(H111=\"before 5th\",K111,0)","v":183869.04300000001},{"$f":"L111*G111/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G111","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$110:K111)+$L$106+IF(H112=\"before 5th\",K112,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$110:K112)+$L$106+IF(H113=\"before 5th\",K113,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K110:K121)>P112,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G113","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$110:K113)+$L$106+IF(H114=\"before 5th\",K114,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G114","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$110:K114)+$L$106+IF(H115=\"before 5th\",K115,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N122>Q109,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$110:K115)+$L$106+IF(H116=\"before 5th\",K116,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G116","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$110:K116)+$L$106+IF(H117=\"before 5th\",K117,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G117","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$110:K117)+$L$106+IF(H118=\"before 5th\",K118,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$110:K118)+$L$106+IF(H119=\"before 5th\",K119,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G119","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$110:K119)+$L$106+IF(H120=\"before 5th\",K120,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G120","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$110:K120)+$L$106+IF(H121=\"before 5th\",K121,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D108","v":7},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K110:K121)+SUM(M110:M121)+L106-N122","v":183869.04300000001},null,{"$f":"O110","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J124,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J124,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D122+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J124,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":8},null,null,null,null,{"$f":"I108+1","v":8},{"$f":"CONCATENATE(\"FY \",$M$8+I124-1,\" - \",$M$8+I124)","v":"FY 2023 - 2024"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J124,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D124,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J124,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"8th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D124>=3,D124<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D124>=3,D124<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D125=\"Loan amount available\",25%*L106,\"\")),\"\",IF(D125=\"Loan amount available\",25%*L106,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J124,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J124,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O125=\"no withdrawal limit\",\"\",IF(O125=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O125=\"no withdrawal limit\",\"\",IF(O125=\"No withdrawal possible\",\"\",50%*MIN(L122,L74)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$122+IF(H126=\"before 5th\",K126,0)","v":183869.04300000001},{"$f":"L126*G126/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$126:K126)+$L$122+IF(H127=\"before 5th\",K127,0)","v":183869.04300000001},{"$f":"L127*G127/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G127","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$126:K127)+$L$122+IF(H128=\"before 5th\",K128,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$126:K128)+$L$122+IF(H129=\"before 5th\",K129,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K126:K137)>P128,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G129","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$126:K129)+$L$122+IF(H130=\"before 5th\",K130,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G130","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$126:K130)+$L$122+IF(H131=\"before 5th\",K131,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N138>Q125,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$126:K131)+$L$122+IF(H132=\"before 5th\",K132,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G132","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$126:K132)+$L$122+IF(H133=\"before 5th\",K133,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G133","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$126:K133)+$L$122+IF(H134=\"before 5th\",K134,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$126:K134)+$L$122+IF(H135=\"before 5th\",K135,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G135","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$126:K135)+$L$122+IF(H136=\"before 5th\",K136,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G136","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$126:K136)+$L$122+IF(H137=\"before 5th\",K137,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D124","v":8},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K126:K137)+SUM(M126:M137)+L122-N138","v":183869.04300000001},null,{"$f":"O126","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J140,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J140,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D138+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J140,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":9},null,null,null,null,{"$f":"I124+1","v":9},{"$f":"CONCATENATE(\"FY \",$M$8+I140-1,\" - \",$M$8+I140)","v":"FY 2024 - 2025"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J140,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D140,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J140,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"9th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D140>=3,D140<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D140>=3,D140<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D141=\"Loan amount available\",25%*L122,\"\")),\"\",IF(D141=\"Loan amount available\",25%*L122,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J140,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J140,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O141=\"no withdrawal limit\",\"\",IF(O141=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O141=\"no withdrawal limit\",\"\",IF(O141=\"No withdrawal possible\",\"\",50%*MIN(L138,L90)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$138+IF(H142=\"before 5th\",K142,0)","v":183869.04300000001},{"$f":"L142*G142/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$142:K142)+$L$138+IF(H143=\"before 5th\",K143,0)","v":183869.04300000001},{"$f":"L143*G143/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G143","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$142:K143)+$L$138+IF(H144=\"before 5th\",K144,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$142:K144)+$L$138+IF(H145=\"before 5th\",K145,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K142:K153)>P144,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G145","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$142:K145)+$L$138+IF(H146=\"before 5th\",K146,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G146","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$142:K146)+$L$138+IF(H147=\"before 5th\",K147,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N154>Q141,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$142:K147)+$L$138+IF(H148=\"before 5th\",K148,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G148","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$142:K148)+$L$138+IF(H149=\"before 5th\",K149,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G149","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$142:K149)+$L$138+IF(H150=\"before 5th\",K150,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$142:K150)+$L$138+IF(H151=\"before 5th\",K151,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G151","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$142:K151)+$L$138+IF(H152=\"before 5th\",K152,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G152","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$142:K152)+$L$138+IF(H153=\"before 5th\",K153,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D140","v":9},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K142:K153)+SUM(M142:M153)+L138-N154","v":183869.04300000001},null,{"$f":"O142","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J156,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J156,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D154+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J156,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":10},null,null,null,null,{"$f":"I140+1","v":10},{"$f":"CONCATENATE(\"FY \",$M$8+I156-1,\" - \",$M$8+I156)","v":"FY 2025 - 2026"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J156,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D156,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J156,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"10th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D156>=3,D156<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D156>=3,D156<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D157=\"Loan amount available\",25%*L138,\"\")),\"\",IF(D157=\"Loan amount available\",25%*L138,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J156,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J156,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O157=\"no withdrawal limit\",\"\",IF(O157=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O157=\"no withdrawal limit\",\"\",IF(O157=\"No withdrawal possible\",\"\",50%*MIN(L154,L106)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$154+IF(H158=\"before 5th\",K158,0)","v":183869.04300000001},{"$f":"L158*G158/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$158:K158)+$L$154+IF(H159=\"before 5th\",K159,0)","v":183869.04300000001},{"$f":"L159*G159/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G159","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$158:K159)+$L$154+IF(H160=\"before 5th\",K160,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$158:K160)+$L$154+IF(H161=\"before 5th\",K161,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K158:K169)>P160,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G161","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$158:K161)+$L$154+IF(H162=\"before 5th\",K162,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G162","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$158:K162)+$L$154+IF(H163=\"before 5th\",K163,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N170>Q157,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$158:K163)+$L$154+IF(H164=\"before 5th\",K164,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G164","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$158:K164)+$L$154+IF(H165=\"before 5th\",K165,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G165","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$158:K165)+$L$154+IF(H166=\"before 5th\",K166,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$158:K166)+$L$154+IF(H167=\"before 5th\",K167,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G167","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$158:K167)+$L$154+IF(H168=\"before 5th\",K168,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G168","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$158:K168)+$L$154+IF(H169=\"before 5th\",K169,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D156","v":10},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K158:K169)+SUM(M158:M169)+L154-N170","v":183869.04300000001},null,{"$f":"O158","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J172,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J172,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D170+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J172,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":11},null,null,null,null,{"$f":"I156+1","v":11},{"$f":"CONCATENATE(\"FY \",$M$8+I172-1,\" - \",$M$8+I172)","v":"FY 2026 - 2027"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J172,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D172,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J172,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"11th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D172>=3,D172<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D172>=3,D172<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D173=\"Loan amount available\",25%*L154,\"\")),\"\",IF(D173=\"Loan amount available\",25%*L154,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J172,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J172,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O173=\"no withdrawal limit\",\"\",IF(O173=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O173=\"no withdrawal limit\",\"\",IF(O173=\"No withdrawal possible\",\"\",50%*MIN(L170,L122)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$170+IF(H174=\"before 5th\",K174,0)","v":183869.04300000001},{"$f":"L174*G174/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$174:K174)+$L$170+IF(H175=\"before 5th\",K175,0)","v":183869.04300000001},{"$f":"L175*G175/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G175","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$174:K175)+$L$170+IF(H176=\"before 5th\",K176,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$174:K176)+$L$170+IF(H177=\"before 5th\",K177,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K174:K185)>P176,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G177","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$174:K177)+$L$170+IF(H178=\"before 5th\",K178,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G178","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$174:K178)+$L$170+IF(H179=\"before 5th\",K179,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N186>Q173,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$174:K179)+$L$170+IF(H180=\"before 5th\",K180,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G180","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$174:K180)+$L$170+IF(H181=\"before 5th\",K181,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G181","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$174:K181)+$L$170+IF(H182=\"before 5th\",K182,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$174:K182)+$L$170+IF(H183=\"before 5th\",K183,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G183","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$174:K183)+$L$170+IF(H184=\"before 5th\",K184,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G184","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$174:K184)+$L$170+IF(H185=\"before 5th\",K185,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D172","v":11},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K174:K185)+SUM(M174:M185)+L170-N186","v":183869.04300000001},null,{"$f":"O174","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J188,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J188,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D186+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J188,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":12},null,null,null,null,{"$f":"I172+1","v":12},{"$f":"CONCATENATE(\"FY \",$M$8+I188-1,\" - \",$M$8+I188)","v":"FY 2027 - 2028"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J188,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D188,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J188,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"12th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D188>=3,D188<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D188>=3,D188<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D189=\"Loan amount available\",25%*L170,\"\")),\"\",IF(D189=\"Loan amount available\",25%*L170,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J188,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J188,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O189=\"no withdrawal limit\",\"\",IF(O189=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O189=\"no withdrawal limit\",\"\",IF(O189=\"No withdrawal possible\",\"\",50%*MIN(L186,L138)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$186+IF(H190=\"before 5th\",K190,0)","v":183869.04300000001},{"$f":"L190*G190/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$190:K190)+$L$186+IF(H191=\"before 5th\",K191,0)","v":183869.04300000001},{"$f":"L191*G191/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G191","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$190:K191)+$L$186+IF(H192=\"before 5th\",K192,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$190:K192)+$L$186+IF(H193=\"before 5th\",K193,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K190:K201)>P192,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G193","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$190:K193)+$L$186+IF(H194=\"before 5th\",K194,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G194","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$190:K194)+$L$186+IF(H195=\"before 5th\",K195,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N202>Q189,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$190:K195)+$L$186+IF(H196=\"before 5th\",K196,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G196","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$190:K196)+$L$186+IF(H197=\"before 5th\",K197,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G197","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$190:K197)+$L$186+IF(H198=\"before 5th\",K198,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$190:K198)+$L$186+IF(H199=\"before 5th\",K199,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G199","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$190:K199)+$L$186+IF(H200=\"before 5th\",K200,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G200","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$190:K200)+$L$186+IF(H201=\"before 5th\",K201,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D188","v":12},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K190:K201)+SUM(M190:M201)+L186-N202","v":183869.04300000001},null,{"$f":"O190","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J204,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J204,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D202+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J204,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":13},null,null,null,null,{"$f":"I188+1","v":13},{"$f":"CONCATENATE(\"FY \",$M$8+I204-1,\" - \",$M$8+I204)","v":"FY 2028 - 2029"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J204,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D204,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J204,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"13th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D204>=3,D204<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D204>=3,D204<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D205=\"Loan amount available\",25%*L186,\"\")),\"\",IF(D205=\"Loan amount available\",25%*L186,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J204,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J204,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O205=\"no withdrawal limit\",\"\",IF(O205=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O205=\"no withdrawal limit\",\"\",IF(O205=\"No withdrawal possible\",\"\",50%*MIN(L202,L154)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$202+IF(H206=\"before 5th\",K206,0)","v":183869.04300000001},{"$f":"L206*G206/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$206:K206)+$L$202+IF(H207=\"before 5th\",K207,0)","v":183869.04300000001},{"$f":"L207*G207/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G207","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$206:K207)+$L$202+IF(H208=\"before 5th\",K208,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$206:K208)+$L$202+IF(H209=\"before 5th\",K209,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K206:K217)>P208,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G209","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$206:K209)+$L$202+IF(H210=\"before 5th\",K210,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G210","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$206:K210)+$L$202+IF(H211=\"before 5th\",K211,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N218>Q205,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$206:K211)+$L$202+IF(H212=\"before 5th\",K212,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G212","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$206:K212)+$L$202+IF(H213=\"before 5th\",K213,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G213","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$206:K213)+$L$202+IF(H214=\"before 5th\",K214,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$206:K214)+$L$202+IF(H215=\"before 5th\",K215,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G215","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$206:K215)+$L$202+IF(H216=\"before 5th\",K216,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G216","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$206:K216)+$L$202+IF(H217=\"before 5th\",K217,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D204","v":13},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K206:K217)+SUM(M206:M217)+L202-N218","v":183869.04300000001},null,{"$f":"O206","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J220,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J220,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D218+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J220,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":14},null,null,null,null,{"$f":"I204+1","v":14},{"$f":"CONCATENATE(\"FY \",$M$8+I220-1,\" - \",$M$8+I220)","v":"FY 2029 - 2030"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J220,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D220,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J220,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"14th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D220>=3,D220<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D220>=3,D220<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D221=\"Loan amount available\",25%*L202,\"\")),\"\",IF(D221=\"Loan amount available\",25%*L202,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J220,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J220,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O221=\"no withdrawal limit\",\"\",IF(O221=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O221=\"no withdrawal limit\",\"\",IF(O221=\"No withdrawal possible\",\"\",50%*MIN(L218,L170)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$218+IF(H222=\"before 5th\",K222,0)","v":183869.04300000001},{"$f":"L222*G222/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$222:K222)+$L$218+IF(H223=\"before 5th\",K223,0)","v":183869.04300000001},{"$f":"L223*G223/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G223","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$222:K223)+$L$218+IF(H224=\"before 5th\",K224,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$222:K224)+$L$218+IF(H225=\"before 5th\",K225,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K222:K233)>P224,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G225","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$222:K225)+$L$218+IF(H226=\"before 5th\",K226,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G226","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$222:K226)+$L$218+IF(H227=\"before 5th\",K227,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N234>Q221,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$222:K227)+$L$218+IF(H228=\"before 5th\",K228,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G228","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$222:K228)+$L$218+IF(H229=\"before 5th\",K229,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G229","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$222:K229)+$L$218+IF(H230=\"before 5th\",K230,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$222:K230)+$L$218+IF(H231=\"before 5th\",K231,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G231","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$222:K231)+$L$218+IF(H232=\"before 5th\",K232,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G232","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$222:K232)+$L$218+IF(H233=\"before 5th\",K233,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D220","v":14},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K222:K233)+SUM(M222:M233)+L218-N234","v":183869.04300000001},null,{"$f":"O222","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J236,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":""}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J236,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D234+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J236,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":15},null,null,null,null,{"$f":"I220+1","v":15},{"$f":"CONCATENATE(\"FY \",$M$8+I236-1,\" - \",$M$8+I236)","v":"FY 2030 - 2031"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J236,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D236,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J236,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"15th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D236>=3,D236<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D236>=3,D236<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D237=\"Loan amount available\",25%*L218,\"\")),\"\",IF(D237=\"Loan amount available\",25%*L218,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J236,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J236,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"Withdrawal"},{"$f":"IF(O237=\"no withdrawal limit\",\"\",IF(O237=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":"Withdrawal limit"},{"$f":"IF(O237=\"no withdrawal limit\",\"\",IF(O237=\"No withdrawal possible\",\"\",50%*MIN(L234,L186)))","v":91934.521500000003}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$234+IF(H238=\"before 5th\",K238,0)","v":183869.04300000001},{"$f":"L238*G238/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$238:K238)+$L$234+IF(H239=\"before 5th\",K239,0)","v":183869.04300000001},{"$f":"L239*G239/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G239","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$238:K239)+$L$234+IF(H240=\"before 5th\",K240,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$238:K240)+$L$234+IF(H241=\"before 5th\",K241,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K238:K249)>P240,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G241","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$238:K241)+$L$234+IF(H242=\"before 5th\",K242,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G242","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$238:K242)+$L$234+IF(H243=\"before 5th\",K243,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N250>Q237,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$238:K243)+$L$234+IF(H244=\"before 5th\",K244,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G244","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$238:K244)+$L$234+IF(H245=\"before 5th\",K245,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G245","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$238:K245)+$L$234+IF(H246=\"before 5th\",K246,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$238:K246)+$L$234+IF(H247=\"before 5th\",K247,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G247","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$238:K247)+$L$234+IF(H248=\"before 5th\",K248,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G248","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$238:K248)+$L$234+IF(H249=\"before 5th\",K249,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D236","v":15},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K238:K249)+SUM(M238:M249)+L234-N250","v":183869.04300000001},null,{"$f":"O238","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J252,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits"}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J252,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D250+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J252,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":16},null,null,null,null,{"$f":"I236+1","v":16},{"$f":"CONCATENATE(\"FY \",$M$8+I252-1,\" - \",$M$8+I252)","v":"FY 2031 - 2032"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J252,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D252,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J252,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"16th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D252>=3,D252<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D252>=3,D252<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D253=\"Loan amount available\",25%*L234,\"\")),\"\",IF(D253=\"Loan amount available\",25%*L234,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J252,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J252,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"no withdrawal limit"},{"$f":"IF(O253=\"no withdrawal limit\",\"\",IF(O253=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":""},{"$f":"IF(O253=\"no withdrawal limit\",\"\",IF(O253=\"No withdrawal possible\",\"\",50%*MIN(L250,L202)))","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$234+IF(H254=\"before 5th\",K254,0)","v":183869.04300000001},{"$f":"L254*G254/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$238:K254)+$L$234+IF(H255=\"before 5th\",K255,0)","v":183869.04300000001},{"$f":"L255*G255/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G255","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$238:K255)+$L$234+IF(H256=\"before 5th\",K256,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$238:K256)+$L$234+IF(H257=\"before 5th\",K257,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K254:K265)>P256,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G257","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$238:K257)+$L$234+IF(H258=\"before 5th\",K258,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G258","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$238:K258)+$L$234+IF(H259=\"before 5th\",K259,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N266>Q253,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$238:K259)+$L$234+IF(H260=\"before 5th\",K260,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G260","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$238:K260)+$L$234+IF(H261=\"before 5th\",K261,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G261","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$238:K261)+$L$234+IF(H262=\"before 5th\",K262,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$238:K262)+$L$234+IF(H263=\"before 5th\",K263,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G263","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$238:K263)+$L$234+IF(H264=\"before 5th\",K264,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G264","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$238:K264)+$L$234+IF(H265=\"before 5th\",K265,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D252","v":16},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K254:K265)+SUM(M254:M265)+L250-N266","v":183869.04300000001},null,{"$f":"O254","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J268,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits"}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J268,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D266+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J268,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":17},null,null,null,null,{"$f":"I252+1","v":17},{"$f":"CONCATENATE(\"FY \",$M$8+I268-1,\" - \",$M$8+I268)","v":"FY 2032 - 2033"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J268,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D268,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J268,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"17th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D268>=3,D268<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D268>=3,D268<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D269=\"Loan amount available\",25%*L250,\"\")),\"\",IF(D269=\"Loan amount available\",25%*L250,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J268,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J268,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"no withdrawal limit"},{"$f":"IF(O269=\"no withdrawal limit\",\"\",IF(O269=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":""},{"$f":"IF(O269=\"no withdrawal limit\",\"\",IF(O269=\"No withdrawal possible\",\"\",50%*MIN(L266,L218)))","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$234+IF(H270=\"before 5th\",K270,0)","v":183869.04300000001},{"$f":"L270*G270/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$238:K270)+$L$234+IF(H271=\"before 5th\",K271,0)","v":183869.04300000001},{"$f":"L271*G271/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G271","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$238:K271)+$L$234+IF(H272=\"before 5th\",K272,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$238:K272)+$L$234+IF(H273=\"before 5th\",K273,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K270:K281)>P272,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G273","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$238:K273)+$L$234+IF(H274=\"before 5th\",K274,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G274","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$238:K274)+$L$234+IF(H275=\"before 5th\",K275,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N282>Q269,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$238:K275)+$L$234+IF(H276=\"before 5th\",K276,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G276","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$238:K276)+$L$234+IF(H277=\"before 5th\",K277,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G277","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$238:K277)+$L$234+IF(H278=\"before 5th\",K278,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$238:K278)+$L$234+IF(H279=\"before 5th\",K279,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G279","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$238:K279)+$L$234+IF(H280=\"before 5th\",K280,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G280","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$238:K280)+$L$234+IF(H281=\"before 5th\",K281,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D268","v":17},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K270:K281)+SUM(M270:M281)+L266-N282","v":183869.04300000001},null,{"$f":"O270","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J284,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits"}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J284,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D282+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J284,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":18},null,null,null,null,{"$f":"I268+1","v":18},{"$f":"CONCATENATE(\"FY \",$M$8+I284-1,\" - \",$M$8+I284)","v":"FY 2033 - 2034"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J284,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D284,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J284,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"18th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D284>=3,D284<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D284>=3,D284<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D285=\"Loan amount available\",25%*L266,\"\")),\"\",IF(D285=\"Loan amount available\",25%*L266,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J284,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J284,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"no withdrawal limit"},{"$f":"IF(O285=\"no withdrawal limit\",\"\",IF(O285=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":""},{"$f":"IF(O285=\"no withdrawal limit\",\"\",IF(O285=\"No withdrawal possible\",\"\",50%*MIN(L282,L234)))","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$234+IF(H286=\"before 5th\",K286,0)","v":183869.04300000001},{"$f":"L286*G286/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$238:K286)+$L$234+IF(H287=\"before 5th\",K287,0)","v":183869.04300000001},{"$f":"L287*G287/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G287","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$238:K287)+$L$234+IF(H288=\"before 5th\",K288,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$238:K288)+$L$234+IF(H289=\"before 5th\",K289,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K286:K297)>P288,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G289","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$238:K289)+$L$234+IF(H290=\"before 5th\",K290,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G290","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$238:K290)+$L$234+IF(H291=\"before 5th\",K291,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N298>Q285,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$238:K291)+$L$234+IF(H292=\"before 5th\",K292,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G292","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$238:K292)+$L$234+IF(H293=\"before 5th\",K293,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G293","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$238:K293)+$L$234+IF(H294=\"before 5th\",K294,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$238:K294)+$L$234+IF(H295=\"before 5th\",K295,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G295","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$238:K295)+$L$234+IF(H296=\"before 5th\",K296,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G296","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$238:K296)+$L$234+IF(H297=\"before 5th\",K297,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D284","v":18},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K286:K297)+SUM(M286:M297)+L282-N298","v":183869.04300000001},null,{"$f":"O286","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J300,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits"}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J300,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D298+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J300,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":19},null,null,null,null,{"$f":"I284+1","v":19},{"$f":"CONCATENATE(\"FY \",$M$8+I300-1,\" - \",$M$8+I300)","v":"FY 2034 - 2035"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J300,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D300,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J300,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"19th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D300>=3,D300<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D300>=3,D300<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D301=\"Loan amount available\",25%*L282,\"\")),\"\",IF(D301=\"Loan amount available\",25%*L282,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J300,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J300,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"no withdrawal limit"},{"$f":"IF(O301=\"no withdrawal limit\",\"\",IF(O301=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":""},{"$f":"IF(O301=\"no withdrawal limit\",\"\",IF(O301=\"No withdrawal possible\",\"\",50%*MIN(L298,L250)))","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$234+IF(H302=\"before 5th\",K302,0)","v":183869.04300000001},{"$f":"L302*G302/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$238:K302)+$L$234+IF(H303=\"before 5th\",K303,0)","v":183869.04300000001},{"$f":"L303*G303/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G303","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$238:K303)+$L$234+IF(H304=\"before 5th\",K304,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$238:K304)+$L$234+IF(H305=\"before 5th\",K305,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K302:K313)>P304,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G305","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$238:K305)+$L$234+IF(H306=\"before 5th\",K306,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G306","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$238:K306)+$L$234+IF(H307=\"before 5th\",K307,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N314>Q301,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$238:K307)+$L$234+IF(H308=\"before 5th\",K308,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G308","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$238:K308)+$L$234+IF(H309=\"before 5th\",K309,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G309","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$238:K309)+$L$234+IF(H310=\"before 5th\",K310,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$238:K310)+$L$234+IF(H311=\"before 5th\",K311,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G311","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$238:K311)+$L$234+IF(H312=\"before 5th\",K312,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G312","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$238:K312)+$L$234+IF(H313=\"before 5th\",K313,0)","v":183869.04300000001},0]
[null,null,null,{"$f":"D300","v":19},null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K302:K313)+SUM(M302:M313)+L298-N314","v":183869.04300000001},null,{"$f":"O302","v":0}]
[null,null,null,null,{"$f":"IF(DATE(MID(J316,4,4),4,1)>=$M$6,\"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits\",\"\")","v":"Account has matured. No further deposits are possible unless extended for 5Y years. Account can be kept alive without deposits"}]
[null,null,null,{"$f":"IF(ISERROR(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J316,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)),D314+1,INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J316,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1))","v":20},null,null,null,null,{"$f":"I300+1","v":20},{"$f":"CONCATENATE(\"FY \",$M$8+I316-1,\" - \",$M$8+I316)","v":"FY 2035 - 2036"},null,null,null,null,{"$f":"IF(ISERROR(CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J316,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\")),CONCATENATE(D316,\"th financial year\"),CONCATENATE(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J316,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1),\"th financial year\"))","v":"20th financial year"}]
[null,null,null,null,{"$f":"IF(ISERROR(IF(AND(D316>=3,D316<=6),\"Loan amount available\",\"\")),\"\",IF(AND(D316>=3,D316<=6),\"Loan amount available\",\"\"))","v":""},{"$f":"IF(ISERROR(IF(D317=\"Loan amount available\",25%*L298,\"\")),\"\",IF(D317=\"Loan amount available\",25%*L298,\"\"))","v":""},"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,{"$f":"IF(ISERROR(IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J316,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\")),\"no withdrawal limit\",IF(INDEX('PPF Matuirty date Calculation'!$F$3:$G$18,MATCH('PPF Tracker'!J316,'PPF Matuirty date Calculation'!$G$3:$G$18,0),1)>5,\"Withdrawal\",\"No withdrawal possible\"))","v":"no withdrawal limit"},{"$f":"IF(O317=\"no withdrawal limit\",\"\",IF(O317=\"No withdrawal possible\",\"\",\"Withdrawal limit\"))","v":""},{"$f":"IF(O317=\"no withdrawal limit\",\"\",IF(O317=\"No withdrawal possible\",\"\",50%*MIN(L314,L266)))","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",null,{"$f":"$L$234+IF(H318=\"before 5th\",K318,0)","v":183869.04300000001},{"$f":"L318*G318/12","v":0}]
[null,null,null,null,null,null,0,"before 5th",null,"May",null,{"$f":"SUM($K$238:K318)+$L$234+IF(H319=\"before 5th\",K319,0)","v":183869.04300000001},{"$f":"L319*G319/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G319","v":0},"before 5th",null,"Jun",null,{"$f":"SUM($K$238:K319)+$L$234+IF(H320=\"before 5th\",K320,0)","v":183869.04300000001},0,null,null,150000]
[null,null,null,null,null,null,null,"before 5th",null,"Jul",null,{"$f":"SUM($K$238:K320)+$L$234+IF(H321=\"before 5th\",K321,0)","v":183869.04300000001},0,null,null,{"$f":"IF(SUM(K318:K329)>P320,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G321","v":0},"before 5th",null,"Aug",null,{"$f":"SUM($K$238:K321)+$L$234+IF(H322=\"before 5th\",K322,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G322","v":0},"before 5th",null,"Sep",null,{"$f":"SUM($K$238:K322)+$L$234+IF(H323=\"before 5th\",K323,0)","v":183869.04300000001},0,null,null,{"$f":"IF(N330>Q317,\"Withdrawal is above limit\",\"\")","v":""}]
[null,null,null,null,null,null,null,"before 5th",null,"Oct",null,{"$f":"SUM($K$238:K323)+$L$234+IF(H324=\"before 5th\",K324,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G324","v":0},"before 5th",null,"Nov",null,{"$f":"SUM($K$238:K324)+$L$234+IF(H325=\"before 5th\",K325,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G325","v":0},"before 5th",null,"Dec",null,{"$f":"SUM($K$238:K325)+$L$234+IF(H326=\"before 5th\",K326,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,"before 5th",null,"Jan",null,{"$f":"SUM($K$238:K326)+$L$234+IF(H327=\"before 5th\",K327,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G327","v":0},"before 5th",null,"Feb",null,{"$f":"SUM($K$238:K327)+$L$234+IF(H328=\"before 5th\",K328,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,{"$f":"G328","v":0},"before 5th",null,"Mar",null,{"$f":"SUM($K$238:K328)+$L$234+IF(H329=\"before 5th\",K329,0)","v":183869.04300000001},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K318:K329)+SUM(M318:M329)+L314-N330","v":183869.04300000001},null,{"$f":"O318","v":0}]

{"sheet":"Post 15 yearsTracker ","index":4,"n_rows":171,"n_cols":30,"rows_kept":171,"cut":false,"hidden":false,"merged":[[1,3,2,18],[7,4,7,5],[7,16,7,17],[12,9,12,12],[28,9,28,12],[5,9,5,11],[44,9,44,12],[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]]}
[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,"Enter data only in green cells",null,null,null,null,"Account extension date ",null,null,{"$f":"'PPF Matuirty date Calculation'!B9","v":"2031-04-01"},"This has to be entered in \"PPF Matuirty date Calculation\" sheet"]
[null,null,null,null,null,null,null,null,null,"Maturity Date",null,null,{"$f":"'PPF Matuirty date Calculation'!B11","v":"2036-04-01"}]
[]
[null,null,null,null,null,null,null,null,null,"Opening Balance on March 31st of",null,null,2015]
[]
[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,1,{"$f":"CONCATENATE(\"FY \",$M$8+I13-1,\" - \",$M$8+I13)","v":"FY 2015 - 2016"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,8.1000000000000003E-2,"before 5th",null,"Apr",5000,{"$f":"$L$11+IF(H15=\"before 5th\",K15,0)","v":474108},{"$f":"L15*G15/12","v":3200.2289999999998}]
[null,null,null,"Withdrawal limit",null,{"$f":"60%*$L$11","v":281464.8},{"$f":"G15","v":8.1000000000000003E-2},"before 5th",null,"May",5000,{"$f":"SUM($K$15:K15)+$L$11+IF(H16=\"before 5th\",K16,0)","v":479108},{"$f":"L16*G16/12","v":3233.9789999999998},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G16","v":8.1000000000000003E-2},"before 5th",null,"Jun",5000,{"$f":"SUM($K$15:K16)+$L$11+IF(H17=\"before 5th\",K17,0)","v":484108},3267.7289999999998,null,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},0,null,null,{"$f":"IF(SUM(K15:K26)>P17,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G18","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$15:K18)+$L$11+IF(H19=\"before 5th\",K19,0)","v":494108},0]
[null,null,null,null,null,null,{"$f":"G19","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$15:K19)+$L$11+IF(H20=\"before 5th\",K20,0)","v":499108},0,null,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},0]
[null,null,null,null,null,null,{"$f":"G21","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$15:K21)+$L$11+IF(H22=\"before 5th\",K22,0)","v":509108},0]
[null,null,null,null,null,null,{"$f":"G22","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$15:K22)+$L$11+IF(H23=\"before 5th\",K23,0)","v":514108},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},0]
[null,null,null,null,null,null,{"$f":"G24","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$15:K24)+$L$11+IF(H25=\"before 5th\",K25,0)","v":524108},0]
[null,null,null,null,null,null,{"$f":"G25","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$15:K25)+$L$11+IF(H26=\"before 5th\",K26,0)","v":529108},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K15:K26)+SUM(M15:M26)+L11-N27","v":538809.93700000003},null,{"$f":"O15","v":0}]
[]
[null,null,null,null,null,null,null,null,2,{"$f":"CONCATENATE(\"FY \",$M$8+I29-1,\" - \",$M$8+I29)","v":"FY 2016 - 2017"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$27+IF(H31=\"before 5th\",K31,0)","v":543809.93700000003},{"$f":"L31*G31/12","v":0}]
[null,null,null,"Withdrawal limit",null,{"$f":"60%*$L$11","v":281464.8},{"$f":"G31","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$31:K31)+$L$27+IF(H32=\"before 5th\",K32,0)","v":548809.93700000003},{"$f":"L32*G32/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G32","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$31:K32)+$L$27+IF(H33=\"before 5th\",K33,0)","v":553809.93700000003},0,null,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":558809.93700000003},0,null,null,{"$f":"IF(SUM(K31:K42)>P33,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G34","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$31:K34)+$L$27+IF(H35=\"before 5th\",K35,0)","v":563809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G35","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$31:K35)+$L$27+IF(H36=\"before 5th\",K36,0)","v":568809.93700000003},0,null,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":573809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G37","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$31:K37)+$L$27+IF(H38=\"before 5th\",K38,0)","v":578809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G38","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$31:K38)+$L$27+IF(H39=\"before 5th\",K39,0)","v":583809.93700000003},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":588809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G40","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$31:K40)+$L$27+IF(H41=\"before 5th\",K41,0)","v":593809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G41","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$31:K41)+$L$27+IF(H42=\"before 5th\",K42,0)","v":598809.93700000003},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K31:K42)+SUM(M31:M42)+L27-N43","v":598809.93700000003},null,{"$f":"O31","v":0}]
[]
[null,null,null,null,null,null,null,null,3,{"$f":"CONCATENATE(\"FY \",$M$8+I45-1,\" - \",$M$8+I45)","v":"FY 2017 - 2018"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$43+IF(H47=\"before 5th\",K47,0)","v":603809.93700000003},{"$f":"L47*G47/12","v":0}]
[null,null,null,"Withdrawal limit",null,{"$f":"60%*$L$11","v":281464.8},{"$f":"G47","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$47:K47)+$L$43+IF(H48=\"before 5th\",K48,0)","v":608809.93700000003},{"$f":"L48*G48/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G48","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$47:K48)+$L$43+IF(H49=\"before 5th\",K49,0)","v":613809.93700000003},0,null,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":618809.93700000003},0,null,null,{"$f":"IF(SUM(K47:K58)>P49,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G50","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$47:K50)+$L$43+IF(H51=\"before 5th\",K51,0)","v":623809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G51","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$47:K51)+$L$43+IF(H52=\"before 5th\",K52,0)","v":628809.93700000003},0,null,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":633809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G53","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$47:K53)+$L$43+IF(H54=\"before 5th\",K54,0)","v":638809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G54","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$47:K54)+$L$43+IF(H55=\"before 5th\",K55,0)","v":643809.93700000003},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":648809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G56","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$47:K56)+$L$43+IF(H57=\"before 5th\",K57,0)","v":653809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G57","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$47:K57)+$L$43+IF(H58=\"before 5th\",K58,0)","v":658809.93700000003},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K47:K58)+SUM(M47:M58)+L43-N59","v":658809.93700000003},null,{"$f":"O47","v":0}]
[]
[null,null,null,null,null,null,null,null,4,{"$f":"CONCATENATE(\"FY \",$M$8+I61-1,\" - \",$M$8+I61)","v":"FY 2018 - 2019"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$59+IF(H63=\"before 5th\",K63,0)","v":663809.93700000003},{"$f":"L63*G63/12","v":0}]
[null,null,null,"Withdrawal limit",null,{"$f":"60%*$L$11","v":281464.8},{"$f":"G63","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$63:K63)+$L$59+IF(H64=\"before 5th\",K64,0)","v":668809.93700000003},{"$f":"L64*G64/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G64","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$63:K64)+$L$59+IF(H65=\"before 5th\",K65,0)","v":673809.93700000003},0,null,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":678809.93700000003},0,null,null,{"$f":"IF(SUM(K63:K74)>P65,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G66","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$63:K66)+$L$59+IF(H67=\"before 5th\",K67,0)","v":683809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G67","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$63:K67)+$L$59+IF(H68=\"before 5th\",K68,0)","v":688809.93700000003},0,null,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":693809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G69","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$63:K69)+$L$59+IF(H70=\"before 5th\",K70,0)","v":698809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G70","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$63:K70)+$L$59+IF(H71=\"before 5th\",K71,0)","v":703809.93700000003},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":708809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G72","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$63:K72)+$L$59+IF(H73=\"before 5th\",K73,0)","v":713809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G73","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$63:K73)+$L$59+IF(H74=\"before 5th\",K74,0)","v":718809.93700000003},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K63:K74)+SUM(M63:M74)+L59-N75","v":718809.93700000003},null,{"$f":"O63","v":0}]
[]
[null,null,null,null,null,null,null,null,5,{"$f":"CONCATENATE(\"FY \",$M$8+I77-1,\" - \",$M$8+I77)","v":"FY 2019 - 2020"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$75+IF(H79=\"before 5th\",K79,0)","v":723809.93700000003},{"$f":"L79*G79/12","v":0}]
[null,null,null,"Withdrawal limit",null,{"$f":"60%*$L$11","v":281464.8},{"$f":"G79","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$79:K79)+$L$75+IF(H80=\"before 5th\",K80,0)","v":728809.93700000003},{"$f":"L80*G80/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G80","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$79:K80)+$L$75+IF(H81=\"before 5th\",K81,0)","v":733809.93700000003},0,null,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":738809.93700000003},0,null,null,{"$f":"IF(SUM(K79:K90)>P81,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G82","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$79:K82)+$L$75+IF(H83=\"before 5th\",K83,0)","v":743809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G83","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$79:K83)+$L$75+IF(H84=\"before 5th\",K84,0)","v":748809.93700000003},0,null,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":753809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G85","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$79:K85)+$L$75+IF(H86=\"before 5th\",K86,0)","v":758809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G86","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$79:K86)+$L$75+IF(H87=\"before 5th\",K87,0)","v":763809.93700000003},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":768809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G88","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$79:K88)+$L$75+IF(H89=\"before 5th\",K89,0)","v":773809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G89","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$79:K89)+$L$75+IF(H90=\"before 5th\",K90,0)","v":778809.93700000003},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K79:K90)+SUM(M79:M90)+L75-N91","v":778809.93700000003},null,{"$f":"O79","v":0}]
[]
[null,null,null,null,null,null,null,null,6,{"$f":"CONCATENATE(\"FY \",$M$8+I93-1,\" - \",$M$8+I93)","v":"FY 2020 - 2021"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$91+IF(H95=\"before 5th\",K95,0)","v":783809.93700000003},{"$f":"L95*G95/12","v":0}]
[null,null,null,{"$f":"IF(#REF!=0,\"Withdrawal limit\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"60%*$L$91","v":467285.96220000001},{"$f":"G95","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$95:K95)+$L$91+IF(H96=\"before 5th\",K96,0)","v":788809.93700000003},{"$f":"L96*G96/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G96","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$95:K96)+$L$91+IF(H97=\"before 5th\",K97,0)","v":793809.93700000003},0,null,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":798809.93700000003},0,null,null,{"$f":"IF(SUM(K95:K106)>P97,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G98","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$95:K98)+$L$91+IF(H99=\"before 5th\",K99,0)","v":803809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G99","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$95:K99)+$L$91+IF(H100=\"before 5th\",K100,0)","v":808809.93700000003},0,null,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":813809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G101","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$95:K101)+$L$91+IF(H102=\"before 5th\",K102,0)","v":818809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G102","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$95:K102)+$L$91+IF(H103=\"before 5th\",K103,0)","v":823809.93700000003},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":828809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G104","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$95:K104)+$L$91+IF(H105=\"before 5th\",K105,0)","v":833809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G105","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$95:K105)+$L$91+IF(H106=\"before 5th\",K106,0)","v":838809.93700000003},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K95:K106)+SUM(M95:M106)+L91-N107","v":838809.93700000003},null,{"$f":"O95","v":0}]
[]
[null,null,null,null,null,null,null,null,7,{"$f":"CONCATENATE(\"FY \",$M$8+I109-1,\" - \",$M$8+I109)","v":"FY 2021 - 2022"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$107+IF(H111=\"before 5th\",K111,0)","v":843809.93700000003},{"$f":"L111*G111/12","v":0}]
[null,null,null,{"$f":"IF(#REF!=0,\"Withdrawal limit\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"60%*$L$91","v":467285.96220000001},{"$f":"G111","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$111:K111)+$L$107+IF(H112=\"before 5th\",K112,0)","v":848809.93700000003},{"$f":"L112*G112/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G112","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$111:K112)+$L$107+IF(H113=\"before 5th\",K113,0)","v":853809.93700000003},0,null,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":858809.93700000003},0,null,null,{"$f":"IF(SUM(K111:K122)>P113,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G114","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$111:K114)+$L$107+IF(H115=\"before 5th\",K115,0)","v":863809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G115","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$111:K115)+$L$107+IF(H116=\"before 5th\",K116,0)","v":868809.93700000003},0,null,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":873809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G117","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$111:K117)+$L$107+IF(H118=\"before 5th\",K118,0)","v":878809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G118","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$111:K118)+$L$107+IF(H119=\"before 5th\",K119,0)","v":883809.93700000003},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":888809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G120","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$111:K120)+$L$107+IF(H121=\"before 5th\",K121,0)","v":893809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G121","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$111:K121)+$L$107+IF(H122=\"before 5th\",K122,0)","v":898809.93700000003},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K111:K122)+SUM(M111:M122)+L107-N123","v":898809.93700000003},null,{"$f":"O111","v":0}]
[]
[null,null,null,null,null,null,null,null,8,{"$f":"CONCATENATE(\"FY \",$M$8+I125-1,\" - \",$M$8+I125)","v":"FY 2022 - 2023"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$123+IF(H127=\"before 5th\",K127,0)","v":903809.93700000003},{"$f":"L127*G127/12","v":0}]
[null,null,null,{"$f":"IF(#REF!=0,\"Withdrawal limit\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"60%*$L$91","v":467285.96220000001},{"$f":"G127","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$127:K127)+$L$123+IF(H128=\"before 5th\",K128,0)","v":908809.93700000003},{"$f":"L128*G128/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G128","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$127:K128)+$L$123+IF(H129=\"before 5th\",K129,0)","v":913809.93700000003},0,null,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":918809.93700000003},0,null,null,{"$f":"IF(SUM(K127:K138)>P129,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G130","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$127:K130)+$L$123+IF(H131=\"before 5th\",K131,0)","v":923809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G131","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$127:K131)+$L$123+IF(H132=\"before 5th\",K132,0)","v":928809.93700000003},0,null,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":933809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G133","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$127:K133)+$L$123+IF(H134=\"before 5th\",K134,0)","v":938809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G134","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$127:K134)+$L$123+IF(H135=\"before 5th\",K135,0)","v":943809.93700000003},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":948809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G136","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$127:K136)+$L$123+IF(H137=\"before 5th\",K137,0)","v":953809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G137","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$127:K137)+$L$123+IF(H138=\"before 5th\",K138,0)","v":958809.93700000003},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K127:K138)+SUM(M127:M138)+L123-N139","v":958809.93700000003},null,{"$f":"O127","v":0}]
[]
[null,null,null,null,null,null,null,null,9,{"$f":"CONCATENATE(\"FY \",$M$8+I141-1,\" - \",$M$8+I141)","v":"FY 2023 - 2024"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$139+IF(H143=\"before 5th\",K143,0)","v":963809.93700000003},{"$f":"L143*G143/12","v":0}]
[null,null,null,{"$f":"IF(#REF!=0,\"Withdrawal limit\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"60%*$L$91","v":467285.96220000001},{"$f":"G143","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$143:K143)+$L$139+IF(H144=\"before 5th\",K144,0)","v":968809.93700000003},{"$f":"L144*G144/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G144","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$143:K144)+$L$139+IF(H145=\"before 5th\",K145,0)","v":973809.93700000003},0,null,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":978809.93700000003},0,null,null,{"$f":"IF(SUM(K143:K154)>P145,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G146","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$143:K146)+$L$139+IF(H147=\"before 5th\",K147,0)","v":983809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G147","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$143:K147)+$L$139+IF(H148=\"before 5th\",K148,0)","v":988809.93700000003},0,null,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":993809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G149","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$143:K149)+$L$139+IF(H150=\"before 5th\",K150,0)","v":998809.93700000003},0]
[null,null,null,null,null,null,{"$f":"G150","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$143:K150)+$L$139+IF(H151=\"before 5th\",K151,0)","v":1003809.937},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":1008809.937},0]
[null,null,null,null,null,null,{"$f":"G152","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$143:K152)+$L$139+IF(H153=\"before 5th\",K153,0)","v":1013809.937},0]
[null,null,null,null,null,null,{"$f":"G153","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$143:K153)+$L$139+IF(H154=\"before 5th\",K154,0)","v":1018809.937},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K143:K154)+SUM(M143:M154)+L139-N155","v":1018809.937},null,{"$f":"O143","v":0}]
[]
[null,null,null,null,null,null,null,null,10,{"$f":"CONCATENATE(\"FY \",$M$8+I157-1,\" - \",$M$8+I157)","v":"FY 2024 - 2025"},null,null,null,null,"Withdrawal can be made only once in a year"]
[null,null,null,null,null,null,"Interest rate","Deposited",null,"Month","Deposit","Balance","Interest",null,"Withdrawal"]
[null,null,null,null,null,null,null,"before 5th",null,"Apr",5000,{"$f":"$L$155+IF(H159=\"before 5th\",K159,0)","v":1023809.937},{"$f":"L159*G159/12","v":0}]
[null,null,null,{"$f":"IF(#REF!=0,\"Withdrawal limit\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"60%*$L$91","v":467285.96220000001},{"$f":"G159","v":0},"before 5th",null,"May",5000,{"$f":"SUM($K$159:K159)+$L$155+IF(H160=\"before 5th\",K160,0)","v":1028809.937},{"$f":"L160*G160/12","v":0},null,null,"PPF investment limit"]
[null,null,null,null,null,null,{"$f":"G160","v":0},"before 5th",null,"Jun",5000,{"$f":"SUM($K$159:K160)+$L$155+IF(H161=\"before 5th\",K161,0)","v":1033809.937},0,null,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":1038809.937},0,null,null,{"$f":"IF(SUM(K159:K170)>P161,\"Warning: total investment exceeds allowed limit\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"G162","v":0},"before 5th",null,"Aug",5000,{"$f":"SUM($K$159:K162)+$L$155+IF(H163=\"before 5th\",K163,0)","v":1043809.937},0]
[null,null,null,null,null,null,{"$f":"G163","v":0},"before 5th",null,"Sep",5000,{"$f":"SUM($K$159:K163)+$L$155+IF(H164=\"before 5th\",K164,0)","v":1048809.9369999999},0,null,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":1053809.9369999999},0]
[null,null,null,null,null,null,{"$f":"G165","v":0},"before 5th",null,"Nov",5000,{"$f":"SUM($K$159:K165)+$L$155+IF(H166=\"before 5th\",K166,0)","v":1058809.9369999999},0]
[null,null,null,null,null,null,{"$f":"G166","v":0},"before 5th",null,"Dec",5000,{"$f":"SUM($K$159:K166)+$L$155+IF(H167=\"before 5th\",K167,0)","v":1063809.9369999999},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":1068809.9369999999},0]
[null,null,null,null,null,null,{"$f":"G168","v":0},"before 5th",null,"Feb",5000,{"$f":"SUM($K$159:K168)+$L$155+IF(H169=\"before 5th\",K169,0)","v":1073809.9369999999},0]
[null,null,null,null,null,null,{"$f":"G169","v":0},"before 5th",null,"Mar",5000,{"$f":"SUM($K$159:K169)+$L$155+IF(H170=\"before 5th\",K170,0)","v":1078809.9369999999},0]
[null,null,null,null,null,null,null,null,null,"Year End Balance",null,{"$f":"SUM(K159:K170)+SUM(M159:M170)+L155-N171","v":1078809.9369999999},null,{"$f":"O159","v":0}]