RealComp Under My RCO then Settings then Custom Exports click Add Export Name it CMA Fields Then add the same fields and the same order as are on the Template Excel Spreadsheet you will use for CMAs ID: 744419
Download Presentation The PPT/PDF document "Create a Custom Export template in" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Create a Custom Export template in RealComp
Under My RCO, then Settings, then Custom Exports click Add Export. Name it CMA Fields. Then add the same fields (and the same order) as are on the Template Excel Spreadsheet you will use for CMAs.
Unparsed AddressSubdivision NameParcel NumberSchool DistrictArchitectural LevelWater FacilitiesWaterfront NameWater Frontage FeetYear BuiltYear Remodeled
Basement TypeRoad Frontage TypeOut BuildingsPool YNCDOMList PriceOriginal List PriceOwnershipShort SalePublic Remarks
Close Date
Close Price
Seller Concession Amount
Acreage
Beds Total
Baths Full
Baths Half
Garage Size
Est Fin Lower Floor
SqFt
Est Fin Abv
Grd
SqFtSlide2
Preparing Fast & Accurate CMAs(moderate to advanced Excel skills)
Rick BaileyBailey Realty & Investment Companyrick@weknowyourmarket.comwww.baileycustomhomes.com/template.xlsxSlide3
Comparative Market AnalysisFind Comparable Sales
Adjust comparable to look like subject propertySq.Ft adjustment:(Subject Sq.Ft – Comp Sq.Ft) * Unit Price for Sq.FtComp $ = Comp SalePrice + all adjustmentsSlide4
Benefits of Preparing CMA before offer
Working with SellerShows knowledge of their marketProvide framework to have seller tell you what their home is worthWorking with BuyerHave prelim CMAs available for each showingBuyer has value reference points besides the Asking PriceShows knowledge of their (potential) marketSlide5
ProcessOpen Excel template; Save As !!!!!!!!
Open RCO3Export subject property info (old listings) or manually enterSet criteria for comparables (subdivision, size, style, age, …)Export comparablesExport pendingsExport activesCopy supply / demand data (
solds, pendings, actives)Adjust spreadsheet10 minutes later . . .