TEXAS FIVE STAR REALTY

Info@TexasFiveStarRealty.com

 
214-457-7055

 

 

Texas Real Estate Commission Information About Brokerage Services                       Texas Real Estate Commission Consumer Protection Notice

Dallas homes for sale, Plano homes for sale, Frisco homes for sale, Prosper homes for sale, Allen homes for sale, McKinney homes for sale, Murphy homes for sale, Celina homes for sale, homes for sale

Home

About Us Buyers Sellers Investors Commercial Relocation Contact Us Lenders Inspectors Titles
Builders Vendors PlaceHolder
Search Properties
Find Your Home's Value
Local Market Snapshots
Local Real Estate Trends
National Market News
Foreclosure vs. Short Sale
Dallas FW City Directories
Dallas FW School Ratings
Dallas FW City Tax Rates
Estimate Closing Cost
Mortgage Calculator
Mortgage Amortization
Green Tax Credit
Types of Loans
Relocation to Texas
Customers vs Clients
Repair Cost vs Value
Rent vs Buy Calculator
Your First Home?
My Blogs
Testimonials
Test Your R. E Knowledge
  Property Management
Open House Manager Tool

NTREIS MATRIX Average Calculation is Wrong for Price per Square Foot SqFt and Sold Price to List Price ratio SP%LP

Legend:
CMA: (Comparative Market Analysis)
 MLS: (Multiple Listing Services)
NTREIS (North Texas Real Estate Information System)
NTREIS 
Matrix  is the primary  MLS system and includes both search and input functions.

The CMA generated report from NTREIS MATRIX provides an average Sold Price per Square foot, Percentage of the Sold Price vs. Listed Price for selected sold properties, and average Listed Price per Square foot for selected Active/Active Option/Cancelled/Expired and Pending properties. See Figure 1 for more information.

Currently, the Matrix adds all numbers under each column in a group (e.g., Active Status) and divides that by the number of items in the group. This calculation is correct for all columns except columns for $/SqFt and SP%LP. In the example shown below, this results in Avg $/ SqFt =$280.24 which is WRONG and should be $276.98. All incorrect numbers are circled red and their respective correct number shown with blue color.

Question: One may ask how the calculation is correct for other columns except $/SqFt and SP%SL.

Answer: The answer is because all other columns are independent of each other, where as Average Price per Sq Ft ($/SqFt) is dependent on the Listed or Sold Price AND Sq. Ft. of each property and therefore calculated based on these two numbers. One cannot assign an arbitrary numbers for these two columns, they are calculated.

Solution: The correct way is to add all numbers under each column of List Price (or Sold Price) and divide that by total numbers added in column SqFt  in a group to derive the correct averages for $/SqFt and SP%LP. This also can be achieved by simply by dividing the calculated Average for List Price (or Sold Price) and calculated Average SqFt.

Example: Calculate the Average $/SqFt for ACTIVE list in Plano with Listed Price =>$2,000,000 (See Figure below)             

1. Average $ per SqFt = $Total List Prices / Total Sq.Ft   = $24,158,000/87215= $276.99                       OR simply

2. Divide Average List Price (OR Sold Price) by Average SqFt = $2415800/8722 = $276.98

Note the 1 Cent difference is due to round off (the actual Average of SqFt is 8721.5 but used as whole integer 8722).

I caution each agent in North Texas to be aware of these inaccuracies. I have reported these to NTREIS Matrix Committee too, hope to be fixed.

 

To show my points and better understand the problem, please see the following scenario for illustration purposes only.

         

Average Calculation Example

         

Scenario:

Example

                       

A Computer store sells 100 computers at $100,000 and 1 refurbished computer at $100.

       

Question:

What is the Average sell price per computer?

               

Answer:

(Total sales Price) / (Total number of computers sold)

             
   

(100 * $1000 + $100) / (100+1) = $100,100 / 101 = $ 991.09

         
                           
 

Number of Computers Sold

 

$Total Sale Price

   

$Avg. Sale Price/ Computer

 
 

100

     

$100,000

               
 

1

     

$100

               

Total

101

 

 

 

$100,100

 

 

 

$100,100/101=

 

$991.09

 CORRECT

                           
                           

Incorrect: Way:

                       

First Calculate the Avg. Sale Price per each computer in each line. Then calculate the avg. of all calculated Averages:

 
 

Number of Computers Sold

 

$Total Sale Price

   

$Avg. Sale Price/ Computer

 
 

100

     

$100,000

     

$100,000/100=

 

$1,000.00

 
 

1

     

$100

     

$100/1=

   

$100.00

 

Total

101

 

 

 

$100,100

 

 

 

($1000 + $100)/2=

$550.00

 INCORRECT

                           

This Incorrect way, is the way Matrix CMA calculates Average $/Sq.Ft.

           

 


 

 

 

Averages Calculations in Matrix for $/SqFt and SP%LP are Not Correct

 
 

CMA 1 Line

Residential

Status="Active"

 

City is Plano

Current Price is $2,000,000+

Average $/SqFt Calculation in Matrix vs. the Actual (Correct) $/SqFt

             
     

#BTH

                     

Listing#

 

#Bed

#FULL

/

HALF

GAR/

CP/

TCP

Yr Blt

Pool

SqFt

$/SqFt

 List Price

CDOM

1

 

