{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Mortgage","Mortgage (2)","Mortgage (3)","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Mortgage","index":0,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Real estate value","Principal"]
[null,100000,100000]
[]
[]
[null,null,null,"nper","rate per annum",null,"payment","to be paid in total"]
[null,"annual",null,30,5.0999999999999997E-2,"annual rate",{"$f":"PMT($E$7,$D$7,-$C$3)","v":6579.484358124022},{"$f":"G7*D7","v":197384.53074372065}]
[null,"monthly",null,{"$f":"12*D7","v":360},{"$f":"E7/12","v":4.2499999999999994E-3},"annual rate/12",{"$f":"PMT(E8,D8,-$C$3)","v":542.94977340040987},{"$f":"G8*D8","v":195461.91842414756}]
[null,"monthly - compounded ",null,360,{"$f":"POWER(1+E7,1/12)","v":1.0041537774426925},"(1+r)^1/12",{"$f":"PMT(E9-1,D9,-$C$3)","v":535.87673943772108},{"$f":"G9*D9","v":192915.62619757958}]

{"sheet":"Mortgage (2)","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Real estate value","Principal P"]
[null,120000,100000]
[]
[]
[null,"periodicity",null,"nper","interest rate","interest ","payment",null,"to be paid in total"]
[null,"annual",null,30,5.0999999999999997E-2,null,{"$f":"PMT($E$7,$D$7,-$C$3)","v":6579.484358124022},"= P x r / (1-1/(1+r)^N)",{"$f":"G7*D7","v":197384.53074372065},"= PMT x N"]
[null,"monthly",null,{"$f":"12*D7","v":360},{"$f":"E7/12","v":4.2499999999999994E-3},"annual rate/12",{"$f":"PMT(E8,D8,-$C$3)","v":542.94977340040987},null,{"$f":"G8*D8","v":195461.91842414756}]
[null,"monthly compounded",null,360,{"$f":"POWER(1+E7,1/12)-1","v":4.1537774426925189E-3},"compounded (1+r)^1/12",{"$f":"PMT(E9,D9,-$C$3)","v":535.87673943772108},null,{"$f":"G9*D9","v":192915.62619757958}]
[]
[null,null,null,null,null,null,null,{"$f":"C3*E7*POWER(1+E7, D7)/(POWER(1+E7,D7)-1)","v":6579.4843581240239}]
[null,null,null,null,null,null,null,{"$f":"C3*E7/(1-1/POWER(1+E7,D7))","v":6579.4843581240239}]
[]
[null,"What is the split in interests vs. principal payment in the payment",null,null,"interest payment","interest payment","principal payment","principal payment"]
[null,null,null,null,"= P x r",{"$f":"C3*E7","v":5100},"= PMT - P x r",{"$f":"G7-F15","v":1479.484358124022}]

