{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Ausgangsbeispiel","RND korrigiert","BWK erhöht und RND korrigiert","BWK und RND erhöht, BW gesenkt"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Ausgangsbeispiel","index":0,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[22,16,22,20],[22,22,22,23],[22,25,22,26],[28,22,28,23],[28,25,28,26],[25,16,25,23],[25,25,25,26],[26,25,26,26],[27,22,27,23],[16,23,16,24],[18,16,18,17],[18,19,18,20],[19,25,19,26],[20,25,20,26],[12,16,12,17],[12,23,12,24],[27,8,27,9],[3,5,3,6],[4,5,4,6],[19,11,19,12],[7,15,7,27],[9,16,9,17],[9,19,9,20],[9,25,9,26],[10,23,10,24],[23,25,23,26],[13,23,13,24],[15,16,15,17],[15,19,15,21],[15,23,15,24],[28,11,28,12],[28,8,28,9],[7,1,7,13],[5,5,5,6],[23,11,23,12],[25,2,25,9],[25,11,25,12],[26,11,26,12],[9,11,9,12],[20,11,20,12],[22,8,22,9],[22,2,22,6],[22,11,22,12],[18,2,18,3],[18,5,18,6],[16,9,16,10],[12,2,12,3],[15,2,15,3],[15,5,15,7],[12,9,12,10],[13,9,13,10],[15,9,15,10],[1,5,1,6],[9,2,9,3],[9,5,9,6],[2,5,2,6],[10,9,10,10]]}
[]
[null,"Grundstücksfläche:",null,null,null,900,null,"qm"]
[null,"Nutzfläche:",null,null,null,1750,null,"qm"]
[null,"Rundung:",null,null,null,-3]
[null,"Wertermittlungsstichtag:",null,null,null,"2023-11-01"]
[null,"Datenstichtag:",null,null,null,"2022-07-01"]
[]
[null,"01.07.2022 (Datenstichtag) + MAP (§ 7) auf den Stichtag 01.11.2023",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wertermittlungsstichtag 01.11.2023 | Marktanpassung umgerechnet in LSZ"]
[null,"Bodenwert",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwert"]
[null,null,{"$f":"$F$2","v":900},null,"€ x",650,null,"€/qm",null,null,null,{"$f":"ROUND(C10*F10,0)","v":585000},null,"€",null,null,{"$f":"$F$2","v":900},null,"€ x",650,null,"€/qm",null,null,null,{"$f":"ROUND(Q10*T10,0)","v":585000},null,"€"]
[null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€",null,null,null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€"]
[null,"Bewirtschaftungskosten pauschal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bewirtschaftungskosten pauschal"]
[null,null,0.18,null,null,null,null,null,null,{"$f":"-ROUND(C13*J11,0)","v":-28800},null,"€",null,null,null,null,0.18,null,null,null,null,null,null,{"$f":"-ROUND(Q13*X11,0)","v":-28800},null,"€"]
[null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"J11+J13","v":131200},null,"€",null,null,null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"X11+X13","v":131200},null,"€"]
[null,"Bodenwertverzinsungsbetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwertverzinsungsbetrag"]
[null,"LSZ",1.4999999999999999E-2,null,"von",{"$f":"L10","v":585000},null,null,null,{"$f":"-ROUND(C16*F16,0)","v":-8775},null,"€",null,null,null,"LSZ",2.5791266606212199E-2,null,"von",{"$f":"Z10","v":585000},null,null,null,{"$f":"-ROUND(Q16*T16,0)","v":-15088},null,"€"]
[null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"J14+J16","v":122425},null,"€",null,null,null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"X14+X16","v":116112},null,"€"]
[null,"Kapitalisierungsfaktor bei",null,null,null,null,40,"Jahren",null,null,null,null,null,null,null,"Kapitalisierungsfaktor bei",null,null,null,null,40,"Jahren"]
[null,"LSZ",{"$f":"C16","v":1.4999999999999999E-2},null,"=",{"$f":"PV(C16,G18,-1)","v":29.915845204174367},null,"fach",null,null,null,null,null,null,null,"LSZ",{"$f":"Q16","v":2.5791266606212199E-2},null,"=",{"$f":"PV(Q16,U18,-1)","v":24.771544376833191},null,"fach"]
[null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J17*F19,0)","v":3662447},null,"€",null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(X17*T19,0)","v":2876274},null,"€"]
[null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L10+L20,$F$4)","v":4247000},null,"€",null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z10+Z20,$F$4)","v":3461000},null,"€"]
[null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021"]
[null,null,"Datenstichtag 01.07.2022 zu Stichtag",null,null,null,null,"Wert:",-0.185,null,null,{"$f":"ROUND(L21*I23,0)","v":-785695},null,"€",null,null,"Keine",null,null,null,null,"Wert:",0,null,null,{"$f":"ROUND(Z21*W23,0)","v":0},null,"€"]
[null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L21+L23,$F$4)","v":3461000},null,"€",null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z21+Z23,$F$4)","v":3461000},null,"€"]
[null,"Besondere objektspezifische Grundstücksmerkmale",null,null,null,null,null,null,null,null,null,null,null,null,null,"Besondere objektspezifische Grundstücksmerkmale"]
[null,null,null,null,null,null,null,null,null,null,null,0,null,"€",null,null,null,null,null,null,null,null,null,null,null,0,null,"€"]
[null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L24+L26,$F$4)","v":3461000},null,"€",null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z24+Z26,$F$4)","v":3461000},null,"€"]
[null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(L27/J11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(L27/$F$3,9)","v":1977.714285714},null,"€/qm",null,null,null,null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(Z27/X11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(Z27/$F$3,9)","v":1977.714285714},null,"€/qm"]
[null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*L29/L27","v":-22.710199364345566},null,"%",{"$f":"L27-L21","v":-786000},null,"€",null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*Z29/Z27","v":0},null,"%",{"$f":"Z27-Z21","v":0},null,"€"]

