Underwriting 4-Plex like Commercial Multifamily

Underwriting 4-Plex like Commercial Multifamily

Rental Property Investor · Philadelphia, PA · Member since 2015 · 212 posts · 116 votes

Hi All,

Is it realistic to underwrite a 4-plex the same way as you'd underwrite a small commercial multifamily property (more than 4 units)? I've been using Michael Blank's Syndicated Deal Analyzer and was wondering if I could use it for 4 plexes as well, since I'm trying to syndicate a 4plex from family and friends (I don't have that much capital and can't provide sweat equity to partner with someone). For example, for commercial MFH I typically implement the following from his analyzer:

  • Conservatively estimate expenses as 50%
  • 2% annual rent growth (again, being conservative)--I know this depends on the market
  • Vacancy % = 1/[number of units in property]--ex. 1/6 unit, 1/8unit, etc.
  • Ernest Money Deposit = ~1% of Purchase Price
  • Charge an acquisition fee since I'm procuring the deal = ~1%
  • Charge capital transaction fee = ~1%
  • Charge Asset Management fee = 1%
  • Refinance after X years and sell after Y years
  • Gauge whether a deal is "good" if: Average Annual Return = 15%, IRR = 15%, Average CoC Return = 9%

Can these measures be taken for 4plexes as well? If not, what are the criterion I can remove? Should I perhaps estimate expenses at 40%? Not charge an acquisition fee? Lower my "good deal" thresholds? What I'm finding is that my offers are too low for sellers to accept, but they meet these criterion, so I'm wondering if I'm being too strict in my underwriting.

Is there an Excel model specific for 4-plexes? I couldn't find it in the FilePlace.

Hope this makes sense. Thanks in advance!

1Reply
9 views

Most Popular Reply

Brandon SturgillBusiness Member
Real Estate Broker · Columbus, OH · Member since 2013 · 3k+ posts · 1k+ votes
7y

So harsh @Ben Leybovich ;) 

I remember being a fledgling investor...those days were so good...naivete in abundance. @Snehann Kapnadak 1-4 unit properties are valued on the comparable sales method. Period...however, in a tight situation and appraiser will look to the income method for support...mainly GRM...which is ironic, but whatever. Irrespective, the income every property produces will be considered by any lender if you are using a loan...so, it is important to know what your units are renting for and what your expenses are.

There is a benefit to super-analyzing small MF properties like this...you get practice for your future analysis of hundreds of properties and a successful career in the industry as you scale. As is, this analysis is merely for your own edification...we feel good as investors when we can know all the numbers associated with everything....but for this asset class it really doesn't matter. 

I've seen dozens and dozens of investors over-analyze themselves out of so many small MF deals I can't count any longer...

If you must analyze residential property, cash-on-cash is the only real measure...but it's limited...it simply lets us compare apples to apples so we can determine the best use of our limited capital. 

Keep analyzing your deals...but at the same time, if you are involved in this asset class, link up with a good agent that can produce reliable comparable market analysis reports.

Realize Multifamily Group11 Review
View Page
See this reply in the discussion

6 Replies

Jump to latestLatest
  • Rental Property Investor · NorCal · Member since 2018 · 399 posts · 222 votes
    7y

    May I ask you what is the difference between your average annual return and your CoC return? What's the difference between the two calculations?

  • Rental Property Investor · Teaneck, NJ · Member since 2016 · 567 posts · 291 votes
    7y

    @Snehann Kapnadak I would think that a lot of expenses from SDA would not apply to 4-Plex. 

    You can defenantly use it but there are much simpler tools. For example, BP have a calculator for smaller properties you could probably use. 

  • Rental Property Investor · Phoenix/Lima, Arizona/OH · Member since 2012 · 4k+ posts · 4k+ votes
    7y

    This is not the most idiotic thing ever...it's up there, though lol

    Please learn some stuff :)

  • Brandon SturgillBusiness Member
    Real Estate Broker · Columbus, OH · Member since 2013 · 3k+ posts · 1k+ votes
    7y

    So harsh @Ben Leybovich ;) 

    I remember being a fledgling investor...those days were so good...naivete in abundance. @Snehann Kapnadak 1-4 unit properties are valued on the comparable sales method. Period...however, in a tight situation and appraiser will look to the income method for support...mainly GRM...which is ironic, but whatever. Irrespective, the income every property produces will be considered by any lender if you are using a loan...so, it is important to know what your units are renting for and what your expenses are.

    There is a benefit to super-analyzing small MF properties like this...you get practice for your future analysis of hundreds of properties and a successful career in the industry as you scale. As is, this analysis is merely for your own edification...we feel good as investors when we can know all the numbers associated with everything....but for this asset class it really doesn't matter. 

    I've seen dozens and dozens of investors over-analyze themselves out of so many small MF deals I can't count any longer...

    If you must analyze residential property, cash-on-cash is the only real measure...but it's limited...it simply lets us compare apples to apples so we can determine the best use of our limited capital. 

    Keep analyzing your deals...but at the same time, if you are involved in this asset class, link up with a good agent that can produce reliable comparable market analysis reports.

    Realize Multifamily Group11 Review
    View Page
  • Rental Property Investor · Philadelphia, PA · Member since 2015 · 212 posts · 116 votes
    7y

    @David de Luna The difference is that the average annual return accounts for the entire lifespan of the investment. So it includes the return given to investors with the refinance and sale of the property along with the yearly CoC returns. The CoC is primarily from the rental income, reducing expenses, etc.

    @Oleg Shalumov Thanks for your comment. I've used the BP calculator and it's super helpful but I also wanted to model it in Excel. Regarding expenses, would you still recommend that I conservatively estimate 50% or should it be lower? The reason why I'm asking for an estimated percentage is because I'd like to do a quick back of the napkin calculation before I get the T12 from the owner. Kind of like the 10 minute deal analysis that Michael Blank talks about. So for example on one deal, the owner got back to me and their expenses were only 25%, so of course the deal penciled out to look really good. I countered and said "usually the expenses are about 50%", but that ended up making my offer too low. I'm wondering if I'm being too conservative.

    @Ben Leybovich Thanks for your note, now I'm kind of bummed that I didn't get to the top of your list for Most Idiotic Things said--I wanted to be #1 in something! I'm a big fan of you and find your story to be incredibly inspiring, so it's disappointing to see that your comment provided 0 value, but thanks for wasting your "valuable" time by replying to my question. I'll continue to do more research.

    @Brandon Sturgill Thanks for the detailed response! Yup, I'm aware of the comp sales evaluation method and was using that as the primary basis of my offers, but was wondering if a case can be made for evaluating the property off of income like larger MF properties. It's good to know that GRM might come into play to some extent. Yeah my goal is to eventually scale up to larger MF properties, so I'll continue analyzing but will focus on CoC for residential with a grain of salt. Noted on working with a good agent. Thanks again for the tip!

  • Danny RandazzoPro Member
    Apartment Syndicator · Charleston, SC · Member since 2016 · 973 posts · 728 votes
    7y

    @Snehann Kapnadak if you message me I will send you a calculator I built out. 

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