{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Einfache Zinsrechnung","Zinseszinsrechnung","EFFEKTIV-Funktion","Ratentilgung","Annuitätentilgung","Opt.Annuitätentilgung","Finanzmath.Funktionen","Kreditvergleich"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":42,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",7]
[null,"Thema","Strategisches Prozess-Controlling"]
[]
[null,"Inhalt","Zinsrechnungen"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2023-08-03"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Einfache Zinsrechnung","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Anfangskapital",80000]
["Zinssatz",3.5000000000000003E-2]
["Laufzeit [Jahre]",6]
[]
["Jahr","Anfangskapital","Zinsen"]
[1,{"$f":"Anfangskapital1","v":80000},{"$f":"Anfangskapital1*Zinssatz1","v":2800.0000000000005}]
[2,80000,2800.0000000000005]
[3,80000,2800.0000000000005]
[4,80000,2800.0000000000005]
[5,80000,2800.0000000000005]
[6,80000,2800.0000000000005]
[null,null,{"$f":"SUM(Zinsen1)","v":16800.000000000004}]

{"sheet":"Zinseszinsrechnung","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Anfangskapital",80000]
["Zinssatz",3.5000000000000003E-2]
["Laufzeit [Jahre]",6]
[]
["Jahr","Anfangskapital","Zinsen","Kapital+Zinsen"]
[1,{"$f":"Anfangskapital2","v":80000},{"$f":"B6*Zinssatz2","v":2800.0000000000005},{"$f":"B6+C6","v":82800}]
[2,{"$f":"D6","v":82800},2898.0000000000005,{"$f":"B7+C7","v":85698}]
[3,{"$f":"D7","v":85698},2999.4300000000003,{"$f":"B8+C8","v":88697.43}]
[4,88697.43,3104.41005,91801.840049999999]
[5,91801.840049999999,3213.0644017500003,95014.904451750001]
[6,95014.904451750001,3325.5216558112502,98340.426107561245]
[null,null,{"$f":"SUM(Zinsen2)","v":18340.426107561252}]

{"sheet":"EFFEKTIV-Funktion","index":3,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Anfangskapital",80000]
["Zinssatz",3.5000000000000003E-2]
["Anzahl der Zahliungen/Jahr",2]
[]
["Effektivverzinsung",{"$f":"EFFECT(Zinssatz3,Anzahl3)","v":3.5306250000000095E-2}]

{"sheet":"Ratentilgung","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Kredit",80000]
["Zinssatz",3.5000000000000003E-2]
["Laufzeit [Jahre]",6]
[]
["Jahr","Restschuld","Zinsen","Tilgung","Annuität"]
[1,{"$f":"Kredit4","v":80000},{"$f":"B6*Zinssatz4","v":2800.0000000000005},{"$f":"Kredit4/Laufzeit4","v":13333.333333333334},{"$f":"Zinsen4+Tilgung4","v":16133.333333333334}]
[2,{"$f":"B6-D6","v":66666.666666666672},{"$f":"B7*Zinssatz4","v":2333.3333333333339},13333.333333333334,15666.666666666668]
[3,{"$f":"B7-D7","v":53333.333333333336},{"$f":"B8*B$2","v":1866.666666666667},13333.333333333334,15200]
[4,40000,1400.0000000000002,13333.333333333334,14733.333333333334]
[5,26666.666666666664,933.33333333333337,13333.333333333334,14266.666666666668]
[6,{"$f":"B10-D10","v":13333.33333333333},466.66666666666663,13333.333333333334,13800]
[null,null,{"$f":"SUM(Zinsen4)","v":9800.0000000000018},{"$f":"SUM(Tilgung4)","v":80000},{"$f":"SUM(Annuität4)","v":89800}]

{"sheet":"Annuitätentilgung","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Kredit",80000]
["Zinssatz",3.472707629375605E-2]
["Laufzeit [Jahre]",6]
[]
["Jahr","Restschuld","Zinsen","Tilgung","Annuität"]
[1,{"$f":"Kredit5","v":80000},{"$f":"B6*Zinssatz5","v":2778.166103500484},{"$f":"Annuität5-Zinsen5","v":12221.833896499516},15000]
[2,{"$f":"B6-D6","v":67778.16610350048},{"$f":"B7*B$2","v":2353.7375453271316},{"$f":"E7-C7","v":12646.262454672869},15000]
[3,{"$f":"B7-D7","v":55131.903648827611},{"$f":"B8*B$2","v":1914.569824232844},{"$f":"E8-C8","v":13085.430175767156},15000]
[4,42046.473473060454,1460.1510921823603,13539.848907817639,15000]
[5,28506.624565242815,989.95172615464764,14010.048273845352,15000]
[6,{"$f":"B10-D10","v":14496.576291397463},{"$f":"B11*B$2","v":503.42371086961481},{"$f":"E11-C11","v":14496.576289130386},15000]
[null,{"$f":"B11-D11","v":2.2670774342259392E-6},{"$f":"SUM(C6:C11)","v":10000.000002267083},{"$f":"SUM(D6:D11)","v":79999.999997732913},{"$f":"SUM(E6:E11)","v":90000}]

{"sheet":"Opt.Annuitätentilgung","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Startkapital",null,80000]
["Endkapital",null,0]
["Zinssatz",null,3.5000000000000003E-2]
["Laufzeit [Jahre]",null,6]
["Annuität",null,{"$f":"PMT(Zinssatz6,Laufzeit6,Startkapital6,Endkapital6)","v":-15013.456693225413}]
[]
["Jahr","Startkapital","Zinsen","Tilgung","Annuität","Endkapital"]
[1,{"$f":"Startkapital6","v":80000},{"$f":"B8*Zinssatz6","v":2800.0000000000005},{"$f":"ABS(Annuität6)-C8","v":12213.456693225413},{"$f":"Annuität6","v":-15013.456693225413},{"$f":"B8-D8","v":67786.543306774591}]
[2,{"$f":"F8","v":67786.543306774591},2372.529015737111,12640.927677488302,-15013.456693225413,55145.615629286287]
[3,{"$f":"F9","v":55145.615629286287},1930.0965470250203,13083.360146200394,-15013.456693225413,42062.255483085894]
[4,{"$f":"F10","v":42062.255483085894},1472.1789419080064,13541.277751317406,-15013.456693225413,28520.977731768486]
[5,{"$f":"F11","v":28520.977731768486},998.23422061189706,14015.222472613515,-15013.456693225413,14505.75525915497]
[6,{"$f":"F12","v":14505.75525915497},507.701434070424,14505.755259154988,-15013.456693225413,-1.8189894035458565E-11]

{"sheet":"Finanzmath.Funktionen","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Startkapital",null,80000]
["Endkapital",null,0]
["Zinssatz",null,3.5000000000000003E-2]
["Laufzeit [Jahre]",null,6]
["Annuität",null,{"$f":"PMT(Zinssatz7,Laufzeit7,Startkapital7,Endkapital7)","v":-15013.456693225413}]
[]
["Jahr","Zinsen","Tilgung","Endkapital"]
[1,{"$f":"ABS(IPMT(Zinssatz7,Jahr7,Laufzeit7,Startkapital7,Endkapital7))","v":2800.0000000000005},{"$f":"ABS(PPMT(Zinssatz7,Jahr7,Laufzeit7,Startkapital7,Endkapital7))","v":12213.456693225413},{"$f":"ABS(FV(Zinssatz7,Jahr7,Annuität7,Startkapital7))","v":67786.54330677462}]
[2,2372.5290157371114,12640.927677488304,55145.615629286331]
[3,1930.0965470250205,13083.360146200394,42062.255483085988]
[4,1472.1789419080067,13541.277751317406,28520.977731768602]
[5,998.23422061189751,14015.222472613515,14505.75525915515]
[6,507.70143407042457,14505.755259154988,1.4551915228366852E-10]

{"sheet":"Kreditvergleich","index":8,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[7,0,13,0]]}
["Kredit",null,80000]
["Restwert",null,0]
["Zinssatz",null,3.5000000000000003E-2]
["Laufzeit [Jahre]",null,6]
[]
[null,"Annuität","Kredit"]
[null,{"$f":"-PMT(Zinssatz8,Laufzeit8,Kredit8,Restwert8)","v":15013.456693225413},70000,80000,90000,100000]
["Zinssatz",0.03,12921.825031512404,14767.800036014176,16613.775040515946,18459.750045017721]
[null,3.2500000000000001E-2,13029.09784740645,14890.397539893089,16751.697232379724,18612.996924866358]
[null,3.5000000000000003E-2,13136.774606572237,15013.456693225413,16890.138779878591,18766.820866531769]
[null,3.7499999999999999E-2,13244.853615591632,15136.975560676154,17029.09750576067,18921.21945084519]
[null,0.04,13353.333175556783,15260.952200636324,17168.571225715863,19076.190250795404]
[null,4.2500000000000003E-2,13462.211582305888,15385.384665492444,17308.557748678999,19231.730831865552]
[null,4.4999999999999998E-2,13571.487126656599,15510.271001893256,17449.054877129915,19387.83875236657]