What is a pro forma in real estate?

A pro forma is a forward-looking cash flow projection for a property — what the asset is expected to produce, not what it currently produces. It starts with gross potential rent at market, deducts vacancy and collection loss, adds other income, subtracts operating expenses to arrive at NOI, then layers in debt service, capital reserves, and an exit value to produce levered cash flows and return metrics. In institutional deals, the pro forma is the financial spine of the investment thesis — every assumption in it gets stress-tested by investment committee, lenders, and appraisers.

How do you calculate a real estate pro forma?

Start with gross potential rent (units or SF times market rent, annualized), subtract vacancy and credit loss (typically 5% to 10% for stabilized multifamily, higher for office in 2026), add other income (parking, laundry, RUBS, late fees), and you have effective gross income (EGI). Subtract operating expenses — property taxes, insurance, utilities, repairs, payroll, management fee, G&A — and the result is NOI. Subtract debt service for levered cash flow, then subtract capex reserves. For multi-year pro formas, grow revenue and expenses at stabilized rates and calculate an exit value by dividing the year-N+1 NOI by an exit cap rate.

What is the difference between pro forma and actual in real estate?

Actuals are what the property produced last year — the T-12 operating statement. Pro forma is what the property is projected to produce going forward, adjusted for your business plan (rent growth, renovation premiums, lease-up, expense efficiencies). The gap between actual and pro forma is where most deals are won or lost. A seller's pro forma almost always assumes faster rent growth, lower vacancy, and tighter expenses than the actuals support — sophisticated buyers underwrite the gap, not the number.

What is a pro forma cap rate?

The pro forma cap rate is the capitalization rate implied by projected NOI rather than in-place NOI. Pro forma cap = Pro forma NOI divided by purchase price. It is almost always higher than the in-place cap rate because the pro forma assumes a stabilized, post-business-plan NOI. It is also the most manipulated number in a marketing package. When a broker leads with a 7.5% pro forma cap but the T-12 cap is 4.8%, the deal lives or dies on whether that 270-basis-point gap is achievable.

What line items should a real estate pro forma include?

Revenue: gross potential rent, vacancy and collection loss, concessions, other income (parking, RUBS, laundry, late fees, pet fees), effective gross income. Expenses: real estate taxes, insurance, utilities, repairs and maintenance, payroll, contract services, marketing, administrative, management fee, replacement reserves. Below the line: NOI, debt service (interest plus principal), unlevered cash flow, levered cash flow, capex (non-recurring), exit value via reversion cap rate. Year-1 should match the T-12 plus your adjustments; years 2 to 10 apply growth assumptions.

Why are real estate pro formas usually wrong?

Three reasons. First, they assume a linear path — rents grow every year, vacancy stays flat, expenses inflate at 2.5%. Reality is lumpy and asymmetric. Second, they under-reserve for capex, deferred maintenance, and re-tenanting costs that the T-12 doesn't show. Third, they rarely stress-test the exit — a 25-basis-point cap rate expansion at sale can erase two years of NOI growth. A good analyst runs at least three scenarios (base, downside, bear) and underwrites to the downside.

Real Estate Pro Forma: Structure, Example, and Common Mistakes

The pro forma is where deals are won, lost, and lied about

Every institutional real estate deal runs on a pro forma. It is the spreadsheet the broker sends with the marketing package. It is the file the buyer’s analyst rebuilds from scratch during diligence. It is the exhibit stapled to the IC memo and the appendix in the lender’s credit submission. A pro forma is not a forecast so much as a negotiation — a structured argument about what a property will produce, built line by line from assumptions that are each individually defensible and collectively optimistic.

What a pro forma actually is

A real estate pro forma is a forward-looking statement of projected cash flows for a property. The name is Latin for “as a matter of form”: a formal projection of what the asset should produce, distinct from what it has produced or currently produces.

That distinction matters more than it sounds. There are three documents that get confused constantly:

Document	Time orientation	Purpose
T-12 operating statement	Backward-looking	Actuals for the trailing twelve months
Pro forma	Forward-looking (year 1, often 10-year hold)	Projected cash flows under a business plan
DCF model	Forward-looking with explicit discount rate	Values future cash flows at present, produces IRR/NPV

A pro forma is the input. A DCF is the valuation engine that consumes the pro forma and produces an unlevered IRR, levered IRR, equity multiple, NPV, and price sensitivity. A stabilized operating statement is a snapshot of a single year (usually year 3 or 5) pulled from the pro forma to present a “normalized” NOI. All three coexist in the same underwriting workbook. Not all three are the pro forma.

In practice, “pro forma” most often refers to either the year-1 pro forma (next-twelve-months projection) or the multi-year pro forma (usually 10 years plus a reversion year). Both follow the same structure; the multi-year version just applies growth rates forward.

