Loading...
TR-2011-58 RESIDENTIAL TAX FACTOR '��� �_� __-- __� h r �� I . _...._ ��1 �1 s ak l ` s t kZ TES FY 2012 TAXRA ........ RESIDENTIAL COMMERCIAL PERSONAL PROPERTY 2i TZ `S` y; r 4M, k� Pei- m. # 'Per Thousand Effective J ties , e 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 OPEN SPACE 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 PERCENTS 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 Exempt SMALL-COMMERC1 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 454,391,913 minus Exemption Signatures Signatures for LA5 0 (Board of Assessors) (Date) Comments: L. Certification w;(*1t*1tf1AtW n,:n%- 1 1/10 IM I 1 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 Roberta 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) Comments C: (Authorized Signatur ) (Date) Comments: (Authorized Sign ore) (Date) Comments- /2-/4.5 0 (Authorized Signature) (Date) Commentsl (Authorized Si (Date) Comments Page a of"I U (Authorized Signature) (bete) Comments: Ile (Autha zest Si nature) r (Date) . t Comments: Views Edil Lis) SIgIV5 of TaxR tip View More — ViewLast Uodater In(grmation Calculate&Save ] r"rnt Sbrtslt Ctisar ttp,s:/Aldisgatf'.1 ,iy. or.staic.illkt.11�/4 dtt�Vtit'���tt\"sxtE`�'4�i ���'d1I°r�t,�� tt�29�t��1.gi ntintw .iQnv 11/ f1+7ff1 t TR-2011-58 A RESOLUTION ADOPTION A RESIDENTIAL FACTOR OF Q.8�1 PURSUANT TO MASSAC USETTS 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 o i,uq NOW THEREFORE, THE AGAWAM CITY COUNCI hereby resolves after conducting a public hearing to adopt residential factor of 0.82 pursuant to Massachuseup General Laws, Chapter 40, Section 56;andCD DATED THIS OF 2011. ! ,. PER ORDER OF THE AGAWAM CITY COUNCIL :K . -n -n r Donald M. Rheault, President Wow AI' 'VEIL ' TO FORM AND LEGALITY Nnce t ios ia, Solicitor cowrcd CK:1 C� --- MAYORAL ACTION Received this day ofD�-C�tom, 011 from Council Clerk Signed by Council President this 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, 1 h Oe arcve the passage of the above legislation can this Clay of Q11 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 can this day of 2011 for the following reasons) Richard A. Cohen, Mayor RETURN OF LEGISLATION TO COUNCIL ILCLERK Returned to Council Clerk this day of 2011. AGAWAM CITY COUNCIL 36 MAINSTREET AGAWAM, MASSACffUSETTS, 01`001 ' - LEGAL NOTICE LEGAL NOTICE PUBLIC HEARING AG.A► AM CITY COUNCIL PRESIDENT Donald M. T�Trau![; The Agawam City Council will conduct a public hearing on Monday December S, 2011, at 7:00pm, at the Roberta G. 'Doering School, 58 VICE PRESIDENT T 'Whin Street, Agawam, MA to consider the adoption° f a Residential Robert E. Rossi Tax Factor pursuant to 'Massachusetts General Laws, Chapter 40, Section 5 as submitted to the City Council by the Mayor 'on C©�t�i+tw't1�Ft ; November 17, 2t71 I. , Creorge Bitzas James P. Cibherti Gina M. Letetiier The Resolution (TR-201 l- 8) is available for public inspection at the Roben A Maagovern City Clerk's Office, 36 Main Street, Agawam, MA between the hours Jill S,Messick of 8:30arn to 4;30prn, Monday through Friday. It is also available at Joseph Mineo the Agawam public Library, 70 Cooper Street, Agawam', MA and the Dennis J P,err, .Till P.Simpson; Agawam Senior Center, 954 Main Street, Agawam, MA. John F" Walsh ADMINISTRATIVE BY O ER OF< ASSISTANT Barbara A Bard plonald M.'Rheault+ ' President of the City Council TO ICE ADVERTISED ON 11 4/1`1 > - C c" NJ rn (4'13) 786-0400 Ext. 233 FAX (413) 786- 9 7 ]EMAIL bbardQa agawarn.ma.us LC_g_o_1 _ NofiCC_S AGAWAM ZONING MA to consider the adoption BOARD OF APPEALS of a Residential Tax Factor` LEGAL pursuant to Massachusetts ADVERTISEMENT General Laws, Chapter 40, Oetober 24,2011 Section 56 as submitted' Notice is hereby given 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 58) 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;Center, 954 Agawam Zoning Ordinances Main Street,Agawam,MA. to allow for an addition to a BYORDFR OF residential structure with less Donald M.Rheault than the required frontage; President of the 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 Springfield,MA 01103 PUBLIC HEARING (413)748-7758 AGAWAM Docket No.HD1I.P221IEA CITY COUNCIL In the Estate of: The;Agawam City Coun- James J Burgess cil will conduct public hear- Late.of:Agawam, ing on Monday, December MA 01001 5, 2011, at 7.00pm, at the Date of Death: 10/27/2011 Roberta G. Doering School, NOTICE OF PETITION 68 Main Street, Agawam, FOR PROBATE OF WILL �Iivlr, .ri-.f,5 pon for a tree appetizer or cessert .rota y. 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 malting balloon sculptures. were donated To make an.appointment to donate blood, m see because call i-800-RED CROSS (1-800-733-2767); vas used in 45 or log onto rederossblood.org. - 6 8- 9: 10 11 12 13. is 16 16- 19 23 zs 26 31 32' 33 :34. 3 38. 39 41 42 45 46 49: 50: '51- 53 54 58. So BQ 61 63> 64 65; :Be B 69 70 3 lated on the, CLUES DOWN 31. 14027 NY !r s side L one who feels' 32.A citizen of 1pposite'of penitence Havanna ming 2.Name meaning 33.Very coldly drikaans "God knows" 34.Singer .very small 3.Tel_, Della tar shape; Israel city 36.Wager' tateriaf 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 -,- , ; - 40 ?i;er< 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 alter 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 AiGAWAM CITY COUNCIL Donald`M. Rheault,President Ap VED TO FORM AND LEGALITY ,cent` ioscia, 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 VEIL AS FORM AND LEGALITY 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 Giosc Solicitor ��C,,Z2 k?{t,,tY t}irj`iti :7t4 t{flr3t,�Yd F#rr k�.'1t sl{tt €. i ts'{i 3 ,. tc ..Yt s t e s,�zY,"Sz',:}t P��s�lst.42��t�ti,Ir�yn..l{tt}�ts�f��tlt ft«ti}��'r 3�. rr s>•.s. r Z s t s i t s3}. !t tt tLe t�l to l� \�?�st �,�:}ktii?1�Y,,�� ���13t�St,,�ttYsrt zi�s�.) t} rr��,4.}. att 2Y ;•t�r:'.�lr}^t ft r t t tr) { rt t ) s rC tF y=w,^ ti if 4 T f S;sFS f F)} F 2 3 f I 2F{ tt }{? 1 3}iS t}t j . } tt ltt ,z l gF �ynitFtY r 1 ro 1 s� J'0'WN rr�tt,z ,e..,,. ts,,.,.,, ^r„. #r {}t u T,�X CLASSIFICATION FY 2012 it RICHARD COHEN M..�k'YOR s ) f t t t 'F tt ti tt tYt t tt tt st st i 5�2`t � s i st{�a sstti :�i�sltz t r7ts?tCw>:tt)t4 sEYrgt�zlt,tS i 4jliryt Nocioeconomic ,d E� Count y HAMPDEN School Structure K, to -1 Form of Government y or **.* ouncil ❖School Committee 201LO Population 28,438 2010 Labor Force 15,578 2009 Per capita Income 30,032 Land Square Miles 23.24 ti n m l y m n t Rate ***• 010 8.0 Standard & P is Rating services l y's Boni Rating Aa2 r t PROPOSED FY2012TClassification 1 d e sssse Tax Classification Tax; Rate Tax Levy Assessed Residential 14.35 30,777,830 2144,942,590` Commercial 28.63 6f727,714 235,002,583 Industrial 2 .63 61280,734 219, 89,330 Personal Property 28.63 3,333,934 116,456, 60 Total 47120,212* 21715,790,563` *Difference from proposed tax levy due to rounding 2012 CLASSIFICATION BREAKDOAVN PROPER VALUE PERSONAL 4 INDUSTRIAL 8% COMMERCIAL -A-- - 9% III RESIDENTIAL ■ COMMERCIAL 0 INDUSTRIAL 0 PERSONAL RESIDENTIAL 7 % PROPERTY CLASS PROPERTY VALUE RESIDENTIAL 21144,942,590 COMMERCIAL 235,002,583 INDUSTRIAL 219,389,330 PERSONAL 116,45 ,06 r 2011 . A TGo N IGLEFAMILY 1 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 31624,640,300 26,046 135,329 19.49 2,638 303 HOLYOKE 979,854,428' 5,304� 184,739 16.78 2,916 273 AGAWN 11668,670,6001 7,6661 217,672 14.00 3,047 258 SOUTHWICK 764,882,4001 21993 266,557 13.44 3,435 215 1 WESTFIELD 21155,853,800 91320 231,315 16,41 3,66 194 WEST SPRINGFIELD 11398, 82,900 61446 216,923 16.72 31627 188 EAST LONGMEADOW 11364,757,600 5,282' 258,379 1167 4,566 108 LONGMEADOW 1,91019671800 61442' 3511150 18.75 61684 44 1 1 TAX RATES SURROUNDING TOWNS 2o12 PROPOSED TAX RATE $14-35Residential $28.63 Municipality FY Residential Commercial Industrial AGAWAM 2009 12.07 26.04 2010 12.94 27.07 2011 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.15 2010 14.98 36.54 2011 15.78 37.08 1 LONGMEADOW 2009 17.11 17.11 2010 18.28 18.28 2011 18.75 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 2011 19.49 38.97 1 WEST SPRINGFIELD 2009 14.66 33.85 2010 16.00 34.69 2011 16.72 34.20 WESTFIELD 20091 13.94 27.6`1 20101 14.68 28.60 20111 15.41 29.3. COMPARATIVE TAX EFFECT TAX COMPARISON FY 2012 Fi§cal Year 2111 Fiscal Year 2012 TYPICAL COMMERCIAL PROPERTY Value 1622,600 Value $622,600 Shift 161 1.62 1.63 1.64 1.65 166 1.67 1.68 1.69 1.70 171 1` Tax Rate 28.3 Factor 0.837657 0,834995 0,832334 0,829673 0.827011 0.824350 0.821688 0.819027 0.816366 0.813704 0,811043 Tax $17,63 Rate $27 93 $28.11 $28.28` $28.45; $28.63i $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 $17,931 $18,043 $18,49 $18,255 $18 367 $18,473 $112 Difference -$243 4131 -$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 166 1.67 1.68 1.69 1.70 1171 Tax Rate 28.3 Factor 0.837657 0.834995 0,B32334 0,829673 0.827011' 0.824350 0.821688 0,819027 0.816366 0.813704 0.811043 Tax $23.409 Rate $2793 $28.11 $28,28 $28.45 $28.63 $28,80 $28.98 $29.15 $29.32 $29.50 $2967 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 Difference 4322 -$174 •$33' $107 L.! $397 $646' $686' $827 $975 $1,116 mmmi Fiscal Year 201`1 Fiscal Year 2012 TYPICAL RESIDENTIAL PROPERTY Value $219.000 Value $219,000 shsff 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.00 Factor 0.937657 0.834995 0.832334 0.829673 0,827011 0,824350 0.821688 0,819027 0.816366 0.813704 0.811043 tax< $3.066 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 INCREAS Tax $3.182 $3173 $3,162 $3,154 $3,143 $3,132 $3,123 $3,112 $3.101 $3,092 $3,081 $101 Difference; $116 $107 $96 $88 $77 . $66` $57 $0 $35 $26 $16 1 11 312011 Town of Agawam &54:08AM ASSESSMENT CLASSIFICATION REPORT: LA4 i n 1a n ace ornrnerc 8_ n u8 r0 ers:, rope EVv andT` pe Chaster Parcels Classl Class2 less Class4 Classy l", 01 7,681 1,680,002,900 02: 1,603 227,924,100 Misc Res: 15 3,878,700 04: 415 82,333.640 05: 1 25 5„423,400 111-126 60 951 87,000 30-32& 106 725 32,801,800 00.299 0' 0 100-39�9: 309 0 214,851 900 00-4'99: 164 0 218 701,700 CM61 Land: 6 4 0 1 14,256 H61 A, 73 41 0 1 1,121;048' M61 B: 1 13 4 0 1 1,458,299 012-043: 111 17,391,050 1 17,557,080 687,630 01: 486 0 3,670,190 502 301 0 39,195,970 03: 4 0 18,30 04.650652: 2 0 56,944,820 505: 21 0 1 9.861,800 06: fi 1 0 1 6,179,500 08: 7 0 1,585,400 nvalid LUC: 0 0 TAXABLE CLASS VALUES: 2,144 942,690 0 235,002,583 219,389,330 116,456,060 RIE 13C1UNT-� 11,167 REAL ESTATE TAXABLE 2,599,334,603 EXEMPT CQUNTa 248 I-KE EXEMPT VALUE: 111®1� 368,726,244 RIE TOTAL COUNT 11,405 RIE TOTAL VALUE: 2,968,0€0,747 PJP C T: 803 IPERS.PROP,TAXABLE: k 116,456,060 TAXABLE COUNT: 11,960 TdTAL RJE Ss PP TAXABLE VALUE. 2,79�I5�790,563 Questions concerning this report should be directed to the following person: Narrae Title Da Tirne Phonp DEPARTMENT OF REVENUE MINIMUM RESIDENTIAL FACTOR COMPUTATION FOR FY 2012 AGAWAM City/Town/District A Class Full and Fair Cash Percentage Valuation Share 1. Residential 2,144,942,590 78.9804% 8,9 f 40/. 2. Open S ° �a 0 0.0000,/o 3. Commercial 235,002,583 8.6532% 21,0196% 4. Industrial 219,38 ,330 8.0783% 5. Personal Propertv 116,45 ,060 4.2881% TOTALS 2,715,790,563 1009 0000% Maximum Share of Levy-for 150% X 21.0196% 31.5294% Classes Three, Four and Lines-3C + 4C + 5C P � e : %�Personal Pro �� Max Share Minimum Share of Leery for 100%, 31.52 4% - 68.4706% Glasses One and Two — _ _ Max % Share =in Share r Minimum Residential Factor` 68.4706°IQ / 78.9804% 86,6932% (MRF) Min % Share Lines 1 C +_2 Minimum Residential Factor MINIMUM RESIDENTIAL FACTOR 86.69320/. t.A7(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 TAKFCA7 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, 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.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 1 of I :Share Parce nagn Lavy Amourlta EsUrruged Us Rats.. CIP Rae What lf...Scenario Worksheet snne Factor Raa us corn tnd PP ToW Rn 09 cart uw PP Tate! Res 05 Cam Ind PP CLASS VALUE % 1.01 99.7339 76.7702 00000 0.7307- 8.1501 4,3310 100,0000 37116.693 0 4;118,i77 3,844,571 2.040772 47.120,212 1730 17.52 17,52 1752 Rea 2,144,942,690 78.9804% R&O% IM 994877 78;5800 00000 807W 82399 4.3739 100'ODDO 37017.648 S 0 4158,951 3,882,836 2.060,177 47,120,212 17,26 17,70, 17,70 17.70 08 0.00009E 78.9804% 103 W 2016 78.3498 0 OOW 8.9128 '8 3206 4;4168 100;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% 104 989355 781396 0ODW B.9993P 84014 4,4596 100;00W 36.819,559 f 0 4240,499 ;3.958.766 2,1D1,389 47.120,212 17.17 1804 1804 18"D4 Ind 219,389,330 8.0783% C I.P% 1.05 98.6693 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 984D32 77.7192 00000 9.1724, 85830 4.5454 1000000 36.621,469 0 4;322,D47 4,034896 2,141,8W 47.120,212 iT07' 18.39 10.39 18.39` Total 2,716,790,563100.0000% 1.07 981370 77.5090 OOODD 9.2589 86435 4:5883 1D0;00DO 36.522,425 0 4.362.821 4,072,961 2,162,OW 47,120,212 17.03 18% 1856 1656 ME PQWN T '.0 M TtEspATAENTRY 1 1.08 97;87D9 77.2988 0.00DO 93454' :8.7246 46312 1000DD0 36,423,380 0 44D3,595 4,111,026 2,182,211 47,120212 18.98 1874 1874 18.74 CLASSIFICATION OPTIONS 1.09 97.6048 770886 0.0000' 9.4320 8.8053 46740 100:0000 36.324335 0 4,444,369 4,149.091` 2.202,417 47.120,212 18.93 Iasi 10.91 18,91 1;10 97;33W 78-0785 O,ODDO- 9.5185` 8 6W1 4,7169 1D0`0000 38,225,290 0 4,455.143 4,107,150 2.222,623 47,120;212 16,89: 19.09' 1909 19.09 Residential Exempt 1.11 97.0725 766683 00000' 9.W50' 8.9889 4,7598 1000000 3o,vs,246 D 4,526.017 4,225.221 2,242,928 47.120,212 1684 1926' 1926 19.26 Small Commercial 1.12 96.8064 76.4581 0 OWD 9.6916 90477 458027 iDD:00DO 36,027,201 0 4 566,691 4,263,286 2,283,034 47,120.212 1680 1943 19.43 1943 Exemption 1.13 96.5402 10.2479 0 00W> 9.7781 ':9.1285 4.8456 1000000 35.928,156' 0. 4.607,465' 4,301.351: 2,253,240 47.120,212 1675 061 19 81 19.61 LEVY 1.14 962741 760377 000W 9.8848 92092 4r8884 1DD'00 0 35,829,111 0 4;64e,239 4,339,416 2,303.446 47,129;212 1510 1978 1978 1970 1.15 960079 75,8275 0.0000 9.9512 92900 49313 100:00W 35,73O,Da7 0 4,689.013 4,377,481 2,323.651 47.120,212 1666 19.95 19.95 19,95 $47,120,212 Estimated Levy 116 95.7418 758173 000W 100377 9,3708 4,9742 1000000 35,631.022r 0 4729,787 4,415,548 2343,857 47.120212 1661 20.13 2013 20J3 17.35 Single Tax Rate 117 954757 754071 OD000 10.1242 9,4516 50171 1DD0000 35.531,977 0 4,770,56t <4,453611 2,364,082 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. 47,120 212 16.52: 2047 2047 20,47 Note:' This table should be used for planning 119 949434 749887 0ODOD 102973 96132 5,1025 iOD0000 35333,8813 0 4852,109 4,529,742 2,4D4,474 47,120212 1647' 2065 2065 2065 purposes only.Actual calculations may differ slightly due to;rounding.For 1.20 946773 747765 0,0000 10.3838 9.6939 5,1457 100.0000 35,234.843 0 4.892.663 4,587.807 2424,670 47.120,212 1643: 20.82 2D82 2082 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" L22 94.1450 743561 aOOOD,` 10.5569. i98556 $2315 1000000 35.036.754 0 4,974,431' 4,843,937: 2,465.091 47,120212 i6.33 21.17 21.17 21,17 123 93.8789 74.1459 000DD' 106434. 99363 5.2744 100.0000 34,937,709 0 5.Oi5,205 4,882,002 2.485,298 47,120,212 1629:: 21.34 ;21.34 2134 1;24 03.6127 73.9357 0OD00 10.7300 10.0171 53173 1010000 34;838,684 0 5,055.979 4.720,OB7 2,505.502 47,120;212 16.24 21.51 21.51 21`.51 1 1:25 933466 73:7255 00000 108165 '100979 573601 100.00DO 34.739619 0 5096,753 4,758,132 2,525,708 47,120,212 1820 21.69 21.69 2169' Page i of 11123r2011 2:43 PM Share Perc"gaa Le"Amoume Estimated jai RaCas CIP Ras What fir...Scenario Worksheet snot Factor Res 03 Com Ind eP Toro Rea 03 Corr wo PP Total Res as corn Ind PP 1.26 93�0804 73.5153 DMOO 109030 10.17W 5.4030. 100 0000 34,640;575 0 :5,137,527 4,796,197. 2,645,013 47,120,212 18.15 21.E6 21.86 21.86 127 928143 73,3051 000W 109896 102594 54459 1000W0 34,541530 0 5,178.301 4,834,262 2,568,119 47.120,212 16.10 2204 2204 2204 1,28 92.5482 730949 0 0000 11,070 10 3402 SAM 100 OWO 14.442,486 0 :5,219,075 4,872.327': 2.586,325 47.120,212 16 08 22.21 2221 22.21 1,29 92.2620 728847 0 ODW 11.1626. 10.4210 5.5317 100 ODW 34,343.440 0. :5.259.849 4,910,392: 2,606,530 47.120,212 16.01 22.311 22.38 2238 1.30 92.0150 726745 0 DDDO 112492" 10.5018 5.5745 100.0000 34,244.396 0 5,30D,623 4,948,457 2.626.736 47,12D,212 15.97 22.66 27,56 2256 1.31 91.749E 724843 00000 11.3357 10.5826 5.6174 100.0000 34,145.351 0 :5,341,397 4,988,522: 2,646,942 47.120,212 1592 22.73 22.13 22.73 1.32 91.4836 72.2541 00000 11.4222 10.6633 56603 100.0000 34,046,306 0 5.382,171 5024,587: 2.667,147 47,120,212 15.87 22.90 22,90 22,9D 1.33 91.2175 72.0439 00000 11.5087 10.7441 '5.7032 1D00000 33,947,261 0 5,422,945' 5,052.652 2,687.353 47,120.212 15.83 23.08 2308 23-08 1.34 90.9514 71.8338 O.00W 11.5953 10.8249 '5.7481 100.0000 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 156810 109057. 5,7889 1DO.DODO 33,749,172 0 15,5D4,494 5,138,782' 2,727.764 47.120.212 15,73 2342 23.A2: 2342. 1.36 904191 714134 O.OM 11.7683: 109865 :56318 i00.ODW 33,6W,127 0 5,545,268 5,176,84.7. 2,747.070 47,120,212 15.69 2360 2360. 2360 1.37 90.1`529 71.2032 0,0000 11.8549 11,0673 56747 1Do0000 33555,082:. 0 5,5W,042 5214,913' 2.760. 76 47,120,212 15.64 23.77 2377 7377 1.30 89,WW 70.993D 0000D 11,9414 11.1480 5.9176 "1D00000 33,452,038 0 5.626.816 5,252,978 2,788,381 47,120212 1560 23.94 2394: 2294 1.39 89.6207 70.7828 0.0000 12.0279 11.2208 ':5.9BO5 1000000 33362,993. 0 f6,687.590 5,291,043 2,800.58.7 47,120,212 1555 24,12 24.12. 24,12" 1.d0 89.3545 705726 0.0000 12.1145 11.3096 6OD34:1DO DOW 33,253.940 0 5.700,364 5,329,108 2,828,702 47 120,212 1530: 24.29 24.29 2429 141 r89.0884 70.3624 00000 12.2010 11.3904 '6 0462'100.0000 33,154.903: D ;5,749,138 5,367.173 2,848,W8 47120,212 1546 24.46 2446 2446 1.42 88.8223 70.1522 0 0OW 12.2875 11.4712 60891 '100 0000 33,055,859 D Y5.789,912 . 5.405.238 2,869,204 47 120.212 15,41 2464..:24 e4 2464 1.43 88.5561 69.9420 O.000O 123741s 11.5519 6A320r 100.00W 32,956,814 0 5,830.6W 5,443,3D3 2,869,409 47.120,212 15`36 2461 2481 24111 1.44 88 2900 69.7310 O.00W 12.4606 11.6327 :6.1749 100 0000 32,857,769' 0 ":5,871,480 5,481,36E 2.W9,615 47 120,212 15.'32 24.98 .24 9E 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. 25 16 25 W 1.46 87.7577 69..3114 0:000D 12.6337 11,7943 6 28M 100.ODDO 32,659.6W 0 5,953.008 5.557,498 2,950,026 47,120,212 1523 25 33: 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,595,583 2,970,232 47,120.212 1518 25.51 25.51 25.51 4.48 E7:2254 68.891D O.00DO 12.6067: 11.0669 8.3464:100.00oo 32,481,590 0 6,034,556 5,633,628 2.990,438 47.120.212 15.13. 2568: 2568 2568. 1.49 86 9593 68.9 01 0 OOIb 12.B933 12.0368 63893 000000 32,362,545 0 6,075,330 5,671,693 3.010,643 47,120.212 15 09 25815 25 85 25 65 1.50 866932 68.4708 0.0000 12.97W 12.1174 64M 10000W 32,283,501 0 6,118.104 5,709,758 3.030,849 47.120,212 15.04 2603 1 2803 2803 PaO 2 oI a 11/2312011 2:43<PM Share Pereentagsa Amourib Estkmtw Tax Rates CiP Res What if...Scenario Worhsheet Sht11 Factor Res Os Com Intl PP Tote) Res 05 COO Intl PP Total Res as Cem ma PP 1.51 864270 682604 0`0000 130663 `12.19$2 :6 4750 100: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 68;0602 0:0000 131529 -12,2790 :6.5179 100:0000 32.065,411' 0 6,197,1151i 5,785,888 3,071.260: 47.120,212 14.95- 26.37 2637 26,37' r1,53 858948 878400 0`0000 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 734 85.6286 67.6298 00000 133269':124a06 -:66037 100;0000 31.567322: 0 r6,279,200 5.862,018 3.111,672 47.120,212 1486. 26.72' 2672 :2672. 155' 85,3625 674196 0.0000 13,4124:,12.5213 :864W IOU DOW 31.768,277' 0 6,319,974: 5900,084 3,131.877 47,.120,212 1481 : 2689 r2689 2689` 150 85,0963 67.2094 0:0000 1349W 12W21 86895 10OMW 31,869.232 0 6;3W .748 5.938,149 3,152.083 47,120,212 1476< 27.07" 2707 27.07` 1.57 848302 609992 0.0000 13.5855; 12.6829 s63323 1W.0000 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 1DO 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 842979 66170 00101 13.71W 12.8445' t11.11181' 1DOD" 31,372,098 0 6,483,070 6,052;344 3,212.700 47.120,212 1463 27.59 2759 i27.59 1.60 84 0318 66 36$7 00000 13,8451 12.9253' 6.8810 100.0000 31.273,053 0 6,523.844 6,090,4D9 3,232,9W 47,120.212 14.58 27,76t 27.76 27.76 1.81 837657 66.1685 0:9000 13.9316.13.OM 6.9D39: 1000D00 31174,009' 0 6,564.618 6.128,474 3,253,111 47,120,212 14.53 2793- 27.93 2T93' 1:82 834995 859483 0000D 14D182: 130888. 6.9467 100.0000 31.074.964 0 '6,605,392 6.166,539 3,273.317 47120,212 14.49' 28.11 2811 28.11 163 832334 65.7381 00000 to1047' 13.1876 69896 100.0000 30975,019 0 6648,166 6,204,604 3,293,523 41,170,212 14,44 2826 2826 2828' 164 829673 65,5279 D.ODW 14.1912` 132484 7.0325 10D.DDW 30,876,874 0 6,8W.940 6,242,689 3.313,728 47.120,212 14.40 28.45' 2845 28.45. 1.65 82.7011 653177 O.OWO. 14,2178 133292 7.0754 100.D000 30,777.830 0 6,727,714 6.280,734 3,333,934 47.120,212 14.35 28.63: 2863 2863. 1.66 82.4350 65.1075 O ODOO d 14 3643'. 134100 7.1183 100 ODW 30 678,785. 0 6,766.488 6,318,799 3,354.140 47.120,212 14,30'. 26 W 28.60 2850'.. 1,67 $21608 648973 O.DOW 14450E 134907 7.1611 1000000 30,579,740 0 6;809,262 6,356,$64 3,374.346 47.120,212 1426 2898 2898 2898 1.68 81:9D27 64,6871 0.0000' 14,5374 13.5715 7.2040 1OD DDW 30,400,695 0 6,850,036 6,394.929' 3.394 551 47,120,212 1421 29.15r 2915 29.15' 1.69 81.8368 6414769 0.0000, 14.6239: 136523 7.2469 100:0000 30.301,651 0 8890,$10 6.432,994 3.414,757 47,120,212 1416 2932'. 2932 29.32' 1.70 81.3704 64,2667 00000 14.7104 13.7331 7.2898 100.0000 30282,608 0 6931,504 6.471,059 3,434,962 47,120212 14,12 2950' 2950 2950 1.71 81,1043 64.0565 0.0000 147070. 138139 7.3327 1ODODOD 30,183561 0 6,972,358. 6,W9,124 3,455.160 47,120.212 14.07 2967. 2967 29.67: 1.72 80 8382 63,M3 0.00W 14.8835 13.8947 7.3755 1DO DDW 30.084.516 0 7,013.132 6,547,189 3.475,374 47.120,212 1403 2994 29.84 29,94 173 80.5720 83:6361 O;WW` 149700 13,9754 7:4184 1W.ODW 29,965,472 0 7;053.907 6,565,255 3,495.579 47.120.212 13.95 30.02 30.02 30.02: 174 80.3059 634259 0.0000 150586 '14.0562 7.4613 1W.0000 29,556,427 0 7.094.681 6,623,320 3,515,765 47,120,212 1193 30,19 3019 3019: 1.751 80.0397 L 63,2157 1 O.OD00 1 15.14311 14.13701 7.5M2 100.0OD0 29,787,3821 0 7.135,455 6,661,385 3,535,991' 47.120.212 13.89 1 1 3036 30.36 1 3036: Page 3 of` 1123f2011 2:43[PM }'rk�r�SX�#�; S �St��,t'�s �ll�#z5lt,a£�t4>,�,';s���t��W�..r{�k'�z`"•Fi.su,<�,rt tit Gy' r 1`£.�( k t `r} 3trYlst �Jl 1t t s '3�t e: t y 4{tt t F}s httffil"4NONE F y l {IJt 3{ S tt{ ti 4t }t tt �r t r {t� £�l l } t S, 5 i rt .at 4�#It�t$Fi. z 4 � i 1t t # Jy yyr i Yt t t a Ftlrta tilt }r4 F �} vv v itt .'., TAX is ,. e .,, ATION ,� S " ,. ,I .......... FN ;`mm4 — 1 H Y { RICHARDA 0.,� r k Socioeconomic ED County HAMPDEN School Structure K to 1 Form of Government * eyor *'+Cwuncil +.#Schaal Committee 2010 Population 28,438 2010 Labor Force 15f578 2009 Per Capita Income 30,032 Land Square Miles Unemployment Rate 4�*2010 8.0 tern erd & Poor"S Rating Services oo y'S Sand Rating Aa2 PROPOSED i • FY20112 Tax C1 ion Tax Classification Tax Rate Tax Levy Assessed ■ Residential 14.35 30,777,830 2fl44,342,5 0 Commercial 28.63 6,727,714 235,002,5$3 Industrial 28.63 61280,734 219,389,330 Personal Property 28.63 31333,934 116,456,060' Total 47 120 212* 2 "15 790 563' *Difference from proposed tax levy due to rounding 1 2012 CLASSIFICATION BREAKDOAVN 1 1 PROPERTYUALUE PERSONAL 4% INDUSTRIAL I 1 8% l I COMMERCIAL 1 � ■ RESIDENTIAL ■ COMMERCIAL ❑ INDUSTRIAL PERSONAL RESIDENTIAL 79% PROPERTY CLASS PROPERTY VALUE RESIDENTIAL 2,144,942,590 1' COMMERCIAL 23 ,002,583 INDUSTRIAL 219,389,330 PERSONAL 116,456,060 1 FY2011 I-XVG. SINGLE FAMILY TAX ILL S 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 304 SPRINGFIELD 31624,640,300 26,045 135,329 19.49 21638 303 HOLYOKE 9791854,428 61304 184,739 15.78 21915 273 'AGAAM 11668,670,600 11666 217,672 1 ,00 31041 268 SOUTHWICK 764,882,400 21993 266,667 13.44 3,436 216 WESTFIELD 21166,853,800 91320 231,315 16.41 31665 194 WEST SPRINGFIELD 1398,282,900 61446 216,923 16.72 31627 188 EAST LONGMEADOW 1,364,7671600 51282 258,379` 17.67 41666 108 LONGMEADOW 1910 967 800 6 442 36115 ,7, � 18 5 6,584 44 1 1 TAX RATES SURROUNDING TOWNS 2on2 PROPOSED TAX RATE $J14.,35 Resfi en $20.6,3 coITITI1meIrefi Municipality F'Y Residential Commercial Lndustria l AGAWAM 2009 12.07 26.04 201® 12.94 27.07 20IL 1 14.00 28.32 CHICO PE'E 2009 13.20 28.12 2010 13.63 28.95 2011 14.6+6 30.30 EAST LONGMEADOW 2009 16.26 16.26 2010 17.38 17.38 2011 17.67 17.67 HOLYO.KE 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 20`11 18.75 18.75 1 SOUTHWICK 2009" 12.55 12.55 22010 13.44 13.44, 2011 13.44 13.44 SPRINGFIELD 2009 17.89 36.98 2010 19.50 39.25 2011 19.49 38.97 1 WEST SPRINGFIELD 22009 14.6`6 33.85 2010 16.00 34.69 2011 16.72 34.20 W-ESTFIELD 2009 13.94 27.61 2010 14.68 28`.60 2011 15.4:1 29.13 r r COMPARATIVE TAX EFFECT TAX COMPARISON FY 2012 i Fiscal Year 2011 Fiscal Year 2012 TYPICAL COMMERCIAL PROPERTY I Value 556 200 �.- -- t Value 556 200 Shit _1.61 1.62 1.63 1.64PS, 1.66 1.67 1.68 1.69 1.70 i.71 Tax Rate 28.32 Factor 0.837657 0.834995 0.832334 0 8296730.824350 0.8216M 0.819027 0.816366 0.813704 0.811043 Tax $15,752 1 Rate 1 $27.93 $28,11 $28.28 $28,45 $28.80 $28.98 $29.i3 9,32 $29.50 $2967FY2011 AVGINGREAS Yax $15,535 $15;635 $15,729 $15,824 $16,019 $iS,11B $15,213 $0 $16,408 $18;502 $ 1 ] feee $72 5172 $267 $367 $d82 5 $B$ $ T Fiscal Year 2011 Fiscal Year 2012 { ATYPICAL INDUSTRIAL PROPERTY I Value 826 600+ ---1 Value I 26 600 8 - Shdt 1.61 1.62 1.63 1.64 1.66 1,66 1.67 1.68 1,69 1,70 1.71 5 Tax Rat 28.32 Factor 0.837657 0.83499 .832334 0.829673 <0 827011 0.624350 0.8216 0.619027 0 816366 0,813704 0.811043 Tax �$23,409 -_ _- __- -r I Rate $27,93 $28.1 i $28.28 $28.45 $28.63 $28.80 $28.98 $29.15 $29.332 $29.5 $29 67 FY 2011 AVG INCREASE1 Tax $23,087 $23236 $23,376 $23,517 '$23,666 $23,806 $23.955 $24,096 $24,236 $24,385 $24,525 4 -� $i75 lafferenCe $322 $174 -$33 $107 $26fi $397 $546 $686 $827 $976 $1,116 Fiscal Year 2011 Fiscal Year 2012 TYPICAL RESIDENTIAL PROPERTY 1 - - _ Value 215 000 Value $219,000 __ T Shift 1.81 1.62 1"'63 1.64 1.65 1.66 1.67 1.68 1.69 1.70 1,71 Tax Rate 14A0 Factor 10,8376570.834995 O.B32334 0:829673 d.827D11 0.824350 0.821688 0.819027 D.816388 0.813704 0811043 ` Tax $3,066 ' I Rate $14:5-3-$14.49 $14,44 $1, 40 $14.36 $14.30 $14.26 $14.2i $14.i6 $14.12 $14.07 FY2011 AVGINCREAS Tax $3,182 $3,173 $3,162 $3.154 $3,143 $3.132 $3,123 $3,112 $3,101 $3.092 $3,081 5101 _ tafterence, 5116 $1D7 $96 $88 $77 $66 $ M $335 $26 $i5- ! I il- 57{ 1 11/23/2011 Town of Agawam 8:54:0BAM ASSESSMENT CLASSIFICATION REPORT: LA4 esc en is pen ZjDace Uommercial Industrialtiers. Propel andType: Chanter Parcels Class1 Class2 Class3 Class4 Class5 01: 7,681 1,680,002,900 02: 1.,603 227,924,100 Misc Res: 15 3,878.700 04:: 415 82,333,640 05 25 5,423,400 111-125: 60 95,187.000 30-32& 106: 725 32,801,800 200-299: 1 1 0 0 00-399: 1 1 309 0 1 214,851,900 00-499: F 164 0 7-218,701,7001 CH61 Land: 1 6 4 0 1 14 256 H61 A: 1 73 41 0 1 1,121,048 H61 B; 1 13 4 0 1 1,458,299 12-043 1`11 17,391,050 1 17.557,080 687,630 01: 486 0 3,670,190 502: 301 0 39,195,970 03: 4 0 1 18,380' 04.5550-552: 2 0 55,944,820 505 2 0 %861,800 06: 1 1 0 1 6,179,500 08: 7, 0 1,585,400 nvalid LUC: 0 0 TAXABLE CLASS VALUES 2,144,942,590;, 0 235,002583 219,389,330 116456,060 RIE COUNT: 11,157 REAL ESTATE TAXABLE: 2,599,334,503 EXEMPT COUNT: 248 RIE EXEMPT VALUE: 368,726,244; R/E TOTAL COUNT: 11,405 RIE TOTAL VALUE 2,968,060,747` P1P COUNT:WOMA 803 PERS.PROP,TAXABLE: 116,456,060 TAXABLE COUNT: 11,960 TOTAL.RIE&PP TAXABLE VALUE: 2,715,790,563 Questions concerning this report should be directed to the following person: Name Title - Dav-Time 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 Property 116,456,060 42881% TOTALS 2,715,790,563 100,0000% Maximum Share of Levy for 150% X 21.019610 = 31.5294% Classes Three, Four and 3 + L x Ala Share Personal Property : Lines C +4C 5C Ma I - Minimum Share of Levy for 100% 31.5294% = 68.4706% Classes One and Two : Max% Share Min %Share::] Minimum Residential Factor 68.4706% l 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 THE LOWEST 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% 53 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 Pwcantapaa LowAmouras EstinutsE Tax Rates. CM Res. What lf...Scenario War*Sheet shift Facto. Rw o s Con, tnd PP soul Res 05 Dom Wd PP Total Ra 05 con, Ind PP CLASS VALUE' % 1,01 997339 78.7702 0.0000 8.7397 8.1591 4,3310 1000000 37.116.693 0 4.118,177 3;84¢571 2.040.772 47.120 212 17.30` 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;0000 37,017,84E 0 4,158.951 3.8WAV 2,0W,977 47,120,212 17.26 17.70 17.70 17.70 08 0.0000% 7&9804% 1,03 02D18 78.3498 O WW 8 9128 8.3208 44188 100.0000 36.918,604 0 4;199,725 3.920,701 2.081,183' 47,120.212 1721 1707 17 87 17.87' Com 238,002,683 8.6632% 1,04 9&9355 70,1396 O W00 8.9W3" 8.4014 4,4596 100.0000 36,819,559 0 4,240,499 3,958,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 0000- 9.0859 84822 4,5025 106.0000 36,720,514 0 4.281,273 3,9W.831 2,121.594 47,120212 17.12 18.22< 18 22 A 22 PP 118,466,060 4.2881% 21.0196% 1.00 0,4032 77,7192 0 00W 9.1724 85830 4.5454 10O OOW 36,621.469 0 4,322.047 4.034,896 2.141,800 47.120.212 17.07 1810 ion 4 39 Total 2,716,790,563 1060400% 1,07 08,1370 77,5D80 000W 9,2589 86438 45883 10000W 36,522,425 0 4,362,821 4,072,961 2.162,006 47.120,212 17.03 i8.56 18,56 18.56 PAGE VYN TO COMPLIEUE DATA.EHi1i 1.08 9L6709 77.2988. 0.0000 9.3454 6.7245 4:8312..100:000D 38,423,380 0 4;403,595 4,711,ffi6 2,iB2;211 47,120212 15:98 1874 '78.74 18.74. CLASSIFICATION OPTIONS 1.09 07 600 77MW 00000 94320 B.8053 46740 100i0000 36.324.335 0 4,444,369 4,149.091' 2.202,417 47.120,212 16,93 16.91 1891 113.91 1.10 97.3386 786785 00000: 9,5185- 98W1 4`.7169 100:000D 38,225,290 0 4.485,143: 4,187,159. 2.222,623 47.120,212 16,89 1909` 1909 1909' Residential Exempt 1.11 070725 786683 00000 96050 6.9669 4,7598 10000DO 36.126,246 0 4525.917 4,225,721 2,242,828 47.120,212 16A4 19.26 1926 1926 Small Commercial 112 968064 764581 00000 96510 90477 48027 100:0000 36027.201 0 4,566.691 4,2B3,286 2,263.034 47.120,212 16.80 19.43 1943 19.43 Exemption 1.13 9B,5402 782479 D 0000 9.7761 9.1285 4.8456 100.0000 35 928,156 0 a 607,465 4,301,351 2,283,240 47,120,212 1675 19,61 1951 10.81 LEVY 114 952741 760377 O WW> 9.8646 '9 2092 4 8684 100 0D00 35,829,111 0 4,648,239 4,339.416 2,303445 47,120 212 16.70 19.78 19,78 1978 1.15 960079 75 9275 O OWO, 9.9512: 9.2900 4.9313 100 D000 35,730 007 O 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;0000 100377 -93708 49742 100:0000 35,631,022 0 4,729,787 4,415.546 2,343,867 47,120,212 16,61 20.13 <20.13 2013i = 17.35 Single Tax Rate 1,17 95.4757 75,4071 40000 10t242 94516 50171 1ODOOW 35,531.977 0 4770,561 4,453.611 2,364;OB2 47,120212 16.57 2030 2030 20.30 118 95,2095 75.1969 0.0000 102108 9,5324 6,0600 16D.ODW 35;432,932 D 4,B11,335 4,491,677 2.384,288 47.120212 16.52 2047 2047 2047: Notes This table should be used for planning 1.19 94.9434 74;9W7 0.0000 10.2973 '96132 5.1023 i0D.0000 35.333,8W 0 4.852.109 4,529,742 2.404,474 47,120,212 1647 2065 20.65 2065 purposes only.Actual calculations may differ slightly due to rounding.For 1;20 948773 74;7765 O.OWO 103838 9.6939 5,1457 100:0000 35,234,843 0 4;E92,683 4,567,807 2,424;879 47,120212 16.43 20,62 2082 2082 actual calculations,complete Recap.: 1,21 944111 745663 O;DWO. 104704 9.7747 51BW 10D_0000 35135.79E 0 4,933,857: 4,605.072 2.444.885 47.120,212 15.3E 2099 :20.99 2099 1.,22 94.1450 74.3501 00000 10.5569'. '98555 52315 10D.000D 15.038.754 0 4.974,431 4,843937 2,465,091 47,120,212 1633 21,17 r21,17 2117: 123 938789 74.1459 00D00 10.6434: :99383 62744 1W.0000 34.937,709 0 5,015,205 4,W2002 2,405,298 47,120;212 16.29 21.34. -21.34 21.34.: 1.24 93,6127 73.9357 000D0- 10.7300 10.0171 53173 10000W 34.M.684 0 '5,055,979 4,720.087 2.505,502 47.120,212 1624 2L51: :2t51 2151 11.261 933466 1 73,7255 1 0 0000 110.81651 1009791 $360t 1 100 0000 34 139,619 0 5 0W.753 4,75B;132 2.525;708 47,120 212 16.20 21.69 21.69 1 21.69; Page 1 of 4 11123MI l 2:43 PM Shara::Psmm"es,. Le"Amourft F.atlmaMd Tax Ratas. CIP fief What Jf,..SGenarfa Work5he43t ShM Fanor Rn 09 Com Ind PP Total Res OS Can Iltd PP Total Res OS Com Ind PP 1.26 930B04 73,5153 0,0000 10..9030 10.1786 54030 1000000 34,640,575 0 5,137,527 4,798197 2,545.913 47,120,212 16.15' 21.85 21,80 21.86 127 92.8143 733051 0.000® 10.98% 10.2594 54459 100.0000 34,541.530 0 5.175.301 4,834,282 2,588;119 47,120.212 16.10 22,04 2204 22.04 1.28 92,S482 73.0949 0 0000 11.0761: 102402. 5.4688 100 0000 34,442,485 0 5,219,075 4,872,327 2,5B8,325 47.M,212 16.06 22.21. 22,21 2.2 21. 129 922820 728847 00000 11AM 10A210. 55317 1000000 34343.440 0 5,250.849 4,910,392 2;608,530 47,120,212 16.01 22.38 22,38 22.38- 1.30 92.0159 72.6745 0.0000 111492 10.5018 55745 100 0000 34,244,396 0 5,300;623 4,948,457 2,628,736 47.120,212 15.97. 22.56 22.56 2256 1131 91,7498 72.4643 00000 11:3357 10i5826 5.6174,10000W '34145,351 0 5,341,397 4,986:522 2,648,942 47.120,212 1502 22,73 22.73' 2273 4.32 01,4830 72.2541 0.0000 114222 10sW33 56603 1000000 34;040308 0' 5,382,171 5,024,587' 2,687.147 47,120,212 15.87 22,90 22.90 22.90 t.33 912175 72.0439 0.0000 11.5087 10.7441 5.7032 100 0000 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 909514 71,8338 0�0000 11,5953 10.8249' 5,7461 r100,0000 33.548,217' 0 5.463.719 5,100,717 2.707,559 47,120.212 15.78 2325 2325 2325 1.35 906852 71,623E 00000 11,6818'. i0.9057` 5.7889 1000000 33,749,172 0 5,604,494 5,138,782: 2.727,764 47,120,212 15.73 2342 2342` 2342 1.36 004191 714134 00000 11,7683' %9885: 58318.100.0000 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:0000 11.8549 11.0673 5,8747 100 0000 33,551,082 0 5.586,042 5,214,913 2.70,176 47,120 212 15:64. 2377 23.77 23.77 1,30 89"6868 70.9930 0 0000 11.9414 11.1480 5.9176 1000000 33,452,038 0 5,626,01 e 5,252,979 2,788,381 47.120,212 15,60 2394 2394 23:94 1.39 896207 70.7828 0,0000 12.0270 11.2298 5.9605:100 0000 33,352,003 0 5,667.590 5,291.043 2,808,587 47,120,212 15.55 24 12 24.12 2412 1.40 89.3545 705726 00000 12.1145 11.3096 6.0034 100.0000 33,253,948 0 5,708.364 5.329,106 2,828,792 47.120,212 15,50 2C29 2429 2429 1,41 89.0884 703624 0.0000 12.2010 11.3904 8 0462 100.0000 33,154,90.7 0 5.749.138 5,367.173 2,W.M 47.120.212 1548:: 2446 2448 2448 1.42 88 8223 701522 0.0000 12.2875 11.4712 6.0891 100 0000 33,055,859 0 5.789.912 5,405,238 2,869.204 47.120,212 1541 2464 2464 24.64; 1.43 66.5561 %9420 0 0000 12.3741 11.5519 8 1320 100.0000 32,956,814 0 5,830,688 5,443,303 2,889,409 47,120,212 15,36 2481 2481 2481 144 86.2900 69.7310 0.0000 124606 11.6327: 6.1749 100.0000 32057,769 0 5.671.460 5.481,368 2,909,615 47,120,212 1532 2498 24.98 24,98' 1,45 88 0238 69.5216 0.0000 12.5471 11.7135" 62178 100.0000 32.758,724 0 5,912,234 5.519,433 2,929,821 47,120.212 1527 2510 25,16 25.16 1,46 $7.7577 69,3114 0 0000 12.8337 11.7943 6.2606 100.0000 32,659,6B0 0 5,953,008 5.567,498 2,950,026 47,120.212 1523" 25.33 25.33 25.33 1.47 87.4916 69,1012 40000 12,7202: 11.8751 6.3035 1000000 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 0.0000 12.BM7 11.0550 0.3464 1000000 32481,590 0 6.034,558 5,633,628 2,990,438 47.120.212 15.13 2568 2568 2568. 149 889593 686608 0.0000 1281133 12.11" 6 3893 100.0000 32,362.545 0 13,076.330 5.671,893 3.010,643 47.120,212 1509 25 B5 25 al. 25$5 1.50 886932 68.4708 0.0000 12.1798 12.1174: 84322 100.0000 32,263,501 0 6,116,104 5,709,758 3.030.849 47,120,212 15.04 2603 20M 26- Page 2 of 4 1 V2312011 2:43 PM 8kera:Pamentapss.;.. :La Law Amounts Fstlmated Tax Rafts CIP What It..Scenario Worksheet hif e t F ctnr Res 05 Corn Ina Pa 'Tout Ras 03 Corn Ind P17 Total Rea Cis Corn Ind as 1.51 864270 68:2604 00000 13 0BB3 -12.1982 8 4750 100.0000 32.464,456 0 8,156,678 5,747 823 3,051 055 47.120,212 15.00 28.20 26.20 2620 1,52 88 t609 68.0502 0.0000 13,1129' 122190. 6,51711 101,00110 32,085,411 0 6,197,652 5,7115,888 1,071,260 47,120,212 14,'95'., 26,37. 21137 2637: 1.53 85 8948 67.84DD 0,0000 13.2394 12.3590 65608 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 154 85.6286 676298 0.0000 13,3259 :12.4408 66037 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 0.0000 13.4124>`12.5213 566468 100-0000 31,768,277. 0 6,319,974 5,900,084 3,131.877 47,120,212 14.81 26.89 2689 726`.69. 1:56 85,0863 87.2094 0.00D0 134990: 12.6021 6.6895 100.00D0 31,869,232 0 636Q748 5,938.149 3,162,083 47,120.212 14.76: 27.07'. 2707 27.07: 1.57 64.6302 66.9992 0.0000 13 5855'::.12.6829`. 8.7323 300.0000 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 0,00D0 13.6-120 12,7637 6.2752 100-0000 31.471,143 0 6.442,296 6.014,279 3.192494 47.120,212 1467 27.41 27,41 2741 1.59 64.2979 68.5789 00000 13.7586''12.8446 6.0181 106:00D0 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 8:0000 138451 12.9253 6.8610 1OD-0000 31,273,053 0. 6.523,944 6,090,409 3,232,906 47,120,212 14.58' 27,76 27,76 27,76 1,61 83,7657 66,1585 0`0D00 13,9316: 13.0060 6.9039 100.0000 31.174,009 0 6.564.618 6.128,474 3253,111 47,120,212 14,53 27,93': 27,93 27.93. 162 83.4995 65`9463 00000 140182 130808 B.9487 100.0000 31,074.964 0 6.605,392 6,166.539 3273.317 47.120,212 14,49 2&11` 2811 2811 1.63 :83.2334 65.7381 0.0000 14,1047: 13.1676` 6.9696 100:00D0 30.975.919 o 6,848,186 :6.21)4,604 3 291,523 47.120,212 14.44: 2828 2828 2526 1,64 82.9673 65.5279 0:0000 141912 13.2484- 7,0325 100.OW0 '30,876,874 0 6;688,940 6,242.669 3.313,726 47,120,212 14.40 2845 2646 2845 1_05 827011 653177 00000 14.2778' 133292."7,0754 1000D00 30,777.830 0 6,727.714.. 82B0,734 3,333.934 47,120,212 1435 2863. 2863 2863 1.86 82.4350 65.1076 00000 14.3643 134100 "TIM 100.DD00 30,676.785. 0 6.758.488 6,318,799 3,354,140 47,120,212 14301 2860. :20.80 2880 :87 82.1688 64.8973 0.0000 14.4508 13.4907 7.1611 100.0DD0 30,579,740 0. 6,809 282 8,358,864 3,374.345 47,120,212 14,26' 28.98: 28.98 28 98 160 011027 64.6671 0 DD00 14.5374 13.5715 72040 1D0.0000 30,480,695 0 8;850,036. 6,394,929 3.394.551 47,120,212 1421 29.15 29.15 29 15 1,69 81.6386 64.4769 0 0000 14.6239 13.6523 7,2469 100.0000 30,381,661. 0 8,890,810 8,432,994 3,414,757 47,120,212 14.18 29.32 29.32 29,32 110 81.3704 B4.2667 0.0000 14.7104 13.7331 7.2898 1D0.0D00 30,282,606 0 6.931,564 6471.050 3,434,962 47,120,212 14.12' 2950 2950 29.50 1.71 B1.1043 64.0585 0 0000 14.7970 13.8139 7.3327 100.0D00 30.1B3,561 0 6,972,35B 6,509,124 3,455,168 47.120,212 14,07 29.67 2987 2967 1.72 808362 63.8463 0.D000 148835 138947 7.3755 i00.0000 30,054,516 0 7,013,132 6.547.189 3,475,374 47.120,212 14.D3: 2904 2984 2984 1,73 80$720 63.636i 0.0000 14.9700 13.9754 7.4184 100.0000 29,905,412 0 7;053,907 8.505,255 3,495.579 47,120,212 13.98 30.02 3002 3002 1.74 80.3059 034259 0_DOOo 15,0668: 140%2 74813 100.0000 2%888427 0 7,D94,681 6,623.320 3,515,785 47,120,212 13.93 3019 3019 3019 175 80.0397 632157 1 0.0000 1 15,1431 1 14.13701 7,5042 1 1000000 29,787,382 0 7.135.455 6,6Bi,385 3.535,991 47,120,212 13.89 30,36 1 3036: 3030 Page 3 0t 4 110=01 12:43`PM