Property Analysis Sheet? Anyone want to share

Property Analysis Sheet? Anyone want to share

Pleasant Hill, CA · Member since 2008 · 428 posts · 43 votes

Would anyone like to share a copy of a property analysis sheet that they use? Thanks for your reply!

0Reply
24 views

9 Replies

Jump to latestLatest
  • Real Estate Investor · OH · Member since 2008 · 4k+ posts · 1k+ votes
    18y

    I just do it in my head. I don't use a property analysis sheet.

    Good Luck,

    Mike

  • Real Estate Investor · Flint, MI · Member since 2009 · 6 posts · 0 votes
    17y
    Originally posted by MikeOH:
    I just do it in my head. I don't use a property analysis sheet.

    Good Luck,

    Mike


    Hello Mike,
    Any chance you are willing to share the calculations you do in your head?
    Thanks,
    Victor
  • Real Estate Investor · OH · Member since 2008 · 4k+ posts · 1k+ votes
    17y

    Hi Victor,

    Yes, I'll be happy to share. I would suggest that you start by reading this thread:

    http://www.biggerpockets.com/forums/48/topics/26378-validate-the-5-rule

    If you have any questions after you read that, just ask!

    Good Luck,

    Mike

  • Will BarnardPro Member
    Moderator
    Developer · Santa Clarita, CA · Member since 2008 · 15k+ posts · 10k+ votes
    17y

    Jason,
    perhaps you could be more specific as to what type of property and strategy you choose to do as the calculations differ from strategy to strategy, from investment type to investment type.

    For a buy and hold, you can do a quick and basic analysis by assuming that ALL the expenses, including operating, loss to vacany, and capital expenses will be 50% of the gross rents. Then calculate your mortgage paymnet based on 100% of the purchase price and any initial rehab expenses and the final number should be at least $100 per door. This of course is a simple and general calculation and you may experience lower or higher expense ratios depending on what, where, and how you invest.

    For rehab flips, you should not pay more than 70% of the ARV less repairs. Under some circumstances, this % may need to be decreased.
    Hope that helps some.

  • Real Estate Broker · Rochester Hills, MI · Member since 2009 · 2k+ posts · 2k+ votes
    17y

    In addition to the question Will asked about what strategy - I have different ways of looking at deals depending on what I am doing - buy / hold - rent / land contract - wholesale - senior on a reverse blah blah.....

    Also commercial or residential ?

  • Real Estate Investor · Flint, MI · Member since 2009 · 6 posts · 0 votes
    17y

    Mike,
    Thanks for the information. That thread (and others I found on 50%) are very helpful. I'm feeling more prepared for my first deal every day.

  • Rental Property Investor · Omaha, NE · Member since 2008 · 62 posts · 14 votes
    17y

    Here is the one I used for buy and hold. I'm sure it isn't perfect, but it works for me.

    http://members.cox.net/elimbeck/30thAve.xls

  • J ScottPro Member
    Moderator
    Investor · Sarasota, FL · Member since 2008 · 18k+ posts · 17k+ votes
    17y

    Here's a very simplified version of what I use to analyze flips:

    http://www.123flip.com/rehab-analysis-worksheet

    And here's what I use for buy-and-hold:

    http://jason.netrino.com/PropEval/PropertyEval.xls

    I mostly use this buy-and-hold spreadsheet for analyzing multi-family/apartment investments, but it can be simplified for SFH.

  • Curt DavisBusiness Member
    Flipper/Rehabber · Memphis, TN · Member since 2008 · 5k+ posts · 2k+ votes
    17y

    Jason,

    Here is a link to the financial model we use when evaluation any property for any strategy. Just copy and paste it into your search bar. Let me know what you think.

    http://www.box.net/shared/7y3jdasysx

    Curt Davis - KAIZEN Realty538 Reviews
Join the conversationCreate a free account to reply, vote on answers and follow this thread.