Loading...
HomeMy WebLinkAbout992356.tiff 1999 Weld County PROPERTY ASSESSMENT STUDY Prepared for Colorado Legislative Council Thos. Y. Pickett & Company, Inc. Denver, Colorado Ccnt zcp�C�_ �: AS 992356 99 9-aa A5'00411 / THOS. Y. l'aluation Engineers PICKETT Oil& Gas-Minerals Tax Consultants Industrial& Commercial Ratio Studies Public Utilities &COMPANY, INC. Data Management Services Real Estate Apt aisals September 15, 1999 Mr. Charles S. Brown Director of Research Colorado Legislative Council State Capitol Building - Room 029 Denver, Colorado 80203 Dear Mr. Brown, Thos. Y. Pickett & Co. has completed the 1999 Property Assessment Study in Weld County. This Final Report documents the results and associated recommendations of the analysis and procedural verifications. The statistical analysis has been conducted in complete accordance with the following procedures: the Request for Credentials and Proposals to Conduct a Colorado Property Assessment Study, dated July 17, 1998; Contract Encumbrance Number 99000000004, dated November 27, 1998; and the current Standards on Ratio Studies approved and published by the International Association of Assessing Officers in July 1990. Respectfully submitted, THOS. Y. PICKETT & CO. INC. John Zimmerman 4155 East Jewell Avenue, Suite 809 • Denver,Colorado 80222-4512 Phone(303) 691-9986 • Fax (303) 757-4898 • Home Page: www.typco.com 1999 Property Assessment Study Weld County This Final Report presents the results of Thos. Y. Pickett & Company, Inc. 's comparison study of as- sessed values to qualified sales, the associated pro- cedural verifications, and the required analysis on the other specified lasses and/or subclasses of property in Weld County, Colorado. This study was conducted pursuant to Colorado Revised Statutes Sections 39-1-104, governing valuation for assess- ment. Table of Contents INTRODUCTION 1 SUMMARY RESULTS OF SOLD PARCEL ANALYSIS 2 Summary Results of Sold Parcel Analysis 3 Summary Results Of Sold Parcels by Economic Area 3 AGRICULTURAL LAND STUDY 5 AGRICULTURAL OUTBUILDING AND RESIDENCE STUDY 6 PERSONAL PROPERTY STUDY 6 SALES VERIFICATION 6 ECONOMIC AREA EVALUATION 7 SUBDIVISION DISCOUNTING 7 NATURAL RESOURCE STUDY 7 Earth or Stone Procedures 8 Producing Gas Procedures 8 Producing Oil Procedures 8 Non Producing Patented Mining Claims Procedures 9 APPENDICES 11 1999 Property Assessment Study Weld County Introduction Thos. Y. Pickett & Company, Inc., has concluded the Property As- sessment Study for each of the 63 counties within the State of Colorado. The study was conducted pursuant to provisions of the Constitution of Colorado and the Colorado Revised Statutes [CRS] Sections 39-1-104, governing valuation for assessment. The funda- mental objective of the 1999 study was to ascertain that each county assessor complied with Colorado's mandated guidelines in valuing all applicable classes of property. By addressing the research through a ratio study and the associ- ated statistical analysis, Thos. Y. Pickett & Company, Inc., compared assessed values to qualified sales transactions within Weld County. When qualified sales did not meet sample size requirements, ap- praisal ratios were calculated. The prevailing level of ratio (or global level of assessment), measured by its median value, and the vari- ability of the ratio, measured by the coefficient of dispersion (COD), were then compared to the benchmarks established by the Colorado State Board of Equalization. When individual parcel ratios for a particular property class are arrayed by numerical value, the value of the ratio that lies in the middle of the array is defined as the median ratio, which is a meas- ure of central tendency (half of the ratios are greater than the me- dian ratio and half are less). A parcel appraised at its market value will have a ratio value of 1.00. The coefficient of dispersion is the 1999 Weld County 1 measure of an individual parcel ratio deviation from the median. The deviation indicates how uniformly the assessor values parcels. The Colorado State Board of Equalization (SBOE) has established the following median standards that all county assessors are re- quired to achieve: PROPERTY CLASS MEDIAN COD t. Vacant Land 0.95 to 1.05 20.99 Flesidential 0.95 to 1.05 15.99 Commercial/Industrial 0.95 to 1.05 20.99 Summary Results of Sold Parcel Analysis This report presents the analysis and associated conclusions with regard to property valuations within Weld County for the 1999 tax year. By law, these valuations are based on the tax status date of June 30, 1998. The results of the analysis are summarized in the tables below, "Summary Results of Sold Parcel Analysis," and "Summary Results of Sold Parcel Analysis by Economic Area" (if applicable). The complete analysis, including frequency distributions of ratios by class, plots of 1999 assessed value versus the sales price, ratio results, and stratifi- cation of results in single-family class is appended to this report. 2 Thos. Y. Pickett&Company, Inc. Summary Results of Sold Parcel Analysis PROPERTY QUALIFIED OF UNWEIGHTED LOWER 95% UPPER 95% COEFFICIENT GLASS QUALIFIED MEDIAN CONFIDENCE CONFIDENCE OF SALES RATIO LIMIT r LIMIT DISPERSION commercial 95 100.00 100.00 100.00 3.34 . ..and:... Industrial Condominium N/A N/A N/A N/A N/A 97.72 97.37 97.96 7.07 Single Family 3508 Vacant Land 782 100.00 100.00 100.00 7.90 Summary Results Of Sold Parcels by Economic Area Economic Qualified Median Ratio Lower 95% 2 Upper 95%; Coefficient Area Sales Confidence Confidence : of ,`: Limit L '`''Limit 'Dispersion 1 248 96.35 95.03 98.13 7.08 15 278 98.36 97.88 98.94 5.13 16 96 98.21 92.92 99.92 7.78 17 72 97.58 93.60 101.66 10.09 19 298 100.44 99.26 101.59 7.68 2 211 95.92 94.87 96.88 6.98 21 191 99.18 97.69 100.30 7.72 22 361 97.21 96.30 98.10 5.39 23 266 95.95 94.84 97.22 7.84 28 110 99.21 97.72 101.16 8.67 1999 Weld County 3 Economic Qualified Median Ratio Lower 95% Upper95% `.Coefficient Area - Sales Confidence Confidence of Limit Limit ' ` Dispersion 29 103 98.03 95.62 101.54 10.83 3 291 97.91 97.28 98.60 5.79 30 39 97.98 86.73 101.82 .13.64 43 80 96.70 94.72 99.23 8.58 45 331 95.74 94.90 96.27 7.15 5 149 100.03 98.66 102.00 7.10 6 304 97.52 96.77 98.23 4.91 8 80 98.93 95.14 101.76 6.85 Conclusions The sales ratio analysis for the property classes analyzed in Weld County indicates that the median ratios and their associated coefficients of dispersion are within the benchmarks established by the SBOE. No significant differences between the change in assessed value for sold parcels and the change in assessed value for comparable unsold parcels in any classes were identified. Recommendations None. 4 Thos. Y. Pic:kett& Company, Inc. Agricultural Land Study Land Class Acres Total Actual Value Per Acre Ratio Value Irrigated Farm 379,014 180,889,388 477.26 .99 Dry Farm 573,380 38,924,418 67.89 1.00 Meadow Hay 18,882 2,387,257 126.43 1.00* Grazing 1,045,171 14,469,877 13.84 1.00 Waste 16,982 99,345 5.85 1.00 Total 2,033,429 236,770,285 116.44 N/A * Yield based on local producer's data Findings • Aerial photos from the county ASCS (now called Farm Service Agency) office and soil maps in the SCS (now called the Natural Resources Conservation Service) Soil Survey for the county were the basic tools in the land classification. • Aerial photos in the county ASCS (now called Farm Service Agency) office are used as necessary, but are not in the Asses- sor's office. • The land classification includes adequate detail to accurately re- flect the productivity and profitability of individual parcels. • Grazing land is appropriately classified by carrying capacity with the aid of SCS Range Site Maps and Range Site Descriptions. • The crop rotation used should include corn for grain plus the corn for silage acreage. Adding in the corn silage would change the rotation from 60% corn and 40% alfalfa to 67% corn and 33% alfalfa. Lease terms accurately reflect land use in the county. • Production areas are established within the county. • Crop yields as a percentage of the ten-year county average re- ported by the Colorado Agricultural Statistics Service as: Irrigated Corn 100%, Irrigate Alfalfa 98%, and Dry land Wheat 100%. • Commodity prices, expense items, and capitalization rate speci- fied by the DPT were properly used. 1999 Weld County 5 • The pumping cost formula, as specified by DPT, is used incorpo- rating local electric costs, well and system costs, depth, and pumping pressure. • A ten-year average of local figures documents the crop expenses. • One percent: of the different land uses were physically inspected. Several of the flood-irrigated parcels that were inspected now have pivot sprinkler systems and the assessments are based on flood irrigated land. The assessments should be based on the sprinkler irrigated land formula. Suggestions The acres of corn for grain and corn for silage should be added together to develop the correct corn acreage in the crop rotation. Lands that have been changed from flood irrigation to sprinkler irrigation should be classified and assessed as sprinkler irrigated lands. Lands converted from flood to sprinkler irrigation should be reviewed and sprinkler irrigated land assessment formula used. Recommendations None Agricultural Outbuilding and Residence Study Agricultural outbuildings were exempt in the 1999 study. Personal Property Study The Personal Property Study was omitted in the 1999 study. Sales Verification Weld County maintains master sales, verified sales and qualified sales lists. Lists are maintained on a continuous basis. The verifica- 6 Thos. Y. Pickett & Company, Inc. tion process of all sales supplemented with a letter or phone call when TD 1000s are incomplete. The sales list development evaluation includes a random sample of qualified and unqualified sales pursuant to State requirements. Vacant land, single family and commercial sales fall within accepted requirements. Economic Area Evaluation Weld County has identified the variables which influence property values of specific neighborhoods and has adequately documented the conclusions reached. The County has also mapped the economic areas and can readily identify the economic area for each property. Subdivision Discounting Weld County has developed marketing areas for vacant land parcels and has defined these areas by divisions and filings. Questionnaires were mailed by the County to subdividers to gather information necessary for discounting. The County has documented its discounting procedures on each subdivision as well as the development of its discount rate of 10.50 percent. Subdivided land with improvements and vacant lots in subdivisions where at least 80% of the lots have been sold were appraised at market value, with the exception of one subdivision, which was discounted. In addition, the sellout period in one subdivision was calculated incorrectly. Recommendations Review ARL VOL 3, Sec IV, Valuation of Vacant Land Present Worth for correct procedures. Natural Resource Study Thos. Y. Pickett & Company, Inc., conducted a study in Weld County that included various relevant natural resource elements. 1999 Weld County 7 Earth or Stone Procedures The Colorado Revised Statutes, Article 39, Section 6, and the ARL, Volume 3, provide the guidelines in appraising natural resource property. While all three approaches should be considered, the income approach is most widely used in the valuation of earth or stone. Production and life of the leases were provided by the operator. There are no other sources available to document production. The economic location factor was applied to the gross tons extracted to determine the landlord's royalty. The landlord's royalty was multiplied by a recommended Hoskold Factor to find the actual value. The Hoskold Factor was calculated using the life of the reserves. Conclusions The guidelines set forth by the natural resource valuation procedures were followed in determining these values. Producing Gas Procedures The Colorado Revised Statutes, Article 39, Section 7, and the ARL, Volume 3, provide the guidelines in appraising gas property. The total MCF of gas are multiplied by the current average price. All government royalty is deducted from the gross value sold to determine actual value. Conclusions The correct appraisal procedures were used in valuing gas production. Producing Oil Procedures The Colorado Revised Statutes, Article 39, Section 7, and the ARL, Volume :3, provide the guidelines in appraising oil property. The total barrels of oil are multiplied by the current average field price. All government royalty is deducted from the gross value sold to determine actual value. 8 Thos. Y. Pickett&Company, Inc. Conclusions The correct appraisal procedures were used in valuing oil production. Non Producing Patented Mining Claims Procedures In accordance with the guidelines established in ARL, Volume 3, the market and income approaches to value were considered. The primary use of property established the parameters used in the valuation process. Conclusions The correct appraisal procedures were used in valuing non- producing patented mining claims. 1999 Weld County 9 Appendices Documentation of Statistical Analysis 1999 Weld County 11 Appendix A Sales Ratio Analysis N Q N N n N w N N N N EL, J U H N ¢ Y W a J O o a N O • >- • w cn W L O J .1 Q N N 3 U w O LL Q C r 6 N N - U d 0 0 0 0 CC S Y b A F F N Cr O E 0) O 0 0 E F LL U 0 Q H O 0 ti O ¢ ✓ J U F W a • Ncrl 2 3 • m 2 0 d O N a � N J F • O J •• • E N_ In U J '- V U ry W as O N E Lai a N O in N ! N I N N d • d 100 N Y 10 N G N 0 0 N 0 0• 0 CO 0 n 0 •• O • • CO - N •d J •• O >- • a F- m • 0- 0 0 ' CC • 0 a • o • > • m N m J N N 3 O W 0 O HQ C Q 0 N < O O Y U • • • • • 0 C J Y NO m 0 0 0 N 6 D E E 0 0 E C LL U 0 y II CC 0 O • f W O 3 • m • lee • en O0 2 O CO O S • W ~ • O 0• 1- • O • 1 L O_ ( W 0 00 0 111 LL O N 0 0 N O N 0 a, u 1 1 I 6 0 n O O O O O O 03 10 N < t7 N Ca co Ca N m U, 10 m g V V IA N H 0 � U a 0 O cc a N 6 } Q7 U _ L • W U, 1 Q LC) a, U O W O Q .Wr d ✓ J O in m o • J E 0 a in _ } O ti CO CD g ot Q G O OLL n faC •• O O U iy J a CC m M W n O a U z a O o O m Y 2 N in U (O E V O >- U, y O W f K W U, N N m U a R V C i U -� 1 1 1 L 0) O O C' O 0 N to u1 e 0 0 N 0 0 0 0 O n 0 0 0 0 0 0 4 J T 0 0 En Y F Q U W d O O 0 a O N m Y m 0 L W C' J -0 - CU 0 N 3 0 W 0 •• O Y Q C J O 0 0 v Q J E • • • E J O J O U .I C C W 8 2 T E • F 0 O C 0 0 C CD E O 0 0 U • F U Q 0 0 0 2 H J R CU Q ; O 6 0 ea LL u ' • ' n 0 al CO a 2 0 CO 0 F 0 J CO CC `I 0 0 CC o 0 C 0 0 R Ill 0 m O 0 E CC ~ LL 0 N 0 O O O 0 N 0 0 C aa U I I I 1 I CU 0 0 0 0 0 0 O 0 0- 0 1" to 0 Q CO N OI CO U) N J fL [) •' > N •� F Y Q 0 � 0 0 • d • N .. • N C > • C CO • 4-. V N W Q! • • • sC • • • N m CO • • • w ♦ • W O LL Q .r S C J O T d • 0 W O • R O U E lE W - z > m I- z w In Z y cc 0 o E 0 o c 1- 411C O O If 2 4-+ J U 4,44 wa r- W a 4a W L LL • N O H m N N Z C O f` 0 • O CO Q F N — COcol N O a ›- 2 W y W "1'1) 4 01 Q LL V N N C A C 61 O 0 0 o a 40 O O N 0 I Ot I 0 0 0 0 cn w en .a 4, 0' 0 a1 }CC V Y r V O. W a OCC 0 0. O. >- (.0 W • • 0 d N In a W O 6-4 0 Q c .+ ¢ • a, J O > • O 4 J -4 • 7 0 40 • • h O U E J W V V 2 T a1 r r ci • 0 (Y l7 0 OM E 0 0 c • •+ CC O O • .--. J O ♦' I- W a • 0 m Q¢ • Q N z � N•W O a+ y rn a • Z • • = O 0 • • m 0 • • • • • 7 m C (r 40 O y N N - 0 4O T U CO 2 N • 0 40 •Ey W ft- Q Il. 0 N O tOi 0 O a, a, A a, U 1 1 4 } a, O 0 0 0 U) U) ca Ch 4.0 N. U) Cr) In U I() Ul CC H C a O CC • aL • • N O } • • w O, Cr, O • . • w O • O w Q O N Cu Q J O E O O C 1 O U tp H =• >- 'r 1pa F C N CC D z Io O y c rn O ) E O O ro c- 0 Q O U A cr J d H w 7 N c U, • 3 IA L L • N O ~ ry N Z • OM • n O O J ' CO r-. F • N U • N ✓ • CC O • ? O 02 t° w v) y O to € w I CC ts- U) N N N 0) N a n C c y O o O 0 IL (7 N CO O 0 N 0 0) O CO 0 N LU I LI) O N aI 4 '. J T U •)N O . } v I- ^ x K U W a O • cc o. co CI N L w CC `. Q • • O a C0 • • N 3 O • ' w O .-• O W Q .-. cr C C J O O a' Q .I a E O O C O U al ' w - r 7. d° t = Y •' U Z H H U O U a,O O CC O UE O O ro W U ' d •• If O O O rr .. _r a I- W Q O T cc Cr, z a O a, n Z O 1.•o co o I- O co K ; C a Cl) • $• 0 E i N. o U • I U I N Z w 00 (O E w •_ U- 0CC >n O v O 17 a N 0 v 0, C LI -_--___t I I ClL. 0 O 0 0 a. P co 04 a o 0 O O N 0 4 O II O T O O O O I N O 0 O -O 0 0 N O O O -o O O I N o O O 0 in W O d -4 C T Nia a CO W LL O V V 0 N J d O J a OO O O O O n - v Or N = a 0 i 1 f S N L O 2 J n CI O O m O 3 W OO w O F n O 6 0z 0 In CU n 0 W C N o W E W II a OJ a a W VC 0 El W ; M 0 0 a O O N 0 ti• O II d 0 d C O O W E O W L a N 2 O V CO -cc CO) O CO J Q 0 A 0 0 UO ^ O J ) 0- OO in a t'F— —O d 7 6 W -. W Z N n O d N J W O J O N 2 a O N d 1 W N Y <a co m ccC a O O E m a o m O m- o 1 OO N Z- 0 d A O d co E O J O a o O O 0 N O O O O O a o m a m a o O 0 o a o m o m in m 0 m 0 t m :s .e a —o I I 1 I I 1 O O O a O O o o O O O O O O O O O CO O O m < O O = d 0 4- a I- '-4 O 2 a J 4 > a J J W S I.C. 0 6 G a r '~ O 0 _0 < 0 0 CV OD 0 0 0 < to N 0 0 0 0 N < 0 0 < 0 < N < N < CO < W J 0 CO 0 0 0 0 w < N ti U co 0 < O O to 0 o a C' w o o < O 2 < O ., f 2 N 0 C O 0 2 J 0 < 4 CO 0' O 0 0 3 - < N ,U., z 0 << O Z 0 LU 0j d 00 r, c < O W O 11 < O d E Co 0 C , < 0 m m LLI 0 CO J LU 0 0 W 3 0 o m < r m 0 c m C ii 0 ~ C 0 C' < E N 0- d d w J Z 0 ♦. m - CO < 0 N < m p > < W < 0 0 O < —O w 0 r CO 0 0 0CC 0 J F 2 U < < F W Ca> W W Z W < .0 Ill O o Q M m < C < 0 N d > 0 0 w r CO CO 0 CO0 < 0 m 0 6 < C < 0 < 0 0) O N y m m a CI 0 03 .o-, < LL a m [1) O 0 < m In en m 0 y 0 w 0 CO 00 < 0 0 U ,- al < 0 0 0 W 0 W < < 2 CO < 0 0 Q 0 O 0 04 < < 0 < U < OQ Q O 0 O 0 0 1 CO 0 0 0 0 I < 0 0 0 0 0 0 0 0 0 0 0 0 00 0 0 00 00 0 0 a W 0 in O N 0 N 0 0 3 0 0 F' < H ' O Z < J E > < J J W S LL 0 C 6 < ti •+ 0 0 0 —0 0 0 0 a Q Q O O O a O ¢ 1 ¢ O ¢¢ ¢ 6 o ¢ 0 a v 6 6 a a m ¢ * a m r o w O J o m 6 m QQ Q QQ Q < N T co N w m • . Q a Y LL a m o « a ¢ Q 7.1 U Q 6 U 0 O CO ¢ m Q <m OW O O 6 Qm a m 6 U 0 H C N m Q Q m m ¢ Q 0 m C OJ II Q 6 Q ¢ Q Q l7 Q. O O m 6 LL 0 co CO 3 W - 0 0 CO w 0 6 6 a 3 O. Z. a 6 6 C 0 W l 6 W 0 O 6 LL 0 0 c COm 6 0 U CO CO W 00 W E W O m r:00 0o3 m 0 J O W U 0 co N LU 3 LL Q 6 Q Lt. U CO N J w N p m m LL 6 6 • O 0 N 6 m LL m m N m I-- m 0- m 0 '0 LL W W O_ Z F O LL J ¢ U 0 m m N cocc co- Q tit Q > L ¢ U W O 0 J 0 m 0 = 0 6 0 co W U O a 6 ¢ 6 m _I U Q 6 0 w J } a ti F 6 m O LL O m Q d CO 0 N > w W .-I 0 LL o a w Q a Q N U O Q Q m 0 N W ) U 0 J O 0 O E. Q m 0 0 2 m u a'l N 0 m 6 Q W N N O Q 6 a O O 0 6 ¢ a N O 6 0 E O co Y N Y U O co J N W m N O 6 m O N W LL y 0 N 2 m m 0 ONN N 0 CO ' E 0 Q 0 N N N F J W U } N N ¢J N N m LUNNLLI Q LL 0 N 2 Q0 ¢4 0 N Y 0 O N X 03 0 J N N N O 0 O O N N O O ¢ 6 LL N 3 6 in N 0 N N N 6 a N 6 a N t m 6 W m O 0 O m Q O a O O 0 m O 6 m o m a in m m m a. Q O N a a O 0 0 0 o O 0 0 0 0 00 0 0 '^ O 0 O 0 O 0 a m P 0 N 0 0 0 2 2 J F Q f ti 0 Z a J i > 6 J 0 W S LL O m m Q F ti O m a a W i- 0 N —O ^ a 0 O 0 6 0 O O O N 0 O O O O O N O O O O 0 Cl O O O O 0 N C 0 0 O 0 O CO Cl W J 6 CO 0 O 0 W 0 0 ^ N Cl J d 6 0 J O O .0 0 I C 0 0 C Ia i ~ CC O Cl 0 C J 11 N 0 O O U- O 0 w - w 3 U Y O .. F- a o a o w 0 o 0 a v w n 0. e C 0 6 CO co W W O J 0 1116 a -.-0 N re 0 co C 0 C O 0F 111 b 0 Ln LL C J 2 .Ei 0 - C co no j 6 O w Oco O U .U. a —O C OL. J Y C P a ti F ty W Z 6 o o W o 0 ¢ a 6 0 0 a O 0 a 6 6 O 0 0 C N a i P 0 6 ✓ m m O 4-• 0 0 0. a < 0 o m a w E 0 O 0. 6 6 Q 0 0 6 0 0 a 0 a a a a a 2 0 0 0 2 QO a 0 U 0 0 C W a 0 0 6Q6 CO 0 U 0 O 0 6 S 7 0 0 J = = 0 LL 0 0 0 6 2 6 0 O 0 C W < 0 6 C LL 6 0 CO 2 N < 6 N CO N 6 a N 0- N a W N N a 0 N U 0 N N 0 W I 0 C Q 6 6 1 N a D 0 0 O 4 1 I 1 I 1—J m C 0 0 0 0 0 0 b C O O O O O o Cl Cl Ln N O N W 0 00 269p— 6 1- ^ O 2 a J E J 6 J J W E LL O C C 6 h ^ 0 2 I' o Q W W 2 0 0 0 0 U f W o a a C -1 W d W LL 6 LL O 0 CO 0 N F a 2 0 0 ' N N CC 2 C C) 0 0 0 aC .. .- F.- 2 0 2 a N• ~ UJ m s2 f) 0 0 0 _ 0) N In N 0 01 CC 01 0 W CC J W C) 0 0 0 d C -- - d LL U' J 2 U' Cl) O a 1- 0 2 J Z W O Z U a W or ~ l - 0 P CO O 0 Z 0 N 0 0 d CC J 0 O .- 0 N Z W W CO 0 m rn 0 8 _I 2 0 an o a en m U 0 0 O q F_ O cc he e_.o o a O CV N Ir-- < 2 -I U' 2 CU N N - 00 CO U C W Q 0 N 0 0 ai o 0 S 0 0100) 0) 3 I-• N a a 1- C 2 7 • O O I- O a o 2 «. O J W 0 C a 0 W C') 0 0 0 .- d - Z LLw CCV rr m 0 -+ d n+ O W o U w 0 LL E - J 0 CO a F 0 co Z O a — W Z J -+ 0 O LL o n U J an F a 0 0 0 O 2 a 0 2 5 O N 0 O ~ W U O O CC W J C 0 0 0 0 O Cc ti. .- - U z = a LL O O F 0 2 W U 0 i C 0 C an O c. N LL E 0 tn to 2 F 0 0 a 0 N — a0 0 r O 4 2 0 m C 0 0 0 0 ry a C J Z O O )` O E 0 W C 0 0 0 0 F F• 0 LL O a J 2 W C O 2 0 Z a 0 2 Q 0 J ._ r 0 W < J 0 OI 00 . . _ LL LL 0 II 0 -- U.1 a 0 co N II 0 • Q C iT N U, N n 0 0 O 0 C) < T J ~ 0 E>C N .C J A N W 0 ^ 0 J b E O M C O . O ti c d E o rn ry E C NO O 0 O Cl Cl) > P J a O F N F O O . 0 0 0 O O o O 0 O 0 0 0 0 0 0 0 O 0 0 0 0 0 C) .- O ' O O O O O 0 0 P 0 T O N .- O W W 2 0000000000000000000000 .00000000000001000000000000 0 a c 0 o ¢ J W a. w LL ¢ U. 0 • P ^ b 0 0 0 0 0 b O F .- .- P F 0 — — P a F ^ or P 0 0 0 N 0 0. 0 — C) C) b 0 b N 0 0 0 0 0) 0 F el S Z 0 CO J N F O C) co co 0 N _ .' co 0 0 N .- 0 or 10 0 C) 0 CO VD or 0 0 0 _ 0 0 .- co P _ N 0 or O of C) N F 6 H . W )- C) O CO 0 _ O C) N O N N M C) N 0 0 0 M1 0 0 OI 0 0 0 0 0 F CO 0 0 F 0 0 F F co O O P — to 0 F a 6 2 6 O O 1 OI O O O 0 0 0 0 0 0 0 0 0 0 OI 0 0 0 O OI 01 0 O) 0 0 0 OI 0 0 Oi F F 0 0 0 0 .- 0 0 0 0 0 01 0 a ¢ I 2 O 2 6 ce M W in 2 0 or F CO N O 0 Of N N P CO F 0 CO 0 CO 0 N 0 F O O .- C. 0 P ^ or P F C) O 0 O N 0 co O .- b 0 w 0 N a 0 2 .- 0 N P 00 031•00N. O CO b 0 0 0 O N CO 0 0 O) 0 0 0 C) F P 0 b 0 .- 0 P N 0 0 0 O 0 N 0 10 ¢ J O P C) O Cr) 0 O C) O N 0 0 P N F a N 0 0 0 _ 0 0 0 0 0 N _ 0 0 0 0 0 0 0 or F OI 0 0 0 O 0 N 0 0 co 0 w w 000010000000000000000000) 010000) 0) 000. 0) F030000) .- 000000, 0 a LL 0 J 2 0 0 6 0 CO F 2• z 02 a J o▪ r E1 W In 0 2 O F 0 0 0 O 0 0 0 a O 0 or 0 • 0 CO o 0 0 N '0 N P 0) N C) N 0 N CO F 0 C) 0 N F F P 0 F 0 0 0 0 F co W O) 2 0 CI) N b 0 0 CO0 0) 0 CO0 a C) P N N N 0 ID 0 0 or 0 0 0 or 0 P P 0 CO N P N 0 0 CO 0 F o O 0 — Tim Ur . . . . . . . • . . . . • . . . . . - - . . . . . . . Z CC J U' 0 a 0 O o 0 CO N 0 0 0 F 0 0 or P 0 0 CO F 0 co N F in 0 N. F 0 CO F F or 0 N 0 0 0 0 N co 0 or W W W 0 0 0 0 CO0 0 0 0 O 0 O) 0 0 0 0 0 0 0 01 01 0 OP 0 0 O 0 0 0 ) 01 OI COO 0 a 01 0 CO F F 0 0 0 0 0 0 0 0 0 0 OI O LL▪ J Z 0 A Z O a O U U 4. a• W O t- 0 0 a O F O CO 0 0 0 0 in 0 0 0 F 0 0 C) 0 0 N 01 F ICI O 0 F p1 O CO O P 0 0 N C) N 0 C) O CO or O or or CO 0 0 0 ti O U' 2 C) P 0 0 N 0 0 0 0 CO F N 01) C) 0 b 0 0 N — 0 d N 0 0 0 0 O P P .- 0 01 .- 0 or F co 0 P O ..... 0 co co N cc y ¢ ¢ W 6 — P is 0 .0 O C) N 0 N N N . N N CO 0 0 F 0 01 N 0 0 CO 01 0 0 F 0 0 CO F 0 ^ N b O 0 0 O 0 0 b N 0 or 0 0 0 2 ¢ 000100000000000001000100O0) 000) 00010. 00011, 03000010000000) 0 01 0 0 0 J O 0 0 0 0 0 0 0 0 O 0 OI 0 0 0 0 0 0 0 O 0 0 01 0 0 0 F 0 0 0 0 0) 0 0 0 0 0 0 01 0 60 0 0. o 0 I- i a I- 2 C 2 I- 0 J Z .. 2 O w 0 3 U -. ¢ 0 0 P O - O ID 0 - CO b ^ .- P 01 0 0 0 01 CO 0 N 01 P F 17 0 P 0 0 O IC1 O 0 O O N F P O N - d N 01 0 O O W .. 0 0 0 P O 0 F O or N CO P ._ _ 0 .- F 0 0 0 N C) 0 0 0 r, 0 0 .- _ 01 0 0 N 0 0 _ N O O C1 or co cv - O 0 .. Q. O J LL N 0 C) O O N O b (V N N N N N F 0 F O h 10 F 0 N 0 O 0 co. co F F P 0 O 01 O a N 01 F O b 10 10 F co N Z W LL • 6 3 w 0 0 O - 2 O LL n O r. 0 00 O 0 W J .. 0 6 2 I- CO O O � w 1100 v. a O 0 O CO b b Co) F F ... 0 or N 0 01 0 0 0 N 0 or O N C) F 0 N b 0 0 0) 0 0 0 0 C) 0 co J F Oa 2 ¢ . 0 0 b 0 0 N 0 01 0 P . c, 0 0 0 0 N , N .- 0 b CO N N 0 N F 0 0 C) O 0 O 01 10 0 ¢ J 2 0 0 0 0I N P or 0 CO 0 0 0 01 .-' .- 0 0 co F _ 0 .- 01 0 N co N C) d 0 O P N 0 v1 O Q w a 0 0 0 0 0 0 0 0 a 0 0 0 a a o O a O a a 0 o a 0 0 0) o a O ! 0 0 0 01 0 0 m 0 2 O 0. LL .0 . . . . . _ _ '. .- .- O 0 7 2 w 0 2 LL w 0 0 2 2 0 0 ,— or 0 2co O u. 0 0 E O or 0 ~ 6 0 O O NCOCOco P C) N N O N O N P F- a 2 ¢ 0 0 0 N 0 C7 d N F 0 0 0 0 b N 0 0 C) 0 F 0 N N F 0 0 F .-- or F F O 0 - O .- T ¢ J 2 01 O 0 0) 0 0 O N F O . 0 r, N C) 01 P F W or N in F 0 d 0 0 0 0 N 0) 0 O N 0 O 01 N O LU 6 01 O 0 0 01 0 0 0 0 0 0 0 CO 0 a1 01 0 0) 0 0 0 7 0 0 CO 0) 0 0 0 0 0) 01 O 0 P 0 CO 0 a O• O a: 0 E -J20 O 0 2 • U I- 6 ¢ 2 2 0 O 0 0 0 0 0 CO 0 0) CO P In 0 0 0 .- CO P N• 0 0 0 o) 0 0 P co N co 0 a b 0 0 0 or O 0) 0 0 n 0 6 6 O O O. O N F O V P 0 N ^ 0 N O 0 N C) N 0 P O) r. N 0 N 0 0 0 F F 0 0 0 .- 0 P 0 d O CO 0 0 0 O CO O▪ O F 0 0 0 0 .- O .D — .' 0 0 P 0 0 CO 0 F O 0 0 h b 0) 0 F F CO 0 O 0 0 0 F F 0 0 0 0 _ or o N O CI W W6 O 0 O 01 O O O O O O O O 0 0 0 0 0 CO 0 0 0 0 0 0 0 0 0 a 0 0 0 0 0 F 0 0 O O O 0 O O 0 O O 0 O 2 2 ¢ .- .- Iv LL CO O .. W P P' 0 '- N " _ 0 F 0 OI F _ F 0 0 0 0 N 0 _ •-• 0- 0 0 C) _ 0 0 _ 0 or 0 N P — P P .- N C) in 0 P 0 Cn ... -1 Q '. 0 - P - P F N P F 0 F 0 .- 01 b CO 0 01 C7 0 0 d O 0 N N C) O N C) 10 • N N NN .- MN .- .- 01 M - 0 C) O J CO 2 O U 2 0 w N O O N N d 0 N d 0 0 0 0 F p1 w a O O O O O F Y 0 in 0 0 F F F 10 10 F 01 N N co co 01 O b 0 O O O 0 b 01 O CM N . . . N N N N C) C7 P P 0 0 0 . . . .. . . . . CI j N N N .> ._I ti.-1 .YT.. .. F. 1-. .-I .>• ti T a..-I ti.>•Ce.4 atI C J 7 CI C O C C j = E 0 = 0 0 0 0 '6 6 .. 'E E .. .. E s E 'C C C C O C C C C C C C C Cr H 1C1 1Ci 1C1 M O J O ^ 7 E en E E E al E E E E E E E E E Ca E M C C C a C a a a C a w w w w w w w w .10- w w ni N y0- « .may .Oy .0-1 .-. a w CO u r .. may ~. .. .4 C C. Ci Ci H •F y- .F w .F ..1 .4 .-I .-1 .. ti -Vi .�. 0. 6 al .+ ✓ .. .+ ✓ a 0 5 6 0 0 0 0 0 E N O 0 0 d . EI d W 0 .0 .m-I d .0'I .Vi �-1 ~ •' C ~ c ~ C C C C LLN E Ei • E 0 0 0 0 0 00 0 O CO 0)H .Y .Y d 0) 0 01 0.0 .Y 01 d CT CP E A I! a a a RI Elena O a U a E E E E E E C C C C C C C C C C C C C C C C C C C C C C C C C C O U O U V 0 0 0 0 0 0 0 0 C1 0 0 0 0 0 0 0 0 0 0 0 0 0 '.. .'1 V a 0 00 V 0 V 0 0 0 V 0 0 0 0 CO co CO CO CO 0 CO co) 0 0 co 0 0 0 0 0 > > > > > > > > > > > > > > In a W 0 2 0 0 0 0 0 O 1- W Q5w a W IL Cr LL 0 0 O 0 N 0 2 Z O n. 0 0 0 0 H W 1- 0 O OI O N C 2 < O O 0 OI 0 < 2 O Z Q 8 ti W m s Coo O a W CC J• W N 0 0 0 0 a . ¢ 6 LL 0 J 2 U' O 6 U CO I- 3 Z O 2 J a dP - W W 0 2 0 0 0 CI 0 o 0 2 .0 O < 0 0 Z W ¢ J U' CO O N 1` CO d O LU W w 0 0 0 00 -v LL O +' 2 J 2 'U cn O 0 < U 0 8 '^ N 0 m W F0 0 ~Q o C'1 o C F a a+ r — O O t- 0 0 Cr W Z W 2 2 C 00 01 0 0 C • O 0 C O 3 > C Q I- ¢ 2 2 J I-- O 2 0 2 r O• 0 H C N O C O C d 0 O IllEL C 0 CO CO VI E 0 J ti 2 ttl LL CO O V OI N in < 3 LL ry N J W o ^ - 2 0 V 0 O ti 0 LL O 0 U W E - J 0 Q I' CO O O ri LI• W F- evl a J OCi I� 1 2 O O I. O W H J 2• < W C 0 0 0 C W J 0- '".i 0 0 L LL O a J Z W = LL▪ W 0 2 0 2 2 0 0 O F U 8 O C 0 LL Z E o 0 0 0 or ~ M C C 0 0 0 0 CO o o r- c ^ 0 C J 2 0 0 CO C C Q y 0 0 0 O LL 0 w 0 J 2 W a 0 2 F 0 C CC ¢ Q_ O 0 00 00 0 0 Iii CO c O < 0 0 0 0 2 0 2 ¢ LL U. 0 I O I O J VI 0 0 P C. II J • Q Q •- 11 C 2 C i P• 0 0 2 O 2 Q 0 W 0 CC CI to Ln W ¢ 0 p O C It V V a 9 Z CC m cifC n ct F- C .-I .+ rl .-I Cr C W M LL C en co C CrEl cart U CI 0 0 V 2 N CO N al cf > > > > > O -J 6 0 1-▪ 0 0 0 0 W W 2 0 0 0 0 0 0 F w 5 6 w ^ f 0. w LL Cr LL O 0 0 01 0 N F Q O 0 — 0' < N CC 2 < et 00 0 0 0 0 6 Cr .- 2 0 2 Q dP F w 0 1+ 2 0 r- N O O O .2 N O 0 0 N 6 J 0 0 OI 0 0 .- 0. w O1 01 0 0 0 C LL 0 J z 0 O 6 CO 0 H 2 J 2 ZZ W 0 U OP F W W 0 2 0 O I0 O 1- 0 LL - W J W 0, 0 0 0 OI 0 0LLo O J O Q dt U 0 0 o 0 O F 0 W CD .. Q aF C CC 0 0 6 2 0 00r' 0 < Q O 2 W Q at 0 0 0 0 CT 0 U S C 0 0 0 0 0 0 0ai - 6 3 F 6 F- CC 2 J O 2 U - 0 z 0 W CO E O J r. ¢ 0 0 0 < a 40 3 0 LLI 0- 0 O o J CO 0 ' , LL 0 01 Ia 1O 0 O - z v o .. Ill 0 m O 0 U W U 0 E - J O Q 4-' F CO 5 0 2 • I--. O O Ea J L. LL JP F F w .. 0 r. 6 a 01 0 0 0 m 0 J 0 2 C n N 0 N 0 2 Q W 0. 6 J $ O N ID 0 O 0 0 w0 0 0 01 OI 0 LL IUi w a I.L. 0 00 00 P= 0 0 LU - 0 5 0 0 0 Cr ,r o CI O LL 0 E 2 0 0 O - F r. dP O F Q r- 0 17 0 CO D 0 01 2 0 n 0 10 0 0 0 6 Cr J 2 N 0 I. N Co V, W Q 01 0 T 0 0, E O^ O LL O F F J 2 W 6 0 2 Cr U a C 6 0 0 'W P 0 - 0 C 2 0 1- Cl 0 10 10 0 w 6 0 0 01 0 0 2 Cr o r• LL. w a r- 10 .- 0r CD IIII C) J J - 0 m o a a C) ' 6 Q r- 0 O n 0 II 0 CO 2 0 U" > w ti a - N (0 < 0 -i a Eames Y- 0 A IV O a- W Cr 0 w W Q C J N 0 L b 0 0 (.3 01 O1 01 0) 01 0. C3C0C 0 00 0 0 0 N. 4 O I- 0 0 0 0 W W Z 0 0 0 0 0 O H w .. Q ¢ ,- F ¢ J W w W LL C LL 0 n 1- - N N X 2 0 0 4 N m 0 ¢ 5 ¢ (D m 0 T 001 ¢ ¢ 2 O 2 a So -. LU in .. 5 .r O Of 0 m m s CV C) m CO 4 ¢ J▪ O 0 0 0 0 0 w w m o o m o w ¢ a- LL 0 J 2 m O < U CO H 3 2 J 0 Z Q UJ U N ~ ILI 3 m m O 0 0 2 0 5 4 CO m 0 O 'Si d 0 ¢ J 0 m m m m m 6.4 al W m m m m m LL ¢ 2 0 -I O O Y 0 a. � m 0 0 0 W 0 QQ ▪ C O Z O O N O N •4 0 0 W < H ✓ 2 J 6 LU < N- 0 0 0 0 = C 0 O 2 ¢ m 0 0 0 0 0 0 0 -- O Q d 3 F y- .1'C - = Z 2 0 I- O U 0 .w. ¢ O co N m O E 0 J o w m 0 IA m in a 3 LL co m m m m m - 2 W O m 0 .. 0 0 0 a) U 0 0 E w - J N 6 I- m 0 i Z o 0 0 of FL J F.W di F f a' U. N < .' N N 0 4 0 m 2 ¢ O m 0 0 0 U J .. • WD W Q m 0 0 m O J '� w - a 0 o u_ La o. z w o 2 = O 2 O O ti 0 U ...ir 8 O y N LL E a, 0 O ai k.. 0 i .~. Q 0 m m v 0 2 ¢ w 0 n O O R 2 ¢ J 2 N 0 I- N 0 Q 0 Cr, 0 0 0 0 Q E 0 0 z W N - 0 2 Q 0 C Q N m e ' n o 2< o m o . in m w s w ¢ 01 0 0 0r) CO 2 C LL LL 0 II o .. w Ia m o N 4 II CD J J I9 m m m r II O • < < N 0 N 0 N II N Z 0 N II m 0 > F J LL N m 4 m LL J w 0 > EESEE I- 0 015000 f W < w .. ` 1 J 0 0 0 0 0 2 U m o Of 01 O O. C C C C C .- i71010) 0101 J C D. W W Z 0 0 0 0 0 O F W CC J W O- W LL C IL O _ _ O CO N CO O O O la. < N F Q DI W F 0 0 0 0 0 C 5 Q 0) 00) 00 < 2 z o z < e F w O 5 m m N 0 5 m 3 m am O 0 m _ m J O 0 0 0 - 01 w w 0 01 0 0 01 a . c a U. g J 2 0 co O F 2 - J▪ 2 O 2 co < U JP F W 2 VI F. Z N O .- O m W 0 2 N < O . 0 y O „ - 6 J O Nap CO o r LL W W mm m m m N 0 0 LL O J 0 m U< O m O O O .F O F. W 0 Q ¢F¢ Z0 0 O m v n ar O �0 2 O < O 0 J ID a C t m O m O 0 O U 0 5 Q m IT 01 0 01 D. O O w F▪ >- < F C 2 J Z O Z D. O o U F O c 2 y o o re 0) N m < O E F V C 0 - CI• - O• 7 LL N co N- m m m - z a 00 F. O o m O 0 U LL as W O E - J 0 < H F CO 5 O Z D. W O O J W .-i O D. C 0 01 .. N N an 2 Q I11 O. C. J 2 n N N m 0 .-1 O O w C 0 0 0 0 0 -O a • IL w a u_ o OO Zr J z o 0 0 5 0 U 6 dP 0 C N LL N m E Z CO O O F J ` 00 F.F C N < .. v. V 0 0 5 c < m N m O N 2 a CC W J C m m m m m E o F LL o F F J Z W C 0 2 C O 2 C CI < m O O Io O O m Z O F m m N. m N w C 0010, 0101 2 C O .+ W N 0 O m 0 11 CO J O 0 0 O1 0 11 O C C N N N. m m 11 I(1 O J CO II O 2 O N W F CI O W J .. ,- N C 0 01 2 < C CO 2 T T T N• .-1 F ♦ -.1 .y .-. Y E E E E 0 F m CC m CO CO l 01 II) It D-ID W < J 0 N CYO 0 O • U O m CO O O C CCCCC N N 0 0 CO Appendix B Sold / Unsold Analysis o w J 0 C) 0 0 0 O 2 C) 0 O n 2 r O 0 0 0 O 0 N N 1� 0 N 0 N • 2 • q < 0 N 0 - J O H O W (/) 2 2 O 0 0 N 0 0 dP f 2 O ti < O N V C) O r O N 0 0 m CE J W 0 O N C.) N J N N N N R LL 0 J 2 0 0 2 CO 0 0 F f J 2 O W 0 0 0 O . 0 or N 2 O O O O Z 0 Q 0 •- 0 C) 0 0 0 I 0 N 0 - 0 ry 0 CC J LL < W 0 0 C.) N O• 0 O LL 0 O 0 J 20 _ so O 0 0 a - r In r " 0 ¢ Lu co 0 0 0 0 0 0 0' 0 0 o N- 0 w ¢ m 0 C) W < 0 2 2 CO is C <01 01 0) 3 O > 0) N M N - 2 N - 0) 2 < .- . ._. 0 O F 6 I.-. CO 0 CC 0 w Z 0 O 0 0 0 0 • W O O O O 01 0 CO CC 0 0) 2 < iN.0 0 0 N- U- CC — x O 01 0 f') 6 cc W a W J O IN 0 < 0 J0 O d LL O el A f9 H N > O 0 O 0 N 0 o a W J fA 0 0 W 2 2 Inc O 0 0 0 0 0 W 0 0 0 0 ¢ O N ~ Z P 0 N 0 2 0 0 2 Q N 0 0 0 • 0 2 I., 0 0 0 CC J O 6 W 07 N 0 (1 0 0 S • 0 N N N N Q IS. J 2 0 2 0 0 0 0 Q 0 W▪ 2 W 0 0 0 0 0 g 6 02 01 0) 0 0 0 0 O ¢ ' o n O n w x N .- 00 0 0 e 0 m O O CO 0 P < J > 0) - 0 0 fM 0 - 0 N 0 Q O LL W O LL W N O 0 N J N N N 0 J Q C) 2 < N 0 O .- Z 0 0 0 0 LL 6 0 0 0 01 > N ofC ID L N O CD O .- N 1 O N a 0 N N N 0 0 0 N 0 0 N N F- 0 0 0 0 O 0 II a N 0 A U 0 • a 0- 0 _ e v a> c O 0 0 L 0 N a a n n M L 0 N 0 C n n 0 0 G O 50 Z- O ' N J O 0 U 6 0 - U- ,- 0 n co O C 0 0 N 0 CO O 0 — V Z 00 0 0 U C 0 L 0 0 �� 0 0 a0 0 Cl _ 0 0 _N 0-L 0 0 C L F- W d W C N 0 0 O 0 3 W 3 O 0 0 aea CA Z Cr 0 W C N a r 0 0 O >: x g 0 a F L Y O O J 0 a co w 0 L O W CO 0 E n U. O ti W0 00 W Q I ¢ ▪ 0 0 C 0 0 0 0 W J 0 0 0 0 0 a 0 0 R 0. a >▪ a 6 0 -4 L < = cr 0 LIJ 1- 0 a▪ 0 d 0 c0 3 •co 0 0 0 Y L •.a E 'ti w 0 ¢ > . G. Li 0 0 0 W z W ¢ E > _ • 0 0 3 -- 0 - 0 0' '0 ✓ Z Q a .- - E L. • m 0) 0 r U F I JO 0 0. < a O 0 a a a) C N Q I• Q 0. 0 L) Q E 0 >N U • j m CO 0 3 r 'd 0 a 0 N O O O 2 C O C 11 W C 0 N a O y a It a W 0 0 a S 0 = F 0 Z 0 O Z Q F 0 0 W -I I- 0 0 ]: th N Cl W 0. 0 J. J F. 0 0 CO J 0 01 0 Z 0 0 0 1' C o - 0 Co LI N 1-- 0 f C, Y N 0 N F 0 a 0 0 C7 < N O O N N 0) 0 0 N O 0 11II — 0 N N - r A U a A O a a` o L. > O 0 0 6 o r 0 0 o 0 0 L. O O O d 0 0 4 is N N N C n N n m 0 e e cr o a 0 . J < H 6 m o ti J co O U co O 0 O• z t o O O N - O J o r o 0 0 m - U L O 0 P 11 co d d 0 0 f O O a at 1- J V % C 0 0 0 0 O 3 W :0 W D 0 0 o II Y O 0 0 d ^N 0 2 CC N W C Co d H 0 J O > O J O CC 0 o Co O CC m W CO CO .0 a LL o Z w 01 0 CC v w < 00 o a 42 ml d w o J• a0 0 0 ' O U 0 0 a Co W0 a >▪ < Q 6 0 L-4 d Q = Cr W CC U 0- o . Co L. C -1 0 Co 3> 0 CA >- L CoCO ti W 0 Cr > a CO .0 d 0 U N 2 W < 0 > C- Z a 0 3 O 0 4- an b 0 0 coan 0 Q W T CC d en J 0 O O 03 H -I 0 ti Q O0 0 0 N 10 -I C 0 2 CC• 0 d CO 0 0 O Q a CO E O > 0 V al Z C CO O 3 2 3 0 < 0 O N N '^' 11 -+ 0 Co CO 0 Ill O O 2 4 CO Z J v n a .. W 0 V d 2 • 2 Z CO M U N f J Z O 0 2 6 I- en a F- O 0 2 0 0 O 0 W a 0 >- J r 0 0 0 J 0 to 0 2 0 0 0 yr C d o d I.. O CO 3 C' O O 0 N 0 O O O N O 0 at (0 In e 0 0 O 0 o O O O o o II Ia 0 N CO n c..) a A O L a d O L > C) CO CO 0- O ]: n D- 0 CO N N N V ii CO CO ✓ t) as CO 4: CO 0 =i 0 N 6 0 SQ a 0 0+ J 0 O U 0 O J.- N F N aO N CO 0 a D N A P m o .- 0 n .- 0 C u _ N V II N d 'I) N- N O 0 0 ...a a,] C LL V 0 0 0 O 3 W 3 W :] f IO d 01 'I 4-,d — N CO p z ¢ d .0 C E H O J O `Y O O J 0 < 7) O `T L C W 0 9 E a LL U IL W N O O Q W CO CO o C O v 0 L J 0) 0 O U a D a co >▪ Q J C n d -. d C = 0 L L O' a ix ea d ti CO W i- Y LL O m > 3 m 0 0 F L E L CO J 6 Y d L >. 0 = W 0 W a a CodL 2 O1 CO C) r 0-0 Q 3 , d 0 O O Q 0 CO 3 - `o 0 v f Q y ti CCo d E O O CO0 d d T 6 L m I) O ! O D F CO O < < 0 A 0 4,OL 0) CO d 6 Q_ 0 LL CO U 6 N U 22 ¢ CO o ea o 3 2 ea C O O N0 _ 1I o U 2 C -• O • C JD ID O al O fl CO 0 a II a W 0 d d S Z 2 2 O 3 0 F O 2 O O z C F CO O W J F 0 CO 2 0 r O 0 O- CO W CL 0 J F 0 0 0 J 0 CO 0 2 0 0 0 N N O Co L 0 0 0 0 < 0 0 0 21 N ,,- O N 0 I. 0 V' O O 0 0 0 0 N N O O 11 II N N 2 A U 2) A 0 a a 0 > 0 v a 0- O 2 0 0 0 L 0 0 '0 0 IA 0 M O N N 0 C 0 0 J N 01 N 0 CC 0 Q 0 J Q I+ 6 Z O 0' J CO 0 U CC O - LL T La H 0 2 150 0 0 N O 0 J 0 S 0 0 C') 0 O M 0 0 N U = U L O O II 0 0 O O ^ O O CO CD 0 C I- J T) X X C C 00 0 O w CO w o 0 II O 0 3 LI 3 O -- CO N 0 .- 0 N 0 T 2 2 W C C E C 1- 0 0 0 > X N .0 F L Y 0 O O CC W0 L 0 < 0 0 IL U U W0 q O N 2 Q > I ¢ U C OI 0 0 0 w J O. II �� OI -4 0 0 J CO 0 O O a J 0. >• < C C °" 0 -`°i u C 0 - - L a O CC 0 LL 0 .0 Co 0 0 W 1- m > 3 co 0 J I— > 0 L T In L W O S .0 N . 0 0 U 0 2 W Q E > L 2 .-. CO 0 3 _o m 0 0 0 • 0 C . 0 O 0 - ' 0 2 2 R 0 0 In CO ▪ Q E O 0 0 T 6 0 0 2 0 0 w J 0 0 0 N II O Q Q 0 0 C 0 2 F- Q N Q 0 LL N 0 > 6 N 2 6 Q E 0 T N U al 2 2 0 0 3 — Q• 0 O N 0 -+ U 0 11 O 7 C ' C IL O 0 O 0 a a 0 II 2 2 3 CO 22 U I- J 2 0 0 2 Q F 0 O W -4 H O 0 2 0 0 — 0 N N W O C )- J F O O N J 0 ' 0 0 2 O 0 J _______1'1 � OA _! r x0p g3 F _� ❑ o N q g 0 o £3 o2C G (.,) o' 8 CD r �� w [7iII E.1 q a ] _ 41 U 0C �� ca a. A O E5 0 �„� :3 H c ��J v A oo II 01 li o w UCi z Za �� w ' 3 �I E __�� 8 C.) Iwo �_ 7 o Z ❑ ,� � o 8 0 - _ �� �' o a p ___ U A s • cn Ei eq 2 , F, - a 4020 [:=ne M O � cn70 �� v $ O ,.. eC 40 • • 00 II 4Fa C e -- F L U ZU a , °' Ocz; 1 C °w) w i C _ gj � ■ s wci o a a 1 O e n § 0. W � �j � __ o Mill o I V a _ g '• - z C 4 co $ r------------------------ N B4- OO • CN • a _ o O EM g e . Awo �� I gU a° I b z...; A00 ii a g m s� z c9 a- � w � � � W BE N w �" CO U A _ g w ° o � ma ® - g w W E o —cm cz H i �__iZ 5 Appendix C County Response: Valuation of Agricultural Land a a OFFICE OF THE WELD COUNTY ASSESSOR �j PHONE(970)353-3845, EXT 3650 y♦j�. FAX(970)351-0978 WELD COUNTY ADMINISTRATIVE OFFICES I 1400 N. 17TH AVENUE G c ',j GREELEY,COLORADO 80631 COLORADO August 24, 1999 Thos. Y. Pickett & Company, Inc. 4155 E. Jewell Ave., Suite 809 Denver, CO 80222 Dear Mr. Zimmerman: In the recently released preliminary audit for Weld County there were 2 separate issues that went down as suggestions for the Agricultural Reappraisal. The issues were regarding 1. Sprinkler ground that is being classified as flood i:Tigated and 2. Whether we are not doing the crop rotation correctly based upon silage as opposed to corn for grain. With respect to issue#1 the Weld Assessors staff has always attempted to follow the state guidelines as closely as possible while still allowing for adequate time to correctly and successfully complete the valuation process in the properly prescribed time frame. We are beginning the process of review regarding this issue and will be formulating a plan which will allow for a complete assessment of the sprinkler issues for the 2001 reappraisal. We are aware that there may be some areas where the typical irrigation methods that were prevalent some years back have now changed and that we may need to make some changes in these areas if the pervasive use of sprinklers is now evident and the facts clearly shows a need for review. We appreciate the help of the auditors and State Department of Taxation personnel in working with us on this issue in hopes that the future will not reveal problems in this area further. Relative to issue i;'2 we again were following the state guidelines as we felt we had been directed in the past as well as present. It was clearly our understanding that in those counties were there was a predominant base crop, such as is the case in Weld, then we were to base our rotations upon that base crop only. The corn for silage was accounted for in the total acreage (as can be seen in total areas planted verses harvested). But as we interpreted the state guidelines and in further discussions with Department of Taxation personnel we were completely sure that our methodology was entirely appropriate. We hope that some further clarification can be brought forth in the next reappraisal period which will help to clarify these issues and avert further complications in the future. Rest assured we are fully prepared to make changes if the statutes and guideline change or are altered to better clarify some of these minor issues. , Please feel free to contact cur office at any time you feel it necessary. We would very much like to alleviate these issues altogether for this year as well as future years. Sincerely, The Weld Agricultural Staff cc: Judy Kahl, Dept. Of Property Taxation Hello