Real Estate Finance

How to Build a Real Estate Pro Forma

A real estate pro forma is a forward looking projection of a property's income, expenses and cash flow. It starts with gross potential rent from the rent roll, subtracts vacancy and credit loss, adds other income, deducts operating expenses to reach net operating income, then layers in reserves, capital costs and debt service to show cash available to owners.

What is a real estate pro forma used for?

A pro forma translates a property's leases, market rents and operating costs into a projection of cash flow over a hold period, usually five to ten years. Buyers use it to set a purchase price and estimate returns, lenders use it to size debt and test coverage, and asset managers use it as a budget against which actual results are measured. A good pro forma is not a sales document. It should reconcile to the property's trailing twelve month operating statement and current rent roll, and every change from history should be supported by a specific, documented assumption such as a signed lease, a scheduled renovation or a verified market rent comparison.

The pro forma also forces discipline on the business plan. If the plan calls for raising rents after renovating units, the model should show the cost and timing of each renovation, the downtime while units are offline, and the rent premium supported by comparable renovated units nearby. Assumptions that cannot be tied to evidence belong in an upside case, not the base case that drives the purchase price or loan amount. Labeling each assumption as historical, contractual or projected makes the model far easier for a lender or investment committee to audit.

How do you build revenue from the rent roll?

Revenue begins with gross potential rent, the income the property would earn if every unit or suite were leased at its contract rent or, for vacant space, at market rent. For multifamily, the analyst totals in place rents and applies a growth assumption at lease turnover. For commercial property, each lease is modeled separately with its contractual rent steps, expiration date, renewal probability, downtime, free rent and leasing costs if the tenant leaves. This lease by lease approach matters because a single large tenant expiration can dominate the cash flow in a given year.

From gross potential rent, the analyst deducts loss to lease, which is the gap between contract rents and market rents, concessions, and vacancy and credit loss. Vacancy should reflect both the physical vacancy expected for the property and the market, plus a credit loss allowance for tenants who occupy space but do not pay. Other income such as parking, storage, utility reimbursements, laundry and fees is then added to reach effective gross income. Vacancy for a stabilized asset should never be modeled at zero, because even well leased buildings experience turnover gaps, collection problems and units held offline for repairs.

Which operating expenses belong in the pro forma?

Operating expenses include real estate taxes, insurance, utilities, repairs and maintenance, payroll, contract services, marketing, administrative costs and property management fees. Each line should start from the trailing twelve months, then be adjusted for known changes. Real estate taxes deserve special care because a sale often triggers reassessment, so the buyer's tax bill can be far above the seller's. Insurance has also become a volatile line in many markets and should be quoted rather than inflated from history. Utility costs should be checked against meter data where available, since recent rate changes often lag in historical statements.

Management fees are usually modeled as a percentage of effective gross income, so they rise and fall with revenue. Expenses that the seller managed informally, such as an owner who did not charge a management fee or handled maintenance personally, must be normalized to what a third party would cost. The operating expense ratio, expenses divided by effective gross income, is a useful cross check against comparable properties, but it should never be used as the primary method of projecting expenses.

• Fixed or semi fixed: taxes, insurance, payroll, contract services
• Variable: utilities, repairs, turnover costs, marketing
• Percentage based: management fee as a share of effective gross income
• Below the line: replacement reserves, tenant improvements, leasing commissions, capital projects

How do you get from NOI to cash flow?

Net operating income is effective gross income minus operating expenses. It excludes debt service, depreciation, income taxes and capital expenditures, which makes it the standard measure of a property's unlevered earning power and the basis for cap rate valuation. Below NOI, the pro forma deducts replacement reserves, tenant improvements, leasing commissions and capital projects to arrive at cash flow before debt service. Then it subtracts interest and principal to show levered cash flow to equity. Each layer answers a different question: NOI measures the property, cash flow before debt service measures the investment, and levered cash flow measures the equity position.

Where items sit relative to NOI matters because lenders and appraisers capitalize NOI. Moving a recurring cost such as unit turnover below the line inflates NOI and therefore value. Many lenders underwrite to net cash flow after a standardized reserve so that properties are compared on a consistent basis. The analyst should state clearly which convention the model uses and apply it consistently to the purchase price, loan sizing and exit valuation. When comparing a seller's offering memorandum to an internal model, the first reconciliation step is usually to align these definitions before debating any individual assumption.

How should growth and exit assumptions be set?

Rent growth, expense growth and the exit cap rate drive most of the return in a typical pro forma, so they deserve the most scrutiny. Rent growth should reflect submarket supply, demand and affordability rather than a long run average applied by default. Expenses should generally grow at least as fast as inflation, and taxes may step up at sale or reassessment. A common error is projecting rents growing faster than expenses every year, which steadily widens margins in a way few real properties achieve.

The exit value is typically calculated by capitalizing the following year's NOI at an exit cap rate, less selling costs. Many analysts set the exit cap rate above the going in rate to reflect an older building and uncertainty about future markets. The model should show how sensitive returns are to that assumption, because a small change in the exit cap rate often moves the internal rate of return more than years of operating improvements. A one quarter point change in exit cap rate is a reasonable minimum stress, and many committees ask to see a full grid of exit cap rates against rent growth.

What are the most common pro forma mistakes?

The most frequent problems are optimism stacked across many assumptions, each individually defensible but collectively unrealistic. Examples include market rents taken from the best comparable rather than the median, vacancy set below the submarket average, expenses frozen at the seller's understated levels, renovation premiums achieved immediately, and an exit cap rate equal to or below today's rate. Mechanical errors also creep in: rent steps that ignore lease terms, reimbursements calculated on the wrong expense pool, and reserves omitted entirely. A disciplined reviewer reconciles year one to the trailing twelve months, explains every variance, and runs a downside case with flat rents and higher vacancy.

Building year one NOI for a 100 unit apartment property

1. Gross potential rent: 100 units x $1,500 per month x 12 = $1,800,000.
2. Vacancy and credit loss at 6%: $1,800,000 x 0.06 = $108,000.
3. Other income from parking, storage and fees: $60,000. Effective gross income = $1,800,000 - $108,000 + $60,000 = $1,752,000.
4. Operating expenses including taxes, insurance, payroll, repairs and a management fee total $700,000. NOI = $1,752,000 - $700,000 = $1,052,000. The operating expense ratio is $700,000 / $1,752,000 = 40.0%.
5. Replacement reserves at $300 per unit: 100 x $300 = $30,000. Cash flow before debt service = $1,052,000 - $30,000 = $1,022,000.

How underwriters apply this

• Reconcile year one of the pro forma to the trailing twelve months and current rent roll line by line.
• Reassess real estate taxes for the new purchase price and requote insurance rather than inflating history.
• Underwrite to net cash flow after reserves so properties are compared on a consistent basis.
• Model commercial leases individually with renewal probability, downtime and leasing costs.
• Keep rent growth and expense growth assumptions consistent with each other and with the submarket.
• Show return sensitivity to the exit cap rate, vacancy and rent growth in every investment package.

Frequently asked questions

Keep reading

Educational content written by practitioners. Not investment, accounting, legal or tax advice.