{"sheet":"Mortgage (3)","index":2,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Mortgage reduction"]
[]
[]
[null,"Principal","outstanding nper","Interest rate (monthly)","Standard payment","Advance payment","Type: \n0 - payment reduction \n1 - duration reduction","Cummulative payment","Δ nper","Payment","Interests split","principal split","Paid in total"]
[null,100000,360,{"$f":"5.64/1200","v":4.6999999999999993E-3},{"$f":"PMT(D6,C6, -B6)","v":576.60380028204099},0,0,{"$f":"E6+F6","v":576.60380028204099},{"$f":"IF(G6=1, LoanReducedPeriods(D6,C6,B6,F6), 1)","v":1},{"$f":"E6","v":576.60380028204099},{"$f":"B6*D6","v":469.99999999999994},{"$f":"J6-K6","v":106.60380028204105},{"$f":"C6*J6","v":207577.36810153475}]
[]
[]
[]
[]
[null,{"$f":"B6-L6-F6","v":99893.396199717958},{"$f":"C6-I6","v":359},{"$f":"5.64/1200","v":4.6999999999999993E-3},{"$f":"PMT(D11,C11, -B11)","v":576.60380028204099},10000,1,{"$f":"H6+E11+F11","v":11153.207600564081},{"$f":"IF(G11=1, LoanReducedPeriods(D11,C11,B11,F11), 1)","v":78},{"$f":"E11","v":576.60380028204099},{"$f":"B11*D11","v":469.49896213867436},{"$f":"J11-K11","v":107.10483814336663},{"$f":"(C11-I11+1)*E11+H11","v":173755.47928009965}]
[null,{"$f":"B11-F11-L11","v":89786.291361574593},{"$f":"C11-I11","v":281},4.6999999999999993E-3,576.31998687457019,0,0,{"$f":"H11+E12+F12","v":11729.527587438652},{"$f":"IF(G12=1, LoanReducedPeriods(D12,C12,B12,F12), 1)","v":1},{"$f":"E12","v":576.31998687457019},{"$f":"B12*D12","v":421.99556939940055},{"$f":"J12-K12","v":154.32441747516964},{"$f":"(C12-I12+1)*E12+H12","v":173675.44389919288}]
[null,{"$f":"B12-F12-L12","v":89631.966944099418},{"$f":"C12-I12","v":280},4.6999999999999993E-3,{"$f":"PMT(D13,C13, -B13)","v":576.31998687457008},0,0,{"$f":"H12+E13+F13","v":12305.847574313222},{"$f":"IF(G13=1, LoanReducedPeriods(D13,C13,B13,F13), 1)","v":1},{"$f":"E13","v":576.31998687457008},{"$f":"B13*D13","v":421.27024463726718},{"$f":"J13-K13","v":155.04974223730289},173675.44389919285]
[null,89476.917201862118,279,4.6999999999999993E-3,576.31998687457019,0,0,12882.167561187793,1,576.31998687457019,420.5415108487519,155.77847602581829,173675.44389919288]
[null,89321.138725836296,278,4.6999999999999993E-3,576.31998687457008,0,0,13458.487548062363,1,576.31998687457008,419.80935201143052,156.51063486313956,173675.44389919285]
[null,89164.628090973158,277,4.6999999999999993E-3,576.31998687457008,10000,0,24034.807534936932,1,576.31998687457008,419.07375202757379,157.24623484699629,183675.44389919285]
[null,79007.381856126158,276,4.6999999999999993E-3,511.57030265105823,0,0,24546.377837587992,1,511.57030265105823,371.33469472379289,140.23560792726533,165739.78136928007]
[null,78867.146248198886,275,4.6999999999999993E-3,511.57030265105823,0,0,25057.948140239052,1,511.57030265105823,370.67558736653473,140.8947152845235,165739.78136928007]
[null,78726.251532914364,274,4.6999999999999993E-3,511.57030265105823,0,0,25569.518442890112,1,511.57030265105823,370.01338220469745,141.55692044636078,165739.78136928007]
[null,78584.694612468011,273,4.6999999999999993E-3,511.57030265105828,0,0,26081.088745541172,1,511.57030265105828,369.3480646785996,142.22223797245869,165739.78136928007]
[null,78442.472374495555,272,4.6999999999999993E-3,511.57030265105828,0,0,26592.659048192232,1,511.57030265105828,368.67962016012905,142.89068249092924,165739.7813692801]
[null,78299.58169200462,271,4.6999999999999993E-3,511.57030265105828,0,0,27104.229350843292,1,511.57030265105828,368.00803395242167,143.56226869863661,165739.7813692801]
[null,78156.019423305988,270,4.6999999999999993E-3,511.57030265105828,0,0,27615.799653494352,1,511.57030265105828,367.33329128953807,144.23701136152022,165739.7813692801]
[null,78011.78241194447,269,4.6999999999999993E-3,511.57030265105834,0,0,28127.369956145412,1,511.57030265105834,366.65537733613894,144.9149253149194,165739.7813692801]
[null,77866.867486629548,268,4.6999999999999993E-3,511.57030265105823,0,0,28638.940258796472,1,511.57030265105823,365.9742771871588,145.59602546389942,165739.78136928007]
[null,77721.271461165656,267,4.6999999999999993E-3,511.57030265105834,0,0,29150.510561447532,1,511.57030265105834,365.28997586747852,146.28032678357982,165739.7813692801]
[null,77574.991134382071,266,4.6999999999999993E-3,511.57030265105828,0,0,29662.080864098592,1,511.57030265105828,364.6024583315957,146.96784431946259,165739.7813692801]
[null,77428.023290062614,265,4.6999999999999993E-3,511.57030265105834,0,0,30173.651166749652,1,511.57030265105834,363.91170946329424,147.6585931877641,165739.7813692801]

{"sheet":"Sheet2","index":3,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Year","Principal","Interest rate","Payment (annuity)","Monthly payment","Interest payment","Principal payment","Additional payment","Short term interest rate","Short debt","Administrative costs"]
[0,100000,5.6399999999999999E-2,{"$f":"PMT(C4,30-A4,-B4)","v":6987.2742662628816},{"$f":"D4/12","v":582.27285552190676},{"$f":"B4*C4","v":5640},{"$f":"D4-F4","v":1347.2742662628816},0,0.1,{"$f":"H4*(1+I4)","v":0},0,{"$f":"30*D4","v":209618.22798788644}]
[1,{"$f":"B4-G4-H4","v":98652.725733737112},5.6399999999999999E-2,6987.2742662628807,{"$f":"D5/12","v":582.27285552190676},{"$f":"B5*C5","v":5564.0137313827727},{"$f":"D5-F5","v":1423.260534880108},0,0.1,{"$f":"H5*(1+I5)","v":0},0]
[2,{"$f":"B5-G5-H5","v":97229.465198857011},5.6399999999999999E-2,6987.2742662628816,582.27285552190676,5483.7418372155353,{"$f":"D6-F6","v":1503.5324290473463},0,0.1,0,0]
[3,95725.93276980966,5.6399999999999999E-2,6987.2742662628807,582.27285552190676,5398.9426082172649,1588.3316580456158,0,0.1,0,0]
[4,94137.601111764045,5.6399999999999999E-2,6987.2742662628798,582.27285552190665,5309.3607027034923,1677.9135635593875,13000,0.15,14949.999999999998,0]
[5,79459.68754820466,5.6399999999999999E-2,6004.8508137278495,500.40423447732081,4481.5263777187429,1523.3244360091066,13000,0.25,{"$f":"H9*(1+I9)","v":16250},0]
[6,64936.363112195555,5.6399999999999999E-2,5003.2251609361738,416.93543007801446,3662.4108795278294,1340.8142814083444,13000,0.25,16250,0]
[7,50595.548830787207,5.6399999999999999E-2,3980.4817726334559,331.70681438612132,2853.5889540563985,1126.8928185770574,0,0.25,0,0]
[8,49468.656012210151,5.6399999999999999E-2,3980.481772633455,331.70681438612127,2790.0321990886523,1190.4495735448027,0,0.25,0,0]
[9,48278.206438665351,5.6399999999999999E-2,3980.4817726334559,331.70681438612132,2722.8908431407258,1257.5909294927301,0,0.25,0,0]
[10,47020.615509172618,5.6399999999999999E-2,3980.481772633455,331.70681438612127,2651.9627147173355,1328.5190579161194,0,0.25,0,0]
[11,45692.096451256497,5.6399999999999999E-2,3980.4817726334559,331.70681438612132,2577.0342398508665,1403.4475327825894,0,0.25,0,0]
[12,44288.648918473904,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,2497.8797990019279,1482.6019736315261,0,0.25,0,0]
[13,42806.046944842376,5.6399999999999999E-2,3980.481772633455,331.70681438612127,2414.26104768911,1566.220724944345,0,0.25,0,0]
[14,41239.82621989803,5.6399999999999999E-2,3980.481772633455,331.70681438612127,2325.926198802249,1654.5555738312059,0,0.25,0,0]
[15,39585.270646066827,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,2232.6092644381688,1747.8725081952853,0,0.1,0,0]
[16,37837.39813787154,5.6399999999999999E-2,3980.481772633455,331.70681438612127,2134.0292549759547,1846.4525176575003,0,0.1,0,0]
[17,35990.945620214043,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,2029.8893329800719,1950.5924396533821,0,0.1,0,0]
[18,34040.353180560662,5.6399999999999999E-2,3980.481772633455,331.70681438612127,1919.8759193836213,2060.6058532498337,0,0.1,0,0]
[19,31979.747327310826,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,1803.6577492603305,2176.8240233731235,0,0.1,0,0]
[20,29802.923303937703,5.6399999999999999E-2,3980.4817726334559,331.70681438612132,1680.8848743420865,2299.5968982913691,0,0.1,0,0]
[21,27503.326405646334,5.6399999999999999E-2,3980.4817726334559,331.70681438612132,1551.1876092784532,2429.2941633550026,0,0.1,0,0]
[22,25074.03224229133,5.6399999999999999E-2,3980.481772633455,331.70681438612127,1414.1754184652309,2566.3063541682241,0,0.1,0,0]
[23,22507.725888123106,5.6399999999999999E-2,3980.481772633455,331.70681438612127,1269.4357400901431,2711.0460325433119,0,0.1,0,0]
[24,19796.679855579794,5.6399999999999999E-2,3980.481772633455,331.70681438612127,1116.5327438547004,2863.9490287787548,0,0.1,0,0]
[25,16932.730826801038,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,955.00601863157851,3025.4757540018754,0,0.1,0,0]
[26,13907.255072799162,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,784.3691861058727,3196.1125865275812,0,0.1,0,0]
[27,10711.142486271581,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,604.10843622571713,3376.373336407737,0,0.1,0,0]
[28,7334.7691498638442,5.6399999999999999E-2,3980.481772633455,331.70681438612127,413.68098005232082,3566.8007925811344,0,0.1,0,0]
[29,3767.9683572827098,5.6399999999999999E-2,3980.4817726334541,331.70681438612115,212.51341535074482,3767.9683572827093,0,0.1,0,0]
[30,4.5474735088646412E-13,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D4:D33)","v":137495.52807654795},null,null,null,null,null,{"$f":"SUM(J4:J33)","v":47450},{"$f":"SUM(K4:K33)","v":0},{"$f":"D35+J35+K35","v":184945.52807654795}]
[]
[]
[]
[]
[]
[4,179431.34985860385,5.6399999999999999E-2,{"$f":"PMT(C41,30-A41,-B41)","v":13318.121968493197},{"$f":"PMT(C41,23,-B41+13000)","v":13093.581744167966}]
[null,null,null,{"$f":"SOLVE()","v":{"$error":"#NAME?"}}]