BiggerPockets

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

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

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.

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.

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.