Skip to content

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
FilePlaceDustin Beam's FilesBuy and Hold Analysis

Buy and Hold Analysis

XLSM

uploaded by Dustin Beam

533 KB

File Size

3K

Downloads

N/A

Rating

**Deleted old file and replaced with this. Has more options like Internal Rate of Return, Owner Finance, and Amortization Table. Please let PM me if you find errors! Can be used for SFH or Mult-unit properties. Itemized CapX, Management, etc. Kicks out Cash on Cash returns, Monthly Cashflow, and Equity in property at any given year. Easy to use!

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

doesn't calculate appreciation. not useful also doesn't enable what if scenarios to improve cap rate and back calculate offer

Patrick Tobin | over 5 years ago  

This is awesome! Thanks Dustin for sharing!!

Sean Mcmahon | almost 7 years ago  

excel claims errors in worksheet formulas and won't open

Jim R. | about 7 years ago  

This is brilliant

Manthan Kanabar | over 7 years ago  

Great Sheet! Thank you!

Nick Childs | almost 8 years ago  

Thank you Dustin. Well done.

Carolyn Q. | almost 8 years ago  

Looks awesome! But agreed.. It only opens in "compatibility mode"... can't add it to Google Suite account.

Hayden Power | about 8 years ago  

Great job Dustin, just what i needed...

Stallone D watson | about 8 years ago  

Doesn't transfer over to Google Sheets for those that use it. Some issue with named ranges. Great sheet, I just need one that works on Google Sheets.

Josh Cossey | about 8 years ago