All
Members
Companies
Blog
Forums
Podcast
Webinars
    User Log in  /  Sign up
  • Forums
    Newest Posts Trending Discussions Followed Forums Real Estate News & Current Events General Landlording & Rental Properties Buying & Selling Real Estate Deal Analysis See All
  • Education

    Read

    BiggerPockets Blog BPInsights: Expert Analysis Guides Glossary Reviews Member Blogs

    Watch

    Webinars Video Library Financial Independence Blueprint Intro to Real Estate: Rentals

    Listen

    BiggerPockets Real Estate Podcast BiggerPockets Money Podcast BiggerPockets Business Podcast Real Estate Rookie Podcast Daily Podcast (Audio Blog)

    Topics

    Business Operations Finance Finding Deals Property Management Property Types Strategy
  • Network

    Recommended Vendors

    Real Estate Agents Mortgage Lenders Hard Money Lenders Insurance Contractors Investment Companies Build Your Team

    Search

    Members Events Jobs
  • Tools

    Calculators

    Rental Property Fix and Flip BRRRR Rehab Estimator
    Wholesaling Mortgage Payment 70% Rule Airbnb

    Services

    BPInsights: Property Insights Tenant Screening Property Management Lease Agreement Packages

    New Feature

    BPInsights (beta)

    Quickly analyze a property address or ZIP Code to compare your rent in your neighborhood.

    Analyze a property
  • Find Deals
    Real Estate Listings Find Foreclosures External Link Ads, Jobs, and Other
  • Bookstore

    Real Estate Books

    Profit Like The Pros Bidding to Buy See all books

    Featured Book

    BiggerPockets Wealth Magazine book cover
    BiggerPockets Wealth Magazine

    Written by financial journalists and data scientists, get 60+ pages of newsworthy content, expert-driven advice, and data-backed research written in a clear way to help you navigate your tough investment decisions in an ever-changing financial climate! Subscribe today and get the Oct/Nov issue delivered to your door!

    Get the Magazine
  • Pricing
Log In Sign up
User
Quick search links
Podcast Hard Money Lenders Books Washington
ForumsArrowReal Estate Deal Analysis and AdviceArrowHelp Analyzing My First Deal
  • Newest Posts
    • Newest Posts
    • Unanswered Discussions
  • Trending
    • Top Discussions
    • Trending Discussions
  • Browse Forums
Search Nova
Create post

Help Analyzing My First Deal

10 Replies

  • Share on Facebook
  • Share on Twitter
  • Share on LinkedIn
Rotate Log in or sign up to reply
user profile avatar
  • Posts 1
  • Votes 1

John Garretson
from Penfield, New York

posted over 3 years ago

Hi All,

I'm getting ready to do my first deal and I wanted to get some sense of whether the numbers work well...

Fully renovated, new roof, new interiors, granite countertops, LVP on all floors, etc. Basically look like luxury apartments. Place is completely redone.

Fourplex around 3,800 square feet.

Sale price: $400,000

No off-street parking. That's common in this city. In a medium-sized city. Not major city. Real estate prices here are generally reasonable.

Rents are $1300 in 3 units, and $1225 in one of them.

We're going to do owner-occupied and put 5% down.

The place is beautiful on the interior, and we won't have to put any work in at all because they just completely redid the place...

PITI total should be around $2900 per month. Taxes are around $7,500. Principal and interest around $1800. Tenants pay their own utilities.

Trash, sewer, water is picked up by landlord.

Is this a good deal or should I look elsewhere? I don't want to get in over my head... Will reserves and cash flow be good on this? Thanks for any guidance you can provide.

Rotate Log in or sign up to reply
user profile avatar
  • Posts 378
  • Votes 304

Ben Wilkins
Rental Property Investor from York, PA

replied over 3 years ago

When looking at an investment, you have a few expenses that you need to consider. These are not concrete expenses such as taxes or bills, and are instead calculated as percentages of the income (I call them "Percentage Expenses")

Maintenance: 10%. This is for every day wear and tear, repairs, removing bee nests, etc

Capital Expenses (CapEx): 10%. This is your major repair items - basically, you're saving up for when the roof needs replaced, the water heater needs repairs, etc

Property Management (PM): 10%. Even if you plan to manage the property at first, you might decide not to later. Also, your time should be worth something

Vacancy: 8%. This should be based on the average of your market, but 8% is a safe, conservative number.

