Cash Flow Calculator
Investment Property Analysis
$
%
%
%
yrs
Down Payment
$75,000
Loan Amount
$225,000
Total Cash Invested
$84,000
$
$
Gross Scheduled Income
$2,400/mo
Less: Vacancy
-$120/mo
Effective Gross Income
$2,280/mo
$
$
$
$
$
Total Monthly OpEx
-$930
Total Annual OpEx
-$11,160
✓
Positive Cash Flow
Monthly Cash Flow
$352
per month after all expenses & mortgage
$4,224 / year
Cash-on-Cash
5.0%
Return on cash invested
Cap Rate
5.4%
NOI ÷ Price
NOI
$16,200
Net Operating Income
Debt Service
$17,976
Annual mortgage P&I
OpEx Ratio
41%
Operating expenses %
Break-Even
85%
Min occupancy needed
Quick Investment Rules Check
1% Rule
PASS
0.80%
Target: Rent ≥ 1% of price
50% Rule
PASS
41%
Target: OpEx ≤ 50% of rent
GRM
PASS
10.4
Target: GRM ≤ 12
Monthly Cash Flow Breakdown
Total Income
+$2,280
Gross Rent
+$2,400
Other Income
+$0
Less: Vacancy (5%)
-$120
Operating Expenses
-$930
Property Tax
-$300
Insurance
-$150
Property Management (10%)
-$228
Repairs & Maintenance (5%)
-$120
CapEx Reserve (5%)
-$120
Net Operating Income (NOI)
$1,350
Less: Mortgage Payment (P&I)
-$1,498
Monthly Cash Flow
$352
Cash Flow Waterfall
Effective Income
Operating Expenses
Debt Service
Cash Flow
