I was a little off in my analysis but not that bad, the calculator in projecting a yearly income of
I added on a little more to my monthly expenses.
Gross Rental Income $4,000.00 $48,000.00
Vacancies ($600.00) ($7,200.00)
Gross Operating Income $3,400.00 $40,800.00
Expenses ($1,250.00) ($15,000.00)
Net Operating Income $2,150.00 $25,800.00
Debt Service ($1,342.00) ($16,115.00)
Before Tax Cash Flow $807.00 $9,685.00
Theres a few things I don't understand,
How is the cap rate 9%
I'm getting ( 9685.00 / 280,000 = 3.4 % )
Financial Ratios
Gross Multiplier 6 %
Cap Rate 9 %
Internal Rate of Return 17 %
Yield 17 %
Debt Coverage Ratio 1.60 1.64 1.68 1.73 1.77
Loan to Value (LTV) Ratio 80% 75% 72% 68% 64% 61%
Ownership Percentage 24% 27% 31% 35% 38%
Cash on Cash Return (BT) 17 % 18 % 19 % 20 % 22 %
Cash on Cash Return (AT) 15 % 16 % 17 % 17 % 18 %
How do you read and understand the cash flow page ?
Net Operating Income (NOI) 25,800 26,466 27,148 27,843 28,554
Debt Service -16,115 -16,115 -16,115 -16,115 -16,115
Before Tax Cash Flow 9,685 10,351 11,033 11,728 12,439
Depreciable Allowance -8,145 -8,145 -8,145 -8,145 -8,145
Mortgage 1 Interest -13,365 -13,195 -13,015 -12,824 -12,621
Taxable Income 4,290 5,126 5,988 6,874 7,788
Taxes Due -1,072 -1,281 -1,497 -1,718 -1,947
After Tax Cash Flow 8,613 9,070 9,536 10,010 10,492
How come the cap rate is now 9.21 % ?
Gross Multiplier (Price/GSI) 5.83
Cap Rate 9.21 %
Internal Rate of Return 17 %
Yield 17.00 %
Debt Coverage Ratio 1.60 1.64 1.68 1.73 1.77
Loan to Value (LTV) Ratio 80 % 75 % 72 % 68 % 64 % 61 %
Ownership Percentage 24 % 27 % 31 % 35 % 38 %