{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Comp","Mort","Salary","Retire"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Comp","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Base Family Salary",100000," enter your base salary"]
[{"$nulls":9},"The split"]
["Item","Company","Employee","Total",null,"Comp","Emp","Total",null,"Comp","Emp"]
["Medical",0.09109,0.02272,0.11381000000000001,null,9109,2272,11381,null,0.8003690361128196,0.19963096388718038]
["Vision",0.00126,0.001,0.00226,null,126,100,225.99999999999997,null,0.5575221238938053,0.4424778761061947]
["Dental",0.00691,0.00245,0.00936,null,691,245,936,null,0.7382478632478633,0.26175213675213677]
["Mental Health Support",0.0005,null,0.0005,null,50,0,50,null,1,0]
["Term Life",0.00746,null,0.00746,null,746,0,746,null,1,0]
["Group Life",null,0.00794,0.00794,null,0,793.9999999999999,793.9999999999999,null,0,1]
["Long Term Disability",null,0.00536,0.00536,null,0,536,536,null,0,1]
["Accident Insurance",null,0.00061,0.00061,null,0,61,61,null,0,1]
["Defined Benefit Retirement",0.07638,null,0.07638,null,7638,0,7638,null,1,0]
["401K Savings",0.07,0.07,0.14,null,7000.000000000001,7000.000000000001,14000.000000000002,null,0.5,0.5]
["Social Securiy and Medicare",0.075,0.075,0.15,null,7500,7500,15000,null,0.5,0.5]
["Unemployment",0.0045,0.00097,0.00547,null,449.99999999999994,97,547,null,0.8226691042047531,0.1773308957952468]
["Holidays",0.030136986301369864,null,0.030136986301369864,null,3013.6986301369866,0,3013.6986301369866,null,1,0]
["Vacation",0.0410958904109589,null,0.0410958904109589,null,4109.58904109589,0,4109.58904109589,null,1,0]
[]
["Total",0.40433287671232876,0.18605000000000002,0.5903828767123288,null,40433.28767123287,18605.000000000004,59038.28767123288,null,0.6848655214459156,0.31513447855408444]
[]
["Salary plus Benefits",133310,"less vacation and holidays"]
["Total Compensation",140433.2876712329,"with vacation and holidays",null,null,"if you consult this is your package"]
["Notes:"]
["The pink are really fixed costs but here they move up and down with the salary"]
["Holidays and vacations are the first to suffer in consulting"]

