Full Analysis Tool - Hold or Flip

XLSX

uploaded by Ryan Sanders

106 KB

File Size

2.1K

Downloads

N/A

Rating

This is my spreadsheet that will analyze any deal I look at. This tool will analyze buy and hold investments or fix and flips. It will even allow you to consider both types of investment side by side if you would like. Somewhat complicated, but after playing with it for a while you'll see there's a wealth of great info! BE SURE TO READ THE INSTRUCTIONS TAB IN THE SPREADSHEET FIRST! If you feel like ranking this as 1 star, please at lease detail the reason. This will allow me to improve the spreadsheet.

Download File

Disclaimer: Safety of files uploaded to the BiggerPockets FilePlace cannot be guaranteed. Download at your own risk.

Rate this file

Pick a rating between 1 and 5 stars

Comments

Great Job! Thanks for sharing. By far the most useful spreadsheet for Investors!

Paul Orsenigo | over 6 years ago

Simply amazing. I am still studying the file. I love the CapEx schedule, I believe that's a number many over-look. Great job...

Lloyd Winston | almost 7 years ago

This is an amazing tool! If you take a couple minutes to read the instructions tab, you should have no issues understanding its complexity. The only issue I found was lines 25-31 on the "Display - Buy & Hold" Tab. The values are pointing to incorrect cells on the "Analysis - Buy & Hold" Tab. This should be an easy fix though. Great job and thanks for sharing!!

Brandon Rader | about 7 years ago

@Brian S. Once you follow the first instructions on changing what it asks, you should be ok. It works well, I'm only looking for buy and hold but it is very thorough.

Joe Swanson | over 7 years ago

Hi, I got the following error when attempting to open: Cell references in the formula refer to the formula's result, creating a circular reference. For help with correcting a circular reference, click OK.To continue without changing the formula, click Cancel.

Brian S. | over 7 years ago

I just downloaded the spreadsheet and used it on a house I'm looking at now. I thought the spreadsheet was well laid out, giving the critical info. needed to analyze the property. Well done!!!

Kevin Romines | over 7 years ago

I'm sure it's a great tool and I would like to learn to use it effectively. I'm only so-so proficient at excel so maybe it's me...but I never got past step 1. Can you direct me to "file, then options" for the iterative calculations.

Elldee Davis | almost 8 years ago

Just a tip, it's helpful to upload the spreadsheet with a fake deal being analyzed so others can follow the numbers throughout the spreadsheet.

Austin Mudd | almost 8 years ago