DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 1 TIME: 17:40 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 043 Collin 043-907 McKinney +-----| C A T E G O R Y: A |-----+-----------| S A M P L E D A T A |-----------+-----------| S T R A T U M D A T A |------------+ | | | | | Low High | Sam Sam CAD Sam PTD Random |Stratum Stratum CAD Random Stratum PTD | | Range Range | Obs Value Value Ratio |Parcels Value Ratio Value | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |L 1 84,723 | 0 0 0 Untested | 4,378 185,698,364 Untested 185,698,364 | |N1 84,724 149,825 | 107 13,676,709 / 13,885,205 = .9850 | 6,243 882,067,229 / .9850 = 895,499,725 | |N2 149,826 193,662 | 107 18,041,030 / 18,018,201 = 1.0013 | 4,610 882,067,229 / 1.0013 = 880,922,030 | |N3 193,663 285,633 | 107 25,074,115 / 25,266,443 = .9924 | 3,367 882,067,229 / .9924 = 888,822,278 | |N4 285,634 & UP | 107 43,190,744 / 43,789,506 = .9863 | 1,951 882,067,229 / .9863 = 894,319,405 | | | | | | Random Totals: | 428 | 16,171 3,528,268,916 3,559,563,438 | | Untested Totals: | | 4,378 185,698,364 185,698,364 | | |----- |------- -------------- -------------- | | Category Totals: | 428 | 20,549 3,713,967,280 / 3,745,261,802 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9916 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| C A T E G O R Y: B |-----+-----------| S A M P L E D A T A |-----------+-----------| S T R A T U M D A T A |------------+ | | | | | Low High | Sam Sam CAD Sam PTD Random |Stratum Stratum CAD Random Stratum PTD | | Range Range | Obs Value Value Ratio |Parcels Value Ratio Value | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |L 1 120,309 | 0 0 0 Untested | 140 11,447,285 Untested 11,447,285 | |N1 120,310 7,145,890 | 0 0 0 Untested | 63 59,263,306 Untested 59,263,306 | |N2 7,145,891 9,404,659 | 0 0 0 Untested | 7 59,125,109 Untested 59,125,109 | |N3 9,404,660 15,090,188 | 0 0 0 Untested | 4 51,777,657 Untested 51,777,657 | |N4 15,090,189 & UP | 0 0 0 Untested | 2 48,714,299 Untested 48,714,299 | | | | | | Untested Totals: | | 216 230,327,656 230,327,656 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 216 230,327,656 / 230,327,656 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 2 TIME: 17:40 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 043 Collin 043-907 McKinney +-----| C A T E G O R Y: C |-----+-----------| S A M P L E D A T A |-----------+-----------| S T R A T U M D A T A |------------+ | | | | | Low High | Sam Sam CAD Sam PTD Random |Stratum Stratum CAD Random Stratum PTD | | Range Range | Obs Value Value Ratio |Parcels Value Ratio Value | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |L 1 23,400 | 0 0 0 Untested | 1,207 14,069,432 Untested 14,069,432 | |N1 23,401 45,000 | 0 0 0 Untested | 1,911 52,908,065 Untested 52,908,065 | |N2 45,001 136,953 | 0 0 0 Untested | 777 49,538,403 Untested 49,538,403 | |N3 136,954 784,865 | 0 0 0 Untested | 179 51,223,234 Untested 51,223,234 | |N4 784,866 & UP | 0 0 0 Untested | 32 51,070,068 Untested 51,070,068 | | | | | | Untested Totals: | | 4,106 218,809,202 218,809,202 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 4,106 218,809,202 / 218,809,202 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| C A T E G O R Y: F |-----+-----------| S A M P L E D A T A |-----------+-----------| S T R A T U M D A T A |------------+ | | | | | Low High | Sam Sam CAD Sam PTD Random |Stratum Stratum CAD Random Stratum PTD | | Range Range | Obs Value Value Ratio |Parcels Value Ratio Value | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |L 1 170,247 | 0 0 0 Untested | 361 34,464,097 Untested 34,464,097 | |N1 170,248 1,109,786 | 14 5,737,475 / 5,369,328 = 1.0686 | 328 165,399,983 / 1.0686 = 154,781,942 | |N2 1,109,787 2,374,457 | 7 9,980,242 / 11,336,128 = .8804 | 88 165,261,573 / .8804 = 187,711,918 | |N3 2,374,458 7,563,810 | 6 20,775,764 / 26,429,929 = .7861 | 34 165,261,573 / .7861 = 210,229,707 | |N4 7,563,811 & UP | 4 72,821,749 / 75,805,280 = .9606 | 8 161,662,912 / .9606 = 168,293,683 | | | | | | Random Totals: | 31 | 458 657,586,041 721,017,250 | | Untested Totals: | | 361 34,464,097 34,464,097 | | |----- |------- -------------- -------------- | | Category Totals: | 31 | 819 692,050,138 / 755,481,347 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9160 | +----------------------------------------------------------------------------------------------------------------------------------+
DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 3 TIME: 17:40 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 043 Collin 043-907 McKinney +-----| C A T E G O R Y: G |-----+-----------| S A M P L E D A T A |-----------+-----------| S T R A T U M D A T A |------------+ | | | | | Low High | Sam Sam CAD Sam PTD Random |Stratum Stratum CAD Random Stratum PTD | | Range Range | Obs Value Value Ratio |Parcels Value Ratio Value | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |N1 1 & UP | 0 0 0 Untested | 0 0 Untested 0 | | | | | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 0 0 / 0 | | |===== |======= ============== ============== | | | | Final Category Ratio: .0000 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| C A T E G O R Y: L |-----+-----------| S A M P L E D A T A |-----------+-----------| S T R A T U M D A T A |------------+ | | | | | Low High | Sam Sam CAD Sam PTD Random |Stratum Stratum CAD Random Stratum PTD | | Range Range | Obs Value Value Ratio |Parcels Value Ratio Value | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |L 1 47,665 | 0 0 0 Untested | 1,516 25,408,327 Untested 25,408,327 | |N1 47,666 394,311 | 8 847,416 / 930,893 = .9103 | 418 78,664,180 / .9103 = 86,415,665 | |N2 394,312 1,426,436 | 8 6,516,185 / 7,075,428 = .9210 | 70 78,460,913 / .9210 = 85,191,002 | |N3 1,426,437 3,112,695 | 6 12,172,535 / 12,770,665 = .9532 | 27 81,916,446 / .9532 = 85,938,361 | |N4 3,112,696 10,006,369 | 5 22,602,676 / 27,193,636 = .8312 | 8 75,107,014 / .8312 = 90,359,738 | |H 10,006,370 & UP | 3* 162,484,072 166,955,678 Censused | 3 162,484,072 Censused 166,955,678 | | | | | | Random Totals: | 27 | 523 314,148,553 347,904,766 | | Exception Totals: | 3 | 3 162,484,072 166,955,678 | | Untested Totals: | | 1,516 25,408,327 25,408,327 | | |----- |------- -------------- -------------- | | Category Totals: | 30 | 2,042 502,040,952 / 540,268,771 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9292 | | * All sample observations in stratum are exceptions. | | +----------------------------------------------------------------------------------------------------------------------------------+
