Commercial vacancy calculator: from isolated KPI to impact on NOI and cap rate
In Latin American commercial real estate, vacancy rate stopped being an anecdotal line in the quarterly committee to become the metric that moves asset valuation. Mexican FIBRAs, Chilean REITs, family offices with Class A and B office portfolios, developers with Class AAA towers in Polanco, Santa Fe, Las Condes or El Poblado, and CRE brokers from CBRE, JLL, Cushman & Wakefield and Newmark work with the same technical vocabulary: physical vacancy, economic vacancy, net absorption, effective rent, concessions, downtime, tenant improvement allowance and stabilized occupancy. A homebrew Excel or a property manager report that only reports physical occupancy hides the true profitability deterioration — which usually lives in economic vacancy.
A serious calculator solves the two foundational equations of CRE vacancy analysis:
Physical vacancy = (Vacant area / Total rentable area) × 100
Economic vacancy = (Potential rent − Collected rent) / Potential rent × 100
The difference between the two is where the asset's economic truth lives. A 40,000 m² Class A building in Insurgentes Sur Mexico City can report 18% physical vacancy — seemingly manageable — and at the same time 27% economic vacancy when you incorporate aggressive concessions: three months free on signing, TI allowance of 350 USD/m² amortized into effective rent, step-ups frozen the first 18 months and a 12% discount on market rent to close a strategic tenant. Economic vacancy is the metric that reconstructs real NOI and exposes what physical vacancy hides.
Numeric example: Mexico City office tower
Imagine a Class A tower of 40,000 m² in a premium CBD with market rent USD 38/m² monthly. Physical occupancy 82% (7,200 m² vacant), current tenants paying average effective rent of USD 32/m² due to carried concessions. Annualized monthly potential rent is:
PMR = 40,000 × 38 × 12 = USD 18.24M
Annual collected rent = 32,800 m² × 32 × 12 = USD 12.59M. Economic vacancy = (18.24M − 12.59M) / 18.24M = 31.0% — more than double the reported 18% physical vacancy. With NNN operating expenses of USD 10.6/m²/month (USD 5.1M annually), NOI falls to USD 7.5M against a potential of USD 13.2M. At a market cap rate of 8.5%, that USD 5.7M NOI gap means USD 67M of value destroyed vs the stabilized-occupancy scenario. That is the number the asset manager presents to the investment committee when asking for budget for a retenure program or an asset repositioning.
Net absorption, stabilized vacancy and lease-up period
Net absorption measures m² occupied minus m² vacated in a quarter — it is the market's directional indicator. When net absorption of Mexico City offices fell to 15,000 m² per quarter against a historical average of 80,000 m² (as happened in 2020-2021 due to remote work), the individual asset's vacancy analysis must be recalibrated against a stabilized vacancy of the submarket, not against the national benchmark. JLL and Solili publish stabilized vacancy by corridor (Reforma 16%, Insurgentes 13%, Polanco 11%, Santa Fe 22%, Interlomas 25%) and that is the real competitive reference.
The lease-up period — the months needed to go from current vacancy to stabilized vacancy — is the critical variable of the pro forma. A tower with 35% vacancy in a submarket with 12% stabilized typically needs 18-30 months of lease-up, depending on the corridor's historical absorption speed. During that period NOI is compressed, and any refinancing must be modeled with DSCR under stressed NOI, not under stabilized NOI.
Gross lease, NNN and the impact of CAM charges
In LatAm, leasing schemes with naming conventions that confuse modeling coexist. The gross lease charges operating cost (maintenance, security, property tax, insurance, common-area energy) to the owner, who incorporates it into base rent. The NNN (triple net) passes to the tenant the property tax, insurance and maintenance of their area, typically expressed as CAM charges (common area maintenance) at 15%-28% on base rent by location and class. Modified gross is the intermediate practice: the owner covers the base year, the tenant absorbs annual increases over the base year.
To compute economic vacancy correctly, collected rent must be normalized to the contract scheme. An anchor tenant with NNN and base rent USD 31/m² generates cash flow equivalent to a gross lease of roughly USD 40/m² once reasonable CAM charges are added. Comparing apples to oranges — charging NNN and subtracting concessions calculated on a gross lease — is the most common mistake in improvised models.
TI allowance, free rent and concessions under GAAP/IFRS 16
A Class A office broker in Miami or Mexico City closes a 5-year contract with three months of free rent, TI allowance of 75 USD/sq ft (807 USD/m²) for fit-out and base rent stepped 3% annually. The effective rent calculation amortizes concessions over the contract term:
Effective rent = (Total rent over the period − Total concessions) / Total months
Under IFRS 16 and ASC 842, the landlord recognizes rent on a straight-line basis: income is smoothed across the term, generating a deferred asset during the concession phase that reverses at contract end. This is neutral for the aggregate income statement but distorts operating NOI between year one vs year five if not reconciled. Mexican FIBRAs report NOI with separate straight-line adjustments precisely for this reason, and the SEC requires explicit disclosure by REITs listed on NYSE and NASDAQ.
Vacancy by asset class and submarket
There is no single stabilized vacancy; each asset type and submarket has its own benchmark. Class A offices in CBD typically stabilize at 8%-12%; Class B in a secondary corridor at 12%-18%; Class C and mature submarkets can have structural vacancy of 20%-30% without implying value destruction, as long as prices reflect the submarket. Supermarket-anchored retail strip centers stabilize at 5%-8%; unanchored secondary retail at 12%-18%; regional mall retail in secondary post-pandemic cities at 18%-25%. Class A industrial/warehouse in logistics hubs (Monterrey, Guadalajara-El Salto, Tijuana-San Diego border, Bogotá-Funza) stabilize at 3%-6% — the most defensive assets of the 2024-2026 cycle.
Downtime, turnover and the economics of rotation
Downtime between tenants — the vacant months between departure and next occupancy — is the variable most underestimated by owners who only watch current occupancy. A commercial unit with 3 months of downtime between 3-year contracts has effective occupancy of 91.7%, even if at a cutoff date it shows 100% occupancy. Added to TI allowance for the new tenant's fit-out and broker commission (typical 4%-8% of total contract value), each rotation can cost between 12-20 months of gross rent. Retaining an existing tenant with an 8% concession on renewal rent almost always dominates financially over placing a new one.
Cap rate, NOI impact and income-approach valuation
The bridge between vacancy and asset value is income capitalization valuation:
Value = Stabilized NOI / Cap rate
A tower with USD 13M stabilized NOI at an 8.5% cap rate is worth USD 153M. If the real economic vacancy reduces sustainable NOI to USD 9.4M, value falls to USD 110.6M — USD 42M less. Professional appraisers (ASA, MAI) additionally apply a lease-up reserve adjustment to as-is value for assets that are not stabilized: they discount projected stressed-NOI months before reaching stabilized occupancy. A calculator that only reports physical vacancy omits this adjustment and systematically overvalues the asset.
Re-leasing pro forma and scenario sensitivity
A serious pro forma models three scenarios: base (current vacancy holds 12 months before being absorbed), upside (aggressive retenure program absorbs 50% of the gap in 9 months), downside (loss of anchor tenant opens 25% additional area). Each scenario impacts NOI, DSCR and valuation. The calculator generates the three scenarios in parallel with inputs editable by the asset manager. This is exactly what CBRE Valuation Advisory, JLL Capital Markets, Cushman Valuation and Newmark Valuation deliver in a 40-page report that costs 15,000-40,000 USD; the tool solves it in 15 minutes with inputs the asset administrator already knows.
Differentiation vs Excel and the property manager's sheet
Excel computes physical vacancy with a division. It does not model concessions amortized under straight-line, does not distinguish gross lease from NNN, does not project lease-up with the submarket's stabilized vacancy, and does not connect economic vacancy to NOI and cap rate in a single view. The property manager's operating report reports physical occupancy, not adjusted profitability. The calculator closes both gaps: it turns the operational KPI into an input of the financial model the investment committee and the creditor bank actually need.
For the asset manager of a FIBRA, the portfolio manager of a family office, the CRE broker preparing an opinion of value, or the owner of a multi-tenant tower evaluating refinancing, the tool connects two worlds that usually live apart: the administrator's daily occupancy report and the valuation model that decides the capital strategy.
Conclusion
The difference between a CRE portfolio that defends its value through the cycle and one that destroys it silently is the rigor with which economic vacancy — not physical — is measured, reported and acted on. Class A assets in premium LatAm submarkets are being repositioned with aggressive concessions to sustain apparent physical occupancy while real economic vacancy spikes. The asset manager who presents NOI adjusted for straight-line concessions, submarket net absorption, projected downtime and cap-rate sensitivity is no longer an operator; they are an institutional capital manager. The next time the committee asks "how much is the asset really worth if remote work stays at 30%?", the answer must be in the tool, not in the three-year-old Excel.