DATE: 1/22/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 1 TIME: 13:23 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,400,992 Untested 5,400,992 | |N1 32,551 74,601 | 10 599,843 / 591,900 = 1.0134 | 379 25,738,596 / 1.0134 = 25,398,259 | |N2 74,602 104,144 | 31 2,915,152 / 2,968,784 = .9819 | 224 25,673,654 / .9819 = 26,146,913 | |N3 104,145 144,232 | 68 7,921,817 / 7,962,562 = .9949 | 168 25,706,125 / .9949 = 25,837,898 | |N4 144,233 & UP | 17 3,060,635 / 3,099,043 = .9876 | 102 25,716,949 / .9876 = 26,039,843 | | | | | | Random Totals: | 126 | 873 102,835,324 103,422,913 | | Untested Totals: | | 301 5,400,992 5,400,992 | | |----- |------- -------------- -------------- | | Category Totals: | 126 | 1,174 108,236,316 / 108,823,905 | | |===== |======= ============== ============== | | | | 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 658,234 Untested 658,234 | |N1 8,001 17,500 | 9 108,865 / 102,111 = 1.0661 | 436 7,267,414 / 1.0661 = 6,816,822 | |N2 17,501 & UP | 23 604,602 / 610,738 = .9900 | 175 4,855,593 / .9900 = 4,904,639 | | | | | | Random Totals: | 32 | 611 12,123,007 11,721,461 | | Untested Totals: | | 214 658,234 658,234 | | |----- |------- -------------- -------------- | | Category Totals: | 32 | 825 12,781,241 / 12,379,695 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0324 | +----------------------------------------------------------------------------------------------------------------------------------+DATE: 1/22/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 2 TIME: 13:23 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 313,525 Untested 313,525 | |N1 10,187 66,032 | 0 0 0 Untested | 40 1,627,223 Untested 1,627,223 | |N2 66,033 197,429 | 0 0 0 Untested | 9 1,745,119 Untested 1,745,119 | |N3 197,430 316,088 | 0 0 0 Untested | 4 1,716,616 Untested 1,716,616 | |N4 316,089 & UP | 0 0 0 Untested | 1 1,075,314 Untested 1,075,314 | | | | | | Untested Totals: | | 114 6,477,797 6,477,797 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 114 6,477,797 / 6,477,797 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
