Rental-property analysis in plain English
A rental-property analysis organizes what the property earns, what it costs to operate, what financing costs, how much cash is invested, what physical and legal risks remain, and how the answer changes when assumptions change.
Step 1: Define the property and legal unit count
Confirm the address, parcel, recognized use, lawful unit count, occupied units, vacant units, commercial space, parking, storage, laundry, and other income-producing areas. Do not let an advertised bedroom or unit count replace zoning, permit, certificate, lease, and local-record review.
Step 2: Verify rental income
Start with signed leases, amendments, rent roll, tenant ledgers, bank deposits, management reports, and current collection history. Separate scheduled rent, billed rent, collected rent, concessions, unpaid balances, deposits, and other income.
Fannie Mae’s multifamily income-analysis framework starts with actual rents in place for occupied units and market-supported treatment for vacant units, illustrating why current records and market support matter rather than one headline total.
Step 3: Estimate vacancy and bad debt separately
Vacancy is income lost because a unit is not occupied. Bad debt or collection loss is billed income that is not collected. They can happen for different reasons and should not be blended without explanation. Use property history, current occupancy, lease expirations, unit condition, local market evidence, and professional input.
Step 4: Verify other income
Laundry, parking, storage, pet fees, utility reimbursements, application charges, and other income require records. Confirm that the income is lawful, recurring, supported by leases or policies, collected, and likely to continue. Do not count tenant deposits as operating income.
Step 5: Verify operating expenses
Review property taxes, insurance, utilities, management, repairs and maintenance, landscaping, pest control, trash, accounting, legal, licenses, payroll, common-area costs, and recurring services. Compare seller statements with source documents and current quotes using the operating-expenses guide.
Step 6: Calculate NOI conceptually
Effective gross income − operating expenses = net operating income.
Fannie Mae defines NOI as effective gross income minus operating expenses. NOI does not include mortgage principal and interest. It also should not be treated as the same thing as cash flow, taxable income, appreciation, or profit.
Step 7: Separate capital expenditures and reserves
A roof replacement, major plumbing project, broad electrical upgrade, paving replacement, or large HVAC project may not belong in ordinary recurring expenses. Build a separate capital plan and reserve plan using condition, scope, timing, estimates, lender requirements, and the reserves-and-capex guide.
Step 8: Review financing and debt service
Record the loan amount, interest rate, amortization, term, points, fees, reserves, insurance requirements, repair escrows, and annual debt service. The lender determines underwriting and final loan terms. A working analysis should be updated when the lender’s terms change.
Step 9: Calculate cash flow conceptually
NOI − debt service − separately planned cash items = working cash-flow estimate.
Owners may also plan for capital spending, reserves, asset-management costs, income taxes, and other items outside a simple NOI calculation. Label the model clearly so the reader knows what is included and excluded.
Step 10: Review cash invested and closing costs
Cash invested may include down payment, lender fees, points, title and closing charges, inspections, appraisal, legal and accounting costs, immediate repairs, initial reserves, utility or insurance deposits, and other transaction-specific amounts. Cash-on-cash return depends on how cash invested and cash flow are defined.
Cap rate vs. cash-on-cash return
| Metric | What it generally compares | What it does not answer alone |
|---|---|---|
| Cap rate | NOI compared with property value or price | Financing, total cash invested, future capex, or personal tax result |
| Cash-on-cash return | Annual pre-tax cash flow compared with cash invested | Appraised value, appreciation, legal risk, system condition, or final profit |
| DSCR | Underwritten property cash flow compared with debt service | Buyer liquidity, full condition risk, legal-unit status, or future refinance |
| Cash flow | Money remaining after defined inflows and outflows | Whether every future cost or risk has been captured |
Sensitivity and scenario testing
Build more than one case. A base case may use supported current expectations. A cautious case may test lower collection, longer vacancy, higher taxes or insurance, repair surprises, larger reserves, or different financing. An upside case should still require support.
Condition, insurance, tax, utility, tenant, permit, and legal review
The spreadsheet does not replace physical and legal due diligence. Review tenant records, security deposits, utility setup, permits, recognized use, insurance, taxes, inspection findings, repair estimates, and professional conclusions. A positive number does not erase a weak lease file, unrecognized unit, failing system, insurance problem, or financing condition.
Fact vs. estimate vs. assumption
| Type | Example | How to handle it |
|---|---|---|
| Verified fact | Current signed lease, paid tax bill, insurance quote, lender term sheet | Record source, date, and limits |
| Estimate | Contractor scope, appraiser opinion, projected utility cost | Identify professional, assumptions, exclusions, and date |
| Working assumption | Future vacancy, renewal rent, reserve funding, repair timing | Label clearly and test alternate scenarios |
| Unknown | Unverified unit, missing lease, unclear insurance eligibility | Do not quietly convert it into a favorable assumption |
Rental-property analysis framework
| Step | Question | Source |
|---|---|---|
| 1. Define | What property and legal income-producing units exist? | Local records, permits, leases, site review |
| 2. Verify income | What is scheduled, billed, collected, and recurring? | Rent roll, leases, ledgers, bank and manager records |
| 3. Verify expenses | What does operation realistically cost? | Bills, contracts, taxes, insurance, invoices, quotes |
| 4. Separate capital | What major work and reserve funding remain? | Condition reports, scopes, estimates, lender requirements |
| 5. Add financing | What debt service, fees, escrows, and conditions apply? | Lender terms and closing documents |
| 6. Test | What happens when important assumptions change? | Base, cautious, and supported upside scenarios |
| 7. Decide calmly | Are the return, risks, liquidity, and professional findings acceptable? | Complete due-diligence file and buyer judgment |
Buyer and investor due-diligence checklist
- Confirm legal unit count, recognized use, occupancy, and all income-producing areas.
- Verify leases, rent roll, ledgers, deposits, collections, concessions, vacancy, and bad debt.
- Verify taxes, insurance, utilities, management, maintenance, and recurring expenses.
- Separate operating expenses from capital expenditures and reserves.
- Record lender terms, debt service, repair escrows, and required reserves.
- Calculate NOI and cash flow as separate figures.
- Define exactly what cash invested includes.
- Use cap rate, cash-on-cash return, DSCR, and cash flow as separate tools.
- Label facts, estimates, assumptions, and unknowns.
- Test a cautious scenario before deciding.
- Update the analysis when leases, taxes, insurance, condition, financing, or professional findings change.
Professional questions to ask
- Lender: What income, expenses, reserves, loan terms, and DSCR standards will underwriting use?
- Appraiser: What income, expense, market, legal-use, and condition evidence supports value?
- CPA: How should income, expenses, depreciation, repairs, improvements, and taxes be treated?
- Attorney: What lease, title, unit-status, contract, tenant, or legal obligations affect the analysis?
- Property manager: What rents, vacancy, collections, expenses, staffing, and maintenance are realistic?
- Insurance professional: What current coverage, premium, deductible, and eligibility apply?
- Contractor, inspector, or engineer: What condition, scope, timing, and cost questions remain?
- Title or closing professional: What closing costs, assessments, escrows, credits, and transfer records apply?
