Rental Property Cash Flow
See exactly how much cash your rental property generates each month with automatic NOI, cap rate, and cash-on-cash return calculations.
About the Rental Property Cash Flow
This Excel rental property cash flow template is designed for real estate investors and landlords who need to analyze the monthly financial performance of a rental property. It tracks rental income and other revenue across twelve months, then deducts operating expenses including property management, maintenance, insurance, taxes, HOA fees, and vacancy/repair reserves that auto-calculate as percentages of rental income. The template computes net operating income and cash flow after debt service for each month and annually. A summary section displays key investment metrics including annual cash flow, cap rate, cash-on-cash return, and debt service coverage ratio, with conditional formatting that color-codes healthy versus concerning values. Generate tenant payment records with a rent receipt template and review overall profitability with an income statement.
Rental Property Cash Flow Features
- Monthly income and expense tracking across twelve months
- Auto-calculated operating expenses as percentages of rental income
- Net operating income and cash flow after debt service calculations
- Key metrics: annual cash flow, cap rate, cash-on-cash return, DSCR
- Conditional formatting color-codes healthy vs. concerning values
How to Use This Rental Property Cash Flow in Excel
- 1
Enter property details
Fill in the property purchase price, down payment, loan terms, and other acquisition details that drive the debt service calculations.
- 2
Input monthly income
Enter rental income and any additional revenue sources for each of the twelve months.
- 3
Review operating expenses
Adjust percentage-based expense assumptions for property management, vacancy reserves, maintenance, insurance, taxes, and HOA fees.
- 4
Analyze investment metrics
Review the summary section for annual cash flow, cap rate, cash-on-cash return, and debt service coverage ratio to assess property performance.
Rental Property Cash Flow FAQ
- Can I analyze multiple rental properties?
- This template is designed for one property. Duplicate the workbook for each property in your portfolio to compare performance side by side.
- How are operating expenses calculated?
- Several expenses auto-calculate as configurable percentages of rental income (e.g., vacancy reserve, property management). You can override any percentage or enter fixed dollar amounts.
- What is the debt service coverage ratio?
- DSCR measures net operating income divided by debt service (mortgage payments). A DSCR above 1.0 means the property generates enough income to cover its mortgage. The template calculates this automatically.