The line items every institutional pro forma contains

Whether the asset is a 300-unit apartment complex, a 120,000 SF office building, or a single rental house, the skeleton of the pro forma looks the same. The categories below are the institutional standard.

Revenue

Gross potential rent (GPR): what the property would produce at 100% occupancy at market rents. For multifamily, units × monthly market rent × 12. For commercial, leased SF × market rent PSF plus any vacant SF at market.
Vacancy & collection loss: haircut for economic vacancy. Multifamily stabilized: 5% to 7%. Office in 2026: 12% to 25% depending on market. Industrial: 3% to 5%. Retail: 5% to 10%.
Concessions: free rent, moving allowances, TI amortization. Shown as a negative against GPR.
Other income: parking, RUBS (ratio utility billing system) reimbursements, pet fees, laundry, late fees, storage, application fees, and in commercial, expense reimbursements from NNN or modified gross tenants.
Effective gross income (EGI): GPR minus vacancy and concessions plus other income. This is the top-line number the rest of the model flows from.

Operating expenses

Real estate taxes: often the single largest line item. Critical to reassess based on the purchase price, not the seller’s basis. Georgia’s 299C freeze, California’s Proposition 13, and Texas’s valuation dynamics each create buyer-specific tax profiles.
Insurance: has doubled or tripled in coastal markets between 2021 and 2026. Underwrite current market quotes, not the seller’s legacy policy.
Utilities: common area utilities; in multifamily, this is net of RUBS recovery.
Repairs & maintenance: ongoing operating repairs, distinct from capex.
Payroll: on-site staff for multifamily and office. Usually $600 to $1,200 per unit per year for managed multifamily.
Contract services: landscaping, pest control, trash, elevator.
Marketing: listings, turns, referral fees. Multifamily: 1% to 2% of EGI.
General & administrative: office supplies, legal, accounting, background checks.
Management fee: typically 3% to 4% of EGI for multifamily, 2% to 3% for commercial.
Total operating expenses: the sum. Expressed as an expense ratio (OpEx / EGI). Institutional multifamily runs 40% to 50%, office 35% to 45%, industrial 20% to 30%.

Below the NOI line

Net operating income (NOI): EGI minus operating expenses. The number that gets capitalized into value.
Capital expenditure reserves: recurring replacements (roofs, HVAC, flooring). Multifamily: $250 to $400 per unit per year. Often below the NOI line for the lender’s debt coverage but above the line for the equity investor’s cash flow.
Debt service: interest plus principal. For interest-only loans, just interest. Critical input for levered returns.
Unlevered cash flow: NOI minus capex. The return stream for an all-cash buyer.
Levered cash flow: NOI minus debt service minus capex. The return stream for the equity investor.
Exit value (reversion): year N+1 NOI divided by exit cap rate, minus selling costs (typically 2% to 3%).

That is the vocabulary. Every institutional pro forma (CBRE, Eastdil, JLL, Newmark, an IC memo at Blackstone) uses this structure. What varies is the granularity of the line items and the aggressiveness of the assumptions.

Acquisition vs. development vs. rental property pro formas

The skeleton is constant; the emphasis shifts based on what the pro forma is for.

Acquisition pro forma

Starts from an existing T-12 and rent roll. The analyst’s job is to reconcile the actuals to a forward year 1: adjusting for real-estate-tax reassessment, insurance mark-to-market, management fee normalization, below-market leases rolling to market, and any one-time items in the T-12 that shouldn’t recur. Year 1 pro forma NOI is the defensible anchor. Years 2 to 10 layer in rent growth, expense inflation, and any value-add assumptions (renovation, re-tenanting, lease-up).

The hard work in acquisition pro formas is not the forward projection. It is the reconciliation of the seller’s numbers to something you can defend in a lender call.

Development pro forma

No existing cash flow: you are building it from nothing. The structure has two phases: a construction period (usually 18 to 36 months) with no revenue and a rolling stack of hard costs, soft costs, contingency, and capitalized interest, and a stabilization period after certificate of occupancy during which lease-up occurs over 12 to 24 months until physical occupancy hits underwritten stabilized levels. Key differences from an acquisition pro forma:

Sources & uses table up front: how the capital stack funds construction (senior construction loan, mezz, preferred equity, common equity).
Development budget: land, hard costs, soft costs, financing costs, developer fee, contingency (usually 5% to 10% of hard costs).
Lease-up absorption curve: often 15 to 25 units per month for multifamily, longer for office or retail.
Yield on cost: untrended NOI at stabilization divided by total project cost. The most important development return metric. The spread between yield on cost and prevailing market cap rate is your development profit margin; anything under 100 basis points of spread in 2026 is considered tight.
Refinance or sale at stabilization: how the construction debt gets taken out. If refinance, the new permanent loan sizing feeds levered returns.

