DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 1 TIME: 17:57 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 057 Dallas 057-904 Cedar Hill +-----| 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 68,030 | 0 0 0 Untested | 1,219 75,517,633 Untested 75,517,633 | |N1 68,031 98,030 | 46 4,020,610 / 3,996,042 = 1.0061 | 3,703 355,306,726 / 1.0061 = 353,152,496 | |N2 98,031 118,910 | 50 5,365,590 / 5,347,991 = 1.0033 | 2,910 355,007,647 / 1.0033 = 353,839,975 | |N3 118,911 165,170 | 49 6,540,508 / 6,513,226 = 1.0042 | 2,294 354,858,107 / 1.0042 = 353,373,936 | |N4 165,171 & UP | 50 13,727,563 / 14,545,017 = .9438 | 1,167 354,708,567 / .9438 = 375,830,226 | | | | | | Random Totals: | 195 | 10,074 1,419,881,047 1,436,196,633 | | Untested Totals: | | 1,219 75,517,633 75,517,633 | | |----- |------- -------------- -------------- | | Category Totals: | 195 | 11,293 1,495,398,680 / 1,511,714,266 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9892 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 | | -------------- -------------- |----- ------------- ------------- ------ |------- -------------- ------ -------------- | |L 1 53,960 | 0 0 0 Untested | 65 3,589,082 Untested 3,589,082 | |N1 53,961 63,890 | 0 0 0 Untested | 199 12,863,771 Untested 12,863,771 | |N2 63,891 1,810,680 | 0 0 0 Untested | 105 13,183,109 Untested 13,183,109 | |N3 1,810,681 9,700,000 | 0 0 0 Untested | 2 13,689,884 Untested 13,689,884 | |N4 9,700,001 10,618,960 | 0 0 0 Untested | 1 11,683,608 Untested 11,683,608 | |H 10,618,961 & UP | 0 0 0 Untested | 1 14,418,808 Untested 14,418,808 | | | | | | Untested Totals: | | 373 69,428,262 69,428,262 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 373 69,428,262 / 69,428,262 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 2 TIME: 17:57 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 057 Dallas 057-904 Cedar Hill +-----| 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 18,000 | 0 0 0 Untested | 1,160 7,210,266 Untested 7,210,266 | |N1 18,001 57,500 | 14 636,240 / 623,175 = 1.0210 | 778 33,234,166 / 1.0210 = 32,550,603 | |N2 57,501 93,500 | 7 496,980 / 524,300 = .9479 | 437 32,899,454 / .9479 = 34,707,727 | |N3 93,501 174,710 | 10 1,082,350 / 897,000 = 1.2066 | 263 33,178,381 / 1.2066 = 27,497,415 | |N4 174,711 & UP | 9 3,510,400 / 3,378,466 = 1.0391 | 85 32,941,293 / 1.0391 = 31,701,754 | | | | | | Random Totals: | 40 | 1,563 132,253,294 126,457,499 | | Untested Totals: | | 1,160 7,210,266 7,210,266 | | |----- |------- -------------- -------------- | | Category Totals: | 40 | 2,723 139,463,560 / 133,667,765 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0434 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 145,000 | 0 0 0 Untested | 137 10,378,842 Untested 10,378,842 | |N1 145,001 800,000 | 7 2,289,500 / 2,258,780 = 1.0136 | 146 49,818,439 / 1.0136 = 49,149,999 | |N2 800,001 2,275,940 | 6 8,161,720 / 8,456,457 = .9651 | 37 49,382,528 / .9651 = 51,168,302 | |N3 2,275,941 7,078,810 | 5 26,901,370 / 29,456,515 = .9133 | 10 50,877,081 / .9133 = 55,706,866 | |N4 7,078,811 & UP | 3* 43,883,740 44,697,080 Censused | 3 43,883,740 Censused 44,697,080 | | | | | | Random Totals: | 18 | 193 150,078,048 156,025,167 | | Exception Totals: | 3 | 3 43,883,740 44,697,080 | | Untested Totals: | | 137 10,378,842 10,378,842 | | |----- |------- -------------- -------------- | | Category Totals: | 21 | 333 204,340,630 / 211,101,089 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9680 | | * All sample observations in stratum are exceptions. | | +----------------------------------------------------------------------------------------------------------------------------------+
DATE: 6/27/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 3 TIME: 17:57 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 057 Dallas 057-904 Cedar Hill +-----| 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 33,220 | 0 0 0 Untested | 396 4,460,188 Untested 4,460,188 | |N1 33,221 302,540 | 0 0 0 Untested | 191 21,529,159 Untested 21,529,159 | |N2 302,541 1,208,800 | 0 0 0 Untested | 35 21,950,947 Untested 21,950,947 | |N3 1,208,801 2,346,880 | 0 0 0 Untested | 11 20,640,711 Untested 20,640,711 | |N4 2,346,881 & UP | 0 0 0 Untested | 5 21,161,215 Untested 21,161,215 | | | | | | Untested Totals: | | 638 89,742,220 89,742,220 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 638 89,742,220 / 89,742,220 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
