For many new agents preparing a CMA (Comparative Market Analysis) for the first time can be downright intimidating. After all, experienced agents make them sound like something only grizzled real estate veterans can produce. Luckily, this isn’t the case anymore. With the right tools and software and a bit of hard work, any agent can put together a great CMA.

By the way, you can get notified automatically when Zillow users are seriously shopping for a new home similar to the listing you’re trying to land if you sign up for Zurple’s client generation service. They intuitively gather search data to see when is the best time to contact a potential buyer about purchasing, and send the leads straight to your inbox! Interested? Click here for a free demo.

Visit Zurple

What is a Comparative Market Analysis (CMA)?

A comparative market analysis (CMA) is a document prepared by real estate professionals to help determine the selling price of a home by comparing it to recently sold homes in the same area. To create a CMA, real estate professionals look at the price of recently sold, active, and expired listings that are similar (comparable) to the home they’re trying to sell.

There are two general situations where running a CMA is essential:

For a listing appointment

Any time you want to tell a homeowner how much their property is worth in the current market. This includes when you’re pitching referral homeowners, FSBO’s, and Expired leads.

To help a buyer find a good deal

The other time you should be running a CMA is to help a buyer determine if a home they’re very interested in is a good deal or not. You will eventually be able to know right away when a home is overpriced, but if you’re just starting out or working in an unfamiliar area, a thorough CMA will tell you if a home is priced right.

Why Mastering the CMA is Crucial for New Agents

There’s an old saying in the real estate industry, “Those who list, last.” Though it may be a bit of a cliche, it’s a cliche for a very good reason. Agents who get sales listings tend to do well and stay in the industry longer than those who are stuck working with buyers. There’s no way around it.

There’s solid logic behind this simple truth about the industry. Along with marketing and closing expertise, determining the value of a client’s home is one of the most important skills a new agent can learn. In the age of Zillow, this is one of the only skills that separate the professionals from the amateurs. It is extremely difficult to get an accurate CMA without access to an MLS, so think of a CMA as your value add, special sauce, and secret weapon rolled into one. Here’s how to get started.

8 Steps to Creating a Comparative Market Analysis

Before we get started, you should understand that you will essentially be running two comparative market analyses: One to get a sense of the value of the home BEFORE you go on your listing appointment, and one to present to the home owner AFTER you’ve seen the home to see how accurate you were.

Okay, I know what you’re thinking. You just told your prospective client that you can’t tell him how much his home is worth until you’ve seen it in person. It was one of the best lines in your Mike Ferry script. So why not wait until you get there? Simple. That homeowner you booked an appointment with might have three other agents coming that afternoon. She’s going to have questions ready for you. You need to have the answers.

Step 1 – Assess the Neighborhood

After landing an appointment from a FSBO or referral, the first step in preparing your comparative market analysis is to assess the neighborhood. While you won’t really be able to properly assess the home until you’ve seen it in person, taking a quick look at the neighborhood online will help prepare you for the appointment.

Street View to the Rescue

Google Street View will tell you almost everything you need to know about the neighborhood surrounding the home you’re going to prepare a CMA for. Here are some things to look for to get the lay of the land:

• Nice blocks vs less attractive blocks
• Proximity to amenities like beaches, parks, schools, etc
• Proximity to unpleasant locations like garbage dumps, highways, industrial facilities, etc.
• Significant curb appeal issues

Step 2 – Assess the Listing (if any)

Once you’ve checked out the neighborhood, see if you can find the original listing. If it’s still up, the listing should give you a ballpark idea of what you’re up against. Look very carefully at the pictures and description. This should give you a pretty decent sense of the condition of the home, any upgrades that have been made, as well as issues in marketing strategy.

Step 3 – Check Zillow Zestimates & HouseCanary Valuations & Value Forecasts

Since Zillow’s Zestimates are only based on limited tax records and data added by agents, they should always be considered a starting point for valuation rather than an accurate estimate. Zestimates can be off by as much as 20-30%. For example, Zillow’s own CEO Spencer Rascoff recently sold his own personal home for 40% less than its Zestimate.

Why Look at Zestimates for your CMA if they’re Inaccurate?