Development pro formas live or die on construction cost inflation, entitlement delays, and lease-up velocity. Each of these is a tail risk that rarely shows up until it shows up.

Rental property pro forma (sub-institutional)

Retail investors and small sponsors use a simplified version, often called a “rental property proforma” or “rental pro forma.” Structurally identical to an institutional pro forma but with fewer line items and a heavier reliance on rules of thumb. Common simplifications:

The 50% rule (operating expenses roughly equal 50% of rent)
The 1% rule (monthly rent should be ~1% of purchase price, a screening test, not an underwriting standard)
Single-unit vacancy assumptions (5% to 8% rather than a granular lease roll)

These rules work for napkin math. They break down above $5M deal size, which is why institutional investors underwrite line by line.

Worked example: 100-unit multifamily year-1 pro forma

Let’s put numbers to it. Assume a 100-unit garden-style multifamily property in a secondary Sunbelt market. In-place rents average $1,450/unit. Market rent per the comp set is $1,600. T-12 shows 93% economic occupancy. Purchase price: $22.5M.

Line item	Calculation	Year 1 ($)
Gross potential rent	100 units × $1,600 × 12	1,920,000
Loss to lease	(In-place $1,450 vs market $1,600) × 100 × 12	(180,000)
Vacancy	5.5% of GPR	(105,600)
Credit loss / bad debt	1.0% of GPR	(19,200)
Concessions	0.5 months per signed lease × turnover	(32,000)
Other income	Parking, RUBS, fees	95,000
Effective gross income		1,678,200
Real estate taxes (reassessed)	1.8% of purchase price	(405,000)
Insurance	$550/unit	(55,000)
Utilities (net of RUBS)	$350/unit	(35,000)
Repairs & maintenance	$425/unit	(42,500)
Payroll	$950/unit	(95,000)
Contract services	$175/unit	(17,500)
Marketing	$125/unit	(12,500)
G&A	$100/unit	(10,000)
Management fee	3.0% of EGI	(50,346)
Total operating expenses		(722,846)
Net operating income		955,354
Capex reserves	$300/unit	(30,000)
NOI after reserves		925,354
Debt service	$15M loan @ 6.5%, 30-yr amort	(1,138,000)
Levered cash flow		(212,646)

Observations this pro forma would provoke at IC:

Going-in cap rate is $955,354 / $22,500,000 = 4.25%. Tight for a Sunbelt secondary in 2026.
Pro forma cap rate at stabilization (after marking rents to $1,600, trimming vacancy to 5%) is closer to 5.3%, but only if the full $150/unit mark-to-market is achievable.
Debt service coverage is 0.84x in year 1. The loan would not size without interest-only, equity paydown, or a lower LTV.
Expense ratio is 43.1%, within institutional norms for managed garden-style.
Tax line is the largest single expense: and the most sensitive to reassessment assumptions.

This is a representative year-1 pro forma. The multi-year version would grow revenue at 3.0% annually, expenses at 2.5%, and hit an exit at year 5 or 7 with an exit cap 25 to 75 basis points above the going-in cap, the standard cap rate decompression every institutional underwrite builds in.

The pro forma cap rate (and why it’s so often misleading)

The pro forma cap rate is the most manipulated number in commercial real estate marketing. Formula:

Pro forma cap rate = Stabilized pro forma NOI / Purchase price

It is higher than the in-place cap rate because it assumes the business plan has succeeded: below-market leases have rolled to market, vacancies have absorbed, operating efficiencies have landed, and the property is producing the NOI the sponsor projected.

Where it misleads:

It presumes execution risk is zero. A 7.5% pro forma cap three years into a value-add plan is meaningless if the plan misses by a year or the market softens during lease-up.
It ignores the capital required to achieve it. Renovation capex, re-tenanting costs, and carrying costs during repositioning are often below-the-line in marketing materials.
The denominator excludes closing costs. Buyers see the “all-in basis” yield, which is 50 to 100 basis points lower than the headline pro forma cap.
Comparable cap rates are almost always in-place, not pro forma. Presenting a pro forma cap next to in-place cap comps is an apples-to-oranges trick that inexperienced LPs fall for.

A more honest framing: use going-in cap rate (in-place NOI / price) for current yield and stabilized yield on cost (stabilized NOI / all-in basis) for the business plan outcome. The gap between them is the value-creation thesis.

How sophisticated buyers stress-test a pro forma

The first thing a real acquisitions team does with a seller’s pro forma is tear it apart. The second thing is rebuild it. The checks below are standard at institutional shops:

Vacancy haircut. Add 200 to 500 basis points to the seller’s vacancy assumption. If the pro forma assumes 4% vacancy in a market where the CoStar submarket average is 8%, the deal already has a gap.

