Membership

One membership: every in-depth guide, plus the Deal Workspace. Templates are sold separately and bought once — see below.

All-Access$9.99/mo

Every in-depth guide across Mortgage, Insurance, Investment, Salary, Rent and Budget, plus the Deal Workspace — our per-property case file for tracking a purchase from pre-approval to closing.

  • Every in-depth guide, across every category
  • Deal Workspace — per-property case file, multi-deal comparison, and buying-journey checklist
  • Unlimited saved calculations
  • The full article library, always free

Underwriting a Rental: The Deal Analysis Playbook

$4.99
CalculatorByState EditorialUpdated 2026-08-2890 min read
Read the Cliff Notes
  • The same property, the same loan, the same week produces a debt service coverage ratio of 0.58 by a real analysis and 1.33 by the seller's rent on a DSCR lender's formula, because the lender's ratio divides gross rent by PITIA and never subtracts vacancy, management, maintenance, or reserves. Both numbers are correctly calculated. Only one of them is about whether you make money.
  • In many jurisdictions the property is reassessed on sale, so the seller's tax line is a fact about the seller's holding period, not about the property. On the worked example the bill goes from $2,100 to $3,577.50 the moment you buy, and that single unreviewed line is worth $22,730.77 of purchase price capitalized at a 6.5% cap rate.
  • The worked audit in this guide takes a seller's pro-forma showing a 9.19% cap rate and $673.34 a month of positive cash flow to an audited 3.54% cap rate and -$574.46 a month. That is a $1,247.80 monthly swing with no dispute about a single physical fact -- every change is a line the pro-forma either omitted or priced at the seller's cost rather than yours.
  • You cannot divide a fixed net operating income by your required cap rate to get a maximum price, because property tax and the maintenance convention are both functions of the price you pay. Solving it properly on the example gives $176,315 at a 6.5% cap, $183,800 at cash-flow breakeven, and $160,575 at a 1.20 DSCR -- against a $265,000 ask.
  • A capital reserve built from actual component ages and real replacement costs comes to $2,398.50 a year on the example, which is 9.30% of gross rent -- nearly double the 5%-of-rent convention, because the roof is 18 years into a 30-year life and the furnace is 12 years into a 20-year one.
  • Fannie Mae caps interested party contributions on an investment property at 2% of the lower of sales price or appraised value, so on a $265,000 purchase the largest lendable seller credit is $5,300. A $7,300 inspection credit has to be restructured before it can exist, and nobody tells you that until underwriting kills it.
  • At 25% down a price reduction and a closing credit of the same size are within about $219 of each other on day one -- and the price reduction then keeps paying $546.75 a year in lower debt service and lower property tax, permanently.
  • A rent roll is a document the seller typed. It proves nothing on its own. The three things that convert it into evidence are twelve months of bank deposits, the actual signed leases with every addendum, and a tenant estoppel certificate signed by the tenant rather than by the seller.
  • Write the walk-away rules before you see the property, in numbers, and sign them. This guide gives seven of them with the arithmetic behind each -- they are the only part of the process that does not get renegotiated by the version of you that has already told people about the deal.

The listing says 9.19% cap rate. By the end of this guide you will be able to take that number apart into eleven lines, replace nine of them with figures you sourced yourself, and arrive at 3.54% -- without disputing a single physical fact about the building. The roof is the same roof. The tenant is the same tenant. Every change is a line the seller's pro-forma either left out entirely or priced at the seller's cost rather than at yours.

The single largest of those, and the one almost nobody re-checks, is the property tax. A very large number of American jurisdictions reassess a property when it sells. In California the trigger is a change in ownership under Proposition 13's acquisition-value system (BOE Assessors' Handbook 401). In Michigan the taxable value is uncapped in the year following a transfer of ownership (Michigan Treasury). In Florida, non-homestead residential property is assessed at just value as of the January 1 following a change of ownership, and only then does the 10% annual cap start running again (Fla. Stat. 193.1554). The seller's tax bill is a fact about how long the seller has owned the house. It is not a fact about the house.

