need a formula for buying residential multi-family rental properties

need a formula for buying residential multi-family rental properties

Bakersfield, CA · Member since 2013 · 128 posts · 7 votes

Hello Everyone

For buying 4 units and under (quads – triplex and duplex), I need a formula to show me whether a deal is a good deal or not

0Reply
89 views

Most Popular Reply

Rental Property Investor · Mercer Island, WA · Member since 2008 · 22k+ posts · 14k+ votes
13y

How about these:

If you're going to pay a PM:

cash flow = (rent * 0.5) - P&I payment

If you're going to self manage and you're willing to work for free:

cash flow = (rent * 0.64) - P&I payment

And then

Cash on cash return = annual cash flow / total cash invested

Note that those cash flow numbers assume you're doing a good job of running the property. A run down junker or a bunch of dead beat tenants can result in much lower, or even negative, cash flow.

That's just a quick and dirty analysis to determine if its worth digging deeper. If you like those results, dig deeper.

Two other criterian that I think matter too.

Are you getting a good deal? I'd rather not pay retail price because if you have to sell quickly, you'll lose, at best, all your transaction costs

Is there demand? Theoretical cash flow won't turn into real cash flow if you have units vacant half the time. Really, though, that means the rents are lower than you might other wise think. But some places really do have very high vacancy rates and you can't get tenants are any price. You don't want that.

See this reply in the discussion

15 Replies

