Use this rental property ROI template to turn an asking price, rent estimate, financing quote, and expense budget into a repeatable investment decision. The workflow below shows how to calculate gross yield, net yield, cap rate, cash-on-cash return, monthly cash flow, and break-even rent without relying on optimistic assumptions.
Overview
A property can look attractive because the rent appears high, but rental income is only one part of the result. Vacancy, repairs, insurance, taxes, management, utilities, financing, and purchase costs can materially change the outcome. A useful investment property calculator should therefore show several measures rather than a single return percentage.
Start with a spreadsheet containing these columns or tabs:
- Property: asking price, closing costs, initial repairs, furnishing, and total cash invested.
- Income: market rent, other income, vacancy, and effective annual income.
- Operating expenses: taxes, insurance, maintenance, management, utilities, association fees, licensing, and reserves.
- Financing: loan amount, interest rate, term, monthly payment, and annual debt service.
- Returns: gross yield, net operating income, cap rate, cash-on-cash return, cash flow, and break-even rent.
- Scenarios: cash purchase and multiple loan-to-value, or LTV, cases.
Keep property performance separate from financing performance. Cap rate evaluates the property before debt payments, while cash-on-cash return evaluates the cash invested after financing. This distinction makes it easier to compare the same property under different loan structures.
How to estimate rental yield and ROI
1. Estimate realistic annual income
Begin with expected monthly rent, not the highest advertised rent for a nearby property. Compare similar rental listings by location, size, condition, parking, amenities, and lease terms. A neighborhood comparison can also reveal whether the property competes with apartments for rent, houses for rent, or newer owner-listed homes.
Use this formula:
Potential gross income = monthly rent × 12 + other annual income
Then allow for vacancy and collection loss:
Effective gross income = potential gross income − vacancy and collection allowance
For a cautious first pass, model vacancy as a percentage of potential rent. Do not treat that percentage as a universal fact; replace it with a locally informed assumption based on comparable rentals, lease-up time, and the property’s condition.
2. Build the full expense budget
List fixed bills separately from variable costs. Typical lines include property taxes, insurance, association or service fees, routine maintenance, larger replacement reserves, management, utilities paid by the owner, landscaping, pest control, accounting, licensing, advertising, and legal or administrative costs.
For each uncertain item, create a low, expected, and high estimate. Maintenance is particularly easy to understate when the property is older or has major systems approaching replacement. Include a reserve even if no repair is due immediately.
Net operating income (NOI) = effective gross income − operating expenses
NOI excludes loan principal and interest. It is used for cap rate because cap rate is intended to describe the property’s operating performance before financing.
3. Apply the core formulas
- Gross yield = annual potential gross income ÷ total acquisition cost × 100
- Net yield = annual NOI ÷ total acquisition cost × 100
- Cap rate = annual NOI ÷ purchase price or agreed valuation × 100
- Annual cash flow = NOI − annual debt service
- Cash-on-cash return = annual cash flow ÷ total cash invested × 100
Define your denominator consistently. Total acquisition cost may include the purchase price, transfer charges, professional fees, immediate repairs, furnishing, and other costs required to place the property into service. Total cash invested usually includes the down payment plus those upfront costs, less any financing proceeds.
4. Calculate break-even rent
Break-even rent estimates the monthly rent required to cover operating expenses and debt service after allowing for vacancy. If vacancy is represented by v, use:
Break-even monthly rent = (annual operating expenses + annual debt service) ÷ [12 × (1 − v)]
This is a planning measure, not a guarantee. It excludes surprises such as major capital work unless you include a reserve for them, and it does not measure your desired profit or tax position.
Inputs and assumptions for the spreadsheet
Use one input cell for each assumption so you can change a number without rewriting formulas. A simple template might include:
| Input | How to use it |
|---|---|
| Purchase price | Enter the negotiated price, not an initial listing price if the offer changes. |
| Monthly rent | Use supported comparable rents and test a lower-rent case. |
| Vacancy allowance | Enter a percentage based on local evidence and property-specific risk. |
| Operating expenses | Enter actual quotes where available; otherwise use transparent estimates. |
| Down payment or LTV | Run separate cases for cash, lower leverage, and higher leverage. |
| Interest rate and term | Use a written loan quote or a clearly labeled planning assumption. |
| Upfront costs | Include repairs, furnishing, inspections, legal costs, and transaction charges applicable to your location. |
Do not mix operating expenses with capital improvements. A new roof or major renovation may need a separate capital reserve rather than being treated like a recurring monthly bill. Also check whether taxes, insurance, association fees, and utilities are paid by the owner or passed through under the proposed lease.
For a more complete cash flow calculator, add a tax tab only after confirming the applicable rules with a qualified local professional. Accounting treatment can differ by jurisdiction and ownership structure, so the basic ROI model should not be presented as a tax calculation.
Worked examples: cash purchase versus financing
Consider a hypothetical property with a purchase price of 240,000 in the currency used by the investor. Assume monthly rent of 1,800, annual operating expenses of 7,200, and a vacancy allowance of 5%. These numbers are illustrative only and should be replaced with local property listings, quotes, and comparable rentals.
Potential gross income is 1,800 × 12, or 21,600. The vacancy allowance is 1,080, producing effective gross income of 20,520. NOI is therefore 20,520 − 7,200, or 13,320. The gross yield on the purchase price is 9.0%, while the cap rate is 13,320 ÷ 240,000, or 5.55%.
Now compare financing cases. Assume upfront acquisition costs of 12,000 and no initial renovation for this simplified example:
| Scenario | Loan assumption | Cash invested before reserves | What to compare |
|---|---|---|---|
| Cash purchase | No loan | 252,000 | NOI, cap rate, and cash flow before financing |
| Lower-LTV loan | Example: 50% of price | Down payment + 12,000 | Debt service, cash flow, and cash-on-cash return |
| Mid-LTV loan | Example: 70% of price | Down payment + 12,000 | Whether leverage improves return without excessive risk |
| Higher-LTV loan | Example: 80% of price | Down payment + 12,000 | Break-even rent and sensitivity to rate or vacancy changes |
Do not fill in debt service by multiplying the loan balance by the interest rate alone unless you are intentionally modeling interest-only debt. For an amortizing loan, use the lender’s payment figure or a properly configured loan formula. Then subtract annual debt service from NOI to find annual cash flow, and divide that result by cash invested to find cash-on-cash return.
Run at least three rent cases: expected rent, a lower rent, and a stronger rent supported by evidence. Repeat the exercise for vacancy, repairs, and interest rate. A property that works only under the strongest case deserves additional scrutiny.
When to recalculate
Reuse the template for every serious property evaluation. Recalculate when the asking or agreed price changes, a new rent comparable appears, a mortgage quote changes, insurance or taxes are updated, or a major repair is identified. Revisit the model after an inspection, because deferred maintenance can change both the initial cash requirement and the ongoing reserve.
As a maintenance routine, review vacancy and expense assumptions at least annually, and refresh local rental comparables and sample market inputs periodically. Re-run financing scenarios whenever rates move materially or your lender changes fees, term, or underwriting requirements. Keep an archived copy of the original analysis so you can see which assumptions changed.
Before making an offer, print or save a one-page checklist:
- Confirm comparable rents and identify what is included in each listing.
- Verify taxes, insurance, association fees, utilities, and local operating requirements.
- Obtain a property inspection and price known repairs.
- Request current financing terms and calculate annual debt service.
- Run cash, lower-LTV, and higher-LTV scenarios.
- Test lower rent, higher vacancy, higher expenses, and a repair reserve.
- Record gross yield, net yield, cap rate, cash-on-cash return, cash flow, and break-even rent.
- Compare the result with your risk tolerance, liquidity needs, and investment plan.
For related budgeting work, see the rental property income calculator guide and the guide to comparing the true monthly cost of rental listings. The spreadsheet is most useful when it is treated as a living decision tool: update the inputs, preserve the assumptions, and let the revised numbers—not the original asking price—guide the next step.