{"sheet":"RND korrigiert","index":1,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,5,1,6],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[7,15,7,27],[9,2,9,3],[9,5,9,6],[9,11,9,12],[9,16,9,17],[9,19,9,20],[9,25,9,26],[7,1,7,13],[10,9,10,10],[10,23,10,24],[12,2,12,3],[12,9,12,10],[12,16,12,17],[12,23,12,24],[13,9,13,10],[13,23,13,24],[15,2,15,3],[15,5,15,7],[15,9,15,10],[15,16,15,17],[15,19,15,21],[15,23,15,24],[16,9,16,10],[16,23,16,24],[18,2,18,3],[18,5,18,6],[18,16,18,17],[18,19,18,20],[19,11,19,12],[19,25,19,26],[20,11,20,12],[20,25,20,26],[22,2,22,6],[22,8,22,9],[22,11,22,12],[22,16,22,20],[22,22,22,23],[22,25,22,26],[23,11,23,12],[23,25,23,26],[25,2,25,9],[25,11,25,12],[25,16,25,23],[25,25,25,26],[26,11,26,12],[26,25,26,26],[27,8,27,9],[27,22,27,23],[28,8,28,9],[28,11,28,12],[28,22,28,23],[28,25,28,26]]}
[]
[null,"Grundstücksfläche:",null,null,null,900,null,"qm"]
[null,"Nutzfläche:",null,null,null,1750,null,"qm"]
[null,"Rundung:",null,null,null,-3]
[null,"Wertermittlungsstichtag:",null,null,null,"2023-11-01"]
[null,"Datenstichtag:",null,null,null,"2022-07-01"]
[]
[null,"01.07.2022 (Datenstichtag) + MAP (§ 7) auf den Stichtag 01.11.2023",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wertermittlungsstichtag 01.11.2023 | Marktanpassung umgerechnet in LSZ"]
[null,"Bodenwert",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwert"]
[null,null,{"$f":"$F$2","v":900},null,"€ x",650,null,"€/qm",null,null,null,{"$f":"ROUND(C10*F10,0)","v":585000},null,"€",null,null,{"$f":"$F$2","v":900},null,"€ x",650,null,"€/qm",null,null,null,{"$f":"ROUND(Q10*T10,0)","v":585000},null,"€"]
[null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€",null,null,null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€"]
[null,"Bewirtschaftungskosten pauschal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bewirtschaftungskosten pauschal"]
[null,null,0.18,null,null,null,null,null,null,{"$f":"-ROUND(C13*J11,0)","v":-28800},null,"€",null,null,null,null,0.18,null,null,null,null,null,null,{"$f":"-ROUND(Q13*X11,0)","v":-28800},null,"€"]
[null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"J11+J13","v":131200},null,"€",null,null,null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"X11+X13","v":131200},null,"€"]
[null,"Bodenwertverzinsungsbetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwertverzinsungsbetrag"]
[null,"LSZ",1.4999999999999999E-2,null,"von",{"$f":"L10","v":585000},null,null,null,{"$f":"-ROUND(C16*F16,0)","v":-8775},null,"€",null,null,null,"LSZ",2.5114245857799131E-2,null,"von",{"$f":"Z10","v":585000},null,null,null,{"$f":"-ROUND(Q16*T16,0)","v":-14692},null,"€"]
[null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"J14+J16","v":122425},null,"€",null,null,null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"X14+X16","v":116508},null,"€"]
[null,"Kapitalisierungsfaktor bei",null,null,null,null,40,"Jahren",null,null,null,null,null,null,null,"Kapitalisierungsfaktor bei",null,null,null,null,39,"Jahren"]
[null,"LSZ",{"$f":"C16","v":1.4999999999999999E-2},null,"=",{"$f":"PV(C16,G18,-1)","v":29.915845204174367},null,"fach",null,null,null,null,null,null,null,"LSZ",{"$f":"Q16","v":2.5114245857799131E-2},null,"=",{"$f":"PV(Q16,U18,-1)","v":24.6837718451354},null,"fach"]
[null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J17*F19,0)","v":3662447},null,"€",null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(X17*T19,0)","v":2875857},null,"€"]
[null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L10+L20,$F$4)","v":4247000},null,"€",null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z10+Z20,$F$4)","v":3461000},null,"€"]
[null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021"]
[null,null,"Datenstichtag 01.07.2022 zu Stichtag",null,null,null,null,"Wert:",-0.185,null,null,{"$f":"ROUND(L21*I23,0)","v":-785695},null,"€",null,null,"Keine",null,null,null,null,"Wert:",0,null,null,{"$f":"ROUND(Z21*W23,0)","v":0},null,"€"]
[null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L21+L23,$F$4)","v":3461000},null,"€",null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z21+Z23,$F$4)","v":3461000},null,"€"]
[null,"Besondere objektspezifische Grundstücksmerkmale",null,null,null,null,null,null,null,null,null,null,null,null,null,"Besondere objektspezifische Grundstücksmerkmale"]
[null,null,null,null,null,null,null,null,null,null,null,0,null,"€",null,null,null,null,null,null,null,null,null,null,null,0,null,"€"]
[null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L24+L26,$F$4)","v":3461000},null,"€",null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z24+Z26,$F$4)","v":3461000},null,"€"]
[null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(L27/J11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(L27/$F$3,9)","v":1977.714285714},null,"€/qm",null,null,null,null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(Z27/X11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(Z27/$F$3,9)","v":1977.714285714},null,"€/qm"]
[null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*L29/L27","v":-22.710199364345566},null,"%",{"$f":"L27-L21","v":-786000},null,"€",null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*Z29/Z27","v":0},null,"%",{"$f":"Z27-Z21","v":0},null,"€"]

