A rental property yield worksheet helps you test an investment using the numbers that matter: expected rent, vacancy, operating expenses, financing, repairs, and purchase costs. Use the steps below to estimate gross yield, net yield, and monthly rental property cash flow before making an offer, then revisit the calculation whenever the price, rent, loan terms, or expenses change.
Overview
Yield is a way to compare rental income with the amount invested in a property. It is useful for screening property listings, but it is not a complete investment decision on its own. A property can show an attractive gross yield while producing weak cash flow after taxes, insurance, maintenance, financing, vacancy, and other costs.
Use three related measures:
- Gross rental yield: annual scheduled rent divided by the purchase price. This is a quick first-pass comparison and excludes expenses.
- Net rental yield: annual rental income after operating expenses divided by the total cash invested or another clearly defined property cost. State which denominator you use so comparisons remain consistent.
- Monthly cash flow: rental income actually available each month after vacancy allowance, operating expenses, financing, and recurring reserves. This shows whether the property may require additional cash during normal operations.
Keep the worksheet conservative. Separate recurring costs from one-time purchase costs, and distinguish expenses paid by the landlord from costs that a tenant may pay under the proposed lease. Lease terms, local rules, tax treatment, and lending requirements vary, so confirm important assumptions before relying on the result.
How to estimate rental property yield
Build the worksheet in the following order. Use monthly figures for cash flow and annual figures for yield calculations.
- Estimate market rent. Review comparable rental listings with similar size, condition, location, parking, furnishings, and amenities. Use a realistic achievable rent rather than the highest asking rent you find. If the property is a multi-unit building, calculate rent for each unit separately.
- Allow for vacancy and collection loss. Multiply scheduled annual rent by an assumption for vacant periods, turnover, late payment, or uncollected rent. Do not treat a property as fully occupied every month unless your analysis clearly labels that as an optimistic scenario.
- List operating expenses. Include property taxes or equivalent charges, insurance, utilities paid by the owner, routine maintenance, repairs, landscaping, cleaning, pest control, licensing or compliance costs, association fees, advertising, accounting, and property management where applicable.
- Add replacement reserves. Set aside a monthly amount for larger items such as appliances, flooring, heating or cooling equipment, roofing, exterior work, and furnishings. A reserve is not always a current bill, but omitting it can make cash flow look stronger than it is over the ownership period.
- Calculate financing. Record the loan amount, interest rate, repayment period, and required monthly payment. Keep principal and interest visible separately if you want to understand both cash flow and the reduction in loan balance.
- Include one-time costs. Add the deposit or down payment, purchase taxes or transfer charges, legal or conveyancing fees, inspection, valuation, loan fees, immediate repairs, furnishing, and initial utility or setup costs.
- Run at least three scenarios. Compare a cautious case, a base case, and an upside case. Change rent, vacancy, repairs, interest rate, and purchase price rather than changing every input without explanation.
Core formulas:
- Gross yield = annual scheduled rent ÷ purchase price × 100.
- Net operating income = collected rent − operating expenses − replacement reserve.
- Net yield = net operating income ÷ chosen investment basis × 100.
- Monthly cash flow = monthly collected rent − monthly operating expenses − monthly reserve − monthly debt payment.
Inputs and assumptions
Use a worksheet with one row for each income or expense item. The following layout keeps commonly missed costs visible:
| Category | Worksheet input | How to handle it |
|---|---|---|
| Income | Monthly rent per unit | Use comparable properties and note whether utilities or furnishings are included. |
| Income adjustment | Vacancy and collection allowance | Apply a stated percentage or estimated vacant months to scheduled rent. |
| Operating costs | Taxes, insurance, utilities, association fees | Use available property documents or written estimates; verify billing frequency. |
| Maintenance | Routine repairs and replacement reserve | Separate small recurring work from longer-term replacements. |
| Management | Management, leasing, advertising, and accounting | Include the cost even if you plan to self-manage; it represents the value of the work and allows fair comparisons. |
| Financing | Loan amount, rate, term, and payment | Use the proposed loan terms rather than a generic mortgage assumption. |
| Acquisition | Deposit, closing costs, immediate repairs, and furnishing | Show these separately from recurring expenses and include them in cash required to buy. |
Be precise about the denominator. If you calculate yield on purchase price, the result is easy to compare across listings but does not show how much cash you personally need. If you calculate yield on total cash invested, include the deposit and eligible acquisition costs, and label the method clearly. A financed property may also have a different cash-on-cash return from its unleveraged net yield because borrowing changes both the cash invested and the monthly obligations.
Tax treatment deserves separate review. Rental income, deductible expenses, depreciation, interest, capital improvements, sale proceeds, and local property charges may be treated differently depending on jurisdiction and ownership structure. Do not treat a yield worksheet as a tax calculation. Use it to identify questions for a qualified local tax or property professional.
Worked examples
Assume a property has a purchase price of 200,000 in the currency relevant to your market and expected rent of 1,600 per month. Scheduled annual rent is therefore 19,200. The gross yield is:
19,200 ÷ 200,000 × 100 = 9.6% gross yield.
Now assume a 5% vacancy and collection allowance, or 960 annually. Collected rent becomes 18,240. Suppose annual operating expenses are 4,800 and the replacement reserve is 1,200. Net operating income is:
18,240 − 4,800 − 1,200 = 12,240.
Using the purchase price as the denominator, the net yield is 12,240 ÷ 200,000 × 100 = 6.12%. If the loan payment is 800 per month, annual debt service is 9,600. Estimated cash flow before tax is:
12,240 − 9,600 = 2,640 per year, or 220 per month.
This example shows why gross yield should not be the only screening measure. If rent falls to 1,450 per month, the property has a longer vacancy, or a major repair occurs, the monthly result may change substantially. Create a comparison table before making an offer:
| Measure | Base case | Cautious case | What it tells you |
|---|---|---|---|
| Monthly scheduled rent | 1,600 | 1,450 | Tests rent sensitivity. |
| Vacancy allowance | 5% | Higher stated allowance | Tests occupancy and collection risk. |
| Annual operating costs | 4,800 | Higher stated costs | Tests repairs, taxes, insurance, and services. |
| Monthly cash flow | 220 before tax | Recalculate from revised inputs | Shows how much margin remains after financing. |
Do not compare two rental property listings unless both worksheets use the same definitions. One listing may quote gross yield, while another may include management, taxes, or financing. Rebuild each estimate from the underlying rent and expense inputs.
When to recalculate
Revisit the worksheet whenever a key input changes. Before submitting or revising an offer, update the purchase price, expected rent, vacancy assumption, insurance quote, taxes or local charges, association fees, repair estimates, furnishing budget, and loan terms. A change in interest rate or required deposit can alter monthly cash flow even when the property and rent remain unchanged.
Recalculate after inspecting the property, receiving contractor estimates, reviewing leases, or learning that an owner-paid utility or service was omitted. Recheck the figures before renewal or refinancing, after a major repair, and whenever market rents or operating costs shift enough to affect the decision.
For practical use, save a dated version of each worksheet and record the source of every important input. Flag assumptions that still need confirmation. If the cautious case produces unacceptable cash flow, treat that as a decision warning rather than relying on the base case. A rental yield calculator is most useful when it makes uncertainty visible, lets you compare property listings consistently, and helps you decide what must be verified before committing funds.