A quick method for evaluating is to assume 50% of your income will go toward your percentage expenses and your utility expenses. The remaining income will be an estimate of your monthly NOI. As a side note, 5% down on a $400k loan would make P&I closer to $2040 rather than $1900, and that doesn't include PMI or taxes.

So say you rent out three of the units for $1300 = $3900 monthly income.

Now, subtract 50% for expenses and you're left with $1950 as your NOI.

Take out your mortgage payments of $2040 = -$90 monthly cash flow

So you'll have negative cash flow based on this very loose evaluation, and assuming you live in one unit. If you rented all four units out, your number would change to $560 monthly cash flow.

On paper, it's actually not a bad deal, and you can live in one unit for only $90 per month. Once you move out, you can have $560 cash flow, which is better than $100 per door.

Now, the major "but":

This was done using 50% for expenses, which doesn't take into account PMI or the higher taxes. This is a good example of where the 50% Rule might not be a great first analysis.

My suggestion would be to do a full analysis of the property rather than depending on the 50% Rule. For the sake of keeping this post a little shorter, I'll run a full analysis in a second comment ;)

Rotate Log in or sign up to reply
user profile avatar
  • Posts 620
  • Votes 386

Shawn Ward
Real Estate Investor & Consultant from Los Angeles, CA

replied over 3 years ago

@John Garretson I ran the numbers and this looks like a solid deal. You can cash flow a couple hundred bucks per month. 

All the best!

sjw

Rotate Log in or sign up to reply
user profile avatar
  • Posts 378
  • Votes 304

Ben Wilkins
Rental Property Investor from York, PA

replied over 3 years ago

@John Garretson - in my previous comment, I used the 50% Rule to do an initial analysis. While the property looks good on paper using that method, I then went on to argue that this is a situation where the 50% Rule is not the correct tool.

You could use something higher than 50% for your expenses and still apply that rule, but at that point you're guessing how much more your taxes and PMI will raise the expenses above 50% of your income. So instead, let's do a deeper analysis of this property.

First things first: Income. Since you're thinking of putting 5% down and house-hacking, I'll assume 3 rented units at $1300 each.

Total monthly income: $1300 x 3 = $3900

Next: Expenses

PM (10%): $390

Maintenance (10%): $390

CapEx (10%): $390

Vacancy (8%): $312

Taxes ($7500 annual): $625

Insurance ($2000 annual): $166.67

Utilities ($3500 annual): $291.67

I estimated insurance and utilities, but you can call around to get the insurance quote, and get historical amounts for the utilities.

So your monthly NOI: (Monthly Income) - (All of the above) = $1334.66

Assuming you put down 5%, 30 year loan, 5% interest, with 0.8% PMI, your monthly payment would be $2230.

Cash Flow: NOI - Mortgage = -$895.34 

The 50% rule said that your cash flow would be -$90, which is a far cry from -$900. If you rent all four properties at $1300, you would have -$80 per month cash flow.

As anticipated, the PMI and taxes hurt this deal a lot. My advice: Find a better deal, or see if you can partner with someone to collect the 20% down payment.

I hope this helps!

Rotate Log in or sign up to reply
user profile avatar
  • Posts 378
  • Votes 304

Ben Wilkins
Rental Property Investor from York, PA

replied over 3 years ago

@Shawn Ward - take another look at the taxes, the fact that he will have PMI due to 5% down, and the fact that he's only renting out three units. Even at 4 units, I'm not seeing a positive cash flow, but maybe you saw something that I missed

Rotate Log in or sign up to reply
user profile avatar
  • Posts 620
  • Votes 386

Shawn Ward
Real Estate Investor & Consultant from Los Angeles, CA

replied over 3 years ago

@Ben Wilkins I added the taxes (which are def high), but I did include the fourth unit. Take that away, and yes, you lose + cash flow. 

Rotate Log in or sign up to reply
user profile avatar
  • Posts 459
  • Votes 219

Jay Orlauski
Realtor from Fresno, CA

