A rental property can look attractive at a glance and still produce weak returns after vacancy, repairs, taxes, insurance, management, financing, and major replacements are included. This worksheet gives you a repeatable way to estimate gross yield, net operating income, rental property cash flow, and cash-on-cash return so you can compare investment homes using consistent assumptions.
Overview
Rental property analysis is less about finding one perfect number and more about making the important assumptions visible. Asking rent alone does not tell you whether a property is likely to work as an investment. You also need to estimate how much of the rent will be collected, how often the property may be vacant, what it will cost to operate, and how much cash you will have invested.
Use three complementary measures:
- Gross rental yield: annual scheduled rent divided by the property purchase price. It is quick, but it ignores expenses and financing.
- Net operating income (NOI): rental income after operating expenses, before mortgage payments and income taxes. This helps compare properties independently of the loan structure.
- Cash-on-cash return: annual cash flow after financing divided by the cash invested. This reflects the effect of your deposit, purchase costs, improvements, and financing.
No single metric should decide a purchase. A property with a higher gross yield may have greater maintenance needs, weaker demand, higher insurance costs, or more volatile occupancy. For a broader comparison, pair this worksheet with a rental property cash flow and yield guide and review the local market evidence before relying on an asking rent.
How to estimate rental property yield and cash flow
Work through the calculation in the same order for every property. Keep annual and monthly figures separate until the final check; mixing them is a common source of errors.
1. Estimate realistic gross income
Start with market rent supported by comparable listings, recently leased properties, property managers, or other credible local sources. Multiply monthly rent by 12 to calculate scheduled annual rent. If the property has parking, storage, laundry, or other income, list those items separately rather than assuming they will always be received.
Then subtract a vacancy and collection allowance. For example:
Effective gross income = scheduled rent + other income − vacancy and collection loss
Use a conservative assumption when the rent estimate is uncertain. Do not base the calculation only on the highest advertised listing in the area.
2. Subtract operating expenses
Operating expenses are costs required to own and operate the property, excluding mortgage principal and interest. Common categories include property taxes, insurance, routine repairs, maintenance, utilities paid by the owner, landscaping, pest control, licenses, accounting, advertising, management, and a reserve for capital expenditures.
NOI = effective gross income − operating expenses
Capital expenditures, such as a roof, heating system, exterior work, or appliance replacement, may not occur every year. They still belong in a long-term analysis. You can record an annual reserve based on the property’s age, condition, and expected replacement schedule, while separately noting any immediate work required before leasing.
3. Calculate the main return measures
Use these formulas:
- Gross yield = annual scheduled rent ÷ purchase price × 100
- Net yield = annual NOI ÷ total acquisition cost × 100
- Annual cash flow = NOI − annual debt service − other recurring cash costs not already included
- Cash-on-cash return = annual pre-tax cash flow ÷ total cash invested × 100
Total acquisition cost may include the purchase price, legal or conveyancing costs, inspection, taxes or duties where applicable, loan fees, and immediate improvements. Total cash invested generally includes the deposit, acquisition costs, initial repairs, furnishing, and any required reserve. The exact categories depend on your location and ownership structure, so confirm local tax and legal treatment with a qualified professional.
Inputs and assumptions worksheet
Copy the following headings into a spreadsheet or notes document. Record the source and date for every estimate.
| Input | What to enter | Why it matters |
|---|---|---|
| Purchase price | Agreed or expected price | Used in yield and total-cost calculations |
| Monthly market rent | Supportable achievable rent | Drives gross income |
| Other income | Parking, storage, or similar income | Should be separated from base rent |
| Vacancy and collection allowance | Percentage or annual amount | Accounts for empty periods and unpaid rent |
| Taxes and insurance | Annual confirmed or estimated amounts | Often varies by property and location |
| Repairs and maintenance | Annual allowance | Prevents optimistic cash-flow estimates |
| Management and leasing | Fees or self-management cost | Shows the cost of professional management or your time |
| Capital expenditure reserve | Annual replacement allowance | Accounts for large, infrequent repairs |
| Financing | Loan amount, rate, term, and payment | Determines debt service and cash flow |
| Initial cash invested | Deposit plus costs and improvements | Denominator for cash-on-cash return |
Build three columns for conservative, expected, and optimistic assumptions. The conservative case might use lower rent, more vacancy, higher repairs, and a higher borrowing cost. The optimistic case should still be plausible; it is not a justification for ignoring known defects or unusually favorable temporary conditions.
Worked example using illustrative assumptions
Consider an investment home with an illustrative purchase price of $300,000 and monthly rent of $2,400. The figures below are examples for demonstrating the method, not a market forecast or a recommended benchmark.
- Scheduled annual rent: $2,400 × 12 = $28,800
- Vacancy and collection allowance: 5% of scheduled rent = $1,440
- Effective gross income: $28,800 − $1,440 = $27,360
- Operating expenses, including taxes, insurance, maintenance, management, and capital reserves: $9,360
- NOI: $27,360 − $9,360 = $18,000
The gross rental yield is $28,800 ÷ $300,000, or 9.6%. If acquisition costs and immediate work bring total acquisition cost to $315,000, the net yield is $18,000 ÷ $315,000, or approximately 5.7%. This difference shows why gross yield should be treated as a screening measure rather than a final return figure.
Suppose the loan’s annual debt service is $13,200 and the investor’s total cash invested is $85,000. Annual pre-tax cash flow would be $18,000 − $13,200 = $4,800. Cash-on-cash return would be $4,800 ÷ $85,000, or approximately 5.6%.
Now test the downside case. If rent is lower than expected, vacancy rises, and repairs increase by a combined $3,000 annually, NOI falls to $15,000. With the same debt service, cash flow falls to $1,800, and cash-on-cash return falls to approximately 2.1%. This sensitivity test may be more useful than the original headline yield because it shows how much room the deal has before cash flow becomes weak or negative.
For additional purchase-cost context, compare the property with other homes using the home listing comparison worksheet. For financing assumptions, review a mortgage and affordability guide, then replace general estimates with lender-specific terms.
When to recalculate
Recalculate the worksheet before making an offer, whenever the rent or financing changes, and after inspection reveals new work. A small change in monthly rent can affect annual income, vacancy loss, management fees, and the final return. A change in the interest rate or loan amount can materially alter cash flow even when the property itself has not changed.
Review the numbers at least annually during ownership. Replace estimates with actual rent collected, vacancy, repairs, insurance, taxes, management fees, and capital spending. Compare actual performance with the original conservative and expected cases. If insurance renews at a different cost, taxes are reassessed, a major system ages, or local rental demand shifts, update the model rather than relying on the original listing analysis.
Before proceeding, complete these actions:
- Verify achievable rent with several current local references.
- Request written estimates for taxes, insurance, financing, and management where possible.
- Inspect the property and list immediate repairs separately from annual reserves.
- Run conservative, expected, and optimistic cases in the same spreadsheet.
- Check whether the conservative case still fits your cash and risk limits.
- Save the assumptions and revisit them after every major price, rent, rate, or expense change.
A rental yield calculator is most useful when it exposes uncertainty. Treat the result as an underwriting aid, not a guarantee of return, and obtain local legal, tax, insurance, and lending advice before committing capital.