Pro-forma Lite — Residual Land Value

Project / Bulk

Project (optional)

Site Area (m²)

FAR (gross)

Efficiency (Net/Gross, %)

Override Net/GLA (m²)

Revenue

Revenue Mode

—

Rent (ZAR/m²/mo)

Vacancy (%)

Opex (% of EGI)

Cap Rate (%/yr)

Costs & Finance

Hard Cost (ZAR/m² gross)

Soft % of Hard

Prof Fees % of Hard

Contingency %

Construction Period (mo)

Finance Rate (%/yr)

Loan-to-Cost (LTC, %)

Finance Fee (% of loan)

Include land in interest calc (approx.)

VAT, Duties & Developer’s Tax

Conservative toggles — treat as leakages to cash flows (simplified).

Apply VAT

VAT Rate (%)

Transfer Duty (%)

Apply Developer’s Tax

Dev Tax Rate (% of profit)

Leasing, Exit & Discounting

Stabilisation (mo)

Rent-free (mo)

Analysis Horizon (mo)

Exit Cap Rate (%/yr)

Include Exit Sale at Horizon (rent mode)

Discount Rate (%/yr)

—

GDV / Value (ZAR)

—

Dev Cost excl Land (ZAR)

—

Residual Land Value (ZAR)

—

NPV @ Disc. Rate

—

Project IRR (p.a.)

Detail

Cash flow and tax/VAT are simplified for early feasibility (conservative). Confirm with advisors.

Quick Scenarios (Residual per m² of Site)

Cap Rate ±

Cap %	R/m²

Rent/Sales ±

Rate	R/m²

Hard Cost ±

Hard ZAR/m²	R/m²

Sensitivity increments are auto-selected around your inputs. Export CSV for deeper analysis.

Cash Flow Preview

Month	Inflow	Outflow	Net	Loan	Notes

Shows the first and last 6 months. Use Export Cash Flow CSV for the full schedule.