Worksheet downloaded from www.erica.biz -- MAY NOT be emailed or otherwise redistributed!
Rental property Property #1
Assumptions Worst-Case Scenario Best-Case Scenario
Purchase price $199,000.00 $235,000.00
BUILDING value (look up in prop tax) $125,000.00 $150,000.00
Initial cash outlay $30,000.00 $30,000.00
Income Income
Rental income (TOTAL) $1,595.00 $1,750.00
Depreciation (straight-line; 27.5yrs) $378.79 $454.55
Tax deduction (unknown)
$1,973.79 $2,204.55
Expenses (all monthly)
Monthly payment (use mortgage calc) $1,167.00 $1,167.00
HOA
Property taxes $222.22 $262.42
Insurance $165.83 $195.83
Maintenance $165.83 $195.83
Loss of income (Down payment) @ 8% $200.00 $200.00
Each unit vacant 1mo/yr $132.92 $145.83
Income tax on rental income $364.86 $243.24
$2,418.66 $2,410.16
PROFIT -$444.88 -$205.61
*Cash outlay is 10% down payment and $15,000 in savings account as "buffer room" to pay mortgage & loan if tenants can't
*Straight-line depreciation means you cannot start depreciating a property until Jan 1 of the next year…not the day you buy i
If you would like to send this worksheet to your friends, please send them the following link so they can download their own
be emailed or otherwise redistributed!
Property #2
est-Case Scenario Assumptions
Purchase price
Building value
Initial cash outlay
Income
3 - 2BR 1BA + 1 - 1BR 1BA
Depreciation $0.00
$0.00
Expenses (all monthly)
1.34% $0.00
$0.00
$0.00
$0.00
$0.00
30% worst-case; 20% best-case $0.00
$0.00
$0.00
er room" to pay mortgage & loan if tenants can't cover
until Jan 1 of the next year…not the day you buy it! Make sure you have enough money to cover this.
he following link so they can download their own copy: http://www.erica.biz/real-estate-cash-flow-worksheet/