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-918 Community +-----| 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 31,004 | 0 0 0 Untested | 456 7,671,302 Untested 7,671,302 | |N1 31,005 77,930 | 15 914,430 / 953,834 = .9587 | 618 36,646,641 / .9587 = 38,225,348 | |N2 77,931 120,444 | 19 1,839,350 / 1,829,135 = 1.0056 | 325 36,615,832 / 1.0056 = 36,411,925 | |N3 120,445 170,820 | 29 4,134,125 / 4,145,351 = .9973 | 224 36,631,236 / .9973 = 36,730,408 | |N4 170,821 & UP | 32 6,326,996 / 6,242,299 = 1.0136 | 155 36,477,194 / 1.0136 = 35,987,760 | | | | | | Random Totals: | 95 | 1,322 146,370,903 147,355,441 | | Untested Totals: | | 456 7,671,302 7,671,302 | | |----- |------- -------------- -------------- | | Category Totals: | 95 | 1,778 154,042,205 / 155,026,743 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9936 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 | 1 44,398 Untested 44,398 | | | | | | Untested Totals: | | 1 44,398 44,398 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 1 44,398 / 44,398 | | |===== |======= ============== ============== | | | | 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 5,000 | 0 0 0 Untested | 296 938,968 Untested 938,968 | |N1 5,001 20,000 | 7 81,870 / 102,500 = .7987 | 476 4,693,179 / .7987 = 5,876,022 | |N2 20,001 25,973 | 7 156,415 / 147,518 = 1.0603 | 169 3,133,763 / 1.0603 = 2,955,544 | |N3 25,974 32,910 | 7 210,822 / 196,443 = 1.0732 | 159 3,911,812 / 1.0732 = 3,644,998 | |N4 32,911 & UP | 8 357,190 / 343,500 = 1.0399 | 93 3,911,812 / 1.0399 = 3,761,719 | | | | | | Random Totals: | 29 | 897 15,650,566 16,238,283 | | Untested Totals: | | 296 938,968 938,968 | | |----- |------- -------------- -------------- | | Category Totals: | 29 | 1,193 16,589,534 / 17,177,251 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9658 | +----------------------------------------------------------------------------------------------------------------------------------+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-918 Community +-----| 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 | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |N1 1 & UP | 0 0 0 Untested | 50 4,668,418 Untested 4,668,418 | | | | | | Untested Totals: | | 50 4,668,418 4,668,418 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 50 4,668,418 / 4,668,418 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 9,994 | 0 0 0 Untested | 50 166,407 Untested 166,407 | |N1 9,995 29,234 | 0 0 0 Untested | 32 496,436 Untested 496,436 | |N2 29,235 80,060 | 0 0 0 Untested | 12 536,123 Untested 536,123 | |N3 80,061 162,964 | 0 0 0 Untested | 5 548,656 Untested 548,656 | |N4 162,965 295,485 | 0 0 0 Untested | 2 393,737 Untested 393,737 | |H 295,486 & UP | 0 0 0 Untested | 1 1,339,960 Untested 1,339,960 | | | | | | Untested Totals: | | 102 3,481,319 3,481,319 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 102 3,481,319 / 3,481,319 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
