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.
monthly_rent = 2800vacancy_rate = 5monthly_mortgage = 1400monthly_taxes = 250monthly_insurance = 120monthly_maintenance = 200monthly_mgmt_fee = 0
- 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%
Ready to run the numbers?
Open Property Cash Flow Calculator