Skip to main content

Comparative market analysis template

A priced comparison of a subject property against recent comparable sales, generated per property from your sales data.

Google Docs PDF export No watermark

Free plan, no credit card. Bring your own design or start from this layout.

The actual template Comparative market analysis template shown in Google Docs

What’s in this template

Every block is bound to a field in your data. The layout stays exactly as designed; only the values change from one run to the next.

  • Subject property summary and prepared-for line {{subject.address}} · {{client.name}}
  • Comparable sales table, one row per property loop: {{comparables}}
  • Adjustments made to each comparable loop: {{comparables.adjustments}}
  • Price per square foot and range {{analysis.psf}} · {{analysis.range}}
  • Market conditions and time on market {{market.days_on_market}}
  • Recommended asking price and reasoning {{recommendation.price}}
  • Preparer, date and sources {{agent.name}} · {{prepared_on}}

How this template fills itself

Connect Airtable, Google Sheets, a SQL database, a CSV or a REST API, map each field to a placeholder, and generate. One run can produce a single document or one per matching record.

Real estate: A priced comparison of a subject property against recent comparable sales, generated per property from your sales data.

Comparable sales · SQL database

AddressSoldPrice
19 Kestrel RowJul 2026£528,000
4 Priory CloseJun 2026£511,500
27 Bramble WayMay 2026£549,000

Template: Google Slides or Docs

{{subject.address}}

Comparative market analysis · {{prepared_on}}

loop: {{comparables}} → row

{{analysis.range}} range

{{recommendation.price}} recommended

one analysis per subject property; the table repeats a row per comparable

Generated output

DocsPDF

22 Kestrel Row

Comparative market analysis · 4 Sep 2026

6 comparables listed

£505,000–£555,000 range

£540,000 recommended

Who uses this template

Listing agents

Back a suggested asking price with the sales that support it, prepared before the valuation appointment.

Read the guide

Brokerage and valuation teams

Keep every analysis in the same structure so two agents pricing similar homes show their working the same way.

Read the guide

Investors and buying agents

Produce a written comparison per property under consideration from the sales data you already pull.

Read the guide

A comparative market analysis argues a price. It puts a subject property next to recent sales that are genuinely like it, shows the adjustments made for size, condition and date, and lands on a recommended figure a seller can follow. The evidence is the document, so its length depends on how many comparables the market gives you, which is what Docs handles and a fixed slide layout does not.

Choosing the comparables in the data

The selection rules belong in the query, not in the writing. Set the radius, the property type, the size band and how far back a sale still counts, then let the run pull whatever matches and repeat a row for each. When a property has too few comparables the document shows that rather than hiding it behind three cherry-picked sales. Keep the adjustment for each comparable in a field beside it, so the reasoning travels with the number and the same house priced twice gives the same answer.

Common questions, answered

Why is a CMA a Google Doc rather than a deck? +
Because the number of comparables varies. A rural property might have three defensible sales to point at and a city block twelve, and the adjustments written against each one are not the same length either. In Docs the table repeats a row per comparable and the pages break themselves; on a slide you would be cutting evidence to fit.
Where do the comparable sales come from? +
From wherever you hold them: a SQL database, Airtable, Google Sheets, a CSV export or a data provider through a REST data source. The document places the sold prices, dates and adjustments you supply. It reports your analysis rather than producing a valuation of its own.
Can I use our own CMA format? +
Yes. Build the master in Google Docs with your column order, adjustment grid and disclaimers, mark the comparables as a repeating row and the subject details as placeholders, and generate against that. Firms with a required format keep it exactly.
Can I prepare an analysis for several properties in one run? +
Yes. Filter to the subject properties you are pricing this week and one run produces an analysis per property, each pulling only the comparables matched to it. Nested loops handle the adjustments listed beneath each comparable, so a property with twelve sales and one with three both come out correctly laid out.

Generate this document from your data

Start on the free plan, connect a data source, and export a real Google Docs document. No watermark, no credit card.