A rental property pro forma is a projected income statement that estimates a property's gross rent, operating expenses, and net operating income before you buy. It converts assumptions about vacancy, capital reserves, and the expense ratio into a defensible cap rate and cash-on-cash return. It is also the document DSCR lenders underwrite against when they size a loan.
Key Takeaways
- A pro forma is a forecast, not actuals, so every assumption must be defensible.
- Start with gross scheduled rent, subtract vacancy, then subtract each operating expense.
- Standard vacancy and credit loss assumption for 2026 single-family runs 5 to 8 percent.
- Set a capital expenditure reserve of 5 to 10 percent of gross rent.
- A single-family operating expense ratio typically lands between 35 and 45 percent of income.
- NOI excludes debt service, depreciation, and income taxes by design.
- Most 2026 DSCR loan programs require a debt service coverage ratio of at least 1.20.
What is a rental property pro forma?
A rental property pro forma is a forward-looking income statement that projects how a property will perform financially once you own and operate it. The Latin phrase means "for the sake of form," and in real estate it captures the standardized form investors use to translate a purchase into a yield. Unlike a tax return on IRS Schedule E, which records what already happened, the pro forma models what should happen over the next twelve months under a defined set of assumptions.
The document has one job: turn a listing price and a rent number into a cap rate, a cash-on-cash return, and a debt service coverage ratio you can defend to a partner or a lender. A seller's pro forma is a sales tool and almost always optimistic; your pro forma is a risk-control tool and should be conservative. Institutional buyers, from Fannie Mae and Freddie Mac securitization desks to single-family aggregators like RealPage-tracked operators, all underwrite off the same core structure covered here. For the broader process that surrounds the model, see our deal underwriting framework.
What line items go in a real estate pro forma?
A complete pro forma flows top to bottom: gross scheduled rent, minus vacancy, equals effective gross income; then each operating expense line; then net operating income; then debt service and pre-tax cash flow. The table below models a sample stabilized single-family rental purchased for $215,000 at a market rent of $2,050 per month. Every negative line is money the property loses before it reaches your pocket.
| Line item | Annual | Basis / note |
|---|---|---|
| Gross Scheduled Rent (GSR) | $24,600 | $2,050/mo market rent |
| Vacancy & credit loss (6%) | -$1,476 | Submarket assumption |
| Effective Gross Income (EGI) | $23,124 | GSR minus vacancy |
| Property taxes | -$2,700 | Post-sale reassessed estimate |
| Insurance | -$1,450 | Landlord policy |
| Property management (8% of EGI) | -$1,850 | Third-party manager |
| Repairs & maintenance | -$1,250 | Ongoing turn and fixes |
| CapEx reserves (7% of GSR) | -$1,722 | Roof, HVAC, systems |
| Misc / landscaping / admin | -$400 | Owner-paid items |
| Total operating expenses | -$9,372 | 41% of EGI |
| Net Operating Income (NOI) | $13,752 | EGI minus OpEx |
| Annual debt service (70% LTV, 6.4%) | -$11,304 | $150,500 loan, 30-yr |
| Pre-tax cash flow | $2,448 | NOI minus debt service |
| Going-in cap rate | 6.4% | NOI / $215,000 price |
| Cash-on-cash return | 3.3% | On ~$75,000 invested |
| DSCR | 1.22 | NOI / debt service |
Notice that NOI stops before debt service. That separation is deliberate: it lets you compare two properties on operating merit regardless of how each is financed. Below NOI, the loan terms take over, and small changes in leverage or rate swing your cash-on-cash return more than any single expense line. The gross rent multiplier versus cap rate comparison explains why cap rate, not GRM, is the number lenders and institutional buyers actually price against.
How do you calculate NOI in a pro forma?
Net operating income equals effective gross income minus operating expenses, full stop. In the sample above, EGI of $23,124 minus $9,372 in operating expenses produces an NOI of $13,752. NOI deliberately excludes mortgage debt service, depreciation, and income taxes, because those depend on the buyer rather than the building. That is what makes NOI the cleanest apples-to-apples metric across deals.
The two most common ways investors inflate NOI are understating vacancy and omitting a CapEx reserve. A property manager charging 8 to 10 percent of collected rent, insurance that has risen sharply since 2023, and property taxes that reassess to the new purchase price all compress NOI in ways a seller's sheet conveniently ignores. Our full breakdown of net operating income walks each expense line in depth, and the good cap rate guide shows how NOI feeds the valuation.
How much vacancy should a pro forma assume?
A conservative single-family pro forma assumes 5 to 8 percent vacancy and credit loss for 2026, even in tight rental markets. Vacancy captures both physical empty days between tenants and credit loss from unpaid or partially paid rent. Underwriting to zero vacancy, as some seller sheets do, is the single fastest way to manufacture a cap rate that will not survive the first tenant turnover.
The better move is to pull the actual submarket vacancy rather than use a blanket figure. The U.S. Census American Community Survey publishes rental vacancy and median gross rent by geography, and a local property manager can tell you realistic days-on-market for your rent band. Pair that with HUD Fair Market Rents to sanity-check that your assumed rent is achievable, not aspirational. If your model only works at 3 percent vacancy, it does not work.
What is a good pro forma cap rate in 2026?
In 2026, stabilized single-family rentals in Midwest and Sun Belt markets commonly pro forma between 5.5 and 7.5 percent on a going-in cap rate, with the sample deal above landing at 6.4 percent. Cap rate equals NOI divided by purchase price, so a higher cap means more yield per dollar, but it usually signals a softer location, older stock, or more operational risk. There is no universal "good" cap rate; there is only the cap rate relative to comparable trades in that submarket.
Interest rates set the floor. When 30-year financing sits near 6.4 percent, buying at a 5 percent cap rate produces negative leverage, meaning debt drags your return below the all-cash yield. The Federal Reserve Economic Data 30-year mortgage series is the fastest way to see where rates stand before you set your target cap. As a rule, your going-in cap rate should exceed your loan constant, or the deal only works on appreciation and rent growth, not current cash flow.
| Assumption | 2026 benchmark | Why it matters |
|---|---|---|
| Vacancy & credit loss | 5–8% of GSR | Protects NOI from turnover |
| Operating expense ratio (SFR) | 35–45% of EGI | Reality check on total OpEx |
| CapEx reserve | 5–10% of rent | Funds roofs, HVAC, systems |
| Property management | 8–10% of collected rent | Even if self-managed, price it |
| DSCR loan floor | ≥1.20 (often 1.25) | Lender sizing constraint |
| Going-in cap rate (Sun Belt SFR) | 5.5–7.5% | Compare to recent trades |
Pro forma vs actuals: why do they differ?
Pro forma numbers are projections, so they diverge from actuals whenever reality misses an assumption: vacancy runs higher, repairs spike, property taxes reassess after the sale, or market rent falls short of the listing claim. The gap is not a flaw in the method; it is the reason you stress-test. Seller pro formas in particular tend to understate expenses and overstate rent, which is why the number on a marketing flyer should never be the number in your model.
Disciplined investors underwrite to trailing-twelve-month actuals wherever they exist, then layer their own assumptions on top. Ask for the rent roll, the last two years of tax bills, the insurance declaration page, and repair invoices. Where actuals are missing, default to conservative benchmarks and note the assumption. Tools like Stessa for bookkeeping and PropStream for comparables help you replace guesses with data. Cross-check your projected yield against the cash-on-cash return formula and the rent-to-price ratio rules so a single optimistic line does not carry the whole deal.
Do lenders require a pro forma for DSCR loans?
Yes. A DSCR loan is underwritten on the property's cash flow rather than the borrower's personal income, so the lender needs a pro forma to compute the debt service coverage ratio: NOI divided by annual debt service. In the sample deal, $13,752 of NOI against $11,304 of debt service yields a DSCR of 1.22, which clears the typical 1.20 floor most 2026 programs enforce and approaches the 1.25 many prefer.
Because the loan is sized to that ratio, every assumption in your pro forma has a direct dollar consequence at closing. Overstate rent or understate vacancy and the appraiser's or lender's own analysis will trim your NOI, shrink the supportable loan, and force a bigger down payment. A clean, conservative pro forma is what gets a DSCR loan to the number you underwrote to. See our DSCR loan underwriting guide for program terms, and our how to underwrite a rental property walkthrough for the end-to-end model.
Frequently Asked Questions
What is the difference between a pro forma and a rent roll?
A rent roll is a snapshot of current leases, tenants, and rents in place today. A pro forma is a forward projection of income and expenses over the next twelve months, built partly from the rent roll and partly from your assumptions. The rent roll tells you what the property earns now; the pro forma tells you what it should earn under your operating plan, including market-rate rent and full expense loading.
Should a pro forma use market rent or in-place rent?
Use both, clearly labeled. Model the in-place rent to show what you inherit on day one, and a stabilized case at market rent to show the upside once leases turn. Presenting only the market-rent case is how sellers inflate value. Lenders and serious partners want to see the going-in figure and the path to stabilized, not a single blended number that hides the lease-up risk.
How do you calculate cap rate from a pro forma?
Divide net operating income by the purchase price or current value. In the sample, $13,752 of NOI on a $215,000 price is a 6.4 percent going-in cap rate. Because cap rate ignores financing, it lets you compare properties on operating performance alone. To judge whether that cap rate is attractive, compare it to recent comparable sales in the same submarket, not to a national average.
What operating expense ratio is realistic for single-family rentals?
For single-family homes, a total operating expense ratio of 35 to 45 percent of effective gross income is realistic once you include management, taxes, insurance, maintenance, and CapEx reserves. Older homes and high-tax states push toward the top of that range. A pro forma showing a 20 percent expense ratio is almost certainly missing lines, most often the CapEx reserve and honest maintenance.
Can I build a rental pro forma in a spreadsheet?
Yes, and most investors do. A single tab with gross rent, vacancy, each expense line, NOI, debt service, and the resulting cap rate, cash-on-cash return, and DSCR is enough to underwrite a single-family or small multifamily deal. Purpose-built tools and lender templates from Fannie Mae or Freddie Mac add structure, but the math is simple enough that a clean spreadsheet with defensible inputs beats a fancy model built on optimistic assumptions.
How often should I update a pro forma after buying?
Re-run the model at least annually and after any material change: a tax reassessment, an insurance renewal, a rent increase, or a major CapEx event. Comparing your live actuals against the original pro forma tells you whether the deal is tracking, and it sharpens the assumptions you carry into your next acquisition. The pro forma is a living underwriting tool, not a one-time document you file after closing.
Founder of Home Pros, operator across 48 markets, closed 300+ investor transactions since 2021. Home Pros sources off-market single-family and small multifamily deals and places them with individual and institutional capital. More about Trevor →
Primary sources: Federal Reserve Economic Data, 30-Year Fixed Mortgage Average; U.S. Census American Community Survey, rent and vacancy data; HUD Fair Market Rents; Investopedia, Pro Forma. This article is educational and not investment advice; underwrite every deal to its own trailing actuals.