Real Estate Pro Forma FAQs

A real estate pro forma is a forward-looking model of a property's income, costs, financing and investor returns. It converts assumptions about rent, occupancy, operating expenses, capital expenditure and exit value into period-by-period cash flows. Buyers, developers and lenders use it to test whether a property can meet a particular underwriting case; it is not a guarantee of performance.

A typical operating build follows this chain:

1. gross potential rent;
2. less vacancy, concessions and credit loss;
3. plus parking, service and other property income;
4. less operating expenses; and
5. net operating income (NOI), followed by debt service, capital expenditure and tax where relevant.

For example, a property with £500,000 of gross potential rent, 6% vacancy, £20,000 of other income and £170,000 of operating expenses produces £320,000 of NOI:

£500,000 - £30,000 + £20,000 - £170,000 = £320,000

The pro forma should distinguish historical results from assumptions and show when leases begin, expire or reset. It should also include base, downside and upside cases for the variables that genuinely drive the asset: rent, occupancy, expense inflation, refurbishment cost, financing and exit cap rate. A model that starts with the required return and works backwards to optimistic assumptions is not a sound underwrite.

The real estate pro forma guide explains the full structure. For a working model, use the real estate pro forma template, or explore the broader real estate solution.

Pro forma NOI is the net operating income a property is expected to generate under a defined future scenario, usually after lease-up, rent changes or operational improvements. It is calculated before financing, income tax, depreciation and owner-level distributions so that the property's operations can be assessed independently of its capital structure.

The standard bridge is:

NOI = gross potential rent - vacancy and credit loss + other property income - operating expenses

Suppose a 20-unit property is underwritten at £1,500 monthly rent per unit. Gross potential rent is £360,000 a year. With 5% vacancy, £12,000 of ancillary income and £120,000 of operating expenses, pro forma NOI is:

Gross potential rent       £360,000
Less: vacancy              (18,000)
Plus: other income           12,000
Less: operating expenses  (120,000)
Pro forma NOI              £234,000

Operating expenses normally include property management, repairs, utilities paid by the owner, insurance and property taxes. They normally exclude mortgage payments, depreciation, income tax and major capital projects. Replacement reserves are treated differently across models, so state clearly whether they sit above or below NOI.

The word pro forma matters because £234,000 may not be the property's current earnings. It may assume market rents, stabilised occupancy or savings that have not yet been achieved. Show the timing and evidence for each adjustment rather than presenting one unexplained figure. The real estate pro forma template provides a structured income-to-NOI build, while the real estate pro forma guide discusses underwriting assumptions and checks.

To create a pro forma for a rental property, begin with the rent roll and lease terms, not a top-down revenue growth rate. Build monthly when leases, renovation timing or seasonality matter; an annual model may be sufficient for a small, stable property.

Include these modules:

• Rental income: units × monthly rent × occupied months, separated by unit type.
• Income deductions: physical vacancy, concessions, bad debt and loss-to-lease.
• Other income: parking, storage, laundry, service charges or fees.
• Operating costs: management, repairs, utilities, insurance, property taxes and recurring contracts.
• Capital and financing: refurbishment, replacement expenditure, loan drawdown, interest, amortisation and sale proceeds.

For a simple four-unit property at £1,250 per unit per month, gross potential rent is £60,000 a year. At 5% vacancy and £18,000 of operating costs, NOI is £39,000 before other income:

£60,000 × (1 - 5%) - £18,000 = £39,000

Do not stop at the base case. Test slower rent growth, a vacant unit lasting several months, unexpected repairs and refinancing at a higher rate. Keep one-off capital expenditure separate from recurring operating expenses, and reconcile total occupied units so occupancy cannot exceed available inventory.

The output should show NOI, cash flow after debt service, minimum cash, loan balances and any return measures relevant to the decision. Use the real estate pro forma template for a general property build or the multi-family pro forma where unit types and lease-up require more detail. Any assumptions should be replaced with property-specific evidence; this is an analytical framework, not investment advice.

A pro forma cap rate expresses expected stabilised NOI as a percentage of the property's value or purchase price. It is a forward-looking yield based on the pro forma operating case rather than current or trailing income.

Pro forma cap rate = pro forma annual NOI / property value

If a property is priced at £4.0 million and the model projects £240,000 of stabilised NOI, its pro forma cap rate is 6.0%. The same relationship can estimate value when a market cap rate is assumed:

Implied value = £240,000 / 6.0% = £4.0 million

The calculation is simple; the judgement sits in the inputs. Review whether the NOI assumes:

• achievable market rent and a credible lease-up period;
• normalised vacancy and bad debt;
• complete operating expenses at sustainable levels; and
• any replacement reserve required by the stated convention.

A seller may quote a high pro forma cap rate because the numerator assumes rent increases or cost savings that do not yet exist. Bridge current NOI to pro forma NOI line by line and show when each improvement takes effect. Also sensitise both NOI and the exit cap rate: a higher NOI can be offset by a softer valuation multiple.

Cap rate is not the same as cash-on-cash return or IRR. It excludes financing and does not capture the timing of capital expenditure, distributions or sale proceeds. Use it as one property-level valuation measure, not a complete investment conclusion. The real estate pro forma guide shows where the cap-rate calculation fits within an underwrite, and the real estate pro forma template links it to operating cash flow and value.

