• Skip to main content

Denver Investment Real Estate

Helping Investors with Denver Residential Real Estate

  • Denver
    • Start Here
    • Deal Analyses
    • Market Updates
    • Denver Podcast
  • Springs
    • Start Here
    • Deal Analyses
    • Market Updates
    • Springs Podcast
  • Education
    • Free Toolkit
    • Podcasts
    • Getting Started Guides
    • Courses
    • Books
    • Events Calendar
    • Blog
  • Spreadsheets
    • Rental Property
    • House Hacking
    • BRRRR
    • Fix and Flip
    • Return on Equity (ROE)
  • Services
    • Rental Properties
    • House Hack
    • Sell
    • 1031 Exchanges
    • Investment Consultation
  • Portfolio Analysis
    • About Portfolio Analysis
    • Portfolio Consultation
  • About
    • About Us
    • Team
    • Our Process

Denver Rental Property Spreadsheet

December 4, 2019 • Chris Lopez

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.
Download Spreadsheet

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.
Download Spreadsheet

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!

IPAC Table of Contents
  • Overview: Investment Property Anaylsis Course (IPAC.)
  • Module #1: The Four Returns in Real Estate: Cash Flow is NOT everything
  • Module #2: Rental Property Analysis Spreadsheet Tutorial
  • Module #3: Return on Equity: Playing Adult Monopoly
  • Module #4: Refinancing Your Primary Residence to Purchase Denver Investment Property
  • Module #5: Tapping into Your Primary Residence Equity Updates – Part #2
  • Module #6: Case Study: Investing $100,000 from a Primary Residence Cash-Out Refinance

About Chris Lopez

Investor Friendly Realtor| Investor | Host of the Denver Real Estate Investing Podcast | Call Chris at (303) 548-0846 | Chris@envisionrea.com | Read more about Chris...

Real Estate Investment Consultation
Creating your real estate investing strategy and putting together your team can be a daunting task. Schedule your free Colorado real estate investment consultation to start creating your personalized plan.

Envision Advisors Logo
Copyright © 2022 · All Rights Reserved

Envision Advisors at Your Castle Real Estate · 2755 S. Locust St #243, Denver CO 80222

Return on Investment Quadrant™, True Cash Flow™ and Nomad™ are trademarks of Real Estate Financial Planner LLC and used with permission.

denverinvestmentrealestate logo

Disclaimer:This information is designed to provide accurate and authoritative information with regard to the subject matter covered. It is offered with the understanding that the presenters are not engaged in rendering legal, accounting, or other professional services. If legal advice or other expert advice is required, the services of a competent professional should be sought.

Privacy Policy | Terms of Use | Disclaimer