Skip to content
Get started
Resources & Media
Resource Hub Bookstore Blog Guides Pro-Exclusives PRO Podcasts Pro Partnerships Newsletters NEW
Events & training
BPCON2025 Webinars Bootcamps Upcoming Events Free Courses
Strategies
How to Manage Your Rental Property How to Operate a Short-Term Rental How to Passively Invest in Real Estate How to House Hack How Does the BRRRR Method Work How to Flip a House How to Invest in Commercial Real Estate How to Invest in Real Estate How to Invest in Multifamily Real Estate How to Build Wealth
BPCON2025
This is your chance to learn from the best, network with the best, and become one of the best in the game.
Build Wealth Without Tenants
Become a stronger passive investor with proven frameworks, actionable insights, and lots of networking.
Pick markets
Pick markets
Market Finder - NEW PRO Picking a Market Workshop PRO Picking a Market Worksheet Top 100 Cash Flow Markets Market Insights - Sunbelt Region
Market finder
Pinpoint the best real estate market for your specific goals with expert recommendations and real-time data on appreciation, affordability, rent to price ratio, and more.
Find deals
Find deals
BiggerDeals NEW Off-Market Deal finding PRO Real Estate Syndications Investor-Friendly Agents Find Foreclosures Community Listings (FSBO) Business Directory
BiggerDeals
Quickly find your perfect investment property based on your cash flow and ROI goals.
Invelo - Off market deals
Scale your portfolio with off-market deals
Analyze deals
Calculators
Rental Property Calculator PRO Rehab Estimator PRO Rent Estimator PRO BRRRR PRO Fix & Flip PRO Short-Term Rental PRO Sell vs. Keep PRO Landlord Insurance Calculator by Steadily All Calculators
Rental property calculator
Is it a good deal? Run your numbers like a pro with this simple yet powerful calculator.
Rent estimator
Understand how much rental income you can expect based on recent reports and data for your specific property.
Manage properties
Manage properties
Managing Properties 101 Find a Property Manager RentRedi Property Management Software PRO Property Management Tools Ask a Management Question Finding Tenants PRO Screening Tenants PRO Leases + Landlord Forms PRO Accounting/Bookkeeping PRO Property Insurance Property Maintenance / Rehab Baselane Banking and AI Bookkeeping
Property management software
Manage tenants, tasks, and your entire portfolio with one simple tool.
Property manager finder
Find reliable property management partnerships that last.
Forums
For You
Newest Trending Unanswered My Discussions Followed Discussions Followed Categories Followed Locations Followed People
General Real Estate
General Real Estate Investing Starting Out Deal Analysis Buying & Selling Business & Marketing Landlording Property Management Reviews & Feedback
Real Estate Strategies
House Hacking BRRRR Short-Term Rentals Mid-Term Rentals Multi-Family Fix & Flip Other Strategies
Finance & Financing
Lending Creative Finance Personal Finance Taxes & Legal Issues
News & Announcements
Official Site Announcements Market Trends & Data Real Estate News & Current Events Pro Exclusive Area PRO
Events & Networking
Events & Meetups Classifieds
Store
All Books
Best Sellers Browse All New Books & Pre-Orders PRO Bundle & Save Books for Beginners
Flip your way to financial freedom
Scale your investment framework with this valuable guide to compounding real estate success.
Outsmart the short-term rental competition
Cash in on the exploding STR market with this must-have guide from expert Avery Carl.
Pricing
Plans and Pricing
Pro Membership Business Membership
TRY PRO FOR 7 DAYS COMPLETELY FREE
Avoid mistakes and make informed decisions with Pro.
GROW YOUR BUSINESS
Promote your business on BiggerPockets and make quality connections with the right investors
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 54%
$32.50 /mo
$390 billed annualy
MONTHLY
$69 /mo
billed monthly
7 day free trial. Cancel anytime
×
Try Pro Features for Free
Start your 7 day free trial. Pick markets, find deals, analyze and manage properties.
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 | about 4 years ago  

This is awesome! Thanks Dustin for sharing!!

Sean Mcmahon | almost 6 years ago  

excel claims errors in worksheet formulas and won't open

Jim R. | about 6 years ago  

This is brilliant

Manthan Kanabar | over 6 years ago  

Great Sheet! Thank you!

Nick Childs | over 6 years ago  

Thank you Dustin. Well done.

Carolyn Q. | over 6 years ago  

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

Hayden Power | almost 7 years ago  

Great job Dustin, just what i needed...

Stallone D watson | almost 7 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 7 years ago