Formulas for declinig market

[MattPatterson]

I am new to using forums and I am not sure if I am in the right place.

I have compiled all my information for sales from the past 3 years and active listings, etc. I know need to know what to do with the information, How do I turn it into statistical information I can use in the report.

I appreciate any help I can get.
Thanks so much

 

[Pamela Crowley (Florida)]

Welcome Matt.

I don't see this as being and "urgent" matter, so this is being moved to the General Appraisal forum. You might want to do a search for graphs as I do remember threads about this recently.

 

[MattPatterson]

Thanks so much, I am new to this and don't know how to search very well, but I will try to.

 

[Karl]

Easest way!! Find a young kid the younger the better, give em the info & tell em you want a graph!! Computers is the only thing that the younger generation has in the arsenal that can be used to teach old folks.

 

[TJSum]

Easest way!! Find a young kid the younger the better, give em the info & tell em you want a graph!! Computers is the ONLY thing that the younger generation has in the arsenal that can be used to teach old folks.

Sorry Karl, how about cell phones, VCRs, DVD players, remote controls, IPods...

I admit it, I still carry a 50' Stanley Tape and clipboard with pen and paper, but I do have a digital camera

 

[Randolph Kinney]

I am new to using forums and I am not sure if I am in the right place.

I have compiled all my information for sales from the past 3 years and active listings, etc. I know need to know what to do with the information, How do I turn it into statistical information I can use in the report.

I appreciate any help I can get.
Thanks so much

Are you familiar with Excel?

You can organize the data by month or by calendar quarter and plot the median sales price versus month/quarter. You can also plot the volume on the same graph. You can use the curve fitting functions to do some regression using linear or polynomial.

You need to also look at marketing time and exposure time.

You need to look at inventory of listings, average marketing time (days on market). Compare that to the sales rate over the last 12 months to get how many months of inventory does the current number of listings represent.

Now summarize and state what the market and neighborhood trends are.