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-902 Anna +-----| 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 32,550 | 0 0 0 Untested | 301 5,404,388 Untested 5,404,388 | |N1 32,551 74,601 | 10 599,843 / 591,900 = 1.0134 | 379 25,754,780 / 1.0134 = 25,414,229 | |N2 74,602 104,144 | 31 2,915,152 / 2,968,784 = .9819 | 224 25,689,797 / .9819 = 26,163,354 | |N3 104,145 144,232 | 68 7,921,817 / 7,962,562 = .9949 | 168 25,722,288 / .9949 = 25,854,144 | |N4 144,233 & UP | 17 3,060,635 / 3,099,043 = .9876 | 102 25,733,119 / .9876 = 26,056,216 | | | | | | Random Totals: | 126 | 873 102,899,984 103,487,943 | | Untested Totals: | | 301 5,404,388 5,404,388 | | |----- |------- -------------- -------------- | | Category Totals: | 126 | 1,174 108,304,372 / 108,892,331 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9946 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |N1 1 & UP | 0 0 0 Untested | 12 948,198 Untested 948,198 | | | | | | Untested Totals: | | 12 948,198 948,198 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 12 948,198 / 948,198 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 8,000 | 0 0 0 Untested | 214 655,929 Untested 655,929 | |N1 8,001 17,500 | 9 108,865 / 102,111 = 1.0661 | 436 7,241,969 / 1.0661 = 6,792,955 | |N2 17,501 & UP | 23 604,602 / 610,738 = .9900 | 175 4,838,593 / .9900 = 4,887,468 | | | | | | Random Totals: | 32 | 611 12,080,562 11,680,423 | | Untested Totals: | | 214 655,929 655,929 | | |----- |------- -------------- -------------- | | Category Totals: | 32 | 825 12,736,491 / 12,336,352 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0324 | +----------------------------------------------------------------------------------------------------------------------------------+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-902 Anna +-----| 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 52,466 | 0 0 0 Untested | 24 666,762 Untested 666,762 | |N1 52,467 170,053 | 6 602,855 / 567,089 = 1.0631 | 23 2,560,533 / 1.0631 = 2,408,553 | |N2 170,054 603,293 | 5* 1,488,853 1,498,327 Censused | 5 1,488,853 Censused 1,498,327 | |N3 603,294 1,152,677 | 2* 1,747,836 1,624,143 Censused | 2 1,747,836 Censused 1,624,143 | |N4 1,152,678 1,816,107 | 1* 1,402,984 1,400,000 Censused | 1 1,402,984 Censused 1,400,000 | |H 1,816,108 & UP | 2* 5,238,081 5,238,032 Censused | 2 5,238,081 Censused 5,238,032 | | | | | | Random Totals: | 6 | 23 2,560,533 2,408,553 | | Exception Totals: | 10 | 10 9,877,754 9,760,502 | | Untested Totals: | | 24 666,762 666,762 | | |----- |------- -------------- -------------- | | Category Totals: | 16 | 57 13,105,049 / 12,835,817 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0210 | | * All sample observations in stratum are exceptions. | | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 10,186 | 0 0 0 Untested | 60 249,199 Untested 249,199 | |N1 10,187 66,032 | 0 0 0 Untested | 40 1,293,363 Untested 1,293,363 | |N2 66,033 197,429 | 0 0 0 Untested | 9 1,387,070 Untested 1,387,070 | |N3 197,430 316,088 | 0 0 0 Untested | 4 1,364,416 Untested 1,364,416 | |N4 316,089 & UP | 0 0 0 Untested | 1 854,691 Untested 854,691 | | | | | | Untested Totals: | | 114 5,148,739 5,148,739 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 114 5,148,739 / 5,148,739 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
