{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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":"Tabelle1","index":0,"n_rows":40,"n_cols":4,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"L I E G E N S C H A F T S Z I N S S A T Z    A U S    R E N D I T E    E R M I T T E L N"]
[null,null,null,"Felder ausfüllen"]
[null,"Parameter ","%-Ansatz","Wert"]
[null,"Ertragswertverfahren"]
[null,"    Bodenwert",null,1500000]
[null,"    Nettokaltmiete ohne Betriebskosten (Rohertrag)",null,375000]
[null,"    Bewirtschaftungskosten"]
[null,"         Verwaltungskosten",0.02]
[null,"         Instandhaltungskosten",0.04]
[null,"         Mietausfallwagnis",0.04]
[null,"         Sonstige Kosten",0.01]
[null,"    Summe Bewirtschaftungskosten",{"$f":"SUM(C9:C12)","v":0.11},{"$f":"(-1)*D7*C13","v":-41250}]
[null,"    Reinertrag",null,{"$f":"D7+D13","v":333750}]
[null,"    Restnutzungsdauer",null,50]
[null,"Rendite"]
[null,"    Nettoanfangsrendite (NAR) *",null,0.05]
[null,"    Transaktionskosten (% vom Verkehrswert)",null,7.4999999999999997E-2]
[null,"    Bewirtschaftungskosten für NAR *"]
[null,"         Verwaltungskosten",0.02]
[null,"         Instandhaltungskosten",2.5000000000000001E-2]
[null,"         Mietausfallwagnis",0]
[null,"         Sonstige Kosten",0.01]
[null,"         Sonstige Kosten",0]
[null,"    Summe Bewirtschaftungskosten (für NAR)",{"$f":"SUM(C20:C24)","v":5.5E-2},{"$f":"-D7*C25","v":-20625}]
[]
[null,"Ergebnis",null,"Wert"]
[null,"Liegenschaftszinssatz",null,4.6483989776604333E-2]
[]
[null,"Nebenrechnung",null,"Wert"]
[null,"Kapitalisierungsfaktor nach ImmoWertV 2021",null,{"$f":"ROUND(PV(D28,D15,-1),2)","v":19.29}]
[null,"Rohertragsfaktor",null,{"$f":"Ergebnis_EW/D7","v":17.581395348837209}]
[null,"Reinertrag (Bewirtschaftungskosten Renditeberechnung)",{"$f":"C25","v":5.5E-2},{"$f":"D7-(D7*C33)","v":354375}]
[null,"RE(BWKnar)/NAR * 1/(1+Delta)",null,{"$f":"(RENAR/NAR)*(1/(1+Delta))","v":6593023.2558139535}]
[null,"Ertragswert (RE-lz*BW)*V+BW",null,{"$f":"(RE-(lz*BW))*V+BW","v":6593023.2558139535}]
[]
[]
[]
[null,"© Prof. Thore Simon 2026. Die Datei dient zu Demonstrationszwecken. Es wird keine Haftung übernommen."]
[null,"* Wenn die Bruttoanfangsrendite als Basis verwendet wird, sind Transaktionskosten und Bewirtschaftungskosten nicht auszufüllen."]

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