Key takeaways
- Start from net operating income, not rent: vacancy, reserves and management fees decide whether a rental works.
- National rental vacancy rose to 7.6% in Q3 2026, so a zero-vacancy pro forma is not credible[1].
- With 30-year rates averaging 7.18% in early November 2026, many rentals that look fine on cap rate lose money after debt service[2].
- Give clients a one-page sheet with cap rate, cash-on-cash return and DSCR, plus the price, rent or down payment that would make the deal work.
Why investor clients need the numbers from you
Individual investors and second-home buyers made up 20% of US existing-home transactions in September 2026[3]. Many are not institutions with analysts. They are a dentist buying a first rental, a couple adding a second door, or a landlord trading up. They will ask you whether a property is a good rental, and a vague answer costs you the client.
You are not giving investment or tax advice. You are giving them a clean, consistent analysis built from market evidence you can show: rents, vacancy, taxes, insurance and realistic financing. Their accountant and lender will confirm the rest. Done well, the analysis also filters out properties early, which saves both of you showings that were never going to pencil.
The four numbers every rental sheet needs
- Net operating income (NOI): effective rent collected minus operating expenses, before any mortgage payment.
- Cap rate: NOI divided by purchase price. It compares properties as if they were bought with cash.
- Cash-on-cash return: annual cash flow after debt service divided by the total cash the client puts in, including closing costs and make-ready work.
- Debt service coverage ratio (DSCR): NOI divided by annual principal and interest. Many investor lenders look for at least 1.0 and often more.
Cap rate tells you whether the property earns its price. Cash-on-cash tells the client what their own money earns. DSCR tells you whether a lender will finance it and whether the property can carry its own loan in a bad month.
Build the income line honestly
Pull at least five rental comparables of the same bed count within a tight radius, leased in the last six months, and note days on market for each. Asking rents overstate what landlords collect, so weight closed leases where your MLS or a local property manager can supply them. Rents are still rising, but slowly: the Zillow Observed Rent Index was up 2.9% year over year in October 2026[4]. Do not assume big rent jumps in year one.
Vacancy is the line most first-time investors leave blank. The US rental vacancy rate climbed from 7.1% in the third quarter of 2025 to 7.6% in the third quarter of 2026[1]. Your local figure may be lower or higher; use it, and add a turnover allowance for the weeks between tenants even in tight markets.
Source: U.S. Census Bureau, 2026[1]
Show the data
| Item | Value |
|---|---|
| Q3 2025 | 7.1% |
| Q3 2026 | 7.6% |
Write the source of every input on the sheet: which leases you used, who supplied the tax estimate, and when the insurance quote was issued. If the client's lender or accountant questions a number, you can show where it came from in seconds, and the client sees that the analysis is evidence, not salesmanship.
Expenses clients forget
- Property tax at the post-sale assessment, not the seller's current bill, where your state reassesses on sale.
- Landlord insurance quote, not the owner-occupant policy the seller carries.
- Repairs and maintenance as a percentage of rent, higher for older homes.
- Capital reserves for roof, HVAC, water heater and flooring, set aside every month.
- Property management fee, even if the client plans to self-manage; their time has a cost and they may hire out later.
- HOA dues and any rental restrictions or registration fees the association or city charges.
- Owner-paid utilities, lawn care and pest control, which are common in single-family rentals.
Ask the seller for the current lease, rent roll, security deposit amounts and 12 months of utility bills before the inspection period ends. A rental analysis built on guesses should be labelled as a guess.
Example: a single-family rental, analyzed
Example (fictional): an investor client is looking at a three-bedroom house listed at $310,000. Comparable leases support $2,350 a month. The table below uses an 8% vacancy and credit-loss allowance, a little above the national rate, and assumes a 25% down investor loan at 7.5%, slightly above the average 30-year rate because investor loans usually price higher.
| Line | Annual amount | How it was set |
|---|---|---|
| Gross scheduled rent | $28,200 | $2,350 x 12 |
| Vacancy and credit loss | -$2,256 | 8% of gross rent |
| Effective gross income | $25,944 | Rent actually expected |
| Property tax | -$3,700 | Post-sale estimate |
| Insurance | -$1,900 | Landlord quote |
| Repairs and maintenance | -$2,256 | 8% of gross rent |
| Capital reserves | -$1,410 | 5% of gross rent |
| Management | -$2,335 | 9% of collected rent |
| Owner-paid services | -$600 | Lawn and pest |
| Net operating income | $13,743 | Before any mortgage |
| Cap rate | 4.4% | $13,743 / $310,000 |
| Debt service | -$19,508 | $232,500 loan, 7.5%, 30 years |
| Annual cash flow | -$5,765 | NOI minus debt service |
| Cash invested | $91,800 | Down payment, closing costs, make-ready |
| Cash-on-cash return | -6.3% | Cash flow / cash invested |
| DSCR | 0.70 | $13,743 / $19,508 |
This is a common result in today's market. The cap rate looks acceptable for an appreciating suburb, but the property cannot carry a 75% loan at current rates. Average 30-year rates were 7.18% on November 5, 2026, up from 6.22% a year earlier[2], and that change alone turns many marginal rentals negative.
Show the levers, not just the verdict
A good analysis does not stop at no. It shows what would make the numbers work so the client can decide whether that is realistic.
Price
Work backwards from the client's target. To break even at the same loan terms, debt service must fall to the NOI, which in this Example means a loan of about $163,800. That is a large gap, so price alone rarely fixes it.
Down payment
In this Example, a much larger down payment makes the property cash flow, but the return falls toward the cap rate. An all-cash purchase earns about 4.2% on $324,300 of total cash before appreciation and tax effects, which some clients prefer to a leveraged loss.
Rent and expenses
Check whether a fourth bedroom, a garage conversion where permitted, or owner-paid utilities moved to the tenant changes NOI. Test only changes that leases in the area actually support.
Rate
Show the same sheet at a rate one point lower so the client sees what refinancing could do, and label it a scenario, not a forecast.
Red flags that should pause the analysis
Some findings make the spreadsheet irrelevant until they are resolved. Flag them to the client in writing as soon as you see them, and do not let a strong cap rate hide them.
- HOA covenants that cap or ban rentals, set minimum lease terms, or require board approval of tenants.
- Local rental registration, inspection or licensing rules the seller has not complied with.
- A tenant in place whose lease, deposit or rent level the seller cannot document.
- Unpermitted bedrooms or units that the rent comparables assume are legal.
- Insurance quotes far above the area norm, which often signal flood, wildfire or claims history.
- Deferred maintenance on the roof, foundation, sewer line or electrical panel that the reserve line cannot absorb.
When a red flag appears, rerun the sheet with a realistic cost to fix it, or drop the property. Investors forgive you for killing a deal early; they do not forgive surprises after closing.
Decision criteria to agree before the search
Agree three thresholds with the client in writing before you send listings: a minimum cap rate, a minimum DSCR, and whether negative cash flow is acceptable in exchange for expected appreciation. Some investors accept a small monthly loss in a strong school district; others want cash flow from day one. Neither is wrong, but you need to know which client you have.
Then screen every candidate with the same template so results are comparable. If a client changes the assumptions to make a property work, note it on the sheet. When they later trade the property, the same discipline helps with timing a 1031 exchange or comparing it with a short-term rental.
A script for the first investor conversation
Try: 'Before I send you anything, let me ask three questions. What cap rate do you need, what is the most you would put down, and would you hold a property that loses a little each month if it is in a strong location? I will run every listing through the same sheet so you can compare them side by side.'
Clients remember the agent who saved them from a bad rental. Keep each sheet in the client's file and update it when the lease, insurance quote or rate changes. For more on serving this group, see working with investor buyers and our guide to small multifamily properties.
Frequently asked questions
What is a good cap rate for a rental property?
It depends on the market and risk. Lower cap rates are common in expensive, appreciating areas and higher ones in slower or riskier areas. Agree a minimum with your client and compare like with like.
What is the difference between cap rate and cash-on-cash return?
Cap rate measures NOI against the purchase price as if bought with cash. Cash-on-cash measures annual cash flow after the mortgage against the cash the investor actually put in.
Should agents include property management fees if the investor will self-manage?
Yes. It shows the true return of the asset and protects the client if they later hire a manager. You can show a self-managed version as a second scenario.
What vacancy rate should I use?
Use your local rental vacancy data and lease-up times. The national rate was 7.6% in Q3 2026[1], so leaving vacancy at zero is rarely defensible.
References
U.S. Census Bureau (2026). Quarterly Residential Vacancies and Homeownership, Third Quarter 2026 (opens in a new tab) ↑
Freddie Mac (2026). Primary Mortgage Market Survey (PMMS) (opens in a new tab) ↑
National Association of REALTORS® (2026). Existing-Home Sales Increased 1.5% in September, According to NAR Report (opens in a new tab) ↑
Zillow Research (2026). Newly Pending Listings Fell 17% In October (Zillow October 2026 Market Report) (opens in a new tab) ↑