Skip to content
Real Estate Spreadsheets
  • SpreadsheetsExpand
    • Rental Property Analysis
    • House Flipping & Rehab
    • Airbnb Calculator
    • Comparative Market Analysis
    • Excel Mortgage Calculator
  • Online CalculatorsExpand
    • Rental Property Calculator
    • House Flipping Calculator
    • Airbnb Estimator
  • My AccountExpand
    • Orders
    • Downloads
    • Account Details
    • Affiliate Dashboard
  • HelpExpand
    • Contact Us
    • FAQs
    • Documentation
    • Changelog
  • ResourcesExpand
    • Blog
    • Best Real Estate Resources
    • Home Inspection Checklist
Shopping Cart 0
Pricing
Real Estate Spreadsheets

Support

5
  • How to Open a Corrupted Workbook
  • How to Fix “The File Extension Is Not Valid”
  • I get a #NAME? error when opening the spreadsheet
  • How to download my spreadsheet?
  • How to unblock macros?

Learning

1
  • Key Financial Ratios

Rental Property

10
  • Mortgage Tab
  • Estimate Maximum Purchase Price
  • Run Alternative Scenarios
  • Available Reports
  • Multi-Unit Forecasts
  • Dashboard Overview
  • Forecasts Sheet
  • Debt Sheet
  • Multi-Units Assumptions
  • Customize Your Spreadsheet

House Flipping

12
  • Getting Started
  • Dashboard Overview
  • Build Your Repair Database
  • Review Your Project By Area
  • Keep Track of Deadlines (Schedule)
  • Compare Actuals Vs. Budget (Tracker Tab)
  • Keep Track of Your Expenses
  • Keep Track of Your Vendors
  • Run Alternative Scenarios
  • Estimate Maximum Purchase Price
  • Customize Your Spreadsheet
  • Available Reports

FAQ

4
  • How to Add My Own Logo & Property Photo
  • How to change the Print Area on a worksheet
  • How to change column size of a sheet?
  • How to whitelist an Email Address

Sourcing Data

3
  • How to Estimate Rent
  • How to Estimate Vacancy Rate
  • How to Estimate Operating Expenses

Comparative Market Analysis

4
  • Listing Tab
  • Comps Analysis
  • Selection Report
  • Summary Report

Licenses

8
  • Where can I find my license key?
  • How do I register my spreadsheet?
  • How many license keys can I get?
  • How do I generate a license key?
  • How can I delete my license key?
  • How can I associate my license with another computer?
  • What is the Workbook Key?
  • What is the Check Status button?

Affiliate Program

6
  • What is your Affiliate Program?
  • How do I join your program?
  • What happen after a customer clicks my link?
  • Where do I get my affiliate link?
  • How do I get paid?
  • How does the dashboard work?
  • Home
  • Docs
  • Comparative Market Analysis
  • Listing Tab
View Categories

Listing Tab

3 min read

0:00 / 4:34
  • View as Markdown Open this page as plain Markdown (opens in a new tab)
  • Export PDF Download this page as a PDF
  • Open in ChatGPT Ask questions about this page (opens in a new tab)
  • Open in Claude Ask questions about this page (opens in a new tab)
  • Open in Google AI Studio Ask questions about this page (Google account required) (opens in a new tab)

The listing tab will help you keep track of all the properties you review, provide high-level financial metrics for each property as well as keep track of the offers you make and feedback you receive.

This tab is split in 4 sections: Property Information, Listing Details, Financial Data and Actions. You can easily navigate from one section to another using the left menu:

Similarly, you can add as many new lines as desired by clicking on the Add a Comp Line button:

Property Information

Includes all the details about the property (location, type, size, number of beds, baths, etc.). This section also includes 8 custom columns under the “Custom Property Features” sub-section that you can freely customize (by directly renaming the columns):

Listing Details

This section includes all the details regarding the property listing, including:

  • Status: Indicate if the property is currently for sale or already sold
  • Listing Price: indicate the price at which the property was listed for. This price may be different from the price at which the property was ultimately sold (called “Sold Price” in the spreadsheet)
  • Listing Date: Indicate when the listing was first published online
  • Days On Market: Field calculating the number of days between the listing date and today’s date (if still for sale) or the sale date (if already sold)
  • Sale Date: Indicate when the property was last sold. Only available if the status of the property is set on “Sold”
  • Sold Price: Indicate how much the property was sold for in the most recent transaction
  • Var vs. List: Difference between the Sold Price and Listing Price
  • Previously Sold For: Indicate how much the property was sold for in the previous transaction. This figure will help you assess how much the property has appreciated (or depreciated) between the previous sale and the most recent sale
  • Previous Sale Date: Indicate when the property was previously sold