5

5

/

0

3

0

3

1992

Yes

6,556

$305.06

 $        2,000,000

48

2

 

5

6

/

1

3

0

3

1996

Yes

7,935

$264.65

 $        2,100,000

154

3

 

5

4

/

2

3

0

3

2001

Yes

7,128

$314.96

 $        2,245,000

237

4

 

5

7

/

5

4

0

4

2004

Yes

8,367

$274.53

 $        2,297,000

569

5

 

7

6

/

1

4

0

4

1996

Yes

7,700

$311.04

 $        2,395,000

224

6

 

6

8

/

1

4

2

6

1998

Yes

8,756

$276.95

 $        2,425,000

182

7

 

6

7

/

2

5

0

5

2006

Yes

10,852

$230.28

 $        2,499,000

280

8

 

5

6

/

1

3

0

3

1996

Yes

9,100

$274.62

 $        2,499,000

177

9

 

6

7

/

2

4

2

6

2001

Yes

10,766

$232.12

 $        2,499,000

119

10

 

7

7

/

1

4

0

4

2003

Yes

10,055

$318.15

 $        3,199,000

305

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

From

Medians

6

7

/

1

4

0

4

2000

 

8,562

$275.79

 $        2,410,000

203

Matrix

Minimums

5

4

/

0

3

0

3

1992

 

6,556

$230.28

 $        2,000,000

48

CMA

Maximums

7

8

/

5

5

2

6

2006

 

10,852

$318.15

 $        3,199,000

569

Calculation

Averages

6

6

/

2

4

0

4

1999

 

8,722

$280.24

 $        2,415,800

230

Matrix calculates Average $/SqFt = Add all $/SqFts / Number of Listings=

Avg=($305.06+$264.65+$314.96+$274.53+$311.04+$276.95+$230.28+274.62+$232.15+$318.15)/10 =$2,802.36/10=$280.24

This method is not correct for $/SqFt, because $/SqFt numbers are NOT independent, they are dependent and

   
 

are calculated based on two numbers (List Price)/SqFt.

         
                             

Actual

Total

                 

87,215

 

 $      24,158,000

 

Correct

1. Averages= $Total List Pri

/

Total Sq.Ft   = $24,158,000/87215=

   

$276.99

   

Calculation

2. Averages= $Average List Prices / Avg. Sq.Ft= $2415,800/8,722=

   

$276.98

   

2 Methods

Difference from Actual vs. Matrix Calculation Per SqFt is=

     

$3.25

   
                             

This wrong Averages calculation in Matrix CMA, results in a $32,500 higher for a Buyer with a house around 10,000 SqFt.

 

 

Average Calculation is Wrong in NTREIS Matrix              

Avg Calculation is Wrong in NTREIS Matrix                                                                                 

For more information please see

http://www.texasfivestarrealty.com/Matrix_Avg_Calculation_is_Wrong_2015.asp

 Contact Bahman Davani at: http://www.texasfivestarrealty.com/Contactus.asp

Equal Housing Opportunity Commission Bahman Davani REALTOR

Bahman Davani, CM
Broker/REALTOR
ABR, GRI, CDPE, SFR,
TAHS, eAgentC, and
CCIM Candidate

Office: (214) 457-7055
Cell: (214) 457-7055
Fax: (972) 596-7984

P.O. Box 261665
Plano, TX 75026-1665

Contact Form

First Name Required*

Last Name

Email Address Required*

Phone Number

Comments/Questions


Enter the code above 

Texas Five Star Realty
P.O. Box 261665
Plano
, TX 75026 US
Phone: 214-457-7055
Website: www.texasfivestarrealty.com/
Follow ME button from AddThis
Follow US:

Share, Pin and LIKE This Page:
    Share this page in Facebook 

My Blogs:
Subscribe to Bahman Davani Blogs RSS See Bahman Davani Blogs See Bahman Davani Blogs in ActiveRain See Bahman Davani Blogs in WordPress Texas-Five-Star-Realty-Manta-Badge See Bahman Davani Blogs in SlideShare See Bahman Davani Blogs in Zillow   See Bahman Davani Blogs in Klout See Bahman Davani Blogs in Plaxo See Bahman Davani Blogs in Blogger

My Real Estate Designations and Certifications:
Bahman Davani REALTOR Bahman Davani Commercial REALTOR Bahman Davani ABR Designation Bahman Davani GRI Designation Bahman Davani CDPE Designation Bahman Davani SFR Shortsale Forecolsure Resource Certification Bahman Davani TAHS Texas Affordable Housing Specialist Certification Bahman Davani Inbound Marketing Certification Bahman Davani Certified Manager from Institute Certified Professional Managers Bahman Davani eAgentC Internet Profficiency Certification Bahman Davani NMLS RMLO Residential Mortgage Loan Originator License Bahman Davani TRLP Texas Real Estate Leadership Program Graduation Send Texas Five Star Realty Text via email

Additional Resources and Newsletters:
Texas Five Star Realty website Mortgage News Daily from Texas Five Star Realty website Bahman Davani Credit Score Tips and Tricks book published by Texas Five Star Realty Bahman Davani Credit Score Tips and Tricks book published by Texas Five Star Realty          


. Copyright 2011-2014 Texas Five Star Realty Web Site Developed by We provide a fast and easy solution for your business. .