HomeMy WebLinkAboutITEM IV-E
F 4;.~~T•
AL.J.-t V il1V AGENDA BILL APPROVAL FORM
WqSHINGTON
Agenda Subject: January 2010 Financial Report Date: 3/8/2010
Department: Finance 1 Attachments: January Monthly Budget Impact: 0
Re ort
Administrative Recommendation:
Background Summary:
The January 2010 status report highlights City revenues and expenditures and is based on
financial data availabie as of February 22, 2010. Sales tax reported in January is for business
activities that occurred in November 2009.
Total General Fund revenues for the City at the end of January were $3,370,800 which is
approximately 7% of the annual budgeted revenues. Compared to budgeted year-to-date
revenues, this is $581 K(14.7%) less due to timing of receipts for taxes and grants.
Expenditures for the General Fund totaled $3,623,649 which is $607.6K (14.4%) under budget
for the month. Most of the departments' expenses are typically under budget at the beginning of
the year as some expenses such insurance and professional services are paid out in later
periods.
Reviewed by Council & Committees: Reviewed 6y Departments 8 Divislons:
❑ Arts Commission COUNGL COMMITTEES: ❑ Building ❑ M&O
❑ Airport Z Finance ❑ Cemetery ❑ Mayor
❑ Hearing Examiner E Municipal Serv. ~ Finance ❑ Parks
❑ Human Services ❑ Planning & CD ❑ Fire ❑ Planning
❑ Park Board ❑Public Works ❑ Legal ❑ Police
❑ Planning Comm. ❑ Other ❑ Public Works ❑ Human Resources
❑ Information Services
Action:
CommitteeApproval: ❑Ves ❑NO Council Approval: ❑Yes ❑No Call for Public Hearing
Referred to Until / /
Tabled Until / / Councilmember: Staff: Coleman
Meeting Date: Februa 15, 2010 Item Number:
AU.BURN * MORE THAN YOU 1MAGINED
Monthly Financial Report January 2010
- Y 'i ~t vo 'x. y~~-R,tt
General~ ~r- und a}~. W\.y,'t~3 T~R.s~2010..+..:v
-2b10YTDButlge'tvrAcfuel~,4+`.
(Un~xoreble)ra~%
c~Dm aN,~Ainou~t.....:~.,'u""~.-A.~s<ta8e4s
OPERATING REVENUES
PropertyTax 12,357,309 45.500 27,735 (17.765) -39.0%
SalesTax (1) 14,255.000 1,213.024 965.532 (247,492) -20.4%
Sales Tax - Annexation Credit 7,453.500 121.400 105,799 (75,601) -12.9%
' CriminaUustice Sales Tax 1.143.300 96,100 97365 1.265 13°b
BrokeredNaNmlGarTax 260,000 30,400 ?S.Bll (4,589) 15.1°k
Ciry Utilities Tax ' 2,140,200 172,100 182,308 10106 5.9%
Admissiont Taz 400,000 98.900 67,953 (30,947) -313%
Electric Tax 2,794,100 680J00 746.132 65.432 9.60b
NaturalGasTax . 1,245,500 266,100 255,003 (11.097) -4.2%
N Cable Tax 676,300 170,900 - (170.900) .100.0%
TelephoneTax 1.734.200 119,100 66.692 (52.408) -44.0%
GarbageTax(extemal) 100,000 6,000 8,657 2,657 44.3%
Leasehold Excise Tax 80,000 - - - , N/A
' GamblingExdseTax 766,500 1IJ00 6,037 (5.663) -48.4%
Business Llcense Fees 200,000 6.300 3,945 (2,355) -37.4%
Building Permits 700.000 69,600 88.175 16,375 263%
Other Licenses 6 Permit: I88.000 13.500 41,518 28,018 707.5 %
Intergovernmental (Grants, etc) 4.241,990 422,300 238,528 (183.772) -43.5 %
Charges for Services:
Generai Government Services 113.000 22700 7,812 (14.898) -65.6°k
Pubii<Safery 244,000 15.400 14,606 (794) .5.2%
Development Services Fees 857.000 89.800 39,755 (50.045) -55.7%
CWture and Recreation 635.000 71.600 65,917 (5.883) -8.2%
Fines and Forfeln 1.870.700 140.800 238141 97.447 69.2°Po
Interesn and Other Eamings 170,000 31.400 8.194 (23.206) -73.9%
Rents. Leaser and Concessions 180.000 9,900 27.821 17.921 181.0°k
ConMbutions and Donations 12.000 1.000 1247 2,247 224J%
OtherMiswllaneous 46.200 6.100 3.959 (2341) -35.1°h
Transfers In 1I.000 17.000 17.000 - , 0.0%
Insuranre Recoveries- Ca ital & Operating 25.000 2.083 17.057 14.973 7183%
TotalOperatin Revenues 49.105.799 3.951.807 3,370,800 (587,007) -I4.7%
Operatlng ExpendiNref .
Council & Mayor 738.900 59.200 49196 9.904 16.7%
Municipal Court 6 Probation 3,055,760 219,000 167.045 37,955 I4.6°h
Human Resourcet 736,150 63.000 53.703 9.297 14.8%
Finance 1.146.360 90300 66.418 23.882 26.4a/v
CityAttomey 1,710.650 141.600 116,808 24792 17.5%
Planning ' 3.743,970 368,000 310.380 57.620 15.7%
Community 6 Human Servlces 632.600 15.000 5.770 9.230 6I.5°k
Police 23.646,265 1.734,000 1.608.077 125.923 7.3^/0
Engineering 3.111,010 298.800 184.615 ❑4,165 38.2^/0
Psrks and Recreation 6.899.300 477.900 450,502 27.398 5.7%
Streets 3.140]00 278.200 143.007 135,199 48.6°Po
NonDepartmental 5,442.900 486.00 3.6300 448,035 38 7.265 7.9%
Total OperaHng ExpendiNres 54.005.685 4.231.323.649 60.651 14.4Wo
(1) Sales Tax includes S[reamlined Sales Tax mitigation
N cable tax revenue is low due to timing of receipts: $193K revenue for the quarter was
received in February.
Page 1 of 8
Monthly Financial Report January 2010
Overview
This financial overview reflects the City's overall financial position for the fiscal year through
January 31, 2010. The budgeted year to date revenues and opereting expenditures are primarily
based on the collection/disbursement for the same period of 2009. The table on the previous
page summarizes the general fund revenues and expenditures.
Revenues
Taxes
In January, the combined collection of property tax, sales/use tax, utility tax, gambling, and
admissions tax represents 76% of all resources supporting general governmental activities. The
following section provides detail information on property and sales taxes.
Propertv Tax
January colledion is $27,735 or 0.22% of the annual budget. Compared to 2009, the City
collected $70,867 or 28.15% less. This is $17,265 less than the projected monthly budget. We
will monitor our collections in future months to see if they are in line with the budget.
PropertyTaxRevenue-N
Yearxto Date tfirou h Janua
. 8...... ...LY x.~h.,...,... , ~ ,~..,a....~.~...
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud e[ Actual Amount Percenta e Amount Percenta e
. . . . . . . . . .
. . . : _
Jan 38.602 45.000 27735 (10,867) -28.2% (17.265) -38.4%
Feb 111.495 130,000
Mar 222,173 259,000
, A r 4,188,834 4,882,400
Ma 852,588 993.800
Jun 37,763 44,000
Jul 21.078 24,600
Au 32.632 38,000
Se 196,757 229.400
Oct 3.836,015 4.471.309
Nov 1,017,258 1,185,700
Dec 46,566 54,300
YTD Total 38.602 45,000 27.735 (10,867) -28.20/o (17,265) -38.4%
Annual Total 10,601,791 12.357,509
Page 2 of 8
Monthly Financial Report January 2010
Sales Tax
Sales tax received for January totaled $965,532 and is approximately $267.5K or 21.7% less
than last year for the same period. Compared to the projected monthly budget, it is under by
$247.5K or 20.4 % less. This shortfall is mainly due to the streamlined sales tax mitigation that is
included in the 2009 actual amounts. This funding is received quarterly and is not included in
the January 2010 revenue. When we receive the quarterly streamlined sales tax mitigation (SST)
payment in March we will allocate January & February's portion and should bring this revenue
source to be more in line with the budget. The total anticipated SST mitigation for 2010 is
$1,966,775 but the amount the City will receive from the State is reduced by revenues received
from companies that have voluntarily complied with the new destination based sales tax.
Without the streamlined sales tax mitigation adjustment of $173,808 in January 2009, the
difference would be $93,659 or 7.59% less.
l~z t'~~~pqy: ~2ta ° z. SJ k .~•k $O~ESEcUS T2X'RCVCI100~ ~~tiytrF~ w~'E ~r - ~z y .
4l~ R:-si 2a crre-tx ~~,ri m .ux v/" 'h 'h~r p ~ iy+~nw `~t'~.'~, a. ,yY .-~t,yr r:+Fr
~ear.to~Da;eroughtJanuarYaia`, , ~ r...,.~,i'. ,
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Ac[ual Amount Percenta e Amount Percenta e
:.:vc..~:.rcr.v::n~.:~zec>xuwna:4rY.r.. «.'m:~Xtd~t.-.aiStiu~b.t>v..rf~u:.;s;r:wYkP11uJ&wsbF:.nsurc~..'v+nm'3cC:w.~,u;i~i::. S!:a5..
Jan 1.232,999 1.213,000 965.532 (267,467 -21.70/o (247.468) -20.4%
Feb 1.279,532 1,372,300
Mar 1,059,642 1,085.700
A r 1,041,972 1,066,300
Ma 1,161,471 1,249,400
Jun 1.098,038 1.144.900
Jul 1,152.738 1,180.300
Au 1.250.264 1,302,700
Se 1,146,525 1,147,700
Oct 1,254,457 1,200.400 -
Nov 1,197,153 1.175,200
Dec 1.065.935 1,117,100
YTD Total 1.232,999 1.213,000 965.532 (267.467) -21.70/o(247.468) -20.40/o
Annual Total 13.942,728 14.255.000
The following table breaks out the City's base sales tax excluding Criminal Justice. Annexation
Credit and Streamlined Sales Tax Mitigation by major business sectors.
Comparison of Sales Tax Colleetion{ 6y SIC Group.
Yearto Datethrough'January
2009 2010 Chan e from 2009
Com onent Grou Actual Actual Amount Percenta e
New Construction 105,696 98,810 (6,886) 6.5%
Manufacturin 26,161 28.667 2,506 9.6%
Trens ortation & Warehousin 2,024 1.781 (243) -12.0%
Wholezale Trade 80,639 105,837 25.198 31.2%
Automotive 187,177 176,364 (10,813) -5.8%
Retail Trede 455.195 299,232 (155.963) -34.3%
Services 244,542 248,513 3,971 1.6%
Miscellaneous 7,018 2.965 (4,053) -57.8%
YTD Total 1,108,452 962,169 (146,283) -13.2%
Page 3 of 8
Monthly Financial Report January 2010
InterQOVernmental
Revenues in this category include Grants, (Dired & Indirect Federal, State and Local) State shared
revenues and compact revenue from the Muckleshoot Indian Tribe. January revenue is low
compared to budget mainly due to timing of receipt of the Muckleshoot compact revenue of
$368,231 for the quarter, which was received in February. Timing of grant revenue varies as
they are processed on a reimbursement basis.
v
~:7~~'~ilu.GE¢ a.5S,47ti~,r ..ab,S,re Y.^°~e `~r~f1YE~gOV2R1R720TB~txit~~ t~~~i~~y~` ~-~.sa^~G~''n rh# ?e5~;
e>
TM ~,~y+~ YearrtoDate,thcough,January<,~,,,,~,,,+„ ~ry;
2009 2010 2010 2009 vs 2010 2010 vz.Budget
Revenue Actual Budget Adual % Change % Change
Federel Grents - 500 246 N/A -50.7%
State Grants - - N/A N/A
Interlocal Grants 5,000 8,142 N/A 62.87/.
State Shared Revenue 333,410 319,900 327,504 -1.8% 2,47/o
Muckleshoot Casino Emer . 323,222 226,400 -100.00/0 -100.0%
YTD Total 656,632 551,800 335,892 -48.8% -39.1%
...,~...,.,,~.,A.., .~..x. :w,. ,..»..,w.,,~.w.w.... ~...~......,.t:....a,.. ,..,.u
' Annual Total 4,499,411 4,241,990
Y7"D % 15% 13% 8%
Total state shared revenues are less than 2009 for the same period due to the lower revenues
from the Criminal Justice Sales Tax. Compared to budget, revenues are greater by $7,604 or
2.38%. Income from Criminal Justice-Special programs and State DUI were budgeted
conservatively and contributed to the overell increase.
State Shared Revenuesi +
Year'io Date through lanuary`
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Revenue Adual Bud et Adual Amount Percenta e Amount Percenta e
: . -
Motor Vehide Fuel Tax 114,630 119,900 115,067 437 0.4% (4,833) -4.00/o
Criminal Justice Sales Tax 108.270 96,100 97365 (10,905) -lOJ% 1,265 13%
CriminalJustice -Po ulation 16,176 76,700 17,034 858 5.3% 334 2.0%
Criminal Justice -S ec. Pro . 13,401 8,000 14,056 655 4.9% 6,056 75.7%
State DUI 2.983 1,000 3.156 173 5.80 2,156 215.6%
Li uor Excise Taz 77,950 78,200 80.826 2,876 3.7% 2,626 3.4%
YTD Total 333.410 319,900 327,504 (5,906) -1.8%7.604 2.4%
AnnualTotal 2.465,986 2,594,740
Page 4 of 8
Monthly Financial Report . January 2010
Fines & Penalties
These revenue sources include treffic and parking infradion penalties, criminal (traffic, non traffic
and costs) false alarm and shopping cart finez. This revenue source is $90,100 or 60.80/o greater
than 2009 for the same period and $97,440 or 62.2% higher than projected budget for the
month. The overall increase is mainly due to the rise in the traffic infraction and photo
enforcement revenues. Two new photo enforcement school zones were added in September
2009 with a month grece period; the City began receiving revenues from these additional zones
in November 2009. Revenues net of operating expenses from the photo enforcement program
are designated for traffic calming improvements.
Fmet& Forfeitsby Month . e, H
C=$ ~'C~'?!F'V~~ l F K*y t'3 F k '4 `l t. ;+(dh
a. : s
2009 2010 2010 2010 vs. 2009' m2010 vs. Bud et
Month Actual Bud et Actual Amount Percenta e Amount Percenta e
:4,u ...r.r.aban,ssw.. _tiHUar.:h,-aw.:wambx~.t......ar~:.a-.nTwn.a,.~., .,Fr.~[re3>:+~Y _~.•c -:-..a e.:., ..a= -.u:c..
Jan 148.141 140,800 238,241 90,100 60.8% 97.441 69.2%
Feb 153,213 145.600 '
Mar 168,348 160,000
A r 165,420 157.200
Ma 174,475 165,800
Jun 168.280 159,900 Jul 159,112 151.200
Au 144.593 137,500
Sep 163.212 155,200
Oct 143,517 136.500
Nov 167,497 159.200
Dec 212,349 201.800
YTD TOtal 148,147 140.800 238.241 90,100 60.8% 97,441 69.2%
Annual Total 1.968.157 7.870.700
, . . . . ...,:.pines & Forfefts.by Type~:? - . _ . . -
~ Year to Date through 7anuary
- 2009 2070 2070 2010 vs. 2009 2010 vs. Budget
Month Actual Bud et Aaual Amount Percenta e Amount Percenta e
. . . - . . . . .
Civil Penalties 1.244 900 2.489 1,246 100.7% 1.589 176.6%
Civil Infradion Penalties 39,503 28,600 63.541 24,038 60.9% 34.941 1222%
Red Light Photo Enforcement 73,432 101.000 134,182 60.751 82.7% 33.182 32.9%
Parking Infractions 12.299 3.800 18,580 6,281 51.1% 14,780 388.9%
Criminal Traffic Misdemeanor 7,233 8,500 5.726 (1.507) -20.8% (2.774) -32.6%
Criminal Non-Traffic Fines 10.479 8.100 7.908 (2,571) -24.5% (192) -2.4%
Criminal Costs 1,313 2,200 664 (449) -34.2% (1,336) -60.7%
NomCourt Fines & Penalties 2,638 1.300 4,950 2.312 87.7% 3,650 280.8%
YTD Total 148J41 - 154,400 238,241 1,246 0.8% 1.589 1.0%
. n .
Anual Total 1.968.156 1,870,700
Page 5 of 8
Monthly Financial Report January 2010
y' - >w > '7~ `ni ~t G~r'g'rY /A 4 ~'t+w•
, Y.~a**..._>.~1 ~~ti.,r.~~'s_>., .a.. ~ _....8_ .._..!Y. -~.~..~.t.~_,t~G,,.__A,~
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percenta e Amount Percenta e
Jan 73,432 101,000 134,182 60.751 52.7% 33.162 32.9%
Feb 62,632 91,900 Mar 67,543 93.300
A r 70.057 91,600
May 78.746 103,000
1un 76.980 100,700
1ul 79.382 103.800
Au 63,225 82,700
Se 47,697 67,700
Oct 44,010 62,600
Nov 74,239 97,100 Dec 102,895 104,600
YTD Total 73.432 101,000 134.182 60,751 82.7% 33,182 32.9%
Annual Total 841,038 1,100.000
Real Estate Excise Tax
The Real Estate Excise Tax (REET) revenue is received in the Capital Improvement Projects Fund
and is used for governmental capital projects. January 2010 revenue of $44,219 is $11,088 or
20% less than 2009 for the same period. This is $19.6K less than the budget for the month and
reflects the decline in the housing market.
' Real Estate Exciie:7ax Revenues,
Year to Date through January,. ,
2009 2010 2010 2010 vs. 2009 2010 vs. Bud et
Month Actual Bud et Actual Amount Percenta e Amount Percenta e
1an 55,308 63.900 44.219 (11,088) -20.0% (19,681) -30.8%
Feb 115,443 133,300
Mar 114,240 131,900
A r 75,831 87,600
May 68,846 79,500
Jun 141,704 163,600
Jul 106,672 123,200
Au 115,268 133,100
Se 179,067 206,700
Oct 314,172 362,700
Nov 184,935 213,500
Dec 87,440 101,000
YTD Total 55308 63,900 44,219 (11,088) -20.0% (19,681) -30.8%
Annual Total 1,558.926 1,800.000
Page 6 of 8
Monthly Financial Report January 2010
Enterprise Funds
The table below provides an analysis of all City Enterprise funds and shows the year to date
revenues and expenditurez for each enterprise fund.
, Water Sewer Stortn Solid Wane Airport Cemetery Golf Comm. 0.etail
OPEMTING RF/ENUES .
Charges for iervices 621.167 1,163.409 510.498 748.79 1,164 54,261 33,473
Renlt leases, end mncmlons 49.417 6.968
TOTAt07EMTING0.EVENUES 621.187 1,163,403 570.498 748757 51.576 54,261 40.390
OPERATING E%PFNSES:
Adminislmtion 163,510 130,018 184.499 55,041 67.686 21,367 17.150
Opemtions6Meimenence 255,745 1,006,485 134.834 57371 38.075 65.951
Depreda[ion6Amorti¢allon 176,409 115.646 92332 1,711 IB,iD 4767 27.836 5.083
TOTALOPERATINLEXPENSES 595.163 1.252,149 411,664 109.173 85.813 64.709 110.937 5,083
OPEMTING WCOME(1-05S) 26,024 (88340) 108.834 639,634 (34,238) (9,948) p0.547) (503)
NON-0PEMTING REVENUE56 EXPENSES
InferettReoenue 7.839 1,229 1.177 248 762 254 54
Other Non Operating Revenue ' 725 - (25) 75 7.149
TOTALNONOPERATING0.EVENUES(EXPENfES) 1.964 3.229 1.177 248 237 379 7.703
INCOME (LOSS) BEFO0.E CONT0.IAUT10N56
TRANfFERf 77.988 (86.571) 110,011 639.882 (34,001) (9.619) (68344) (5.083)
Cantnbwions 59.000 39.149 40.670 - ~ ~ -
Transfen In - - - - '
Transfen Oul (50.000) (50,000) (SO.OOO)
TOTALCONTRIBUTION56TRTNSFERS 9,000 (10.851) (9330) - ~ CHANGE M FUND BALINCE 36.988 (97362) 700.687 639.881 (34.00i) (9.619) (68.344) (5.083)
i
BEGINNINGFUNDBAUNCEJanuary1,7010 58.580,947 64.391.018 39,320.492 1,576387 9.687b53 7,114.074 5,501.774 1,473.941
- ENDINGFUNDBAIANCE.lanuary 31.2010 58.617.929 64,293.666 39.417.773 2.716,769 9b53b52 I.I04.455 5.433.431 1,468.857
Solid Waste operating expenses are low due to timing of invoices form Waste Management.
January billing of $611.245 was posted in February.
Page 7 of 8
, Monthly Financial Report January 2010
Internai Service Funds
The table below provides an analysis of all City Internal Service funds and shows the year to date
revenues and expenditures for each fund.
Information Equipment
Insurance Facilities Servires Rental
OPERATING REVENUES:
Charges for services - 216,462 325,172 202.688
Rents. Leases & Concessions - 27.718
TOTALOPERATINGREVENUES - 244380 325,172 202,688
OPERATING EXPENSES:
Administration 1,304,105 - 4,945
Operationt & Maintenance - 133,170 226.239 47,160
Depredation & Amortization - - 40.285 90,849
TOTAL OPERATING EXPENSES 1.304.105 133,170 266.524 142.954
OPERATING INCOME (LOSS) (1304.I05) 111.011 58.648 59.734
NON-OPERATING REVENUES 6 EXPENSES
Interest Revenue 516 100 984 1,242
Other Non Operating 0.evenue - - 2.024 529
TOTAL NON-OPERATING REVENUES (EXPENSES) 516 100 3.008 1,771
INCOME (LOSS) BEFORE CONTRIBUTIONS & TRANSFERS (1303.588) 111.111 61,656 61.505
Contributions - - -
Transfers In - -
Transfers Out - - - (7.000)
TOTALGONTRIBUTIONS&TRANSFERS - - (7.000)
CHANGE IN FUND BAL4NCE (I.303,588) 111.111 61,656 54,505
BEGINNING FUND BAL4NCE, January I, 2010 2,234.469 242.514 4.914,846 10.892.939
ENDING FUND BALANCE, January 31, 2010 930.881 353.625 4.976.501 10.947,444
The Insurance Fund expenses include $1,229,855 that is paid at the beginning of the year but will
be allocated to other funds mid year when the statistical information is received from WCIA.
Contact information
This report is prepared by the Finance Department. Additional financial information can also be
viewed at our website: http://www.auburnwa.gov/. for any questions about the report please
contad us at kiesterCo?auburnwa.gov or scoleman(a?auburnwa.gov.
Page 8 of 8
SALES TAX SUMMARY
Januar 2010 NovemberRecei ts
rro no
NniCS CONST0.0CTION 0910inL 09Yip t0Yi0 Y,DIII NarS aUi0H0iNF 09tO1at 0 Y1D 10ttD XD'H
236 Consttuclionol&iqinps 6]5 JIi 509U Jd.161 la?ti an 4davenc* BPaYDea4r
dJ69.aU 11~.551 160,11] dJ% l]) HeavydCviCmsuuciun 1 n0889 7660 17.576 19a13k 44] (',asyne5lauors i09fiI'i161] 15948 T6l%
]JB SpetiaryLaGeCoMrdC10r5 6p]}16 QJI] QOfi9 .86% 10UlAp10M0iIVE S 2.559.061 S tEi,lii S 1I6,1W
TOTf.ICONSTRUCTON f 1.16e]I] f 105.696 $ 98,810
WeOI1rlvlwnotrveCNnge4pnP.<viousYear (S10.811/ S.IX
Ov<nllCam(ruclionChanpelromPo~novsYwr ~ (E6,LE)) 6.5%
NPICS REiNLiPADE WIOtAI 09tt0 tOttO %pill
vi0 u] Fum~meb.'~ameF~menvps 219_7]5 72.351 1),85] ip.1X
NPxUFARURING pgi0iaL p9xTp mno %pill eq EkaronKStPOdances ❑Vf5 163,741 8,719 .94.7%
]fl fooCUVylacWrng ~ )61i au 69 BIJk 444 Bubeguartiui8Ca,0en 358.1M 75.313 35.898 tl.8%
317 Bereraqe8TO0aaaPfopucts 3890 ]O} 724 155+e 445 Fooa88e.erageApes 352,401 LSfii 79,410 68%
Jq ieaokMns 2i5 30 21. JE61 4e6 HeaimLPaSwNGne 9156 U.115 ll.7ll .U6% .
3t~ iulue a,oEmtM~6 ~n i.tsn 150 nfi 13tL <aB CioiNrgbAacess«rts 791376 7I.785 68.810 36X '
JIS ApoareiManolxiu'ng ))9 1018 66 976•b 451 SpomnpGaoUS.HOOey,BOOws 4511 y 3.767 3,110 16.6%
316 LeaW bMieUPmEUCIS 6i 11 0 965•6 457 GenerairnefcnandSeSlaes 8329n 68,616 6I,070 .1.7Y,
IIi Wpo0FO0uclNanulacWnnp 31!11 _ 196e 1911 1 9: 453 Misc¢iianeousSiweReWneiS 401 ,356 36.997 35,774 .d1%
Pace~ManolxwMp P99] 15, 131 5)]•: 154 NonameReulert 218016 iBJll 21604 178%
713 Primiig6RelateG5o0Dw U.SV 3451 IOdE 177>; iOtAIREiARiRAOE 5 3 ,580.129 S 455,195 3 I99.131
]p `PeVOkmnBCOdIProCucb I0100 1.111 102 -836`. peullGeneralReuilCNnye4omPrevrousYUi (11155963) .34 725 CnemKallAanulanvin9 61.?f15 nBa 767 751Y .
326 PlasticBNuELerProoucu 96fi.i 611 ]i< 561 v1D
777 Nonmeia?eMme2lProUO[IS Iti)ip iiU 1 ]3) .2148°; SERNCES 09i0iPL 09YiD fOYTD %Dill
731 PevndryNetalMamil,xWinq 192 v .16 .19708 L Inlamaimn 66.586 33.131 3].51t LI%
331 FaOncaleOUnmMqVroEOCb Q l31 656 ]Jit ]5]4^: SY FuoMedinsunrce 92.939 3.863 S.IU 102X
333 MacM1irerylAanubclmiq A193 6]] 1,036 5314 53' HeAESiaie.RemA.teasmq JO<}pp 25.098 ]],611 -9.9y,
7N CampmndElecuor:[ROOUns tllTS :16 BI] 95E•.: Sai PioiessamlScemnK.lttn 199,712 9.564 12891 NEX
135 EIttVCE@qnRnl,ApDidMK 2 .119 29k 59 GomwnyMaeaqemenl 478 l] 17 .671% '
376 TransponaiimEydpmentlAlq . 111978 12 .755 10195 .i2 0!'. 55' Annu,.5vpp.RemeES.a 16p.98i 13.515 17.019 LB%
337 Fumdure80.txtre0ProWtls VJBI 41] 1607 710,1% 6u EEiemmai5urcec 42J61 2825 1,512 46.5%
339 M'attWneousNanvlapumq 21.911 1.919 - 1653 .119!: 62' Hm4nCVeSaol Awsurce 61i57 4.8E4 ZIBi .Il.p%
TOiALRANUFa[TURING S 381169 S 16.761 S 1E.667 ]i• MsdEnierurunm ia)_ip) 58_077 51,351 4 21{
O.en11 ManvlacNrinBCna^9ehomPreviousYroi 51,505 9.6% )y xf,cpmmepajmdFOOESas 827.347 61698 61.583 .4 8%
el' aM, u^¢es - 47203 ]8.]52 i1.955 .1.1%
YTD 92* PopkppmnaVWqn 6159 196 1979 9041X
iPANSPOqiAiION{WIREHOU9HG 0 TOlAL p3Ylp 10 TT0 XOill TOiPLSERVICES $ },e6],dp! S $U,N1 { $Ip,NJ
181 AiirarspMatun p 0 0 WA Ov.nSenioesCNngoLOmReriousvea. I3.971 1.6%
482 PaiTrinSppbfvM 997 a], I$I JINy
484 irvdTraspMation ].090 l9, AB 09ti
485 iraiwanaCxpmOPassengers 5 U 0 a01V,4 YTD
488 TlyrSopfldYdl$Y(y'0I1 13 m IAC1 939 J]i`: NiSCEUnHEOu5 09LOTAL a9YTD 10Yi0 '.SUiI~
491 PosU15ervies ' i90 46 18 N:A 000 Unuawn 772 63
0 .~000%
a9E CourkrsBNesurcyen i.ua 0 0 epivq' 111.115 eqiemwefaeStry.FeMq 1.611 41 77 .17.1%
dW W3elrousnGb9areoe 126 _795 ]OS 7075. IILItt MnrqdUWibes }7,a5] ' 1,106 1276 II]X
TOTAtTPANSPdWNSING $ ]0,]9t 5 },ON 5 1)31 999 UnciaivlaOkEsu015M1ments " 16906 5805 I693 700%
OvmninnspaUfionCNnpehomvrcv;ousva. (5243P 110% AfISCELtAUE0UST0i4L 5 46.456 S 7.010 f 1,965
OverallMisreiOneousCOangeLOmPieviousYeai (td,OSJ) -9]%
T10
Wr10LE5AlE TqAOE 09 TOTAI 09 YT0 10 Yi0 X Odl
WntsTra0e0uraUkGoo05 ' 91991p 61.851 95.957 41!k yip
414 vmtsrraae-r+ordmaGeGOOas I49752 12640 9137 Q7.0°% 09i01A1 09Yi0 10TT0 80111
QS NTW¢ylpEleQrOnKMdktls 3.744 I86 IS] .IBS°: Gft4N0i0TAL5 511909,1)9 f1,103.451 $961169
WHOlESALETRR0ET0TAL $ l0]}965 S 80.6)9 S IDSEP GonOiQOIChanpelromAevmusYmr (1144]83) 1I101A
OverallWhWeSaleLhangelrom)"eviousYwr 515,19E ]LT% '
ic:rvn Pa, I
oeae..o.n
City of Auburn
Investment Portfolio Summary
As of January 31, 2010
Investment Purchase Purchase Maturity Yield to
Type Date Price Date Maturity
State Investment Pool Various $ 72,951,212 Various 0.286%
KeyBank Money Market Various 5,236,906 Various 0.120%
US Treasury 5/4/1990 57,750 5/15l2016 5720°/o
FHLMC 8/17/2009 1,000,000 8/17/2012 2.160%
FHLB 7/24/2008 1,022,000 5l26/2010 4.520%
FHLB 2/212009 1,000,000 2/2/2011 1.540%
FHLB 2/2/2009 1,000,000 8/2/2011 1.840%
FHLB 8/10/2009 1,000,000 2/10/2012 1.740%
FHLB 8/11/2009 1,000,000 5/11/2012 1240%
FHLB 12/10/2009 1,000,000 12/10/2012 1.000%
F Fi L6 11 /24/2009 1,000,000 11 /21 /2012 1.000%
FHLB 12f29/2009 1,000,000 6/29/2012 1.375%
Total Cash & Investments $ 87,267,866 0.44°/a
Investment Mix % of Total Summary
State Investment Pool 83.6% Current 6-month treasury rate 0.15°/a
KeyBank Money Market 6.0% Current State Pool rate 029%
US Treasury 0.1% KeyBank Money Market 0.12%
FHLB 9.2% Blended Auburn rate 0.44°/a
FHLMC 1.1%
100.0%