Rental Property Cash Flow Worksheet: How to Evaluate Income, Expenses, and Yield
Use this repeatable rental property cash flow worksheet to estimate income, operating expenses, financing costs, cash-on-cash return, and rental yield before you make an offer or reassess an existing property. The results are planning estimates, not guarantees, but a consistent method can reveal whether a deal still works when rent is lower, vacancy is higher, or repairs are more expensive than expected.
Overview
A rental property can show positive monthly cash flow and still produce a weak return on the cash invested. It can also have an attractive projected yield while carrying risks that a simple rent-minus-mortgage calculation misses. The purpose of this worksheet is to separate the major parts of the analysis so you can compare properties on the same basis.
Start with three questions:
- How much income could the property reasonably produce?
- What will it cost to operate and finance?
- What return remains after setting aside money for vacancy, repairs, and long-term replacements?
Use conservative, property-specific inputs where possible. A listing’s advertised rent is only a starting point. Verify comparable rental listings, ask about included utilities and fees, inspect the property’s condition, and account for local landlord costs before treating an estimate as decision-ready.
How to estimate rental property cash flow
Work through the calculation in the order below. Monthly figures are useful for budgeting, while annual figures make yield and return comparisons easier.
1. Estimate potential rental income
Record the expected monthly rent and multiply it by 12 to calculate potential annual rent. Add other recurring income only when it is reasonably supported, such as documented parking, storage, laundry, or pet-related income. Do not count a security deposit as income.
Next, subtract a vacancy and collection allowance. Even a well-managed property can experience turnover, delayed payments, or periods between tenants. Use an assumption that reflects the property type, tenant demand, lease structure, and your own operating history.
Effective gross income = potential rental income + other income − vacancy and collection allowance
2. List operating expenses
Separate regular operating expenses from financing and major capital improvements. Common operating categories include:
- Property taxes and landlord insurance
- Routine repairs and maintenance
- Property management or leasing fees
- Owner-paid utilities, internet, lawn care, or snow removal
- Homeowners association or condominium fees
- Licensing, inspections, bookkeeping, advertising, and legal costs
- A reserve for capital expenditures, such as a roof, heating system, appliances, or exterior work
Some costs are easy to overlook because they do not arrive every month. A capital reserve converts occasional large bills into a regular planning expense. It is not a guarantee that the reserve will cover every replacement, but excluding it can make cash flow look artificially strong.
Net operating income, or NOI = effective gross income − operating expenses
NOI excludes loan principal and interest, income taxes, and personal accounting choices. This makes it useful for comparing properties before financing differences are introduced.
3. Add financing costs
For a financed purchase, record the monthly principal and interest payment, then add any recurring loan-related costs that are not already included in taxes or insurance. Keep the loan assumptions visible: purchase price, down payment, interest rate, loan term, points or lender fees, and estimated closing costs.
Annual cash flow before income taxes = NOI − annual debt service
This is the amount left after the operating property and loan costs in your worksheet. It is not the same as taxable income, and it does not automatically account for your personal tax position.
Inputs and assumptions worksheet
Copy the following fields into a spreadsheet or notes app for each prospective property. Keep the source or reason for each assumption beside the number so you can update it later.
| Category | Input | Planning question |
|---|---|---|
| Purchase | Price, closing costs, initial repairs | How much cash is required before the first tenant moves in? |
| Income | Monthly rent and other recurring income | What evidence supports the rent assumption? |
| Vacancy | Vacancy and collection allowance | What happens if the property is empty or rent is not collected for a period? |
| Operations | Taxes, insurance, repairs, management, utilities, HOA fees | Which costs are confirmed, estimated, or excluded? |
| Reserves | Capital expenditure allowance | Which major components may need replacement during ownership? |
| Financing | Down payment, rate, term, and debt service | Would the result change materially with a different loan? |
Key return measures
Gross rental yield is a quick screening measure:
Gross rental yield = annual gross rent ÷ purchase price × 100
Because it ignores vacancy, expenses, financing, and acquisition costs, gross yield should not be used alone to choose a property.
Net operating income yield, often called cap rate, uses NOI instead:
NOI yield = annual NOI ÷ property price × 100
Cash-on-cash return measures annual cash flow against the cash invested:
Cash-on-cash return = annual cash flow before income taxes ÷ total cash invested × 100
Total cash invested may include the down payment, closing costs, initial repairs, furnishing, and other funds required to place the property into service. Define this consistently when comparing properties.
Worked examples and sensitivity checks
Consider a hypothetical property with monthly rent of $2,000. Annual potential rent is $24,000. Suppose the worksheet uses a 5% vacancy and collection allowance, reducing expected collected rent by $1,200. If other recurring income is $600, effective gross income is $23,400.
Assume annual operating costs are $9,400, including taxes, insurance, repairs, management, utilities, HOA fees, and a capital reserve. NOI is therefore $14,000. If annual debt service is $9,600, estimated annual cash flow before income taxes is $4,400, or about $367 per month.
If total cash invested is $70,000, the estimated cash-on-cash return is approximately 6.3%. Annual gross rental yield, using a hypothetical $240,000 purchase price, is 10%. The difference shows why a gross rental yield calculator is a screening tool rather than a complete investment analysis.
Compare alternative scenarios
| Scenario | Change to test | What to observe |
|---|---|---|
| Base case | Most supportable rent and expense estimates | Expected cash flow and return |
| Self-management | Remove or reduce management fees, add your time and leasing costs | Whether the return depends on unpaid labor |
| Higher vacancy | Increase the vacancy allowance | How quickly cash flow weakens |
| Financing change | Adjust down payment, interest rate, or loan term | Effect on debt service and cash-on-cash return |
| Major repair | Add a one-time roof, appliance, or system replacement | Required reserves and cash needs |
| Rent change | Test lower initial rent or a modest future increase | Whether the deal works without aggressive rent assumptions |
A sound analysis should remain understandable when one assumption changes. If a small rent adjustment or one moderate repair turns positive cash flow negative, treat that sensitivity as a central part of the decision rather than an inconvenience to ignore.
When to recalculate
Revisit the worksheet whenever a major input changes. Before making an offer, update the analysis with the latest insurance quote, tax information available to you, lender terms, inspection findings, and realistic rental comparisons. Review it again before closing if the purchase price, repairs, or financing changes.
For an owned property, update the worksheet at least when the lease renews, rent changes, insurance or property taxes are revised, HOA fees increase, a loan is refinanced, or operating expenses materially change. An annual portfolio review can compare actual rent, vacancy, repairs, management costs, and reserves with the original assumptions.
Local rules and costs can affect deposits, inspections, licensing, notices, utilities, and maintenance obligations. Confirm requirements for the property’s location rather than copying assumptions from another market. Likewise, mortgage rates, insurance premiums, repair costs, and rent conditions can change; refresh those inputs whenever market conditions materially move.
Finally, save each version of the worksheet. Comparing the original estimate with actual results helps you improve future property analyses and identify which assumptions deserve the most attention. Use the worksheet alongside property inspections, comparable rental listings, lender documents, and professional tax or legal advice where appropriate. It is a decision tool—not a promise of profit—and its value comes from making uncertainty visible before your cash is committed.