How to Read a Real Estate Pro Forma Before You Buy
- Rey Rey Rodriguez
- 7 minutes ago
- 18 min read
A real estate pro forma is a forward-looking projection of a property’s income, expenses, and net operating income (NOI), built on assumptions the seller or sponsor chooses. The single most important thing you can do when reading one: never take it at face value. Cross-check every number against the trailing 12 months of actuals (T‑12) and the current rent roll, then stress-test the assumptions that drive value before you write an offer.
Run these six checks the first time you open any pro forma:
Reconcile stated rents against the actual rent roll, unit by unit
Check whether vacancy and credit loss assumptions reflect the property’s real history
Confirm capital expenditure (CapEx) and reserve allowances actually exist in the model
Recalculate NOI yourself and derive the cap rate independently
Verify debt assumptions, especially the debt service coverage ratio (DSCR)
Run a downside scenario with lower rent growth and a higher exit cap rate
Sellers and sponsors build pro formas to sell a story, and the story almost always leans optimistic. That’s not necessarily dishonest. It’s just the nature of a document built to attract capital. The fixes come later in this guide, in the red-flag checklist and the stress-testing section, but the mindset starts here: treat every pro forma as a claim to verify, not a fact to accept.
Pro Tip: Before you read a single line item, ask for the T‑12 and the rent roll in the same email where you request the pro forma. If a seller stalls on either document, that delay tells you more than the pro forma itself.
Key Takeaways
Reading a real estate pro forma correctly means treating every projected number as a claim to verify against the T‑12 and rent roll, not a fact to accept.
Point | Details |
Verify against actuals first | Always reconcile pro forma figures with the T‑12 and current rent roll before trusting any projection. |
NOI drives everything | A small NOI error can swing valuation by tens of thousands of dollars once divided by the cap rate. |
Reserves are non-negotiable | Budget realistic CapEx reserves, around $250 per unit per year, even when the seller’s model shows none. |
Stress-test before you offer | Run conservative, realistic, and optimistic scenarios, and test rents down 10% with cap rates up 50 bps. |
Get a professional review when needed | 2ndstreetpropertymanagement supports investors with due-diligence document review and underwriting verification. |
Table of Contents
What Is a Real Estate Pro Forma, and How Does It Differ From a T‑12?
A pro forma is a projection, not a record. It estimates what a property’s income and expenses will look like going forward, based on assumptions someone else chose. A T‑12 (trailing 12 months) shows what actually happened over the past year, drawn from bank statements and paid invoices. A rent roll is simply a snapshot of who’s renting each unit right now, at what rate, and under what lease terms.
Those three documents answer three different questions. The T‑12 tells you what the property has done. The rent roll tells you what it’s contractually earning today. The pro forma tells you what someone believes it will do tomorrow. Public companies filing pro forma statements alongside GAAP financials face the same tension real estate investors do: pro forma figures can omit or reclassify items in ways that flatter the picture, so investors have to compare both sets of numbers before drawing conclusions.
Here’s how the three documents stack up in practice:
Document | What it shows | When to trust it |
Rent roll | Current leases, rents, and terms, unit by unit | Trust as the baseline for today’s actual income |
T‑12 | Actual income and expenses over the past 12 months | Trust as the baseline for underwriting; reconcile the pro forma against it |
Pro forma | Projected income, expenses, and NOI over a future period | Treat as a hypothesis to test, not a fact to accept |
Most operating pro formas project three to five years out, though some sponsors extend to ten. The horizon matters because a longer projection compounds more assumptions. A 10 percent rent growth assumption barely moves year-one numbers, but stretched across seven years it can inflate exit value substantially. Shorter horizons force more honesty; longer ones give room for optimism to hide in the outer years, which is exactly where most investors stop scrutinizing closely.
How Do You Build a Pro Forma From Scratch?
Building your own pro forma, or auditing someone else’s, follows the same sequence every time. Each step feeds the next, so an error early in the chain compounds by the time you reach NOI.
Start with the rent roll. List every unit, its current rent, lease end date, and any concessions in place.
Calculate gross potential income (GPI). Sum what every unit would earn at full occupancy and market rent.
Subtract vacancy and credit loss. Apply a realistic percentage based on the property’s actual history, not the sponsor’s hoped-for number.
Add other income. Laundry, parking, pet rent, storage fees, and application fees all belong here.
Calculate effective gross income (EGI). GPI minus vacancy and credit loss, plus other income.
Subtract operating expenses. Property tax, insurance, utilities, payroll, repairs, management fees, and contract services.
Arrive at NOI. EGI minus operating expenses. This is the number everything else depends on.
Deduct reserves and CapEx. Set aside funds for roof, HVAC, and major system replacements, before you call the cash flow real.
Calculate cash flow before and after debt service. Subtract your mortgage payment from NOI to get levered cash flow.
Three formulas do most of the heavy lifting in this process, and you should be able to run each one from memory:
EGI = Gross Potential Income − Vacancy & Credit Loss + Other Income
NOI = Effective Gross Income − Operating Expenses
Value = NOI ÷ Cap Rate
For market rent assumptions, pull comps from Rentometer, Zillow, and Apartments.com. Rentometer works fastest for a quick sanity check on a single unit’s rent. Zillow gives you a broader view of recently listed and rented comparables in the immediate area. Apartments.com tends to have deeper inventory in markets with larger multifamily buildings. Cross-reference at least two of the three before you accept a sponsor’s stated market rent, and verify local property tax and insurance costs directly with the county assessor and an insurance broker rather than trusting a stale figure in someone else’s spreadsheet.
If you’re building this yourself, work from a downloadable Excel pro forma template with a dedicated assumptions tab and separate scenario tabs. That structure lets you change one number, like vacancy or exit cap rate, and watch it flow through every downstream calculation without rebuilding the model. For a broader look at underwriting a full deal around these numbers, our guide on how to analyze a rental property deal walks through the surrounding decision points.
What Do the Revenue and Expense Line Items Actually Mean?
Every line item on a pro forma represents a real-world number that someone chose, and some of those choices deserve more scrutiny than others.
Gross potential rent is what every unit would generate if it were fully leased at market rate, all the time. Loss to lease captures the gap between what a unit could rent for and what the current tenant actually pays, which matters most in buildings with long-tenured renters below market. Concessions are discounts, like a free month, offered to sign a lease. Vacancy and credit loss account for empty units and tenants who stop paying. Other income covers everything outside base rent: laundry machines, reserved parking, pet rent, application fees, and late fees.
On the expense side, split every line into fixed and variable. Property tax, insurance, and often payroll behave as fixed costs that don’t flex much with occupancy. Utilities, maintenance, and contract services swing with usage and season. Property management fees typically run 8 to 10 percent of collected rent, and if a pro forma shows $0 for management because the current owner self-manages, that’s not a real expense, that’s a hole in the model.
Reserves deserve their own line, separate from routine repairs. A widely used baseline is $250 per unit per year set aside for future capital needs, roofs, parking lots, major mechanical systems. Skipping this line doesn’t make the cost disappear. It just means the money comes out of your pocket later instead of showing up in the projection now.
A short worked example shows how fast a small error compounds. Say a 10-unit building shows insurance at $6,000 a year in the pro forma, but your broker quotes $9,500 based on current market rates and the building’s actual claims history. That $3,500 difference drops straight to NOI. At a 6 percent cap rate, that single line item mistake overstates the property’s value by roughly $58,000. Now imagine reserves are also missing entirely at $250 per unit: another $2,500 a year gone, another chunk of inflated value. Two overlooked lines, and the pro forma has quietly manufactured six figures of phantom equity.
Pro Tip: Recalculate insurance and property tax yourself before you trust anything else in the pro forma. These two lines are the most commonly outdated or understated numbers in any seller-provided model and they’re also the easiest to verify with a phone call.
How Does NOI Determine a Property’s Value?
Value equals NOI divided by cap rate. That single equation is why NOI sits at the center of every serious pro forma review, and why a small error in the operating numbers can swing a purchase price by tens of thousands of dollars.
Here’s how sensitive that relationship really is. A $1,000 monthly swing in NOI, roughly $12,000 a year, moves valuation dramatically depending on the cap rate environment:
At a 4 percent cap rate, $12,000 in annual NOI translates to a $300,000 valuation swing.
At a 6 percent cap rate, that same $12,000 swing translates to $200,000 in value.
At an 8 percent cap rate, the swing narrows to $150,000.
Lower cap rates amplify the impact of NOI errors because you’re dividing by a smaller number. In one documented example, a $6,900 difference in annual NOI produced a $115,000 swing in valuation at a 6 percent cap rate. That’s the kind of gap a single mistyped expense line or an omitted reserve can create.
Pay attention to whether the pro forma uses stabilized NOI or year-by-year NOI. Stabilized NOI represents the property’s expected performance once occupancy, rents, and expenses settle into a normal pattern, and it’s usually the number sponsors use to calculate exit valuation. Year-by-year NOI shows the messier path to get there, including lease-up periods or renovation downtime. If a sponsor is using stabilized NOI to justify today’s purchase price, ask how many years out that stabilization actually sits.
Exit cap rate assumptions deserve particular skepticism. Many pro formas assume the exit cap rate will hold steady or even compress below the entry cap rate, which assumes market conditions improve in the investor’s favor over the hold period. That’s a bet, not a guarantee, and it’s one of the most common places optimistic underwriting hides.
What DSCR, Cash-on-Cash, and IRR Numbers Should You Check?
Lenders and investors each care about different metrics, and a pro forma needs to satisfy both audiences to be useful.
The debt service coverage ratio (DSCR) measures how much cash flow a property generates relative to its debt payments: DSCR = NOI ÷ Annual Debt Service. Most lenders require a minimum DSCR somewhere between 1.20 and 1.35, meaning the property needs to generate 20 to 35 percent more income than its mortgage payment demands. A pro forma showing DSCR right at the minimum threshold leaves no cushion if rents soften or expenses rise, and it signals the deal was underwritten to hit a number rather than to reflect reality.
Debt mechanics change these numbers meaningfully. An interest-only period in the first few years of a loan inflates DSCR and cash flow temporarily, because no principal payment is due yet. Once amortization kicks in, both numbers drop. If a pro forma shows strong Year 1 and Year 2 DSCR but doesn’t flag when interest-only ends, you’re looking at a projection that gets harder to sustain right when the model claims things are improving.
On the investor side, three metrics matter most:
Cash-on-cash return = Annual Pre-Tax Cash Flow ÷ Total Cash Invested
Equity multiple = Total Cash Distributed ÷ Total Cash Invested
Internal rate of return (IRR) accounts for the timing of cash flows, not just their total, which is why a faster exit with the same total profit produces a higher IRR
IRR is time-sensitive in a way the other metrics aren’t. A deal that returns your capital in three years with modest annual cash flow can post a higher IRR than one that takes seven years to deliver a bigger total payout, because IRR rewards speed as much as size. When you see an IRR projection, always ask what hold period it assumes, because changing that single input can shift the headline number substantially without changing anything about the underlying property. For a deeper look at how these targets should shape your buying decisions, see our guide on cash flow goals for real estate investors.
What Are the Most Common Red Flags in a Pro Forma?
The most common red flags cluster around the same handful of moves, and once you know what to look for, they jump off the page. Seller pro formas frequently overstate market rent, understate vacancy, omit capex reserves entirely, and set management costs at $0, often in combination rather than isolation.
Watch for these specific patterns:
Market rent instead of current rent roll rent. If every unit shows the same “market” rate rather than what tenants actually pay today, the pro forma assumes an immediate rent bump that hasn’t happened yet.
Vacancy set below the submarket average. A 2 to 3 percent vacancy assumption in a market that historically runs 6 to 8 percent inflates EGI across every year of the projection.
Zero or near-zero capital reserves. No line item for roof, HVAC, or parking lot replacement means those costs are hidden, not eliminated.
Self-management priced at $0. If the current owner manages the property personally and the pro forma reflects no management fee, your actual operating costs will be higher the moment you take over.
Outdated insurance and tax figures. Property tax often reassesses after a sale, and insurance premiums have climbed sharply in many markets over the past several years.
Translating these seller assumptions into conservative buyer assumptions typically lowers the implied cap rate by 1.5 to 3 percentage points, which is another way of saying the “going in” cap rate a seller advertises usually overstates the deal’s real return once you correct for these five items.
Pro Tip: Build a simple translation table before you make an offer: bump vacancy up by 2 to 3 percentage points over the seller’s figure, add a full management fee even if the current owner self-manages, and insert a $250-per-unit CapEx reserve if one doesn’t already exist. Recalculate NOI with those three changes alone, and you’ll usually land much closer to reality.
When a red flag surfaces, don’t argue with the sponsor’s spreadsheet. Ask for the source documents instead: the actual rent roll with lease start and end dates, 24 months of utility bills, current insurance declarations pages, and the most recent property tax bill. Numbers are easy to defend in the abstract and much harder to defend against a paper trail.
How Do You Stress-Test a Pro Forma’s Assumptions?
Run at least three scenarios before you trust any single number: conservative, realistic, and optimistic. Then build a sensitivity table that varies two assumptions simultaneously, usually rent growth and exit cap rate, because that combination shows downside exposure better than testing one variable at a time.
A basic sensitivity table lays out rent growth assumptions down the rows and exit cap rate scenarios across the columns, with projected returns filling each cell. Reading it is straightforward: find where your realistic assumptions land, then look at the cells around it. If a small, plausible shift, say rent growth coming in at 2 percent instead of 4 percent, combined with the exit cap rate rising half a point, turns a strong return into a mediocre one, the deal has less margin for error than the headline pro forma suggests.
Here’s a practical way to set your three scenarios:
Conservative: Reduce projected rent growth by half, increase vacancy by 2 to 3 percentage points, add a 50 basis point cushion to the exit cap rate.
Realistic: Use verified market comps for rent growth, historical vacancy for the submarket, and hold the exit cap rate flat relative to entry.
Optimistic: Use the sponsor’s original assumptions largely as presented, since this scenario represents the best case rather than the expected case.
If you only run one stress test, make it this one: reduce rent by 10 percent and raise the exit cap rate by 50 basis points simultaneously. That single combined shock tends to reveal more about a deal’s real risk than testing rent and cap rate separately, because it mirrors what actually happens in a softening market: rents come down at the same time buyers demand a higher return to compensate for the uncertainty, compressing value from both directions at once.
Pro Tip: If a deal still cash flows and clears your minimum DSCR under the combined “rents down 10%, cap rate up 50 bps” scenario, that’s a meaningfully more durable deal than one that only survives under the sponsor’s base case.
What Does a Fully Worked Pro Forma Example Look Like?
Numbers make this concrete faster than formulas alone. Here’s a simplified 10-unit property example, walking through every calculation from gross rent to IRR.
Inputs: 10 units at $1,200/month market rent, 6 percent vacancy and credit loss, $150/month average other income, $58,000 in verified annual operating expenses (including a corrected insurance figure and a $2,500 CapEx reserve), a $900,000 purchase price, and a $675,000 loan at 6.5 percent interest, 30-year amortization.
That DSCR of 1.86 sits well above the typical 1.20 to 1.35 lender minimum, giving real cushion if rents soften. The cap rate math also shows why buying at $900,000 against an implied value of nearly $1.59 million at a 6 percent cap rate looks attractive, assuming the NOI figure holds up to scrutiny. IRR calculations require projecting this cash flow forward across a hold period and modeling a future sale, which is exactly what the scenario tabs in a proper Excel pro forma template are built to handle.
To reproduce this yourself, paste your verified rent roll and expense figures into the assumptions tab of your template first, then let the formulas cascade through EGI, NOI, and debt service automatically. Build your conservative, realistic, and optimistic scenarios as separate tabs referencing the same assumptions sheet, so changing one number updates every scenario consistently. Check the DSCR and cap-rate-implied value first. Those two outputs tell you within thirty seconds whether a deal is worth deeper analysis. Our breakdown of cash flow calculations for smarter investing covers additional variations on this same math for different property types.
What Documents Should You Request Before Closing?
A practical review starts with the rent roll and T‑12, reconciles those against the pro forma, then audits every revenue and expense assumption before checking return metrics and financing terms. That sequence only works if you have the right paper trail in hand.
Request these documents before you take a pro forma seriously:
Trailing 12-month (T‑12) profit and loss statement
Current rent roll with lease start and end dates
Copies of all active leases
24 months of utility bills
Most recent property tax bill and any pending reassessment notice
Current insurance policy and declarations page
Vendor and service contracts (landscaping, pest control, elevator maintenance)
Recent invoices for major repairs or capital work
Court records for any pending or recent evictions, where applicable
When the documents arrive, verify specific things in each one rather than skimming. In the T‑12, check whether reported expenses match the pro forma’s categories exactly, sellers sometimes reclassify costs between years to smooth out a bad quarter. In the rent roll, look for concession history and lease escalation clauses that might not be reflected in the pro forma’s flat rent assumption. Understanding what a proper rent roll actually contains helps you spot when a seller’s version is missing key fields like security deposit amounts or renewal options.
For tax verification, call the county assessor’s office directly and ask whether a sale triggers reassessment, since state and local forms often outline specific reassessment or filing rules that change your post-purchase tax liability substantially. For insurance, get a fresh quote from at least one broker using the actual claims history and current replacement cost, not the seller’s existing premium. A simple script works: “I’m underwriting a purchase at [address] and need a current quote based on [square footage/unit count/construction type], plus any claims history you can pull.”
A short document request you can send directly to a seller or sponsor: “To finalize our underwriting, please provide the trailing 12-month P&L, current rent roll, copies of active leases, 24 months of utility bills, the most recent tax bill, and your current insurance declarations page. We’d like to reconcile these against the pro forma before proceeding.”
Which Tools Help You Verify a Pro Forma’s Numbers?
A handful of tools cover most of what you need to check a pro forma’s assumptions without hiring outside help.
Rentometer works best for a fast rent check on a single address or unit type, pulling nearby comparable rents into a quick range. Zillow gives broader visibility into recently listed and recently rented units across a neighborhood, useful for spotting trends the pro forma’s rent growth assumption should reflect. Apartments.com tends to carry deeper listing inventory in markets with more multifamily supply, which helps when you’re comparing a larger property against true peers rather than a handful of single-family comps.
For the modeling itself, a well-built Excel pro forma template remains the standard tool, and a good one has three features: a dedicated assumptions tab where every input lives in one place, separate tabs for conservative, realistic, and optimistic scenarios that all reference those assumptions, and clearly labeled formulas rather than hardcoded numbers, so you can audit exactly how NOI and cash flow get calculated. A basic IRR calculator, whether built into your spreadsheet or a standalone tool, rounds out the kit for evaluating multi-year hold projections. For a broader framework on evaluating income assumptions before you even reach a full pro forma, this guide on rental income projections offers a useful starting checklist.
Use these tools in sequence, not all at once. Start with Rentometer for a fast gut check, expand to Zillow and Apartments.com if the numbers look off or you need more comps, then feed whatever you confirm into your Excel model’s assumptions tab.
What Do Experienced Investors Wish Beginners Knew About Pro Formas?
The gap between a pro forma and reality rarely shows up in the big, obvious numbers. It hides in the boring line items nobody double-checks: an insurance quote that’s eighteen months stale, a management fee assumed at zero because the current owner happens to live next door, a reserve line that simply doesn’t exist. Those are the details that quietly cost buyers real money after closing, not the flashy rent growth assumption everyone argues about upfront.
The discipline that actually protects you isn’t skepticism for its own sake. It’s re-underwriting every deal from scratch using your own verified numbers, even when the sponsor’s model looks polished and professional. Do get a fresh insurance quote before you trust any premium figure. Do budget realistic CapEx reserves even if the seller’s model shows none. Do re-underwrite every pro forma line by line rather than accepting the summary tab. Don’t accept a seller’s pro forma at face value just because it comes from a name you recognize. Don’t treat missing reserves as a rounding error. Don’t underestimate vacancy just because the current owner claims the building has “never had a vacant unit.”
Keep every document you gather and every recalculation you run. When you’re negotiating a purchase price, walking in with your own re-underwritten numbers, backed by the actual T‑12, real insurance quotes, and a documented reserve schedule, gives you leverage that a general objection to price never will.
How Can a Property Manager Help You Verify a Pro Forma?
Running the checks in this guide takes real time, and if you’re evaluating several properties at once or you’re new to a market, that time adds up fast. 2ndstreetpropertymanagement gives investors a faster path to a trustworthy number: instead of chasing county records and insurance quotes yourself, you get a team that already knows local tax reassessment patterns, current insurance costs, and realistic vacancy rates for the submarkets it operates in.
A professional review makes the most sense in a few specific situations: you’re evaluating a property outside your usual market and don’t have local comps memorized, you’re under a tight due-diligence deadline and can’t chase down twenty-four months of utility bills yourself, or you’re buying a multi-unit property where tenant screening, Section 8 compliance, or HOA coordination adds complexity beyond a simple rent roll. 2ndstreetpropertymanagement supports investors through tenant screening, rent collection, maintenance coordination, and due-diligence document review, built by investors who read these same pro formas every day. If you want a second set of eyes on a deal before you commit, reach out to 2ndstreetpropertymanagement to talk through what a professional underwriting review would look like for your next property.
Frequently Asked Questions
What is the fastest way to read a real estate pro forma for the first time?
Start with NOI and work backward. Confirm the rent roll matches the stated gross potential rent, check that vacancy reflects the property’s real history, and verify a CapEx reserve line actually exists. Those three checks catch most of the inflation in a typical pro forma within a few minutes.
How much should vacancy be in a realistic pro forma?
It depends on the submarket, but a minimum of 5 to 10 percent is a reasonable conservative baseline for most residential rentals, adjusted based on actual local vacancy data rather than a sponsor’s optimistic assumption.
Is a pro forma the same as an appraisal?
No. An appraisal is an independent, licensed professional’s estimate of current market value, often based partly on comparable sales. A pro forma is a projection built by a seller, sponsor, or investor using their own assumptions, and it can be far more optimistic than an appraisal would support.
How many years should a pro forma project?
Most operating pro formas run three to five years, though some extend to ten. Longer horizons compound more assumptions, so scrutinize the outer years of any long-dated projection more closely than the near-term numbers.
What’s a reasonable CapEx reserve if the seller’s pro forma shows none?
A commonly used starting point is $250 per unit per year, adjusted upward for older buildings or properties with aging major systems like roofs and HVAC units.
This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.
Sources
A short set of resources covers most of what you’ll need beyond this guide, whether you’re building your first pro forma or auditing someone else’s.
Ultimate Guide to Pro Forma for Real Estate Investors - Real Estate Financial Planner™
When two sources disagree on a specific assumption, like a recommended vacancy percentage or reserve amount, treat the more conservative figure as your working number until your own market comps confirm otherwise. Verification always beats convenience when real money is on the line.
Recommended
Comments