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-911 Princeton +-----| 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 33,203 | 0 0 0 Untested | 538 11,426,452 Untested 11,426,452 | |N1 33,204 72,721 | 19 1,120,038 / 1,312,876 = .8531 | 968 54,384,415 / .8531 = 63,749,168 | |N2 72,722 97,608 | 30 2,560,657 / 2,771,643 = .9239 | 613 54,453,111 / .9239 = 58,938,317 | |N3 97,609 130,165 | 20 2,259,531 / 2,225,609 = 1.0152 | 461 54,407,313 / 1.0152 = 53,592,704 | |N4 130,166 & UP | 41 6,448,784 / 6,393,396 = 1.0087 | 331 54,315,719 / 1.0087 = 53,847,248 | | | | | | Random Totals: | 110 | 2,373 217,560,558 230,127,437 | | Untested Totals: | | 538 11,426,452 11,426,452 | | |----- |------- -------------- -------------- | | Category Totals: | 110 | 2,911 228,987,010 / 241,553,889 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9480 | +----------------------------------------------------------------------------------------------------------------------------------+ +-----| 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 | 36 4,242,093 Untested 4,242,093 | | | | | | Untested Totals: | | 36 4,242,093 4,242,093 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 36 4,242,093 / 4,242,093 | | |===== |======= ============== ============== | | | | 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 5,000 | 0 0 0 Untested | 348 1,348,862 Untested 1,348,862 | |N1 5,001 24,948 | 10 130,854 / 131,250 = .9970 | 371 5,059,814 / .9970 = 5,075,039 | |N2 24,949 29,634 | 9 225,000 / 230,300 = .9770 | 176 4,833,948 / .9770 = 4,947,746 | |N3 29,635 40,000 | 7 234,707 / 230,707 = 1.0173 | 130 4,922,606 / 1.0173 = 4,838,893 | |N4 40,001 & UP | 7 398,803 / 370,857 = 1.0754 | 69 4,943,715 / 1.0754 = 4,597,094 | | | | | | Random Totals: | 33 | 746 19,760,083 19,458,772 | | Untested Totals: | | 348 1,348,862 1,348,862 | | |----- |------- -------------- -------------- | | Category Totals: | 33 | 1,094 21,108,945 / 20,807,634 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0145 | +----------------------------------------------------------------------------------------------------------------------------------+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-911 Princeton +-----| 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 58,925 | 0 0 0 Untested | 41 1,021,321 Untested 1,021,321 | |N1 58,926 205,000 | 6 842,077 / 898,005 = .9377 | 47 5,166,056 / .9377 = 5,509,284 | |N2 205,001 385,888 | 5 1,598,372 / 1,657,455 = .9644 | 15 5,032,286 / .9644 = 5,218,049 | |N3 385,889 1,264,820 | 4 3,045,488 / 2,968,977 = 1.0258 | 6 5,507,912 / 1.0258 = 5,369,382 | |N4 1,264,821 & UP | 2* 3,868,128 5,039,591 Censused | 2 3,868,128 Censused 5,039,591 | | | | | | Random Totals: | 15 | 68 15,706,254 16,096,715 | | Exception Totals: | 2 | 2 3,868,128 5,039,591 | | Untested Totals: | | 41 1,021,321 1,021,321 | | |----- |------- -------------- -------------- | | Category Totals: | 17 | 111 20,595,703 / 22,157,627 | | |===== |======= ============== ============== | | | | Final Category Ratio: .9295 | | * 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 11,683 | 0 0 0 Untested | 113 319,902 Untested 319,902 | |N1 11,684 75,297 | 0 0 0 Untested | 69 1,586,451 Untested 1,586,451 | |N2 75,298 135,816 | 0 0 0 Untested | 18 1,530,305 Untested 1,530,305 | |N3 135,817 258,688 | 0 0 0 Untested | 9 1,579,269 Untested 1,579,269 | |N4 258,689 & UP | 0 0 0 Untested | 5 1,512,677 Untested 1,512,677 | | | | | | Untested Totals: | | 214 6,528,604 6,528,604 | | |----- |------- -------------- -------------- | | Category Totals: | 0 | 214 6,528,604 / 6,528,604 | | |===== |======= ============== ============== | | | | Final Category Ratio: 1.0000 | +----------------------------------------------------------------------------------------------------------------------------------+
