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-910 Plano +-----| 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 116,000 | 0 0 0 Untested | 10,225 888,880,198 Untested 888,880,198 | |N1 116,001 173,880 | 107 15,987,113 / 16,061,515 = .9954 | 27,669 4,222,180,941 / .9954 = 4,241,692,728 | |N2 173,881 235,087 | 107 21,784,680 / 21,940,433 = .9929 | 20,244 4,222,180,941 / .9929 = 4,252,372,788 | |N3 235,088 352,759 | 106 30,427,456 / 30,554,524 = .9958 | 14,353 4,222,180,941 / .9958 = 4,239,988,894 | |N4 352,760 & UP | 107 61,725,855 / 60,784,810 = 1.0155 | 7,232 4,222,180,941 / 1.0155 = 4,157,736,032 | | | | | | Random Totals: | 427 | 69,498 16,888,723,764 16,891,790,442 | | Untested Totals: | | 10,225 888,880,198 888,880,198 | | |----- |------- -------------- -------------- | | Category Totals: | 427 | 79,723 17,777,603,962 / 17,780,670,640 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9998 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 184,777 | 0 0 0 Untested | 932 106,647,227 Untested 106,647,227 | |N1 184,778 10,859,425 | 7 30,464,481 / 33,852,590 = .8999 | 184 514,503,687 / .8999 = 571,734,289 | |N2 10,859,426 14,750,704 | 6 77,587,448 / 80,770,793 = .9606 | 40 503,221,645 / .9606 = 523,861,800 | |N3 14,750,705 21,143,322 | 6 107,969,560 / 117,015,391 = .9227 | 29 514,077,950 / .9227 = 557,145,280 | |N4 21,143,323 & UP | 6 165,174,139 / 168,266,622 = .9816 | 19 490,236,653 / .9816 = 499,426,093 | | | | | | Random Totals: | 25 | 272 2,022,039,935 2,152,167,462 | | Untested Totals: | | 932 106,647,227 106,647,227 | | |----- |------- -------------- -------------- | | Category Totals: | 25 | 1,204 2,128,687,162 / 2,258,814,689 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9424 | +----------------------------------------------------------------------------------------------------------------------------------+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-910 Plano +-----| 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 45,000 | 0 0 0 Untested | 712 16,858,590 Untested 16,858,590 | |N1 45,001 185,990 | 31 3,528,400 / 3,477,850 = 1.0145 | 1,099 74,372,441 / 1.0145 = 73,309,454 | |N2 185,991 750,000 | 11 4,667,432 / 4,815,038 = .9693 | 201 74,498,017 / .9693 = 76,857,544 | |N3 750,001 2,734,560 | 7 8,944,092 / 9,056,216 = .9876 | 61 75,314,261 / .9876 = 76,259,884 | |N4 2,734,561 & UP | 6 26,062,466 / 27,491,099 = .9480 | 15 72,928,316 / .9480 = 76,928,603 | | | | | | Random Totals: | 55 | 1,376 297,113,035 303,355,485 | | Untested Totals: | | 712 16,858,590 16,858,590 | | |----- |------- -------------- -------------- | | Category Totals: | 55 | 2,088 313,971,625 / 320,214,075 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9805 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 704,123 | 0 0 0 Untested | 819 272,636,347 Untested 272,636,347 | |N1 704,124 4,139,196 | 15 31,418,371 / 33,929,924 = .9260 | 710 1,297,617,884 / .9260 = 1,401,315,210 | |N2 4,139,197 10,500,000 | 7 40,456,773 / 42,609,734 = .9495 | 187 1,314,555,212 / .9495 = 1,384,470,997 | |N3 10,500,001 23,175,990 | 7 120,401,811 / 121,905,721 = .9877 | 74 1,282,319,652 / .9877 = 1,298,288,602 | |N4 23,175,991 & UP | 6 315,441,479 / 309,693,960 = 1.0186 | 27 1,297,071,518 / 1.0186 = 1,273,386,529 | | | | | | Random Totals: | 35 | 998 5,191,564,266 5,357,461,338 | | Untested Totals: | | 819 272,636,347 272,636,347 | | |----- |------- -------------- -------------- | | Category Totals: | 35 | 1,817 5,464,200,613 / 5,630,097,685 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9705 | +----------------------------------------------------------------------------------------------------------------------------------+
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-910 Plano +-----| 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 67,154 | 0 0 0 Untested | 5,969 102,650,935 Untested 102,650,935 | |N1 67,155 986,545 | 8 1,820,784 / 2,071,652 = .8789 | 1,982 488,413,146 / .8789 = 555,709,576 | |N2 986,546 3,978,919 | 9 19,011,901 / 20,911,166 = .9092 | 222 486,770,731 / .9092 = 535,383,558 | |N3 3,978,920 14,629,930 | 8 54,906,777 / 55,259,558 = .9936 | 61 492,313,882 / .9936 = 495,484,986 | |N4 14,629,931 & UP | 4 90,650,106 / 98,100,543 = .9241 | 15 482,869,996 / .9241 = 522,530,025 | | | | | | Random Totals: | 29 | 2,280 1,950,367,755 2,109,108,145 | | Untested Totals: | | 5,969 102,650,935 102,650,935 | | |----- |------- -------------- -------------- | | Category Totals: | 29 | 8,249 2,053,018,690 / 2,211,759,080 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9282 | +----------------------------------------------------------------------------------------------------------------------------------+