{"sheet":"BWK erhöht und RND korrigiert","index":2,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,5,1,6],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[7,15,7,27],[9,2,9,3],[9,5,9,6],[9,11,9,12],[9,16,9,17],[9,19,9,20],[9,25,9,26],[7,1,7,13],[10,9,10,10],[10,23,10,24],[12,2,12,3],[12,9,12,10],[12,16,12,17],[12,23,12,24],[13,9,13,10],[13,23,13,24],[15,2,15,3],[15,5,15,7],[15,9,15,10],[15,16,15,17],[15,19,15,21],[15,23,15,24],[16,9,16,10],[16,23,16,24],[18,2,18,3],[18,5,18,6],[18,16,18,17],[18,19,18,20],[19,11,19,12],[19,25,19,26],[20,11,20,12],[20,25,20,26],[22,2,22,6],[22,8,22,9],[22,11,22,12],[22,16,22,20],[22,22,22,23],[22,25,22,26],[23,11,23,12],[23,25,23,26],[25,2,25,9],[25,11,25,12],[25,16,25,23],[25,25,25,26],[26,11,26,12],[26,25,26,26],[27,8,27,9],[27,22,27,23],[28,8,28,9],[28,11,28,12],[28,22,28,23],[28,25,28,26]]}
[]
[null,"Grundstücksfläche:",null,null,null,900,null,"qm"]
[null,"Nutzfläche:",null,null,null,1750,null,"qm"]
[null,"Rundung:",null,null,null,-3]
[null,"Wertermittlungsstichtag:",null,null,null,"2023-11-01"]
[null,"Datenstichtag:",null,null,null,"2022-07-01"]
[]
[null,"01.07.2022 (Datenstichtag) + MAP (§ 7) auf den Stichtag 01.11.2023",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wertermittlungsstichtag 01.11.2023 | Marktanpassung umgerechnet in LSZ"]
[null,"Bodenwert",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwert"]
[null,null,{"$f":"$F$2","v":900},null,"€ x",650,null,"€/qm",null,null,null,{"$f":"ROUND(C10*F10,0)","v":585000},null,"€",null,null,{"$f":"$F$2","v":900},null,"€ x",650,null,"€/qm",null,null,null,{"$f":"ROUND(Q10*T10,0)","v":585000},null,"€"]
[null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€",null,null,null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€"]
[null,"Bewirtschaftungskosten pauschal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bewirtschaftungskosten pauschal"]
[null,null,0.18,null,null,null,null,null,null,{"$f":"-ROUND(C13*J11,0)","v":-28800},null,"€",null,null,null,null,0.22,null,null,null,null,null,null,{"$f":"-ROUND(Q13*X11,0)","v":-35200},null,"€"]
[null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"J11+J13","v":131200},null,"€",null,null,null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"X11+X13","v":124800},null,"€"]
[null,"Bodenwertverzinsungsbetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwertverzinsungsbetrag"]
[null,"LSZ",1.4999999999999999E-2,null,"von",{"$f":"L10","v":585000},null,null,null,{"$f":"-ROUND(C16*F16,0)","v":-8775},null,"€",null,null,null,"LSZ",2.2542929892744253E-2,null,"von",{"$f":"Z10","v":585000},null,null,null,{"$f":"-ROUND(Q16*T16,0)","v":-13188},null,"€"]
[null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"J14+J16","v":122425},null,"€",null,null,null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"X14+X16","v":111612},null,"€"]
[null,"Kapitalisierungsfaktor bei",null,null,null,null,40,"Jahren",null,null,null,null,null,null,null,"Kapitalisierungsfaktor bei",null,null,null,null,39,"Jahren"]
[null,"LSZ",{"$f":"C16","v":1.4999999999999999E-2},null,"=",{"$f":"PV(C16,G18,-1)","v":29.915845204174367},null,"fach",null,null,null,null,null,null,null,"LSZ",{"$f":"Q16","v":2.2542929892744253E-2},null,"=",{"$f":"PV(Q16,U18,-1)","v":25.764249641064708},null,"fach"]
[null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J17*F19,0)","v":3662447},null,"€",null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(X17*T19,0)","v":2875599},null,"€"]
[null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L10+L20,$F$4)","v":4247000},null,"€",null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z10+Z20,$F$4)","v":3461000},null,"€"]
[null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021"]
[null,null,"Datenstichtag 01.07.2022 zu Stichtag",null,null,null,null,"Wert:",-0.185,null,null,{"$f":"ROUND(L21*I23,0)","v":-785695},null,"€",null,null,"Keine",null,null,null,null,"Wert:",0,null,null,{"$f":"ROUND(Z21*W23,0)","v":0},null,"€"]
[null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L21+L23,$F$4)","v":3461000},null,"€",null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z21+Z23,$F$4)","v":3461000},null,"€"]
[null,"Besondere objektspezifische Grundstücksmerkmale",null,null,null,null,null,null,null,null,null,null,null,null,null,"Besondere objektspezifische Grundstücksmerkmale"]
[null,null,null,null,null,null,null,null,null,null,null,0,null,"€",null,null,null,null,null,null,null,null,null,null,null,0,null,"€"]
[null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L24+L26,$F$4)","v":3461000},null,"€",null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z24+Z26,$F$4)","v":3461000},null,"€"]
[null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(L27/J11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(L27/$F$3,9)","v":1977.714285714},null,"€/qm",null,null,null,null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(Z27/X11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(Z27/$F$3,9)","v":1977.714285714},null,"€/qm"]
[null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*L29/L27","v":-22.710199364345566},null,"%",{"$f":"L27-L21","v":-786000},null,"€",null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*Z29/Z27","v":0},null,"%",{"$f":"Z27-Z21","v":0},null,"€"]

