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-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,756,170 Untested 9,756,170 | |N1 43,784 113,521 | 23 2,127,983 / 2,180,345 = .9760 | 542 46,400,342 / .9760 = 47,541,334 | |N2 113,522 173,221 | 40 5,722,085 / 5,736,706 = .9975 | 303 46,283,268 / .9975 = 46,399,266 | |N3 173,222 281,490 | 16 3,542,728 / 3,599,950 = .9841 | 186 46,380,830 / .9841 = 47,130,200 | |N4 281,491 & UP | 12 4,021,683 / 4,031,200 = .9976 | 118 46,322,293 / .9976 = 46,433,734 | | | | | | Random Totals: | 91 | 1,149 185,386,733 187,504,534 | | Untested Totals: | | 418 9,756,170 9,756,170 | | |----- |------- -------------- -------------- | | Category Totals: | 91 | 1,567 195,142,903 / 197,260,704 | | |===== |======= ============== ============== | | | | 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 772,737 Untested 772,737 | |N1 11,701 48,960 | 11 308,570 / 343,000 = .8996 | 264 7,414,223 / .8996 = 8,241,689 | |N2 48,961 & UP | 24 1,673,360 / 1,555,750 = 1.0756 | 107 7,392,412 / 1.0756 = 6,872,826 | | | | | | Random Totals: | 35 | 371 14,806,635 15,114,515 | | Untested Totals: | | 171 772,737 772,737 | | |----- |------- -------------- -------------- | | Category Totals: | 35 | 542 15,579,372 / 15,887,252 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9806 | +----------------------------------------------------------------------------------------------------------------------------------+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-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 283,120 Untested 283,120 | |N1 10,047 45,000 | 0 0 0 Untested | 66 1,396,531 Untested 1,396,531 | |N2 45,001 136,350 | 0 0 0 Untested | 23 1,448,533 Untested 1,448,533 | |N3 136,351 416,959 | 0 0 0 Untested | 8 1,631,694 Untested 1,631,694 | |N4 416,960 & UP | 0 0 0 Untested | 2 1,018,075 Untested 1,018,075 | | | | | | Untested Totals: | | 191 5,777,953 5,777,953 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 191 5,777,953 / 5,777,953 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
