What's inside
- Property, purchase-price, loan, rate, and term inputs
- Rent, other income, and vacancy assumptions
- Property tax, insurance, repairs, management, HOA, utilities, and other expense inputs
- Automatic monthly and annual cash flow
- Cap rate, cash-on-cash return, and DSCR calculations
Best for: Individual landlords · Small property investors · Buy-and-hold investors
Worked example
Worked example from the included workbook
Inputs
- Purchase price
- $420,000
- Loan amount
- $336,000 at 6.5% for 30 years
- Monthly rent + other income
- $4,450
- Vacancy rate
- 5%
- Monthly operating expenses
- $1,296
Outputs
- Net operating income
- $2,931.50 / month
- Annual debt service
- $25,484.98
- Annual cash flow
- -$22,553.48
- Cap rate
- 0.7%
- DSCR
- 0.12
These are the sample values and formulas included in the workbook, not a forecast or investment recommendation.
Customer feedback
Write a review
Download this file first to unlock review submission.
FAQ
Is the sample free?
Yes. The base workbook or pack shown on this page can be downloaded without payment, an account, a credit card, or an email address.
What software do I need?
The product is supplied as an editable spreadsheet or pack designed for Microsoft Excel and Google Sheets.
Can I edit it?
Yes. Inputs, labels, categories, and sample records can be changed in your spreadsheet app. Formulas are intended to remain intact when you replace the example values.
What does Rental Property Cash Flow Calculator help me do?
Screen rental deals in minutes with automatic NOI, cash flow, cap rate, cash-on-cash return, and DSCR. It includes property, purchase-price, loan, rate, and term inputs.
Is this a subscription?
No. This is a downloadable spreadsheet product, not a recurring subscription. A paid bundle may remain available as an optional alternative.