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
DownloadNote - 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.
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
Seller Concession Amount
Est Fin Lower Floor
Est Fin Abv
Preparing Fast & Accurate CMAs(moderate to advanced Excel skills)
Rick BaileyBailey Realty & Investment Companyrick@weknowyourmarket.comwww.weknowyourmarket.com/template.xlsxwww.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 . . .