Denver Rental Property Spreadsheet

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

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

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.