Rental Property Analysis Example: A Complete Deal Breakdown

Scenario overview and underwriting assumptions

Assume an investor is reviewing a fictional single-family rental offered for $325,000. The property is expected to rent for $3,200 per month and produce another $100 from a separately documented parking arrangement. The analysis asks whether the expected property operations can cover normal expenses and scheduled debt service, and how much cash remains relative to the capital committed at acquisition.

The numbers are an educational example, not a listing, appraisal, forecast, or representation of an actual investment. Rent, vacancy, tax, insurance, repairs, financing, and resale value would all need independent verification. The example deliberately includes management, maintenance, capital expenditures, association dues, and other expenses so the apparent rent is not mistaken for cash flow.

Utilities are entered as zero because the scenario assumes tenants pay them directly. Zero is still an explicit assumption, not proof that no owner-paid service exists. Before relying on it, an analyst would check the lease, utility accounts, local billing rules, and any common-area service. The same discipline applies to each line: replace a convenient estimate with a documented figure as diligence progresses.

Step 1: Move from scheduled income to effective income

Scheduled income is the starting point, not the expected collection. Monthly rent and other income total $3,300. Annualizing that amount produces $39,600 of gross scheduled income. This keeps the model transparent: twelve months of rent are visible before any allowance is applied.

A 5% allowance removes $1,980.00 from scheduled income. The calculator applies vacancy to both rent and other scheduled income, producing effective gross income of $37,620.00. That convention must remain consistent when comparing the example with another model; applying vacancy only to rent would produce a slightly different result.

This allowance does not predict the exact days a unit will be empty. It is a planning estimate for noncollection and turnover over a full year. A current tenant, recent lease renewal, or full occupancy on the inspection date does not eliminate future vacancy risk. Conversely, a vacant property may stabilize faster than the annual assumption suggests. The useful question is whether the selected rate is supported by the property, lease history, tenant profile, and realistic turn time.

Step 2: Build operating expenses and NOI

Operating expenses describe the cost of producing rental income before financing. Fixed annual items are $4,200 of property tax and $1,800 of insurance. Monthly HOA and other costs add $1,800 per year. Management, maintenance, and capital expenditures are calculated from effective gross income, not from the purchase price or loan balance.

NOI is $23,048.40. The $1,580.96 monthly mortgage payment is not inside operating expenses and is not subtracted when calculating NOI. That separation allows the property’s operations to be compared independently of this investor’s financing. It also prevents debt service from being counted twice when cash flow is calculated next.

The percentage allowances are not promises that repairs arrive evenly. Actual maintenance may be quiet for months and then exceed the annual allowance in one event. Capital expenditures likewise represent planning for longer-lived items rather than a forecast of a specific replacement date. The analyst should inspect the roof, mechanical systems, structure, drainage, and interiors and adjust these assumptions for known work.

Step 3: Add financing, cash flow, and return metrics

The 25% down payment equals $81,250, leaving a $243,750 loan. At 6.75% for 30 years, the calculator produces monthly principal and interest of $1,580.96 and annual debt service of $18,971.49. These are financing figures, not operating expenses.

Initial cash investment is $103,000: $81,250 down, $9,750 closing costs, and $12,000 of repairs. It excludes optional reserves, inspection expenses, and financing charges that are not inputs in this calculator. A real capital plan should still budget those items separately.

The result is positive on the modeled assumptions, but each metric answers a different question. NOI describes operations. Cap rate compares NOI with price before financing. Cash flow subtracts the loan payment. Cash-on-cash return compares that cash flow with initial cash. A favorable sign in one row cannot erase a thin cushion, a high capital requirement, or unsupported assumptions elsewhere.

Sensitivity: reduce monthly rent by $200

A sensitivity test is most useful when it changes one important input and leaves the rest of the model intact. Here monthly rent falls from $3,200 to $3,000. Other income, vacancy percentage, operating-cost assumptions, purchase terms, and financing stay unchanged. Because management, maintenance, and CapEx are percentages of effective income, those expenses also adjust automatically rather than remaining artificially fixed.

The mortgage does not change when rent changes, so the entire reduction in NOI ultimately reduces cash flow. Variable expense allowances soften the decline slightly, but that is not a benefit to assume casually: lower maintenance spending may be unrealistic if the building still needs the same work. The comparison shows how a modest revenue miss can consume a meaningful portion of the modeled cushion.

Interpret the deal without turning one metric into a verdict

The base case suggests that estimated income covers the listed operating expenses and scheduled mortgage payment. It does not show that every bill will arrive evenly or that the remaining monthly average is available for distribution. Repairs, deductibles, leasing costs, legal compliance, accounting, and reserve funding can create cash needs outside the simplified model. The educational cap rate also says nothing about loan risk, while cash-on-cash return does not include appreciation, principal paydown, income tax, or sale proceeds.

Before a decision, verify market rent with relevant comparables and executed leases; review tax records and reassessment rules; obtain an insurance quote that matches the intended use; read HOA documents; inspect major systems; confirm utility responsibility; and compare lender terms with the assumed rate and amortization. A reserve plan should reflect the property’s actual condition rather than the percentage used here.

It is also worth comparing the property with alternative financing and operating cases. A larger down payment may improve cash flow but requires more capital. Self-management may remove a fee but adds labor and execution risk. Lower vacancy may improve results but must be supported rather than selected to reach a target. Each change has an operational consequence beyond the spreadsheet.

The practical conclusion is conditional: under the stated inputs the property produces positive modeled cash flow, while the lower-rent case narrows that outcome. That combination is a reason to investigate the supporting evidence and resilience of the assumptions, not a categorical instruction to buy or reject the property.