Expense ratio sanity check. Compare the seller’s OpEx ratio to recent institutional comps. If your pro forma shows 38% OpEx ratio for managed Class B multifamily in the Southeast and the submarket comps are 46%, one of you is wrong. Usually the seller.

Real-estate-tax reassessment. Apply the local jurisdiction’s reassessment rules to the purchase price. Sellers almost always show the current tax bill; the buyer’s year-1 taxes will be materially higher in most states.

Insurance mark-to-market. Get a fresh quote from a broker before underwriting. Coastal, wind, and wildfire exposures have repriced dramatically.

Rent growth reality. The pro forma’s rent growth assumption should be defensible against the CoStar / Axiometrics / RealPage five-year forecast for the submarket, not the seller’s national narrative.

Exit cap rate decompression. Apply at least 25 to 50 basis points of cap expansion from going-in to exit. The era of ever-compressing caps ended in 2022.

Three-scenario downside. Base, downside, bear. In the downside, lease-up slows by six months, rent growth drops 150 basis points, and expenses inflate 100 basis points faster than base. If the deal still clears a minimum IRR in the downside case, the business plan has real margin. If it only works in the base case, there is no margin.

Why most pro formas are wrong

Three structural reasons, each independent:

1. Linear assumptions, lumpy reality. Pro formas project rent growth, expense inflation, and vacancy as smooth trend lines. Real estate operates in 18-month up cycles and 6-month corrections. A pro forma that assumes 3% annual rent growth over 10 years will rarely be right in any individual year.

2. Under-reserving for capex and re-tenanting. The T-12 shows operating repairs, not the $2,400/door amenity refresh or the $45 PSF TI package the next office tenant will demand. Pro formas that net capex against the sale proceeds, rather than showing it as a year-by-year drag on cash flow, flatter the interim return profile.

3. Information asymmetry at underwriting. Buyers see a redacted rent roll, a summarized T-12, and a 40-page marketing package. The real data (individual lease files, service contracts, utility bills, insurance claim history) surfaces only during diligence, often after the contract is signed. Pro formas are built on the first-pass information set; the second-pass information set is the reason earnest money deposits get renegotiated.

This is not a reason to distrust pro formas. It is a reason to build your own, not inherit the seller’s.

The tools institutional teams use

Excel: still dominant. Proprietary templates at every major shop. Flexible, transparent, version-controlled by file name. Most institutional pro formas live here first.

ARGUS Enterprise: the industry-standard DCF engine, primarily for commercial (office, retail, industrial) where lease-by-lease complexity exceeds what Excel handles gracefully. Multifamily shops often run ARGUS and Excel in parallel.

Valuate: a cheaper web-based alternative to ARGUS, used by sub-institutional sponsors and middle-market shops.

Quadratic / RealPage / AppFolio templates: productized templates for multifamily and small-sponsor workflows.

Each of these tools handles the math downstream. None of them handle the upstream problem: getting clean, accurate, normalized inputs (rent roll, T-12, lease terms) into the model in the first place.

Where Atlas fits: clean inputs into your pro forma

The hardest part of building a real estate pro forma is not the modeling. It is producing inputs you trust.

A typical value-add multifamily deal arrives with a 30-page rent roll PDF, a T-12 exported from Yardi in a format your Excel template doesn’t want, and 60 lease documents of varying vintage. An analyst spends two to three days keying that data into a pro forma template, reconciling inconsistencies, and chasing lease clauses that affect the revenue line. The pro forma is built on top of this data, which means the pro forma is only as trustworthy as the extraction.

Atlas (Moraine) sits upstream of your pro forma. It ingests the rent roll PDF, extracts lease-level data into a normalized rent roll, parses the T-12 into standardized operating-statement line items, abstracts each lease for material terms (expirations, options, escalations, recoveries, co-tenancy), and flags lease risks: sub-market rents, over-termed tenants, rollover concentration, co-tenancy trips. What used to take three days of analyst time and still leave gaps, Atlas produces in under an hour with full document traceability.

Those outputs feed directly into your Excel or ARGUS pro forma. The model doesn’t change. The time to build the model, and the defensibility of the inputs, does.

The bottom line

A real estate pro forma comes with a well-understood set of manipulations that sellers and brokers apply to make the argument more favorable. Institutional buyers rebuild the pro forma from scratch because inheriting the seller’s version is the same as agreeing with it.

The most valuable skill in pro forma modeling is knowing which assumptions move the IRR the most and which assumptions the seller has quietly softened. Vacancy, expense ratio, tax reassessment, exit cap rate. Those four line items account for most of the gap between a pro forma that underwrites and a pro forma that prints.

And none of them are debatable if your inputs are wrong. The pro forma is only as good as the rent roll, T-12, and lease file behind it. Spend less time formatting cells and more time validating the data that flows into them.

See how Atlas delivers clean inputs into your pro forma →