GDV total
Dashboard izolat extragere rapida
Fezabilitate dezvoltare rezidentiala
Replica modelului Excel in UI web, cu editare live, cash-flow pe trimestre si criterii de investitie.
TDC
18.114.560 EUR
Cost total de dezvoltareProfit brut
5.487.440 EUR
GDV - TDCMarja dezvoltare
23,25 %
Profit / GDVIRR equity anualizat
27,57 %
Din cash flow leveredPeak equity
4.281.118 EUR
Necesar maxim capital propriuRitm vanzari (ultimele 4Q)
0 unitati
-100.0% vs fereastra anterioaraMomentum venituri (ultimele 4Q)
9.227.000 EUR
-12.2% vs fereastra anterioaraCompresie sold credit
100,0%
Peak: 6.240.000 EUR | Curent: 0 EURSell-through pana in Q curent
100,0%
144 din 144 unitatiNet levered Q curent
0 EUR
+0 EUR vs Q anteriorMarja peste prag 20%
3,2 pp
Marja curenta: 23,25 %Cash flow trimestrial
Venituri, costuri si flux net unlevered
Evolutie cumulata
Comparatie unlevered vs levered + sold credit
Trend vanzari unitati
Unitati vandute pe trimestru si progres cumulat
Mix venituri pe trimestre
Avansuri, balante la livrare si venituri auxiliare
Trend finantare
Drawdown, rambursare, dobanda si sold credit
Indicatori model
Rezultatele din tab-ul RETURNS
IRR proiect anualizat22,74 %
NPV proiect1.713.013 EUR
Multiplu equity2,13x
Total cost finantare629.200 EUR
LTC efectiv45,93 %
Luni teoretice vanzare24,0
Criterii investitie
Evaluare automata GO / NO-GO
IRR equity anualizat > rata discount
Prag: 12,00 %27,57 %GO
Marja dezvoltare > 20%
Prag: 20,00 %23,25 %GO
Multiplu equity > 1.5x
Prag: 150,00 %2,13xGO
NPV proiect > 0
Prag: 0,00 %1.713.013 EURGO
Inputuri derivate si timeline
Valorile calculate automat din parametri
Unitati totale
144Unitati faza 2
72NLA total
9.360 sqmGBA total
16.000 sqmStart constructie faza 1
Q5Livrare faza 1
Q13Start constructie faza 2
Q9Durata proiect
17 trimestreDev budget summary
Echivalentul foii DEV BUDGET
| Linie | Valoare | % din TDC | EUR/sqm GBA | EUR/sqm NLA |
|---|---|---|---|---|
| Pret teren | 1.750.000 EUR | 9,66 % | 109 | 187 |
| Costuri achizitie teren | 52.500 EUR | 0,29 % | 3 | 6 |
| Total costuri teren | 1.802.500 EUR | 9,95 % | 113 | 193 |
| Constructie supraterana | 10.200.000 EUR | 56,31 % | 638 | 1.090 |
| Constructie subterana | 2.600.000 EUR | 14,35 % | 163 | 278 |
| Total hard costs | 12.800.000 EUR | 70,66 % | 800 | 1.368 |
| Design si inginerie | 768.000 EUR | 4,24 % | 48 | 82 |
| Autorizatii si taxe | 150.000 EUR | 0,83 % | 9 | 16 |
| Bransamente utilitati | 250.000 EUR | 1,38 % | 16 | 27 |
| Project management | 512.000 EUR | 2,83 % | 32 | 55 |
| Vanzari si marketing | 708.060 EUR | 3,91 % | 44 | 76 |
| Legal si administrativ | 100.000 EUR | 0,55 % | 6 | 11 |
| Overhead dezvoltator | 384.000 EUR | 2,12 % | 24 | 41 |
| Total soft costs | 2.872.060 EUR | 15,85 % | 180 | 307 |
| Contingency | 640.000 EUR | 3,53 % | 40 | 68 |
| Cost total dezvoltare (TDC) | 18.114.560 EUR | 100,00 % | 1.132 | 1.935 |
| Venit rezidential | 20.592.000 EUR | 113,68 % | 1.287 | 2.200 |
| Venit parcari | 2.400.000 EUR | 13,25 % | 150 | 256 |
| Venit comercial | 360.000 EUR | 1,99 % | 23 | 38 |
| Venit boxe | 250.000 EUR | 1,38 % | 16 | 27 |
| Total GDV | 23.602.000 EUR | 130,29 % | 1.475 | 2.522 |
| Profit brut | 5.487.440 EUR | 30,29 % | 343 | 586 |
Cash flow table
Primele trimestre relevante pentru executie
| Q | Venit | Cost | CF unlevered | CF levered | Unitati vandute | Sold credit |
|---|---|---|---|---|---|---|
| Q1 | 0 EUR | -2.100.382 EUR | -2.100.382 EUR | -2.100.382 EUR | 0 | 0 EUR |
| Q2 | 0 EUR | -297.882 EUR | -297.882 EUR | -297.882 EUR | 0 | 0 EUR |
| Q3 | 0 EUR | -297.882 EUR | -297.882 EUR | -297.882 EUR | 0 | 0 EUR |
| Q4 | 0 EUR | -297.882 EUR | -297.882 EUR | -297.882 EUR | 0 | 0 EUR |
| Q5 | 0 EUR | -901.882 EUR | -901.882 EUR | -469.957 EUR | 0 | 520.000 EUR |
| Q6 | 0 EUR | -901.882 EUR | -901.882 EUR | -396.507 EUR | 0 | 1.040.000 EUR |
| Q7 | 643.500 EUR | -921.187 EUR | -277.687 EUR | 217.938 EUR | 18 | 1.560.000 EUR |
| Q8 | 643.500 EUR | -921.187 EUR | -277.687 EUR | 208.188 EUR | 18 | 2.080.000 EUR |
| Q9 | 643.500 EUR | -1.817.187 EUR | -1.173.687 EUR | -182.437 EUR | 18 | 3.120.000 EUR |
| Q10 | 643.500 EUR | -1.817.187 EUR | -1.173.687 EUR | -201.937 EUR | 18 | 4.160.000 EUR |
| Q11 | 643.500 EUR | -1.817.187 EUR | -1.173.687 EUR | -221.437 EUR | 18 | 5.200.000 EUR |
| Q12 | 643.500 EUR | -1.817.187 EUR | -1.173.687 EUR | -240.937 EUR | 18 | 6.240.000 EUR |
| Q13 | 9.870.500 EUR | -1.197.997 EUR | 8.672.503 EUR | 2.889.128 EUR | 18 | 520.000 EUR |
| Q14 | 643.500 EUR | -921.187 EUR | -277.687 EUR | 227.688 EUR | 18 | 1.040.000 EUR |
| Q15 | 0 EUR | -901.882 EUR | -901.882 EUR | -406.257 EUR | 0 | 1.560.000 EUR |
| Q16 | 0 EUR | -901.882 EUR | -901.882 EUR | -416.007 EUR | 0 | 2.080.000 EUR |
| Q17 | 9.227.000 EUR | -282.692 EUR | 8.944.308 EUR | 6.844.808 EUR | 0 | 0 EUR |
| Q18 | 0 EUR | 0 EUR | 0 EUR | 0 EUR | 0 | 0 EUR |
| Q19 | 0 EUR | 0 EUR | 0 EUR | 0 EUR | 0 | 0 EUR |
| Q20 | 0 EUR | 0 EUR | 0 EUR | 0 EUR | 0 | 0 EUR |