Loading...
HomeMy WebLinkAbout20022605.tiff 2002 Weld County PROPERTY ASSESSMENT STUDY Prepared for Colorado Legislative Council Thos. Y. Pickett & Company, Inc. Denver, Colorado I/5 g0{50 Ce =„t/ 2002-2605 al( AS - 2002 Property Assessment Study Weld County This Final Report presents the results of Thos. K 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 dasses and/or subdasses of property in Weld County, Colorado. This study was conducted pursuant to Colorado Revised Statutes Sections 39-1-104, governing valuation for assess- ment THOS.Y. Valuation Engineers PICKETT Oil& Gas-Minerals Tax Consultants Industrial& Commercial Ratio Studies Public Utilities Data Management Services &COMPANY,INC. Real Estate Apraisals September 15, 2002 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 2002 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 21, 2000; Contract Encumbrance Number 02000000005, dated December 11, 2001; and the current Standards on Ratio Studies approved and published by the International Association of Assessing Officers in July 1999. Respectfully submitted, THOS. Y. PICKETT & CO. INC. at"-/44 John Whitley _ _ 4155 East Jewell Avenue,Suite 809• Denver,Colorado 80222-4512 Phone(303)691-9986• Fax(303)757-4898• Home Page: www.typco.com a a 2002 a Property Assessment Study Weld County This Final Report presents the results of Thos. K 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 dasses 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 a 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 4 AGRICULTURAL OUTBUILDING AND RESIDENCE STUDY 5 PERSONAL PROPERTY STUDY 6 Procedural Verification 6 Statistical and Procedural Analysis Results 7 SALES VERIFICATION 7 ECONOMIC AREA EVALUATION 7 SUBDIVISION DISCOUNTING 7 NATURAL RESOURCE STUDY 8 Earth or Stone Procedures 8 Producing Gas Procedures 9 Producing Oil Procedures 9 APPENDICES 11 2002 Property Assessment Study Weld County Introduction Thos. Y. Pickett & Company, Inc., has concluded the Property As- sessment Study for each of the 64 counties within the State of Colo- - rado. The study was conducted pursuant to provisions of the Consti- tution of Colorado and the Colorado Revised Statutes [CRS] Sections 39-1-104, governing valuation for assessment. The fundamental ob- jective of the 2002 study was to ascertain that each county assessor complied with Colorado's mandated guidelines in valuing all applica- ble 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 2002 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 Vacant Land 0.95 to 1.05 20.99 Residential 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 2002 tax year. By law, these valuations are based on the tax status date of June 30, 2000. 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 2002 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. a Summary Results of Sold Parcel Analysis PROPERTY NUMBER OF UNWEIGHTED LOWER 95%. UPPER 95% COEFFICIENT CLASS QUALIFIED MEDIAN CONFIDENCE CONFIDENCE OF SALES. RATIO LIMIT LIMIT DISPERSION Commercial 133and 96.98 94.59 98.48 10.67 Industrial Condominium 250 101.58 100.25 102.79 7.46 Single Family 6498 97.64 97.39 97.87 8.95 Vacant land 1288 98.48 97.82 98.92 13.14 a Summary Results Of Sold Parcels by Economic Area a Economic Qualified Median Ratio Lower 95% Upper 95% Coefficient Area Sales Confidence Confidence of Limit Limit Dispersion 2 1979 98.75 98.34 99.15 6.84 3 1420 96.26 95.80 96.74 9.34 4 537 95.42 94.34 96.17 11.99 5 108 97.04 94.52 99.15 12.04 6 2403 98.02 97.66 98.46 9.38 8 32 95.44 81.62 101.83 15.00 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 2002 Weld County 3 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. Agricultural Land Study Land'Clasi Acres Total.ACtual Value Per AcreRatio Value., Dry Farm 559,663 $27,614,424 $ 49.34 1.002 Grazing .: 1,042,442 $14,720,523 $ 14.12 1.00 I rn3dterl Farm ,, 363,859 $151,933,539 $417.56 1.001 Meadow Hag '`' 17,140 $2,172,563 $126.75 1.002 Waste 17,071 $95,767 $ 5.61 1.00 Total 2,000,175 $196,536,816 $ 98.26 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. • The land classification includes adequate detail to accurately reflect 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 and lease terms accurately reflect land use in the county. • Lease terms accurately reflect land use in the county. • Production areas are established within the county. 4 Thos. Y. Pickett &Company, Inc. • Crop yields as a percentage of the ten-year county average reported by the Colorado Agricultural Statistics Service as: Irrigated Corn 100%, Irrigated All Hay 99.8%, Dry Land Wheat 100%. • Commodity prices, expense items, and capitalization rate specified by the DPT were properly used. • The pumping cost formula, as specified by DPT, is used incorporating 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 each land class was physically inspected with the majority of parcels conforming to county appraisal records. Weld County needs to continue to update their records on sprinkler irrigation development. Also, some larger parcels of Waste need to be reviewed and acreages double-checked. Suggestions • Continue to update sprinkler irrigation development and make appropriate adjustments. • Consider using .25 Ton increments in valuing Meadow Hay. _ Recommendations None Agricultural Outbuilding and Residence Study Weld County is exempt from this portion of the Property Assessment Study. 2002 Weld County 5 Personal Property Study Thos. Y. Pickett & Company, Inc., conducted a procedural study on the overall approach to personal property in Weld County. The study was executed in compliance with the provisions of Article X, Section 3(2)(a) of the Colorado Constitution and CRS Section 39-1- 104(16). Procedural Verification In accordance with ARL Volume 5, Weld County has an estab- lished discovery process for personal property. The time frame established for the 2002 audit was May 2001 through April 2002. Schedules were selected for audit based on the _ following criteria: Non-filing or "Best Information Available" assessments. Incomplete or inconsistent declarations. New businesses filing first time. Accounts with discrepancies from prior audits. Accounts near to the $2500 threshold. Businesses in a selected geographic area. Possessory interest accounts. A random selection of schedules was identified for statistical - analysis. Present worth established by Weld County was compared to present worth developed by Thos. Y. Pickett & Company, Inc. Specific items valued by techniques other than cost trending and depreciation were excluded from ratio analysis. Weld County used the indices, depreciation schedules, economic life, and level of value adjustment factors recommended in ARL Vol- ume 5. Further adjustments for any additional functional or economic obsolescence were not utilized. 6 Thos. Y. Pickett&Company, Inc. Statistical and Procedural Analysis Results The ratio study on the randomly selected parcels indicated a median appraisal ratio of 100.0%. Therefore, the overall level of appraisal was in compliance with the current standard adopted by the State Board of Equalization. The procedures employed by Weld County are in compliance with current guidelines and policies defined by the Division of Property Taxation, including the required plan to audit an appropriate number of personal property schedules each year. Recommendations None. Sales Verification Weld County maintains master sales, verified sales and qualified sales lists. Lists are maintained on a continuous basis. The verifica- 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. 2002 Weld County 7 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. Recommendations None. — Natural Resource Study Thos. Y. Pickett & Company, Inc., conducted a study in Weld — County that included various relevant natural resource elements. 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. 8 Thos. Y. Pickett &Company, Inc. 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 million cubic feet (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. Conclusions The correct appraisal procedures were used in valuing oil production. a 2002 Weld County 9 a a Appendices Documentation of Statistical Analysis a a a a a a a 2002 Weld County 11 a a Appendix A Sales Ratio Analysis a a a a a a Aiik in 01 In m in n in to A • • • • U) • • U) • • r- • • in m .- co m T. O • w. >- •• In m W CC 1 .0 a. 7 R • • Cl. • ♦ UI •Y • • C CO • • +i co W = J • • .pl 44gJJ • • 1p # • w • • W • • O I. CL R6 Q •s n • C _ O b • 0 i m < O s i O 0 U C • m - m .'' CC z a ► 011 O m o 14. 00 0 f F +.A 0 0 U I N 4 _1,UW W A. 4,CC: r m L Z 4 <L .-, • 0 in 2 'i 0 • U) 7 .» i► 8)- I, J • m C I. CC C co ■ in E w • 40 r+ M in Y • J U Is W • a 00 •• in Q W • m• +� w CC W • 1- UI O in n • • UI • CV • • in a m in C? 0 C C in � I 4 4 I 4 ! 1 a in 0 in 0 - ^O in w 11 A O O N O W • A 0 CO O n 0. CI 0 n 01 9- CO 1". A 0 I- .. O 4+ C' Y S O W 4 0 0 O CC 0 O. 0 I- 0 C OS C 9-I CO r W L A J ♦ co Q ""5 W • 0 # O • U.'U 11 y J 0 • • ♦ C 7 • • • O O O 00 C • E 0 • • —a. ♦ • V N • ♦ 4. 0 7 x > 0 dr V H I q ..w ¢ 0 E 0 o e o U o U.0 0 ■ I— r 40 9-4 0 U g 1/ d # d + • 0 CD m 3 ♦ • 1. _. ♦ i+ 0 CO M m 2 .1 O CO 0 .. .0 U I ■ 0 OD CC C 0 • ♦ • y • • 4 O • ■ • N y O • • • ca Y ♦ ♦ • z 2 V W a IL ♦ 40 E CC ♦ ..y W ■ 1- 0 in 0 v 0 0 0 N w • 0 O N i+ C m 1 1 i f I O. 0 e) c,0. 0 CI a 01 In m to n in to a in in N a N N < 5 ti U T M T N to H N Q ^ a to m a .y 0 0 CC 0 a N > P m C • • M N a W C L CO Q N N m ; 0 — W pO LL -+ 6 J C O C D O = 0 E Co -1 e V C N W +1 J t- t- o dr is a z o m o o o m 0 m 6 U U Fi E O O 0 • C ✓ N -I d C Q 3 • • • • • • • r C N m z co L LL y 0 m CO m Z .9 0 .0 a N J n 0 0 m • • C Y I- C an m O in €0 Y to T U z a w In 0 C a m W N E C LL -f N a N 0 a N N m m to In M C m O I I I I I I I a to en N 0 - 0 N 0. m a 0 0 N O a O Co O N 0 co 0 in N S m 0 T V O a n a 6 .- Y W 0 n. .4 0 O J CC a 0 0 > Co co m -- c .4 m 4+ W c Q O .. N • it • t CM CO 3 0 W 0 Q - C -I O C C CD J O E 0 a O 0 -4 M C 0 W J x i e - I- o ce a CC 0 C m 0 0 0 0 0 0 0 U. 0 0 e 0 0 ` c :+ Q 3 Y C 0 0 Z OI L a r »0 m an 0 a 0 J a- • • m o ' • • • • • 0 m 1- c CO co O 0 n M CO J 0 0 2 a w0 m 0 o m W 10 ,,, C a LL H O in o a 0 Co 0 a m 0 a m 4-. C 0 0 I I I I I I I r_ aa d in o an O a 0 in cn a co N N OI N m N n N N in in N a N co n V N m n N 2 Y in U 1 M O J 2 O 6 N } • w co m m C • • N co n in L J CD CO in m 3 O M O W Sy] J O T C J• O N O E m co W � n an I- r m x a z .I m O 0 c N Oi O m 3 O E O O It M F▪ W 1 m CC 3 w N m 2 m L LL N Y O ♦ • ♦ • • • ♦ • w • • ♦ • • • m CO m 2 .I O • w w in p f n O J O m 2 Y H C CO • W in E o • m ✓ m > • o O z a w m a N m w in e 2 M LL • n in a in N N N N m CD N CO Y C m o I 1 I I I I I I 1• a n {7 N N N O in to a 0 N O 0 r sat o to O h o m O to ' m N co 4 . Y V o N Y41. F Y 4.. M CC 0 a 0 O O • a • • 0 o c m 4.4m •, CO r CU CO -I • co • 0 m or 3 o • • a a to O N Y C J O T 0 m J E 0 •.-I r m m O U 6 • a Ill F d° 9 ~ 2 .4 0 0 0 LL C) C • F ..E4 < Y O2 0 U m I-• Ill LL Y O0 CO N Y LL • m 0 m co "1 z a O O a ,.• . . . to c o to y Q C Fa 1 m CO o B F Y O m • • a o- a 2 m j • • o at O • co .,E4 4. Le • F LL 0 in o a 0 to 0 N O at m to Y C O• 1 I I 1 I I I i m O 0 O In O ' O O a a 0 (7 N N 1_ on o) In m in n in IO ♦ ♦ LL) • In ♦ 4- • SO O 40 CO O S .. a U • 4, • In h } • 0 cc • ^♦ U W N d 7 O 0 a • • • Q • • • in ► • ♦ N co } ♦ ♦ ♦ *- C m • • ♦ •.i N 0 L A W I9 _I •.4 Q ► In m en • 3 W O w IL 4+ hl K C < _I 'G • 0 O 00 C ► 0 4441 O W Z > 4+ eif. ...... 4- H C eel 2 el • in 0 0 A i °D 0-4 o 0 1L 0 a ♦ I- •.I O O 0 a a+ H J O. a F- W V • co L z • 4+ IL M • 4) 0 m CO - Z a .4 i 4- 0 I- t 0 J • 03 r ¢ C I- • • • m 0 r • • • IID Y ♦ ♦ ♦ 0 • ♦ ♦ 0 v o z 0 W ► • 0 5 In 0• w ■ ► •.1 CC ■ • 4- IL • • In ♦ If a 4. • In • 0 • ♦ 0 • N • O 0. m N 0 a 4+ C m L 1 I 1 I I I m 0 N O In 0 In a. M N N .- 4.., CO N 0 01 O CO O A r n.► 0 10 p O N Q m, *Ma J a C.) • v • 0 a • v N • Y Q • O W .1 4. O O 4 t 0 ♦ w w } t c r In t W Q w Q • 0 m t 0 W O r •:( -JV •+ 0 F 4 00 4) i CO Ill • Z W • 0 CC 7 C) • 0 0 m � U > 4. F •.4 o 0 0 .+ J 4 m Q i ► 0 m • rn C. Z w V LL .-. t b 0 z a 0 : m0 o N , 0 m_ Q N m — A 0 6 w • A N O t N 7 } Z 3 Z m W ♦ I. t , • w 0 m O t It • tp E ^, W ► ■ • .4 CC w • , H w • • O •• • • .f) a • • p • M • • • • • N • m O N C 1D I I I I 1 I I -- m N O O O ^ p 1f) 4 P) P) N N at a a I11 J 01 a N T Y O » W Y LL 0 0 Y +'1 J 01 J < O o a O .0 C Q S Q . F ¢ N O L 6 J II 0 U CO 00 0~i 0 w - —o .. U Y a 0 .. - .0 In CC L J 0N 0 V 0 C CO U < 0: a, J 0 LL Y < J < N CO CO W W J 111 .8 9 < 9 0 0 C < N t0 F cc IL II ob 0 cow E CO IL J J 2 a to - M 6 co W N co ' 5 Ill 0 .'1 L J L +1 J > a a < r M > 6 N a W 2 - W O - 0 J a CO O. > —o 0 W Y 0 m Y co < to co a co c c < a, N 0 E o < « o ✓ N 0 J LL 1 V O CO O co O a, F O a a 0 0 f a- < o < < 0 Q U —O < O In W 6 < < < U IL, J O. so U 2 —O a - --Y - 1 1 1 I 0 0 0 0 0 0 0 o 0 0 0 0 0 0 0 0 0 0 0 a 0 N U 0 2 u 0 r « I+ o z < J a > < J J w a LL O a ¢ < I- I+ 0 0 O Q —o 0 CO N 0 0 Q 0 0 a m 0 a 0 0 0 N N O 0 O 0 O 0 O O —0 O Q 0 N a O w o a —0 i - .. N Q 0 > N Y O CO W Q a0 Q 0 Y 0 +-I J ro O 0 J 0 0 0 le O O C N CO i Q 0Q .`. F 6 N Y O L C J 0 0 O .� 0 0 0 +. a 0 0 Q 00 3 W N N 0 ) CO N .. F a CC 2 0 w a o Q 0 4-1 C CO 0 Q 0 6 d 11.1 J O 0 0 a 0 Q J Q Q CO 0 CO b CO W Q 0 W = 3 2 D N J 2 C 0 C a C 0 ~ II 0 6 0 P CO I.L. a 0 O Q W a o N J a a —0 2 Y 2 N 0 W in a mQ N CO > J 0 0) 0 w U .4 L 0 L Q Q Y J ) a W > Q m Q Q O w W 2 C —0 re N 6 re 0 CO 0 Q (0 0 e' CO a > m O 0 CO 0 m ¢ mQQUmQ UmQa Q Y N O Q 0 0 —O 6 0 Y QQQQQQ O Y 0 N 0 U Q Q = w a 3 a t Qa1. N Q U (5 m O 0 0 CO0 E 0 m Q o I- a. m OA Q 9▪ `Uy Q LL -0 —o Q O 0 T Q Q Q U U 3m 6 0 0 Q 0 Q a —O 0 Q Q 0) Q 6 W 0 O Q —0 Q 0 O N 0) _ 1 * O O —O O I I I I I v 0 o 0 o o o 0 o O O o o 0 0 0 0 0 o O O o 0 N O CO N 0 0 f a 0 F Q F w 0 2 Q J it > Q J 0 W Y Is. 0 2 6 Q F w1 0 —o 0 0 0 0 a 0 a 0 0 0 —0 0 N a 0 0 0 —0 O 0 0 0 a. —0 O 0 0 0 +-0 CO 0 W 0 -I 00 a < .a CO M 0 0. W y Fe Y V O 0 N Q 0 —0 0 O O n to a W O 0 -I a0 N G 0 a 0 0 i LL U CO 10 600 Y 0 < a Z 0 Q LL o 0 Y W c co U cc m 6 E W S N CO to W a 3 LL a W 0 ir. 1=- 0 0 0 a a 00 co co 0 S LL LL 0 E J CO _ Z COa Y Qq W CO a 4 a 0 0 W -I o +Ui a s L Y J } i a Q a a 0 0 > CC 0 a a m a —0 m W z 0 el a W O N a Q a a a in 0 CO6 a 0 a 0 CO > 0 a $ a co a• m 2QmmQ to c N 0 a a U Q 0 E O QQQ3 QQ _0 » 0 W CO U m m Q 0 0 N d CO = 3 a 6 V .0 0 CO as m LL CO 01 CO a a a. 0 m 0U. Y -�+ -I CO LL LL O U0 SSS F 6 CO ti LL IL O a 0 a 0 LL he el 0 LL to a —O O J U'J U co O 0 O▪ O O. 0 0 0Q W O.> O W Q U = N LL N = CO a Y(J� N N 0 O NN N O 0 _ MNN IL 0 4 0 N = —O a O N= NN U O GG a N N N O ¢ N N J J N N a ZNNO LL N N e+ UNN 0. -INN m 0 O N NN CO —0N0 N N O 0 _ LL N 2 M Q N O. 0 r+ J a 9 � a U L a —0 0 I I I I I I I m 0 00 00 00 00 00 00 " 0 00 0 0 0 0 0 o a a N O 0 CO a N W 0 OM00Zia- 0 CC a r i+ 0 Z N 0 ' 0 0 —0 0 0 Q 0 0 —0 0 0 W 0 < —O 0 0 0 < CO W 0 J 0 Q 0 m 0 0 T O h Y Wco LL 0 Y M 0 Q m m o o m o a mu' pQ O o c H C CM 0 4, 0 6 J N 0 C ILL x CO < m +4 m W .. i 0 ). L Q H 2 Z 0 a D w 0 .- 0 la U C ILI N 0 0 —O Cl. Y Q Q CO 3 U 0 CO CO w 0 2 > C 0 Q V cc 0 m q Cl, CO J LL 6 J W NS CO .. Z CC +4 W CO CO Q M > < m 0 -I V 0 M J O t —o C a 1'- 0.« a 0 m > c 0 e o a .= .0i w o a CO c 0 < 0 0 _ w0- w 0 N� m a < .. II- a a 0 la O O Q —0 a O y 0 Y 0 CO N .m4 Q Q 1" LL 0. 0 a Q m 0 O < Q a J < +4a R Q H mQ < < o < O aQ O U 6 0 m N C < a E 2 o < a o al < O U0 lc- 0 0 0 0 0 W N 2 Q < 00 0 0 -3 CC ILI U. N 0 a 0 0 U N 7 O 2 N O U m N OY m < N N 4 .1 2 N Q m < N CO w 3 a .. 0 0 ..1 a a I i I I I 1 w a 0 0 0 0 0 y 0 0 0 0 m 0 0 0o n CO 0 0< N m a 00 Z u J ti Q F N O Z < J a > < J J W a w O c c < F L+ 0 O Ill F 0 Z CI a J Q 0 f O 0 0 W W 2 0 0 0 0 0 aF lu C J W - •- ... . Li- CC Li- 8 x zz o 00 a a e F 2 a Cr 0 CC 0 0 0 3 G 2 0 zQ JP F w n 3 0 a a m m m m n 2 J O I, 0 0 0 W W 0 0 0 0 6 • 2 LL LL Q CO 0 Q I- 0 2 JIL ZZ ZZ 0 O 6 2 d° F W a 0 0 6 2 n N 'co too V .m1 LL 0 J 0 O CJ CO 0 T 2 ;W W 0 0 0 0 m o O LL*Z Qan o y 0 0 Q 0 CO 0 CO Q .. W C C I 0 O Q 0 0 0 0 0 4.-' ^ J uJ CI: N• • • C• CO w 0 O " C 0 O O 01 +l I'' 3 = > Q Z O O F 0 c 0 2 N O J W 0 E z Iy 6 3 O w O 00i Crr 0 -„ a LL 0 0 A 0 V a 0 W O 0 COCLI W LL E J 0 ..E H 0 2 0 N V J - 0 0 C- w JP F F Y W 0 i < 0 5 6 CO n 0 CC N W y , 0 0 ¢ _J zQ W OI n O a a Ill 0 0 0 0 0 LL W 6 Zr 6 LL 0 0 0 F DZILI0 0 5 �.CC O GII N U- I13 O C 0 E CO 2 M N .... 0 0 7 P F F 4.4 0 J Of 2 0 S 6 N Ol CO 0 Q IC J O O I. N ^ o w zd' 0 0 0 0 F 0 LL O F Q J 2 W C O i O OILI Z 6 O CO N 0 CO et CO+`e OWSI Q 0 0 0 CO a LL w CO6• II 0 Fi W O 0 0 CO N 0) O J H ^ O Cr .-O II 0 2 O N a Ili T O .I4 T V E +I C CC 0 - -I N N W N 25M sCl 1F .1 CC 0 • O C 1 E V CO N E C C O O O +I N 0 0 CO > Y 4 0 r 0 0 N d 0 0 0 0 O N N 0 d m m m 0 rn 'Q W w 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.. g6 6 w 0. w LL ¢ U. 0 N 0 0 0 N m 0 m N. d m 0 0 m N - N m 0 N FQ Z 0 0 0 0 4 0 - r m d m N - 0 0 0 0 4 - 0 0 N -N 0 _ • W F CI 40 0 m d n 0 N 0 Y d n Y 0 - 0 n 10 N Y 0 Of`J Q¢ 00000000000000000m0000000 0 0 0 m 0 0 0 0 0 0 0 0 0 0 0 - 0, 0 0 0 0 0 0 Q z o zd F w l0 m Z 0 N m 0 CO N 0 0 N 0 N m d 0 m m d 0 CO m 0 m r 0 0 5 O - N 0 CO - n n - r - 0 N 0 0 0 - - N 10 0 m d 0 0 . . . . . . . . . . . . . . . . . . . . . . . . . ¢ J O 0 0 0 0 0 - n CO m n m N 0 0 0 Y 0 0 d 0 0) 10 0 Y N W w 0 0 0 N m m C00000000000 m 0) 00000 4- ¢ - - - a 0 0 O U 0 F _ Z O J• d° a QW 0 Z 0 0 N 0 0 01 m 0 m O n O N ^ r rn d - 0 0 0 0 0 0 0 U 0, Z n O O N N n 0 0 0 0 0 0 N W m N n - N O t0 0 0 2 ¢ J 0 ON Of 00 m NO) 0 N Y 0701 N N 404- 00 0 d d 0 - W W W CO MO) N 0) 030) 010N 0 N 0 r 0 0 0 0 0 0 0 0 0 0 rn 0 rn rn CO 0 a O• 0 LL 00 - T 2 J Oa as o a o x a e 0 J rn w o 01 o Q 0 o rn d n m N m m 0 ' Y m m r m 10 0, r - 0, N - m m 0 •- N C U• 0 0 0 m m - r r r 0 m m m 0 d r m m m - n m m 0 0 <¢ ¢ Q O N Y m N r O m m N d d m m 0 O N N 0 0 0 rn +� 0 0 0 Z 6 0 0 m ' 00) 000000000000000100) 00 c ad' o < - 0 U a o w > C a Z F 0 3 2 �+ i8 w 6 Y O d O m O 0 n N N d d m O 0 d O 0 0 0 0 N N N C O o ow m N 0 N 0 0 O r - r - 0 0 0 O 0 r O m O 0 m O N O 0 w . . . . . . . . . . . . . . . . . . . . ZO J LL D ' n N00) 00 rn 0 0 0 - m 0 0 m - N 0, - m m NO) m 0 N 0 Y 6 2 WLm 0 0 - - - - - - - - N J O 2 U LL V 0 0 0 o 00 0 W a J a m < Z Y > m O O m ; 0 d F F M N W m Q 0 r 0 N 0 d m d n m CO 0 m m m 0 CO CO d 0 O J ti 0 2 6 ON 0 0 mo - - r - - d d 0 0 m 0 0 0 - O L • U J W J 2 d N O 0 0 m m 000) 0V m 0 d n 0 f0 Of Of O O 0 0 Q 6 Q - - -0 0 0 0 0 ' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 w o O. LL 0 M O O J 2 w a 0 = J .•• LL• W 0 0 0 OF O 6 V e 0 Z C ma O O 0 0 N N Q N O 0 n Y O d N m r N 0 m 0 CO 0 0 m m F 0 M 6 0G r - N . 999999 ' 'Yn J ¢ J 4004- d 0M N O m d d r 0 - m - O r 0 r 0 V O �u �d 0 0 0 m ma 0 0 0 0 rn rn 0 0 0 rn 0 0 0 0 n It b LL O - J 2 W E .� 0 OU Z- - a a N 0 0 m N 0 N N N 0 0 N V N N d ' N 0 d 0 ID 0 O m 1000, 0 - C. 001 0 m IN N d 0 0 0 d m 0) 10 r 0 N m mm o O F 0 0 (Q 0 r r r 0 0 0 0 0 0 n 0 n 0 r 0 N 0 rn 0 W LU 10 < 000000000000) 0) 0) 000001000000 LL N 0 II 0 W d N 0Y0•- - 0 d N d m 0 N. 001 0) N 0 0 MVO m - II 0) J J N - - n 0 0 N C- N 0 0 0 - 0 0 0 n 0 0 . - II CO 0 J CO 4- 0 ' 0, - N d 0 0 H 0 Z 0 11 0 O Z < U WW, - W 6 N M Y 0 0 r 0 N 0 d 0 N 0 O 0 0 NON m d 0 0 n 0 O 0 0 0 0 0 0 T T >404 ,404 ,4 J J J J J J J > C C C C C C C E E E E N 0 E 'E E E V C V C C C V F C C C C C C C J J J J E E E E E E E C C C C C C C C C N m m m m m m m m m m m m m m W C C C C F F W W W W W N N N .'1 N N -i 0 b a a a b a a E L 0000m00 , , O E E E E m m m m m m m Y CCCCCCC Y C C ¢ U 0 0 0 0 0 C C C C 0 C 0 EEEE E E E C VC V C C0 C C0 C C0 C Cl 0 0 CO CO 0 0 0 ES 0 0 0 0 0 0 0 0 0 C C C C C C C O 0 O fJ U O 0 0 0 0 0 0 0 0 0 0 .i i 0 .44 4030 CO 0 0 0 000 0000 0 000 03 (00 (000N > > > > > > > In a J Q W W 2 0 0 0 0 0 0 F W IF CC CC O. W LL 6 LL IF o m• CO n n n F zz m CO a N N IF i ¢ 0 0 0 0 0 Z 0 eP F m s CO a m m m Ol w FOLOCLIO 2 J o 0 m m YI a I' a 0000 0 . C u. to a z co 0 Q 0 O i- 5 J▪ z W 0 O OP F W W q 3 z 00000 10 a O 0 LL• W J W 0 co 0 0 0 a ^ ^ 0 0 LL m m O J 2 0 Q y N co co N 0 O co pO H < Q-Q C 0 o 0 0 n n m m• 0 0 y�j� • • .1 a • O co 0 m ¢ N 0 0 0 0 c g a w 1- F a a 4¢ z J O F 0 C 2 0 IF Z0Z ¢ 0 a 0 LO at E ¢ 3 r0. CL _ mammco Z LL CO ^ CO A n CO re a 00 IF WO 0 a0 0 w 0 0 m J e m Q N F co M • W — Co ✓ J H Fi W IL LIP F F L W in iF < U101000 0 0 01 q 0 Q OEM NO CO CO m W J O: J • 0000 0 0 W Cd' 0 0 0 0 0 n 6 z S Jr W 0 O0 F 0 5 0 O: LIP 0 ✓ N LL C 0 m z e 0 O O +' F w 0 v a▪ ma4a. mnn -am m ,., 0 w ' F. 0 00 0 01 0 w ¢• -1 O W F cc 0 • Z 6 O Imo 01 0010 CO 00 CO F. F m c. CO CO I. W < 000001 S 0: a LL ILM CO II 0 O < < m N N N N I II at Z 0 II W Q a W J O'. N CI a 0 a a a a a a Fl eel Fi el Fl M E 4 E "M F CO 03030a$ 63 I¢ CO VF W F v- w 5 a m m m m m 0 0 ^I .4 .4 .i .i 6 O 0 W a a O. CCCCC CO 0 0 CO CO 2 4 W Z 00 0• 0 0 W 0 H W a5ac, _ � .- _ 6 W LL 6 LL O • O 0 W N - O CO Y 03 CO 0 2 0<CC 0 0 0 ) Z 0 JP l- 01 0 2 03 0 M. A- CC W J W 00 0 0 03 0 R • C a 6 LL 'U J 2 O 0 < U CO 1- 5 Z J O 3�j w dP — Y7 2 1 N A O a 0 .2 W • O ¢ J w w 0 O 0 0 A 0 0 0 0 ^I a LL . Q¢ > 0 J 2 Q » 0 8 U � In al 0) 0 CO 01- 2 w a 0 coma m 0 U a O 0) C .40 022 0000 0 a 0 a I •C m F 3 ¢ a J a V 2 0 C 000 W CO C ZO2 OJ U W CO N 1 on C0 a IS < 3 a O N CO CO g- w 0 ^ U CO 0 0 m W 0 J a N a +i F CO a 2 O O 0 0 W Q 0 0 a J LL O ~ 0 A 4-1 W 0 22 J A LO 0 O 0. 0 CO 01 0 n 'Ira Jaw J at 2 0 2 O U A 0 G of O N Is. C a 0 2 m 0 O @ a a y aP f F CO 0 03A0:10 2 02 = . 011101 'a a V W Q 01 J 01 OO 0 0 0 0 LL O a J 2 W •.I Q 0 a ~ w 'd o 0 O a0 0 o f • < 0 • a 0 A a Ill < 00010 LL LL LL CO II om It 0 O MCI N CO Q Q N O 0 0 0 l P CO 0a 0: >- F J LL J ^ N CO 0 W 0 T T T T r-1 N rl SEEM I- CO CO 00 CM 6 S A Y• P- A W 0 m 0 -4 -4 ..4i al CC i C CC CC 01 C CO 'ri H CIi CO CO 0 0 0 I- a J a WOF W2 2 0 0 0 0 0 W OFW - - - - • 6 W 6 W LL CCU- 8 = 30 e N 0 m O C ul < 00 0 0 0 0 s 6 2 0 3 JP F Ill 0 .OM Z 0 v 0 a 0 .. 6 J O d IO W d • LU W 0 0 0 0 0 6 0. • 6 0 320 Z 0 O < fO a F Z J 2 W 0i O e F W 2 In — = . 0000 W O 2 01- 0010 'I0- O 6J0 O CYVOMO T LL W LU O O O O O m 0 0 . 0 -i = 0 Y 0 < Q -I JP N 3 O OCOO O w Q QH CD a 00 U' 2 . 40 F O O N V a <d' 0 m w < 0 . 00e w O 0 O 0 0 0 0 Q 3 i-▪ >- CI- = 2 3 0 F O C Z . 0 ZO J . 6 .- O O 1- V 0 W IO F d N O 0 LL O O O 1- (O n 0 Y W O , m OW O LL 0 W 0 J N V O Q F O 0 V i▪ W 0 0 0 J . LL dP F <F V 0 -1 COMM N 00004 co W3 6 J 2 O 1� O O O "I 0 0 W 2 WWWWW n aJ 2 D Z O W 0 U w 0 Y d° O C mu_ 0 O m Z Y F O O ^I 0 ▪ W . < 020 ,- 001 O oz 6 O Iu, two an 0 W cc -4Z < a OI OI a W E n 0 M LL O F 20 Q- J OM 6 0 O 2 OFOMM W 22 W N O t7 . Z OF h I. O O 0 WQ WWWWW K ..n LL O II 0 . 0 O01 . 0003 J J 0 - 000110 3 0 O < O O N N Nd 0 2 0 0 CO W F LU 0 IllZ JJ ¢ 1- N O d 0 O 6 T T T T T - -I .'I +I "I F W 0 0 0 0 0 6 N . . . . . W 0 00 'i H000 .-I ..1 'i 6 00002 O. CCCCC -'I -1 +I +1 .'I 00000 a a Appendix B Sold / Unsold Analysis a a. a a a a a a O W J 0 0 0 0 0 O 0 0 0 0 J 0 0 . 4 0 0 a d 0 • 2 < a 0 CO 0 w a J O a a O 0 a 0 2 2 O 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 6 J U n 0 0 CO W 0 0 04 0 0 d • J q N N LL LL O N N N J 2 CO 0 2 a CO I- •-• U ❑ 2 J• 2 W O lal U b 0 0 0 U 8 H 2 O O 0 04 0 O N N - < 0 J 4 CC 2 O W • _l a .- N N O O 0 LL 2 0 K W K U 0 2 a dP 0 J 0 O T f 0 2 •_• 00 000 ❑ N' 00 0 0 0 0 < J 2 S C. CO N 0 isi 0 • 04 3 0 0 CO 0 0 0 2 0 J 0 o a - N N N •+ 2 < N H N H O r J 0 K O i- t, 0 2 N 0 W 0 0 0 0—I 2 W dP H O G U 0 = a 2 0 0 n Cr LL 6 S O 0 Y 0 LL 0 J U 6 • ❑ N cu m J ❑ J J Y I.L. J N a a a J N ' 0 $ ; 0 ❑ W 0 ❑ iii0 W z co 0 O O Z W O O O O et CO ID 2 0 N Q 0 0 0 - 0 0 0 n CO 04 O 0 J 0 SSS - - W 0 W 0 0 0 P. co LL 3 ❑ N a < OJ 2 0 W = O 0 a U 0 ki,❑ - 2 < UJ O O 00 00 04 00 w 2 O W i N 0 n 0 N 2 0 • 0 0 0 0 0 > O N 04 N O < N N H N H a 0 LL W O LL W I•••• a O O 0 < N ^ ••- O a 8 0 0 0 LL < 6 0 0 0 > a N a Q Q� C m 0 b JJJ O CPS L 0 0 f 0 0 M OO a m Ft O VD U NI CO A N N O O O O > O LL F N 2 U N J O O m O U ... N L > O O J ...I U CD S o or t-- 3 0 D m 0 & O > Y 9 N > O � L m CO J y o m o o r a .- N F n .M o a o 0 0 CO >. M O N O O d O m Ym O CO O O . O W L L M ¢ U 0 C L O m CO V V b , v LL Q V Dm +ml O D O O N H b '1 a W O. II O D m m S 0 D Di J 0 O m .1 Y 0 O m m C 0 J J CO L 3 L O L CO ti Q i. a H g n m m m a b n > 0 .i 6 D N N E N N > CC O F U Q O 0 W J N h L CO 3 m CO O ¢ 3_ Q T b b .jm 3 L L 0 CO O W z to CO a m H a s o 0- en .. o i c 9 t- c m D D c N 6 O ¢ +1 F m O O O 0 '.1 m 0 0 CO 'N 1 0 O O m O +i 0 D 9 'N J L wZi L n F L Y m 9 m .� '.. D O' U J ~ F 0 E 0 0 0 0 2 Y CO CO E CO A W a O 0 M 0 CO 0 0 O +i 0 CO CO Y C T. L L ¢ 0 U 0 0 N O 1- U O O n a 6 x ill n > U 3 E a M o za o — U O O o2 0 b Wrr J 0 1- 2 O L co O W 2 a 3 J b t- 0 0 0 F0 d ~0 J CO W o O 0 CI) J f CO a In a a a 7 ¢ o Cm L m 0 co o 01 0 T O 0a co N 2 - O 0 O LL n N a 0 N J 0 0 0 O U .i a 01 0 0 0 0 0 0 J I— W L L 01 01 ; al M 9 q q 0 > 0 2 0 C 0 O N L 0 = Q y 0 in n N V 0 •- V 0I 0 0 O. +1 0 CO 0 01 N Al S• J 0 Y Y CO 0 01 0 CO CO 0 n 0 .- n to tu CC 0 2 L C L o m n o 0 o 0 o 0 LL W 0 9 to CO 0 .. 0 0 • T W 0. ill O V 0 m 2 N b 9 ~ N a J J CO0 L a n D L CO 0 0 .01 Q > 01 J 6 0 .m 0.9 ac co 6 E N N > O N >. Q ova W ≥ 0 co co N F a n > 0 V A 3 L w zz w C 0 n 3 o co to m f 6 6 O Q CO 0 2 C 9 L C 0 0 N CO 0 ..4 0 4- 0 n N 0 m ..i m 0 -CCV m ..i a a m O 0 0 0 0 0 Y 9 9 J c Y 1 F L 0 C) m 9 CO +1 .i 9 0' 0 I'- E O O 0 0 ..i CO 0 0 CO J 0 a 0 0 0 CO !) M `a A W M ~0 0 CO CO CO CO 0 b 0 0 /'. 2 U L n L Y C 3 0 LL L Q CO N O U G 6 Y W O U O O 0 0 2 E a 2 O Z a U a 0 0 0 0 m W J Co m m 2 O L CO 0 W 2 0 a J CO 1— CI a. O a V r 0 0 01 0 0 0 J CO N 0 co 7 F a _ 7 g o co C 0 0 p o 0 m 0 N e S J 0 2 0 on N M▪ 0 NI co N Y N 0 0 0 0 T 0 IL I- Cl 2 0 N J 0 0 0 0 0 '1 N o nq co0 a 0 40 O W L L 0) 0) 0 3 > ' a n n O L m N a 0 IO m 0 1D O O n ' O 01 0 0. 01 01 '.1 0 0 0 0 01 0 co 4- >. Y O N O O CO 0 M J 0 . . 0 6 P O J C .0 O q N n v V 0) 0 V W Is. V 1 O V O O O f to a '1 W 6 11 0 O 0 m a O 0 q < < < d CO 0 0 N n < J m. > 14 J 0 . 0.V 01 04 E — T cc 0 O H < 0 CO W 0 L y N N q 3 co J F>- 3 Q > 3 o V A 0 40. co Oz w < 0 .0 0 F L L 0VS CO03 0 0 ¢ .4C m w CO 0 0 V 00 CO 0 V V m L r. 1 m o .1 m m 0 ..4 ti 0 0 '1 CO +4 N L O. L N O VI V Y O V V 0 .C a ".1 E 0 N N 0 CO +i +4 0 S 0 -I F CO J 0 N 0 M ..4 CO CO S CO W < 0 0 N CO CO N m1 Y • A ^ 2q q q 0 0 +i 0 L N L Y C 3 .C LL L 6 0 0 0 CO N O F 0 0 O. ZU E Q O z a a 0 O CO m m W J 0 m 10 9 S O L N N CO 0 W 0 NO S J I- 0 0 O T J I- CI 0 Y JC W 0 00 y O H CO a a a < C 0 O o6 O 0 L 0 2 J 0 2 00 f 0 CO 0 NI CO V in N o O Y O O O LL F N Z 0 OS J 0 0 O 0 0 ,I am. N 0 0 C S et et O N 0 J 'I 0 N N I W C. L 0 0 3 0 a m d d O > Y V CO CO 0 2 CO C CO V 0 r O N L 0 J CO CO 0 0 0 0 0 0 0 N 0 O. +I 0 N 0 0 CO 0 2 CO J 0 F � Y Y 0 0 0 0 C CO 0 0 W L — 0 L 0 N V . +i W V CC LL 0 a 9 2. C O F F N T 0 04 0 04 > 0 +4 O O N N .-I W O. II 0 9 0 0 2 N A V 0 0 a < 6 .aOJ d 0 0 0 O N Cl. — a > 6 0 7 > L O.C . N O OP N N C 0 r 4 O CC W 0 CO . L 3 0 W CO ) 3 L > m 0 O 0 A A • L N B I. 2 4 T ; f l t C 2 W 2 W * N .0 C d d 0 Cr 0 0 Z C O L C 0 O 0 C L N < 0 ¢ ..I 0 0. C I, O 0 -I +I C 0 0 C +1 d m O +i O N 0 0 O e Y V V +1 = L N L O. F L N 0 C 0 CO +1 M V 0 0 ~ CO CO J Y. C J 00 2 0 0 0 Y CO• CO• 2 • A W „ O 0 CO CO 0 0 0 00 0 +I a 2 O L 0 0 I. N N 0 H 0 0 0. < 6 0 O N N 0 0 Y 0 N < Y 2 0 2 < O 2 0 0 2 O L m CO 0 W 2 O S 0 CO H O C 2 0 O < -.4T OJ a 0 0 J y F O CO J 2 L O Z W O O CO 0 F Ul a i ! Ei] ; U � $ a ohs ce . I CI) CD0 E 00 m E � z � �P E ° ot ET, r, -5,,,, .. C::, r� ® s g a w C � g . s - vi a9 b ww R q 'mow ! r w a - i 711.45) CD 8 x O co 8 % a N 42 ymU b CI "s & 6 gOO ® s 4g ,-; c cd S a �� M N A83 e I u o e----------------H .t,a O' � W R e W U o5 * a . E:, ,, a § 5 Wcow # [: . , 1 ,,4 ii w ~ 19 I 9 p Ci 1 a 44 O cn ~ 0 ce o• g w [-I F d v EEoqEl 5 A n z• c � a CI 3 1 ° a w W U Li 1 g § 9 * CO 8 M I �'] 9 F o a a a a _ 1 ! CD ; 0 ; I ZEI tet:6 k _ cx 4 who z A _ � 5 0a $ or, m z g _ Q 0.p a 7 aAg R. �� a E g z - l ❑ _ 0 o � o g Ww a a § A9 Eil A I _ , 9 Hello