Help! I'm bad at math or doing something wrong

Help! I'm bad at math or doing something wrong

Investor · New Haven, CT · Member since 2016 · 20 posts · 5 votes

Hello BP,

I have two properties and looking to purchase a third. I keep doing the numbers and feel like the numbers are showing bad deals, but it doesn't make sense to me how they can be. 

I know I need to re-read some of the books, etc. but advice will be greatly appreciated! Am I misreading this, and it's actually a good deal? Am I improperly estimating the expense and income increases that's affecting profitability? Looking at the numbers CAPEX and repairs add a huge amount to the monthly expenses.

For instance, this third deal:

Monthly Income: $1,100

Monthly Expenses $1,134.14

Monthly Cashflow: -$34.14

Pro Forma Cap: 5.22%

NOI: $5,215

Total Cash Needed: $11,050

Cash on Cash ROI: -3.71%

Purchase Cap Rate: $5.73

Sale Price: $91,000

Closing Costs: $2,500

Renovation Costs: $4,550 (5%)

TOTAL PROJECT COSTS: $98,050

Down Payment: $4,550 (5%)

Loan Amount: $87,314.5

Loan Points: $864.5 (1%)

Amortized: 30 years

Interest Rate: 5%

P&I: 468.72

Total Cash Needed: $11,050

Property Taxes: $2,184/yr

2% Rule: 1.13%

Initial Equity: $12,685.50

Gross Rent Multiplier: 6.89

Debt Coverage Ratio: 0.93

Expense Increase: 4%/yr

Income Increase: 5%/yr

Property Value Increase: 4%/yr

Cash on Cash ROI: YR1 (-3.71%) YR2 (-0.63%) YR5 (2.64%) YR10 (9.76%) YR15 (31.56%)

Annualized Total Return: YR1 (2.48%) YR2 (22.27%) YR5 (26.37%) YR10 (26.47%) YR15 (22.20%)

Total Profit if sold: YR1 ($274) YR2 ($5,469) YR5 ($11,251) YR10 ($24,701) YR15 ($70,982)

Expenses:

HOA: $82

Insurance: $66

Taxes: $182

MTG: $468.72 (@5%)

TOTAL: $798.72

Vacancy: $110 (10%)

CAPEX: $190/mo (~2.5%)

Repairs & Maint: $380/mo (5%)

TOTAL EXPENSES: $1,478.72

These expenses are different than the $1,134.14 mentioned early on. That number was used and still gave a negative ROI, etc. meaning the current numbers you see just above make the picture even worse.

Please advise, and thanks!

Rick

0Reply
33 views

3 Replies

Jump to latestLatest
  • Lender · Vancouver, BC · Member since 2017 · 40 posts · 16 votes
    8y

    @Rick L.

    I think your repairs and maintained are pretty high. 5% of purchase price is really up there. If there is HOA, you shouldn't need a manager either. Not saying they're all perfect, just if this deal is to even be considered, it should be self managed. I usually only use managers in slum areas or out of town buys. All in all however, this is a bad deal and the homework done should be burned. Keep hunting. Instead of using a manager, simply look to use a handyman as a proxy and pay them hourly once a relationship is established. I go months without ever calling them, then when something does come up, it usually costs 50to $75 bones. Far easier. Of course I don't trust mgrs to source proper tenants, but that's the doing of my business's mentor from back in the day.

  • Real Estate Investor · Kansas City, MO · Member since 2015 · 222 posts · 121 votes
    8y

    Are you considering investing in a negative cash-flow unit? Is this more of an equity play? Are you confident in the appreciation of this location? 

  • Investor · New Haven, CT · Member since 2016 · 20 posts · 5 votes
    8y

    @Jason D. Lewis  - Thank you for your comments. Being new to this I am estimating based on numbers I'm seeing from the BP calculators and from other posts I see for these kinds of things, trying to account for all eventualities as a "conservative" estimate hoping that I would have  expenses to cover the unexpected.

    I also appreciate your advice about managers and using a handyman as a proxy, paid hourly.

    @Account Closed - Definitely not an equity play, just trying to understand how to make these numbers and deals make sense. I know the math is straightforward, I just can't seem to make it work. I think it's because I'm being too conservative with the numbers. Thanks!

Join the conversationCreate a free account to reply, vote on answers and follow this thread.