Rental property cash flow calculator
Work out monthly and yearly cash flow, cap rate and cash-on-cash return for a rental from the numbers you already know. Free and private.
Your result
Where the money goes each month
Rental Property Income & Expense Tracker (Excel)
Tracking real rent and bills across the year? One ledger for rent and bills; totals by property, month and category, ready for your own records or your tax preparer.
Get it on Gumroad — $9.99 One-time purchase, instant download.
How it works
Income is rent plus other income, less vacancy. Management and maintenance are percentages of that collected income. Operating expenses are property tax and insurance (spread over 12 months), HOA, utilities, other costs, management and maintenance. NOI is income minus operating expenses; cash flow is NOI minus the mortgage payment. See the step-by-step guide with a worked example.
Common questions
What is cash flow on a rental property?
Cash flow is the money left each month after the rental pays its own operating costs and the mortgage payment: collected rent minus vacancy, taxes, insurance, repairs, management and other costs, minus the loan payment.
What is NOI?
Net operating income is the rent you actually collect minus operating expenses, before any mortgage payment. It is the property's earning power regardless of how it is financed.
What is a cap rate?
Cap rate is a year of NOI divided by the purchase price. It lets you compare properties without the effect of different loans.
What is cash-on-cash return?
A year of cash flow after the mortgage divided by the cash you actually put in (down payment, closing costs and repairs). It shows the return on your own money.
What vacancy and maintenance numbers should I use?
There is no universal number. Many investors plan a few percent for vacancy and a percentage of rent for repairs, then adjust to the age of the building and the local market. Use your own records where you have them.