If Zestimates are not reliable, why even look at them when running a CMA? Simple. Homeowners don’t know just how inaccurate Zestimates can be. Since Zillow dominates the real estate listings space, your clients will have already checked out the Zestimate for their home and may think this provides a good idea of its value. You need to be able to address the Zestimate when your homeowner brings it up.

Check the Accuracy Rating for Your Area on Zillow

Since Zillow is very upfront about the limitations of their Zestimates, they actually publish an accuracy rating of their Zestimates for states and counties. In order to tell how accurate the Zestimate is, you need to check the accuracy rating on Zillow. Here’s how you find out.

Go to Zillow.com and scroll down to the bottom of the page and click on “Zestimates.” From there, click on “How Accurate is a Zestimate”. This will bring you to a table called “Data Coverage and Zestimate Accuracy Table”. If you click on “States/Counties”, you can drill down and find the state and county your potential listing is in. Here’s that that table looks like for New York State:

The first column “Zestimate Accuracy” is an accuracy rating based on a star system. 1 star is very inaccurate, while 4 stars would be very accurate. The other columns show the number of home in that county on Zillow, the number of homes with Zestimates, those that sell within a certain percentage difference from the Zestimate, and the margin of error.

Let’s look at Erie County, New York, as an example. Out of the 298.1k homes with Zestimates in Erie County on Zillow, only 37.4% had a Zestimate within five percent of the selling price. 59.6% were within ten percent, and a whopping 77.5% came in within 20%. 

Even though Zestimates can be pretty inaccurate, your potential client might not know that. This is why getting ahead of the question and backing up your answer with data is so crucial.

Use HouseCanary to Get a Valuation & Value Forecast for Your CMA

While you shouldn’t rely solely on Zillow and HouseCanary for your valuation, you need to show your potential clients that you are both thorough, and aware of the latest technology. HouseCanary, a Google Ventures backed home valuation and forecasting startup, offers valuations with an MdAPE (Median Absolute Percentage Error- a measurement of a valuation’s accuracy) of only 4.4% nationwide. That means you should be able to get a valuation that’s pretty close to market value that you can use to back up your own analyses.

Even though HouseCanary has a very low MdAPE, there are still factors that you should know that will affect the accuracy of their valuation. By comparing your final analysis to both Zillow and HouseCanary, you can show you are taking them into consideration. Since your homeowner will have likely already checked Zillow and possibly HouseCanary already, this will keep you one step ahead.

Even better, HouseCanary offers value forecasts that offer valuations three years out. While this information is more useful for buyers, you can use it as leverage for negotiating offers. For example, if a buyer tries to make a lowball offer, you can show them the three year forecast and run the numbers to show why your listing price is the right price.

Step 4 – Start Your Preliminary CMA on Your MLS or Through Cloud CMA or Similar Software

Once you’ve assessed the neighborhood on Google Street view, checked out the listing, and looked up the Zestimate on Zillow, the next step is to fire up your MLS or CMA Software like Cloud CMA. These platforms take MLS data and create attractive CMAs that can be presented on tablets, viewed online, or saved as PDFs and printed out to leave behind with your home owner. 

The idea is look for comparable listings and come up with a rough idea of the home’s value. You need to look at sold listings, expired listings, active listings, and pending listings that are comparable to the home.

Unfortunately, since different MLS systems run on different backend software, we can’t run you through the exact steps you need to take in your MLS. Instead, we’ll walk you through some general guidelines about how to sort listings in your MLS by to find comparable homes. You’re looking for:

Homes that have sold, expired, have sales pending, or been listed in the past six months

Sold listings will tell you exactly what similar homes in the area have sold for recently and are your primary way to assess value for your comparative market analysis. Expired listings will tell you pricing the market is not willing to bear. Pending listings can give you a good idea of what similar homes are selling for right now. Current listings will tell you what your competition is like.

Homes with the same number of bedrooms and baths as yours

Generally speaking, the number of bedrooms and baths is one of the most important criteria for valuing a home.

Homes within roughly 300 square feet of yours

(i.e. if your home is 2,000 square feet, look at homes that are between 1700 and 2300 square feet) While it’s generally true that more bedrooms equal a higher price, square footage is almost as important. After all, bedrooms can be added or removed from a home fairly easily. Also, if a room meets the legal definition of a bedroom in the eyes of your local building code, dining rooms, dens, and offices can all be labeled as “bedrooms.”