{"sheet":"BWK und RND erhöht, BW gesenkt","index":3,"n_rows":29,"n_cols":28,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,5,1,6],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[7,15,7,27],[9,2,9,3],[9,5,9,6],[9,11,9,12],[9,16,9,17],[9,19,9,20],[9,25,9,26],[7,1,7,13],[10,9,10,10],[10,23,10,24],[12,2,12,3],[12,9,12,10],[12,16,12,17],[12,23,12,24],[13,9,13,10],[13,23,13,24],[15,2,15,3],[15,5,15,7],[15,9,15,10],[15,16,15,17],[15,19,15,21],[15,23,15,24],[16,9,16,10],[16,23,16,24],[18,2,18,3],[18,5,18,6],[18,16,18,17],[18,19,18,20],[19,11,19,12],[19,25,19,26],[20,11,20,12],[20,25,20,26],[22,2,22,6],[22,8,22,9],[22,11,22,12],[22,16,22,20],[22,22,22,23],[22,25,22,26],[23,11,23,12],[23,25,23,26],[25,2,25,9],[25,11,25,12],[25,16,25,23],[25,25,25,26],[26,11,26,12],[26,25,26,26],[27,8,27,9],[27,22,27,23],[28,8,28,9],[28,11,28,12],[28,22,28,23],[28,25,28,26]]}
[]
[null,"Grundstücksfläche:",null,null,null,900,null,"qm"]
[null,"Nutzfläche:",null,null,null,1750,null,"qm"]
[null,"Rundung:",null,null,null,-3]
[null,"Wertermittlungsstichtag:",null,null,null,"2023-11-01"]
[null,"Datenstichtag:",null,null,null,"2022-07-01"]
[]
[null,"01.07.2022 (Datenstichtag) + MAP (§ 7) auf den Stichtag 01.11.2023",null,null,null,null,null,null,null,null,null,null,null,null,null,"Wertermittlungsstichtag 01.11.2023 | Marktanpassung umgerechnet in LSZ"]
[null,"Bodenwert",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwert"]
[null,null,{"$f":"$F$2","v":900},null,"€ x",650,null,"€/qm",null,null,null,{"$f":"ROUND(C10*F10,0)","v":585000},null,"€",null,null,{"$f":"$F$2","v":900},null,"€ x",585,null,"€/qm",null,null,null,{"$f":"ROUND(Q10*T10,0)","v":526500},null,"€"]
[null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€",null,null,null,"Jährlicher Rohertrag",null,null,null,null,null,null,null,{"$f":"160000","v":160000},null,"€"]
[null,"Bewirtschaftungskosten pauschal",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bewirtschaftungskosten pauschal"]
[null,null,0.18,null,null,null,null,null,null,{"$f":"-ROUND(C13*J11,0)","v":-28800},null,"€",null,null,null,null,0.18,null,null,null,null,null,null,{"$f":"-ROUND(Q13*X11,0)","v":-28800},null,"€"]
[null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"J11+J13","v":131200},null,"€",null,null,null,"Jährlicher Reinertrag",null,null,null,null,null,null,null,{"$f":"X11+X13","v":131200},null,"€"]
[null,"Bodenwertverzinsungsbetrag",null,null,null,null,null,null,null,null,null,null,null,null,null,"Bodenwertverzinsungsbetrag"]
[null,"LSZ",1.4999999999999999E-2,null,"von",{"$f":"L10","v":585000},null,null,null,{"$f":"-ROUND(C16*F16,0)","v":-8775},null,"€",null,null,null,"LSZ",3.0122862320336671E-2,null,"von",{"$f":"Z10","v":526500},null,null,null,{"$f":"-ROUND(Q16*T16,0)","v":-15860},null,"€"]
[null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"J14+J16","v":122425},null,"€",null,null,null,"Reinertragsanteil der baulichen Anlagen",null,null,null,null,null,null,null,{"$f":"X14+X16","v":115340},null,"€"]
[null,"Kapitalisierungsfaktor bei",null,null,null,null,40,"Jahren",null,null,null,null,null,null,null,"Kapitalisierungsfaktor bei",null,null,null,null,49,"Jahren"]
[null,"LSZ",{"$f":"C16","v":1.4999999999999999E-2},null,"=",{"$f":"PV(C16,G18,-1)","v":29.915845204174367},null,"fach",null,null,null,null,null,null,null,"LSZ",{"$f":"Q16","v":3.0122862320336671E-2},null,"=",{"$f":"PV(Q16,U18,-1)","v":25.44309618550076},null,"fach"]
[null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(J17*F19,0)","v":3662447},null,"€",null,"Vorläufiger Ertragswert der baulichen Anlagen",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(X17*T19,0)","v":2934607},null,"€"]
[null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L10+L20,$F$4)","v":4247000},null,"€",null,"Vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z10+Z20,$F$4)","v":3461000},null,"€"]
[null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,"Marktanpassung nach § 7 Abs. 2 ImmoWertV 2021"]
[null,null,"Datenstichtag 01.07.2022 zu Stichtag",null,null,null,null,"Wert:",-0.185,null,null,{"$f":"ROUND(L21*I23,0)","v":-785695},null,"€",null,null,"Keine",null,null,null,null,"Wert:",0,null,null,{"$f":"ROUND(Z21*W23,0)","v":0},null,"€"]
[null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L21+L23,$F$4)","v":3461000},null,"€",null,"Marktangepasster vorläufiger Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z21+Z23,$F$4)","v":3461000},null,"€"]
[null,"Besondere objektspezifische Grundstücksmerkmale",null,null,null,null,null,null,null,null,null,null,null,null,null,"Besondere objektspezifische Grundstücksmerkmale"]
[null,null,null,null,null,null,null,null,null,null,null,0,null,"€",null,null,null,null,null,null,null,null,null,null,null,0,null,"€"]
[null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(L24+L26,$F$4)","v":3461000},null,"€",null,"Ertragswert (gerundet)",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(Z24+Z26,$F$4)","v":3461000},null,"€"]
[null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(L27/J11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(L27/$F$3,9)","v":1977.714285714},null,"€/qm",null,null,null,null,"Rohertragsfaktor:",null,null,{"$f":"ROUND(Z27/X11,2)","v":21.63},"fach","pro qm NF:",null,{"$f":"ROUND(Z27/$F$3,9)","v":1977.714285714},null,"€/qm"]
[null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*L29/L27","v":-22.710199364345566},null,"%",{"$f":"L27-L21","v":-786000},null,"€",null,"Differenz Ertragswert zum vorläufigen Ertragswert",null,null,null,null,null,null,{"$f":"100*Z29/Z27","v":0},null,"%",{"$f":"Z27-Z21","v":0},null,"€"]