Loading...
TR-2011-58 RESIDENTIAL TAX FACTOR TES FY 2012 TAXRA ........ RESIDENTIAL COMMERCIAL INDUSTRIAI,- PERSONAL PROPERTY ......... JIM III's A' 4M, Pei- Thousand 'Per Thousand Effective "luiv 1,,2)Qll-Jtine .3(j2()I; Office of the Assessor Page I of copy AGAWAM 2012 Jurisdiction Fiscal Year 2012 E01 LA4 VALUES FFCV PERCENTS Residential 2,144,942.590 Res% 78.9804 MRF 96.6932 Open Space 0 OS% 0.0000 175%Shift 80,0397 Commercial 235,002,583 Com% 8.6532 Chapter 3 0.0000 Industrial 219,359,330 Ind%8.0783 Historic Low% 59�3317 Pers Prop 116,456.060 P P%4�2881 Prior Res%65,5274 Total 2,715,790,563 Total% 100M00 Lowest RF 80-0397 OPENSPACE INPUT OPTIONS DISCOUNT 47,120,212 Resid Factor.0.829673 Selected 0 S 0.0000 Estimated Levy Selected Discount% CIP Shift 1,64000 0 S Factor 1,00000000 Single TR 17�35 SHIFT PERCGNTS Res%65�5279 Res TR 14.40 OS%0.0000 OSTRO COM% 14.1912 Com TR 28,45 Ind % 13,2484 Ind TR 28,45 P P%7.0325 PP TR 28.45 Total% 1ft0000 RESIDENTIAL EXEMPTION Total Res Value 2,144.942,590 Total Res o Avg Res Value 0 Parcel Count Avg Res Value 0 X Selected Res 0�0000 Residential 0 Exemption% Exemption No.Eligible Res 0.0000000 Tot Res Value 0 Parcels minus xempt SMALL-COMMERC-1 EXEMPTIQN No.Eligible Com o Parcels Selected Com,0.0000 X Total Value of 0 Total Value to 0 Exem% Eligible Pcis be Exempt Total C&I Value minus Exemption 454�391,913 Signatures Signatures for LA5 0 (Board of Assessors) (Date) Comments: LA5 Certification w;(*1t*1tf1AtW n,:n%- I 1/10 IM I I flage41 of 3 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 2012 would be held on 12/512011 (date), 7:00 PM (time),at Roberla Doering Middle School (place), by Newspaper Article and Posting on Public Bulletin Boards (describe type of notice). 10 (Clerk) (Date) Comments'. We hereby attest that on 12/5/2011 (date), 7�00 PM (time), at Roberia Doering Middle School (place) a public hearing on the issue of adopting the percentages for the fiscal year 2012.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 12JW2011 (date). The LA-5 excess capacity is calculated as 6,065,792.36 We have been informed by the Assessors of excess levy capacity 6,065,792,36 Signatures for LA5 Certification For cities: City Councilors,Aldermen, Mayor For towns: Board of Selectmen For districts: Prudential Committee or Commissioners 0 (Authorized Signature) (Date) Comments: (Authorized Signature) (Date) Commen C: (Authorized Signatur (Date) Comments: (Authorized Sign ore) (Date) Comments- /2-/4.5 0 (Authorized Signature) (Date) Commentsl (Authorized Si (Date) s Comment Page 3 of"I (Authorized Signature) (Date) Comments: Ile (Authodzed Si nature) (Date) Comments: View Edil Lis SIgIV5 of TaxRalg Fgtms View More — View Last Uodater I n(grmation Ealwate&7 http,s://disgatew,iy.dor.staic.ilia, q i0ntintw .iQnv I q TR-2011-58 A RESOLUTION ADOPTION A RESIDENTIAL FACTOR OF Q.8�1 PURSUANT TO MASSACHUSETTS GENERAL LAWS,CHAPTER 40, SECTION 56 Sponsored by: Mayor Richard A. Cohen 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 interest 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 W; i,uq NOW THEREFORE, THE AGAWAM CITY COUNCI hereby resolves after conducting a public hearing to adopt a residential factor of �`pursuant to Massachuseup CD General Laws,Chapter 40, Section 56; and DATED THIS OF 2011. fz =rn PER ORDER OF THE AGAWAM CITY COUNCIL =:K 19 n W1 4-') Cr rf- Donald M. Rheault, President Wow d' ArPjVJED TO FORM AND LEGALITY r 1Ancem'di'o­`scia, Solicitor cowrcd CK:1 C� --- MAYORAL ACTION Received this _day of D�-C�t 2011 from Council Clerk. -,- A Signed by Council President this 50"N day of�k�Un 2011. APPROVAL OF LEGISLATION By the powers vested in me pursuant to Article 3, Section 3-6 of the Aga hatter, as ed I h Oi�approve the passage of the above legislation on this day of ., 2011. Richard A. Cohen, Mayor DISAPPROVAL OF LEGISLATION By the powers vested in me pursuant to Article 3, Section 3-6 of the Agawam Charter, as amended, I hereby veto the passage of the above legislation on this day of 2011 for the following reason(s): Richard A. Cohen, Mayor RETURN OF LEGISLATION TO COUNCIL CLERK Returned to Council Clerk this day of 2011. AGAWAM CITY COUNCIL 36 MAIN STREET AGAWAM, MASSACffUSETTS, 01001 LEGAL NOTICE LEGAL NOTICE PUBLIC HEARING AGAWAM CITY COUNCIL PRESIDENT Donald M. Rheoult The Agawam City Council will conduct a public hearing on Monday, December 5, 2011', at 7:010pm, at the Roberta G. 'Doering School, 68 VICE PRESIDENT Main Street, Agawam, MA to consider the adoption,Qf a Residential Robert E. Rossi Tax Factor pursuant to Massachusetts General Laws, Chapter 40, COUNCILORS Section 56 as submitted to the City Council by the Mayor 'on Creorge Bilzas November 17, 2 011. James P. Cicherti Gina M. Letellier The Resolution (TR-2011-58) is available for public inspection at the Roben A. Magovern City Clerk's Office, 36 Main Street, Agawam, MA between the hours Jill S,Messick of 8:30amto 4:30pm, Monday through Friday. It is also available at Joseph Mineo the Agawam Public Library, 750 Cooper Street, Agawarri, MA and the Dennis J Perry Jill P.Simpson Agawam Senior Center, 954 Main Street, Agawam, MA. John V Walsh ADMINISTRATIVE BY ORDER'OF: ASSISTANT Barbara A. Bard Ponald M. Rheault President of the City Council TO BE ADVERTISED ON 11/24/11 > C:� C") NJ X C;; C) rn TELF.PHONE (4'13) 786-0400 Ext. 233 FAX (413) 786-9927 ]EMAIL bbard@agawarn.ma.us LC_g_o_1 _ NofiCC_S AGAWAM ZONING MA to consider the adoption BOARD OF APPEALS of a.R�sidential Tax Factor LEGAL pursuant to Massachusetts ADVERTISEMENT General Laws, Chapter 40, Oetober 24,2011 Section 56 as submitted Notice is herebygiven to the City Council by the that the Agawam Zoning Mayor on November 17, Board of Appeals will hold a 2011. public hearing ai the Agawam The Resolution(TR-201 I- Public Library Conference 59) is available for public Room, 750 Cooper Street, inspection at the City Clerk's Agawam, MA on Monday, Office, 36 Main Street, Decemher 12, 2011 at Agawam, MA between the 6:30PM for all parties inter- hours of 8:30am to 4:30pm, ested in the appeal of Scott Monday through Friday. It is Mackenzie, who is seeking also available at the Agawam a Special Permit in accor- Public Library, 750 Cooper dance with Section 180-7, Street,Agawam, MA and the Paragraph B of the Town of Agawam Senior tenter, 954 Agawam Zoning Ordinances Main Street,Agawam,MA. to allow for an addition to a BY ORDFR OF: residential structure with less Donald M.Rheault than the required frontage, President of(he City Council front setback and side yard 11/24/11 at the premises identified as 217 Meadow Street, Commonwealth of Doreen Prouty Chairperson Massachusetts Agawam Board of Appeals The Trial Court 11/24,12/t/11 Probate and Family Court 50 State Street LEGAL NOTICE Springrield,MA01103 PUBLIC HEARING (413)748-7758 AGAWAM Docket No.HD1 I.P221 I EA CITY COUNCIL In the Estate of* The Agawam City Coun- James J Burgess cil wi I I conduct a public hear- Late.of.Agawam, ing on Monday, December MA 01001 5, 2011, at 7.00pm, at the Date of Death: 10/2712011 Roberta G. Doering School, NOTICE OF PETITION 68 Main Street, Agawam, FOR PROBATE OF WILL �Iivlr, 1ki Ifia pon for a free appetizer or cessert rom ays those who Chili's Grill & Bar-,prizes are non-transfer- he community. able and not redeemable for cash, . to become a Balloon sculptor Ed Popielarczyk- Is- e did. Before scheduled to volunteer at the drive and will organ donor. I be making balloon sculptures. were donated To make an.appointment to donate blood, �n see because call i-800-RED CROSS (1-800-733-2767) vas used in 45 or log onto rederossblood.org. 5 6 10 11 112 13 is I 31 3 34 3 41 45 50 51 53 so GC� 61 83 64 65 Be 69 lated on the CLUES DOWN 31. 14027 NY !�s side 1,One who feels 32.A citizen of 1pposite of penitence Havarma ining 2.Name meaning 33.Very coldly drikaans "God knows" 34.Singer .Verysmall 3.Tel— Delia tar shape Israel city 36.Wager laterial 4.Palm fruits 39.Arrived extinct ill the Science 5.Coarse cinnamon 44.British School hark 46,The Education cgregating 6.Goat and Project Asia -ion -I­� 'I - " 40 ? I TR-2011- 58 A RESOLUTION ADOPTION A RESIDENTIAL FACTOR OF 0.827011 PURSUANT TO MASSACHUSETTS GENERAL LAWS, CHAPTER 40, SECTION 56 Sponsored by: Mayor Richard A. Cohen 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 interest 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 1.65; NOW THEREFORE, THE AGAWAM CITY COUNCIL hereby resolves after conducting a public hearing to adopt a residential factor of 0.827011 pursuant to Massachusetts General Laws, Chapter 40, Section 56; and DATED THIS OF 12011, PER ORDER OF THE AGAWAM CITY COUNCIL Donald M. Rheault, President A7Pjy<0VJED :TO FORM AND LEGALITY 4i9cent'6Nio's'cia, Solicitor L> L> TR-2011-58 A RESOLUTION ADOPTING A RESIDENTIAL FACTOR OF 0.00 PURSUANT TO MASSACHUSETTS GENERAL LAWS, CHAPTER 40, SECTION 56 Sponsored by: Mayor Richard A. Cohen 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 interest 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 0.00; and NOW THEREFORE, THE AGAWAM CITY COUNCIL hereby resolves after conducting a public hearing to adopt a residential factor of 0.00 pursuant to Massachusetts General Laws, Chapter 40, Section 56; and DATED THIS OF .2011. PER ORDER OF THE AGAWAM CITY COUNCIL Donald M. Rheault resident A R VED AS FORM AND LEGALITY ,ON - I q I Vincent dioscY, Solicitor TR-2011-58 A RESOLUTION ADOPTING A RESIDENTIAL FACTOR OF 0.00 PURSUANT TO MASSACHUSETTS GENERAL LAWS,CHAPTER 40,SECTION 56 Sponsored by: Mayor Richard A. Cohen 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 interest 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 0.00, and NOW THEREFORE, THE AGAWAM CITY COUNCIL hereby resolves after conducting a public hearing to adopt a residential factor of 0.00 pursuant to Massachusetts General Laws, Chapter 40, Section 56; and DATED THIS OF 12011, PER ORDER OF THE AGAWAM CITY COUNCIL Donald M. Rheaul resident A R VED AS FORM AND LEGALITY Vincent os Solicitor ro J'0'WN � ,A T,�X CLASSIFICATION FY 2012 RICHARD A. COHEN M..�k'YOR Nocioeconomic E Count HAMPDEN School Structure K to -12 Form of Government *,*e M a y o r +*.*Council 4*'*oSchool Committee 201LO Population 28,438 2010 Labor Force 15,578 2009 Per Capita Income 30,032 Land Square Miles 23.24 Unemploymen t Rate ***#20110 8.0 Standard & Poor's Rating AA services Moody's Bond Rating Aa2 PROPOSED FY2012 Tax Classification Tax Classification Tax Rate Tax Levy Assessed Values Residential 14.35 30,777,830 21144,942,590 Commercial 28.63 6f727,714 235,002,583 Industrial 28-63 61280,734 219,389,330 Personal Property 28.63 3,333f934 il6j,456FO60 Total 47,120f 212* 21715,790,563 *Difference from proposed tax levy due to rounding 2012 CLASSIFICATION BREAKDOAVN PROPERTYVALUE PERSONAL 4% INDUSTRIAL 8% C MER OM 9% CIAL- m RESIDENTIAL m COMMERCIAL 0 INDUSTRIAL 0 PERSONAL_ RESIDENTIAL 79% PROPERTY CLASS PROPERTY VALUE RESIDENTIAL 21144,942,590 COMMERCIAL 235,002,583 INDUSTRIAL 219,389,330 PERSONAL 116,456,060 2011 . A TGo I GLE FAMILY N S N TAX BILL RANK SINGLE OUT OF ASSESSED AVERAGE TAX FAMILY 337 MUNICIPALITY VALUE PARCELS VALUE RATE TAX BILL CITIES CHICOPEE 11969,964,600 10,9571 179,496 14.66 21631 304, SPRINGFIELD 31524,640,300 26,045!, 135,329 19.49 2�638 3031 HOLYOKE 979,854,428 5,3041 184,739 2�915 273 AGAWN 11668,670,6001 7,6661 217,672 14.00 3,047 258 SOUTHWICK 764,882,4001 219931 255,557 13.44 3�435 2151 WESTFIELD 21155,853,800 91320 231,315 15.41 3�565 194; WEST SPRINGFIELD 11398,282,900 6146 216,923 16.72 31627 188 EASTLONGMEADOW 11364,757,600 5,282 258,379 17.67 4,566 108 ILONGMEADOW lj91019571800 51442' 3511150 18.75 61584 44 TAX RATES SURROUNDING TOWNS FY2o12 PROPOSED TAX RATE $14-35Residential $28.63 Commercial Municipality FY Residential Commercial Industrial AGAWAM 2009 12.07 26.04 2010 12.94 27.07 2011L 14.00 28.32 CHICOPEE 2009 13.20 28.12 2010 13.63 28.95 2011 14.66 30.30 EAST LONGMEADOW 2009 16.26 16.26 2010 17.38 17.38 2011 17.67 17.67 HC)LYOKE 2009 14.24 35.1S 2010 1-4.98 36.54 2011 15.78 37.08 LONOMEADOW 2009 17.11 17.11 2010 18.28 18.28 2011 18.7S 18.75 SQUTHWICK 2009 12.55 12.55 2010 13.44 13.44 2011 13.44 13.44 SPRINGFIELD 2009 17.89 36-98 2010 19-50 39.25 201Z 19.49 38.97 WEST SPRXNGFIELD 2009 14.66 33.85 2010 16-00 34.69 2011 16.72 34.20 WESTFXELD 20 1 13.94 27.61 20101 14.68 28.6 20111 15.41 29.3. COMPARATIVE TAX EFFECT TAX COMPARISON FY 2012 li,cal Yea,2111 lig",Yea,1112 TYPICAL COMMERCIAL PROPERTY Value 1622,600 Value $622,600 Shift 1.61 1.62 1.63 1.64 1.65 1,66 1.67 1.68 1.69 1.70 1.71 Tax Rate 28.31 Factor 0.837657 0,834995 0,832334 0,829673 0.827011 0324350 0.821688 0.819027 0.816366 0.813704 0,811043 Tax $17,63 Rate $27.93 $28.11 $28.28 $28.45 $28.63 1 $28.80 $28,98 $29.15 $29.32 $29.50 $29.67 FY 2011 AVG INCREAS Tax $17,389 $17.501 $17,607 $17,713 $17,825 V7,931 $18,043 $18,49 $18,255 $18,367 $18,473 $112 1 Difference -$243 4W -$25 $81 $193 $299 $411 $517 $623 $735 $841 Fiscal Year 2011 Fiscal Year 2012 TYPICAL INDUSTRIAL PROPERTY Value $826,600 Value $826,600 Shift 1.61 1.62 1.63 1,64 1.66 1,66 1.67 1.68 1.69 1.70 1171 Tax Rate 28,3 Factor 0.837657 0,8U995 0,B32334 0,829673 0.827011 0.824350 0.821688 0,819027 0.816366 0113704 0.811043 Tax $23.409 Rate $27.93 $28.11 $28,28 $28.45 $28.63 $28,80 $28.98 $29.15 $29.32 $29.50 $29.67 FY 2011 AVG INCREAS Tax $23,087 $23,236 $23.376 $23,517 $23,666 $23.806 $23.955 $24,095 $24,236 $24,385 $24,525 $175 1 Difference 4322 -$174 -$33 $107 L.!L66J $397 $646 $686 $827 $975 $1,116 mmmi Fiscal Year 2011 Fiscal Year 2012 TYPICAL RESIDENTIAL PROPERTY Value $219.000 Value $219,000 SK;ft 1.61 1.62 1.63 1.64 1.65 1.66 1.67 1.68 1,69 1.70 1.71 Tax Rate 14.0 Faclor 0.937657 0.&34995 0.832334 0.829673 0,827011 0,824350 0.821688 0,819027 0.816366 0.8137G4 0311043 tax $3.0661 Rate $14.53 $14.49 $14.44 $14.40 1 $14.36 1 $14,30 $14.26 $14.21 $14.16 $14.12 $14,07 FY 2011 AVG INC REAS Tax $3.182 $3,173 $3,162 $3,154 $3,143 $3,132 $3,123 $3,112 $3.101 $3,092 $3,081 $101 Difference $116 $107 $96 $88 L"!77J $66 $57 $0 $35 $26 $16 1112312011 Town of Agawam &54:08AM ASSESSMENT CLASSIFICATION REPORT: LA4 Kesigential L) n b ace Commercla Inaustria Pers. Propel", EV@ndTvpe WChaoteED FP-a-r-c-els Class2 Class4 Class5 I Classi I !�M M I 01: 7,6811 1,680,002,9001 1 02: 1,6031 227,924,1001 1 1 Misc Res: 151 3,878,7001 1 1 04: 4151 82,333.6401 1 05: 1 251 5,423,4001 1 1 1 11-126: 1 1 601 95187,0001 1 1 30-32& 106:1 1 7251 32,801,8001 1 00-299: 1 01 01 1 1 00-399: 3091 01 214,851,900 00-499: 1641 01 1 218,701,7. 01 c"H61 Land: 65 41 01 1 14,2561 H61 A, 73 411 01 1 1,121�0481 M61 B: 1 13 41 01 1 1,458,2991 012-043: 1111 17,391,0501 1 17,557,0801 687,6301 01: 4861 01 3,670,190 502; 3011 01 39,195,970 03: 41 01 18,380 04.650-652: 21 01 56,944,820 5 05: 21 01 1 9.861,800 06: 1 1 01 1 6,179,500 08: 71 01 1,585,400 n valid LUC: 01 01 TAXABLE CLASS VALUES: 2,144,942,690 0 235,002,583 219,389,330 116,456,060 11,167 REAL ESTATE TAXABLE 2,599,334,603 248 I-KE Fxr=MPT VALUE: 368,726,244 RIE TOTAL COUNT: 11,405 RIE TOTAL VALUE: 2,968,060,747 803 IPERS.PROP,TAXABLE: k 116,456,060 ITAXABLE COUNT: 11,960 PP TAXABLE I VALUE. 2,715,790,5631 kuestions concerning this report should be directed to the following person: Narnp Title Dav-Tirne Phonp# DEPARTMENT OF REVENUE MINIMUM RESIDENTIAL FACTOR COMPUTATION FOR FY 2012 AGAWAM City/Town/District A B C Class Full and Fair Cash Percentage Valuation Share 1. Residential 2,144,942,590 78.9804% 78,980�40/. 2. Open Space 0 0.0000% 3. Commercial 235,002,58:3 8.6:532% 21,0196% 4. Industrial 219,389,330 8.0783% 5. Personal Propertv 116,456,060 4.2881% TOTALS 2,715,790,563 100�0000% Maximum Share of Levy-for 150% X 21.0196% 31-5294% Classes Three, Four and =ines 3C + 4C + 5C Personal Property : Max % Share Minimum Share of Levy for 100% 31.5294% 68.4706% Classes One and Two : Max % Share =in 0/6 Share Minimum Residential Factor 68.4706% 78.9804% 86,6932% (MRF) Min % Sha Lines 1 C +_2C Minimum Residential Factor MINIMUM RESIDENTIAL FACTOR 86.69320/. LA7(6-96) Chapter 58, Section 1A mandates a minimum residential factor of not less than 65 percent, Date; 11/2912011 3:05 PM Page 1 of I TAXFLA7 CALCULATION OF THE LOWEST POSSIBLE RESIDENTIAL FACTO CHAPTER 200 FOR FY 2012 AGAWAM 1, Last year's chosen residential percentage (R)*. 66.5274% Z This years MRF using a 150% shift to CIP (from LA-7). 86.6932% 3, Minimum residential share(R)in current year using 150%Shift to CIP. 68.4706% 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.0397% 5. Multiply this new residential factor by this years FFCV residential 63.2157% percentage (R). 6. What is the lowest histohcal residential percentage since the first 69.3317% certification (R). If#5 is greater than#6, ITOP! You may shift up to 175%to the CIP 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: 11/29/2011 3,06 pm Page I of I Share Parcenugn LavyAmourft EsUrruged Us Rafts CIP Res What ff..Scenario Worksheet ShIft Factor R" us cofn tnd PP ToW R" 09 com uw POP ToW Res 05 Cam Ind Pp CLASS VALUE % 1.01 99.7339 76.7702 00000 0.7307 8.1501 4,3310 100,0000 37.116.693 0 4,118,IT7 3,1144,571 2.040,772 47.120,212 17.30 17.52 17,52 1752 Re* 2,144,942,690 78.9804% R&O% IM 99 4877 70 SSW 00000 8 07W 82399 4.3739 100 ODDO 37,017.648 0 4,158.9si 3,$U.636 2.060,177 47,120,212 17,26 17,70 17,70 17.70 08 0.0000% 78.9804% 1.03 W2016 78.3-498 0 OOW 8.9128 8.3206 4A168 i00,0DD0 36,916,W 0 4.199,725 3,920,701 2.081.183 47,120,212 17,21 17.87 17.87 17.87 Com 236,002,683 8.6632% 1.04 989355 78.1396 0 ODOO B.9993 8.4014 4,4596 100,00W 36.819,559 a 4�240,499 3.958.766 2.ID1,389 47.120,212 17.17 1804 1804 16 D4 Ind 219,389,330 8.0783% C I P% 1.05 1386693 771294 0 00W 9.0859 8.4822 4.5025 106,0000 36,720�514 0 4,281.273 3,998.831 2,121,594 47.120,212 17.12 1822 10.22 18.22 pp 116,466,060 4.2881% 21.0196% 1.05 98 4D32 77.7192 0 DD00 9.1724 8.5B30 4.5454 1000000 36.621,469 0 4,322,D47 4,034.896 2,141,8W 47.120,212 iT07 18.39 10.39 18.39 Total � 2,716,790,5631100.0000% 1.07 98.1370 77.5090 D.00DD 9.2589 8.6435 4�51W3 1 DD OODO 36.522,425 0 4.362.821 4,072,961 2.162,OW 47,120�212 17.03 18% 1856 16.56 ME PQWN TQ COMPLr;Trz VATA EbaBY � 1 1.08 97.87D9 77.29B8 O.00DO 9.3454 8.7246 46312 10D.0DD0 36,423,380 0 4,4D3.595 4,111,026 2.IB2,211 47,120,212 18.98 18.74 18.74 18.74 CLASSIFICATION OPTIONS 1.09 97.6048 77.0886 O.00DD 9.4320 8.8053 46740 10D.0000 36.324.335 0 4,444,369 4,149.091 2.202,417 47.120,212 18.93 Iasi 10.91 18,91 1.10 97�33W 766785 O,ODDO 9.5185 8 6W1 4,7169 1 DD C000 38,225,290 0 4,455.143 4,107,150 2.222,623 47�120,212 16,89 M09 1909 19.09 Residential Exempt 1.11 97.0725 766683 0.0000 O.W50 8AM 4,7598 100 Owo 3o,vs,24s a 4,526.017 4,225.221 2,242,928 47.120,212 1684 19.26 19.26 19.26 SmaH CommerciaJ 1.12 96.8064 76.4581 O.OWD 9.6916 90477 48027 IDD.00DO 36,027,201 0 4.W,691 4,263,286 2.M,034 47,120.212 1680 1943 19.43 19.43 Exemption 1.13 96.5402 10.2479 0 MW 9.7781 91285 4.8456 1000000 35.928,156 0 4.607,465 4,301.351 2,253,240 47.120,212 1675 061 lost 19.61 LEVY 1.14 96.2741 760377 O.00W §.8W 92092 4 OB84 I DD 0060 35,829.111 0 4,r,4e,239 4,a39.410 2,303.446 A�.120,212 1510 19.78 19.78 1970 1.15 960079 75,8275 0.0000 9.9512 92900 49313 100 00W 35,73o.oO 0 4,689.013 4,377,481 2,323.651 47.120,212 1666 19.95 19.95 iogs $47,120,212 Estimated Levy 1.16 95.7418 75.8173 0.00W 10.0377 9,3708 4,9742 1000000 35,631.022 0 4,729,787 4�415,548 2.343,857 47.120,212 1661 20.13 20.13 20J3 17.35 Singje Tax Rate 1.17 95,4757 75.4071 O.D000 10.1242 9,4516 50171 1 DD 0000 35.531,977 0 4,770,56t 4,453.611 2,364,Oa2 47,120,212 46.57 2030 20.30 2030 1.18 952095 75.1969 0.0000 10.2108 9.5324 5 06W 1000000 35.432,932 0 4,811,335 4.491,877 2.384,268 47j20,212 16.52 2047 2047 20,47 Note: This table should be used for planning 1.19 D4,9434 74.9887 O.ODOD 10.2973 96132 5,1025 IOD0000 35,333.aBB 0 4.852,109 4,529,742 2,4D4,474 47,120,212 1647 20.65 2065 2065 purposes only.Actual calculations may differ slightly due to rounding.For 1.20 946773 74.7765 0,0000 10.3838 9B939 5,1457 100.0000 35,234.843 0 4.892.663 4,587.807 2,424,670 47.120,212 16.43 20.82 2D 82 20 412 actual calculations,complete Recap. 1.21 944111 74.5663 0.0000 IOA704 9.7747 SAM 100.0000 35.M,798 0 4.933.657 4,605,872 2,444,865 47,120,212 18.38 20.99 2D.99 20" "22 94"450 743561 a OOOD 10L,5�569 98556 $2315 100.0000 35.036.754 0 4,974,431 4.$43,937 2,465.091 47,120,212 W33 21.17 21.17 21,17 1.23 93.8789 74.1459 0,00DD 106434 99363 5.2744 100.0000 34. . I i , 4. , 2 2.485,298 47,120,212 1629 21.34 21.34 2134 'r24 03.6127 73.9357 0 ODOG 10.7300 M0171 S.WS 1 0100DO 34.83a,684 0 5,055.979 1 4.720, 2,505.'502 47 120 212 16.24 21.51 21.51 21.51 115 93.3466 737255 0 0000 108165 100979 53601 1 00.00DO 34.739.619 0 5,096,753 4,758,�132 2,5257081 47'120'211 18.20 21.69 21.69 2169 Page I of 4 1 In3r2011 2:43PM Share Pem"ga* Le"Amourft Eathurted Tax Ralst Cop Res What fir..Scenario Worksheet Mift Factor Res 03 COM Ind pp TOW Res 03 COM wo pp Tau$ Res as corn Ind pp 1.26 930804 73.5153 DMOO 109030 10.17W 5.4030 100.0000 34,64D.575 0 5,137,527 4,796,197 2,645,013 47,120,212 18.15 2i,ea 21.86 21.86 12? 928143 lF3.3061 0 ODDO 109896 10.2594 54459 100.ODDO 34,541,530 0 5,178.301 4,834,262 2.WAA 47.120,212 16.10 22.04 22.G4 2204 1,28 92.5482 730949 0 0000 11,070 id.3402 SAM 100 OWO 14.442,486 0 5,21g,075 4,872.327 2.586,325 47.120,212 IGM 22.21 2221 22.21 1,29 92.2620 728847 0 ODOO 11.1626 10.4210 5.5317 100.ODDO 34,343.440 0 5.259.849 4,910,392 2.6M,530 47.120,212 16.01 22.311 22.38 2Z38 1.30 92.0150 726745 D.DDDO 111492 10.5018 5.5745 100.0000 34,244.396 0 5.3DD,623 4,948,457 2.626.736 47,12D,212 15.97 22.66 27,56 2256 1.31 91.749B 72 4M3 00000 11.3357 10.5826 5L6174 100.0000 34,145.351 0 5,341,397 4,SW,522 2,646,942 47.120,212 15.92 2213 22.13 22.73 1.32 91.4836 72.2541 0.0000 11.4222 10.6633 5.6603 1 OODOOD 34,046,306 0 5.382,171 5,024,587 2.667,147 47,120,212 15.87 22.90 22,90 22,9D 1.33 91.2175 72.0439 0.0000 11.5W7 10.7441 51032 1 DO.0000 33,947,261 0 5,422,945 5,052.652 2,687.353 47,120.212 15.83 23.08 2308 2308 1.34 90.9514 71.8338 UZODO 11.5953 10.8249 5.7481 100DOOO 33.648,217 0 5.463.719 5,100,717 2,707.559 47.120.212 15.78 23,26 2325 2325 1.35 90.6852 71,6236 0.00W 11.6810 10.9057 5,7889 1 DO.ODDO 33,749,172 0 5,5D4,494 5,138,7a2 2,727.764 47.120.212 15,73 2342 23A2 2342 1.36 90.4191 11.4134 O.OM 11.7683 10.9865 5,631f) I 00rODDO 33.6W,127 0 5,545,268 5,176,e47 2,747.070 47,120,212 15.69 2360 2360 2360 1.37 90.1529 71.2032 0,0000 11.8549 11,0673 56747 1 Do 000a 33.55i,WZ 0 5,5W,042 5.214,913 2.760.476 47,120,212 15.64 23.77 23.77 7377 1.30 89,WW 70.993D O.00DD 11,9414 11.1480 5.9176 1 DO 0000 33,452,038 0 5.626.816 5,252,978 2.7118,381 47,120,212 1560 23.D4 2394 2294 1.39 89.6207 70.7828 0.0000 12.0279 11.2208 5.9BO5 100.0000 33.362,993 0 6,687.590 5,291,043 2,800.587 47�120,217 15,55 24,12 24.12 2412 IAO 89.3S 705726 0.0000 12.1145 11.3096 6 OD34 1 DO DWO 33,253.940 0 5.700,364 5,329,108 2,828,702 47,120,212 1530 24.29 24.29 2429 141 89.06M 70.3624 0.0000 12.2010 11.3904 60462 100.0000 33,154.903 D 5,749,138 5,367.173 2,648,W8 47,120,212 1546 24.46 2446 2446 1.42 88.8223 70.1522 O,OOW 12.2875 11.4712 60891 100.0000 33,055,1159 D 5.789,912 5.405.238 2,869,204 47,120.212 15,41 2464 24,e4 2464 1.43 88.5561 69.9420 O.OGDO 12.3741 11.55ig 6A320 100.00W 32,956,814 0 5,830.6W 5,"3.3D3 2.BB9,409 47.120,212 15.36 2461 2481 24 111 1.44 88.290D 69.7310 O.00W 12.4606 11.6327 6.1749 100.0000 32,857,769 0 5.871.46YD 5.481.36B 2.W9,615 47,120,212 15.32 24.98 24 9a 24.98 1.45 88.0238 69,5216 O.00DO 12.5471 11.7135 62178 100.0000 32,758.724 0 5.912,234 5,519,433 2.929,821 47,120�212 15.27 2518 2s tS 25 W 1.46 87.7577 69.3114 O.00DD 12.6337 11,7943 6 28M 1 00.ODDO 32,659.6W 0 5,953.008 5.557,498 2,950,026 47,120,212 1523 25 J3 25.33 2533 1,41 874916 69.1012 O.00W 12,7202 11.8751 8.3035 10D.0000 32.560,635 0 5.993,782 5.50,503 2,970,232 47,120.212 1518 25.51 25.51 25.51 4.48 ST2254 G8.8giD oO000 12.K*7 11.0669 e,3464 loomoo 32,4ei,590 o e,o34,556 5.6,d,628 2.990,438 47.120.212 15.13 25.68 25.68 2568 49, W,11593 68.901 0 OODC, 12-B933 12-0368 63893 000000 32-362,545 0 6,075-330 5671693 3.010,643 47,120.212 509 25815 2S 8f. 25 a5 '50 BEI&M 68.4708 0.=I 12.97W 1 12.11741 64M 00.0=1 N.283,501 0 6,118.104 3.030,849 47.120,212 5.04 26.0,3 1 26,03 28031 PaOZ04 11/2312011 2:43PM CIP Res Share Pemwages, Amourift Estkmtad Tax Rfftes What ff..Scenario Worksheet Shlfk Faaar Res Os COM Ind pp TOM Res 05 COM w pp TCrtAl Res as COM kw pp 1.51 864270 682604 0 ODDO 130663 12.19$2 64750 IOD.0000 32,164.4% 0 6.156,878 5,747,823 3.051.055 47.120,212. 15.00 28.20 28.20 26.20 1.52 86 IM9 Ba 0602 0 ODOO 131529 12,2790 6.5179 1 OO.ODDO 32.065,411 0 6,197,1151i 5.7B5,888 3,071.260 47.120,212 14.95 26.37 2637 26,37 1,53 858948 878400 0 ODOO 132394 12.3590 6,5608 100,0000 31.966.367 0 6.238,426 5,823,953 3,091,466 47,120,212 14.90 26.55 26.55 26.55 134 85.6286 67.6298 00000 133269 IZ"06 66037 100,DUOO 31.567,322 0 6,279,200 5.862,018 3.111,672 47.120,212 14.86 26.72 26.72 26.72 t55 85,3625 67.4196 0.0000 13,4124 123213 0 64W IOU DOW 31.768,277 0 6,319,974 5,900,084 3,131.877 47.120,212 14.81 26.89 26.89 26.89 1.50 85,0963 67.2094 O.ODDO 13.49W 12 W21 86895 1 OOMW 31,869.232 0 6,3W.748 5.938,149 3,152.083 47,120,212 14,76 27.07 27.07 27.07 1.57 84.M2 609992 0.0000 13.5855 12M29 63323 1 DO.00DD 31,570.188 0 6,401.522 5,978,214 3.172.289 47.120.212 14.72 27.24 27.24 27.24 1.58 84.5641 66.7801 0 WW 13.6120 12.7637 87752 1 DO OODD 31.471,143 0 6,442,298 6,014,279 3.192.494 47,120,212 14.67 27.41 27,41 27.41 1,59 84.2979 66,170 00101 13,71W 12,11445 11.11181 1 DOD" 31,172,M 0 11,4a3,070 6,012,3" 3,212.700 47.120,212 1463 27.59 27.59 27.59 160 84=8 66�36$7 00000 13,8451 12.9253 6.8810 IMODDO 31.273,053 0 6,523.844 6.090.4D9 3.232.9W 47,120.212 14.58 27,76 27.76 27.76 1.81 83.7657 66-1685 0�W= 13.9316 13.OM 6.9D39 100 ODOO 31,174,009 0 6,564.618 6.128,474 3,253.111 47,120,212 14.53 27.93 27.93 2T93 1 A2 83-4995 85.M3 0 OOOD 14 D182 13ON8 6.9467 100.00DO 31.074.964 0 6,605,392 6.166,539 3,273.317 47,120,212 14.49 28.11 2811 28.11 163 e3 2334 651381 0 ODOO U.1047 111876 69896 M.000a 30,975,019 0 6,"0.166 6,204,604 3,293,523 41,170,212 14,44 24126 28 2a 2828 164 829673 e6,5270 D,ODDO 14.1912 13,2484 7.Cr325 10D.DDOO 30,876,874 0 6.8W.940 6,242�689 3.313,728 47.120,212 14.40 2a,45 2845 28.45 1.65 a2,7011 653177 OMM 14,2178 133292 7.0754 100.DDDO 30,777.830 0 6,727,714 6.280,734 3,333,934 47.120,212 14.35 28.63 2863 2863 1.66 a2.4350 65.1075 D ODOO 143643 134100 7.1183 100,ODW 30,678,785 0 6,766.488 6,318,799 3,354.140 47.120,212 14,30 26W 28rW 2850 1,67 $2,1608 648973 O.ODOO M 450B 134907 7.1611 100 OODO 30,579,740 0 OAM,262 6.356,$04 3,374.3-46 47.12D,212 1426 2898 2898 2898 1.68 81-9D27 646871 0.0000 14,5374 13.5715 7.2040 1 OD DDOO 30,400,695 0 6,&r)O,a36 6,394.929 3.394.551 47,120,212 1421 29.15 29 15 29.15 1.69 SI.M 644769 O.ODOO 14.6239 13.6523 7.2469 10D.ODOO 30.301,651 0 6.890,$10 6.432,994 3.414,757 47,120,212 14,16 2932 29.32 29.32 1.70 81.3704 64,2667 G.00DO 141104 117331 7.2898 10D.0000 30.282,608 0 6,931,504 6.471,059 3,434,962 47,120.212 14,12 2950 2§.60 2950 1.71 81,1043 640565 0,00M 14,7070 13.8139 7.3327 1 OD ODOD 30j93,561 0 6,972,358 6,W9,124 3,455.160 47,120.212 1407 290 2967 29.67 1.72 80 8382 63,M3 0.00W 14.8835 13.8947 7.3755 1 DO DDOO 30.084.516 0 7,013.132 6.547,ift 3.475,374 47.120,212 1403 2994 29.84 29,94 1.73 80.5720 83.6MI G,M 14,9700 13,9754 T41B4 IODODDO 29.ga5,472 0 053.907 6,565,255 3,495.579 47.120.212 13.95 M02 30.02 30.02 1.74 80.3059 63.4259 0.0000 15 OSW 14.0562 74613 IOD,0000 29,556,427 0 7.094.681 6.623,32a 3.515,7B5 47,120,212 1193 30,19 30.19 3019 1 1.751 80.0397 L 63,2157 1 O.ODDO 1 15.14311 14.13701 7.UW2 11000DOO 29,787,3821 0 7.135,455 6.661,3a5 3,535,991 47.120.212 13.89 1 1 30.36 30.36 1 30 Page 3 of 4 llr=2011 2:43PM ou'low"m®r, M 4 Art% ffil"A -WIWI s NONE ... ....... ....... a m A 41", MI"! f qg& IN, a "N" v v ......... ,�W'*P TAX C�1,LAS'i,,','.',�!s"IFI(",,IATION .......... FN 4 0- '1 A9.1 ,-M Uj'�,Az�� H Y RICHARDA C -0, EN MAYOR "Nk, .......... ANW-4M Socioeconomic ED County HAMPDEN School Structure K to 12 Form of Government 4*�+M a yo r 4*'+Council ***#School Committee 2010 Population 28,438 2010 Labor Force 15f578 2009 Per Capita Income 30,032 Land Square Miles 23.24 Unemployment Rate 4*�*2010 8.0 -,g—ta—ndard & Poor"s, Rating AA Services Moody's Bond Rating Aa2 PROPOSED 0 AM* 0 FY20112 Tax Classitica ion Tax Classification Tax Rate Tax Levy Assessed Values Residential 14.35 30,777,830 2fl44,942IS90 Commercial 28.63 6F727,714 235,002ISS3 Industrial 28.63 61280,734 219,389,330 Personal Property 28.63 31333,934 116,456,060 Total 47,1201,212* 2,r715,,790,563 *Difference from proposed tax levy due to rounding 2012 CLASSIFICATION BREAKDOAVN PROPERTYVALUE PERSONAL 4% INDUSTRIAL 8% COMMERCIAL_ RESIDENTIAL COMMERCIAL 0 INDUSTRIAL 0 PERSONAL RESIDENTIAL 79% PROPERTY CLASS PROPERTY VALUE RESIDENTIAL 21144,9421590 COMMERCIAL 235,002,583 INDUSTRIAL 219,389,330 PERSONAL 1161456,060 FY2011 I-XVG. SINGLE FAMILY TAX BILL RANK SINGLE OUT OF ASSESSED AVERAGE TAX FAMILY 337 MUNICIPALITY VALUE PARCELS VALUE RATE TAX BILL CITIES CHICOPEE 11969,964,600 10,957 179,496 14.66 21631 3041 SPRINGFIELD 31524,640,300 26,045 135,329 19.49 21638 303 HOLYOKE 9791854,428 51304 184,739 15.78 21915 273 'AGA WM 11668,670,600 71666 217,672 U.00 31047 258 SOUTHWICK 764,882,400 21993 255,557 13.44 3,435 215 WESTFIELD 21155,853,800 91320 231,315 15.41 31565 194 WEST SPRINGFIELD 11398,282,900 61446 216,923 16.72 31627 188, EASTLONGMEADOW 1�364�7571600 51282 258,379 17.67 41566 108 LONGMEADOW 119101957,800 51442 _351_11501 18,751 6,5841 44 TAX RATES SURROUNDING TOWNS FY2on2 PROPOSED TAX RATE $J14.,35 Resfiden�1@2 $20.6,3 commelrefig municipality FY Residential Commercial Xndustrial AGAWAM 2009) 12.07 26.04 20ILD 12.94 27.07 20 IL 1 14.00 28.32 CHXCOPEE 2009 13.20 28.12 2010 13.63 28.95 2011 14.66 30-30 EAST LONGMEADOW 2009 16.26 16.26 2010 17.38 17.38 2011 17.67 HOLYOKE 2009 � 14.24 35.15 2010 14.98 36.54 2011 IS-78 37.08 LONGMEADOW 2009 17.11 17.11 2010 18.28 18.28 2011 18.75 18.75 SOUTHWXCK 2009 12.55 12.55 2010 13.44 13.44 2011 13.44 13.44 SPRXNGFXELD 2009 17.89 36.98 2010 19-50 39.25 2011 , 19.49 38.97 WEST SPRXNGFIELD 2009 14'.66 33.85 201LO 16.00 34.69 2011 16.72 34.20 WESTFIELD 2009 13.94 27.61 2010 14.68 28.60 2 011 15.41 29.13 COMPARATIVE TAX EFFECT TAX COMPARISON FY 2012 Fiscal Year 2011 Fiscal Year 201112 TYPICAL COMMERCIAL PROPERTY T--- -'Va I u--e J§§�,2-00 T $556,200 it .61 1.62 1 A53 1.64 1.65 1.66 1.67 1.68 1.69 -TO .71 28.3 Factr 0.837657 OM9-499-5 0.83-23-34'1-0..629673 0.827011 0.824350 0.8216M 0.819027 0.816366,0.813704 OA1 1043 Tax $15j752, Rate 1 $2793 $2B 11 $2818 $28,45 $28.63 $28.80 $28.98 $29AS $2'9-.3 $29.50 $29.67 FY 2011 AVG INCREASE $16,019 , $16,119 $1 0 Tax $15.535 $15.635 $15,729 $15.824 $1 PS,9 2 4 6,213 $16.308 $16,41:81 $16,502 ax $ 2--- WfWr.� $7-2­1-$V-1-2 - $287 $367 -$462±:$�-$iiS�$751 1 -$217 41117 422 Fiscal Year 2011 Fiscal Year 2012 TYPICAL INDUSTRIAL PROPERTY Vy ail ue - $826,600 Value 1 $8 %600 Shff t 1.61 1.62 1.63 1.64 1.66 1,66 t6? 1.68 1,69 1,70 -L, 28.32 Factor 0.837657 .0.834995 .832334 0.829673 0.827011 0.624350 0.821688 0.619027 0,816366 0,813704 0.811043 s! $27- $28.45 $28.63 $28.80 $28.98 $29.15 $29.32 $29.50 -W-1a.67- .93 -$5-11 $28.28 FY 2011 AVG INCREASE1 Tax $23,087 '236 $23,376 $23,517 $23,666 23, 06 $23.955 $24,096 $24,236- -$-24,3-85 -$24,525 $397 -$33 $5" i686 $827 $976 Fiscal Year 2011 Fiscal Year 201i TYPICAL RESIDENTIAL PROPERTY $�-19,00 Value value $219,000 1.62 1'63 1.64 1.65 1.66 - 1.67 - 1.68 1.69 1.70 1,71 0, 0.834 3i-334 0.829673 -6182761-1 6�-82,�35-0 0,�-21-688 0,819027 8-13 7-04 -6-s-i 1 cW3- 7� fii-Ftit-o- 14. i -FWGor-- 5 995 a B Tax $3,066 I Rate $1453 $j:4�49T$14,44 $1,�.40 $14.36 $14.30 $14.2 12 $14.07 FY 2011 AVG INCREAS T $3,173 $3,162 $3.154 $3,143 $3.132 $3,123 $3,112 $3,101 $3.092 $3,081 �$101 Dfferenc� $66 $57 M $35 $26 I 11/2312011 Town of Agawam 8:54:0 BAM ASSESSMENT CLASSIFICATION REPORT: LA4 - Resigential Upen ZjDace Uommercial Industrial tiers. Propel a andType ChaDter Parcels Classl Class2l Class4k I ClasS5 ndType 01: 7,6811 1,680,002,9001 1 02: 1,6031 227,924,1001 1 Misc Res: 151 3,878.7001 1 1 4: 1 4151 82,333,6401 1 05: 251 5,423,4001 1 1 11-125: 601 95,187.0001 30-32& 106:1 1 7251 32,801,8001 2 00-299: 1 1 01 01 00-399: 1 1 3091 01 1 214,851,9001 00-499: F 1641 01 1 -7-218,701,7001 CH61 Land: 1 6 41 01 1 14,2561 H61 A: 1 73 411 01 1 1,121,0481 H61 B: 1 13 41 01 1 1,458,2991 12-043: 1111 17,391,0501 1 17.557,0801 (387,6301 �01: 4861 01 3,670,190 6, 502: 3011 01 39,195,970 03: 4 01 1 18,380 04.550-552: 21 01 55,9".820 50-5: 21 01 %861,800 06: 1 1 01 1 6,179,500 08: 71 01 1,585,400 0 nvalid LUC: 01 01 [TAXABLE CLASS VALUE 2,144,942,590 0 235,002,583 219,389,330 116,456,060 asmi R/E COUNT: 11,157 REAL ESTATE TAXABLE: 2,599,334,503 248 R/E EXEMPT VALUE: _A 368,726,2" R/E TOTAL COUNT: 11,405 R/E TOTAL VALUE: 2,968,060,747 JP/P COUNT:WOMA 803 PERS.PROP,TAXABLE: 116,456,060 TAXABLE COUNT: 11,960 [�FVE&PP TAXAR-E VALUE: 2,715,790,5631 lQuestions concerning this report should be directed to the following person: Name Title Dav-Timp Phone# DEPARTMENT OF REVENUE MINIMUM RESIDENTIAL FACTOR COMPUTATION FOR FY 2012 AGALALAM City/Town/District A B C Class Full and Fair Cash Percentage Valuation Share 1. Residential 2,144,942,590 78.9804% 78.9804�-/. 2. Open Space 0 0.0000% 3. Commercial 235,002,583 8.6532% 21,0196% 4. Industrial 219,389,330 &0783% 5. Personal Prot)ertv 116,456,060 42881% TOTALS 2,715,790,563 100,0000% L-- .- ..—I Maximum Share of Levy for 150% X 21.0196% 31.5294% Classes Three, Four and Lines 3C +4C + 5C L Max% Sha:re::] Personal Property : I - Minimum Share of Levy for 100% 31.5294% 68.4706% Classes One and Two : Max% Share %Share::] Minimum Residential Factor W4706% 78.9804% 86.6932% (MRF) Min % Lines 1 C +2C Minimum Residential Factor MINIMUM RESIDENTIAL FACTOR 86.6932% LA7 (6-96) Chapter 58. Section 1A mandates a minimum residential factor of not less than 65 percent. DOW 11129/2011 3:05 pm Page 1 of 1 TAXFLA7 CALCULATION.!2F JHELOWEST POSSIBLE RESIDENTIAL FACTOR CHAPTER 200 FOR FY 2012 AGAWAM 1. Last year's chosen residential percentage(R)*. 66.5274% 2. This year's MRF using a 150% shift to CIP (from LA-7), 86.6932% 3. Minimum residential share(R) in current year using 150%Shift to CIP. 68-4706% If#1 is greater than #3, j_TOP! 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.0397% 5� Multiply this new residential factor by this years FFCV residential 63.2157% percentage(R). 6. What is the lowest historical residential percentage since the first 69-3317% certification (R). If#5 is greater then#6, ITOP! You may shift up to 175% to the CIP 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%). & 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: 1112912011 3;06pm Page 1 of 1 sham Pwcantog" Low Amourft Estinuted Tax Rates CIP Res What ff..Scenario War*Sheat Shift Factor Rars os Cam tnd PP Total Res 05 com Wd PP Total R" 05 Com Ind PP CLASS VALUE % 1,01 997339 78.7702 0.0000 8.7397 8.1591 4,3310 10D.0000 37.116.693 0 4.118,177 3,8".571 2.040.772 47.120,212 1T30 17.52 17.52 17.52 Ites Z,144,942,590 78.9804% R&0% 1.02 09 4877 78 55M 0,0000 8.8263 8.2399 4,3739 100.00DO 37,017,"S 0 4,15A.S51 3AWAV 2,0W,977 47,120,212 17.26 17.70 17.70 17.70 08 0.0000% 7&9804% 1,03 02DIO 75,349a OWW 8.9M 8.3208 44188 100.0000 36.918,6u 0 4j99.725 3.920,701 2.081,183 47,120.212 17-21 1707 17 87 17.87 Com 235,002,6113 8.6632% 1,04 N,9355 70,1396 0.00DO 8.9W3 8.4014 44596 100.00DD 36.619,55D 0 4,240,499 3,M.768 2,101.389 47,120,212 17,17 1804 1804 1804 Ind 219,389.330 8.0783% C I P% 1,05 986693 71.9294 0.0DD0 9.0859 84822 45025 106.0000 36,720,514 0 4.281,273 3,9W.831 2,121.594 47,120,212 iT12 18.22 18 22 A 22 PP 116' '060 4.2881% 21.0196% 1.00 0,4032 77,7192 0.00W 9.1724 85830 4.5454 IDOMW 36,621.469 0 4,322.047 4.034,896 2.141,800 47.120.212 17.07 18,10 ion 4 39 Total 2,716.790,U3 1,07 08,1370 7715M 0 ODW 92559 86438 4.5883 100000D 36,522,425 0 4,3r.2,021 4,072,961 2.162,006 47.120,212 17.03 iS.56 18,56 18.56 E :10=0-00o0% PAGE 2QWN TO COMPLIEUE DATA EMTR�D 1 M 9T6709 77L2W8 OL0000 91454 0,7245 4,6312 100 000D 36.423.380 0 4.403,595 4.11 1,D26 2,IB2,211 47,120,212 16.W 18.74 18.74 18.74 CLASSIFICATION OPTIONS 1.09 07600 77MW 00000 94320 B.BM3 46740 WO 000� 36.324.U$ 0 4,444,369 4,149.091 2.202,417 47.120,212 16,93 16.91 1891 113.91 1.10 97.3386 76.67a5 00000 9,5185 5.8W1 4.7169 100 GOOD 38,225,290 0 4.485,143 4j87.i56 2.222,623 47.120,212 16,89 1909 1909 1909 Residential Exempt IM 070725 786683 00000 96050 B.9669 4,7598 10000DO 36.126,246 0 4.525.917 4,225,721 2.242,1128 47.120,212 16A4 19.26 1926 1926 Small Commeretail 112 968064 764581 00000 96510 90477 4.8027 100 ODDO 36.027.201 0 4,566.691 4,2B3,286 2,263.034 47.120,212 16.80 19.43 19.43 19.43 Exemption 1.13 9B 5402 782479 0 DODO 9.7761 9.1285 4.8456 100 0000 35,928,156 0 4,W-1,465 4,301,351 2,283,240 47,120,212 1675 19,61 1951 10.81 LEVY 114 952741 760377 DMOO 9.11646 9.2092 4 86M 100 DD00 35,829,111 0 4,648,239 4,339.416 2,30�445 47,120,212 1610 19.78 19,78 1978 1.15 960079 75 a275 4100M 9.9512 9.2900 4.9313 10D.DD00 35,730,007 D 4,689,013 4,377,A81 2.323,651 47,120,212 16.66 49.95 19.95 19.95 $47,120,212 Estimated Levy 1.16 95.7418 756173 0 000a 100377 9.3708 4,9742 10D.DOOO 35,631,022 0 4,729,787 4,415.546 2,343,867 47,120,212 16,61 20.13 20.13 2013 17.35 Single Tax Rate 1,17 95.4757 75,4071 0.0000 10A242 9.4516 5,0171 1 OD ODW 35,531.977 0 4.770,561 4,453.611 2.364.OB2 47,120,212 16.57 2030 20.30 20.30 1.18 95,2095 75.1969 0.0000 102108 9�53L24 6,0600 10D.ODW 35�432.932 D 4,B11.335 4,491,677 2.384,288 47.120,212 16.52 2047 2047 20.47 Note: This table should be Used for planning 1.19 94.9434 74.9W7 0.0000 10.2973 9�6132 5.1023 $OD.0000 35.333.8W 0 4.852.109 4,529,742 2.404,474 47,120,212 1647 20.65 20.65 2065 purposes only.Actual calculations may 1.20 94.6773 74.7765 O.D000 10.3838 9B939 5,1457 100,00DO 35.234,643 0 4,692,M 4,567.807 2.424.679 47.120,212 16.43 20,82 2082 20 N differ slightly due to rounding.For actual calculations,complete Recap. 1,21 944111 74.5663 O.DOOO 10.4704 9.7747 51 BW 10D 0= 36,135.7" 0 4,933,857 4,605.072 2.444.885 47.120,212 16.38 20.99 20.99 2099 1 1,22 94.1450 74.3501 00000 10.5569 9.11555 52315 10D.00DD 15.038.754 0 4.974,431 4,843.937 2,465,091 47,120,212 1633 21,17 21,17 21,17 123 938789 74.1459 0 0DOD 10.6434 99383 62744 JW.0000 34.937,709 0 5,015,205 4,W2,002 2,405,298 47,lzu, 21.34 21.34 21.34 1.24 93,6127 73.9357 0 OODD .10.7300 $0.0171 53173 i00.00W 34.M.684 01 5,055,979 4,720.087 2.505,502 47.120,212 16.24 2t5i 2t5l 21.51 11.261 933466 1 73,7255 1 0 0000 110.81651 1009791 $3601 1 100.0w 34.139,619 0 5,0W.753 4,75B,132 2.525,7DO 47,120,212 16.20 21.691 21.69 1 21.691 Page I of 4 11123MIl 2:43PM Share Pomm"es. Le"Amourft Fjitlffuftd Tax Rafts CIP Res What ff..Scenarfa Worksheet ShM Faclor Rn 03 Com Ind pp Total Res OS Com Irld pp TOW Res OS com bid pp 1.26 93.GB04 73,5153 Q.00DO 10.9= 10.1786 5,4030 1 DO.00OD 34,640,575 0 5,137,527 4,7W,197 2,545.913 47,120,212 16.15 21.85 2tw 21.86 117 92.8143 733051 O.00DD 10.98% 10.2594 54459 1 0D.00DD 34,541.530 0 5.175.301 4,eU,252 2,5W,119 47,120.212 16.10 22,04 22.04 22.04 1�28 92,S482 730949 0 O(M 11.0761 102402 SAM8 100 OOOD U,442,486 0 5,2ig.075 4,872,327 2.5W.325 47.M,212 16.06 22.21 22,21 2.2.21 129 922820 728847 00000 11 AM 10A210 55317 1000000 34,343.440 0 5,250.849 4,910,392 2.SW.530 47,120,212 16.01 22.38 22,38 22.30 1.30 92.0159 72.6745 O.DDDO 111492 10.5018 55745 1 DO ODDO 34,244,396 0 5,30D,623 4,948,457 2,62e,736 47.120,212 15.97 22.56 22.56 2256 1131 91.74H 72.4643 0,0000 11�3357 1 0�5826 5.6174 100 OOW 34.145,351 0 5,341,397 4,OW.522 2,648,942 47.120,212 15.02 22,73 22.73 2273 4.32 01,4830 72.2541 0�000D IIA222 10 W33 56603 100 OWO 34.040,3DS 0 5,382,171 5,024,587 2,687.147 47,120,212 15.87 22,90 22.90 22,9D t.33 912175 72.0439 0.000D 11�5N)7 1 OY441 5.7032 100 ODDO 33.947,261 0 5,422,945 5.062.662 2,687.353 47,120,212 15.63 23.08 23.08 2308 1,34 DOV514 71.83M 0�00W 11,5953 10.8249 5,7461 100,0000 33.548,217 0 5.463.719 5,100,717 2.707,559 47,120.212 15.7a 23.25 2325 2325 1.35 906852 71-623B 00000 11,6818 M9057 5.7889 1000000 33,749,172 0 5,604,494 5,138,782 2.727,764 47,120,212 15.73 23.42 2342 2342 1.36 004191 71 4134 00000 11,7683 %9885 5.8318 100.ODOO 33.650,127 0 5,545.268 5,176,847 2,747.970 47,120,212 1569 2160 2360 2360 1.37 901529 71.2032 0 ODOO 11.8549 11.0673 5,8747 100 ODOO 33,551,082 0 5.586,042 5,214,913 2.70,176 47,120,212 1 5�64 2377 23.77 23.77 1,30 89 6M 70.9930 0 ODOO 11.9414 11.1480 5.9176 1000000 33.452,03a 0 5,626,01e 5,252,979 2,7a8.381 47.120,212 1560 2394 2394 23.D4 1.39 896207 70.7828 00000 12.0270 11.2298 5.9605 100 OOM 33,352,003 0 5,667.590 5,291.043 2,8W.587 47,120,212 15.55 24 12 24.12 24,12 1.40 89.3545 705726 00000 12.1145 11.3a96 6.0034 10D.ODOO 33,253,"S 0 5,708.364 5.329,106 2,a28,792 47.120,212 15,50 2C29 2429 2429 1,41 89.0884 703624 O.00W 12.2010 11.3904 6.W2 100,ODDO 33,154,9M 0 5.749.138 5,367.173 2,W.M 47.120.212 1548 2446 2448 2448 1.42 88,8?23 701522 0.00W 12.2875 11.4712 6.0891 1 DD ODW 33,055,859 0 5.789.912 5,405,238 2,869.204 47.120,212 1541 2464 2464 24.64 1.43 66.5WI %9420 O.ODW 12.3741 11.5519 6A320 10D.ODOO 32,956,814 0 5.830.M 5,443,303 2,880,4D9 47,120,212 1536 2481 2481 2481 1.44 86.29W 69.7310 O.00DO 12.4606 11.6327 6.1749 IDD.0000 32,057,769 0 5.671.460 5.481,368 2,W9.616 47,120,212 1532 24,98 24.98 24,98 1,45 88 D238 1 69.5216 0.0000 12.5471 11.7135 62178 IDD.00DO 32.758,724 0 5,9Q.234 5.519,433 2.9n,821 47,120.212 1527 2510 25,16 2516 1,46 $73677 69,3114 O.ODDO 12.8M7 11.7943 6.2606 IOD.0000 32.659,6W 0 5.M.008 5.567,498 2,950,=6 47,120.212 1523 25.33 25.33 25.33 1.47 ST4916 69,1012 0,00W 12,7202 11.8751 SrW35 100-0000 32.560.M 0 5.003,702 5.595,563 2.970.232 47.120,212 15.18 25.51 25.51 2561 148 87.2254 WNW DMOD 12.BM7 11.0550 0.3464 WoOOO 32,40,590 0 6.034,558 5.6W.628 2,DW,438 47.120.212 15.13 25.68 25.68 25.68 149 889593 686608 0,0" 1281133 12 11" 63893 1000M 32,362.545 0 13,076.330 5.671,893 3.010,643 47.120,212 1509 'a' 2,al. 0000 . 6 .04 1.501 8816932 1 68.4708 0. L121798 12'11741 4322 100.00W 32,263,501 116,1041 5,709,758 3.030.8491 47,120,2121 15 1 2603 20 M 26-1 Page 2 of 4 1 V2312011 2:43 PM BMrQ Pamentagas Law Amounts Esfimated Tax Rafts CIP Res What It..Scenario Worksheet Shift FACtGF Res 05 Corn Ind PIP Tout Ras 03 Corn [rod PIP Total Res Cis Corn trod pp 1.51 864270 68,26U 00000 13 OBB3 12.1982 6.47-50 100.0000 32.464,456 0 $,156,678 5,747.823 3,051,055 47.120,212 15.00 28.20 26.20 2620 1,52 88 tGO9 60,OW2 O,OOM 13,1129 122190 6,51711 101,00110 32,Oa5,411 0 6,197,652 5,7115,888 1,1111,260 47,120,212 14,ID5 26,31 211,37 26,31 1.53 85 8M 67,84DD 0,0000 13.2394 12.3590 65608 100.00DO 31,966,367 0 6.238,426 5,823.953 3.NI,466 47,120,212 14.90 26.55 26.55 26.55 1,54 85.6286 67.6298 D.00DO 13,3259 12.4408 6.6037 100.0000 31,867,322 0 0,279200 5,862,M 3,111,672 47.120,212 14.86 26.72 26.72 2672 1.55 853625 67.4196 D.00DD 13.4124 12.5213 66468 1000000 31.768,277 0 6,319,974 5,90D.084 3,131.877 47,120,212 14.81 26.89 2689 26 6D 1�56 85M63 871094 Q.00DO 13.4990 12.6021 6.6895 100.00DO 31,869,232 0 6.3W,748 5,938.149 3,162,083 47,120.212 14.76 27.07 27.07 27.07 1.57 64.6302 66.9992 0.0000 13.5855 12.6829 8.7323 iOO,OW 31,510,189 0 6.401�522 5.976.214 3,172,289 47.120,212 14.72 2724 27,24 27.24 1.58 54.6641 66.7891 O.00DD 13.6-120 12,7637 6.2752 1000M 31.471,143 0 6.442,296 6.014,279 3.192,494 47.120,212 14.67 27.41 27,41 2741 1.59 64.2979 68.5789 O.GM 13.7586 12.8446 6�0181 100,OODO 31,372,098 0 6,483,070 6.052,344 3,212,700 47,120,212 14,63 27.51 27.59 27,59 1.60 64.0318 66.3687 O.00DO 138451 12.9253 6.8610 1 OD 0000 31,273,053 0 6.523.9" 6,090,409 3,232.N6 47,120,212 14.58 27,76 27,76 27,76 1,61 83,7657 66,1585 OOM 13,9316 13.00W 6.9M9 IMM 31.174,009 0 6.564.618 6.128,474 3,253,111 47,120,212 14,53 27,93 27,93 27.93 1.62 83.4995 65-IM413 00000 140182 13 OE108 B.W7 100.0000 31,074.964 0 6.605,392 6,166.539 3,273.317 47.120,212 14,49 2&11 28.11 28.11 1-63 83.2334 65.7381 0.0000 14,1047 13.1676 6.9696 IOD.00DO 30.975.919 o 6,e4a.ieO 6.21)4,604 3.291,523 47.120,212 14.44 2828 2828 2526 i,e4 a2.9673 65.5279 D.00DO 14,1912 13.2484 7,0325 imcgm 3o,alf,,074 0 6,6W,940 6,242.669 3.313,726 47,120,212 14.40 2a 45 2846 28.45 105 82.7011 65.3177 0 OWO 14.2778 13 32q2 7,0754 100 ODOO 30,777.830 D 6,727.714 B,2BO,734 3,333.934 47,120,212 1435 2863 2863 28.63 1.86 82.4350 65.1076 O.00DO 14.3643 13.4100 TIM IOD.DDOO 30,676.785 D 6.758.488 6,318.7N 3,354,140 47,120,212 14 3D 2860 20.80 28.80 1 V 82.1608 64.8973 0.00W 14.4508 13.4907 7.1611 10D.ODDO 30,579,740 0 6,41W,M 8,358,864 3,374.345 47.120,02 1426 28.98 28.98 2B 98 160 011027 64.6671 O.DDDO 14.5374 13.5715 72040 IDO.0000 30,480.05 0 6.aM,036 6,394,929 3.394.551 47,120,212 1421 29.15 29.15 29 15 1,69 111,6386 64.4769 0.000D 14.6239 13.6523 7,2469 JOV0000 30,381,661 0 8,00,810 8,432,9W 3,414,757 47,120,212 14.18 29.32 29.32 29,32 110 81.3704 B42667 0.00W 14.7104 13.7331 7.2898 IDD.ODOO 30,2112,606 0 6.931,564 8.471.050 3,434,962 47,120,212 14.12 29.50 29.50 29.50 1.71 BIAD43 64.D585 0.000D 14.7970 13.8139 7.3327 IDD.ODOO 30.1 B3,561 0 6.972,35B 5.5W.124 3,455,168 47.120,212 14,07 29.67 2987 2967 1.72 808362 63.8463 O.DOOD 14.8M 13.8W7 7.3755 IOD.0000 30,054,516 0 7,013,132 6.547.189 3,475,374 47.120,212 14.D3 29.04 29.84 2984 V3 80$720 63.6WI 0.0000 14.9700 13.9754 7.4184 1000000 29,905,412 0 7.CM.907 8.505,255 3,495.579 47,120,212 13.98 30.02 3002 3002 1.74 M3059 034259 0 DOOD 15,0668 140%2 T4813 IWOMO 2%8W,427 0 7.DB4.681 6,623.320 3,515,785 47,120,212 13.93 3019 3019 3019 1,751 80�C*97 W 2157 1 O.00W 1 15,1431 1 14.13701 7,W42 1 1000M 29,707,M 0 7.135.455 6,6BI,385 3.535,991 _47.2L21J2 13.89 30,36 1 3036 30301 Page 3 of 4 1 10=01 I 2:43PM