Homes that are in the same neighborhood

Figuring out exactly what “neighborhood” the home is actually in can be very tricky. This is why assessing the neighborhood online is so important. See if you can find what locals consider the boundaries of the neighborhood. If their’s no general consensus, geographic features like train tracks, highways, and shopping centers can also signify borders between neighborhoods.

Homes that are in the same or comparable school zones

This is another important factor, especially in big cities. Homes on one side of a street might be in an excellent school zone, while schools on the other side might be in a terrible school zone. The difference can add or remove surprisingly significant value from a home. While your MLS may have information on school districts, always double check as the boundaries can change. k12.niche.com is a good site to check school zone locations.  

Homes with a similar lot size as yours

A home on ten acres of land is going to be worth more than a home on one acre. Generally speaking, lots in most neighborhoods are roughly similar sizes. 

Homes built within 10-25 years as yours

This is another tricky one. While brand new homes are generally valued higher than older homes, some older homes, especially antique homes or mid-century modern homes, might command a  premium over new construction. Depending on the changes that have taken place in the neighborhood, new construction might be high end, low end, or comparable to the existing inventory. if you don’t know much about the neighborhood, ask a coworker who does. 

Homes that have similar amenities as yours

For example, if the home has an inground pool, try to find other listings with inground pools. If the home is oceanfront, comparing it to other oceanfront homes will yield much better results than comparing it to homes a few blocks away from the water.

Step 5 – Pull Together the Comparable Listings and Get a Price per Square Foot

Now that you’ve narrowed down the criteria of your search, you should have several homes that are roughly comparable to the one you’re running your CMA on. The next step is to take the selling price of the comparable homes you’ve chosen and divide it by their square footage. This will give you the price per square foot for each comparable home.

After that, find the average between the prices per square foot of the comparable homes. Now multiply the average price per square foot by the exact square footage of the home you’re running a CMA on. Congratulations! You’ve come up with a fairly accurate estimate for the price of your potential client’s home.

Example:

Let’s say the home you’re running the CMA on is a 3000 square foot ranch. You find 4 comparable homes when you run your CMA.

• Home one is 2700 square feet and sold for $500,000 (price per square foot: $185)
• Home two is 3200 square feet and sold for $525,000 (price per square foot: $164)
• Home three is 3300 square feet and sold for $510,000 (price per square foot: $154)
• Home four is 2650 square feet and sold for $495,000 (price per square foot: $187)
• Home five is 3100 square feet and sold for $515,000 (price per square foot: $166)

After crunching the numbers, we find that the average price per square foot for these homes is $171.20. Multiplying our home’s square footage (3000 sf) by the average price per square foot gets us an approximate value for our home. So, $171.20 x 3000= $513,600. Congratulations, you now have a rough estimate of your home’s market value! 

Step 6- Assess the Home in Person

Now that you’ve done your research, you should be very confident when meeting the homeowner and finally seeing the home in person. After all, you already have a pretty good idea of what the home is worth, so you should be able to address any questions about value the homeowner has for you.

Now you need to tour the home to see if there are any hidden issues which will affect the sales price. You should be on the lookout for things like;

• Condition – Is the home in very poor condition or very good condition?
• Additions and upgrades – Has the homeowner added a swimming pool? Central AC? Skylights? All can affect value.
• The Property – Has the landscaping been recently upgraded? This can increase value as well.

If there are any major issues that weren’t apparent from your initial research, either run a search for new comparable listings that better fit the home in its current state, or adjust the price per square foot of the home to reflect the differences.

Step 7 – Prepare Your Final CMA for Your Potential Client

Now that you’ve done extensive research in the neighborhood, looked up comparable listings, and assessed the home in person, you are ready to put together the final comparative market analysis to present to your potential client.

You can either put together a powerpoint or keynote presentation, save as a PDF, print out and present in a binder, or use CMA software to present to your potential client in a web or tablet presentation. 

At the end of the day CMA software offers several advantages over DIY options. They organize the data in a much more attractive way, as well as provide useful information for your potential clients. To get a better idea of what I’m talking about, here’s an example of a CMA produced using Cloud CMA.