On the property worked through in this guide, that one line moves from $2,100 to $3,577.50 on the day of closing. Capitalized at a 6.5% cap rate, the $1,477.50 difference is $22,730.77 of purchase price -- more than the entire inspection findings, more than the negotiation, more than anything else you are likely to argue about.

This guide is about one property. Not a market, not a strategy, not a portfolio. It is the procedure for taking a single address with a single set of seller-supplied numbers and finding out, before your due diligence period expires, whether those numbers are true. You will finish it able to: audit a pro-forma line by line and say where each replacement figure came from; comp a rent from leases that actually signed instead of asking prices that did not; get the tax, the insurance, and the utilities right for a non-owner-occupied property rather than for the seller's; build a capital reserve from the actual ages of the actual systems; age a roof, a furnace, a condenser, a panel, and a sewer lateral yourself on a twenty-minute walkthrough; convert an inspection finding into a specific dollar ask, structured so your lender will actually allow it; verify a tenant rather than a building; solve backwards from your own required return to the highest price that clears it; and write walk-away rules in advance, because the whole point is deciding before you are emotionally committed.

There are eleven checklists and scripts in here and six reference tables. Those are the working part. The prose exists to tell you which one to use and when.

A note before you start: this is general education about how rental property due diligence works, not investment, tax, legal, or insurance advice, and nothing here is a prediction about any property or any market. Every dollar figure is either arithmetic shown on the page or a cited figure with its source and its methodology named. Rents in the examples are stated assumptions, labeled where they are used, and you are meant to replace them with real comps for your own address. The mortgage rate anchor is Freddie Mac's Primary Mortgage Market Survey for the week of 2026-08-20 -- 6.65% for a 30-year fixed and 5.95% for a 15-year (Freddie Mac PMMS) -- which is an owner-occupied conventional survey rate; investment-property loans price above it, and the 7.25% used in the worked example is a stated assumption standing in for a real quote, not a rate anyone has offered you. Landlord-tenant law is state law and this guide does not state it. Eviction procedure, notice periods, security deposit handling and transfer, late fee limits, lease disclosure requirements, and rent regulation all vary enormously and change; where they matter below, the mechanism is named and you are told to go read your own state's statute or ask a real estate attorney licensed there. CalculatorByState takes no lead-generation fees, no affiliate money, and no referral payments from lenders, insurers, property managers, or brokers.

The seller's pro-forma is not a lie, and that is the problem

Almost every objection a first-time buyer raises about a pro-forma is the wrong objection. The numbers on it are usually defensible. They are just answers to a different question than the one you are asking.

"Market rent" is a forecast, not a receipt. The pro-forma line labeled rent is frequently what the seller believes the unit could get, sometimes after improvements the seller is not making. The rent the current tenant actually pays is a different number, it is knowable, and it is often lower.

"Potential" gross income is the definition of gross scheduled rent with no vacancy. It is not wrong. It is a defined term that means twelve months of full rent with no turnover, no non-payment, and no lease-up gap. Presented without a vacancy line under it, it silently becomes a claim.

The expense figures are the seller's actual expenses, which is exactly why they are useless to you. The seller's tax bill reflects the seller's assessment. The seller's insurance premium may be a homeowners policy on a property the seller once lived in. The seller's maintenance number is what the seller happened to spend, which is a description of the seller's tolerance for deferred work, not of the building's needs.

There is no management fee because the seller manages it. If you also self-manage, the fee is still real -- it is your labor, and zeroing it means your return is paying you for weekends rather than for the property. If you do not self-manage, it is a bill.

There is no capital reserve because a reserve is not an expense a cash-basis owner ever records. Nobody writes a check to "roof, 2038." The roof still gets replaced.

