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-914 Wylie +-----| 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 73,905 | 0 0 0 Untested | 1,383 54,127,673 Untested 54,127,673 | |N1 73,906 119,919 | 104 11,264,123 / 11,314,006 = .9956 | 2,049 257,730,162 / .9956 = 258,869,186 | |N2 119,920 142,037 | 106 14,015,034 / 14,005,156 = 1.0007 | 1,608 257,621,690 / 1.0007 = 257,441,481 | |N3 142,038 167,716 | 107 16,546,818 / 16,482,500 = 1.0039 | 1,363 257,513,217 / 1.0039 = 256,512,817 | |N4 167,717 & UP | 106 22,513,733 / 22,457,067 = 1.0025 | 1,050 257,730,162 / 1.0025 = 257,087,443 | | | | | | Random Totals: | 423 | 6,070 1,030,595,231 1,029,910,927 | | Untested Totals: | | 1,383 54,127,673 54,127,673 | | |----- |------- -------------- -------------- | | Category Totals: | 423 | 7,453 1,084,722,904 / 1,084,038,600 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0006 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 73,064 | 0 0 0 Untested | 12 1,537,176 Untested 1,537,176 | |N1 73,065 116,206 | 0 0 0 Untested | 22 4,853,367 Untested 4,853,367 | |N2 116,207 140,545 | 0 0 0 Untested | 15 4,780,484 Untested 4,780,484 | |N3 140,546 790,890 | 0 0 0 Untested | 10 6,128,825 Untested 6,128,825 | |N4 790,891 1,511,490 | 0 0 0 Untested | 1 3,726,988 Untested 3,726,988 | |H 1,511,491 & UP | 0 0 0 Untested | 1 12,101,945 Untested 12,101,945 | | | | | | Untested Totals: | | 61 33,128,785 33,128,785 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 61 33,128,785 / 33,128,785 | | |===== |======= ============== ============== | | | | 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-914 Wylie +-----| 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 11,586 | 0 0 0 Untested | 257 3,115,238 Untested 3,115,238 | |N1 11,587 31,720 | 0 0 0 Untested | 330 14,852,006 Untested 14,852,006 | |N2 31,721 58,450 | 0 0 0 Untested | 164 14,808,305 Untested 14,808,305 | |N3 58,451 214,815 | 0 0 0 Untested | 71 14,945,651 Untested 14,945,651 | |N4 214,816 & UP | 0 0 0 Untested | 14 14,714,661 Untested 14,714,661 | | | | | | Untested Totals: | | 836 62,435,861 62,435,861 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 836 62,435,861 / 62,435,861 | | |===== |======= ============== ============== | | | | 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 99,176 | 0 0 0 Untested | 92 6,536,335 Untested 6,536,335 | |N1 99,177 313,876 | 8 1,841,900 / 1,935,408 = .9517 | 134 31,498,031 / .9517 = 33,096,597 | |N2 313,877 676,643 | 7 3,323,926 / 3,655,269 = .9094 | 55 31,419,121 / .9094 = 34,549,286 | |N3 676,644 2,693,789 | 6 5,706,324 / 6,610,621 = .8632 | 24 32,431,793 / .8632 = 37,571,586 | |N4 2,693,790 & UP | 3* 25,825,492 25,128,732 Censused | 3 25,825,492 Censused 25,128,732 | | | | | | Random Totals: | 21 | 213 95,348,945 105,217,469 | | Exception Totals: | 3 | 3 25,825,492 25,128,732 | | Untested Totals: | | 92 6,536,335 6,536,335 | | |----- |------- -------------- -------------- | | Category Totals: | 24 | 308 127,710,772 / 136,882,536 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9330 | | * All sample observations in stratum are exceptions. | | +----------------------------------------------------------------------------------------------------------------------------------+
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-914 Wylie +-----| 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 18,512 | 0 0 0 Untested | 319 2,128,747 Untested 2,128,747 | |N1 18,513 117,051 | 0 0 0 Untested | 202 10,127,545 Untested 10,127,545 | |N2 117,052 470,698 | 0 0 0 Untested | 45 10,208,600 Untested 10,208,600 | |N3 470,699 1,249,010 | 0 0 0 Untested | 13 10,434,699 Untested 10,434,699 | |N4 1,249,011 & UP | 0 0 0 Untested | 2 9,756,401 Untested 9,756,401 | | | | | | Untested Totals: | | 581 42,655,992 42,655,992 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 581 42,655,992 / 42,655,992 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
