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-903 Celina +-----| 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 43,783 | 0 0 0 Untested | 418 9,769,716 Untested 9,769,716 | |N1 43,784 113,521 | 23 2,127,983 / 2,180,345 = .9760 | 542 46,464,770 / .9760 = 47,607,346 | |N2 113,522 173,221 | 40 5,722,085 / 5,736,706 = .9975 | 303 46,347,533 / .9975 = 46,463,692 | |N3 173,222 281,490 | 16 3,542,728 / 3,599,950 = .9841 | 186 46,445,230 / .9841 = 47,195,641 | |N4 281,491 & UP | 12 4,021,683 / 4,031,200 = .9976 | 118 46,386,612 / .9976 = 46,498,208 | | | | | | Random Totals: | 91 | 1,149 185,644,145 187,764,887 | | Untested Totals: | | 418 9,769,716 9,769,716 | | |----- |------- -------------- -------------- | | Category Totals: | 91 | 1,567 195,413,861 / 197,534,603 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9893 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 | 19 2,491,054 Untested 2,491,054 | | | | | | Untested Totals: | | 19 2,491,054 2,491,054 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 19 2,491,054 / 2,491,054 | | |===== |======= ============== ============== | | | | 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 11,700 | 0 0 0 Untested | 171 771,745 Untested 771,745 | |N1 11,701 48,960 | 11 308,570 / 343,000 = .8996 | 264 7,404,705 / .8996 = 8,231,108 | |N2 48,961 & UP | 24 1,673,360 / 1,555,750 = 1.0756 | 107 7,382,922 / 1.0756 = 6,864,003 | | | | | | Random Totals: | 35 | 371 14,787,627 15,095,111 | | Untested Totals: | | 171 771,745 771,745 | | |----- |------- -------------- -------------- | | Category Totals: | 35 | 542 15,559,372 / 15,866,856 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9806 | +----------------------------------------------------------------------------------------------------------------------------------+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-903 Celina +-----| 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 45,474 | 0 0 0 Untested | 23 734,958 Untested 734,958 | |N1 45,475 110,011 | 0 0 0 Untested | 40 3,721,803 Untested 3,721,803 | |N2 110,012 238,156 | 0 0 0 Untested | 18 3,859,705 Untested 3,859,705 | |N3 238,157 472,566 | 0 0 0 Untested | 8 3,881,644 Untested 3,881,644 | |N4 472,567 & UP | 0 0 0 Untested | 3 3,472,638 Untested 3,472,638 | | | | | | Untested Totals: | | 92 15,670,748 15,670,748 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 92 15,670,748 / 15,670,748 | | |===== |======= ============== ============== | | | | 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 10,046 | 0 0 0 Untested | 92 405,066 Untested 405,066 | |N1 10,047 45,000 | 0 0 0 Untested | 66 1,998,048 Untested 1,998,048 | |N2 45,001 136,350 | 0 0 0 Untested | 23 2,072,448 Untested 2,072,448 | |N3 136,351 416,959 | 0 0 0 Untested | 8 2,334,501 Untested 2,334,501 | |N4 416,960 & UP | 0 0 0 Untested | 2 1,456,583 Untested 1,456,583 | | | | | | Untested Totals: | | 191 8,266,646 8,266,646 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 191 8,266,646 / 8,266,646 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
