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-912 Prosper +-----| 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 85,649 | 0 0 0 Untested | 422 16,640,835 Untested 16,640,835 | |N1 85,650 148,102 | 46 6,062,234 / 5,986,980 = 1.0126 | 501 79,327,997 / 1.0126 = 78,340,902 | |N2 148,103 195,058 | 50 8,177,416 / 8,080,038 = 1.0121 | 379 79,394,827 / 1.0121 = 78,445,635 | |N3 195,059 332,431 | 31 8,297,431 / 8,138,299 = 1.0196 | 246 79,361,412 / 1.0196 = 77,835,830 | |N4 332,432 & UP | 23 10,628,715 / 10,482,030 = 1.0140 | 137 79,394,827 / 1.0140 = 78,298,646 | | | | | | Random Totals: | 150 | 1,263 317,479,063 312,921,013 | | Untested Totals: | | 422 16,640,835 16,640,835 | | |----- |------- -------------- -------------- | | Category Totals: | 150 | 1,685 334,119,898 / 329,561,848 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0138 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 | 16 1,398,006 Untested 1,398,006 | | | | | | Untested Totals: | | 16 1,398,006 1,398,006 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 16 1,398,006 / 1,398,006 | | |===== |======= ============== ============== | | | | 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 22,500 | 0 0 0 Untested | 87 1,263,637 Untested 1,263,637 | |N1 22,501 32,400 | 0 0 0 Untested | 163 6,173,771 Untested 6,173,771 | |N2 32,401 45,000 | 0 0 0 Untested | 120 6,111,879 Untested 6,111,879 | |N3 45,001 107,965 | 0 0 0 Untested | 65 6,080,933 Untested 6,080,933 | |N4 107,966 & UP | 0 0 0 Untested | 32 6,158,298 Untested 6,158,298 | | | | | | Untested Totals: | | 467 25,788,518 25,788,518 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 467 25,788,518 / 25,788,518 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+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-912 Prosper +-----| 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 60,878 | 0 0 0 Untested | 54 2,524,199 Untested 2,524,199 | |N1 60,879 162,443 | 7 669,226 / 676,802 = .9888 | 103 12,356,652 / .9888 = 12,496,614 | |N2 162,444 695,697 | 7 1,589,576 / 1,582,072 = 1.0047 | 39 12,740,206 / 1.0047 = 12,680,607 | |N3 695,698 1,279,805 | 5 5,083,755 / 5,151,250 = .9869 | 10 12,195,974 / .9869 = 12,357,862 | |N4 1,279,806 & UP | 3* 7,007,951 7,386,460 Censused | 3 7,007,951 Censused 7,386,460 | | | | | | Random Totals: | 19 | 152 37,292,832 37,535,083 | | Exception Totals: | 3 | 3 7,007,951 7,386,460 | | Untested Totals: | | 54 2,524,199 2,524,199 | | |----- |------- -------------- -------------- | | Category Totals: | 22 | 209 46,824,982 / 47,445,742 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9869 | | * 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,660 | 0 0 0 Untested | 153 961,142 Untested 961,142 | |N1 18,661 221,250 | 0 0 0 Untested | 78 4,712,319 Untested 4,712,319 | |N2 221,251 1,010,129 | 0 0 0 Untested | 11 5,161,760 Untested 5,161,760 | |N3 1,010,130 1,810,363 | 0 0 0 Untested | 4 5,603,418 Untested 5,603,418 | |N4 1,810,364 & UP | 0 0 0 Untested | 1 3,019,620 Untested 3,019,620 | | | | | | Untested Totals: | | 247 19,458,259 19,458,259 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 247 19,458,259 / 19,458,259 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
