Help & Support

Listing 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

 

Updated on April 13, 2021

Follow Us

© 2021 RealEstateSpreadsheets.com – All rights reserved.