{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Dashboard","Input-Basic","Input-MonthlyExpenses","Input-Events","TestCases"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":2,"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":"Dashboard","index":0,"n_rows":109,"n_cols":10,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["*Considers Investments/Events from beginning of each year"]
["*Considers Investments from your next year age."]
["*P.Y - Previous Year"]
["*C.Y - Current Year"]
[]
[]
[null,"YEAR","AGE","P.Y SAVINGS","C.Y SAVINGS","EVENTS","EVENTS DESCRIPTION","NET INVESTMENT","ROI","TOTAL"]
[]
[null,{"$f":"YEAR(TODAY())","v":2024},{"$f":"userAge+1","v":25},{"$f":"ROUND(userCurrentSavings-userCurrentLiabilities, 0)","v":50000},{"$f":"userAnnualSavings","v":360000},{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C9)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C9, 'Input-Events'!D$4:D$106, \"\"))","v":""},{"$f":"$D9+$E9+$F9","v":410000},{"$f":"ROUND(IF($C9>=userRetirementAge, IF($H9>0, $H9*annualEffectivePostRetirementROI, 0), IF($H9>0, $H9*annualEffectiveROI, 0)), 0)","v":16400},{"$f":"ROUND(H9+I9, 0)","v":426400}]
[null,{"$f":"B9+1","v":2025},{"$f":"C9+1","v":26},{"$f":"ROUND(J9, 0)","v":426400},{"$f":"ROUND(IF($C10>userRetirementAge, IF($D10>0,-FV(annualChangeInSWP, $C10-userRetirementAge-1, 0, -annualAmountSWP, 1), 0), E9+E9*(annualIncreaseInSavings)), 0)","v":378000},{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C10)","v":-50000},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C10, 'Input-Events'!D$4:D$106, \"\"))","v":"Mobile"},{"$f":"$D10+$E10+$F10","v":754400},30176,784576]
[null,2026,27,784576,396900,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C11)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C11, 'Input-Events'!D$4:D$106, \"\"))","v":""},1181476,47259,1228735]
[null,2027,28,1228735,416745,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C12)","v":-500000},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C12, 'Input-Events'!D$4:D$106, \"\"))","v":"Marriage"},1145480,45819,1191299]
[null,2028,29,1191299,437582,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C13)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C13, 'Input-Events'!D$4:D$106, \"\"))","v":""},1628881,65155,1694036]
[null,2029,30,1694036,459461,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C14)","v":-1000000},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C14, 'Input-Events'!D$4:D$106, \"\"))","v":"Car"},1153497,46140,1199637]
[null,2030,31,1199637,482434,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C15)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C15, 'Input-Events'!D$4:D$106, \"\"))","v":""},1682071,67283,1749354]
[null,2031,32,1749354,506556,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C16)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C16, 'Input-Events'!D$4:D$106, \"\"))","v":""},2255910,90236,2346146]
[null,2032,33,2346146,531884,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C17)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C17, 'Input-Events'!D$4:D$106, \"\"))","v":""},2878030,115121,2993151]
[null,2033,34,2993151,558478,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C18)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C18, 'Input-Events'!D$4:D$106, \"\"))","v":""},3551629,142065,3693694]
[null,2034,35,3693694,586402,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C19)","v":300000},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C19, 'Input-Events'!D$4:D$106, \"\"))","v":"PPF Maturity, Insurance Maturity"},4580096,183204,4763300]
[null,2035,36,4763300,615722,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C20)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C20, 'Input-Events'!D$4:D$106, \"\"))","v":""},5379022,215161,5594183]
[null,2036,37,5594183,646508,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C21)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C21, 'Input-Events'!D$4:D$106, \"\"))","v":""},6240691,249628,6490319]
[null,2037,38,6490319,678833,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C22)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C22, 'Input-Events'!D$4:D$106, \"\"))","v":""},7169152,286766,7455918]
[null,2038,39,7455918,712775,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C23)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C23, 'Input-Events'!D$4:D$106, \"\"))","v":""},8168693,326748,8495441]
[null,2039,40,8495441,748414,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C24)","v":-5000000},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C24, 'Input-Events'!D$4:D$106, \"\"))","v":"Home"},4243855,169754,4413609]
[null,2040,41,4413609,785835,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C25)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C25, 'Input-Events'!D$4:D$106, \"\"))","v":""},5199444,207978,5407422]
[null,2041,42,5407422,825127,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C26)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C26, 'Input-Events'!D$4:D$106, \"\"))","v":""},6232549,249302,6481851]
[null,2042,43,6481851,866383,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C27)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C27, 'Input-Events'!D$4:D$106, \"\"))","v":""},7348234,293929,7642163]
[null,2043,44,7642163,909702,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C28)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C28, 'Input-Events'!D$4:D$106, \"\"))","v":""},8551865,342075,8893940]
[null,2044,45,8893940,955187,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C29)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C29, 'Input-Events'!D$4:D$106, \"\"))","v":""},9849127,393965,10243092]
[null,2045,46,10243092,1002946,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C30)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C30, 'Input-Events'!D$4:D$106, \"\"))","v":""},11246038,449842,11695880]
[null,2046,47,11695880,1053093,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C31)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C31, 'Input-Events'!D$4:D$106, \"\"))","v":""},12748973,509959,13258932]
[null,2047,48,13258932,1105748,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C32)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C32, 'Input-Events'!D$4:D$106, \"\"))","v":""},14364680,574587,14939267]
[null,2048,49,14939267,1161035,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C33)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C33, 'Input-Events'!D$4:D$106, \"\"))","v":""},16100302,644012,16744314]
[null,2049,50,16744314,1219087,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C34)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C34, 'Input-Events'!D$4:D$106, \"\"))","v":""},17963401,718536,18681937]
[null,2050,51,18681937,1280041,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C35)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C35, 'Input-Events'!D$4:D$106, \"\"))","v":""},19961978,798479,20760457]
[null,2051,52,20760457,1344043,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C36)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C36, 'Input-Events'!D$4:D$106, \"\"))","v":""},22104500,884180,22988680]
[null,2052,53,22988680,1411245,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C37)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C37, 'Input-Events'!D$4:D$106, \"\"))","v":""},24399925,975997,25375922]
[null,2053,54,25375922,1481807,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C38)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C38, 'Input-Events'!D$4:D$106, \"\"))","v":""},26857729,1074309,27932038]
[null,2054,55,27932038,1555897,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C39)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C39, 'Input-Events'!D$4:D$106, \"\"))","v":""},29487935,1179517,30667452]
[null,2055,56,30667452,1633692,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C40)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C40, 'Input-Events'!D$4:D$106, \"\"))","v":""},32301144,1292046,33593190]
[null,2056,57,33593190,1715377,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C41)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C41, 'Input-Events'!D$4:D$106, \"\"))","v":""},35308567,{"$f":"ROUND(IF($C41>=userRetirementAge, IF($H41>0, $H41*annualEffectivePostRetirementROI, 0), IF($H41>0, $H41*annualEffectiveROI, 0)), 0)","v":1412343},{"$f":"ROUND(H41+I41, 0)","v":36720910}]
[null,{"$f":"B41+1","v":2057},{"$f":"C41+1","v":58},{"$f":"ROUND(J41, 0)","v":36720910},{"$f":"ROUND(IF($C42>userRetirementAge, IF($D42>0,-FV(annualChangeInSWP, $C42-userRetirementAge-1, 0, -annualAmountSWP, 1), 0), E41+E41*(annualIncreaseInSavings)), 0)","v":1801146},{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C42)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C42, 'Input-Events'!D$4:D$106, \"\"))","v":""},38522056,1540882,40062938]
[null,2058,59,40062938,1891203,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C43)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C43, 'Input-Events'!D$4:D$106, \"\"))","v":""},41954141,1678166,43632307]
[null,2059,60,43632307,1985763,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C44)","v":500000},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C44, 'Input-Events'!D$4:D$106, \"\"))","v":"International Trip, Retirement Corpus, Retirement"},46118070,922361,47040431]
[null,2060,61,47040431,-1200000,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C45)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C45, 'Input-Events'!D$4:D$106, \"\"))","v":""},45840431,916809,46757240]
[null,2061,62,46757240,-1260000,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C46)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C46, 'Input-Events'!D$4:D$106, \"\"))","v":""},45497240,909945,46407185]
[null,2062,63,46407185,-1323000,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C47)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C47, 'Input-Events'!D$4:D$106, \"\"))","v":""},45084185,901684,45985869]
[null,2063,64,45985869,-1389150,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C48)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C48, 'Input-Events'!D$4:D$106, \"\"))","v":""},44596719,891934,45488653]
[null,2064,65,45488653,-1458608,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C49)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C49, 'Input-Events'!D$4:D$106, \"\"))","v":""},44030045,880601,44910646]
[null,2065,66,44910646,-1531538,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C50)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C50, 'Input-Events'!D$4:D$106, \"\"))","v":""},43379108,867582,44246690]
[null,2066,67,44246690,-1608115,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C51)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C51, 'Input-Events'!D$4:D$106, \"\"))","v":""},42638575,852772,43491347]
[null,2067,68,43491347,-1688521,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C52)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C52, 'Input-Events'!D$4:D$106, \"\"))","v":""},41802826,836057,42638883]
[null,2068,69,42638883,-1772947,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C53)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C53, 'Input-Events'!D$4:D$106, \"\"))","v":""},40865936,817319,41683255]
[null,2069,70,41683255,-1861594,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C54)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C54, 'Input-Events'!D$4:D$106, \"\"))","v":""},39821661,796433,40618094]
[null,2070,71,40618094,-1954674,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C55)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C55, 'Input-Events'!D$4:D$106, \"\"))","v":""},38663420,773268,39436688]
[null,2071,72,39436688,-2052407,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C56)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C56, 'Input-Events'!D$4:D$106, \"\"))","v":""},37384281,747686,38131967]
[null,2072,73,38131967,-2155028,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C57)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C57, 'Input-Events'!D$4:D$106, \"\"))","v":""},35976939,719539,36696478]
[null,2073,74,36696478,-2262779,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C58)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C58, 'Input-Events'!D$4:D$106, \"\"))","v":""},34433699,688674,35122373]
[null,2074,75,35122373,-2375918,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C59)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C59, 'Input-Events'!D$4:D$106, \"\"))","v":""},32746455,654929,33401384]
[null,2075,76,33401384,-2494714,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C60)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C60, 'Input-Events'!D$4:D$106, \"\"))","v":""},30906670,618133,31524803]
[null,2076,77,31524803,-2619450,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C61)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C61, 'Input-Events'!D$4:D$106, \"\"))","v":""},28905353,578107,29483460]
[null,2077,78,29483460,-2750422,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C62)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C62, 'Input-Events'!D$4:D$106, \"\"))","v":""},26733038,534661,27267699]
[null,2078,79,27267699,-2887943,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C63)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C63, 'Input-Events'!D$4:D$106, \"\"))","v":""},24379756,487595,24867351]
[null,2079,80,24867351,-3032340,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C64)","v":10000000},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C64, 'Input-Events'!D$4:D$106, \"\"))","v":"Term Insurance, Life Expectancy"},31835011,636700,32471711]
[null,2080,81,32471711,-3183957,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C65)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C65, 'Input-Events'!D$4:D$106, \"\"))","v":""},29287754,585755,29873509]
[null,2081,82,29873509,-3343155,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C66)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C66, 'Input-Events'!D$4:D$106, \"\"))","v":""},26530354,530607,27060961]
[null,2082,83,27060961,-3510313,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C67)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C67, 'Input-Events'!D$4:D$106, \"\"))","v":""},23550648,471013,24021661]
[null,2083,84,24021661,-3685829,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C68)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C68, 'Input-Events'!D$4:D$106, \"\"))","v":""},20335832,406717,20742549]
[null,2084,85,20742549,-3870120,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C69)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C69, 'Input-Events'!D$4:D$106, \"\"))","v":""},16872429,337449,17209878]
[null,2085,86,17209878,-4063626,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C70)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C70, 'Input-Events'!D$4:D$106, \"\"))","v":""},13146252,262925,13409177]
[null,2086,87,13409177,-4266807,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C71)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C71, 'Input-Events'!D$4:D$106, \"\"))","v":""},9142370,182847,9325217]
[null,2087,88,9325217,-4480148,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C72)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C72, 'Input-Events'!D$4:D$106, \"\"))","v":""},4845069,96901,4941970]
[null,2088,89,4941970,-4704155,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C73)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C73, 'Input-Events'!D$4:D$106, \"\"))","v":""},237815,{"$f":"ROUND(IF($C73>=userRetirementAge, IF($H73>0, $H73*annualEffectivePostRetirementROI, 0), IF($H73>0, $H73*annualEffectiveROI, 0)), 0)","v":4756},{"$f":"ROUND(H73+I73, 0)","v":242571}]
[null,{"$f":"B73+1","v":2089},{"$f":"C73+1","v":90},{"$f":"ROUND(J73, 0)","v":242571},{"$f":"ROUND(IF($C74>userRetirementAge, IF($D74>0,-FV(annualChangeInSWP, $C74-userRetirementAge-1, 0, -annualAmountSWP, 1), 0), E73+E73*(annualIncreaseInSavings)), 0)","v":-4939363},{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C74)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C74, 'Input-Events'!D$4:D$106, \"\"))","v":""},{"$f":"$D74+$E74+$F74","v":-4696792},0,-4696792]
[null,2090,91,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C75)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C75, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2091,92,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C76)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C76, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2092,93,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C77)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C77, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2093,94,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C78)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C78, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2094,95,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C79)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C79, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2095,96,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C80)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C80, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2096,97,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C81)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C81, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2097,98,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C82)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C82, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2098,99,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C83)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C83, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2099,100,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C84)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C84, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2100,101,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C85)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C85, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2101,102,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C86)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C86, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2102,103,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C87)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C87, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2103,104,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C88)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C88, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2104,105,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C89)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C89, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2105,106,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C90)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C90, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2106,107,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C91)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C91, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2107,108,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C92)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C92, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2108,109,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C93)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C93, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2109,110,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C94)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C94, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2110,111,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C95)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C95, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2111,112,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C96)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C96, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2112,113,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C97)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C97, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2113,114,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C98)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C98, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2114,115,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C99)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C99, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2115,116,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C100)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C100, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2116,117,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C101)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C101, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2117,118,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C102)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C102, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2118,119,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C103)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C103, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2119,120,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C104)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C104, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2120,121,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C105)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C105, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,{"$f":"ROUND(H105+I105, 0)","v":-4696792}]
[null,2121,122,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C106)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C106, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2122,123,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C107)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C107, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2123,124,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C108)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C108, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]
[null,2124,125,-4696792,0,{"$f":"-SUMIFS('Input-Events'!F$4:F$106, 'Input-Events'!E$4:E$106, $C109)","v":0},{"$f":"_xlfn.TEXTJOIN(\", \", TRUE, IF('Input-Events'!E$4:E$106=$C109, 'Input-Events'!D$4:D$106, \"\"))","v":""},-4696792,0,-4696792]

