/
Create  a Custom  Export template in Create  a Custom  Export template in

Create a Custom Export template in - PowerPoint Presentation

stefany-barnette
stefany-barnette . @stefany-barnette
Follow
347 views
Uploaded On 2018-12-20

Create a Custom Export template in - PPT Presentation

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

cmas template excel export template cmas export excel subject fin frontage preparing sqft market est amp knowledge baths close price size seller

Share:

Link:

Embed:

Download Presentation from below link

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.


Presentation Transcript

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 . . .