Pro forma rent is the rent assumed in a forward-looking property model. It may represent contractual rent after scheduled steps, market rent on renewal, or rent expected after refurbishment and lease-up. It should not be presented as current rent unless the leases already support it.

A useful rent schedule keeps three concepts separate:

Suppose 20 apartments currently average £1,400 per month while comparable evidence supports £1,500. Annual in-place rent is £336,000 and annual pro forma rent is £360,000, creating a £24,000 gross gap. The model should not recognise that uplift immediately. It should apply lease expiry dates, renewal probability, downtime, concessions and any renovation cost required to reach the higher rent.

For commercial property, also model rent-free periods, indexation, stepped rent, tenant improvements and leasing commissions. For hotels, rent is not the relevant driver; room revenue is normally built from occupancy and average daily rate.

Treat pro forma rent as an auditable assumption. Record the evidence, date and unit basis, and sensitise the result if comparable rents are sparse. Market rent is an estimate, not a signed cash flow. The multi-family pro forma is designed for unit-level rental assumptions, while the broader real estate pro forma template connects rent, vacancy and other income to NOI.

A real estate development pro forma models a project from land acquisition through design, construction, lease-up or sales, financing and exit. Unlike a stabilised property model, it must show the timing of costs and funding because a delay changes construction interest, equity needs, completion dates and returns simultaneously.

The main sections are:

• land, hard costs, soft costs, contingency and development fees;
• monthly construction spend and completion milestones;
• debt drawdowns, interest during construction and lender fees;
• leasing or unit-sales assumptions, incentives and commissions;
• stabilised income, operating costs and NOI; and
• refinance or sale proceeds, debt repayment and equity cash flow.

Consider a project with £10 million of total cost, financed by £7 million of debt and £3 million of equity. If stabilised NOI is £800,000 and the assumed exit cap rate is 6.25%, gross completed value is £12.8 million:

£800,000 / 6.25% = £12,800,000

That £2.8 million spread over cost is not automatically the developer's profit. Selling costs, financing fees, accrued interest, tax and any remaining debt must still be deducted. The monthly cash-flow schedule determines how much equity is required and when.

Test construction inflation, contingency use, delays, slower sales or lease-up, lower rents and a higher exit cap rate. Checks should confirm that sources equal uses, debt never exceeds its facility, units sold or leased do not exceed inventory, and the closing cash balance rolls correctly. The development pro forma provides the relevant structure; the real estate pro forma guide explains the stabilised operating logic that follows construction. Outputs remain scenario-dependent and should not be read as investment advice.

A hotel pro forma forecasts room demand, pricing, ancillary revenue, operating costs, capital expenditure and financing. Hotels behave more like operating businesses than conventional leased property, so revenue is driven by rooms sold rather than a fixed rent roll. Monthly modelling is usually important because occupancy and room rates can be highly seasonal.

The core room metrics are:

• Occupancy: rooms sold / rooms available.
• ADR: room revenue / rooms sold.
• RevPAR: room revenue / rooms available, or occupancy × ADR.

For a 100-room hotel operating 365 days at 70% occupancy and a £180 ADR:

Available room nights = 100 × 365 = 36,500
Rooms sold            = 36,500 × 70% = 25,550
Room revenue          = 25,550 × £180 = £4,599,000
RevPAR                 = 70% × £180 = £126

Add food and beverage, events, parking, spa and other revenue using their own operational drivers. Expenses should distinguish departmental costs from undistributed costs such as administration, sales, utilities and maintenance, followed by management fees, insurance, property taxes and any reserve convention. Show gross operating profit and NOI separately, because operators, owners and lenders may use different definitions.

Build ramp-up explicitly for a new or renovated hotel and test occupancy, ADR, labour cost, distribution commissions and refurbishment downtime. A high ADR does not help if occupancy falls enough to reduce RevPAR, and an apparently strong NOI can be misleading if recurring furniture, fixtures and equipment expenditure is omitted. The hotel pro forma provides a dedicated model structure. The general real estate pro forma guide is useful for valuation and financing context, but hotel operating assumptions require property- and market-specific evidence.

Current NOI measures the property's operating income today, usually from the latest rent roll, recent month or trailing 12-month accounts. Pro forma NOI estimates income under a stated future operating case. The two figures answer different questions: current NOI shows what exists; pro forma NOI shows what may exist if specific assumptions are achieved.

A clear underwrite bridges between them rather than replacing one with the other:

The £40,000 increase may be reasonable, but its timing matters. Rent uplift may require leases to expire; vacancy may require fit-out and leasing commissions; and cost savings may require capital expenditure. Model those cash effects and the stabilisation period instead of applying the full uplift on day one.

Current NOI can also require normalisation—for example, removing a genuinely non-recurring repair—but avoid relabelling ordinary costs as exceptional simply to increase value. Pro forma NOI should state whether it uses market rent, stabilised occupancy, post-renovation operations or another defined case.

When valuing the property, compare both current and pro forma cap rates and sensitise the time and cost needed to reach stabilisation. Lenders may rely on a more conservative underwritten NOI than either the buyer's or seller's case. The real estate pro forma template supports a transparent operating bridge, while the real estate pro forma guide explains how rent, vacancy, expenses and cap rates interact. These are scenario outputs, not assurances of future performance.