Don’t buy a bad deal! Use our Denver Rental Property Spreadsheet to quickly and accurately analyze Denver rental properties. The spreadsheet was created by Joe Massey, Senior Loan Officer at Castle & Cooke Mortgage, to help investors find the “right deal” for their portfolio. Stop spending money on investment calculators and download our free Denver-focused rental property analysis spreadsheet to start analyzing deals immediately.

The rental property spreadsheet is a free download for you to use. I use it and recommend it because it’s the right balance for return analysis and simplicity.

Latest version:
Version 6.2 – October 12th, 2020

The spreadsheet is designed to analyze two types of rentals:

  • Rental properties
  • House Hacking and Nomad™ properties (owner-occupied investment properties)

There are tutorial videos and spreadsheets with variables and assumption data. If you’re a client of mine, please email me your property analyses so we can discuss and refine them. If you’re not a client, I do not have the time to review your spreadsheets as that is a perk reserved for clients. The information on this page should help out many Denver real estate investors.

Free Rental Property Analysis Spreadsheet Download

Get the Rental Property Analysis Spreadsheet in our free Real Estate Investng Toolkit.

Tutorial: Denver Rental Property Analysis

This video will walk you through how to analyze a rental property. Joe and I discuss a recent condo rental that I purchased.

Tutorial: Denver House Hack and Nomad™ Analysis

This tutorial will walk you through how to analyze a house hack property. We use a recent house hack property that we helped a client close on.

Tutorial: “Long Term Analysis” Tabs

We discuss the two tabs on the spreadsheet for long term analysis. Personally, I hardly ever look at these as I like to focus on the first two tabs to estimate the year 1 returns.

Assumptions

I put together a table from three real transactions to show the various costs associated with buying the properties. Realize that you’ll not be 100% accurate on your costs while you’re analyzing the properties. The total amount will change based on numerous factors. Once you’re under contract and talk with your lender, you’ll be able to better analyze the properties. Two big possible expenses are whether you decide to buydown points to lower your interest rate or prepay PMI (for less than 20% down properties)

Here’s what I use to ballpark the “Acquisitions Costs” (Cell B25):

  • Condo / townhome: $3,000
  • House: $5,000
  • Multi (2-4 units): $7,000

Download the Spreadsheet for Free

You must have a free account to download the spreadsheet. Click here to log in or click here to create a free account.

Spreadsheet Screenshots

Here are two screenshots of the spreadsheet. The yellow fields are editable. The first one is the “Inputs” tab where you put in all the property data.

Here is the “cash flow” tab that shows you the results of the property analysis.

Investment Property Analysis Course (IPAC)
This post is part of the Investment Property Analysis Course. The course teaches you how to analyze a rental at purchase and how to review it annually to optimize your returns.

Three Learning Options:
  1. Listen to episode “#119: IPAC #2 – Rental Property Analysis Spreadsheet Overview” on the Denver Real Estate Investing Podcast
  2. Watch the YouTube video at the bottom of the page.
  3. Read the blog post (updates coming soon.)

Enjoy!

Analyze Before You Buy
Start Evaluating Properties Today with Our Free Toolkit
In a rapidly changing market, having the tools you need to help you analyze the data is critical. Know what the numbers will look like ahead of time so you don't buy a bad deal. Our toolkit is designed to help you thoroughly analyze any kind of deal so you can invest with confidence.
Start analyzing your Colorado investment properties today
Rental Property Spreadsheet • House Hacking Spreadsheet BRRRR Calculator Spreadsheet • Fix and Flip Deal Analyzer Investing Maps • Rehab Pricing Estimator
Start analyzing your Colorado investment properties today
Rental Property Spreadsheet • House Hacking Spreadsheet BRRRR Calculator Spreadsheet • Fix and Flip Deal Analyzer Investing Maps • Rehab Pricing Estimator
Authors
Chris Lopez
Chris Lopez is a Denver area real estate entrepreneur and investor, as well as the host of Bigger Pockets’ House Hackerz and the Denver Real Estate Investing Podcast.
Similar Post You Might Also Like
Colorado Springs
Can You Boost Cash Flow by Mixing Rental Strategies?
Residential multifamily investors aren’t locked in to just one rental strategy. In Colorado Springs, investors Greg and Heather are combining
Deal Analysis - Denver
How This Investor Still Lives for Free
Jeff White joins us to analyze his 7th house hack—just one away from his ultimate goal of owning 8 properties!
Sign Up For Our Newsletter
What do you want to learn today?