Loading...
TR-2010-46 RESIDENTIAL FACTOR _ - �. ® ■ j�--o�Ic��(� �� d..�.�'�� �� � �-t��- - - — - `a �� TR-2010-46 A RESOLUTION ADOPTING A RESIDENTIAL FACTOR OF'.823121 PURSUANT TO MASSACHUSETTS GENERAL LAWS, CHAPTER 40, SECTION 56 WHEREAS, beginning in Fiscal Year 1989 the Agawam City Council began adopting residential factors of less than one (1) pursuant to Massachusetts General Laws, Chapter 40, Section 56; and WHEREAS, it is in the best interests of the residential taxpayers of Agawam to adopt a residential factor of less than one(1); and WHEREAS, it is in the best interests of the Town of Agawam to adopt a residential factor of.823 12 1; NOW THEREFORE, the Agawam City Council hereby resolves after conducting a public hearing to adopt a residential factor of.823121 pursuant to Massachusetts General Laws, Chapter 40,Section 56, DATED THIS DAY OF 2010. PER ORDER OF THEA:GAWAM CITY COUNCIL Donald M. Rheault, President APPROVED AS T FORM AND LEGALITY i;;rl Vincent F. Gioscia, Solicitor co TO-9610_49 Page I of_3 lam M PM AGAWAM 2011 Jurisdiction FiscalYear 2011 ,,-,, DGo LA4 VALUES FFCV PERCENTS Residential 2.134.419,640 Res% 79-35ii MRF 86,9941 Open Space 0 OS%0,0000 175% Shift 80AS12 Commercial 227.929.867 Corn% 8.4744 Chapter 3 0,0000 Industeial 221,513,330 Ind%8-2359 Historic Low%59,3317 Pers Prop 105,754,890 P P % 3.9320 Prior Res% 65,0408 Total 2,689�,617,727 Total% 100-0000 Lowest RIF 80�4912 OPENSPACE INPUT OPTIONS DISCOUNT Estimated Levy 0 Resid,Factor 0-825722 Selected 0 S 0,0000 Selected ,, -, Discount% CIP Slifft, "66"' �,l 70 0 S Factor 1.00000000 Single TR-0 SHIFT PERCENTS Res % 65.5274 Res TR 0 OS%0.0000 OSTRO Corn% 14J522 Com TR 0 Ind % 13.7540 Ind TR 0 P P%6.5664 PPTRO Total% 100.0000 REatDENTIAL EXEMPTIQN Total Res Value 2,134,419,640 Total Res 0 Avg Res Value 0 Parcel Count Avg Res Value 0 X Selected Res 0.0000 Residen.tial 0 Exemption% Exemption No,Eligible Res 0.0000000 Tot Res Value 0 Parcels minus Exempt SMALL COMMERCIAL EXEMPTION No,Eligible Com 0 Parcels Selected Com 0.0000 X Total Value of 0 Total Value to Exem% Eligible Pots be xempt Total C & I Value minus Exemption 449.443,197 Signatures Signatures for LA5 F (Board of Assessors) (Date) Comments: LA5 Certification liitn.,;://dIs,�ate�vay.dor.state.tiia.its/L)atewav/1)rivate/Webifornis/,ra.xRate/La5O1)tioils.aspx 12/22/2010 Page 2 o I") I hereby attest that notice was given to taxpayers that a public hearing on the issue of adopting the tax levy percentages for fiscal year 2011 would be held on (date), (time),at (place)� by (describe type of notice)- (Clerk) (Date) Comments-. We hereby attest that on (date), (time),at (place)a public hearing on the issue of adopting the percentages for the fiscal year 2011.that the Board of Assessors presented information and data relevant to making such determination and the fiscal effect of the available alternatives at the hearing and that the percentages set forth above were duty adopted in public session on (date). The LA-5 excess capacity is calculated as 5,514,315,33 We have beeninformed by the Assessors of excess levy capacity 5,563.8D5 Signatures for LA5 Certification For cities:City Councilors,Aldermen, Mayor For towns.,Board of Selectmen For districts: Prudential Committee or Commissioners '/A (Date) (Authorized Si Comment& L (Authorized Signalur (Date) Comments: (Authorized Signature) (Date) i--2-1 Comments: (Authorized Signature) (Date) Comments: (Authorized Signature) (Date) Comments: (Authorized Signature) (Date) Comments: tit,t,n,;://d1,,;ii�iicway.(lor.state.nia.t.is/L)�,,,itewav/Pi-ivate/WehFornis/TaxRate/La5Ot)tions.ast)x 12/212010 Pagc 3 of (Authorized Signature) (Date) 4 Comments* (Authorized Si (Date) gnatu Comments: View E �dit List No Errors found Status of TaxRalg�Fonrn View,Lastjjqdgjgr Information L—calculate Save -j Erintl (EED a r h t I nl�-Yd ki,.q levvnvf lor.san le-MA I I-Vv a lewl%'/T'ri vate/Web FornjS/1'axRate/l-,,]5 00tiolls.ast)x 12/2/2010 UAX RAUIES IFY 20 Cl till , WON wommmm )NEW mw�� RESIDENTIAL COMMERCIAL- INDUSTRIAL- PERSONAL PROPERTY e6 0 lul 0 - 22o32 Per Thousand Per Thousand Effective July 1, 2010-June 30, 2011 Office of the Assessor I v 0 330 010Z bug no 0, 12/03/2010 12:27 4137892427 AYRE REAL ESTATE CO PAGE 02/02 6L December 6, 2010 U Dear City Councilors, As a member of the West of the River Chamber of Commerce that represents businesses in Agawam, I wanted you to personally know I support the Chamber's position of reducing the "gap"' between what percent of overatt property taxes businesses pay compared to the percent of the towns over-all vatue made up of businesses. N e t0 AJ (Print) Sig ature X 1, �K-E7 C— Business Name -rAJ Business Address We am in need of a,someone to make a brief(one mImAe)re=k. If you are intemted,pleaw, i"cate on this form and we will be in touch with you, Tluank You, December 6, 2010 Dear City Councilors, As a member of the West of the River Chamber of Commerce that represents businesses in Agawam, I wanted you to personally know I support the Chamber's position of reducing the "gap" between what percent of overall property taxes businesses pay compared to the percent of the towns overall value made up of businesses. Name (Print) -ignature 6usiness Name Business Address We are in need of a someone to make a brief(one winute)remark. If you are intmsted,pJease indicate on this form and we will be in touch with you. Thank You. C., —d&11h;9sW11W.JEnbxv1 S,-ffVW1,rMPd1-1Y h&IMI fi1*$0LK16WWtkrfbrmd6c Wd cc:zt 0j0z C Ogg 689Z-98L—UV:xeJ 3NI S31HMONI AP 35 Springfield Street,Agawam, MA 01001 40� Phone:413.786.4454 Fax: 413.789.4240 penfieldprod.com HO Vi,d eo & Intercictive M December 6, 2010 Dear City Councitors, As a member of the West of the River Chamber of Commerce that represents businesses in Agawam, I wanted you to personally know I support the Chamber's position of reducing the "gap" between what percent of overalt property taxes businesses pay compared to the percent of the towns overall value made up of businesses. John M. Shanahan Name (Print) SigrjOure Penfield Productions, Ltd. Business Name 35 Springfietd Street, Agawam, MA 01001 Business Address December 6, 2010 Dear City Councilors, As a member of the West of the River Chamber of Commerce that represents businesses in Agawam, I wanted you to personatly know I support the Chamber's position of reducing the "gap" between what percent of oyeralt property taxes businesses pay compared to the percent of the towns overaL[value made up of businesses. Name (Print) Signature Business Name �M2 Business Address We are in need of a someone to make a brief(one minute)remark. If you are interested,please indicate on this form and we will be in touch with you. Thank You. C Wd to-'C1 OLOZ E 180 689Z-9qL-6LV-*xej ONI S318MON1 Ar 41MMO 1-435 r r OM-V A I M, December 6, 2010 Dear City CounciLors, As a member of the West of the River Chamber of Commerce that represents businesses in Agawam, I wanted you to personally know I support the Chamber's position of reducing the "gap" between what percent of overall property taxes businesses pay compared to the percent of the towns overall value made up of businesses. 1A KO-- Name (Pri Sig ture K—siness Name Business Address We are in need of a someone-to make a brief(one minute)remark. If you are intemqed, please indicate on this form and we will be in touch with you. nank You. C Wxwwnu Town of Agawam Assessor's Office -1837 36 Main St, Agawam, Massachusetts 01001 Tel. 413-786-0400 X258 Fax 413-786-9927 Email: assessor@agawam.maus To: City Council Members From: Kevin Baldini Date: October 27, 2010 Re: Classification Booklet Enclosed please find the"Tax Classification Booklet"prepared by the Assessors' Office on behalf of Mayor Richard A. Cohen. The Mayor has recommended a shift of 1.68,which results in a tax factor of 0.823121. The page in the booklet labeled"Comparative Tax Effect" is the best indicator of the effect this shift will have on the typical residential, commercial and industrial property in Agawam. For the comparison, three values have been selected that are close to the average class value for residential, commercial and industrial properties. These average values are shown in orange at the top left of each large box that represents the three classes of property. It should be noted that the overall values for each class of property dropped by approximately four percent, and that these average values are representative of this overall decrease, The smaller box on the left margin in each example shows what the average assessment would have been in Fiscal Year 2010 if it were not reduced by approximately four percent. The highlighted shift ofl.68 shows the effect the proposed shift would have on these properties in relation to the tax that would have been paid in FY 2010. The percentage difference in value for each of these properties from FY 2010 to FY 2011 is typical for the majority of properties in their respective classes, except for those properties that have had a change in their physical nature, such as an addition, demolition or other alteration. I will be present at the Classification Hearing scheduled for December6, 2010 to answer questions from the Council if need be. I would especially like to thank Charlotte Grondin, Administrative Assistant in the Assessors' Office, for her help in putting this book together. I hope that this information is helpful to you. If you need any further information, please feel free to contact me. Sincerel K on - As e 0 Cc: Mayor Richard A. Cohen IN It It kqj� S ""'m v W pe--% pe.--, ot L �g ir r .1A 10 -st gl\ Es TXX CLASSIFIC ATION FY 24,0" 1, 1 R OHEN MAYOR Rl.(`HA' D A. C ' gg Socioeconomic E county HAMPDEN School Structure K to 12 Form of Government +Mayor ****Council ****School Committee 2009 Population 28r616 2009 Labor Force 15r827 2008 Per Capita Income 25,384 Land Square Miles 23.24 Unemployment Rate +2009 8.1 Standard & Poor's Rating AA Services Moody"s Bond Rating Aa2 1FV 20n Tax Classification Tax Classification Tax Rate Tax Levy Assessed Values Residential 13-96 29,796,498 2r134,r419f640 Commercial 28.49 6,r493,722 227,929,867 Industrial 28.49 6r31Or915 221fS13,330 Personal 28.49 31012f957 10 5,7541890 Property Total 45,614FO92* 21689,617f 727 *Difference from proposed tax levy due to rounding 2011 CLASSIFICATION BREAKDOAVN PERSONAL PROPERTYVALUE 4% INDUSTRIAL 8% COMMERCIAL 8% E RESIDENTIAL 0 COMME RC LAL 0 INDUSTRIAL RESIDENTIAL 0 PERSONAL 80% PROPERTY CLASS PROPERTY VALUE RESIDENTIAL 2,134,419,640 COMMEIRCIAL 227,929,867 INDUSTRIAL 221,513,330 PERSONAL 105,754,890 FY20JLO AVG. SINGLE FAMILY TAX BILL RANK SINGLE OUT OF ASSESSED AVERAGE TAX FAMILY 337 MUNICIPALITY VALUE PARCELS VALUE RATE TAX BILL CITIES ,CHICOPEE 21001,94,000 101957 182,709 13.63 2�490 309 �S�P-R, I-N-GF-IEL-D 31�577-8�1§1#17 —25-1-986 137t7O9 19.50 21685 ---29i HOLYOKE 978,747,928 5,305 184,495 14.98 2,764 283 j�T 'AGAWAM 11733,143,600 7,�01 226, 12.94 21935t 262 §bUTHWICK 759,728,500 721982� 2�177-1'1 13.41 31424 -f9� Wff#IE-L-D �212-0-31-5-9'2180-0���--�91-30�O -23' 6-1-9,4- 14.68 3$478 190 WESTSPRINGFIELD 1143,770,600 6)447 223,945 16.00 31583 178 iEAST LONGMEADOW��I-,3-72�,3�771000 51265 260,660 17-38-- 41530 105 LONGMEADOW 9175-8 8-.281 61394 ---]4 TAX RATES SURROUNDING TOWNS FY2on PROPOSED TAX RATE $13.96Residenfial $28-49Commerdal municipality FY Residential Commercial Industrial AGAWAM 2008 11.74 25.64 2009 12.07 26.04 201LO 12.914 27.07 CHXCOPEE 2008 12.36 26.01L 2009 X3.20 28.12 2010 13.63 28.95 EASY LONGMEADOW 2008 16.06 16.06 2009 16.26 16.26 2010 17.3 8 17.38 HOLYOKE 2008 13.75 33.98 2009 14.24 35.15 2010 14.98 36.54 LONGMEADOW 2008 16.96 JL6.96 2009 17.11 17.JL I 2010 JL8.28 18.28 SOUYHWICK 2008 12.20 12.20 2009 12.55 12.ss 2010 13.44 13.44 SPRINGFXELD 2008 16.03 32.04 2009 17.89 36.98 2010 19-50 39.25 WEST SPFUNGFIELD 2008 14.28 32.61 2009 14.66 33.85 2010 16-00 34.69 WESTF ELD 2008 13.55 26.73 : 2009 13.94 27.61 20 J C% 3.4.68 28.60 COMPARATrVE TAX EFFECT TAX COMPARISON FY 2011 IFiscal Year 2011 ITYPICAL.COMMERCIAL PROPERTY 'Value 1p.-Oooi Fiscal Year 2010 Shit 1,65 1,66 1.67 176-81 1,69 1 1.70 1.71 1.72 1 1.73 1.74 1.75 Vain $558,700 Factor O.M24 0.828323 0.825722 0,823121 0.82052 10.817918 0,815317 0.812716 0.810115 0.807514 O.&M913 Tax Flate 27.07 Pate $27.99 $28.1 $M.32 $2B.49 $28.66 $28'.83 $29.00 $29.17 $29.34 $29.51 $29,68 Tax $15.124 Tax $15.059 $15,150 $15.236 $15,328 $15,419 $15.511 $15,602 $15.693 $15,785 $15,876 $15,968 ;Dfferenod 466 $26 $112 $295 07 $478 $569 $661 LEJ Fisca I Year 2011 �TYPICAL INDUSTRIAL PROPERTY Value 1 $832,9001 F isca I Year 2010 Shfft 1,65 1.66 1.67 1,68 1.69 170 131 92 1.73 1,74 135 �Lalua__$M4,900 Factor 0.830924 0,828323 0,825722 0.823121 0,82052 0,817918 0,815317 0,812716 0,810115 0.807514 1 0.&A913 iax Rate 27.07 Pate $27.99 $28.16 $28.32 $28.49 $28,66 $28.83 $29.00 $29.17 $29,34 $29.51 $29.68 Tax $23,413 Tax $23,313 $23,454 $23,588 1 $23,729 $23,871 $24,013 $24,154 $24.2% $24,437 $24,579 $24,720" Dfference -$100 $42 $Im- -!W16 $458 $600 $741 $883 $1,024 $1,166 $1,308 Fisca I Year 2011 !TYPICAL RESIDENTIAL PROPERTY )Lalue i i g2jNj Fimal Year 2010 Shit 1.66 1 M 1,67 [-1.68 1.69 1,70 1.71 1.72 1.73 1.74 135 Value Factor 0.830924 0.825722 0.823121 0.82052 10,8179181 0.815317 0.812716 1 0.810115 0.807514 0.804913 �_J_$227JOO O.B28323 Tax Rate 12.94 Pate $14.09 $14.05 $14.00 $13.96 $13.92 $13.87 W.83 $13.78 $13.74 $13,70 $13.65 Tax $2.94 $3.067 $3.059 $3,048 $3.039 $3,030 $3,0ig $3,ol i $3,000 $2.991 $2,982 $2,972- $112 $101 $93 $84 $73 $64 $53 $45 $36 $25 10/2612010 Town of Agawam 1:42:05PM ASSESSMENT CLASSIFICATION REPORT: LA4 Residential Open Cornmerciai Inclustrial Pers. Prope F—ar-c-e—isi I ciassi I Class2l I Class3-j L51 ILandType IlChaoter F—class4k F"clas 01: 7,6661 1,668,670,6001 02.- 1,5981 225,224,0001 Aisc Res: 151 3,965,1001 04: 4111 81,448,3401 05: 251 5,"5,3001 11-125: 601 '96,569,1001 30-32&'106-F— 7481 35,595,3001 1 00-299: 1 01 01 1 00-399: 1 3101 01 1 207,631,2961 100-499: 1 1621 01 1 1 218,60B,2001 CH61 Land: 6 41 01 1 86,8611 H61 A: 73 411 01 1 1,124,1161 CH61 B: 13 41 01 1 1,458,2991 12-043: 1131 17,501,9001 1 17,630,3051 2,905,1301 01: 4901 01 3,787,810 5 02: 3141 01 40,343,680 133: 41 01 18,480 04.550-552: 21 01 43,478,120 05: 21 01 1 10,404,200 06: 1 1 01 6,072,200 508: 61 01 1,650,400 Unvalid LUC: 01 01 ITAXABLE CLASS VALUES: 1 2,134,419,640 0 227,929,867 221,513,330 105,754,690 IRIE COUNT: 1 11,157 �E S�TA T LE TaA XMA B"LE: 2,583,862,837 EXEMPT COUNT:J 247 R/E EXEMPT VALUE: 368,638,044 RIE TOTAL COUNT- 11,404 R/E TOTAL VALUE: 2,952,500,881 P/P COUNT: 819 IPERS.PROP. TAXABLE: 105,754,890 11,976 ITOTAL RIE&PP TAXABLE VALUE] 2,689,617,7271 Luestions concerning this report should be directed to the following person-, 2 0 Name Title Dav-Tirne Phone# DEPARTMENT OF REVENUE MINIMUM RESIDENTIAL FACTOR COMPUTATION FOR FY 2011 AGAWAM City I Town/District Class Full and Fair Cash Percentage Valuation Share 1. Residential 2,134,419,640 79,3577% 79,3577�0/6 2. ODen Space 0 0.0000% 3. Commercial 227,929,867 8.4744% 20.6423=/6 4. Industrial 221,513,330 8.2359% 5. Personal Propertv 105,754,890 3,9320% TOTALS 2,689,617,727 100.0000% Maximum Share of Levy for 150% X 20.6423% 30.9635% Classes Three, Four and Lines 3C +4C + 5C Max % Share Personal Property : Minimum Share of Levy for 100% 30.9635% 69.0365% Classes One and Two : Max % Min % Sh Minimum Residential Factor 69.0365% 1 79.3577% 86.9941% (MRF) Min % Share Lines 1E+:=2C Minimum Residential Factor MINIMUM RESIDENTIAL FACTOR 86.99 LA7 (6-96) Chapter 58, Section 1 A mandates a minimum residential factor of not less than 65 oercent. Date. 10/26/2010 138 pm Page I of 1 TAXFLA7 CALCULATION OF THE LOWEST POSSIBLE RESIDENTIAL FACTOR CHAPTER 200 FOR FY 2011 AGAWAM 1. Last year's chosen residential percentage (R)*. 65.0408% 2. This years MRF using a 150% shift to CIP (from LA-7). 86.9941% 3. Minimum residential share(R) in current year using 150% Shift to CIP. 69.0365% If#1 is greater than#3, STOP! You may shift only up to 150% to CIP and#2 remains MRF. If#3 is greater than #1, go on. 4. Calculate a residential factor using a 175% shift to CIP. 80.4912% 5. Multiply this new residential factor by this years FFCV residential 63.8760% percentage (R). 6. What is the lowest historical residential percentage since the first 69.3317% certification (R). If#5 is greater than #6, STOP! You may shift up to 175% to the C/P and#4 is the Lowest Residential Factor. If#6 is greater than #5, go on. 7. Take the lowest historical residential percentage, #6 divide it by the current residential percentage at FFCV the result is the lowest residential factor allowable (it may not be less than 50%). 8. Multiply that factor by FFCV of the open space, add the new R% and 0% shares, take 100% minus (R + 0)% total to equal the new maximum CIP percentage share 9. Divide this new maximum CIP share by FFCV of CIP share to determine the percentage of shift, (this may not be more than 175%). Consider Residential only, not R & 0 together. Date:10126/2010 3:39 pm Page 1 of I Share F%m*ntagn Levy Anmounts Estirnated Tax Rifts CIP Res What ff..Scenario Worksheet Shift Factor Res CIS com Ind PP Total Res os corn Ind PP Total Res 0S Com Ind PIR CLASS VALUE % 1.01 997399 791513 0-DDDD 8.5592 8.3182 3.9713 1 DM0000 38.107,541 0 3.9D4,5W 3,794,639 1.811.637 45.618,376 1692 17.13 17.13 17.13 Res 2,134,419,640 79.3677% R&0% 1.02 99.4798 76.9"9 O,DDOD 0.6439 8AW6 40106 100 ODOO 36.013,375 0 3,943,217 3.832,210 1,829.574 45,618,375 1687 il,10 17.30 17.30 08 0.0000% 79.3577% 1.03 ".2107 M7385 0 000D B1287 8,4029 40499 100 OODO 35,919,2D8 0 3,981,876 3,869,781 1,547.511 45,018,M 16 B3 17.47 17.47 17.47 COM 221r,929,867 8.4744% 1.04 98.9595 78,5320 00= $0134 8.5653 4002 100 ODOO 35,825,041 0 4.020,SU 3,907,261 1.865.448 45,618,375 16.78 17.64 17.84 17.64 Ind 221,613,3301 8.2359% C I P% 1�05 98.6994 1 78.3256 0 00W 8.8992 8.6477 4 1288 100 0000 35,730,875 0 4.059,194 3.944.922 1.883,385 45,618,375 1674 17,81 17.81 17.81 PP 105,754,890 3.9320% 20.6423%1 1.06 984393 78 1192 0 WW 8.9M 8.730D 4,1679 100 ODDO 35.636,7DO 0 4,097,853 3,982.493 1,901,322 45,S'S,375 1SL70 17.98 17.98 17.98 Total 2,689,617,727 100.0000% 1.07 98.1792 77.9128 0 ODOO 0X676 8�8124 42072 100.00oo 35,542,54 1 0 4,1343,512 4,020.OM 1.M.259 45,618,375 16,65 18.15 18.15 18.15 PAGE DOWN TO COKNLL��j I.D8 971191 77.7(XA 00000 9.1524 88947 4.2465 100MW 35,449,375 0 4.175,171 4,057,634 1,937.198 45,818.375 1661 18.32 18.32 18.32 CLASSIFICATION OPTIONS 1.09 97.65W 77 4M 0.0000 9.2371 8.9771 4.2858 1000000 35,354.208 0 4.213,830 4,095,205 1,955.133 45,1818,375 16.56 18.49 18,49 18.49 1.10 07.39M 77.2935 0.0DD0 9.3219 90595 4.3252 100.0000 35,2W.041 0 4,252,489 4,132,T75 1,973,070 45,618.375 1652 18.66 18.60 1066 Realdential Eze=pt im 91,1387 77,0871 0.0000 GIA066 91418 4,3645 1DO.ODDO 35,165.875 0 4,291,148 4,170.346 1,991,007 45,618,375 1648 1683 18.83 M83 Snmll Commerabd 1.12 9&87W 76 SM? 0.00W 911914 9,2242 4.4038 IDD,00M 35,071.708 0 4.329,SD7 4,207,VY 2,W$.944 45.$18.375 1643 19.00 19.00 19.00 ExernPH01% 1.13 96.6185 7&6742 0'0= IDL5761 91M5 4,4411 10000D0 34.977,541 0 4,3W,466 4,245,487 2,026.1181 45,618,375 1639 19.17 19.17 19.17 LEVY 1.14 96.3514 76,4678 O.DOOO 9 6WO 9,3889 4.4824 IDD.0000 34,883.375 0 4,407,125 4,283,058 2,044,818 45,618,375 16.34 19.34 19.34 19.34 1.15 96.0983 76.2614 0.D000 97456 9,4712 4.5218 1100.00DO 34,789,208 0 4,"5,764 4,320,629 2,062.755 45,618,375 16.30 19.51 19.51 19.61 S",618,375 FArtimlated Levy 1,10 95.8381 78.0550 OOOOD 98303 9.5536 4.5611 WD.0000 34,1595.041 0 4,484,443 4,358,200 2,08D.692 45,618,375 1626 1967 10�67 1087 16.96 Singto Tax Rate 1.17 95.578D MaM 0 00W 0,9151 9.6360 4.6004 100.0000 34,BW,875 0 4,523,102 4,395,7-70 2,DW,620 45,618,375 1621 19.84 19.84 19.84 1.18 95.3179 75.8421 OOM AgM 27M 46397 t00.00l)o 34,5W,70$ 0 4,561,761 4,433,341 2,1W5W 45,618,375 18.17 20.01 20.01 2D.01 Note: This table should be used for planning 1.19 W0578 75.4357 00000 100046 SAW 4AM 100.0000 34,C2,54i 0 4,6W,420 4,470.912 2.134.503 45,618,375 16.12 M 18 20.18 20.18 purposes only.Actual calculations may 1.20 94,7977 75.2293 D.ODDO 10,1693 9.6830 4.7184 100.00DO 34,318,375 0 4,639.079 4,500,482 2,162,440 45,618,375 1608 20.35 20.35 20,35 differ slightly due to rounding.For actual calculations,complete Recap. 1.21 W 5376 750229 0.0000 10.2541 9.9654 4.7577 100.0000 34,224.208 0 4,BT7.738 4,546,053 2.170.377 45,618,375 16.03 20.52 20.52 20,52 1.22 942774 74,8164 O.ODDO 10.3388 10.047: 41970 1DO.D000 34,130.041 0 4,71$,397 4,583,624 2.168.314 45,818,375 15.99 2069 20-69 2069 113 94.0173 74,61DO O.ODDO 10.4236 10.130 4,8393 1DO.DOOD 34,035.875 0 4,755.056 4.621,194 2,206,251 45,615.375 1515 20,06 20M 2086 1,24 $3,7572 74.4036 0.00W 10.50113 10.2125 48756 100.. 33941,708 0 4,793.715 4,658.765 2.224,187 45,M,315 5�w 21.03 21,03 21.03 11,251 93.4971 1 74.1972 1 0.0000 1 10.5930 110.2 MW:8 M. 100t000l 33.4M7.5411 01 4.1132,37,61 4.6W,3W1 2.242,1241 45.618,37] 115,86 1 21,201 21,201 21.201 Page I of 4 1012W70110 1:43 Pm Share Percentages Levy Amounts Estimated Tax Rates CIP Res What If-Scenario Worksheet SIM Factor Res OS Com Ind pp Total $401 05 Corn Ind PIP ToIal Res IDS Com Ind pp 126 932370 73.M7 0 OODD 10.6770 10.3772 4.9543 100 ODOO 33,753,375 0 4.871,033 4,733,906 2,260.061 45,618.375 15.81 21.37 21,17 21�37 1.27 92.97439 73.7843 0 ODDD 10,7625 10.4595 4,9936 100 DDOO 33,650.20B 0 4,9W692 4,T71.417 2,277.9M 45,610.375 15.77 21�54 21,54 2tS4 128 92.7167 73.5T79 00000 10.8473 10.5419 5.0329 1000000 33,565.041 0 4,945.351 4,8M�NS 2,295.935 45,618,375 15,73 213l 2 1.71 21.71 1,29 92.4566 73.3715 0 ODOO 10.9M 10.6243 5,0722 100,ODDO 33.47D.875 0 4,087.010 4,846,618 2,313,872 45,618,375 15.68 21,98 21M 211B 1.30 92.1965 73.1651 O,ODOO 11.0168 10706$ 6,1116 100,OWO 33.a76,708 0 5,025,669 4.U4.189 2,331,8Dg 45.618,375 16,04 22M 22.05 22.D5 1.31 91.9364 72,9W O,OOW 11,1015 10.7890 5.1509 1000000 33,2a2,541 0 5.064,320 4,921,76D 2,349,746 45,018,375 1559 22.22 22,22 22.22 1.32 91.6763 72.7522 0 ODDO 11.1863 10.8713 5.1902 100.ODOO 33,188,375 0 5.102,987 4,959,33D 2,367,683 45�818.375 1555 22.39 22.39 22.39 1.33 91,4162 723455 D ODDO 11.2710 10.0537 5.2295 100.ODDO 33.094.208 a 5.141,W 4,9%.901 2,395,620 45,618,375 15.51 22.56 22.56 22.W 1.34 91.1560 72.3394 D.DDOO 11.3557 11.0361 5.2680 100,ODDO 33.000.041 0 5,180,304 5,034,472 2,403.557 45,1318,375 15,46 22,73 22,73 22.73 1.3.5 906959 72.1329 0 ODOO 11.44D5 11.1184 5.3M 100 ODOO 32.906,075 0 5.218,963 5,072.043 2,421.494 45,610,375 15.42 22.90 22.9D 22.90 1.36 90A368 71,v765 0,DDOO 11-5252 il,7WO 51415 100,0000 32.811.708 0 5,257,622 5,109,613 2.439,431 45,616.375 15.37 23.07 23.07 23.07 1.37 903757 71.7201 00000 11.6100 11.2831 5.3888 1000000 32.717,541 0 5,296,281 5.147.154 2,457,360 45,619,375 15.33 23.24 23,24 23,24 1.38 90.1166 7 1.5137 O.ODOO 11.6947 il3655 5,4261 1000000 32.623,375 0 5,334,940 5,184.755 2,475.305 45.618,375 15.28 2341 23,41 2341 1.39 89.8555 7IM72 0.0000 11.7795 114479 5.4654 100 ODOO 32.529,200 0 $,373,699 �,M,325 2.493,242 45.618,375 15.24 23,% 23�58 2358 1.40 89,59W 71.10DB O.DDOO 1 I.SM2 11 r5302 5,5048 WO ODDO 32,435,041 0 5,C2.258 5.259,896 2,511,179 45.618,375 15.20 23.75 23.75 23.75 1.41 891352 708944 0.0000 11.9490 111,$126 5,6�"i 100 ODOO 22,340,875 0 5,450.917 5.297,4137 2,529.116 45,618,375 15,15 23.91 23.91 23.91 1.42 89.0751 XBM 0 OOM 12.0337 11,6949 5.5&U 1000000 32.246,708 D 5.489,576 5,335,037 2,547,053 45,618.375 15.11 24.06 24.08 24.08 1A3 88.8150 70.4816 O.00OD 12.1184 11.7773 5.6227 100,ODOO 32.15Z541 0 5.528,235 5,372,606 2,564.9W 45,618.375 15.05 24.25 24.25 24.25 1," 88.5549 70.2751 O.00DO 12.2032 11 M596 5.6M 10O.ODDO 32.0m.374 0 5,566,894 5,410.179 2,582.927 45,618.375 15.02 24A2 24,42 24.42 1,45 88.2948 7D.DS87 O.00DO 12.2679 11.942D 5.7014 1000000 31.954,208 0 5,605.553 5,447.749 2.6W.854 45,618,375 1498 24.59 24.59 24.50 146 88.0346 69.8623 0.0000 12.3727 120244 5.7407 1000001) 31.870,041 0 6'e".212 5,485.320 2,615.8Dl 45.618,375 14r93 24.76 24.76 24.76 1,47 37.745 69.6559 O.00DO 1 2.4574 12.1067 5.78DO 100,00DO 31.775,874 0 5,682,871 5,522.891 2,63B.730 45.618,375 14,80 24.93 24.93 24.93 11AS 87�5144' 69."94 O.ODDO 12,5422 12.1891 58193 100,0000 31,681,708 0 5.721,530 5,560,461 2,&r,4,875 45.618,375 1484 25.10 2510 2510 1.40 87154S 692430 0.0= 12 W69 12,2714 5 85W 100 OOW 31,47,541 0 5.760,189 5,5M.Da2 2.672,612 45.618.375 14M 25.27 25.27 2527 LL5-0 SO.M2 690366 0.0000 12.7117 QrM$ 5 agao 1000000 31,403,374 0 5,798,8481 5,M.6D31 2.690,5491 45,61a.3751 14.76, 25." 25" 2544 Page 2 of 4 1012WO10 1:43 PM Share Percentages Levy Amounts Estimated Tax Rate* CIP Res What If..Scenario WOrkSheet Shtft Factor Res OS Com Ind Pp Total Res Os Com Ind pp Total Res OS Com Ind pp 151 067341 6a OW2 0 DODD 12.7964 124362 5,9373 IWOM 31,399,208 0 5,537,507 5.673,174 2.708,486 45,618.375 14.71 25.61 25.61 25.61 1.52 864739 68.6238 O.C= 129811 t2.5185 5.9766 100,ODDO 31,305,041 0 5.876,186 5,710,744 2,726,423 45.618,375 14.67 25.78 2575 257B 1.53 882138 68.4173 0.0001) 12.9559 126009 6.0159 100,0000 31,210,874 0 5.914,825 5,748,316 2.744,360 45.618,375 14.62 2595 25,95 2595 1,54 85,9537 68.21 D9 O.ODDD 13.0506 124832 6.0552 10D.DDDO 31,116,708 0 5.M,484 6,786�8W 2.762,297 45,618,375 1438 26.12 2012 20L12 1.55 85.6936 68.0045 0.0" 13.1354 12.7656 6.0945 100 ODOO 31,022,541 0 5,992.143 5,1123A56 2.780,234 45.610.375 14.53 2629 2629 2629 1,56 a5.4335 67.7981 OrOODD 112201 12,84W 6.1339 100,OWO V.028.374 0 6.030,802 5,851,027 2,798.171 45,8111,375 14.49 2BL46 2648 2648 1.67 85 1734 67-$qi$ 0 ODW 13 3o4g 12,0303 6 M2 iWOOM 30,834,200 0 6.DS9,461 5,8W.598 2,816,108 45,1310,375 1446 26.63 26.63 26.63 1.58 84.9132 67.1852 OLOODD 13.3896 13 0127 6.2 125 100 ODDO 30,740,041 0 6,11011,120 5,936,168 2,834.045 45,618.375 1440 26.BO 26.110 26.6D 1.59 64.6531 67.17118 00000 134743 13.0950 8.2510 100.ODDO 30.645.874 0 6,146.779 5,973.739 2�851.982 45,618.375 1436 26.97 26.97 26.97 1.60 84.3930 56.9724 0 ODOO 115591 13-1774 6.2911 100 ODOO 30,551,708 0 6.155,438 6,011,310 2.869.919 45,618,375 1431 27.14 27,14 27.14 1.61 04.1329 68.7669 0 ODDO 13.643B 132597 6.3305 100 ODDO 30,457,541 0 6.224,D97 8,M.880 2,887,856 45.618,375 1427 27,31 27.31 27.31 1.62 63.8728 66.5595 0 ODOO 13.7286 133421 6.3698 100,ODW 30.3,63,374 0 6.262.758 6,W6.451 2.905,793 45,618,375 1423 27,48 27.48 27,48 14a $3 0127 $63531 OWN) 13al3a 13 4245 6,4091 100 ODDO 30,269,208 0 6.301,415 6,124,022 2.923,730 45,618,375 14AS 27.65 27.65 27.65 1.64 63.3525 66.4467 00000 138981 115088 6.4484 1000000 3D.175,041 0 6,340,074 6,161,592 2.941,667 45.816,375 14.14 27,82 27.82 27.82 1,65 83.D924 55.9403 0 ODW 119825 i15M 6.4877 100 ODDO 3D.080,874 0 6,378,M 6.199.163 2.959,8W 45,618,375 14.09 27.99 27.99 27,99 1.66 82.8323 85.7338 0 ODDa 14 OB76 136715 6.5271 100,ODOO 29.986,708 0 6,417,392 8,236,734 2.977,541 45,818,375 14.05 26,16 70,10 29A6 1.67 82.5722 65.5274 0 ODDO 14.1523 13.7539 6.5664 100 ODOO 29,892.541 0 6.456,051 6,274.304 2,995,478 45,615.375 14.00 2832 2832 2832 148 62.3121 65.3210 O,ODDO 142370 138363 66057 100 OOW 29.M,374 0 6.494,710 6,311.875 3,0113.415 45,610,375 13.96 2849 2849 2849 169 62,052D 65J146 0 M 14 321a 139160 66450 1000000 29.704,208 0 6,533,369 6,349."8 3,031.352 45,610,375 13.92 2866 2865 2866 1.70 gi,7918 64L9081 OMW 144065 140010 6.6843 100 OODO 29.610.041 0 6,572,028 6.387,017 3,049,200 45.618,375 13.87 2883 2863 28M 1.71 81.5317 64.7017 O.DDOO 144913 14 OM 6.7237 1000000 29,515,674 0 6.610.687 6,424.5$7 3,087�M 45.818,375 13.83 29DO MOO 2900 1.72 81.2716 644953 O.ODOO 145760 14A657 6.76W 1000000 29.421,706 0 6.649,346 6.462,M 3.M,163 45.818,375 13.78 29.17 29.11 29-17 1.73 81.0115 642889 0.00W 14,6608 142480 6,6023 100 ODOO 29,327,541 0 6.608,005 6,499,729 3.103,100 45,618,375 13.74 29.34 29.34 29.34 1.74 $0,7514 64,0825 O.00DO 14,7455 1*3304 6.8416 100 ODDO 29233374 01 :�.7261W 6537299 3 121 D37 45618375 13 70 2961 29.51 29.51 0 .765.3 1 1 1 1.75 W.4013 83,8760 0.0000 14.8303 14,4128 OAM 100 ODD01 29'139'2Wl 231 6'574'870 1 3'138'9741 45'.618'375 3"95 L29,W 7940 2968J Page 3 of 4 10/2&2010 1143PM Ig INS or e"',', 10 "T'r-o' �W '\111- b r,,g ,g\a X" "'a TAX CLASSIFIC"ATION' FY 201- 1 I' M RICHARD A. COHEN, MAYOR Socioeconomic County HAMPDEN School Structure K to 12 Form of Government +***Mayor ol*'*Council *#*+School Committee 2009 Population 28r616 2009 Labor Force 1Sr827 2008 Per Capita Income 25f384 Land Square Miles 23.24 Unemployment Rate 40#2009 8.1 Standard & Poor's Rating AA Services Moodv"s Bond Rating Aa2 jx%�POSED FY20jLjL Tax Classification Tax Classification Tax Rate Tax Levy Assessed Values Residential 13.96 29r796,498 21134,419r640 Commercial 28.49 6r493r722 227,929,867 Industrial 28.49 6r31Of915 221,513,330 Personal 28.49 31012,957 105,754r890 Property Total 45,614rO92* 216891617r727 *Difference from proposed tax levy due to rounding ri ir A 2011 %.LASSIFICATION BREAKDOAVN PERSONAL PROPERTYVALUE 4% INDUSTRIAL 8% COMMERCIAL 8% RESIDENTIAL 0 INDUSTRIAL 0 PERSONAL SIDENTIAL 80% PROPERTY CLASS PROPERTY VALUE RESIDENTIAL 2,134,419,640 COMMERCIAL 227,929,867 INDUSTRIAL 221,513,330 PERSONAL 105,754,890 FY2010 A v G. SINGLE FAMILY TAX BILL RANK SINGLE OUT OF ASSESSED AVERAGE TAX FAMILY 337 MUNICIPALITY VALUE PARCELS VALUE RATE TAX BILL CITIES CHICOPEE 21001-�9-4-41-00-0 -1019-57 182,709 13,63 21490 309 --­_ --- -� . --- L _--- - -L sit 11 S I"Ril �'l�L D" 3157815011400 25,986 13717091 19.. 216851 291 �HOLY- OK-E 97817471928� 5A5 184,495 14.98 21764 283 IAGAWAM 1,733,143,60 71 0 226,800 12.N 21935 262 ti . - , . _ - _ X � I _ -. - -- 1� - - ll-�- -6f- I .-- ��OUTHWICK 759;728,500 21982 2�1771 13.4 31 198 �WESTFIELD --2120315921800 91300 236,945 468 31478 190 IWEST SPRINGFIELD 1)��31t-1600 61447 223,945 16.00 3-1 5-'8- 178 EASTLONGMEADOW � '11372j377,000 51�65� 26016�-O -'-1 7-.38 - -4 1 5-3-0 -l"-0 5� -�14319 28- 1 4 LONGMEADOW -119021�3�,��OF 5,439 �9,7 18. TAX RATES SURROUNDING TOWNS FY2on PROPOSED TAX RATE $13.96Residential $28-49Commercial MunicipalitV FY Residential Commercial Z Xndustrial AGAWAM 2008 11.74 25.64 2009 12.07 26.04 2010 12.94 27.07 CHICOPEE 2008 12.36 26.01 2009 13.20 28.12 2010 13.63 28.95 EAST LONGMEADOW 2008 16.06 16.06 2009 16.26 16.26 2010 17.38 17.38 HQLYOKE 2008 13.7S 33.98 2009 14.24 35.15 2010 14.98 36.54 LONGMEADOW 2008 16.96 16.96 2009 17.11 17.11 2010 18-28 18.28 S40UTHWXCK 2008 12.20 12.20 2009 12.55 12.SS 2010 13.44 13.44 SIMFUNGFIELD 2008 16.03 32.04 2009 17.89 36.98 2010 19.50 39.25 WEST SPRXNGFIELD 2008 14.26 32.61 2009 14.66 33.85 2010 16.00 34.69 WESTFIELD 2008 13.SS 26.73 20091 13.94 2 7.6 1 20101 14.68 28.60 COMPARATIVE TAX EFFECT TAX COMPARISON FY 2011 jFisml Year 2011 TYPICAL COMMERCLAL PROPERTY Value B10-0-0 Fiscal Year 2010 �S=hit 1.65 1.66 1.67 1.68 1.69 1,70 1.71 1.72 1.73 1.74 1.75 y=alu O.M24 0.828323 0.825722 0.823121 0.82052 0.817918 0.815317 0.812716 0.810115 0,807514 O.M913 Factor Tax Rate 27,07 Rate $27.99 $28.16 $28.32 $28.49 $28.66 $28.83 1 $N.00 $29.17 1 $29.34 $29.51 $29,68 Tax $15,12�4] Tax $15.059 $15.150 $15,236 $15.328 $15,419 $15.511 $1502 $15,693 $15.785 $15,876 $15,968 Dff erend .$65 $2 $112 $204 $295 $387 ws $569 $661 $75i ji4 Fisca I Ye a r 2011 IYPICAL INDUSTRIAL PROPER Y Value Fiscal Year 2010 ShA 1,65 1,66 1.67 -1.68 1.69 1.70 1.71 1.72 1.73 1.74 1.75 Value $864�900 �actor 0.830924 0.828323 0.825722 0.823121 0.82052 0.8179181 0.815317 0.612716 0.810115 0,807514 HUM Tax Rate 27.07 �Ge $27.99 $28.16 1 $28.32 $28.49 $28-66 $28-83 $29.00 $29.17 SN.34 $29.51 $29.68 Tax $23,413 jax $23,313 $23,454 $23,5W $23,729 S23,871 $24,013 $24,154 $24,296 $24,437 $24,579 $24,720 J'Dfferenc� -$IDO $42 $175 $316 $458 $6w 1 m $1,024 $1.166 $1.308 Fisca I Year 2011 ITYPICAL RESIDENTIAL PROPERTY J�Lalue $217,700' Fisca I Year 2010 It 1.65 1.66 1.67 1,68 1.69 UO , 1.71 1.72 1.73 1.74 1.75 Value 700 1 Factor O.M24 0.828323 0.825722 0.823121 0.82052 0.8179181 0.815317 0.812716 0,810115 0.807514 0.8N913 _J� Tax Rate 12.94 Rate $14.09 $14,05 $14.00 $13.96 $13.92 $13.87 $13.83 $13.78 $13.74 $13.70 $13.65 Tax $2,94 1 Tax $3.067 $3,059 $3,048 $3,039 $3,030 $3,019 $3,011 $3,DOO $2,991 $2,982 $2,972 Dfferenc�' $121 $112 $101 $93 $64 1 $73 1 $64 $53 $45 $36 $25 10125/2010 Town of Agawam 9:51:5:1 AM ASSESSMENT CLASSIFICATTION REPORT: LA4 RENOWN Upen t5oace Commercial Industnal.11,111 vers.- rope[ M5'ndTvpe FP—arce-1sj Class2 Class 01: 7,6661 1,668,670�6001 1 WS, T- 02: 1,5981 225,224,0001 1 MISC Res: 5 3,965,1001 A- 1 0-4: 4111 81,448,3401 05: 251 5,445,3001 1 I Ili-125: Sol 96,569,1001 1 30-32&106,1 1 7481 35,595,3001 1 1 2 00-299: 01 01 1 1 ;00-399: 3101 01 1 207,631,2961 0-499: 1621 01 1 1 218,608,2001 CH61 Land, 6 1 41 01 1 85,8511 HSI A: 73 411 01 1 1,124,1161 H61 8: F--13 41 01 1 1,458,2991 12-043: 1131 17,501,9001 1 17,630,3051 2,905,1301 01: 4901 01 1 3,787,810 .L502: 3141 01 1 40,343,680 3: 41 01 1 18,480 04.550-562: 21 01 43,478�120 06: 21 01 1 10,4�04,200 0 0 3 4 6 5 106: 1 01 6,072,200 8 08: 61 01 1 1,650,400 v nvalld LUC: 01 01 E��XABLE CLASS VALUES: 1 2,134,419,640 0 227,929,867 221,513,330 105,754,890 I R/E COUNT: .j 11,157 REAL ESTATE TAXABL" 2,583,862,837 JEXEMPT C2kLTj 247 R/E EXEMPT VALUE: 368,638,044 R/E TOTAL COUNT: 11,404 R/E TOTAL VALUE: 2,952,500,881 Fp—iPCOUNT: 819 IPERS. PROP.TAXABLE: 105,754,890 FTk—*l 3 L E 11.976 T AL RIE&PP TAXABLE V 2,689,617.727 Questions concerning this report should be directed to the following person: Title Dav-Tirne Phone DEPARTMENT OF REVENUE MINIMUM RESIDENTIAL FACTOR COMPUTATION FOR FY 2011 AGAWAM City/Town/District A B C Class Full and Fair Cash Percentage Valuation Share 1. Residential 2,134,419,640 79.3577% 79.3577 2. Open Space 0 0.0000% 3. Commercial 227,929,867 8.4744% 20.64 4. Industrial 221,513,330 8.2359% 5. Personal Prooertv 105,754,890 3,9320% TOTALS 2,689,617,727 100.0000% Maximum Share of Levy for 150% X 20.6423% 30.9635% Classes Three, Four and Lines 3C + 4C + 5C Personal Property : I I Max %Sha:re::] Minimum Share of Levy for 100% 30.9635% 69.0365% Classes One and Two : Max % Share FMin %Shar Minimum Residential Factor 69,0365% 1 79.3577% 86.9941% (MRF) Min %�hare Lines 1C + 2C Minimum Residential Factor MINIMUM RESIDENTIAL FACTOR F 86-9 LA7 (6-96) Chapter 58, Section 1A mandates a minimum residential factor of not less than 65 vercent. Date: 1012512010 11:39 am Page 1 of 1 TAXFLA7 CALCULATION OF THE LOWEST POSSIBLE RESIDENTIAL FACTOR CHAPTER 200 FOR FY 2011 AGAWAM, 1. Last years chosen residential percentage (R)*. 65.0408% 2. This years IVIRF using a 150% shift to CIP (from LA-7). 86.9941% 3. Minimum residential share (R) in current year using 150% Shift to CIP, 69.0365% If#1 is greater than #3, ITOP! You may shift only up to 150% to CIP and#2 remains MRF If#3 is greater than #1, go on. 4. Calculate a residential factor using a 175% shift to CIP. 80.4912% 5. Multiply this new residential factor by this years FFCV residential 63.8760% percentage (R). 6. What is the lowest historical residential percentage since the first 69.3317% certification (R). If#5 is greater than#6, ITOP! You may shift up to 175% to the C/P and#4 is the Lowest Residential Factor. If#6 is greater than #5, go on. 7. Take the lowest historical residential percentage, #6 divide it by the current residential percentage at FFCV the result is the lowest residential factor allowable (it may not be less than 50%). 8. Multiply that factor by FFCV of the open space, add the new R% and 0% shares, take 100% minus (R + 0)%total to equal the new maximum CIP percentage share 9. Divide this new maximum CIP share by FFCV of CIP share to determine the percentage of shift, (this may not be more than 175%). Consider Residential only, not R & 0 together. Date�10/25/2010 11:57 am Page I of I What ff-Scenario Worksheet ----0 CLASS VALUE % 01 99.7399 79.1513 0,0000 8.5592 8.3182 3.9713 iOD.0000 36,107.541 0 3,GO4.558 3,794,639 1,811,637 45,618,375 16.92 17.13 17.13 17,13 Res 79.3577% R&0% 02 994798 70.0449 O.DDOO 8.6439 BADD6 4.0106 100.00DO 36.03,375 0 3,943.217 3,832,210 1,820,574 45,61a,376 16 a? 17.3D 17.30 1730 08 0.0000% 79.3677% 1.03 99,2197 70.7385 o oDDo a.72a7 a 4629 4.0499 1000000 35,919,208 0 3,981,876 3,869,781 1,847,511 45,60,375 16.03 17.47 17,47 17L47 01 99 7399 79 1 tR&PO 102 994798 70 0 1 78 103 992797 7 Com 8,4744% 1.04 W9595 M5320 0 ODW 88134 85853 4.0892 IDD.00DO W,a25,041 0 4,02D.535 3,907,351 1,00.448 45,618,375 16.78 17,64 176.4 17.64 Ind 8.2369% C I P% 1,05 986994 781256 00000 8.8982 86477 4.1288 10D.ODDO 35,73a,675 0 4,059.194 3.W.922 1.983,385 45.616,375 1874 17LB1 17.81 17.81 PIP 1.06 98,4393 78.1192 0 DDDO 8.9829 8.73DO 4,1679 1DD.ODOO 35,636,708 0 4,097.853 3.982,493 1,9G1,322 45.618,375 16,70 17.98 17.98 17,98 Total 1,07 98.1792 77,9128 0 ODOO 9,0876 88124 4.2072 100,DDDO 35,542,541 0 4.136,512 4,020,063 1,919,259 45.618,375 1665 18.15 18,15 18.15 PAGr;DOWN TO OOMMMM ENIBY 4 j 1,08 97.019, 77.7064 00000 9.1524 8 B947 4,2465 100 OOM 35."8,375 0 4.175,171 4.057,634 1,937,196 45,618,375 1661 18.32 18.32 le 32 CLASSIFICAT(ONOP77ONS 1.09 S7 659D 77AM 00000 9.2371 80771 4.2&% IWOODO 35,354,208 0 4,213,830 4,095,205 1,955,133 45.618.375 1656 18.49 18,49 1949 mO 07,39W 77,2935 0 ODOO 9.3219 9LO595 4A252 1000000 35,26D.D41 0 4,252,489 4,132.775 1,973,D70 45,616,375 16.52 1866 1866 1 B.66 Residential Exempt 1.1i W�i 387 77,0871 00000 9.4056 9.1418 4.3645 100.0DOO 35.165,875 0 4,291,148 4.170.346 1,991,007 45,618,375 16.40 1883 18.83 1883 Small Commercial 1.12 968786 7&0807 00000 9.4914 9.2242 4.038 100 OODO 35.071,708 0 4,329,807 4,207,917 2,OD8,944 45.618,375 16.43 MOD 19.00 1900 RKemption 1.13 966185 76.6742 0 ODOO 9.5761 9.3065 4.4431 100,0000 34,97?,541 0 4,3W.466 4,245.487 2,026,881 45.610,375 16.39 19.17 19.17 19.17 LEVY 1.14 963584 76.467B 0 ODDO 9,6609 9-3WO 44924 1000000 34,683,375 D 4,407,125 4.283,058 2,D44,alS 45,618,375 16.34 1934 19,34 19�34 1.15 900983 762614 0,= 91456 DA712 45218 1000000 34,7892DS D 4.445,784 4.320,629 2,082.755 45,618,375 16.30 19r5l 1951 19-51 11TEstimated 1&" 1.16 958381 76.0550 0 OODO 9.8303 9.5536 C5611 100.ODDO 34,695,G41 0 4,484,443 4,358,200 2,080.692 45,618.375 16.26 ig 67 19.67 19,67 16.96 Single Tax Rate 1.17 95,5780 75�5485 0 ODOG OM 51 9.636D 4.6DO4 100.000D 34,6DD,875 0 4,523,102 4,395,770 2,098.629 45,618,375 1621 19.54 W64 19.84 1.18 953179 75.6421 O.ODDD 9.9M 9.7183 4 M7 I DDrODOO 34,U6.708 0 4.561,761 4,433,341 2.116,566 45,616,375 1617 20.D1 20.01 20.01 Note: This table should be used for planning 1.19 050576 754357 0 OUDD 10 O"S 9�BW7 46790 1000000 34,412,541 0 4.6W.42D 4,470.912 2.134,503 45.Gi8,S75 16.12 20.18 20.18 20,18 purposes only.Actual calculations may 1.20 94r7977 75 n93 0 ODW 10,1693 9 SM 4.7184 100.0000 34,318.375 0 4.639.079 4,508.482 2.1$2.440 45,618,375 1608 20.35 203J5 2035 differ slightly due to rounding.For actual calculations,complete Recap. 1.21 94,!�376 750229 0 OWO 101541 9.9 MA 4.75T7 I DO.0000 34,224.208 0 4,677.738 4,546.053 2,V0,377 45.618,375 1603 20.52 20.62 20.52 1.22 94,2774 74L8164 0 OODD M3388 10.0478 4.7970 1 00.ODDO 34,130.041 0 4,716.397 4,583.824 2.188,314 46.618,375 1599 zo49 20.69 20.69 1.23 940173 74L6100 0 OODD 10,4238 10.1301 4 M3 1DO.DDW 34.035,875 0 4,15$,0$$ 4,621.194 2.206,251 45.618,375 1595 2086 20.85 20.86 1. 114 93.7572 744036 0 OM 10.9M 10.2125 48756 100.0= M.W1,70a 0 4,703,715 4.958-765 2.224,1187 4.5.618375 15W 21,03 21,03 21,03 1.25 93.4071 74.1972 0 ODOG 10,59W 10.2948 C9150 100. 33.547,541 0 4,8W.374 4.696.33j 2,242, 24 45,618'.375 W86 2-- -- -- Page I of 4 IOF2&2010 11:03 AM What If..Scenario Workshoet M 93 2370 73.9W? 00000 106778 103M 4.9543 1000WO 33,753.,175 0 4.871,OS3 4,733.905 2.260,061 45.618,375 1581 21.37 21.37 21.37 26 '32 1.17792.1769 73.7943 0,0000 10.7625 10.4596 4,9936 1 00.00W 33,659,208 0 4.9D9,692 4.771.477 2,277,9W 45,618,375 15.77 2t54 21.54 21.54 1.28 92.7187 73.5T79 00000 108473 10.5419 5.0329 100.= 33.585,041 0 4.940,351 4,8W.048 2,295,935 45,618,375 15.73 21,71 21.71 21.71 1.29 92.451% 73.3715 0 ODDD 109320 10.6243 5.0722 100.DDOD 33.47OA75 0 4,987.010 4.M,61 8 2.313.872 45,618,375 156$ 21.88 21.88 21.88 1.30 92.190 73.1651 0 ODDD IIA168 10.7066 5.1116 100.0000 33.376.708 0 5.025.669 4,884,189 2,331.6W 45.618.375 1564 22.05 22.05 22.05 t3l 91.9364 ?2,9US 0 OOW 111015 10.7890 5.15W 1000000 332B2.541 0 5,054,328 4,021,7W 2,349,746 45,618.375 15,59 22.22 22.22 2222 1M 91 6763 7Z7522 o OOM i I,la$3 108713 5.tW2 i oO DDW 33,i$e,375 0 5,102,287 4,959.330 2,367.683 45,618,375 15.55 22.3D 22,39 2139 1.33 91.4162 72.54S8 0 ODOO 11.2710 10.9W 5.2295 100.00M 33.094,208 0 5,141,646 4,996.901 2,385.620 45.618,375 15.51 22,56 22% 2256 1.34 91.1560 723394 0 ODOG 11.3557 11.0361 5.26W '00.0000 33,000.041 0 51180.304 5.034,472 2.403.557 45.618.375 15.46 2213 22.73 2233 1.35 90.8959 72.1329 OMM 11,4405 11,11 B4 5.3082 100.0000 32,905.875 0 5,218,953 5.072.G43 2,421,494 45.610,375 1542 22,90 22.90 22.90 1.36 90.6358 71.9265 0 ODDO 11.5252 11.20DO 5.3475 100.DOGO 32.8li.708 0 5,257,622 5,10,613 7,430.431 45,618,375 15,37 23.07 23.07 2307 1.37 90.3757 71.7201 O,ODOO 11.6100 11.2831 5.3W8 100.DDDO 32,717,541 0 $,296.781 5.147,1 B4 2,457,388 45.618,375 15.33 23.24 23.24 23-24 "38 go"156 71 L51 37 00000 116947 11.305 5A261 1000000 32,023,375 0 5,334,940 5.184,755 2,475,305 45,618,375 15.28 23.41 23A 1 23.41 119 891555 713072 0 ODOO 11.7795 11.4479 5.4 MA I 00.00DO 32,529.208 0 5,373.599 5,222.325 2.493,242 45.618,375 15,24 23,58 23.58 23.58 1.40 89.6953 71A008 00000 11,8642 11.5302 530648 100.DOOD 32,435.041 0 5,412.258 5,259,896 2.511,17D 45,610,375 1520 23.75 23.75 23.75 141 89.3352 70.8944 O.ODDO 11.9490 11.6126 5.5"1 100.DDDO 32.340,875 0 5.450,917 5,297,467 2,$29,110 45,618,375 1515 23.91 23.91 23,91 1,42 09.0751 70 6M 0,0000 12,0337 11.6949 5.5&U 100.00DO 32,246,708 0 5.489,576 5,335.07 2,547,053 45,61B.375 15AI 24.08 24.08 24.08 1.43 888150 704816 0 O= 12,1184 11,M3 5 6W 100,DW 32.152,541 0 5.528,235 5.372.WB 2,564,9W 45,618.375 15.06 24.25 24.25 2425 1.44 08 5549 702751 OMDO 112032 11.859B 5.6620 100.00DO 32.058,374 0 5.566,M 5.410,179 2,582.927 45,618.375 1502 24.42 24.42 24.42 1.45 882948 MOW D.00DO 12.2B79 11.9420 5.7014 100.DOOO 31.984.208 0 5,605,553 5.447.749 2,BM.064 45,610,375 14,90 24.59 24.59 24.59 1.46 88.OU8 698623 O.ODDO 12,3727 12.02" 5.7407 100.DOW 31.870,D41 0 5.6",212 5,485.320 2,81R.BOI 45,616.175 14,01 24.70 24.76 24.76 1.47 87.7745 69.6559 O.ODOO 12.4574 111087 5.78M 100.00W 31,775,874 0 5,682,871 5,522.891 2,6W.73a 46.618,S75 14 B9 24M 24.93 2493 1.48 87.5144 69.4494 0.00W 12.5422 12.1891 5.8193 100.00DD 31.681,708 0 5,721,530 5.560,461 2054,675 45,618,375 14.84 25AO 25.10 25A0 1.49 01543 69,2430 O.00W 12.6269 12.2714 5.8586 ,00.00D011 31.507,541 0 5,760,1 e* 5.$",032 2,672,612 45.618,375 14M 25.27 25.27 25,27 11,501 W.9942 1 69.0366 1 0.0000 1 12.71171 12.35381 5.8M 1,00.0000 3 1.493,3741 0 5.798,846 $05,603 2,690,549 45,618,375 25�" 250 25,1M Page 2 of 4 1 W512010 11:03 AM What lf...Scenario Workshoet .51 86.7341 68,&302 O.ODOO 12.7984 12.4362 5.9373 10D.DDDO 31,399.208 0 5.837,507 5.673.174 2,708,486 45,610.375 14.71 25 01 25 Bi 2561 7".51,18IM8"'7130 886238 0,0000 12.8811 12.5185 5.9766 10D,DDOO 31.305.041 0 5.076,166 5.710,744 2,726,423 45,618.375 14�67 25.78 2578 25.78 1.53 SUM 684173 0 WW 12.0659 12 60M 60159 1 OD DDOD 31,210,874 0 5,914,825 5,740,315 2,744,360 45�510,375 1462 25.95 2595 25.95 1.54 85.13537 682109 O.ODOO 13.0506 12A832 6.0552 1 DO 0000 31.iiO,7w 0 5,953,484 5,786.8M 2,762,297 45,618.375 14.58 26.12 26.12 26.12 1.55 856936 6&0045 O.00W 13.1354 12.7656 6.0945 IOD.ODOO 31.M.541 0 5.992.143 5.823.456 2,7BO,234 45,618.375 14.53 26.29 2629 2629 1.56 854335 673981 0 OOM 13 MI 12 84W 61339 MODW 30,928,374 0 6.030,8W 5,aSs.027 2,79e,171 45.818,375 14.49 2646 2848 2646 1.57 05A734 67.5916 0.0000 13,3049 12,9= 6.1732 IODOOOO 3D,$,U,20S 0 6,069,451 $.898.5% 2.816.108 45,616.375 14.45 26.63 26.63 26.63 158 849132 67.3a52 O.00DO 13.3896 130127 6.2125 iOD.0000 30.740,041 0 6,108,120 5.938.168 2,834,045 45,615.375 14.40 26.60 2680 26.8D 1.59 846531 67.1788 O.DDOO 13.4743 130950 6-2518 100.00DO 30,645.874 0 6.146,779 5,973.739 2,851,982 45,618,375 14.36 26.97 26.97 26.97 1,60 843930 66.9724 0.0000 13.5591 131774 6.2911 1 00.00DO 30.551,708 0 6,185,438 6.011,310 2,869.919 45,618,375 lk3l 27.14 27.14 27A4 161 84,1329 66.7659 O.DUGO 13Z438 13.2597 6.3305 100.0000 30,457,541 0 6,224,097 6,04B.680 2,887,856 45,61$,375 14.27 27.31 27.31 27.31 1.62 83.8728 665595 ()D= 137286 13,3421 63698 100.OWO 30,363,374 0 6,262,756 6,086,451 2.905,793 45,618,375 14.23 27.48 27A8 27A8 1.63 83.6127 66,3531 0.000D 13 M33 13 4245 6A091 100.0= 30.269,2M 0 6.301.415 6.124.022 2,92V30 45.616,375 14.18 27.65 27.65 27.65 1.64 a3.3525 68.1467 O.00OD 138981 13.5068 6.4484 100.0000 30,175.041 0 6.340,074 6.161.592 2,941.667 45,618.375 14.14 27.82 27.82 27.82 1.65 B3.0924 65.94D3 0-000D 139828 13,5692 6.4877 100.00DO 30,DBG.874 0 6.378,733 6,199,163 2.959,604 45.618,375 14.09 27.99 27.99 27.99 1 M 82 OM 65.7338 OrOOW 140576 13.6715 6.5271 IDO.ODDO 29.9M.708 0 6.417,392 6,238,734 2,977.541 45,618,375 14.05 2816 28.16 28.16 1.67 82.5722 M.5274 O�OOOD 14,1523 13.7539 65684 100.00DO 29,892MI 0 6.456,051 6,274.304 2,995,478 45.618,375 MAI 28.32 28.32 28.32 1.66 82.3121 65.3210 00000 142370 13 M3 66057 1MOOW 29,79a,374 0 0.494,710 6,�11.076 3,013.415 45.618,375 13.96 28.49 28.49 28.49 i M 82Z52D 65,1146 0 ODDO 14M18 13.9186 &6450 100.0000 29,704,208 0 6.533,369 6,349,446 3,031.352 45.618,375 13.92 28.66 28.66 28.66 1.70 81,7918 64.W81 0 ODDO 14.4065 14.0010 66843 100.00DO 29.810.041 0 6.572,028 6,387.017 3,049,289 45,618,375 13W 20.83 28.83 26-63 1.71 81.53 64.7017 D.ODDO 14,4913 14.0833 6,7237 100.00DO 29.515,874 0 6,610.667 6,424.587 3,087,226 45.618,375 13.83 29.00 29.00 2900 1 J2 81.2716 644953 O.ODOO 14.5760 14.1657 6,7830 100.00DO 29,421,70B 0 6,649.346 6.482,158 3,085,163 45.618,375 13.78 29,17 29V 20V 03 ai.015 642 9 0.0000 14.6608 14.2480 6,8D23 IDO.DWD 29,327,541 0 SAW.W5 6,499,729 3,103,100 45.618,375 13.74 2034 2S34 29.34 114 8015,4 840825 00000 14.7455 14.3304, 6,8416 ,DO.ODDO 29.233,374 0 6,726-664 6,537.M 3121-037 45-618375 3,70 29.51 1 M 'f, 1.75 80,4013 83,8760 1 0.0=1 14.03031 14.4128 6.8809 1100,0000 29.139,208 01 6.785.323 6,574,8701 3'138.D741 45,618'375 :3.0 29 6a 29.681 29 6B Page 3 of 4 WM/2010 11:03AM