A rental property can appear profitable until vacancy, repairs, financing, and other ownership costs are included. This guide provides a repeatable rental property cash flow worksheet, explains the main return measures, and walks through an illustrative analysis you can update whenever rent, expenses, or loan terms change.
Overview
Rental property analysis starts with a simple question: after collecting rent and paying the property’s operating and financing costs, how much money remains? The answer is your projected cash flow. A useful analysis goes further by showing how much capital is invested and how efficiently that capital performs.
Three measures are especially useful:
- Net operating income (NOI): rental income and other property income minus operating expenses, before mortgage payments and income taxes.
- Cash flow: NOI minus debt service and any additional cash expenses. This estimates the money left before personal income taxes and unplanned costs not included in the worksheet.
- Cash-on-cash return: annual pre-tax cash flow divided by the total cash invested. This helps compare properties that require different down payments or upfront budgets.
Cap rate is another comparison tool: NOI divided by the property purchase price or current value, depending on the purpose of the analysis. It excludes financing, so it should not be treated as the same thing as an investor’s actual cash return. For a broader explanation of comparing property income, see Rental Yield Explained.
A positive result is not automatically a good investment. Check whether the assumptions are realistic, whether the property fits your risk tolerance, and whether you have reserves for vacancies, major repairs, and changes in financing costs.
How to estimate rental property cash flow
Use a monthly worksheet first, then multiply the recurring figures by 12. Keeping income and expenses in the same time frame reduces calculation errors.
- Estimate gross scheduled rent. Start with the expected monthly rent at normal occupancy and multiply by 12. Add other recurring income only when it is reasonably supported, such as a parking fee or storage charge.
- Subtract vacancy and collection loss. Instead of assuming the property is occupied every month, apply a vacancy allowance. You can also include an allowance for late or uncollected rent if that is relevant to your situation.
- Calculate effective gross income. Gross scheduled rent plus other income, less vacancy and collection loss, equals effective gross income.
- List operating expenses. Include property taxes, insurance, utilities paid by the owner, routine maintenance, landscaping, cleaning, advertising, accounting, association dues, and property management if applicable.
- Reserve for capital expenses. Set aside a separate amount for less frequent replacements, such as a roof, heating or cooling equipment, appliances, flooring, or exterior work. This reserve is not always a current bill, but excluding it can make cash flow look too strong.
- Subtract operating costs from effective gross income. The result is NOI. Keep mortgage principal and interest out of this step so you can compare the property itself independently from its financing.
- Subtract annual debt service. Include scheduled principal and interest payments, and account for mortgage insurance or loan-related charges when applicable.
- Calculate annual cash flow and returns. Annual NOI minus annual debt service and other cash expenses produces projected pre-tax cash flow. Divide that figure by total cash invested to estimate cash-on-cash return.
Basic formulas:
Effective gross income = gross rent + other income − vacancy and collection loss
NOI = effective gross income − operating expenses
Cash flow = NOI − annual debt service − additional cash expenses
Cap rate = NOI ÷ property price or value
Cash-on-cash return = annual pre-tax cash flow ÷ total cash invested
Inputs and assumptions
Record each input separately rather than entering one broad “expenses” estimate. A detailed worksheet makes it easier to identify which assumption is driving the result.
| Input | What to include | Why it matters |
|---|---|---|
| Rent | Expected market rent, lease incentives, and recurring additional income | Sets the top line of the analysis |
| Vacancy | Periods without a paying tenant and likely collection loss | Prevents a full-occupancy assumption from overstating income |
| Maintenance | Routine repairs, service calls, landscaping, and cleaning | Captures ordinary ownership costs |
| Management | Management fees, leasing fees, and renewal charges | Shows the cost of professional management or a realistic value for your time |
| Taxes and insurance | Current property tax and insurance estimates, subject to local verification | These can materially change the operating result |
| Capital expenses | Planned reserves for major systems and replacements | Helps account for irregular but predictable costs |
| Financing | Loan amount, interest rate, term, monthly payment, and lender charges | Determines debt service and the cash required upfront |
| Cash invested | Down payment, closing costs, initial repairs, furnishing, and starting reserves | Provides the denominator for cash-on-cash return |
Separate fixed costs from variable costs where possible. Property taxes, insurance, and association dues may be relatively predictable but can change. Repairs, turnover, utilities, and vacancy are less certain. It is useful to build at least three cases: a conservative case, a base case, and an optimistic case. Change only assumptions you can explain; do not make every input favorable at the same time.
Do not mix operating performance with tax benefits, appreciation, or future refinancing proceeds. Those may affect an investment decision, but they are different from recurring rental cash flow. For a complete purchase budget, also account for acquisition costs and initial work before calculating return.
Worked example
The following figures are illustrative assumptions, not a market forecast or recommendation. Suppose a property is expected to rent for $2,400 per month, with no other income. Annual scheduled rent is therefore $28,800.
Assume a 5% vacancy and collection allowance, or $1,440. Effective gross income is $27,360. The annual operating worksheet might look like this:
- Property taxes: $3,600
- Insurance: $1,800
- Routine maintenance: $1,800
- Management and leasing: $2,736
- Utilities and association costs: $1,200
- Capital expense reserve: $2,000
Total listed expenses are $13,136, producing an estimated NOI of $14,224. If the purchase price is $240,000, the illustrative cap rate is approximately 5.9% ($14,224 divided by $240,000). This is a property-level measure before financing.
Now assume annual mortgage principal and interest totals $10,800. Estimated pre-tax cash flow is $3,424. If the investor’s total cash invested is $72,000—including the down payment, closing costs, initial repairs, and starting reserves—the projected cash-on-cash return is approximately 4.8%.
The example also shows why a rental yield calculator should display its assumptions. Removing the capital expense reserve would increase apparent cash flow, but it would not remove the likelihood of future replacement costs. Likewise, a higher rent assumption may be offset by higher vacancy, turnover, or management costs. Test the property at several rent and expense levels instead of relying on one headline return.
When to recalculate
Revisit the worksheet whenever an input changes materially or whenever you are making a new investment decision. Recalculate before submitting an offer, after receiving a lender’s terms, and after verifying taxes, insurance, association dues, and expected rent.
For a property you already own, update the analysis when the lease renews, rent changes, insurance is repriced, taxes are reassessed, management terms change, or a major repair is completed. Review actual income and expenses against the original assumptions at least periodically so the next forecast reflects the property’s experience rather than an outdated estimate.
Before relying on the result, run a downside case with more vacancy, higher repairs, and a different financing cost. Confirm local requirements and obtain professional tax, legal, insurance, and lending advice where appropriate. The worksheet is a decision aid, not a guarantee of income or return.
To use this guide on your next listing or investment property, copy the inputs into a spreadsheet, label every assumption with its date and source, calculate NOI and cash flow separately, and save conservative, base, and optimistic versions. That process makes it easier to compare property listings fairly and to update the analysis as market conditions and ownership costs change.