Financial Data

This section includes the key operating figures of your property and automatically estimates key financial metrics.

  • Rent Estimate: Indicate the total rent estimate for the property. If the property includes multiple units, add all rents in that cell.
  • $ / Sqft: Field calculating the price per square foot of the property.
    • Note that you can select if you want this KPI to be calculated based on the current listing price (if still for sale), the selling price, the previous sale price or simply the most recent figure (which will either be the listing price, if the property is currently for sale, or the “Sold Price” if the property is not on the market anymore)
  • Past Appreciation: Field calculating the compound annual growth rate (CAGR) of the property’s past appreciation (i.e. variation in price between last sale and previous sale). For instance, a 5% Past Appreciation rate means that your property price grew by 5% per year on average between the date of the previous sale and the date of the most recent sale (based on each selling price at the time)
  • 1% Rule: General guideline used by real estate investors. It is the ratio of monthly rent over property price. This rule of thumb states that the monthly rent should be equal to or greater than one percent of the total purchase price of an investment property.
  • Rule of Thumb Expenses: Quick estimate of the operating expenses. You can select the desired percentage in the menu located above the column
  • NOI: Field calculating the Property’s Net Operating Income based on estimated rent and operating expenses (assessed via a Rule Of Thumb)
  • Principal & Interest: Field estimating the monthly P&I based on the property’s price (either listing or sold). Mortgage parameters (term, interest rate, down payment %) can be entered in the menu located above the column
  • Net Cash Flow: Calculated as the property’s estimated NOI minus P&I
  • Cash Needed: Estimates the amount of cash needed to purchase the property, based on the property price, your down payment %, and other acquisition & financing costs (that can be modified in the menu located above the column)
  • Cap Rate: Field calculating the Capitalization Rate for the property, based on its price and its estimated NOI
  • Cash on Cash Return: Calculated as the Annual Net Cash Flow over Cash Needed to purchase the property

Actions

To easily keep track of your offers

  • Offer Price: Indicate how much you offered for the property
  • Offer Date: Indicate when you made the offer
  • Difference: Field calculating the difference between your offer price and either the Listing Price, the Sold Price, the Previous Sale or the most recent price (either listing or sold). This can be adjusted using the menu located above the column
  • Time Since Offer: Field indicating how many days have passed since you made an offer
  • Feedback: Custom field to indicate the feedback received from the vendor / real estate agent on your offer
  • Comment: Custom field to add any additional information regarding the property and its listing

 

Still stuck? How can we help?

How can we help?

Updated on April 13, 2021
Summary ReportComps Analysis

Powered by BetterDocs

The Ultimate Source of Real Estate Spreadsheets
Facebook Twitter Instagram Facebook Group Pinterest Linkedin

Spreadsheets

  • Rental Property Analysis
  • House Flipping & Rehab
  • Airbnb Calculator
  • Comparative Market Analysis
  • Excel Mortgage Calculator

Resources

  • Blog
  • FAQs
  • Documentation
  • Changelog
  • Best Resources
  • Home Inspection Checklist

About Us

  • About Us
  • Terms And Conditions
  • Privacy Policy
  • Contact Us
  • Become an Affiliate

Other Websites

  • Disciplined Finance

    Graz-Apotheke.com

© 2026 Real Estate Spreadsheets – All rights reserved.

  • Spreadsheets
    • Rental Property Analysis
    • House Flipping & Rehab
    • Airbnb Calculator
    • Comparative Market Analysis
    • Excel Mortgage Calculator
  • Online Calculators
    • Rental Property Calculator
    • House Flipping Calculator
    • Airbnb Estimator
  • My Account
    • Orders
    • Downloads
    • Account Details
    • Affiliate Dashboard
  • Help
    • Contact Us
    • FAQs
    • Documentation
    • Changelog
  • Resources
    • Blog
    • Best Real Estate Resources
    • Home Inspection Checklist
Purchase
Search