replied over 3 years ago
Monthly Operating Income Scenario A
Number of Units 3
Average Monthly Rent per Unit 1,250.00
Total Rental Income 3,750.00
% Vacancy and Credit Losses 5.00%
Total Vacancy Loss 187.50
Other Monthly Income (laundry, vending, parking, etc.) -
Gross Monthly Operating Income 3,562.50
Monthly Operating Expenses
Property Management Fees
-
Repairs and Maintenance 166.00
Real Estate Taxes 416.67
Rental Property Insurance 300.00
Homeowners/Property Association Fees
Replacement Reserve
Utilities 180.00
Pest Control (310.00)
Accounting and Legal (60.00)
Monthly Operating Expenses 692.67
Net Operating Income (NOI)
Total Annual Operating Income ( Gross Monthly x12) 42,750.00
Total Annual Operating Expense (Monthly Operating Exp x12) 8,312.00
Annual Net Operating Income 34,438.00
Capitalization Rate and Valuation
Desired Capitalization Rate 8.00%
Property Valuation (Offer Price) 430,475.00
Actual Purchase Price 400,000.00
Actual Capitalization Rate 8.61%
Loan Information
% Down Payment 5.00%
Down Payment 20,000.00
Loan Amount 380,000.00
Acquisition Costs and Loan Fees 4,000.00
Length of Mortgage (years) 30
Annual Interest Rate 5.800%
Initial Investment 24,000.00
Monthly Mortgage Payment (PI) 2,229.66
Total Annual Debt Service 26,755.94
Cash Flow and ROI
Total Monthly Cash Flow (before taxes) 640.17
Total Annual Cash Flow (before taxes) 7,682.06
Cash on Cash Return (ROI) 32.01%

This is what I came up with 

Rotate Log in or sign up to reply
user profile avatar
  • Posts 378
  • Votes 304

Ben Wilkins
Rental Property Investor from York, PA

replied over 3 years ago

@Jay Orlauski - No CapEx? You only have $416 monthly in taxes, when the poster stated $7500 annual ($625 monthly). I assumed he had actual numbers, but it might be less. No property management? Your only savings for each month is 5% vacancy plus 4% maintenance....

It's possible to make any property look good on paper, but you have to account for something breaking eventually. $166 monthly maintenance will barely cover lawn care, snow removal, basic repairs when a tenant moves out. All of your "profit" from the past five years will go toward replacing the furnace, water heater, roof, siding, etc and you'll be left with a loss or deferred maintenance.

For a first investment and someone who is putting down 5%, it would be risky not to set aside savings for CapEx items. He doesn't have other properties to float the repairs, and I'm afraid that your analysis doesn't set anything aside except for vacancies.

Other than that, your spreadsheet seems fairly well laid out. Are numbers in parentheses one-time expenses? Do you include an escrow account for one year of taxes such as most lending agencies request? Would that be included in your initial investment?

Rotate Log in or sign up to reply
user profile avatar
  • Posts 459
  • Votes 219

Jay Orlauski
Realtor from Fresno, CA

replied over 3 years ago

@ben - the Capx I used is the $166 /month which is $2000 / year labeled ( repairs & Maintanance) - probably doesn't cover snow removal and what not -I use it mainly as a way to account for a $2,000 repair bill once a year. I did not use a manager in this case because he is living in one of the units - if he rented out all 4 units , I would add management and the numbers would be different obviously. I used the local ( Fresno) vacancy rate of 5% which came from the last U.S census bureau - you're right about the taxes though I missed that one and used my own local taxes - I should have took note of that better - I usually try to make deals look worse on paper and if they look too good , I will start to undermine it with heavy expenses and higher vacancies - just because , I would rather be pleasantly surprised than to have a bad surprise. Other factors these numbers do not account for is the PMI that will be due until there is 20% equity in the property - and also doesn't account for special conditions like flood insurance if required or other local taxes. These are the numbers I run to see if the property is worth looking into further. If they pencil out here - then I will do a much deeper analysis and due diligence on the property. I hope this was helpful.

Rotate Log in or sign up to reply
user profile avatar
  • Posts 378
  • Votes 304

Ben Wilkins
Rental Property Investor from York, PA

replied over 3 years ago

@Jay Orlauski - fair enough explanation. I am more a fan of putting the expenses and higher vacancy in from the start rather than if it looks too good, but that's just me I suppose. If you have Repairs and Maintenance as your CapEx, what do you use for general maintenance for wear and tear, or when a tenant moves out?

PMI changed, and is now on an FHA loan for life or until refinanced rather than just until 20% - welcome to the new world. It wasn't exactly touted to the general public, and is an easy fact to miss. Because of that, I include PMI in all FHA loans for life during my analyses, or at least account for refinance fees.

Good explanation of your thoughts, but I would rather run safe numbers on my expenses rather than try to undermine it with heavier expenses halfway through my analysis. I'm pretty sure you don't mean it like that, but "undermine" is a strongly negative word ;)

How do you keep from getting into an analysis paralysis mindset if you put in heavier expenses for a deal that looks too good? What if a deal is only "OK" in your first look, so you don't put in the heavier expenses? I would think that it would be better to use conservative numbers from the start based on the individual market - this would give you safer investments and would evaluate properties with a structured approach (if that makes sense)

