A real estate financial model connects a property’s purchase, rent, operating costs, financing and eventual sale to its cash flows. It helps you test how a change in occupancy, costs, borrowing or exit assumptions affects the result.
Begin with the property and the decision. An existing rental building, a development project and a real estate investment trust need different models. This guide uses a simplified rental-property example to explain the core calculations.
Set the scope and collect the inputs
- Acquisition: price, closing costs, initial works and timing.
- Income: units or area, rent, lease terms, vacancy, collection loss and other income.
- Operating costs: management, maintenance, insurance, property taxes and other recurring costs.
- Investment: capital works, leasing costs and reserves, with their timing identified.
- Debt: borrowing, rate, payment structure, fees, maturity and repayment.
- Exit: sale timing, valuation method, selling costs and debt payoff.
Record the source and date for every material assumption. A vacancy allowance is an assumption about lost occupancy or income, not a statement that tenants can leave regardless of the lease. Inspect actual lease terms separately.
A fictional one-year property example
All amounts use the same currency. The figures are teaching assumptions, not market rents, financing terms or a recommended investment. This example has no growth, no additional capital works or leasing costs during the year, and no taxes.
| Item | Calculation | Amount |
|---|---|---|
| Purchase price | Input | 1,000,000 |
| Acquisition costs | Input | 50,000 |
| Initial total cost | 1,000,000 + 50,000 | 1,050,000 |
| Annual potential rent | Input | 120,000 |
| Vacancy and collection allowance | 5% × 120,000 | (6,000) |
| Effective rental income | 120,000 − 6,000 | 114,000 |
| Operating expenses | Input | (44,000) |
| Net operating income in this example | 114,000 − 44,000 | 70,000 |
Net operating income (NOI) is a property operating measure before financing and income taxes. Make your treatment of reserves explicit. Underwriting conventions can differ, and some deduct replacement reserves within their NOI measure. This teaching case assumes no such reserve and no capital spending; a real forecast must investigate both.
Add financing without mixing it into NOI
Assume an initial loan of 600,000 with annual interest of 6%, interest-only for the one-year holding period. Ignore loan fees. Annual interest is 36,000, so the simplified cash flow to equity before sale and tax is 70,000 − 36,000 = 34,000.
Initial equity is 1,050,000 − 600,000 = 450,000. The first-year cash-on-cash return in this simplified case is 34,000 ÷ 450,000 = 7.56%, rounded. It is not the property’s total return and does not include the sale.
If the loan amortizes, separate interest from principal repayment and reduce the loan balance accordingly. Do not use an interest-only formula for an amortizing facility. An amortization period and a loan maturity are also different: a loan can mature before it would fully amortize.
Calculate LTV and LTC correctly
Loan-to-value (LTV) = loan amount ÷ property value. With a property value of 1,000,000, the example’s LTV is 600,000 ÷ 1,000,000 = 60%.
Loan-to-cost (LTC) = loan amount ÷ defined project cost. Using the example’s total initial cost of 1,050,000, LTC is 57.14%, rounded. For a development, establish which land, construction and other costs the lender includes.
Neither ratio is itself a property value. When value and LTV are known, multiplying them gives the corresponding loan amount. Lender definitions, approved values and funding conditions must be checked rather than inferred from a ratio alone.
Model the sale and debt payoff
Assume the property is sold at the end of year one using a forward annual NOI of 70,000 and an exit capitalization rate of 7%. The simple capitalization estimate is 70,000 ÷ 7% = 1,000,000.
Assume selling costs of 2% of gross sale value, or 20,000. After repaying the interest-only loan principal of 600,000, sale proceeds to equity are 380,000. Add the year’s operating cash flow of 34,000: total year-end cash received by equity is 414,000.
Against an initial equity outflow of 450,000, the one-year return is 414,000 ÷ 450,000 − 1 = −8.00%. The operating cash-on-cash return was positive, yet the total result is negative because acquisition and sale costs matter. The equity multiple is 0.92× in this example.
For multiple periods or irregular payment dates, model each cash flow at its actual timing before calculating return measures. Do not annualize a multiple without accounting for the holding period.
Test the assumptions that can change the decision
- Vacancy: how does lower occupancy affect income and debt coverage?
- Costs: what happens if repairs or insurance exceed the base case?
- Capital works: when must cash be spent, and does that interrupt rent?
- Debt: does the rate reset, and what happens at maturity?
- Exit: how sensitive is value to the forward NOI and cap rate?
Holding forward NOI at 70,000, an 8% exit cap rate gives a gross sale estimate of 875,000. The higher cap rate reduces the value; it does not improve it. Use comparable evidence to choose assumptions, and test a range rather than presenting one exit price as certain.
Review the workbook
Check that acquisition funding equals acquisition uses, opening debt plus borrowing minus repayments equals closing debt, sale proceeds deduct the remaining loan once, and equity cash flows include the initial investment. Label annual and monthly periods clearly. Keep formulas consistent across the forecast.
A model does not make a property low risk or replace lease review, physical due diligence and examination of financing terms. It makes the assumed cash flows inspectable.
Practice and further reading
Rebuild the example, then change vacancy to 10% while keeping the operating expenses fixed at 44,000. Effective rental income becomes 108,000, NOI becomes 64,000 and pre-sale equity cash flow becomes 28,000.
For terminology and underwriting context, see the OCC Commercial Real Estate Lending handbook. For a learning sequence, follow the financial modeling study plan. The separate real estate private equity guide covers the career context.
