Skip to content
Multi-Family and Apartment Investing

User Stats

205
Posts
32
Votes
Abou C.
  • Wholesaler
  • Central Falls, Philadelphia
32
Votes |
205
Posts

Spreadsheet?

Abou C.
  • Wholesaler
  • Central Falls, Philadelphia
Posted Nov 22 2015, 15:52

Hello

Any one has a downloadable speed sheet they use for buy and hold?, U understand bigger pocket has their own which I intend to use as well, but I like to practice detailed analysis of deals. Preparing myself.

Thank you! 

User Stats

103
Posts
70
Votes
Michael Sjogren
  • Rental Property Investor
  • Middleton, MA
70
Votes |
103
Posts
Michael Sjogren
  • Rental Property Investor
  • Middleton, MA
Replied Nov 23 2015, 20:01

Hi @Abou C. Personally, I like Michael Blank's syndicated deal analyzer. It is extremely thorough for underwriting multi-family properties. You can find it on his website at www.themichaelblank.com 

User Stats

16,528
Posts
28,445
Votes
Russell Brazil
  • Real Estate Agent
  • Washington, D.C.
28,445
Votes |
16,528
Posts
Russell Brazil
  • Real Estate Agent
  • Washington, D.C.
ModeratorReplied Nov 23 2015, 20:09

@Michael Blank analyzer is probably the best one Ive seen for complex deals and commercial size deals.  @Brandon Turner has a very easy to use spreadsheet available on his website, which I use for most of my analysis.

District Invest Group Logo
BiggerPockets logo
BiggerPockets
|
Sponsored
Find an investor-friendly agent in your market TODAY Get matched with our network of trusted, local, investor friendly agents in under 2 minutes

User Stats

684
Posts
350
Votes
Vincent Crane
Pro Member
  • Realtor
  • Atlanta, GA
350
Votes |
684
Posts
Vincent Crane
Pro Member
  • Realtor
  • Atlanta, GA
Replied Nov 23 2015, 20:10

I believe that @J.Scott has one that's pretty good

User Stats

205
Posts
32
Votes
Abou C.
  • Wholesaler
  • Central Falls, Philadelphia
32
Votes |
205
Posts
Abou C.
  • Wholesaler
  • Central Falls, Philadelphia
Replied Nov 23 2015, 20:59

@Michael Sjogren@Michael Quarles@Michael S.  Thank you guys I will look into them, and buy one. I love bigger pockets spreadsheet tool, but it isn't as detailed as I would want it to. 

User Stats

10
Posts
0
Votes
Randy Wilson
  • New London, CT
0
Votes |
10
Posts
Randy Wilson
  • New London, CT
Replied Jul 17 2017, 08:40

Have you looked into the money Trees Full of Money Spreadsheet?

User Stats

196
Posts
69
Votes
Austin Works
  • Investor
  • West Monroe, LA
69
Votes |
196
Posts
Austin Works
  • Investor
  • West Monroe, LA
Replied Mar 16 2018, 05:22
Originally posted by @Russell Brazil:

@Michael Blank analyzer is probably the best one Ive seen for complex deals and commercial size deals.  @Brandon Turner has a very easy to use spreadsheet available on his website, which I use for most of my analysis.

 Can you provide a link to @Brandon Turner's spreadsheet? I would greatly appreciate it!

User Stats

1,473
Posts
1,990
Votes
Omar Khan
  • Rental Property Investor
  • Dallas, TX
1,990
Votes |
1,473
Posts
Omar Khan
  • Rental Property Investor
  • Dallas, TX
Replied Mar 16 2018, 07:44

@Abou C. I live and breathe Excel and have underwritten multi-million syndications. My best advice would be to (only applies in commercial):

  • steer clear of "mentors" and their spreadsheets - most mentors give their students one set of spreadsheets and use a different set for themselves
  • develop your own models (invest the time to learn now) and if not, hire someone who's a professional (not a marketing or IT guy who happens to run this as a side income project)
  • good to see that you want to look @ details. I have come across multiple people who've told me that the model/calculator/deal analyzer indicated that it was a good deal (without providing context around the #). The problem with spreadsheets is that they will ALWAYS follow your instructions. Without context and color around your #s, you won't know why something is happening.
  • hiring a finance professional will add a level of financial sophistication and credibility because you just don't want to provide your lenders/equity partners a spreadsheet print out. You need to be able to talk about all the #s to sketch out the entire picture.

User Stats

1,014
Posts
671
Votes
Henri Meli
  • Investor
  • Morrisville, NC
671
Votes |
1,014
Posts
Henri Meli
  • Investor
  • Morrisville, NC
Replied Mar 16 2018, 10:26

@Omar Khan I think you make lots of good points, however ... some nuances need to definitely be added.

1. Spreadsheets really only offer guidance and the final decision maker should be the investor. So, nobody should ever really say "I made this purchase because spreadsheet xyz told me to do so". 

2. As you mentioned well, Spreadsheets only do what they have been told to do. Just like computer Software. They are programmed by human being and can only deal with data and formulas they have been taught. Go-no-go decisions should involve a lot of information, lots of which cannot be added to a spreadsheet.

3. A Spreadsheet represents also someone's snapshot of knowledge in time. As we grow and learn (I'm sure "Gurus" also grown and learn), newer versions are created to reflect the additional knowledge gained. Same as software, there is version 1.0, 2.0, ... etc. 

4. Spreadsheets should really only complement other criteria. Crime rates, School rankings, Population growth, Investor experience, ... etc cannot be entered into a spreadsheet. Those should have a weight into the final decision.

5. I used multiple spreadsheets, some from "gurus", some I wrote myself ... But, I also have my own check list which reflect my comfort level , my expertise level at the time of the deal, ... etc. 

6. As you learn and grow as an investor, you need to make sure to update your criteria/checklist.