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-908 Melissa +-----| 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 47,764 | 0 0 0 Untested | 240 7,213,465 Untested 7,213,465 | |N1 47,765 173,002 | 34 4,180,021 / 4,188,843 = .9979 | 355 34,459,504 / .9979 = 34,532,021 | |N2 173,003 255,423 | 24 5,213,759 / 5,194,050 = 1.0038 | 150 34,387,080 / 1.0038 = 34,256,904 | |N3 255,424 322,245 | 15 4,209,749 / 4,206,270 = 1.0008 | 113 34,604,353 / 1.0008 = 34,576,692 | |N4 322,246 & UP | 6 2,333,508 / 2,396,400 = .9738 | 75 34,184,292 / .9738 = 35,104,017 | | | | | | Random Totals: | 79 | 693 137,635,229 138,469,634 | | Untested Totals: | | 240 7,213,465 7,213,465 | | |----- |------- -------------- -------------- | | Category Totals: | 79 | 933 144,848,694 / 145,683,099 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9943 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 | 2 173,938 Untested 173,938 | | | | | | Untested Totals: | | 2 173,938 173,938 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 2 173,938 / 173,938 | | |===== |======= ============== ============== | | | | 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 8,500 | 0 0 0 Untested | 180 1,422,492 Untested 1,422,492 | |N1 8,501 32,000 | 0 0 0 Untested | 127 2,470,431 Untested 2,470,431 | |N2 32,001 46,800 | 0 0 0 Untested | 47 2,130,204 Untested 2,130,204 | |N3 46,801 63,000 | 0 0 0 Untested | 38 2,179,674 Untested 2,179,674 | |N4 63,001 & UP | 0 0 0 Untested | 22 1,893,964 Untested 1,893,964 | | | | | | Untested Totals: | | 414 10,096,765 10,096,765 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 414 10,096,765 / 10,096,765 | | |===== |======= ============== ============== | | | | 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-908 Melissa +-----| 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 56,811 | 0 0 0 Untested | 18 814,074 Untested 814,074 | |N1 56,812 226,897 | 6 881,238 / 936,897 = .9406 | 23 4,464,857 / .9406 = 4,746,818 | |N2 226,898 364,450 | 5 1,498,549 / 1,554,005 = .9643 | 10 4,287,338 / .9643 = 4,446,062 | |N3 364,451 538,123 | 4 1,844,592 / 1,791,615 = 1.0296 | 6 4,091,889 / 1.0296 = 3,974,251 | |N4 538,124 & UP | 3* 2,978,039 2,936,783 Censused | 3 2,978,039 Censused 2,936,783 | | | | | | Random Totals: | 15 | 39 12,844,084 13,167,131 | | Exception Totals: | 3 | 3 2,978,039 2,936,783 | | Untested Totals: | | 18 814,074 814,074 | | |----- |------- -------------- -------------- | | Category Totals: | 18 | 60 16,636,197 / 16,917,988 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9833 | | * All sample observations in stratum are exceptions. | | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 18,319 | 0 0 0 Untested | 76 537,392 Untested 537,392 | |N1 18,320 157,683 | 8 632,482 / 632,815 = .9995 | 48 2,721,096 / .9995 = 2,722,457 | |N2 157,684 345,027 | 4 918,801 / 1,134,384 = .8100 | 10 2,681,452 / .8100 = 3,310,435 | |N3 345,028 812,600 | 4 1,757,351 / 1,957,875 = .8976 | 6 3,249,678 / .8976 = 3,620,408 | |N4 812,601 & UP | 1* 1,744,091 1,965,453 Censused | 1 1,744,091 Censused 1,965,453 | | | | | | Random Totals: | 16 | 64 8,652,226 9,653,300 | | Exception Totals: | 1 | 1 1,744,091 1,965,453 | | Untested Totals: | | 76 537,392 537,392 | | |----- |------- -------------- -------------- | | Category Totals: | 17 | 141 10,933,709 / 12,156,145 | | |===== |======= ============== ============== | | | | Final Category Ratio: .8994 | | * All sample observations in stratum are exceptions. | | +----------------------------------------------------------------------------------------------------------------------------------+