Here is the useful way to hold all five at once. Take the pro-forma exactly as written and put it into the site's own rental analysis calculator with vacancy, management, and capital reserve all set to zero, because that is what the pro-forma says. The calculator will fire three separate warnings at you before you have typed anything of your own -- one for the missing reserve, one for the zero vacancy, one for the zero management fee. That is not the calculator being pedantic. Those three lines are worth $6,836.10 a year on the property below, and they are the three that never appear on a flyer.

The five documents that turn a pro-forma into evidence

You do not argue with a pro-forma. You replace it. These five documents are what you replace it with, and every one of them is obtainable inside a normal due diligence period.

Document Who has it What it settles What it does not settle
Twelve months of bank statements or the property's ledger Seller Whether the rent on the rent roll was actually collected, and when Whether the rent is at market
Every signed lease, with every addendum Seller Term, rate, deposit held, pet and utility terms, renewal and escalation clauses Whether the tenant will honor it
A tenant estoppel certificate, signed by the tenant Tenant What the tenant believes the terms are, what deposit the tenant believes is held, and whether the tenant claims any side agreement or unresolved repair Anything the tenant does not know
The parcel's actual tax bill and the assessor's record County The current assessment, the taxing districts, exemptions in force, and where the county sits in its reappraisal cycle Your bill after reassessment -- you compute that
A bindable insurance quote for the address, non-owner-occupied Your agent The real premium, the real deductibles, and whether anyone will write it at all Nothing else, but it is the line most often wrong by four figures

Request all five in the same email on the day you go under contract. Four of them are free. The fifth costs a phone call.

What this guide assumes you already know

This is a paid guide, so it does not spend your money re-explaining things the site gives away. Cap rate, cash-on-cash return, debt service coverage ratio, the 1% rule, and the specific damage that omitting vacancy, management, and reserves does to a return are all covered free and in depth, with a full worked example per state. Rental property in Ohio is the clearest demonstration of the omitted-expenses problem in the series -- it shows a property that cash flows $34.78 a month with those three lines missing and loses $342.62 a month with them present. Rental property in Florida does the same job where insurance rather than tax is the deciding expense. If you have not read one of those, read it first; it is free and this guide starts where it stops.

What follows assumes all of it and asks a narrower question: not what the numbers mean, but how you find out whether the numbers are true for one specific house.

That’s the preview — the full guide continues from here.

Unlock the rest of “Underwriting a Rental: The Deal Analysis Playbook” for $4.99, yours to read for good.

Better value

Or get this and everything else for $9.99/mo

All-Access unlocks every guide on the site, the Deal Workspace, and unlimited saved calculations. Cancel anytime.

Compare plans →

Run the numbers

Rental Property Deal Analyzer

Works a rental the way an underwriter does: gross rent through vacancy to collected income, operating expenses to net operating income, and only then the mortgage — so cap rate describes the property and cash flow describes your deal on it. Management is charged on rent actually collected rather than on the lease amount, the capital reserve is its own line instead of being buried in maintenance, and a sanity panel checks your expense ratio against the 35-55% range while flagging a missing reserve, a zero vacancy assumption, or an unpriced management fee. Closes with the rent you'd need to break even and the price that would deliver the cap rate you're actually targeting.

View template — $9.99

Sources & citations

  1. 1.boe.ca.gov
  2. 2.michigan.gov
  3. 3.flsenate.gov
  4. 4.freddiemac.com
  5. 5.singlefamily.fanniemae.com
  6. 6.census.gov
  7. 7.nachi.org
  8. 8.homeadvisor.com
  9. 9.homeadvisor.com
  10. 10.homeadvisor.com
  11. 11.homeadvisor.com
  12. 12.homeadvisor.com
  13. 13.homeadvisor.com
  14. 14.gaor.org
  15. 15.selling-guide.fanniemae.com
  16. 16.ftc.gov
  17. 17.selling-guide.fanniemae.com
  18. 18.irs.gov

This guide is general information, not financial, legal, or tax advice. See /methodology for how the figures cited here are sourced.