{"sheet":"Input-Basic","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,4,6,5]]}
[null,"User Fields (Editable)",null,null,null,null,null,null,"*Edit only the fields with Blue Background"]
[null,"Formula Fields (Do not Edit)"]
[null,"Title or Description"]
[]
[]
[]
[null,"User Inputs",null,null,"Computed Values"]
[]
[null,"Name","Ganesh",null,"Age",{"$f":"DATEDIF(C10, TODAY(), \"y\")","v":24}]
[null,"DOB","2000-01-01",null,"Monthly Expenses",{"$f":"userMonthlyExpenses","v":20000}]
[null,"Monthly Income",50000]
[null,"Current Savings",100000,null,"Annual Savings/Investments",{"$f":"ROUND(12*(userIncome-userMonthlyExpenses),0)","v":360000}]
[null,"Current Liabilities",50000,null,"Effective ROI",{"$f":"$C$16-SUM($C$17:$C$19)","v":3.9999999999999994E-2}]
[null,null,null,null,"Effective ROI after Retirement",{"$f":"$C$24-SUM($C$25:$C$27)","v":2.0000000000000004E-2}]
[null,"PRE RETIREMENT"]
[null,"Annual ROI (%)",0.15]
[null,"Annual Inflation (%)",7.0000000000000007E-2]
[null,"Annual Life Style Inflation (%)",0.03]
[null,"Others (%)",0.01]
[]
[null,"Annual Increase In Savings (%)",0.05]
[]
[null,"POST RETIREMENT"]
[null,"Post Retirement ROI (%)",0.1]
[null,"Post Retirement Annual Inflation (%)",7.0000000000000007E-2]
[null,"Post Retirement Life Style Inflation (%)",0.01]
[null,"Others (%)",0]
[]
[null," Post Retirement Annual Withdrawal (SWP)",1200000]
[null,"Annual Change In SWP (%)",0.05]
[]
[null,"MAIN EVENTS"]
[null,"Retirement Age",60]
[null,"Life Expectancy Age",80]

{"sheet":"Input-MonthlyExpenses","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,11,0,13]]}
[null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"*Make sure total expense doesn't exceed monthly income of \", userMonthlyIncome )","v":"*Make sure total expense doesn't exceed monthly income of 50000"},null,null,"Conversion Tool"]
[]
["Monthly Expenses Total",{"$f":"SUM(E4:E45)","v":20000},null,"Description","Amount",null,null,null,null,null,null,"Yearly",12000,{"$f":"ROUND(M3/12, 0)","v":1000}]
[null,null,null,"Rent",10000,null,null,null,null,null,null,"Half-Yearly",6000,{"$f":"ROUND(M4/6, 0)","v":1000}]
[null,null,null,"EMI",3000,null,null,null,null,null,null,"Quarterly",3000,{"$f":"ROUND(M5/3, 0)","v":1000}]
[null,null,null,"Credit Cards",3000,null,null,null,null,null,null,"Bi-Monthly",2000,{"$f":"ROUND(M6/2, 0)","v":1000}]
[null,null,null,"Groceries",2000,null,null,null,null,null,null,"Weekly",250,{"$f":"ROUND(M7*4, 0)","v":1000}]
[null,null,null,"Utilities",1000,null,null,null,null,null,null,"Daily",100,{"$f":"ROUND(M8*30, 0)","v":3000}]
[null,null,null,"Misc",1000]

{"sheet":"Input-Events","index":3,"n_rows":106,"n_cols":9,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"*If any income is expected on certain age, kindly provide negative value"]
[]
["Total Expense Events",{"$f":"SUMIF($F$4:$F$106, \">=0\")","v":7050000},null,"Important Events","Age","Amount"]
["Total Income Events",{"$f":"-SUMIF($F$4:$F$106, \"<0\")","v":11300000},null,"Education"]
[null,null,null,"Mobile",26,50000]
[null,null,null,"Bike"]
[null,null,null,"Car",30,1000000]
[null,null,null,"Domestic Trip"]
[null,null,null,"International Trip",60,500000]
[null,null,null,"Marriage",28,500000]
[null,null,null,"Home",40,5000000]
[null,null,null,"Children Education"]
[null,null,null,"Children Marriage"]
[null,null,null,"Gift"]
[null,null,null,"Event #1",null,0]
[null,null,null,"Event #2"]
[null,null,null,"Event #3"]
[null,null,null,"Event #4"]
[null,null,null,"Event #5"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"PPF Maturity",35,-200000]
[null,null,null,"Insurance Maturity",35,-100000]
[null,null,null,"Retirement Corpus",{"$f":"userRetirementAge","v":60},-1000000]
[null,null,null,"Term Insurance",{"$f":"userLifeExpectancyAge","v":80},-10000000]
[null,null,null,"Retirement",{"$f":"userRetirementAge","v":60}]
[null,null,null,"Life Expectancy",{"$f":"userLifeExpectancyAge","v":80}]

{"sheet":"TestCases","index":4,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,3,4,4]]}
["*Copy and paste only the values to test"]
[]
[]
[]
["User Inputs",null,null,"User Inputs"]
[]
["Name","Ganesh",null,"Name","Ganesh"]
["DOB","2000-01-01",null,"DOB","1970-01-01"]
["Monthly Income",50000,null,"Monthly Income",150000]
["Current Savings",100000,null,"Current Savings",1000000]
["Current Liabilities",50000,null,"Current Liabilities",0]
[]
["PRE RETIREMENT",null,null,"PRE RETIREMENT"]
["Annual ROI (%)",0.15,null,"Annual ROI (%)",0.12]
["Annual Inflation (%)",7.0000000000000007E-2,null,"Annual Inflation (%)",7.0000000000000007E-2]
["Annual Life Style Inflation (%)",0.03,null,"Annual Life Style Inflation (%)",0.03]
["Others (%)",0.01,null,"Others (%)",0.01]
[]
["Annual Increase In Savings (%)",0.05,null,"Annual Increase In Savings (%)",0.05]
[]
["POST RETIREMENT",null,null,"POST RETIREMENT"]
["Post Retirement ROI (%)",0.1,null,"Post Retirement ROI (%)",0.1]
["Post Retirement Annual Inflation (%)",7.0000000000000007E-2,null,"Post Retirement Annual Inflation (%)",7.0000000000000007E-2]
["Post Retirement Life Style Inflation (%)",0.01,null,"Post Retirement Life Style Inflation (%)",0.01]
["Others (%)",0.01,null,"Others (%)",0]
[]
[" Post Retirement Annual Withdrawal (SWP)",1200000,null," Post Retirement Annual Withdrawal (SWP)",1200000]
["Annual Change In SWP (%)",0.05,null,"Annual Change In SWP (%)",0.05]
[]
["MAIN EVENTS",null,null,"MAIN EVENTS"]
["Retirement Age",60,null,"Retirement Age",60]
["Life Expectancy Age",80,null,"Life Expectancy Age",80]