Real Estate Pro Forma: What It Is and How to Build One
A real estate pro forma projects a property's income, expenses and cash flow. Here is the line-by-line structure and how to build one that holds up.
Key takeaways
- A pro forma projects income, expenses and cash flow from gross potential rent down to cash flow after debt service.
- Always show in-place and stabilised figures separately, with each change as a dated event.
- A pro forma gives you net operating income; a full model adds price, debt, exit and returns.
A real estate pro forma is a projection of a property's income, expenses and cash flow over a holding period, typically five to ten years. It is the operating core of any property analysis: before anyone can discuss returns, someone has to show what the building is expected to earn and what it costs to run.
The standard pro forma structure
An operating pro forma runs from the top line down to cash flow in a fixed order.
- Gross potential rent: every unit or lease at its contracted or market rent.
- Vacancy and credit loss: the income you do not expect to collect.
- Other income: parking, storage, service charge recoveries and similar items.
- Effective gross income: the sum of the lines above.
- Operating expenses: taxes, insurance, utilities, repairs, management and payroll.
- Net operating income: effective gross income less operating expenses.
- Capital expenditure, leasing costs and reserves.
- Debt service, leaving cash flow to equity.
In-place versus stabilised
A pro forma should show both what the property earns today and what it is expected to earn once the business plan is complete. Blurring the two is the most common way a projection becomes misleading. Start from the actual rent roll and trailing expenses, then show each change - a lease expiry, a renovation, a rent step - as a dated event rather than an immediate jump to the stabilised figure.
How to build one that holds up
Build revenue lease by lease or unit type by unit type, with start dates, expiry dates, rent steps and downtime on re-letting. Grow expenses line by line, because property taxes, insurance and payroll rarely move together. Keep growth rates, vacancy and cap rates on one assumptions sheet so a reviewer can find and change them. Then reconcile year one back to the trailing actuals and explain every difference.
Operating pro forma versus development pro forma
An operating pro forma describes an existing building. A development pro forma describes a project that does not exist yet, so it is driven by the construction programme, the cost plan and the sales or lease-up period, usually on a monthly basis. We cover that in how to build a development pro forma lenders can review.
From pro forma to full model
The pro forma tells you net operating income. It does not tell you whether to buy. For that you need the purchase price, the debt, the exit and the resulting returns, which is what an acquisition model adds on top.
Frequently asked questions
How many years should a real estate pro forma cover?
Five to ten years is typical for an investment property, with one extra year so the exit value can be based on the following year's net operating income. Development pro formas usually run monthly through construction and sales or lease-up.
Is capital expenditure included in net operating income?
No. Net operating income is calculated before capital expenditure, leasing costs and debt service. Some analysts deduct a recurring reserve above the line, so always check which convention a pro forma uses.
What is the difference between a pro forma and actuals?
Actuals are what the property really collected and spent, usually shown as trailing twelve months. A pro forma is a forecast. A credible pro forma reconciles its first year back to the actuals and explains each difference.