{"sheet":"Mort","index":1,"n_rows":365,"n_cols":27,"rows_kept":365,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["30 years",{"$nulls":6},"15 years",{"$nulls":6},"10 years",{"$nulls":6},"5 years"]
["Totals",216360,null,"Bottom",-850.7654604232687,null,null,"Totals",152460,null,"Bottom",-66.7594228443985,null,null,"Totals",134160,null,"Bottom",-158.6431108408152,null,null,"Totals",117720,null,"Bottom",-41.57672181135672]
[]
["Month","Payment","Pmnts","%","Principal",null,null,"Month","Payment","Pmnts","%","Principal",null,null,"Month","Payment","Pmnts","%","Principal",null,null,"Month","Payment","Pmnts","%","Principal"]
[1,601,601,0.06,100000,"loan",null,1,847,847,0.06,100000,"loan",null,1,1118,1118,0.06,100000,"loan",null,1,1962,1962,0.06,100000,"loan"]
[2,601,1202,0.06,99898.99999999999,null,null,2,847,1694,0.06,99652.99999999999,null,null,2,1118,2236,0.06,99381.99999999999,null,null,2,1962,3924,0.06,98537.99999999999]
[3,601,1803,0.06,99797.49499999998,null,null,3,847,2541,0.06,99304.26499999997,null,null,3,1118,3354,0.06,98760.90999999997,null,null,3,1962,5886,0.06,97068.68999999997]
[4,601,2404,0.06,99695.48247499997,null,null,4,847,3388,0.06,98953.78632499996,null,null,4,1118,4472,0.06,98136.71454999996,null,null,4,1962,7848,0.06,95592.03344999996]
[5,601,3005,0.06,99592.95988737496,null,null,5,847,4235,0.06,98601.55525662495,null,null,5,1118,5590,0.06,97509.39812274995,null,null,5,1962,9810,0.06,94107.99361724994]
[6,601,3606,0.06,99489.92468681182,null,null,6,847,5082,0.06,98247.56303290807,null,null,6,1118,6708,0.06,96878.94511336369,null,null,6,1962,11772,0.06,92616.53358533619]
[7,601,4207,0.06,99386.37431024587,null,null,7,847,5929,0.06,97891.8008480726,null,null,7,1118,7826,0.06,96245.3398389305,null,null,7,1962,13734,0.06,91117.61625326287]
[8,601,4808,0.06,99282.30618179709,null,null,8,847,6776,0.06,97534.25985231296,null,null,8,1118,8944,0.06,95608.56653812513,null,null,8,1962,15696,0.06,89611.20433452917]
[9,601,5409,0.06,99177.71771270606,null,null,9,847,7623,0.06,97174.9311515745,null,null,9,1118,10062,0.06,94968.60937081574,null,null,9,1962,17658,0.06,88097.2603562018]
[10,601,6010,0.06,99072.60630126958,null,null,10,847,8470,0.06,96813.80580733236,null,null,10,1118,11180,0.06,94325.45241766982,null,null,10,1962,19620,0.06,86575.7466579828]
[11,601,6611,0.06,98966.96933277592,null,null,11,847,9317,0.06,96450.87483636901,null,null,11,1118,12298,0.06,93679.07967975816,null,null,11,1962,21582,0.06,85046.62539127271]
[12,601,7212,0.06,98860.80417943979,null,null,12,847,10164,0.06,96086.12921055085,null,null,12,1118,13416,0.06,93029.47507815693,null,null,12,1962,23544,0.06,83509.85851822907]
[13,601,7813,0.06,98754.10820033698,null,null,13,847,11011,0.06,95719.55985660359,null,null,13,1118,14534,0.06,92376.62245354771,null,null,13,1962,25506,0.06,81965.40781082021]
[14,601,8414,0.06,98646.87874133866,null,null,14,847,11858,0.06,95351.15765588659,null,null,14,1118,15652,0.06,91720.50556581543,null,null,14,1962,27468,0.06,80413.2348498743]
[15,601,9015,0.06,98539.11313504534,null,null,15,847,12705,0.06,94980.91344416601,null,null,15,1118,16770,0.06,91061.10809364449,null,null,15,1962,29430,0.06,78853.30102412366]
[16,601,9616,0.06,98430.80870072055,null,null,16,847,13552,0.06,94608.81801138683,null,null,16,1118,17888,0.06,90398.4136341127,null,null,16,1962,31392,0.06,77285.56752924428]
[17,601,10217,0.06,98321.96274422413,null,null,17,847,14399,0.06,94234.86210144375,null,null,17,1118,19006,0.06,89732.40570228326,null,null,17,1962,33354,0.06,75709.9953668905]
[18,601,10818,0.06,98212.57255794524,null,null,18,847,15246,0.06,93859.03641195096,null,null,18,1118,20124,0.06,89063.06773079466,null,null,18,1962,35316,0.06,74126.54534372494]
[19,601,11419,0.06,98102.63542073495,null,null,19,847,16093,0.06,93481.33159401071,null,null,19,1118,21242,0.06,88390.38306944862,null,null,19,1962,37278,0.06,72535.17807044355]
[20,601,12020,0.06,97992.14859783862,null,null,20,847,16940,0.06,93101.73825198076,null,null,20,1118,22360,0.06,87714.33498479586,null,null,20,1962,39240,0.06,70935.85396079576]
[21,601,12621,0.06,97881.1093408278,null,null,21,847,17787,0.06,92720.24694324065,null,null,21,1118,23478,0.06,87034.90665971983,null,null,21,1962,41202,0.06,69328.53323059973]
[22,601,13222,0.06,97769.51488753193,null,null,22,847,18634,0.06,92336.84817795684,null,null,22,1118,24596,0.06,86352.08119301841,null,null,22,1962,43164,0.06,67713.17589675271]
[23,601,13823,0.06,97657.36246196958,null,null,23,847,19481,0.06,91951.53241884662,null,null,23,1118,25714,0.06,85665.84159898349,null,null,23,1962,45126,0.06,66089.74177623646]
[24,601,14424,0.06,97544.6492742794,null,null,24,847,20328,0.06,91564.29008094085,null,null,24,1118,26832,0.06,84976.17080697839,null,null,24,1962,47088,0.06,64458.19048511764]
[25,601,15025,0.06,97431.3725206508,null,null,25,847,21175,0.06,91175.11153134554,null,null,25,1118,27950,0.06,84283.05166101328,null,null,25,1962,49050,0.06,62818.48143754322]
[26,601,15626,0.06,97317.52938325403,null,null,26,847,22022,0.06,90783.98708900226,null,null,26,1118,29068,0.06,83586.46691931834,null,null,26,1962,51012,0.06,61170.57384473093]
[27,601,16227,0.06,97203.1170301703,null,null,27,847,22869,0.06,90390.90702444725,null,null,27,1118,30186,0.06,82886.39925391492,null,null,27,1962,52974,0.06,59514.42671395458]
[28,601,16828,0.06,97088.13261532114,null,null,28,847,23716,0.06,89995.86155956949,null,null,28,1118,31304,0.06,82182.83125018448,null,null,28,1962,54936,0.06,57849.998847524344]
[29,601,17429,0.06,96972.57327839774,null,null,29,847,24563,0.06,89598.84086736733,null,null,29,1118,32422,0.06,81475.7454064354,null,null,29,1962,56898,0.06,56177.24884176196]
[30,601,18030,0.06,96856.43614478972,null,null,30,847,25410,0.06,89199.83507170415,null,null,30,1118,33540,0.06,80765.12413346756,null,null,30,1962,58860,0.06,54496.13508597077]
[31,601,18631,0.06,96739.71832551366,null,null,31,847,26257,0.06,88798.83424706265,null,null,31,1118,34658,0.06,80050.94975413488,null,null,31,1962,60822,0.06,52806.615761400615]
[32,601,19232,0.06,96622.41691714122,null,null,32,847,27104,0.06,88395.82841829796,null,null,32,1118,35776,0.06,79333.20450290554,null,null,32,1962,62784,0.06,51108.648840207614]
[33,601,19833,0.06,96504.52900172691,null,null,33,847,27951,0.06,87990.80756038944,null,null,33,1118,36894,0.06,78611.87052542006,null,null,33,1962,64746,0.06,49402.19208440865]
[34,601,20434,0.06,96386.05164673553,null,null,34,847,28798,0.06,87583.76159819138,null,null,34,1118,38012,0.06,77886.92987804716,null,null,34,1962,66708,0.06,47687.20304483069]
[35,601,21035,0.06,96266.9819049692,null,null,35,847,29645,0.06,87174.68040618233,null,null,35,1118,39130,0.06,77158.36452743738,null,null,35,1962,68670,0.06,45963.63906005484]
[36,601,21636,0.06,96147.31681449404,null,null,36,847,30492,0.06,86763.55380821324,null,null,36,1118,40248,0.06,76426.15635007457,null,null,36,1962,70632,0.06,44231.45725535511]
[37,601,22237,0.06,96027.05339856651,null,null,37,847,31339,0.06,86350.3715772543,null,null,37,1118,41366,0.06,75690.28713182494,null,null,37,1962,72594,0.06,42490.61454163188]
[38,601,22838,0.06,95906.18866555933,null,null,38,847,32186,0.06,85935.12343514056,null,null,38,1118,42484,0.06,74950.73856748405,null,null,38,1962,74556,0.06,40741.06761434004]
[39,601,23439,0.06,95784.71960888711,null,null,39,847,33033,0.06,85517.79905231626,null,null,39,1118,43602,0.06,74207.49226032147,null,null,39,1962,76518,0.06,38982.77295241174]
[40,601,24040,0.06,95662.64320693153,null,null,40,847,33880,0.06,85098.38804757783,null,null,40,1118,44720,0.06,73460.52972162307,null,null,40,1962,78480,0.06,37215.686817173795]
[41,601,24641,0.06,95539.95642296618,null,null,41,847,34727,0.06,84676.87998781572,null,null,41,1118,45838,0.06,72709.83237023118,null,null,41,1962,80442,0.06,35439.76525125966]
[42,601,25242,0.06,95416.656205081,null,null,42,847,35574,0.06,84253.26438775478,null,null,42,1118,46956,0.06,71955.38153208232,null,null,42,1962,82404,0.06,33654.96407751596]
[43,601,25843,0.06,95292.7394861064,null,null,43,847,36421,0.06,83827.53070969354,null,null,43,1118,48074,0.06,71197.15843974272,null,null,43,1962,84366,0.06,31861.23889790353]
[44,601,26444,0.06,95168.20318353691,null,null,44,847,37268,0.06,83399.668363242,null,null,44,1118,49192,0.06,70435.14423194143,null,null,44,1962,86328,0.06,30058.545092393044]
[45,601,27045,0.06,95043.04419945458,null,null,45,847,38115,0.06,82969.6667050582,null,null,45,1118,50310,0.06,69669.31995310113,null,null,45,1962,88290,0.06,28246.837817855005]
[46,601,27646,0.06,94917.25942045184,null,null,46,847,38962,0.06,82537.51503858349,null,null,46,1118,51428,0.06,68899.66655286663,null,null,46,1962,90252,0.06,26426.072006944276]
[47,601,28247,0.06,94790.84571755408,null,null,47,847,39809,0.06,82103.20261377639,null,null,47,1118,52546,0.06,68126.16488563096,null,null,47,1962,92214,0.06,24596.202366978996]
[48,601,28848,0.06,94663.79994614184,null,null,48,847,40656,0.06,81666.71862684526,null,null,48,1118,53664,0.06,67348.79571005912,null,null,48,1962,94176,0.06,22757.18337881389]
[49,601,29449,0.06,94536.11894587254,null,null,49,847,41503,0.06,81228.05221997948,null,null,49,1118,54782,0.06,66567.53968860941,null,null,49,1962,96138,0.06,20908.969295707957]
[50,601,30050,0.06,94407.79954060189,null,null,50,847,42350,0.06,80787.19248107937,null,null,50,1118,55900,0.06,65782.37738705245,null,null,50,1962,98100,0.06,19051.514142186494]
[51,601,30651,0.06,94278.83853830489,null,null,51,847,43197,0.06,80344.12844348476,null,null,51,1118,57018,0.06,64993.2892739877,null,null,51,1962,100062,0.06,17184.771712897425]
[52,601,31252,0.06,94149.2327309964,null,null,52,847,44044,0.06,79898.84908570218,null,null,52,1118,58136,0.06,64200.25572035763,null,null,52,1962,102024,0.06,15308.69557146191]
[53,601,31853,0.06,94018.97889465137,null,null,53,847,44891,0.06,79451.34333113069,null,null,53,1118,59254,0.06,63403.25699895941,null,null,53,1962,103986,0.06,13423.239049319218]
[54,601,32454,0.06,93888.07378912462,null,null,54,847,45738,0.06,79001.60004778633,null,null,54,1118,60372,0.06,62602.2732839542,null,null,54,1962,105948,0.06,11528.355244565813]
[55,601,33055,0.06,93756.51415807023,null,null,55,847,46585,0.06,78549.60804802526,null,null,55,1118,61490,0.06,61797.284650373964,null,null,55,1962,107910,0.06,9623.997020788642]
[56,601,33656,0.06,93624.29672886057,null,null,56,847,47432,0.06,78095.35608826537,null,null,56,1118,62608,0.06,60988.27107362583,null,null,56,1962,109872,0.06,7710.117005892584]
[57,601,34257,0.06,93491.41821250487,null,null,57,847,48279,0.06,77638.83286870668,null,null,57,1118,63726,0.06,60175.21242899395,null,null,57,1962,111834,0.06,5786.667590922046]
[58,601,34858,0.06,93357.87530356739,null,null,58,847,49126,0.06,77180.02703305021,null,null,58,1118,64844,0.06,59358.088491138915,null,null,58,1962,113796,0.06,3853.6009288766554]
[59,601,35459,0.06,93223.66468008522,null,null,59,847,49973,0.06,76718.92716821545,null,null,59,1118,65962,0.06,58536.878933594606,null,null,59,1962,115758,0.06,1910.8689335210383]
[60,601,36060,0.06,93088.78300348563,null,null,60,847,50820,0.06,76255.52180405652,null,null,60,1118,67080,0.06,57711.56332826257,null,null,60,1962,117720,0.06,-41.57672181135672]
[61,601,36661,0.06,92953.22691850305,null,null,61,847,51667,0.06,75789.79941307679,null,null,61,1118,68198,0.06,56882.121144903875]
[62,601,37262,0.06,92816.99305309555,null,null,62,847,52514,0.06,75321.74841014217,null,null,62,1118,69316,0.06,56048.53175062839]
[63,601,37863,0.06,92680.07801836102,null,null,63,847,53361,0.06,74851.35715219287,null,null,63,1118,70434,0.06,55210.77440938153]
[64,601,38464,0.06,92542.47840845281,null,null,64,847,54208,0.06,74378.61393795382,null,null,64,1118,71552,0.06,54368.82828142843]
[65,601,39065,0.06,92404.19080049507,null,null,65,847,55055,0.06,73903.50700764358,null,null,65,1118,72670,0.06,53522.67242283557]
[66,601,39666,0.06,92265.21175449753,null,null,66,847,55902,0.06,73426.02454268179,null,null,66,1118,73788,0.06,52672.28578494974]
[67,601,40267,0.06,92125.53781327001,null,null,67,847,56749,0.06,72946.15466539518,null,null,67,1118,74906,0.06,51817.64721387448]
[68,601,40868,0.06,91985.16550233636,null,null,68,847,57596,0.06,72463.88543872215,null,null,68,1118,76024,0.06,50958.735449943844]
[69,601,41469,0.06,91844.09132984803,null,null,69,847,58443,0.06,71979.20486591576,null,null,69,1118,77142,0.06,50095.52912719356]
[70,601,42070,0.06,91702.31178649726,null,null,70,847,59290,0.06,71492.10089024533,null,null,70,1118,78260,0.06,49228.00677282952]
[71,601,42671,0.06,91559.82334542973,null,null,71,847,60137,0.06,71002.56139469655,null,null,71,1118,79378,0.06,48356.14680669366]
[72,601,43272,0.06,91416.62246215687,null,null,72,847,60984,0.06,70510.57420167002,null,null,72,1118,80496,0.06,47479.92754072712]
[73,601,43873,0.06,91272.70557446765,null,null,73,847,61831,0.06,70016.12707267837,null,null,73,1118,81614,0.06,46599.32717843075]
[74,601,44474,0.06,91128.06910233997,null,null,74,847,62678,0.06,69519.20770804175,null,null,74,1118,82732,0.06,45714.3238143229]
[75,601,45075,0.06,90982.70944785167,null,null,75,847,63525,0.06,69019.80374658195,null,null,75,1118,83850,0.06,44824.895433394515]
[76,601,45676,0.06,90836.62299509092,null,null,76,847,64372,0.06,68517.90276531485,null,null,76,1118,84968,0.06,43931.01991056148]
[77,601,46277,0.06,90689.80611006636,null,null,77,847,65219,0.06,68013.49227914141,null,null,77,1118,86086,0.06,43032.67501011428]
[78,601,46878,0.06,90542.25514061669,null,null,78,847,66066,0.06,67506.55974053711,null,null,78,1118,87204,0.06,42129.83838516485]
[79,601,47479,0.06,90393.96641631976,null,null,79,847,66913,0.06,66997.09253923979,null,null,79,1118,88322,0.06,41222.487577090666]
[80,601,48080,0.06,90244.93624840135,null,null,80,847,67760,0.06,66485.07800193598,null,null,80,1118,89440,0.06,40310.60001497612]
[81,601,48681,0.06,90095.16092964335,null,null,81,847,68607,0.06,65970.50339194565,null,null,81,1118,90558,0.06,39394.15301505099]
[82,601,49282,0.06,89944.63673429155,null,null,82,847,69454,0.06,65453.355908905374,null,null,82,1118,91676,0.06,38473.12378012625]
[83,601,49883,0.06,89793.359917963,null,null,83,847,70301,0.06,64933.62268844989,null,null,83,1118,92794,0.06,37547.489399026876]
[84,601,50484,0.06,89641.3267175528,null,null,84,847,71148,0.06,64411.29080189213,null,null,84,1118,93912,0.06,36617.22684602201]
[85,601,51085,0.06,89488.53335114056,null,null,85,847,71995,0.06,63886.347255901586,null,null,85,1118,95030,0.06,35682.312980252114]
[86,601,51686,0.06,89334.97601789626,null,null,86,847,72842,0.06,63358.77899218109,null,null,86,1118,96148,0.06,34742.724545153374]
[87,601,52287,0.06,89180.65089798573,null,null,87,847,73689,0.06,62828.57288714199,null,null,87,1118,97266,0.06,33798.43816787914]
[88,601,52888,0.06,89025.55415247566,null,null,88,847,74536,0.06,62295.71575157769,null,null,88,1118,98384,0.06,32849.430358718535]
[89,601,53489,0.06,88869.68192323802,null,null,89,847,75383,0.06,61760.19433033557,null,null,89,1118,99502,0.06,31895.677510512127]
[90,601,54090,0.06,88713.0303328542,null,null,90,847,76230,0.06,61221.99530198724,null,null,90,1118,100620,0.06,30937.155898064684]
[91,601,54691,0.06,88555.59548451848,null,null,91,847,77077,0.06,60681.10527849717,null,null,91,1118,101738,0.06,29973.841677555003]
[92,601,55292,0.06,88397.37346194105,null,null,92,847,77924,0.06,60137.51080488965,null,null,92,1118,102856,0.06,29005.710885942775]
[93,601,55893,0.06,88238.36032925075,null,null,93,847,78771,0.06,59591.198358914095,null,null,93,1118,103974,0.06,28032.739440372487]
[94,601,56494,0.06,88078.55213089699,null,null,94,847,79618,0.06,59042.15435070866,null,null,94,1118,105092,0.06,27054.903137574347]
[95,601,57095,0.06,87917.94489155147,null,null,95,847,80465,0.06,58490.3651224622,null,null,95,1118,106210,0.06,26072.177653262217]
[96,601,57696,0.06,87756.53461600922,null,null,96,847,81312,0.06,57935.816948074505,null,null,96,1118,107328,0.06,25084.538541528524]
[97,601,58297,0.06,87594.31728908925,null,null,97,847,82159,0.06,57378.49603281487,null,null,97,1118,108446,0.06,24091.961234236165]
[98,601,58898,0.06,87431.28887553468,null,null,98,847,83006,0.06,56818.38851297894,null,null,98,1118,109564,0.06,23094.421040407342]
[99,601,59499,0.06,87267.44531991234,null,null,99,847,83853,0.06,56255.48045554383,null,null,99,1118,110682,0.06,22091.893145609378]
[100,601,60100,0.06,87102.7825465119,null,null,100,847,84700,0.06,55689.75785782155,null,null,100,1118,111800,0.06,21084.35261133742]
[101,601,60701,0.06,86937.29645924445,null,null,101,847,85547,0.06,55121.20664711065,null,null,101,1118,112918,0.06,20071.774374394106]
[102,601,61302,0.06,86770.98294154066,null,null,102,847,86394,0.06,54549.8126803462,null,null,102,1118,114036,0.06,19054.133246266076]
[103,601,61903,0.06,86603.83785624836,null,null,103,847,87241,0.06,53975.56174374792,null,null,103,1118,115154,0.06,18031.403912497404]
[104,601,62504,0.06,86435.85704552958,null,null,104,847,88088,0.06,53398.439552466654,null,null,104,1118,116272,0.06,17003.56093205989]
[105,601,63105,0.06,86267.03633075723,null,null,105,847,88935,0.06,52818.431750228985,null,null,105,1118,117390,0.06,15970.578736720185]
[106,601,63706,0.06,86097.371512411,null,null,106,847,89782,0.06,52235.523908980125,null,null,106,1118,118508,0.06,14932.431630403784]
[107,601,64307,0.06,85926.85836997305,null,null,107,847,90629,0.06,51649.70152852502,null,null,107,1118,119626,0.06,13889.093788555801]
[108,601,64908,0.06,85755.49266182291,null,null,108,847,91476,0.06,51060.95003616764,null,null,108,1118,120744,0.06,12840.539257498578]
[109,601,65509,0.06,85583.27012513201,null,null,109,847,92323,0.06,50469.25478634847,null,null,109,1118,121862,0.06,11786.74195378607]
[110,601,66110,0.06,85410.18647575765,null,null,110,847,93170,0.06,49874.60106028021,null,null,110,1118,122980,0.06,10727.675663555]
[111,601,66711,0.06,85236.23740813644,null,null,111,847,94017,0.06,49276.974065581606,null,null,111,1118,124098,0.06,9663.314041872773]
[112,601,67312,0.06,85061.4185951771,null,null,112,847,94864,0.06,48676.358935909506,null,null,112,1118,125216,0.06,8593.630612082135]
[113,601,67913,0.06,84885.72568815299,null,null,113,847,95711,0.06,48072.740730589045,null,null,113,1118,126334,0.06,7518.598765142546]
[114,601,68514,0.06,84709.15431659375,null,null,114,847,96558,0.06,47466.104434241985,null,null,114,1118,127452,0.06,6438.191758968258]
[115,601,69115,0.06,84531.7000881767,null,null,115,847,97405,0.06,46856.43495641319,null,null,115,1118,128570,0.06,5352.382717763098]
[116,601,69716,0.06,84353.35858861757,null,null,116,847,98252,0.06,46243.717131195255,null,null,116,1118,129688,0.06,4261.144631351914]
[117,601,70317,0.06,84174.12538156065,null,null,117,847,99099,0.06,45627.93571685123,null,null,117,1118,130806,0.06,3164.4503545086727]
[118,601,70918,0.06,83993.99600846844,null,null,118,847,99946,0.06,45009.07539543548,null,null,118,1118,131924,0.06,2062.2726062812158]
[119,601,71519,0.06,83812.96598851078,null,null,119,847,100793,0.06,44387.12077241265,null,null,119,1118,133042,0.06,954.5839693126218]
[120,601,72120,0.06,83631.03081845334,null,null,120,847,101640,0.06,43762.05637627471,null,null,120,1118,134160,0.06,-158.6431108408152]
[121,601,72721,0.06,83448.18597254559,null,null,121,847,102487,0.06,43133.86665815608]
[122,601,73322,0.06,83264.4269024083,null,null,122,847,103334,0.06,42502.53599144686]
[123,601,73923,0.06,83079.74903692033,null,null,123,847,104181,0.06,41868.04867140409]
[124,601,74524,0.06,82894.14778210492,null,null,124,847,105028,0.06,41230.388914761104]
[125,601,75125,0.06,82707.61852101544,null,null,125,847,105875,0.06,40589.540859334906]
[126,601,75726,0.06,82520.15661362051,null,null,126,847,106722,0.06,39945.488563631574]
[127,601,76327,0.06,82331.7573966886,null,null,127,847,107569,0.06,39298.21600644973]
[128,601,76928,0.06,82142.41618367203,null,null,128,847,108416,0.06,38647.707086481976]
[129,601,77529,0.06,81952.12826459038,null,null,129,847,109263,0.06,37993.94562191438]
[130,601,78130,0.06,81760.88890591332,null,null,130,847,110110,0.06,37336.91535002395]
[131,601,78731,0.06,81568.69335044287,null,null,131,847,110957,0.06,36676.59992677406]
[132,601,79332,0.06,81375.53681719508,null,null,132,847,111804,0.06,36012.98292640793]
[133,601,79933,0.06,81181.41450128105,null,null,133,847,112651,0.06,35346.04784103997]
[134,601,80534,0.06,80986.32157378744,null,null,134,847,113498,0.06,34675.77808024516]
[135,601,81135,0.06,80790.25318165637,null,null,135,847,114345,0.06,34002.156970646385]
[136,601,81736,0.06,80593.20444756464,null,null,136,847,115192,0.06,33325.16775549961]
[137,601,82337,0.06,80395.17046980246,null,null,137,847,116039,0.06,32644.793594277107]
[138,601,82938,0.06,80196.14632215146,null,null,138,847,116886,0.06,31961.01756224849]
[139,601,83539,0.06,79996.1270537622,null,null,139,847,117733,0.06,31273.82265005973]
[140,601,84140,0.06,79795.107689031,null,null,140,847,118580,0.06,30583.191763310024]
[141,601,84741,0.06,79593.08322747615,null,null,141,847,119427,0.06,29889.10772212657]
[142,601,85342,0.06,79390.04864361353,null,null,142,847,120274,0.06,29191.5532607372]
[143,601,85943,0.06,79185.99888683158,null,null,143,847,121121,0.06,28490.511027040884]
[144,601,86544,0.06,78980.92888126573,null,null,144,847,121968,0.06,27785.963582176086]
[145,601,87145,0.06,78774.83352567205,null,null,145,847,122815,0.06,27077.893400086963]
[146,601,87746,0.06,78567.7076933004,null,null,146,847,123662,0.06,26366.282867087393]
[147,601,88347,0.06,78359.54623176689,null,null,147,847,124509,0.06,25651.114281422826]
[148,601,88948,0.06,78150.34396292572,null,null,148,847,125356,0.06,24932.36985282994]
[149,601,89549,0.06,77940.09568274034,null,null,149,847,126203,0.06,24210.031702094086]
[150,601,90150,0.06,77728.79616115404,null,null,150,847,127050,0.06,23484.081860604554]
[151,601,90751,0.06,77516.4401419598,null,null,151,847,127897,0.06,22754.502269907574]
[152,601,91352,0.06,77303.02234266959,null,null,152,847,128744,0.06,22021.27478125711]
[153,601,91953,0.06,77088.53745438292,null,null,153,847,129591,0.06,21284.381155163395]
[154,601,92554,0.06,76872.98014165483,null,null,154,847,130438,0.06,20543.80306093921]
[155,601,93155,0.06,76656.3450423631,null,null,155,847,131285,0.06,19799.522076243906]
[156,601,93756,0.06,76438.62676757491,null,null,156,847,132132,0.06,19051.519686625124]
[157,601,94357,0.06,76219.81990141277,null,null,157,847,132979,0.06,18299.777285058248]
[158,601,94958,0.06,75999.91900091984,null,null,158,847,133826,0.06,17544.276171483536]
[159,601,95559,0.06,75778.91859592442,null,null,159,847,134673,0.06,16784.997552340952]
[160,601,96160,0.06,75556.81318890404,null,null,160,847,135520,0.06,16021.922540102656]
[161,601,96761,0.06,75333.59725484854,null,null,161,847,136367,0.06,15255.032152803167]
[162,601,97362,0.06,75109.26524112278,null,null,162,847,137214,0.06,14484.307313567182]
[163,601,97963,0.06,74883.81156732838,null,null,163,847,138061,0.06,13709.728850135016]
[164,601,98564,0.06,74657.23062516502,null,null,164,847,138908,0.06,12931.27749438569]
[165,601,99165,0.06,74429.51677829084,null,null,165,847,139755,0.06,12148.933881857616]
[166,601,99766,0.06,74200.66436218229,null,null,166,847,140602,0.06,11362.678551266903]
[167,601,100367,0.06,73970.66768399319,null,null,167,847,141449,0.06,10572.491944023237]
[168,601,100968,0.06,73739.52102241314,null,null,168,847,142296,0.06,9778.354403743351]
[169,601,101569,0.06,73507.2186275252,null,null,169,847,143143,0.06,8980.246175762068]
[170,601,102170,0.06,73273.75472066282,null,null,170,847,143990,0.06,8178.147406640877]
[171,601,102771,0.06,73039.12349426612,null,null,171,847,144837,0.06,7372.038143674081]
[172,601,103372,0.06,72803.31911173745,null,null,172,847,145684,0.06,6561.89833439245]
[173,601,103973,0.06,72566.33570729614,null,null,173,847,146531,0.06,5747.707826064412]
[174,601,104574,0.06,72328.16738583261,null,null,174,847,147378,0.06,4929.4463651947335]
[175,601,105175,0.06,72088.80822276177,null,null,175,847,148225,0.06,4107.0935970207065]
[176,601,105776,0.06,71848.25226387558,null,null,176,847,149072,0.06,3280.62906500581]
[177,601,106377,0.06,71606.49352519495,null,null,177,847,149919,0.06,2450.0322103308386]
[178,601,106978,0.06,71363.52599282091,null,null,178,847,150766,0.06,1615.2823713824923]
[179,601,107579,0.06,71119.343622785,null,null,179,847,151613,0.06,776.3587832394046]
[180,601,108180,0.06,70873.94034089892,null,null,180,847,152460,0.06,-66.7594228443985]
[181,601,108781,0.06,70627.3100426034]
[182,601,109382,0.06,70379.44659281641]
[183,601,109983,0.06,70130.34382578048]
[184,601,110584,0.06,69879.99554490938]
[185,601,111185,0.06,69628.39552263392]
[186,601,111786,0.06,69375.53750024708]
[187,601,112387,0.06,69121.41518774831]
[188,601,112988,0.06,68866.02226368705]
[189,601,113589,0.06,68609.35237500547]
[190,601,114190,0.06,68351.3991368805]
[191,601,114791,0.06,68092.1561325649]
[192,601,115392,0.06,67831.61691322771]
[193,601,115993,0.06,67569.77499779385]
[194,601,116594,0.06,67306.62387278282]
[195,601,117195,0.06,67042.15699214673]
[196,601,117796,0.06,66776.36777710746]
[197,601,118397,0.06,66509.24961599299]
[198,601,118998,0.06,66240.79586407295]
[199,601,119599,0.06,65970.9998433933]
[200,601,120200,0.06,65699.85484261026]
[201,601,120801,0.06,65427.354116823306]
[202,601,121402,0.06,65153.49088740742]
[203,601,122003,0.06,64878.25834184445]
[204,601,122604,0.06,64601.649633553665]
[205,601,123205,0.06,64323.657881721425]
[206,601,123806,0.06,64044.276171130026]
[207,601,124407,0.06,63763.49755198567]
[208,601,125008,0.06,63481.31503974559]
[209,601,125609,0.06,63197.72161494431]
[210,601,126210,0.06,62912.71022301903]
[211,601,126811,0.06,62626.27377413412]
[212,601,127412,0.06,62338.405143004784]
[213,601,128013,0.06,62049.0971687198]
[214,601,128614,0.06,61758.3426545634]
[215,601,129215,0.06,61466.13436783621]
[216,601,129816,0.06,61172.465039675386]
[217,601,130417,0.06,60877.32736487376]
[218,601,131018,0.06,60580.71400169812]
[219,601,131619,0.06,60282.61757170661]
[220,601,132220,0.06,59983.030659565135]
[221,601,132821,0.06,59681.945812862956]
[222,601,133422,0.06,59379.35554192727]
[223,601,134023,0.06,59075.2523196369]
[224,601,134624,0.06,58769.628581235076]
[225,601,135225,0.06,58462.47672414125]
[226,601,135826,0.06,58153.78910776195]
[227,601,136427,0.06,57843.55805330075]
[228,601,137028,0.06,57531.77584356725]
[229,601,137629,0.06,57218.43472278508]
[230,601,138230,0.06,56903.526896399]
[231,601,138831,0.06,56587.044530880994]
[232,601,139432,0.06,56268.979753535394]
[233,601,140033,0.06,55949.32465230306]
[234,601,140634,0.06,55628.07127556457]
[235,601,141235,0.06,55305.21163194239]
[236,601,141836,0.06,54980.73769010209]
[237,601,142437,0.06,54654.641378552595]
[238,601,143038,0.06,54326.91458544535]
[239,601,143639,0.06,53997.549158372574]
[240,601,144240,0.06,53666.53690416443]
[241,601,144841,0.06,53333.869588685244]
[242,601,145442,0.06,52999.53893662866]
[243,601,146043,0.06,52663.5366313118]
[244,601,146644,0.06,52325.85431446835]
[245,601,147245,0.06,51986.48358604069]
[246,601,147846,0.06,51645.41600397089]
[247,601,148447,0.06,51302.64308399073]
[248,601,149048,0.06,50958.15629941068]
[249,601,149649,0.06,50611.947080907725]
[250,601,150250,0.06,50264.006816312256]
[251,601,150851,0.06,49914.32685039381]
[252,601,151452,0.06,49562.898484645775]
[253,601,152053,0.06,49209.712977069]
[254,601,152654,0.06,48854.76154195434]
[255,601,153255,0.06,48498.03534966411]
[256,601,153856,0.06,48139.52552641243]
[257,601,154457,0.06,47779.223154044485]
[258,601,155058,0.06,47417.1192698147]
[259,601,155659,0.06,47053.20486616377]
[260,601,156260,0.06,46687.47089049458]
[261,601,156861,0.06,46319.90824494705]
[262,601,157462,0.06,45950.50778617178]
[263,601,158063,0.06,45579.26032510264]
[264,601,158664,0.06,45206.156626728145]
[265,601,159265,0.06,44831.187409861785]
[266,601,159866,0.06,44454.34334691109]
[267,601,160467,0.06,44075.61506364564]
[268,601,161068,0.06,43694.99313896386]
[269,601,161669,0.06,43312.46810465867]
[270,601,162270,0.06,42928.03044518196]
[271,601,162871,0.06,42541.670597407865]
[272,601,163472,0.06,42153.3789503949]
[273,601,164073,0.06,41763.14584514687]
[274,601,164674,0.06,41370.9615743726]
[275,601,165275,0.06,40976.81638224446]
[276,601,165876,0.06,40580.70046415568]
[277,601,166477,0.06,40182.603966476454]
[278,601,167078,0.06,39782.51698630883]
[279,601,167679,0.06,39380.42957124037]
[280,601,168280,0.06,38976.33171909657]
[281,601,168881,0.06,38570.213377692045]
[282,601,169482,0.06,38162.0644445805]
[283,601,170083,0.06,37751.8747668034]
[284,601,170684,0.06,37339.63414063741]
[285,601,171285,0.06,36925.33231134059]
[286,601,171886,0.06,36508.95897289729]
[287,601,172487,0.06,36090.50376776177]
[288,601,173088,0.06,35669.95628660058]
[289,601,173689,0.06,35247.30606803358]
[290,601,174290,0.06,34822.542598373744]
[291,601,174891,0.06,34395.65531136561]
[292,601,175492,0.06,33966.633587922435]
[293,601,176093,0.06,33535.46675586204]
[294,601,176694,0.06,33102.14408964135]
[295,601,177295,0.06,32666.654810089552]
[296,601,177896,0.06,32228.988084139994]
[297,601,178497,0.06,31789.13302456069]
[298,601,179098,0.06,31347.07868968349]
[299,601,179699,0.06,30902.814083131903]
[300,601,180300,0.06,30456.328153547558]
[301,601,180901,0.06,30007.609794315293]
[302,601,181502,0.06,29556.647843286864]
[303,601,182103,0.06,29103.431082503295]
[304,601,182704,0.06,28647.948237915807]
[305,601,183305,0.06,28190.187979105383]
[306,601,183906,0.06,27730.138919000907]
[307,601,184507,0.06,27267.78961359591]
[308,601,185108,0.06,26803.128561663885]
[309,601,185709,0.06,26336.144204472203]
[310,601,186310,0.06,25866.824925494562]
[311,601,186911,0.06,25395.15905012203]
[312,601,187512,0.06,24921.13484537264]
[313,601,188113,0.06,24444.740519599498]
[314,601,188714,0.06,23965.964222197494]
[315,601,189315,0.06,23484.794043308477]
[316,601,189916,0.06,23001.218013525016]
[317,601,190517,0.06,22515.224103592638]
[318,601,191118,0.06,22026.8002241106]
[319,601,191719,0.06,21535.93422523115]
[320,601,192320,0.06,21042.613896357303]
[321,601,192921,0.06,20546.82696583909]
[322,601,193522,0.06,20048.56110066828]
[323,601,194123,0.06,19547.80390617162]
[324,601,194724,0.06,19044.542925702473]
[325,601,195325,0.06,18538.765640330985]
[326,601,195926,0.06,18030.459468532637]
[327,601,196527,0.06,17519.6117658753]
[328,601,197128,0.06,17006.209824704674]
[329,601,197729,0.06,16490.240873828196]
[330,601,198330,0.06,15971.692078197335]
[331,601,198931,0.06,15450.55053858832]
[332,601,199532,0.06,14926.803291281261]
[333,601,200133,0.06,14400.437307737666]
[334,601,200734,0.06,13871.439494276352]
[335,601,201335,0.06,13339.796691747732]
[336,601,201936,0.06,12805.495675206468]
[337,601,202537,0.06,12268.523153582499]
[338,601,203138,0.06,11728.86576935041]
[339,601,203739,0.06,11186.510098197161]
[340,601,204340,0.06,10641.442648688146]
[341,601,204941,0.06,10093.649861931586]
[342,601,205542,0.06,9543.118111241243]
[343,601,206143,0.06,8989.833701797448]
[344,601,206744,0.06,8433.782870306435]
[345,601,207345,0.06,7874.951784657966]
[346,601,207946,0.06,7313.326543581255]
[347,601,208547,0.06,6748.89317629916]
[348,601,209148,0.06,6181.637642180654]
[349,601,209749,0.06,5611.5458303915575]
[350,601,210350,0.06,5038.603559543515]
[351,601,210951,0.06,4462.7965773412325]
[352,601,211552,0.06,3884.1105602279385]
[353,601,212153,0.06,3302.531113029078]
[354,601,212754,0.06,2718.043768594223]
[355,601,213355,0.06,2130.633987437194]
[356,601,213956,0.06,1540.2871573743796]
[357,601,214557,0.06,946.9885931612514]
[358,601,215158,0.06,350.7235361270575]
[359,601,215759,0.06,-248.5228461923072]
[360,601,216360,0.06,-850.7654604232687]

{"sheet":"Salary","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Year","Inflation","Salary"]
[1,0.05,100000,null,"this assumes no career growth - promotions"]
[2,0.05,105000]
[3,0.05,110250]
[4,0.05,115762.5]
[5,0.05,121550.625]
[6,0.05,127628.15625]
[7,0.05,134009.5640625]
[8,0.05,140710.042265625]
[9,0.05,147745.54437890626]
[10,0.05,155132.82159785158]
[11,0.05,162889.46267774416]
[12,0.05,171033.93581163138]
[13,0.05,179585.63260221295]
[14,0.05,188564.91423232362]
[15,0.05,197993.1599439398]
[16,0.05,207892.8179411368]
[17,0.05,218287.45883819365]
[18,0.05,229201.83178010333]
[19,0.05,240661.9233691085]
[20,0.05,252695.01953756393]
[21,0.05,265329.7705144421]
[22,0.05,278596.25904016424]
[23,0.05,292526.07199217245]
[24,0.05,307152.3755917811]
[25,0.05,322509.9943713702]
[26,0.05,338635.4940899387]
[27,0.05,355567.26879443566]
[28,0.05,373345.63223415747]

{"sheet":"Retire","index":3,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
["Final Retirement Size in Terms of Salary",null,null,null,3.5132740448623485]
[]
["Year","Sav % Salary","Return Rate","Inflation Rate","Total"]
[1,0.1,0.05,0.04,0.101]
[2,0.1,0.05,0.04,0.20301000000000002]
[3,0.1,0.05,0.04,0.3060401]
[4,0.1,0.05,0.04,0.410100501]
[5,0.1,0.05,0.04,0.51520150601]
[6,0.1,0.05,0.04,0.6213535210701]
[7,0.1,0.05,0.04,0.728567056280801]
[8,0.1,0.05,0.04,0.836852726843609]
[9,0.1,0.05,0.04,0.946221254112045]
[10,0.1,0.05,0.04,1.0566834666531655]
[11,0.1,0.05,0.04,1.1682503013196972]
[12,0.1,0.05,0.04,1.2809328043328942]
[13,0.1,0.05,0.04,1.3947421323762232]
[14,0.1,0.05,0.04,1.5096895536999855]
[15,0.1,0.05,0.04,1.6257864492369853]
[16,0.1,0.05,0.04,1.7430443137293552]
[17,0.1,0.05,0.04,1.8614747568666488]
[18,0.1,0.05,0.04,1.9810895044353154]
[19,0.1,0.05,0.04,2.1019003994796686]
[20,0.1,0.05,0.04,2.2239194034744654]
[21,0.1,0.05,0.04,2.34715859750921]
[22,0.1,0.05,0.04,2.471630183484302]
[23,0.1,0.05,0.04,2.5973464853191452]
[24,0.1,0.05,0.04,2.7243199501723367]
[25,0.1,0.05,0.04,2.85256314967406]
[26,0.1,0.05,0.04,2.982088781170801]
[27,0.1,0.05,0.04,3.112909668982509]
[28,0.1,0.05,0.04,3.2450387656723345]
[29,0.1,0.05,0.04,3.378489153329058]
[30,0.1,0.05,0.04,3.5132740448623485]