DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 1 TIME: 17:57 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 057 Dallas 057-922 Coppell +-----| 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 130,650 | 0 0 0 Untested | 1,209 137,364,750 Untested 137,364,750 | |N1 130,651 196,940 | 50 8,075,424 / 8,168,770 = .9886 | 3,877 652,757,292 / .9886 = 660,284,536 | |N2 196,941 267,160 | 50 11,318,692 / 11,341,500 = .9980 | 2,715 652,757,292 / .9980 = 654,065,423 | |N3 267,161 334,630 | 50 14,981,627 / 14,957,306 = 1.0016 | 2,106 651,933,104 / 1.0016 = 650,891,677 | |N4 334,631 & UP | 50 20,312,530 / 20,475,743 = .9920 | 1,453 652,482,563 / .9920 = 657,744,519 | | | | | | Random Totals: | 200 | 10,151 2,609,930,251 2,622,986,155 | | Untested Totals: | | 1,209 137,364,750 137,364,750 | | |----- |------- -------------- -------------- | | Category Totals: | 200 | 11,360 2,747,295,001 / 2,760,350,905 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9953 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 103,290 | 0 0 0 Untested | 98 9,367,149 Untested 9,367,149 | |N1 103,291 7,600,000 | 0 0 0 Untested | 220 47,627,334 Untested 47,627,334 | |N2 7,600,001 17,748,940 | 0 0 0 Untested | 4 52,942,296 Untested 52,942,296 | |N3 17,748,941 25,200,000 | 0 0 0 Untested | 2 45,422,191 Untested 45,422,191 | |N4 25,200,001 & UP | 0 0 0 Untested | 1 33,096,003 Untested 33,096,003 | | | | | | Untested Totals: | | 325 188,454,973 188,454,973 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 325 188,454,973 / 188,454,973 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 2 TIME: 17:57 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 057 Dallas 057-922 Coppell +-----| 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 81,600 | 0 0 0 Untested | 352 7,004,824 Untested 7,004,824 | |N1 81,601 438,870 | 0 0 0 Untested | 176 33,558,321 Untested 33,558,321 | |N2 438,871 1,063,910 | 0 0 0 Untested | 48 33,600,604 Untested 33,600,604 | |N3 1,063,911 2,231,100 | 0 0 0 Untested | 22 33,544,227 Untested 33,544,227 | |N4 2,231,101 & UP | 0 0 0 Untested | 7 33,220,060 Untested 33,220,060 | | | | | | Untested Totals: | | 605 140,928,036 140,928,036 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 605 140,928,036 / 140,928,036 | | |===== |======= ============== ============== | | | | 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 1,474,540 | 0 0 0 Untested | 161 80,595,877 Untested 80,595,877 | |N1 1,474,541 5,222,960 | 11 38,653,550 / 43,945,813 = .8796 | 135 387,185,848 / .8796 = 440,184,002 | |N2 5,222,961 11,130,000 | 10 66,786,500 / 71,395,826 = .9354 | 54 391,093,527 / .9354 = 418,102,979 | |N3 11,130,001 17,457,790 | 8 108,051,920 / 111,506,379 = .9690 | 30 395,815,306 / .9690 = 408,478,128 | |N4 17,457,791 & UP | 7 169,971,160 / 156,268,664 = 1.0877 | 16 373,346,152 / 1.0877 = 343,243,681 | | | | | | Random Totals: | 36 | 235 1,547,440,833 1,610,008,790 | | Untested Totals: | | 161 80,595,877 80,595,877 | | |----- |------- -------------- -------------- | | Category Totals: | 36 | 396 1,628,036,710 / 1,690,604,667 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9630 | +----------------------------------------------------------------------------------------------------------------------------------+
DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 3 TIME: 17:57 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 057 Dallas 057-922 Coppell +-----| 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 | 7 6,400 Untested 6,400 | | | | | | Untested Totals: | | 7 6,400 6,400 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 7 6,400 / 6,400 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.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 325,000 | 0 0 0 Untested | 1,025 54,063,443 Untested 54,063,443 | |N1 325,001 2,724,910 | 7 6,129,123 / 6,450,171 = .9502 | 251 256,612,508 / .9502 = 270,061,574 | |N2 2,724,911 7,588,390 | 8 33,032,667 / 33,260,249 = .9932 | 59 261,684,328 / .9932 = 263,475,965 | |N3 7,588,391 29,949,140 | 8 158,348,180 / 144,935,076 = 1.0925 | 18 267,295,703 / 1.0925 = 244,664,259 | |N4 29,949,141 & UP | 4 137,893,884 / 134,684,528 = 1.0238 | 6 239,454,649 / 1.0238 = 233,888,112 | | | | | | Random Totals: | 27 | 334 1,025,047,188 1,012,089,910 | | Untested Totals: | | 1,025 54,063,443 54,063,443 | | |----- |------- -------------- -------------- | | Category Totals: | 27 | 1,359 1,079,110,631 / 1,066,153,353 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0122 | +----------------------------------------------------------------------------------------------------------------------------------+
