Property Cash Flow Calculator Formula
Understand the math behind the property cash flow calculator. Each variable explained with a worked example.
Formulas Used
Monthly Cash Flow
monthly_cash_flow = monthly_cfAnnual Cash Flow
annual_cash_flow = monthly_cf * 12Effective Monthly Income
effective_gross_income = effective_rentTotal Monthly Expenses
total_monthly_expenses = total_expensesExpense Ratio
expense_ratio = effective_rent > 0 ? (total_expenses / effective_rent) * 100 : 0Variables
| Variable | Description | Default |
|---|---|---|
monthly_rent | Monthly Rental Income(USD) | 2800 |
vacancy_rate | Vacancy Rate(%) | 5 |
monthly_mortgage | Monthly Mortgage Payment (P&I)(USD) | 1400 |
monthly_taxes | Monthly Property Taxes(USD) | 250 |
monthly_insurance | Monthly Insurance(USD) | 120 |
monthly_maintenance | Monthly Maintenance Reserve(USD) | 200 |
monthly_mgmt_fee | Monthly Management Fee(USD) | 0 |
effective_rent | Derived value= monthly_rent * (1 - vacancy_rate / 100) | calculated |
total_expenses | Derived value= monthly_mortgage + monthly_taxes + monthly_insurance + monthly_maintenance + monthly_mgmt_fee | calculated |
monthly_cf | Derived value= effective_rent - total_expenses | calculated |
How It Works
Property Cash Flow Analysis
Cash flow is the money remaining after all property expenses are paid from rental income. Positive cash flow means the property pays for itself and generates a profit.
Formula
Monthly Cash Flow = Effective Rental Income - Total Monthly Expenses
Where:
Why Cash Flow Matters
Worked Example
A rental property earns $2,800/month with 5% vacancy, $1,400 mortgage, $250 taxes, $120 insurance, $200 maintenance, and no management fee.
- 01Effective monthly income: $2,800 x (1 - 0.05) = $2,660
- 02Total expenses: $1,400 + $250 + $120 + $200 + $0 = $1,970
- 03Monthly cash flow: $2,660 - $1,970 = $690
- 04Annual cash flow: $690 x 12 = $8,280
- 05Expense ratio: $1,970 / $2,660 = 74.1%
Frequently Asked Questions
What is a good cash flow per rental unit?
Many investors aim for at least $100 to $200 per unit per month after all expenses, including vacancy and maintenance reserves. In expensive markets, even breaking even on cash flow may be acceptable if appreciation is strong.
Should I include capital expenditures in cash flow?
The maintenance reserve line should cover routine repairs. For major capital expenditures like a roof or HVAC, many investors set aside an additional 5-10% of gross rent in a separate CapEx reserve, which would reduce cash flow further.
How does vacancy rate affect cash flow?
Vacancy directly reduces your effective income. A 5% vacancy rate on a $2,800 rent means losing $140/month or $1,680/year. In areas with high turnover, use 8-10% vacancy to be conservative.
Ready to run the numbers?
Open Property Cash Flow Calculator