Jump to latestLatest
  • Rental Property Investor · Mercer Island, WA · Member since 2008 · 22k+ posts · 14k+ votes
    13y

    How about these:

    If you're going to pay a PM:

    cash flow = (rent * 0.5) - P&I payment

    If you're going to self manage and you're willing to work for free:

    cash flow = (rent * 0.64) - P&I payment

    And then

    Cash on cash return = annual cash flow / total cash invested

    Note that those cash flow numbers assume you're doing a good job of running the property. A run down junker or a bunch of dead beat tenants can result in much lower, or even negative, cash flow.

    That's just a quick and dirty analysis to determine if its worth digging deeper. If you like those results, dig deeper.

    Two other criterian that I think matter too.

    Are you getting a good deal? I'd rather not pay retail price because if you have to sell quickly, you'll lose, at best, all your transaction costs

    Is there demand? Theoretical cash flow won't turn into real cash flow if you have units vacant half the time. Really, though, that means the rents are lower than you might other wise think. But some places really do have very high vacancy rates and you can't get tenants are any price. You don't want that.

  • Bakersfield, CA · Member since 2013 · 128 posts · 7 votes
    13y

    Thank you very much for the quick reply Jon.

    Let’s say I want to go with option b) self manage and work for free and live in one unit (so as for calculations, I will be a paying tenant too).

    Cash flow = (rent * 0.64) - P&I payment

    Here is the property I am considering to buy .

    East Bakersfield - Quad
    Purchase price: 160 k
    Annual Gross Income $28440

    Monthly Rent: $2370
    Down payment: 3.5 % = $6000
    Interest rate: 3.6 %
    P&I : $702

    Cash flow = 2370 x 0.64 - 702 = $ 815

  • Rental Property Investor · Cleveland, OH · Member since 2012 · 110 posts · 13 votes
    13y

    Hi Alex R., it also looks like you are financing through Owner Occupied FHA. In that case, no matter how much equity you have, you will have PMI insurance for 60 months under current rules. Not sure if you are going FHA or not? That is just another number to factor into your equation that the 50% rule (in your case 64% rule) does not really account well for.

    I am in the process of completing my first deal as well. FHA financed duplex OO. I am subtracting the PMI insurance as well from my Debt Service (P&I) to make sure the deal works. And when PMI is removed, it will be just more cashflow--nice!

    So IF you are going FHA, your math might look like:
    Cashflow = $2,370 x 0.64 - $852 ($702 + $150 for PMI) = $664.80

  • Investor · Milford, CT · Member since 2012 · 592 posts · 285 votes
    13y

    I look at what the market is for Cap Rate, GRM, Comps. I apply a discounted cash flow analysis looking at factors such as repairs, improvements, and any negative attributes about the property. This is usually a good indication but really depends on what the market and your gut telling you.

  • Wholesaler · Brooklandville, MD · Member since 2013 · 149 posts · 29 votes
    13y

    What is good resource to get comps for duplexes? Loopnet and CoStar is out of my price range anything "cheaper"? Is the MLS reliable?

    To add how far back do I need to go to get these comps?

    What about distance? Reason being is that I have a motivated seller whom wants to sell but finding comps is kinda difficult since it is among a ton of 2 story rowhouses and the "neighbor" is a 2 story rowhouse

  • Bakersfield, CA · Member since 2013 · 128 posts · 7 votes
    13y

    other resources could be price history, sale records, current and past tax assessments and Zestimate.
    Look at al these data and make an offer accordingly.
    **************
    Is the MLS reliable? In my city YES. ay change first appears on MLS followed by Trulia, zipreality, zillow,...
    **************
    And distancewise, if this is your first deal, it shouldn't be more than half an hour drive from your primary residence

  • Real Estate Professional · West Palm Beach, FL · Member since 2012 · 23k+ posts · 13k+ votes
    13y

    By the way,your cash to close for closing costs, pre paids, PMI lump sum, etc. including your down payment, will be about 10%.

  • Real Estate Investor · Audubon, PA · Member since 2009 · 13k+ posts · 8k+ votes
    13y
    Originally posted by Jamaal Hunt:
    What is good resource to get comps for duplexes? ... Is the MLS reliable?

    ...

    Duplexes would be comp'd using the MLS; 4 units and less are usually considered as residential (with some exceptions), and similar sales can be found in the MLS. Most duplexes can be comp'd using the same resources as one would use for SFR.

  • Bakersfield, CA · Member since 2013 · 128 posts · 7 votes
    13y
    Originally posted by Steve Babiak:
    Originally posted by Jamaal Hunt:
    What is good resource to get comps for duplexes? ... Is the MLS reliable?

    ...

    Duplexes would be comp'd using the MLS; 4 units and less are usually considered as residential (with some exceptions), and similar sales can be found in the MLS. Most duplexes can be comp'd using the same resources as one would use for SFR.

    Is there any exception for buying a 5 or 6 unit property on a conventional residential loan with low down and low interest rate ?

  • Altus, OK · Member since 2008 · 2k+ posts · 690 votes
    13y

    If its 5 units or more it's going to be likely a commercial loan.

  • Real Estate Investor · Raleigh, NC · Member since 2012 · 427 posts · 297 votes
    13y

    Craig Sturgill you said " Alex R., it also looks like you are financing through Owner Occupied FHA. In that case, no matter how much equity you have, you will have PMI insurance for 60 months under current rules. "

    I met with a loan guy yesterday and he did not mention this. Although if I go FHA (I probably will have to because of the down payment) I doubt I will be at 78% equity in five years, I did not know this fact. Thanks a lot for alerting me to it!

    Thanks to everyone else in this thread too! I had the exact questions as Alex. Jon Holdman the .64 is new to me if you plan to self manage, which I do. I was doing .6 assuming I did not hire property management since it looks like they run close to 10% all said and done. Is the extra .4 accounting for them taking a half month rent when they fill a vacancy (seems standard in my area?)

    I just want to make sure I have a solid understanding of everything by the time I find my property (hopefully soon!)

  • Rental Property Investor · Mercer Island, WA · Member since 2008 · 22k+ posts · 14k+ votes
    13y

    Eric F., exactly. If you get charged half a months month's rent to fill a vacancy, that's (1/2)/12 of your gross annual income. That is, 1/24th or 4.17%, to be more exact. So, you'll pay the PM 10% of the rent you do get plus 4% for filling a vacancy. Of course, you may have a tenant that stays 10 years. Or, you you may have to fill more than one a year. So, this is just an estimate. But the cost of a PM is significant.

  • Real Estate Investor · Raleigh, NC · Member since 2012 · 427 posts · 297 votes
    13y

    Thanks Jon Holdman! Your posts have taught me a ton about real estate and property management.

  • Homeowner · El Paso, TX · Member since 2012 · 81 posts · 22 votes
    13y

    http://www.biggerpockets.com/files/user/EOD_Investor/file/property-evaluation-spread-sheet-1-4-units

    I might be considered soliciting, but this is a 1-4 unit calculator i made for quad's.

    Just something that might help you out in the future.

  • Property Manager · Livonia, MI · Member since 2011 · 4k+ posts · 1k+ votes
    13y

    elliot,

    thanks for creating this file. you should "pretty it up" to look like J's and Will K's.

    if you would like suggestions, either start a different thread so that we can work on it and get other's input or PM me.

    again, thanks for spending the time to create it.

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