{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Amortisationsdauer"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Amortisationsdauer","index":0,"n_rows":40,"n_cols":45,"rows_kept":40,"cut":false,"hidden":false,"merged":[[5,26,5,27],[5,4,5,21],[20,6,21,6],[31,6,32,6],[9,14,14,17]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jahr","Monat","Tag","Jahr","Monat","Tag"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+YEAR(#REF!)","v":{"$error":"#REF!"}},{"$f":"+MONTH(#REF!)","v":{"$error":"#REF!"}},{"$f":"+DAY(#REF!)","v":{"$error":"#REF!"}},{"$f":"+AA4-1","v":{"$error":"#REF!"}},{"$f":"+AB4","v":{"$error":"#REF!"}},{"$f":"+AC4","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,"Ermittlung der Amortisationsdauer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Umsätze"]
[]
[null,null,null,null,null,"Eingabe",null,null,null,"Ergebnisse",null,null,null,null,"Hinweise und Notizen"]
[]
[null,null,null,null,null,null,"Startjahr",2018,null,"Amortisation, statisch (Jahre)",null,null,{"$f":"IF(ISERROR(H13/(SUM(Z27:AS27)/H11)),\"\",H13/(SUM(Z27:AS27)/H11))","v":6.9390566700292942},null,"Dieses Feld kann für Notizen genutzt werden."]
[null,null,null,null,null,null,"Nutzungsdauer (Jahre)",15,null,{"$f":"\"Amortisation, \" & H12*100 & \"% (Jahre)\"","v":"Amortisation, 5% (Jahre)"},null,null,{"$f":"IF(ISERROR(NPER(H12,PMT(H12,H11,-M12-H13),-H13)),\"\",NPER(H12,PMT(H12,H11,-M12-H13),-H13))","v":8.9315757244928484}]
[null,null,null,null,null,null,"Zinssatz",0.05,null,"Barwert",null,null,{"$f":"IF(AB13=0,\"\",IF(ISERROR(AB13),\"\",AB13))","v":938452.64572342392}]
[null,null,null,null,null,null,"Investition",2000000,null,"Barwert abgezinst auf ",null,null,{"$f":"IF(H10=\"\",\"\",IF(ISERROR(\"01.01.\" &H10),\"\",\"01.01.\" &H10))","v":"01.01.2018"},null,null,null,null,null,null,null,null,null,null,null,"Barwert",null,null,{"$f":"IF(ISERROR(SUM(I29:R29,I40:R40)),\"\",SUM(I29:R29,I40:R40))","v":938452.64572342392}]
[null,null,null,null,null,null,"Jährlicher Rückfluss (Einsparung)",250000,null,"interne Verzinsung",null,null,{"$f":"IF(ISERROR(IRR(Y27:AS27,0.1)),\"\",IRR(Y27:AS27,0.1))","v":0.10969158868331097}]
[null,null,null,null,null,null,"Steigerungsrate Rückfluss",0.02]
[]
[]
[null,null,null,null,null,"Detailübersicht"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,{"$f":"1+Y20","v":2016},{"$f":"1+Z20","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034]
[null,null,null,null,null,null,"Zeitpunkt",{"$f":"+DATE(H10,1,1)","v":"2018-01-01"},"31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.",null,null,null,null,null,null,1,{"$f":"1+Y21","v":2},{"$f":"1+Z21","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,null,null,null,null,null,{"$f":"H10","v":2018},{"$f":"H22","v":2018},{"$f":"I22+1","v":2019},2020,2021,2022,2023,2024,2025,2026,2027]
[null,null,null,null,null,null,"Kredit für Investition",{"$f":"IF(H13=\"\",\"\",H13)","v":2000000}]
[null,null,null,null,null,null,"Rückfluss",{"$f":"IF(H27=\"\",\"\",H27)","v":-2000000},{"$f":"IF(ISERROR(IF(I22<=$H$22+$H$11-1,$H$14*(1+$H$15)^(I22-$H$22),0)),\"\",IF(I22<=$H$22+$H$11-1,$H$14*(1+$H$15)^(I22-$H$22),0))","v":250000},{"$f":"IF(ISERROR(IF(J22<=$H$22+$H$11-1,$H$14*(1+$H$15)^(J22-$H$22),0)),\"\",IF(J22<=$H$22+$H$11-1,$H$14*(1+$H$15)^(J22-$H$22),0))","v":255000},260100,265302,270608.03999999998,276020.20079999999,281540.60481600004,287171.41691231995,292914.84525056637,298773.14215557772,null,null,null,null,null,null,{"$f":"+H21","v":"2018-01-01"},{"$f":"+I21","v":"31. Dez."},"31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.",{"$f":"+I32","v":"31. Dez."},"31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez."]
[null,null,null,null,null,null,"Zins",null,{"$f":"IF(ISERROR(IF(AND(H27<0,I24>0),H27*$H$12,0)),\"\",IF(AND(H27<0,I24>0),H27*$H$12,0))","v":-100000},{"$f":"IF(ISERROR(IF(AND(I27<0,J24>0),I27*$H$12,0)),\"\",IF(AND(I27<0,J24>0),I27*$H$12,0))","v":-92500},-84375,-75588.75,-66103.087500000009,-55877.839875000005,-44870.721828750015,-33037.227679387513,-20330.51821774089,-6701.301866099614,null,null,null,null,null,null,{"$f":"+H22","v":2018},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,2033,2034,2035,2036,2037]
[null,null,null,null,null,null,"Tilgung",null,{"$f":"IF(ISERROR(IF(H27<0,IF(H27<-I24-I25,-I24-I25,H27),0)),\"\",IF(H27<0,IF(H27<-I24-I25,-I24-I25,H27),0))","v":-150000},{"$f":"IF(ISERROR(IF(I27<0,IF(I27<-J24-J25,-J24-J25,I27),0)),\"\",IF(I27<0,IF(I27<-J24-J25,-J24-J25,I27),0))","v":-162500},-175725,-189713.25,-204504.95249999996,-220142.36092499999,-236669.88298725002,-254134.18923293243,-272584.3270328255,-134026.03732199228]
[null,null,null,null,null,null,"Restschuld",{"$f":"IF(H23=\"\",\"\",-H23)","v":-2000000},{"$f":"IF(ISERROR(IF(AND(H27-I26<0,I24>0),H27-I26,0)),\"\",IF(AND(H27-I26<0,I24>0),H27-I26,0))","v":-1850000},{"$f":"IF(ISERROR(IF(AND(I27-J26<0,J24>0),I27-J26,0)),\"\",IF(AND(I27-J26<0,J24>0),I27-J26,0))","v":-1687500},-1511775,-1322061.75,-1117556.7975000001,-897414.43657500017,-660744.55358775018,-406610.36435481778,-134026.03732199228,0,null,null,null,null,null,null,{"$f":"+H24","v":-2000000},{"$f":"+I24","v":250000},255000,260100,265302,270608.03999999998,276020.20079999999,281540.60481600004,287171.41691231995,292914.84525056637,298773.14215557772,{"$f":"+I35","v":304748.60499868926},310843.57709866302,317060.44864063634,323401.65761344903,329869.69076571806,0,0,0,0,0]
[null,null,null,null,null,null,"Überschuss",null,{"$f":"IF(ISERROR(I24+I25+I26),\"\",I24+I25+I26)","v":0},{"$f":"IF(ISERROR(J24+J25+J26),\"\",J24+J25+J26)","v":0},0,0,0,0,0,0,0,158045.80296748586,null,null,null,null,null,null,0,-100000,-92500,-84375,-75588.75,-66103.087500000009,-55877.839875000005,-44870.721828750015,-33037.227679387513,-20330.51821774089,-6701.301866099614,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Barwert",null,{"$f":"IF(ISERROR(IF(I28>0,I28/(1+$H$12)^(I22-$H$22+1),IF(AND(I27<0,J24=0),I27/(1+$H$12)^(I22-$H$22+1),0))),\"\",IF(I28>0,I28/(1+$H$12)^(I22-$H$22+1),IF(AND(I27<0,J24=0),I27/(1+$H$12)^(I22-$H$22+1),0)))","v":0},{"$f":"IF(ISERROR(IF(J28>0,J28/(1+$H$12)^(J22-$H$22+1),IF(AND(J27<0,K24=0),J27/(1+$H$12)^(J22-$H$22+1),0))),\"\",IF(J28>0,J28/(1+$H$12)^(J22-$H$22+1),IF(AND(J27<0,K24=0),J27/(1+$H$12)^(J22-$H$22+1),0)))","v":0},0,0,0,0,0,0,0,97026.413108231034,null,null,null,null,null,null,0,-150000,-162500,-175725,-189713.25,-204504.95249999996,-220142.36092499999,-236669.88298725002,-254134.18923293243,-272584.3270328255,-134026.03732199228,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-2000000,-1850000,-1687500,-1511775,-1322061.75,-1117556.7975000001,-897414.43657500017,-660744.55358775018,-406610.36435481778,-134026.03732199228,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,158045.80296748586,304748.60499868926,310843.57709866302,317060.44864063634,323401.65761344903,329869.69076571806,0,0,0,0,0]
[null,null,null,null,null,null,"Zeitpunkt",null,"31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.","31. Dez.",null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,97026.413108231034,178180.19772071717,173089.33492869668,168143.92535930534,163339.81320618236,158672.96140029142,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"R22+1","v":2028},{"$f":"I33+1","v":2029},2030,2031,2032,2033,2034,2035,2036,2037]
[]
[null,null,null,null,null,null,"Rückfluss",null,{"$f":"IF(ISERROR(IF(I33<=$H$22+$H$11-1,$H$14*(1+$H$15)^(I33-$H$22),0)),\"\",IF(I33<=$H$22+$H$11-1,$H$14*(1+$H$15)^(I33-$H$22),0))","v":304748.60499868926},{"$f":"IF(ISERROR(IF(J33<=$H$22+$H$11-1,$H$14*(1+$H$15)^(J33-$H$22),0)),\"\",IF(J33<=$H$22+$H$11-1,$H$14*(1+$H$15)^(J33-$H$22),0))","v":310843.57709866302},{"$f":"IF(ISERROR(IF(K33<=$H$22+$H$11-1,$H$14*(1+$H$15)^(K33-$H$22),0)),\"\",IF(K33<=$H$22+$H$11-1,$H$14*(1+$H$15)^(K33-$H$22),0))","v":317060.44864063634},323401.65761344903,329869.69076571806,0,0,0,0,0]
[null,null,null,null,null,null,"Zins",null,{"$f":"IF(ISERROR(IF(AND(R27<0,I35>0),R27*$H$12,0)),\"\",IF(AND(R27<0,I35>0),R27*$H$12,0))","v":0},{"$f":"IF(ISERROR(IF(AND(I38<0,J35>0),I38*$H$12,0)),\"\",IF(AND(I38<0,J35>0),I38*$H$12,0))","v":0},{"$f":"IF(ISERROR(IF(AND(J38<0,K35>0),J38*$H$12,0)),\"\",IF(AND(J38<0,K35>0),J38*$H$12,0))","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Tilgung",null,{"$f":"IF(ISERROR(IF(R27<0,IF(R27<-I35-I36,-I35-I36,R27),0)),\"\",IF(R27<0,IF(R27<-I35-I36,-I35-I36,R27),0))","v":0},{"$f":"IF(ISERROR(IF(I38<0,IF(I38<-J35-J36,-J35-J36,I38),0)),\"\",IF(I38<0,IF(I38<-J35-J36,-J35-J36,I38),0))","v":0},{"$f":"IF(ISERROR(IF(J38<0,IF(J38<-K35-K36,-K35-K36,J38),0)),\"\",IF(J38<0,IF(J38<-K35-K36,-K35-K36,J38),0))","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Restschuld",null,{"$f":"IF(ISERROR(IF(AND(R27-I37<0,I35>0),R27-I37,0)),\"\",IF(AND(R27-I37<0,I35>0),R27-I37,0))","v":0},{"$f":"IF(ISERROR(IF(AND(I38-J37<0,J35>0),I38-J37,0)),\"\",IF(AND(I38-J37<0,J35>0),I38-J37,0))","v":0},{"$f":"IF(ISERROR(IF(AND(J38-K37<0,K35>0),J38-K37,0)),\"\",IF(AND(J38-K37<0,K35>0),J38-K37,0))","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,"Überschuss",null,{"$f":"IF(ISERROR(I35+I36+I37),\"\",I35+I36+I37)","v":304748.60499868926},{"$f":"IF(ISERROR(J35+J36+J37),\"\",J35+J36+J37)","v":310843.57709866302},{"$f":"IF(ISERROR(K35+K36+K37),\"\",K35+K36+K37)","v":317060.44864063634},323401.65761344903,329869.69076571806,0,0,0,0,0]
[null,null,null,null,null,null,"Barwert",null,{"$f":"IF(ISERROR(IF(I39>0,I39/(1+$H$12)^(I33-$H$22+1),IF(AND(I38<0,J35=0),I38/(1+$H$12)^(I33-$H$22+1),0))),\"\",IF(I39>0,I39/(1+$H$12)^(I33-$H$22+1),IF(AND(I38<0,J35=0),I38/(1+$H$12)^(I33-$H$22+1),0)))","v":178180.19772071717},{"$f":"IF(ISERROR(IF(J39>0,J39/(1+$H$12)^(J33-$H$22+1),IF(AND(J38<0,K35=0),J38/(1+$H$12)^(J33-$H$22+1),0))),\"\",IF(J39>0,J39/(1+$H$12)^(J33-$H$22+1),IF(AND(J38<0,K35=0),J38/(1+$H$12)^(J33-$H$22+1),0)))","v":173089.33492869668},{"$f":"IF(ISERROR(IF(K39>0,K39/(1+$H$12)^(K33-$H$22+1),IF(AND(K38<0,L35=0),K38/(1+$H$12)^(K33-$H$22+1),0))),\"\",IF(K39>0,K39/(1+$H$12)^(K33-$H$22+1),IF(AND(K38<0,L35=0),K38/(1+$H$12)^(K33-$H$22+1),0)))","v":168143.92535930534},163339.81320618236,158672.96140029142,0,0,0,0,0]