{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dashboard","Grafiek","Data"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":53,"comments":0,"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":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Geldnerd's FIRE Calculator v4.1"]
["© 2021 by Geldnerd",null,null,true,false,null,null,"Alleen vakjes wijzigen waar een kader omheen staat!"]
[null,null,null,13]
["Algemene Variabelen"]
[null,"Startjaar",2021,null,null,"(meestal: huidig jaar)"]
[null,"Gemiddelde inflatie",2.1999999999999999E-2,null,null,"per jaar"]
[]
[null,null,null,null,null,"Schakel de vinkjes in als je de Persoon in de berekening mee wilt nemen"]
[null,null,"Persoon 1","Persoon 2",null,null,null,"Meevallers / Tegenvallers"]
[]
["Persoonlijke variabelen",null,null,null,null,null,null,"Jaar","Bedrag","Omschrijving"]
[null,"Gemiddeld rendement",0.04,0.03,null,"per jaar"]
[null,"Geboortedatum","1971-06-30","1977-04-30",null,null,null,2022,100000,"Erfenis"]
[null,"Vermogen (EUR)",110000,95000,null,"(aan begin startjaar)"]
[null,"Levensverwachting",90,90,null,"jaar"]
[]
["Opbouwfase"]
[null,"Netto jaarinkomen (EUR)",30000,28000]
[null,"Inkomensstijging",1.0999999999999999E-2,1.0999999999999999E-2,null,"per jaar"]
[null,"Spaarpercentage",0.4,0.35,null,"per jaar"]
[]
["FIRE-fase"]
[null,"Ik stop met werken in",2025,2025]
[null,"Benodigd per jaar (EUR)",25000,25000,null,"(wat verwacht je jaarlijks uit te geven in Euro's van vandaag)"]
[]
["Neveninkomsten"]
[null,"Netto jaarinkomen (EUR)",10000,null,null,"(bijvoorbeeld uit part-time baan of hosselen)"]
[null,"Startjaar inkomen",2025]
[null,"Eindjaar inkomen",2035]
[]
["Pensioenfase"]
[]
[1,"Netto AOW per jaar (EUR)",6957,6957,null,"(Pijler 1)"]
[null,"AOW-datum","2040-04-01","2047-06-01"]
[]
[2,"Netto pensioen per jaar (EUR)",10000,12500,null,"(tot nu toe reeds opgebouwd, zie UPO)"]
[null,"Pensioendatum","2040-04-01","2047-06-01",null,"(Pijler 2)"]
[null,"A-factor",900,800,null,"(meest recent, zie UPO)"]
[null,"Verwachte jaarlijkse indexering",5.0000000000000001E-3,5.0000000000000001E-3]
[]
[3,"Netto uitkering per jaar (EUR)",10000,null,null,"(Pijler 3 - aanvullend pensioen)"]
[null,"Startjaar uitkering",2025]
[null,"Looptijd in jaren",10,null,null,"(0 = oneindig)"]
[]
[4,"Nabestaandenpensioen",24000,20000,null,"(netto per jaar in EUR te ontvangen)"]
[null,"Startjaar (optioneel)"]
[null,"Verwachte jaarlijkse indexering",0.01,0.01]

{"sheet":"Grafiek","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Data","index":2,"n_rows":47,"n_cols":32,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Alleen ZWART gemarkeerde kolommen kunnen aangepast worden",null,null,null,null,null,null,"Pas je handmatig iets aan? Ga dan eerst in het menu naar Formules | Berekeningsopties en ze dat op Automatisch. Jouw aanpassingen worden dan automatisch verwerkt in de berekeningen en grafiek."]
["ROOD gemarkeerde kolommen mogen niet aangepast worden"]
[]
[null,"Persoon 1",null,null,null,null,"Mee-/","Neven",null,null,null,"Nabestaanden","Benodigd",null,"Eigen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal Eigen","Dekking uit"]
["Jaar",null,"Leeftijd","Inkomen","Uitgaven","Sparen","Tegenvaller","Inkomsten","Pijler 1","Pijler 2","Pijler 3","Pensioen","Inkomen","Uit Vermogen","Vermogen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vermogen","Vermogen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,110000]
[2021,null,50,30000,18000,12000,null,null,null,null,null,24240,null,{"$f":"M7-(G7+H7+I7+J7+K7+L7)","v":-24240},{"$f":"( ( ( O6 + 0.5 * (F7-N7) ) * (1+AvgReturnP1) ) + 0.5 * (F7-N7) )","v":151364.80000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O7+AC7","v":151364.80000000002}]
[2022,null,51,30329.999999999996,18197.999999999996,12132,100000,null,null,null,null,24482.400000000001,null,-124482.4,296766.08000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,296766.08000000002]
[2023,null,52,30663.629999999994,18398.177999999996,12265.451999999997,null,null,null,null,null,24727.224000000002,null,-24727.224000000002,346369.25271999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,346369.25271999999]
[2024,null,53,31000.929929999991,18600.557957999994,12400.371971999997,null,null,null,null,null,24974.49624,null,-24974.49624,398346.38840504002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,398346.38840504002]
[2025,null,54,null,null,null,null,10000,null,null,10000,25224.241202400004,27273.670656400001,-17950.570546000006,432589.82589816168,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,432589.82589816168]
[2026,null,55,null,null,null,null,10000,null,null,10000,25476.483614424003,27873.691410840802,-17602.792203583202,467848.26698174299,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,467848.26698174299]
[2027,null,56,null,null,null,null,10000,null,null,10000,25731.248450568241,28486.912621879303,-17244.335828688934,504151.42020627542,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,504151.42020627542]
[2028,null,57,null,null,null,null,10000,null,null,10000,25988.560935073925,29113.624699560649,-16874.936235513276,541529.91197474999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,541529.91197474999]
[2029,null,58,null,null,null,null,10000,null,null,10000,26248.44654442466,29754.124442950979,-16494.322101473681,580015.31699724309,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,580015.31699724309]
[2030,null,59,null,null,null,null,10000,null,null,10000,26510.931009868909,30408.715180695905,-16102.215829173005,619640.1898228894,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,619640.1898228894]
[2031,null,60,null,null,null,null,10000,null,null,10000,26776.040319967597,31077.706914671217,-15698.333405296376,660438.09748920728,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,660438.09748920728]
[2032,null,61,null,null,null,null,10000,null,null,10000,27043.800723167275,31761.41646679398,-15282.384256373294,702443.65333027649,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,702443.65333027649]
[2033,null,62,null,null,null,null,10000,null,null,10000,27314.238730398949,32460.167629063446,-14854.071101335507,745692.55198684987,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,745692.55198684987]
[2034,null,63,null,null,null,null,10000,null,null,10000,27587.381117702942,33174.29131690284,-14413.089800800102,790221.60566314007,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,790221.60566314007]
[2035,null,64,null,null,null,null,10000,null,null,null,27863.254928879967,33904.125725874706,-3959.1292030052573,825868.78167673107,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,825868.78167673107]
[2036,null,65,null,null,null,null,null,null,null,null,28141.88747816877,34650.016491843955,6508.129013675185,852265.2413498516,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,852265.2413498516,{"$f":"(N22+AB22)","v":6508.129013675185}]
[2037,null,66,null,null,null,null,null,null,null,null,28423.306352950454,35412.316854664525,6989.0105017140704,879227.06029209751,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,879227.06029209751,{"$f":"(N23+AB23)","v":6989.0105017140704}]
[2038,null,67,null,null,null,null,null,null,null,null,28707.539416479962,36191.387825467144,7483.8484089871818,906762.61732661445,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,906762.61732661445,{"$f":"(N24+AB24)","v":7483.8484089871818}]
[2039,null,68,null,null,null,null,null,null,null,null,28994.614810644758,36987.598357627416,7992.9835469826576,934880.27880175668,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,934880.27880175668,{"$f":"(N25+AB25)","v":7992.9835469826576}]
[2040,null,69,null,null,null,null,null,7686.7585304880695,13229.541447353591,null,29284.560958751208,37801.325521495222,-12399.535415097649,984923.01607722649,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,984923.01607722649]
[2041,null,70,null,null,null,null,null,7725.192323140509,13295.689154590358,null,29577.406568338723,38632.95468296812,-11965.333363101468,1036524.5767506789,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1036524.5767506789]
[2042,null,71,null,null,null,null,null,7763.8182847562102,13362.167600363309,null,29873.180634022108,39482.879685993415,-11516.28683314821,1089732.1723905173,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1089732.1723905173]
[2043,null,72,null,null,null,null,null,7802.6373761799914,13428.978438365124,null,30171.912440362328,40351.503039085277,-11052.02521582217,1144594.5250062768,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1144594.5250062768]
[2044,null,73,null,null,null,null,null,7841.6505630608908,13496.123330556948,null,30473.631564765954,41239.23610594515,-10572.169352438643,1201161.9187460155,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1201161.9187460155]
[2045,null,74,null,null,null,null,null,7880.8588158761931,13563.603947209731,null,30778.367880413611,42146.499300275944,-10076.331343223588,1259486.2534659444,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1259486.2534659444]
[2046,null,75,null,null,null,null,null,7920.2631099555747,13631.421966945778,null,31086.151559217753,43073.722284882017,-9564.1143512370909,1319621.1002428441,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1319621.1002428441]
[2047,null,76,null,null,null,null,null,7959.8644255053514,13699.579076780505,null,31397.013074809929,44021.344175149425,-9035.1124019463605,1381621.7589025432,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1381621.7589025432]
[2048,null,77,null,null,null,null,null,7999.663747632876,13768.076972164406,null,31710.983205558026,44989.813747002707,-8488.9101783526057,1445545.3176405646,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1445545.3176405646]
[2049,null,78,null,null,null,null,null,8039.662066371041,13836.917357025228,null,32028.093037613609,45979.58964943677,-7925.0828115731056,1511450.7148139917,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1511450.7148139917]
[2050,null,79,null,null,null,null,null,8079.8603767028953,13906.101943810352,null,32348.373967989744,46991.140621724378,-7343.1956667786144,1579398.8029866659,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1579398.8029866659]
[2051,null,80,null,null,null,null,null,8120.2596785864089,13975.632453529402,null,32671.857707669642,48024.945715402318,-6742.8041243831321,1649452.4153130036,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1649452.4153130036]
[2052,null,81,null,null,null,null,null,8160.8609769793402,14045.510615797048,null,32998.576284746334,49081.494521141169,-6123.4533563815494,1721676.4343490328,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1721676.4343490328]
[2053,null,82,null,null,null,null,null,8201.665281864236,14115.738168876031,null,33328.562047593798,50161.287400606278,-5484.6780977277886,1796137.8633826764,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1796137.8633826764]
[2054,null,83,null,null,null,null,null,8242.6736082735551,14186.316859720409,null,33661.847668069742,51264.835723419608,-4826.0024126440985,1872905.9003788806,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1872905.9003788806]
[2055,null,84,null,null,null,null,null,8283.8869763149232,14257.248444019009,null,33998.466144750433,52392.662109334844,-4146.9394557495179,1952052.0146389003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1952052.0146389003]
[2056,null,85,null,null,null,null,null,8325.3064111964959,14328.534686239103,null,34338.450806197943,53545.300675740218,-3446.9912278933261,2033650.0262769074,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033650.0262769074]
[2057,null,86,null,null,null,null,null,8366.9329432524773,14400.177359670297,null,34681.835314259923,54723.297290606497,-2725.6483265761999,2117776.1886210912,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2117776.1886210912]
[2058,null,87,null,null,null,null,null,8408.7676079687408,14472.178246468648,null,35028.653667402519,55927.209830999847,-1982.3896908400566,2204509.2736505913,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2204509.2736505913]
[2059,null,88,null,null,null,null,null,8450.8114460085817,14544.539137700989,null,35378.940204076549,57157.60844728184,-1216.6823405042815,2293930.6605839296,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2293930.6605839296]
[2060,null,89,null,null,null,null,null,8493.0655032386258,14617.261833389493,null,35732.729606117311,58415.075833122042,-427.98110962338978,2386124.4277391033,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2386124.4277391033]
[2061,null,90,null,null,null,null,null,8535.5308307548166,14690.348142556439,null,36090.05690217849,59700.207501450728,384.2716259609806,2481177.4477901873,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2481177.4477901873,{"$f":"(N47+AB47)","v":384.2716259609806}]