Step 8: Keep Your Pipeline Filled With Top of the Funnel Seller Leads

Even if you follow the steps in this article, you’re still going to have to practice honing your CMA and listing presentation skills before you start signing sellers clients regularly. It’s one thing use great data and write a great pitch, but you’re going to have to practice with real people before you start to get good. In order to do that, you’re going to need a steady stream of seller leads.

Ideally, you also want to find “top of the funnel” seller leads. These are homeowners who are just starting their home sale process. The idea is to pitch them before any other agents do. If you pitch them first, they will compare every other pitch they recieve to yours. If you do your job correctly, then you have an excellent chance of closing them.

One of the most effective ways of getting seller leads in 2018 is by advertising home valuation landing pages on Facebook. Real Geeks’ Home Valuation Tool is a great way to generate enough seller leads to build your pipeline and hone your CMA and listing presentation.

Here’s how it works. Sellers click on Facebook ads that offer free, instant home valuations. When they get to your landing page, they fill out the details of their home, and their contact information. They then get an instant home valuation with the caveat that a CMA from an experienced agent will be far more accurate. You can then reach out to the lead to offer an in person CMA and listing presentation. Even if they don’t respond right away, you can use Real Geeks’ Home Valuation Tool to send them fresh market updates via email.

Even better, Real Geeks’ Home Valuation Tool allows you to collect partial lead info. In other words, if a seller only enters their address, you can follow up with a direct mail campaign using door hangers or postcards.

Click below to visit Real Geeks to learn more about generating enough seller leads to make the leap from part time listing agent to full time listing agent today.

Visit Real Geeks

CMA Advice From the Pros + Example CMA

Now that you have the basics of running a CMA down, here’s some advice from top producing Realtors, Real Estate Investors, and Appraisers on how to take your CMAs to the next level. Special thanks to everyone that contributed to the article.

Avoid Using Only Smaller Comps and Remember to Adjust for Condition etc.

Jennifer De Vivo, Florida Realtor De Vivo Realty

“A common mistake that new agents to is to use comps that are all smaller than the subject property. Often smaller comps can skew the price per square footage and artificially inflate the price of the subject property. A rule of thumb is that there should always be a smaller and slightly larger property used in the mix of final comps chosen. Another common mistake is the not to make adjustments for items like condition of the home, updating, pools and other major locational factors like being on a conservation lot verses by a busy road.”

Want to check out an example CMA from a Top Producing Realtor? Jennifer was kind enough to share of here CMA’s with us. Click here to see her example comparative market analysis. 

Jennifer’s CMA was created using RPR.

Make Sure Your Comps are as Similar as Possible

Mark Ferguson, Real Estate Investor, Founder Investfourmore.com

The person completing the CMA needs to make sure they are using comparable properties that are similar to the subject in style, age, condition, type, and location. Usually some good guidelines are:

• Homes within 10 years of age.
• Use a ranch style house to compare to another ranch style house.
• Try to use comparable sales or listings that are within the same neighborhood as the subject, or if not possible within one mile.
• The above ground square footage should be within 20 percent. Above ground square footage should be calculated differently from basements. If a home has 2,000 square feet on the main floor, and 1,000 square feet int he basement, it should not be valued the same as a house with 3,000 square feet all on the main floor. For example, in Colorado above ground square footage may be adjusted $40 or $50 a square foot and basement square footage $10 or $20 a square foot if it is finished.
• Do not use a manufactured home to value a stick built home.
• If a home has a large lot (5 acres) make sure you are using comparables with similar lot sizes

Keep up on the Latest Technology

Denise Supplee, Founder SparkRental, Realtor at Long & Foster Real Estate

“For my reports or CMA’s I use Trend (my local MLS) along with Zillow. There was an article on Bloomberg that actually pointed out that the median error gap between the actual sale price and a “zestimate”, which is what Zillow calls it is only 5 percent. This is down from 14 percent when it started in 2006.I like using both of these tools as I believe it provides my sellers the best information.

