Rental Property Cash Flow Worksheet: How to Evaluate Income, Expenses, and Yield
real estate investingrental propertycash flowlandlordsproperty analysis

Rental Property Cash Flow Worksheet: How to Evaluate Income, Expenses, and Yield

LLivings Editorial Team
2026-11-18
6 min read

A practical rental property cash flow worksheet for estimating income, expenses, financing, yield, and return under changing assumptions.

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:

  1. How much income could the property reasonably produce?
  2. What will it cost to operate and finance?
  3. 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.

CategoryInputPlanning question
PurchasePrice, closing costs, initial repairsHow much cash is required before the first tenant moves in?
IncomeMonthly rent and other recurring incomeWhat evidence supports the rent assumption?
VacancyVacancy and collection allowanceWhat happens if the property is empty or rent is not collected for a period?
OperationsTaxes, insurance, repairs, management, utilities, HOA feesWhich costs are confirmed, estimated, or excluded?
ReservesCapital expenditure allowanceWhich major components may need replacement during ownership?
FinancingDown payment, rate, term, and debt serviceWould 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

ScenarioChange to testWhat to observe
Base caseMost supportable rent and expense estimatesExpected cash flow and return
Self-managementRemove or reduce management fees, add your time and leasing costsWhether the return depends on unpaid labor
Higher vacancyIncrease the vacancy allowanceHow quickly cash flow weakens
Financing changeAdjust down payment, interest rate, or loan termEffect on debt service and cash-on-cash return
Major repairAdd a one-time roof, appliance, or system replacementRequired reserves and cash needs
Rent changeTest lower initial rent or a modest future increaseWhether 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.

Related Topics

#real estate investing#rental property#cash flow#landlords#property analysis
L

Livings Editorial Team

Real Estate Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.