Rotate Log in or sign up to reply
user profile avatar
  • Posts 459
  • Votes 219

Jay Orlauski
Realtor from Fresno, CA

replied over 3 years ago

Hi Ben - great questions - I start with a basic set of parameters that are typical for my investment area .. if I like what I see - I do a little more digging. I avoid analysis paralysis by understanding that I am loading up the expenses as more of a "just in case" scenario. If a deal just looks "OK" I will still play with the numbers to see what my break even point is and what would have to happen to get there - if there are too many red flags then I walk away - there are still many other factors that I will look at such as location, age of property, type of property , local comps, ARV , potential add-ons and other factors that would affect the cashflow and/or resell value.

On this particular subject property - it appears that everything is brand new which is one of the reasons I didn't add more for the Cap x - but I understand the importance of building it into numbers. Tenant moveouts are partially covered by repair & maintenance. I am aware of the PMI for life with FHA mortgages , which is one of the reasons I try to avoid FHA myself. He does not indicate if this will be FHA or Conventional though.
 

 Overall - I like to see more than $100 / door in cash flow - I don't put a lot of stock into cap rates as it really more of comparison ratio of one property to another - it's the cash flow I like to see and I want to be sure it is making more for me than a (totally ) passive investment  - I have to go - I am heading up our weekly meetup group today and need to head over to the meeting space - It was great sharing with you all .. I look forward to more engaging dialog. 

Rotate Log in or sign up to reply
  • 1
Related Resources Real Estate Deal Analysis and Advice
The 2% Rule: Fact, Fiction, or Feasible? (Updated 2021)
Is That Neighborhood Up-and-Coming? Here’s How to Tell
Do Your Due Diligence Before Digging Up Dirt: Investing in Vacant Land 101
Best Deal Ever: How a Postcard Gets the Phone Ringing
Meet the Investors: I Sold My Wife on House Hacking With a PowerPoint (& Soon We’ll Live for Free!) Featuring Joaquín Camarasa
Resources Read, see, and learn more!
Link Real Estate Investment Calculators
Link BiggerPockets Blog
Link Path to Purchase
Link Mortgage Loans
Link Find a Contractor
Link Real Estate Agents
Link Hard Money Lenders
Link Real Estate Listings

Top Contributors

Joe Villeneuve
Joe Villeneuve
Plymouth, MI
9.29
Score
Justin Phillips
Justin Phillips
Phoenix, AZ
5.72
Score
Joe Splitrock
Joe Splitrock
Sioux Falls, SD
5.16
Score
Deryck C.
Deryck C.
San Francisco Bay Area
4.63
Score
Collin Lee Johnson
Collin Lee Johnson
Mankato Minnesota
3.36
Score

Real Estate Deal Analysis and Advice Trending Discussions

  • How To Factor An Equity Pull-Out in Cashflow Calculation
    7 Replies
  • First Timer. Can anyone help me analyze this deal?
    4 Replies
  • Credit cards for rehab projects
    3 Replies
  • What to do: opportunity to buy a 400k home for 215
    10 Replies
  • Which mortgage should I pay down first?
    44 Replies
Log in Sign up

Log in

Forgot password?

If you signed up for BiggerPockets via Facebook, you can log in with just one click!

Log in with Facebook

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Let's get started

We just need a few details to get you set up and ready to go!

Use your real name

Use at least 8 characters. Using a phrase of random words (like: paper Dog team blue) is secure and easy to remember.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.

Or
btn_google_dark_normal_ios Created with Sketch. Continue with Google

Why create an account?

Receive a free digital download of The Ultimate Beginner's Guide to Real Estate Investing.

Connect with 1,000,000+ real estate investors!

Find local real estate meetups and events in your area.

Start analyzing real estate properties, we do the math for you.

It's free!

Explore

  • Membership
  • Community
  • Education
  • Marketplace
  • Tools
  • FilePlace
  • REI Resources
  • Perks
  • Glossary
  • Reviews
  • iOS App
  • Android App

Company

  • About Us
  • Press
  • Advertising
  • Careers
  • Stats
  • Contact Us

Important

  • Editorial Guidelines
  • Terms of Use
  • Rules
  • Privacy
  • FAQ

Social

  • Facebook
  • Twitter
  • YouTube
  • Instagram
© 2004-2021 BiggerPockets, LLC. All Rights Reserved.