$300,000 with 25% down at 7%
- Purchase price
- 300,000
- Down payment
- 25%
- Closing costs and repairs at purchase
- 9000
- Loan interest rate (per year)
- 7%
- Loan term
- 30 years
- Monthly rent
- 2600
- Other monthly income
- 0
- Vacancy and unpaid rent
- 5%
- Property management (% of rent collected)
- 8%
- Property tax (per year)
- 3300
- Insurance (per year)
- 1500
- HOA dues (per month)
- 0
- Maintenance and repairs (per year)
- 2400
- Other operating costs (per year)
- 0
- Property value growth (per year)
- 3%
- Rent growth (per year)
- 3%
- Operating cost growth (per year)
- 3%
- Years until sale
- 10 years
- Selling costs (% of sale price)
- 6%
- Net operating income (year 1)
- 20,068.80
- Cap rate
- 6.69%
- Cash flow (year 1)
- 2,105.63
- Cash flow per month (year 1)
- 175.47
- Cash-on-cash return (year 1)
- 2.51%
- Mortgage payment per month
- 1,496.93
- Debt service coverage ratio
- 1.12
- Internal rate of return (IRR)
- 12.13%
- Cash from the sale
- 185,906.56
Checked against: Python decimal model: yearly rent and costs grown at 3%, month-by-month amortization, IRR by 300 bisection steps on the NPV of the ten yearly flows plus sale proceeds
Cash purchase with no growth or costs
- Purchase price
- 300,000
- Down payment
- 100%
- Closing costs and repairs at purchase
- 0
- Loan interest rate (per year)
- 7%
- Loan term
- 30 years
- Monthly rent
- 2000
- Other monthly income
- 0
- Vacancy and unpaid rent
- 0%
- Property management (% of rent collected)
- 0%
- Property tax (per year)
- 0
- Insurance (per year)
- 0
- HOA dues (per month)
- 0
- Maintenance and repairs (per year)
- 0
- Other operating costs (per year)
- 0
- Property value growth (per year)
- 0%
- Rent growth (per year)
- 0%
- Operating cost growth (per year)
- 0%
- Years until sale
- 5 years
- Selling costs (% of sale price)
- 0%
- Net operating income (year 1)
- 24,000.00
- Cap rate
- 8.00%
- Cash-on-cash return (year 1)
- 8.00%
- Internal rate of return (IRR)
- 8.00%
- Total profit
- 120,000.00
- Gross rent multiplier
- 12.50
- Mortgage payment per month
- 0.00
Checked against: Hand calculation: 2,000 × 12 = 24,000 ÷ 300,000 = 8%; five years of 8% cash yield with the price returned at the end is an 8% IRR
Zero-rate loan, 5-year hold
- Purchase price
- 300,000
- Down payment
- 25%
- Closing costs and repairs at purchase
- 9000
- Loan interest rate (per year)
- 0%
- Loan term
- 30 years
- Monthly rent
- 2600
- Other monthly income
- 0
- Vacancy and unpaid rent
- 5%
- Property management (% of rent collected)
- 8%
- Property tax (per year)
- 3300
- Insurance (per year)
- 1500
- HOA dues (per month)
- 0
- Maintenance and repairs (per year)
- 2400
- Other operating costs (per year)
- 0
- Property value growth (per year)
- 3%
- Rent growth (per year)
- 3%
- Operating cost growth (per year)
- 3%
- Years until sale
- 5 years
- Selling costs (% of sale price)
- 6%
- Mortgage payment per month
- 625.00
- Cash flow (year 1)
- 12,568.80
- Cash-on-cash return (year 1)
- 14.96%
- Internal rate of return (IRR)
- 24.27%
- Cash from the sale
- 139,415.29
- Equity at sale
- 160,282.22
Checked against: Python decimal model as above: 225,000 ÷ 360 = 625 a month; balance after 60 payments 187,500; value 300,000 × 1.03^5
Negative cash flow with 10% down (edge)
- Purchase price
- 300,000
- Down payment
- 10%
- Closing costs and repairs at purchase
- 9000
- Loan interest rate (per year)
- 8%
- Loan term
- 30 years
- Monthly rent
- 1900
- Other monthly income
- 0
- Vacancy and unpaid rent
- 5%
- Property management (% of rent collected)
- 8%
- Property tax (per year)
- 3300
- Insurance (per year)
- 1500
- HOA dues (per month)
- 0
- Maintenance and repairs (per year)
- 2400
- Other operating costs (per year)
- 0
- Property value growth (per year)
- 3%
- Rent growth (per year)
- 3%
- Operating cost growth (per year)
- 3%
- Years until sale
- 10 years
- Selling costs (% of sale price)
- 6%
- Net operating income (year 1)
- 12,727.20
- Cash flow per month (year 1)
- -920.56
- Cash-on-cash return (year 1)
- -28.33%
- Debt service coverage ratio
- 0.54
- Internal rate of return (IRR)
- 1.29%
Checked against: Python decimal model as above: 270,000 at 8% costs 1,981.16 a month, more than the 1,060.60 of monthly NOI