{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["IES"],"not_rendered":{"charts":1,"images":36,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"IES","index":0,"n_rows":59,"n_cols":30,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,10,1,15],[1,28,1,29],[2,3,2,15],[2,18,2,30],[3,28,3,29],[3,25,3,26],[3,22,3,23]]}
[]
[null,null,null,"Immobilienentwicklungssimulator IES",null,null,null,null,"Projekt:",null,"Lösungshinweis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UEO",null,"2020-10-21"]
[null,null,null,"Données de base",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evaluation"]
[null,null,null,"1 Terrain / Propriété",null,"Usage résidenciel",null,null,null,null,"Utilisation commerciale",null,null,null,null,"Total",null,null,"Coût de création/constru",0,"Rundung",null,{"$f":"F4","v":"Usage résidenciel"},null,null,{"$f":"K4","v":"Utilisation commerciale"},null,null,"Total"]
[null,null,10,"Superficie GSF",null,null,"816",null,{"$f":"VALUE(G5)","v":816},null,null,"0",null,{"$f":"VALUE(L5)","v":0},null,{"$f":"N5+I5","v":816},null,null,"CFC 0 Terrain",null,"m2 * CHF/m2",null,null,{"$f":"ROUND(I6*I5,$T$4)","v":0},null,null,{"$f":"ROUND(N6*N5,$T$4)","v":0},null,null,{"$f":"AA5+X5","v":0}]
[null,null,11,"Coût du terrain",null,null,null,null,0,null,null,null,null,2075,null,{"$f":"IF(P5=0,0,(I5*I6+N5*N6)/P5)","v":0},null,null,"CFC 0 Frais accessoires GS",null,"du terrain",null,0.01,{"$f":"ROUND(X5*$W6,$T$4)","v":0},null,{"$f":"W6","v":0.01},{"$f":"ROUND(AA5*$Z6,$T$4)","v":0},null,null,0]
[null,null,null,"2 Superficies et volumes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CFC 0 Impôt sur les gains immob.",null,"de gain immob.",null,0.4,{"$f":"IF(G23=2,0,ROUND((X20-X5)*$W7,$T$4))","v":0},null,0.4,{"$f":"IF(L23=2,0,ROUND((AA20-AA5)*$W7,$T$4))","v":0},null,null,{"$f":"AA7+X7","v":0}]
[null,null,20,"Surface de plancher SP",null,null,"285",null,{"$f":"VALUE(G8)","v":285},null,null,"0",null,{"$f":"VALUE(L8)","v":0},null,{"$f":"N8+I8","v":285},null,null,"CFC 1 Travaux préparatoires",null,"de BKP 2 Baukosten/cout de const",null,0.03,{"$f":"ROUND($W8*X9,$T$4)","v":20002},null,{"$f":"W8","v":0.03},{"$f":"ROUND($Z8*AA9,$T$4)","v":0},null,null,{"$f":"AA8+X8","v":20002}]
[null,null,{"$f":"C8+1","v":21},"H.S.D. étage au dessus du sol (un seul étage)",null,null,null,null,260,null,null,null,null,397,null,{"$f":"IF(P8=0,0,(I9*I8+N9*N8)/P8)","v":260},null,null,"CFC 2 Coûts de construction",null,"m3 * CHF/m3",null,null,{"$f":"I45","v":666749.19999999995},null,null,{"$f":"N45","v":0},null,null,666749.19999999995]
[null,null,{"$f":"C9+1","v":22},"Optimisation de surface au-dessus du sol",null,null,800,null,{"$f":"G10/1000","v":0.8},null,null,850,null,{"$f":"L10/1000","v":0.85},null,{"$f":"IF(P8=0,0,(I8*I10+N8*N10)/P8)","v":0.8},null,null,"CFC 4 Aménagement ext.",null,"CHF/m2 GSF",null,200,{"$f":"ROUND($W10*I5,$T$4)","v":163200},null,200,{"$f":"ROUND($Z10*N5,$T$4)","v":0},null,null,{"$f":"AA10+X10","v":163200}]
[null,null,23,"Surface de plancher sous-sol (hors PP)",null,null,"142",null,{"$f":"VALUE(G11)","v":142},null,null,"0",null,{"$f":"VALUE(L11)","v":0},null,{"$f":"N11+I11","v":142},null,null,"CFC 5 Frais supplémentaire",null,"BKP 1-4 exkl. Honorare",null,9.8000000000000004E-2,{"$f":"ROUND($W11*(X8+X9+X10),$T$4)","v":83295},null,9.8000000000000004E-2,{"$f":"ROUND($Z11*(AA8+AA9+AA10),$T$4)","v":0},null,null,{"$f":"AA11+X11","v":83295}]
[null,null,24,"Hauteur du plancher sous-sol",null,null,null,null,260,null,null,null,null,300,null,{"$f":"IF(P11=0,0,(I12*I11+N12*N11)/P11)","v":260},null,null,"CFC 5 Financement",0.4,"von BKP 1-5, 18 Monate",null,0.02,{"$f":"IF(G23<>0,0,ROUND((X8+X9+X13+X10+X11)*$T12*1.5*W12,$T$4))","v":0},null,{"$f":"W12","v":0.02},{"$f":"IF(L23<>0,0,ROUND((AA8+AA9+AA13+AA10+AA11)*$T12*1.5*Z12,$T$4))","v":0},null,null,{"$f":"AA12+X12","v":0}]
[null,null,25,"Optimisation de l’espace UG",null,null,207,null,{"$f":"G13/1000","v":0.20699999999999999},null,null,250,null,{"$f":"L13/1000","v":0.25},null,{"$f":"IF(P11=0,0,(I11*I13+N11*N13)/P11)","v":0.20699999999999999},null,null,"CFC 6 Total des frais",null,"von BKP 1-4",null,0.222,{"$f":"ROUND($W13*(X8+X9+X10),$T$4)","v":188689},null,0.222,{"$f":"ROUND($Z13*(AA8+AA9+AA10),$T$4)","v":0},null,null,{"$f":"AA13+X13","v":188689}]
[null,null,26,"Bauvolumen GV",null,null,null,null,{"$f":"I8*I9*0.01+I11*I12*0.01","v":1110.2},null,null,null,null,{"$f":"N8*N9*0.01+N11*N12*0.01","v":0},null,{"$f":"N14+I14","v":1110.2},null,null,"CFC 7 Marketing",null,"von Ertrag",null,{"$f":"IF(G24=0,11%,4%)","v":0.04},{"$f":"IF(G24=0,ROUND(W$14*I53,$T$4),ROUND(W$14*I59,$T$4))","v":93576},null,{"$f":"IF(L24=0,17%,4%)","v":0.17},{"$f":"IF(L24=0,ROUND(Z$14*N53,$T$4),ROUND(Z$14*N59,$T$4))","v":0},null,null,93576]
[null,null,27,"Ertragsfläche / Surface de rendement",null,null,null,null,{"$f":"I8*I10+I11*I13","v":257.39400000000001},null,null,null,null,{"$f":"N8*N10+N11*N13","v":0},null,{"$f":"N15+I15","v":257.39400000000001},null,null,"CFC 8 Contribution propre",null,"von BKP 0-4",null,2.5000000000000001E-2,{"$f":"ROUND($W15*(X8+X9+X10+X5+X6),$T$4)","v":21249},null,2.5000000000000001E-2,{"$f":"ROUND($Z15*(AA8+AA9+AA10+AA5+AA6),$T$4)","v":0},null,null,21249]
[null,null,28,"Nombre PP intérieur",null,null,"0",null,{"$f":"VALUE(G16)","v":0},null,null,"0",null,{"$f":"VALUE(L16)","v":0},null,{"$f":"N16+I16","v":0},null,null,"Coûts nets",null,null,null,null,{"$f":"SUM(X5:X15)","v":1236760.2},null,null,{"$f":"SUM(AA5:AA15)","v":0},null,null,1236760.2]
[null,null,29,"Nombre PP extérieur",null,null,"2",null,{"$f":"VALUE(G17)","v":2},null,null,"0",null,{"$f":"VALUE(L17)","v":0},null,{"$f":"N17+I17","v":2},null,null,"TVA",7.6999999999999999E-2,"von BKP 1-8",null,null,{"$f":"ROUND($T17*(X8+X9+X13+X10+X11+X14+X15),$T$4)","v":95231},null,null,{"$f":"ROUND($T17*(AA8+AA9+AA13+AA10+AA11+AA14+AA15),$T$4)","v":0},null,null,95231]
[null,null,null,"3 Frais de construction",null,null,null,null,{"$f":"IF(I19<G19,\"tief\",IF(I19>H19,\"hoch\",\"mittel\"))","v":"hoch"},null,null,null,null,{"$f":"IF(N19<L19,\"Rohbau\",IF(N19>M19,\"ausgebaut\",\"Edelrohbau\"))","v":"Edelrohbau"},null,null,null,null,"Coûts création/constru. total",null,null,null,null,{"$f":"X17+X16","v":1331991.2},null,null,{"$f":"AA17+AA16","v":0},null,null,1331991.2]
[null,null,30,"Prix hors-sol BKP 2 (exkl. Honorare)",null,null,520,620,700,null,null,400,500,403,null,{"$f":"IF(P39=0,0,P42/P39)","v":700},null,null,"Revenu"]
[null,null,{"$f":"C19+1","v":31},"Prix sous-sol BKP 2 (exkl. Honorare)",null,null,null,null,401,null,null,null,null,290,null,{"$f":"IF(P40=0,0,P43/P40)","v":400.99999999999994},null,null,"Investisseur prix terrain ?",null,"kalk. Gains terrain",null,0.16669999999999999,{"$f":"IF(G23=0,ROUND(X5*(1+$W20),$T$4),IF(G23=1,ROUND(X5*(1+$W20),$T$4),X5+X6))","v":0},null,0.16669999999999999,{"$f":"IF(L23=0,ROUND(AA5*(1+$Z20),$T$4),IF(L23=1,ROUND(AA5*(1+$Z20),$T$4),AA5+AA6))","v":0},null,null,{"$f":"AA20+X20","v":0}]
[null,null,{"$f":"C20+1","v":32},"Prix PP Garage int. BKP 2 (exkl. Honorare)",null,null,null,null,29200,null,null,null,null,28400,null,{"$f":"IF(P16=0,0,P44/P16)","v":0},null,null,"Prix travail investisseur",null,null,null,null,{"$f":"ROUND((X23-X20)/(1+$T22),$T4)","v":2172134},null,null,{"$f":"ROUND((AA23-AA20)/(1+$T22),$T4)","v":0},null,null,{"$f":"AA21+X21","v":2172134}]
[null,null,null,"4 Rendement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TVA",{"$f":"T17","v":7.6999999999999999E-2},null,null,null,{"$f":"ROUND(X21*$T22,$T$4)","v":167254},null,null,{"$f":"ROUND(AA21*$T22,$T$4)","v":0},null,null,{"$f":"AA22+X22","v":167254}]
[null,null,40,"Devestitionsform (desinvestissement pas capter)",null,null,2,null,{"$f":"IF(G23=0,\"Objektkauf\",IF(G23=1,\"Werk + Land\",\"Werk\"))","v":"Werk"},null,null,1,null,{"$f":"IF(L23=0,\"Objektkauf\",IF(L23=1,\"Werk + Land\",\"Werk\"))","v":"Werk + Land"},null,null,null,null,"Coûts d'investissement",null,"Valeurs acquise capitalisée",null,null,{"$f":"IF(G24=0,ROUND(I54,$T$4),ROUND(I59,$T$4))","v":2339388},null,null,{"$f":"IF(L24=0,ROUND(N54,$T$4),ROUND(N59,$T$28))","v":0},null,null,{"$f":"AA23+X23","v":2339388}]
[null,null,{"$f":"C23+1","v":41},"Calcul de rendement basé sur",null,null,1,null,{"$f":"IF(G24=0,\"Revenu Locatif\",\"Produit de la vente\")","v":"Produit de la vente"},null,null,0,null,{"$f":"IF(L24=0,\"Mieterlös\",\"Verkaufserlös\")","v":"Mieterlös"},null,null,null,null,"Gain de développement (Hors tva exkl. MwSt.,)"]
[null,null,{"$f":"C24+1","v":42},"Revenu locatif par m2",null,null,220,270,267,null,null,null,null,255,null,{"$f":"IF(K49=0,0,P49/K49)","v":0}]
[null,null,{"$f":"C25+1","v":43},"Revenu locatif sous-sol",null,null,null,null,80,null,null,null,null,80,null,{"$f":"IF(K50=0,0,P50/K50)","v":0}]
[null,null,{"$f":"C26+1","v":44},"Revenu locatif par garage",null,null,null,null,150,null,null,null,null,190,null,{"$f":"IF(K51=0,0,P51/K51/12)","v":0}]
[null,null,45,"Revenu locatif par place de parc",null,null,null,null,null,null,null,null,null,80,null,{"$f":"IF(K52=0,0,P52/K52/12)","v":{"$error":"#DIV/0!"}}]
[null,null,46,"Taux de capitalisation",null,null,400,null,{"$f":"G29/10000","v":0.04},null,null,400,null,{"$f":"L29/10000","v":0.04},null,{"$f":"IF(P54=G2401,0,P53/P54)","v":0},null,null,"Evolution revenu, hors tva.",null,null,null,null,{"$f":"IF(G23=2,X21,X23-X22)","v":2172134},null,null,{"$f":"IF(L23=2,AA21,AA23-AA22)","v":0},null,null,{"$f":"AA29+X29","v":2172134}]
[null,null,{"$f":"C29+1","v":47},"Produit des ventes hors sol par surface utilisable",null,null,null,null,9950,null,null,null,null,10000,null,{"$f":"IF(K55=0,0,P55/K55)","v":9950},null,null,"Developpeurs de coûts tiers, exkl. MwSt.",null,null,null,null,{"$f":"IF(G23=2,X16-X15-X7-X6-X5,X16-X15)","v":1215511.2},null,null,{"$f":"IF(L23=2,AA16-AA15-AA7-AA6-AA5,AA16-AA15)","v":0},null,null,{"$f":"AA30+X30","v":1215511.2}]
[null,null,{"$f":"C30+1","v":48},"Produit des ventes sous-sol par surface utilisable",null,null,null,null,2000,null,null,null,null,1500,null,{"$f":"IF(K56=0,0,P56/K56)","v":2000},null,null,"Marge de contribution 1 (exkl. Contribution propres)",null,null,null,{"$f":"IF(X16=0,0,X31/X16)","v":0.7734909321952631},{"$f":"X29-X30","v":956622.8},null,{"$f":"IF(AA16=0,0,AA31/AA16)","v":0},{"$f":"AA29-AA30","v":0},null,{"$f":"IF(AD16=0,0,AD31/AD16)","v":0.7734909321952631},{"$f":"AA31+X31","v":956622.8}]
[null,null,{"$f":"C31+1","v":49},"Produit des ventes PP Garage",null,null,null,null,40000,null,null,null,null,40000,null,{"$f":"IF(K57=0,0,P57/K57)","v":0},null,null,"Contribution propre",null,null,null,null,{"$f":"X15","v":21249},null,null,{"$f":"AA15","v":0},null,null,{"$f":"AA32+X32","v":21249}]
[null,null,50,"Produit des ventes PP Parking",null,null,null,null,6000,null,null,null,null,60000,null,{"$f":"IF(K58=0,0,P58/K58)","v":6000},null,null,"Marge de contribution 2 ",null,null,null,{"$f":"IF(X16=0,0,X33/X16)","v":0.75630975188237792},{"$f":"X31-X32","v":935373.8},null,{"$f":"IF(AA16=0,0,AA33/AA16)","v":0},{"$f":"AA31-AA32","v":0},null,{"$f":"IF(AD16=0,0,AD33/AD16)","v":0.75630975188237792},{"$f":"AA33+X33","v":935373.8}]
[]
[null,null,null,"Haftungsausschluss:",null,"Das vorliegende Modell dient einzig zu Schulungszwecken und ist für den kommerziellen Einsatz nicht geeignet. Der Ersteller lehnt jegliche Haftungsforderungen ab.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 1.3 / 26.06.13 / UEO"]
[]
[]
[null,null,null,"5 Hilfskalkulationen"]
[null,null,null,"Volumen OG",null,null,null,null,{"$f":"I8*I9*0.01","v":741},null,null,null,null,{"$f":"N8*N9*0.01","v":0},null,{"$f":"N39+I39","v":741},null,null,null,null,null,null,"DB",{"$f":"X31","v":956622.8},null,null,{"$f":"AA31","v":0}]
[null,null,null,"Volumen UG",null,null,null,null,{"$f":"I11*I12*0.01","v":369.2},null,null,null,null,{"$f":"N11*N12*0.01","v":0},null,{"$f":"N40+I40","v":369.2},null,null,null,null,null,null,"Kosten",{"$f":"X30","v":1215511.2},null,null,{"$f":"AA30","v":0}]
[null,null,null,"Volumen tot",null,null,null,null,{"$f":"I40+I39","v":1110.2},null,null,null,null,{"$f":"N40+N39","v":0},null,1110.2,null,null,null,null,null,null,"Erlös",null,{"$f":"X29","v":2172134},null,null,{"$f":"AA29","v":0}]
[null,null,null,"Kosten OG",null,null,null,null,{"$f":"I19*I39","v":518700},null,null,null,null,{"$f":"N19*N39","v":0},null,518700]
[null,null,null,"Kosten UG",null,null,null,null,{"$f":"I20*I40","v":148049.19999999998},null,null,null,null,{"$f":"N20*N40","v":0},null,148049.19999999998]
[null,null,null,"Kosten PP",null,null,null,null,{"$f":"I16*I21","v":0},null,null,null,null,{"$f":"N16*N21","v":0},null,0]
[null,null,null,"Kosten Total",null,null,null,null,{"$f":"SUM(I42:I44)","v":666749.19999999995},null,null,null,null,{"$f":"SUM(N42:N44)","v":0},null,666749.19999999995]
[null,null,null,"Ertragsfläche OG",null,null,null,null,{"$f":"I8*I10","v":228},null,null,null,null,{"$f":"N8*N10","v":0},null,228]
[null,null,null,"Ertragsfläche UG",null,null,null,null,{"$f":"I13*I11","v":29.393999999999998},null,null,null,null,{"$f":"N13*N11","v":0},null,29.393999999999998]
[null,null,null,"Ertragsfläche Tot",null,null,null,null,{"$f":"I47+I46","v":257.39400000000001},null,null,null,null,{"$f":"N47+N46","v":0},null,257.39400000000001]
[null,null,null,"Ertrag OG",null,null,null,{"$f":"I49/I25","v":0},{"$f":"IF(G$24=1,0,I46*I25)","v":0},null,{"$f":"SUM(H49,M49)","v":0},null,{"$f":"N49/N25","v":0},{"$f":"IF(L$24=1,0,N46*N25)","v":0},null,0]
[null,null,null,"Ertrag UG",null,null,null,{"$f":"I50/I26","v":0},{"$f":"IF(G$24=1,0,I47*I26)","v":0},null,{"$f":"SUM(H50,M50)","v":0},null,{"$f":"N50/N26","v":0},{"$f":"IF(L$24=1,0,N47*N26)","v":0},null,0]
[null,null,null,"Ertrag PP G",null,null,null,{"$f":"I51/I27/12","v":0},{"$f":"IF(G$24=1,0,I16*I27*12)","v":0},null,{"$f":"SUM(H51,M51)","v":0},null,{"$f":"N51/N27/12","v":0},{"$f":"IF(L$24=1,0,N16*N27*12)","v":0},null,0]
[null,null,null,"Ertrag PP A",null,null,null,{"$f":"I52/I28/12","v":{"$error":"#DIV/0!"}},{"$f":"IF(G$24=1,0,I17*I28*12)","v":0},null,{"$f":"SUM(H52,M52)","v":{"$error":"#DIV/0!"}},null,{"$f":"N52/N28/12","v":0},{"$f":"IF(L$24=1,0,N17*N28*12)","v":0},null,0]
[null,null,null,"Ertrag Total",null,null,null,null,{"$f":"SUM(I49:I52)","v":0},null,null,null,null,{"$f":"SUM(N49:N52)","v":0},null,0]
[null,null,null,"kapitalisiert",null,null,null,null,{"$f":"I53/I29","v":0},null,null,null,null,{"$f":"N53/N29","v":0},null,0]
[null,null,null,"Ertrag OG Kauf",null,null,null,{"$f":"I55/I30","v":228},{"$f":"IF(G$24=0,0,I30*I46)","v":2268600},null,{"$f":"SUM(H55,M55)","v":228},null,{"$f":"N55/N30","v":0},{"$f":"IF(L$24=0,0,N30*N46)","v":0},null,{"$f":"N55+I55","v":2268600}]
[null,null,null,"Ertrag UG Kauf",null,null,null,{"$f":"I56/I31","v":29.393999999999998},{"$f":"IF(G$24=0,0,I31*I47)","v":58788},null,{"$f":"SUM(H56,M56)","v":29.393999999999998},null,{"$f":"N56/N31","v":0},{"$f":"IF(L$24=0,0,N31*N47)","v":0},null,58788]
[null,null,null,"Ertrag PP G Kauf",null,null,null,{"$f":"I57/I32","v":0},{"$f":"IF(G$24=0,0,I32*I16)","v":0},null,{"$f":"SUM(H57,M57)","v":0},null,{"$f":"N57/N32","v":0},{"$f":"IF(L$24=0,0,N32*N16)","v":0},null,0]
[null,null,null,"Ertrag PP A Kauf",null,null,null,{"$f":"I58/I33","v":2},{"$f":"IF(G$24=0,0,I33*I17)","v":12000},null,{"$f":"SUM(H58,M58)","v":2},null,{"$f":"N58/N33","v":0},{"$f":"IF(L$24=0,0,N33*N17)","v":0},null,12000]
[null,null,null,"Ertrag Total",null,null,null,null,{"$f":"SUM(I55:I58)","v":2339388},null,null,null,null,{"$f":"SUM(N55:N58)","v":0},null,2339388]