ROI(i)
19.51%
IRR(i)
10.99%
Buildable Levels(i)
7
Net Profit(i)
$7,103,569
Sale Price per m2(i)
$49,000
Break-even Price(i)
$41,000/m2
Scenario ROI Comparison
Cost Breakdown (base)
Unit Mix (base)
| Unit Type | Qty | Size (m2) | Sale Area |
|---|---|---|---|
| 180 m2 | |||
| 372 m2 | |||
| 336 m2 |
Cashflow & IRR (base)
Negative values are outflows; positive values are inflows. Edit staged percentages below.
| Period | Outflow % | Inflow % | Net Cashflow (MXN) |
|---|---|---|---|
| -$7,281,686 | |||
| -$9,102,108 | |||
| -$4,750,908 | |||
| $10,123,114 | |||
| $18,115,157 | |||
| Totals | 100% | 100% | Auto-normalized in model |
| IRR | 10.99% | ||
| Period | Cashflow (MXN) |
|---|---|
| Month 0 | -$7,281,686 |
| Month 4 | -$9,102,108 |
| Month 8 | -$4,750,908 |
| Month 12 | $10,123,114 |
| Month 16 | $18,115,157 |
| IRR | 10.99% |
Scenario Comparison
| Metric | Conservative | Base | Optimistic |
|---|---|---|---|
| Total Investment | $36,665,943 | $36,408,431 | $36,150,918 |
| Net Profit | $2,406,057 | $7,103,569 | $11,801,082 |
| Buildable Levels | 7 | 7 | 7 |
| ROI | 6.56% | 19.51% | 32.64% |
Calculation Summary (base)
Inputs, coefficients, and final outputs shown in full for auditability.
| Type | Label | Formula | Value |
|---|---|---|---|
| input | Lot Size (m2) | direct input | 221 |
| input | COS | direct input | 0.8 |
| input | CUS | direct input | 4.8 |
| input | Sale Price per m2 | scenario input | 49,000 |
| input | Parking Area (m2) | scenario input | 165 |
| calc | Max Footprint | lotSize * cos | 176.8 |
| calc | Max Construction | lotSize * cus | 1,060.8 |
| calc | Posterior Restriction Area | lotWidth * posteriorDepth | 36 |
| calc | Usable Footprint | (lotSize * cos) - (lotWidth * posteriorDepth) | 140.8 |
| calc | Max Levels by CUS | (lotSize * cus) / usableFootprint | 7.53 |
| calc | Buildable Levels (floor) | floor(maxLevelsByCUS) | 7 |
| calc | CUS Check Area | grossConstructionArea - parkingArea | 1,047.84 |
| calc | Hard Cost | grossConstructionArea * constructionCostPerM2 | 18,192,600 |
| calc | Soft Cost Total | sum(softCostItems) | 7,100,000 |
| calc | Imprevistos y seguridad | hardCost * contingencyPct | 909,630 |
| calc | Base Cost Before Finance | landCost + hardCost + softCost + contingency | 33,402,230 |
| calc | Financing Cost | baseBeforeFinance * financingPct | 3,006,200.7 |
| calc | Gross Revenue | unitSaleArea * salePricePerM2 | 43,512,000 |
| calc | Total Investment | baseBeforeFinance + financingCost | 36,408,430.7 |
| calc | Net Profit | grossRevenue - totalInvestment | 7,103,569.3 |
| calc | ROI | (netProfit / totalInvestment) * 100 | 19.51 |
| calc | Project IRR (annualized approximation) | IRR(cashflow[0..4]) | 10.99 |
| calc | Break-even Sale Price | totalInvestment / unitSaleArea | 41,000.49 |
| cashflow | Period 0 | staged inflow/outflow distribution | -7,281,686.14 |
| cashflow | Period 1 | staged inflow/outflow distribution | -9,102,107.68 |
| cashflow | Period 2 | staged inflow/outflow distribution | -4,750,907.68 |
| cashflow | Period 3 | staged inflow/outflow distribution | 10,123,113.86 |
| cashflow | Period 4 | staged inflow/outflow distribution | 18,115,156.93 |