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-901 Allen +-----| 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 97,472 | 0 0 0 Untested | 2,221 147,431,639 Untested 147,431,639 | |N1 97,473 143,984 | 107 13,157,830 / 13,296,797 = .9895 | 4,994 693,658,562 / .9895 = 701,019,264 | |N2 143,985 175,198 | 107 16,957,374 / 17,167,944 = .9877 | 3,842 692,490,787 / .9877 = 701,114,495 | |N3 175,199 224,762 | 106 20,597,047 / 20,481,826 = 1.0056 | 3,151 692,782,731 / 1.0056 = 688,924,752 | |N4 224,763 & UP | 107 31,140,353 / 31,289,823 = .9952 | 2,051 693,074,674 / .9952 = 696,417,478 | | | | | | Random Totals: | 427 | 14,038 2,772,006,754 2,787,475,989 | | Untested Totals: | | 2,221 147,431,639 147,431,639 | | |----- |------- -------------- -------------- | | Category Totals: | 427 | 16,259 2,919,438,393 / 2,934,907,628 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9947 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 80,188 | 0 0 0 Untested | 69 5,847,277 Untested 5,847,277 | |N1 80,189 4,385,382 | 0 0 0 Untested | 33 14,577,344 Untested 14,577,344 | |N2 4,385,383 7,942,850 | 0 0 0 Untested | 2 17,401,777 Untested 17,401,777 | |N3 7,942,851 13,943,548 | 0 0 0 Untested | 1 16,934,928 Untested 16,934,928 | |H 13,943,549 & UP | 0 0 0 Untested | 2 61,939,122 Untested 61,939,122 | | | | | | Untested Totals: | | 107 116,700,448 116,700,448 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 107 116,700,448 / 116,700,448 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+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-901 Allen +-----| 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 16,600 | 0 0 0 Untested | 619 5,394,913 Untested 5,394,913 | |N1 16,601 34,500 | 0 0 0 Untested | 1,077 23,915,594 Untested 23,915,594 | |N2 34,501 235,800 | 0 0 0 Untested | 478 19,781,348 Untested 19,781,348 | |N3 235,801 938,277 | 0 0 0 Untested | 58 22,423,187 Untested 22,423,187 | |N4 938,278 & UP | 0 0 0 Untested | 12 21,190,328 Untested 21,190,328 | | | | | | Untested Totals: | | 2,244 92,705,370 92,705,370 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 2,244 92,705,370 / 92,705,370 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 466,912 | 0 0 0 Untested | 99 25,102,407 Untested 25,102,407 | |N1 466,913 2,013,479 | 8 8,109,542 / 8,355,256 = .9706 | 110 121,311,432 / .9706 = 124,986,021 | |N2 2,013,480 6,619,766 | 6 20,202,523 / 21,600,654 = .9353 | 33 122,930,942 / .9353 = 131,434,772 | |N3 6,619,767 12,555,736 | 6 56,012,391 / 56,603,939 = .9895 | 12 124,348,013 / .9895 = 125,667,522 | |N4 12,555,737 & UP | 3 80,136,605 / 80,405,969 = .9966 | 5 112,404,126 / .9966 = 112,787,604 | | | | | | Random Totals: | 23 | 160 480,994,513 494,875,919 | | Untested Totals: | | 99 25,102,407 25,102,407 | | |----- |------- -------------- -------------- | | Category Totals: | 23 | 259 506,096,920 / 519,978,326 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9733 | +----------------------------------------------------------------------------------------------------------------------------------+
DATE: 1/22/2004 COMPTROLLER OF PUBLIC ACCOUNTS - PROPERTY TAX DIVISION PAGE: 3 TIME: 13:23 2003 PROPERTY VALUE STUDY RPT: VAL7214 STRATIFIED RATIO DETAIL 043 Collin 043-901 Allen +-----| 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 59,860 | 0 0 0 Untested | 801 19,152,750 Untested 19,152,750 | |N1 59,861 393,426 | 10 1,699,631 / 1,915,114 = .8875 | 240 57,573,629 / .8875 = 64,871,695 | |N2 393,427 1,347,088 | 8 6,674,508 / 7,154,632 = .9329 | 52 58,535,112 / .9329 = 62,745,323 | |N3 1,347,089 2,979,654 | 8 16,875,787 / 20,352,414 = .8292 | 19 58,227,438 / .8292 = 70,221,223 | |N4 2,979,655 14,074,687 | 4 17,965,818 / 18,966,006 = .9473 | 6 55,035,313 / .9473 = 58,097,026 | |H 14,074,688 & UP | 2* 45,003,201 50,958,908 Censused | 2 45,003,201 Censused 50,958,908 | | | | | | Random Totals: | 30 | 317 229,371,492 255,935,267 | | Exception Totals: | 2 | 2 45,003,201 50,958,908 | | Untested Totals: | | 801 19,152,750 19,152,750 | | |----- |------- -------------- -------------- | | Category Totals: | 32 | 1,120 293,527,443 / 326,046,925 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9003 | | * All sample observations in stratum are exceptions. | | +----------------------------------------------------------------------------------------------------------------------------------+