Technology has taken hold of the appraisal industry. In the late 90’s, I did a temporary stint working for an appraiser. Basically, I simply added information into this software (I do not remember the name), and it produced a report based on the comp info I added. Frankly, the MLS does that for me automatically. I just enter the subject property in and it scours for nearby properties of similar description and location.

Therefore, all in all, I believe that newer agents tend to be more tech-savvy and will probably adapt better to creating more precise forecasting than their seasoned counterparts.”

Go Beyond Square Footage to Get the Most Accurate Value

Doug Willis, Pasadena Realtor 

“Aside from the normal beds/baths, square feet, and lot size you have to closely look at the less obvious issues that can deduct from market value. For instance, if someone adds 1000 square feet to their property is it in harmony with the rest of the house or does it look like an apartment building? Does the house maintain its character or has it been remodeled to reflect the current bad taste of the owner?

Other less obvious clues include a house situated on a busy corner or street, a floor plan that has a poor design such as going through a bedroom to enter another bedroom and updates that were last done in the 1980’s.

Cosmetic upgrades (kitchen and baths) also will add much more value than other less obvious system/construction upgrades such as new plumbing, newer roof, insulation, earthquake bracing. Consumers do not see this, therefore there is no WOW factor or emotional appeal.

The best CMA’s include an estimate of the increased or decreased value the subject property has when compared to the comps. This format provides fewer opportunities for the owner to question the value and price it too high.”

Don’t Let Aesthetics Get in the Way of Your Data Analysis

Marc Carver, Principal at Carver Property Group, LLC

“There are software solutions provided by most MLS systems that produce very polished looking reports. But, regardless of the software used, the most important thing to remember when preparing an effective CMA is that the real value is in the data and your interpretation of it. It is of course important to have a concise, professionally prepared presentation, however don’t let the “appearance” take on a higher importance than the selection and interpretation of the data.

​Newer agents need to be aware that a full and detailed report cannot be complete without a similar market analysis of the properties listed and competing with their home in real time. In conjunction with your analysis of the recent sales history of similar properties, this current market information is crucial in determining your maximum list price recommendation.”

Make Sure Your CMA’s Are Easy to Understand

Desare Kohn-Laski, broker/owner of Skye Louis Realty

“For CMAs I use a combination of Imapp, RPR & the MLS. An important tip for new agents is to make sure when creating a CMA to make it as easy as possible for the seller to understand. If the CMA report confuses you, then it will most likely confuse the seller. Software like HouseCanary is a good starting point for CMAs but it is important to really look at the picture, upgrades and specific location of the recent closed sales used in your CMA report to get the most accurate valuation possible.”

Make Sure to Present Your Comp’s Details & Pictures in Your CMA

Kathryn Bishop, Realtor Keller Williams Realty, Studio City, California

“In every CMA, I provide all Actives, Under Contract, Pending and Sold listings that are the closest matches to my seller’s location, home size, amenities, property conditions, and neighborhood characteristics.  Typically, I use listings that are within a half mile of the property to again maintain as much similarity as possible.  All sold properties are within the last 180 days if possible, although some properties are unusual and I have to dig further into past sales to find comparables.   The info on every comparable includes all photos. The seller can also see his property’s characteristics next to the comparable’s characteristics so the similarities and differences are on the same page.

This CMA system allows me to adjust the market value of the comparable listing.   I add to or subtract from the listing price all items affecting the price that do not match between the comparable and my seller’s home.  It also has space on each listing where I comment on my financial adjustments.

Also I show pricing trends, Days on Market and Price averages and medians and I recommend a listing price.My CMA’s have proven to be quite accurate.  My seller’s often comment happily on the accuracy of my analysis and pricing.  They realize that if they go on the market at an unreasonably high price, they will be on the market much longer and will eventually lower their asking price (often below what I recommended because the market has changed)  in order to finally sell.”

The Bottom Line

Once you understand how they work, running comparative market analyses can be fairly straightforward. While accurately pricing a home can involve more market knowledge than we discussed in this article, you should now be able to run a pretty accurate CMA to land your first seller client. 

Want to know what properties your potential buyers are viewing on Zillow? Zurple will notify you when Zillow’s search data shows that a client is getting serious about making a purchase. Click the button below for a free demo of Zurple’s intuitive lead generation process.

Visit Zurple