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-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,673,705 Untested 7,673,705 | |N1 31,005 77,930 | 15 914,430 / 953,834 = .9587 | 618 36,658,121 / .9587 = 38,237,322 | |N2 77,931 120,444 | 19 1,839,350 / 1,829,135 = 1.0056 | 325 36,627,303 / 1.0056 = 36,423,332 | |N3 120,445 170,820 | 29 4,134,125 / 4,145,351 = .9973 | 224 36,642,712 / .9973 = 36,741,915 | |N4 170,821 & UP | 32 6,326,996 / 6,242,299 = 1.0136 | 155 36,488,622 / 1.0136 = 35,999,035 | | | | | | Random Totals: | 95 | 1,322 146,416,758 147,401,604 | | Untested Totals: | | 456 7,673,705 7,673,705 | | |----- |------- -------------- -------------- | | Category Totals: | 95 | 1,778 154,090,463 / 155,075,309 | | |===== |======= ============== ============== | | | | 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 935,540 Untested 935,540 | |N1 5,001 20,000 | 7 81,870 / 102,500 = .7987 | 476 4,676,048 / .7987 = 5,854,574 | |N2 20,001 25,973 | 7 156,415 / 147,518 = 1.0603 | 169 3,122,324 / 1.0603 = 2,944,755 | |N3 25,974 32,910 | 7 210,822 / 196,443 = 1.0732 | 159 3,897,533 / 1.0732 = 3,631,693 | |N4 32,911 & UP | 8 357,190 / 343,500 = 1.0399 | 93 3,897,533 / 1.0399 = 3,747,988 | | | | | | Random Totals: | 29 | 897 15,593,438 16,179,010 | | Untested Totals: | | 296 935,540 935,540 | | |----- |------- -------------- -------------- | | Category Totals: | 29 | 1,193 16,528,978 / 17,114,550 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9658 | +----------------------------------------------------------------------------------------------------------------------------------+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-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 164,309 Untested 164,309 | |N1 9,995 29,234 | 0 0 0 Untested | 32 490,178 Untested 490,178 | |N2 29,235 80,060 | 0 0 0 Untested | 12 529,364 Untested 529,364 | |N3 80,061 162,964 | 0 0 0 Untested | 5 541,739 Untested 541,739 | |N4 162,965 295,485 | 0 0 0 Untested | 2 388,773 Untested 388,773 | |H 295,486 & UP | 0 0 0 Untested | 1 1,323,067 Untested 1,323,067 | | | | | | Untested Totals: | | 102 3,437,430 3,437,430 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 102 3,437,430 / 3,437,430 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
