HomeMy WebLinkAbout04/15/2008 09B 4th Quarter 2007 Treasury Report • BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT )c
Item No.
For Meeting Of 4 -15 -2008 •
ITEM TITLE: 4th Quarter 2007 Treasury Report •
SUBMITTED BY: Finance Department
CONTACT PERSON/ TELEPHONE: Rita DeBord, Finance Director / 575 -6070
Timothy Jensen, Treasury Services Officer / 575 -6
SUMMARY EXPLANATION:
The Treasury Report for the 4th Quarter of 2007 consists of the following: (
• Portfolio Summary
• Schedule(s) of Investment Inventory by Maturity and first call date (
• Sales /Calls Report (including State Pool)
• Maturities Report
• Purchases Report (including State Pool)
• Schedules of General Obligation & Revenue Bonds Payable
• LID Cash Balances, & LID Bonds & Notes Payable
• LID Warrants Payable
• LID Bonds /Notes Payable vs. LID Guaranty Fund
• Warrant Activity for Claims (Accounts Payable) & Payroll Clearing Funds
• Report of Cash Balances
(1) Schedules of investments by fund are available in the Finance Department.
(2) Refer to page(s) 3 & 4 for a description of Treasurer's Reports.
Economic Overview:
At their March 18th 2008 regular policy meeting, the Federal Open Market Committee lowered
its target for the federal funds rate by 75 basis points to 2.25%. The FOMC has acted decisively
and swiftly over the last six months to mitigate the systemic crisis in the housing and financial
products market, which started in the U.S., but has spread worldwide. Recent information
Continued...
Resolution Ordinance Other (Specify) Report
Contract Mail to (name and address):
Phone:
Funding Source
•
APPROVED FOR SUBMITTAL:
City Manager
STAFF RECOMMENDATION: Accept Report.
BOARD /COMMISSION RECOMMENDATION: N/A
COUNCIL ACTION:
TJ - QrtlyTreasRep2ndQtr2004.doc
1 -- April 10, 2008
indicates that the outlook for economic activity has weakened further since year end. Growth
in consumer spending and consumer confidence has slowed considerably and labor markets
have softened significantly in the last three months. Financial markets remain under
considerable stress, and the tightening of credit, the continued widening of credit spreads to
US Treasuries, and the deepening of the housing contraction are likely to have negative effect
on economic growth for the foreseeable future. •
Inflation has become an issue and some indicators of inflation expectations have risen. Due to
the weakening of the dollar, imported commodities such as oil, and base metals used in
manufacturing have become more expensive in the U.S. This trend has, in part, contributed to
flat industrial production and capacity utilization even as business inventories continue to
grow (largely a function of lowered consumer confidence and consumer spending). It will be
necessary to monitor inflation developments carefully.
The Fed, for the first time in history, has opened the discount window to the country's
struggling investment banks. This means investment banks, trying to find cash liquidity to
offset record losses from sub -prime mortgages and related investments, may now borrow cash
directly from the Fed, just like a commercial bank would be allowed to do, at low interest
rates. Some have suggested that this privilege should bring with it new and more stringent
oversight requirements. That issue continues as the SEC, the FED and the Treasury
Department try to work out exactly what those oversights should be.
410
The City's Investment Portfolio:
The City is not invested in any Structured Investment Vehicles (SIV's) at this time, nor will it
be in the future. These types of investments, along with certain asset - backed Commercial
Paper seem to be the epi- center of the credit failures. The City has no exposure to these types
of instruments. We do hold bonds and notes drawn on such entities as the Federal Home
Loan Bank, Freddie Mac, Fannie Mae and other Government Sponsored Enterprises. Many of
these entities' stock is currently suffering, but they have unlimited lines of credit with the US
Treasury which makes their bonds credit quality tantamount to Treasuries. We feel the City
has virtually no negative exposure to this . general credit crisis as it currently exists.
Funds under management come from a variety of sources including operating and capital
reserves, mandatory debt service reserves, employee benefit and risk management reserves
and bond proceeds until fully expended. Maturities are structured to best meet the cash flow
needs of the investing Fund.
The effective yield on the City's portfolio for the fiscal year ended 12/31/2007 was 5.03 %, with
a current yield to maturity of 4.952 %. Approximately 45% of the City's $55 million portfolio '.
was in overnight securities at December 31st, with more than half of that liquidity required to
support expenditures on current projects. The average life of the total portfolio on December
31st was 343 days. Due to the crisis in the credit markets, yields in 2008 will be significantly
lower than 2007. We feel it is better to position the portfolio for a likely rebound in interest
rates in 2009 rather than reach for meager returns in 2008 by extending the duration of the
portfolio.
TJ - QrtlyTreasRep2ndQtr2004.doc
2 -- April 10, 2008
Description of Treasurer's Reports
� p
• Portfolio Summary
This report shows investment position totals by category of investment, the
percentage of the portfolio invested and market values.
• Schedule of Investment Inventory by Maturity and Call Date
This report lists all of the City's major investments, with the exception of funds in
the State pool.
• Sales / Calls Report
This report shows sales of positions and callable bonds called in the report •
period. This includes:State Pool trading activity.
• Maturities Report
This report shows scheduled maturities for the period covered by the report.
• Purchases Report
This report shows purchases of all securities during the report period, including
State Pool trading activity.
•
• Schedules of General Obligation & Revenue Bonds Payable
This report indicates principal payments made during the reporting period, and
the current balances of the City's bonded debt.
• LID Cash Balances, & LID Bonds & Notes Payable
A Local Improvement District is an instrument utilized by citizens to fund
specific local community improvements. This report identifies outstanding
obligations relative to Local Improvement Districts' bonds and notes payable.
• LID Warrants Payable
Local Improvement District warrants are utilized until a project is complete, at
which time a bond or note is issued. This report identifies any outstanding
warrants.
•
TJ - QrtivTreasRep2ndQtr2004.doc
4 -- April 10, 2008
•
• ® LID Bonds/Notes Payable vs. LID Guaranty Fund
Once a Local Improvement District bond or note is issued, there is a required
minimum reserve which the City must maintain so long as the bond, or note is
outstanding. This report compares the current Local Improvement Districts
outstanding debt to the required reserve balance.
• Warrant Activity for Claims (Accounts Payable) & Payroll Clearing Funds
The City uses warrants in lieu of checks. The warrants are non - negotiable
instruments which represent obligations of the City. Included in this report is a
statement of activity and outstanding balances in the payroll and claims warrant
funds for the reporting period.
• Report of Cash Balances
This report is a listing of the balances at the end of the reporting period in each of
the City's major bank accounts.
•
•
TJ - QrtlyTreasRep2ndQtr2004.doc
5 -- April 10, 2008
•
� Q r , 4+��
,)
1/P:' 4. "e,..4,:\ Cit akima
�; $ ' City of Yakima Portfolio 129 North Second Street
r 1 Yakima, WA 98901
„ �. ,. ra Portfolio Management
Portfolio Summary
41 Ya+;a. °.�' December 31, 2007 (509)576 -6639
•
Par Market Book % of Days to YTM
Investments Value _ Value Value Portfolio Term 'Maturity
Local Government Investment Pool 24,692,192.25 24,692,192.25 • 24,692,192:25 44.59 1 1 4.561
Federal Agency Coupon Securities 7,150,000.00 7,194,164.00 7,154,998.21 12.92 404 216 6.411
Treasury Coupon Securities 1,000,000.00 1,000,120.00 999,994.91 1.81 1,020 48 4.100
Federal Agency Coupon - Callable 21,500,000.00 21,624,575.00 21,503,005.14 38.83 1,007 786 4.966
Municipal Bonds 1,020,000.00 - 1,030,421.18 1,025,240.28 ' 1.85 685 488 • 4.727
55,362,192.25 55,541,472.43 55,375,430.79 100.00% 475 343 4.952
Investments •
Total Earnings December 31 Month Ending Fiscal Year To Date Fiscal Year Ending
Current Year ,224,929.53 2,603,254.13 2,603,254.13
Average Daily Balance . 53,388,978.91 51,797,290.83
Effective Rate of Return 4.96% 5.03%
•
• Note: This worksheet identifies all city investments in the General Ledger except LID Notes of $370,700 , LID warrants of $37,413, a pass through note having a balance of $20,017 and a savings
account of $20,000.
Q
4 • Z 40 g
Tim Jensen, Treasury Services Officer ,-
Reporting period 12/01/2007- 12/3112007
Portfolio BOND
AP
Run Date. 04/08/2008 - 07:57 PM (PRF_PM1) SymRept 6.42
Report Ver. 5.00
•
4! f t3 4 o. . \ City of Yakima
1 � � '� City of Yakima Portfolio 129 North Second Street
\,4 i i i � rr ." Yakima, WA 98901
. Inventory by Maturity Report
, :.' , ..4;: , , , ,....„,,,,,01! , ,,++ '. " (509)576 -6639
,►64.110 . D ecem b er 31, 2007
Sec. Purchase Book Current Maturity Maturity Total Par YTM Days to
CUSIP Investment # Fund Type Issuer Date Value Rate Date Amount Days Value 360 365 Maturity
3128X5EW 1281 • 513 FAC Federal Home Loan 12/22/2006 1,000,169.87 5.500 01/18/2008 1,027,500.00 392 1,000,000.00 5.051 5.121 17
912828AT 1166 364 , TRC U.S Treasury 03/21/2003 500,056.89 3.000 02/15/2008 507,500.00 1,792 • 500,000.00 2.860 2.900 45
3133XKXT7 1291 612 TRC Federal Home Loan Bank 06/19/2007 499,938.02 5.230 , 02/21/2008 519,612.50 247 500,000.00 5.228 5.301 51
31359MG4 1268 896 MC1 Federal Nat'I Mtg. Assoc. 02/27/2006 1,000,000.00 5.000 02/27/2008 1,025,000.00 730 1,000,000.00 4.932 5.000 57
3133XDKN 1261 551 MC1 Federal Home Loan Bank 10/17/2005 1,000,000.00 4.700 04/17/2008 1,000,000.00 913. 1,000,000.00 4.636 4.700 107
3133XDHT1 1296 896 FAC • Federal Home Loan Bank 08/08/2007 1,099,653.99 5.000 04/28/2008 1,100,000.00 264 1,100,000.00 5.019 5.089 118'
3133XFN69 1297 896 FAC Federal Home Loan Bank 08/08/2007 1,000,417.50 5.125 06/18/2008 1,000,000.00 315 1,000,000.00 11.915 12.080 169
3133XLUJO 1294 896 MC1 Federal Home Loan Bank 07/30/2007 1,000,000.00 5.300 07/30/2008 1,000,000.00 366 1,000,000.00 5.227 5.300 211
3133XJUA4 1290 896 FAC Federal Home Loan Bank 06/06/2007 999,790.59 5.250 08/14/2008 - 1,000,000.00 435 1,000,000.00 5.206 5.278 226
3133XJUA4 1293 896 FAC Federal Home Loan Bank 06/21/2007 999,812.10 5.250 08/14/2008 1,000,000.00 420 • 1,000,000.00 5.203 5.275 226
3133MGVB9 1313 473 FAC Federal Home Loan Bank • 12/14/2007 553,956.71 5.500 08/15/2008 550,000.00 245 550,000.00 4.246 4.305 227
31359M5T6 1298 141 FAC Federal Nat'l Mtg. Assoc. 09/06/2007 500,940.98 5.125 09/02/2008 500,000.00 362 500,000.00 9.643 9.777 245
0591855B0 1310 513 MUN bALTIMORE UTGO 11/15/2007 528,167.15 6.500 10/15/2008 520,000.00 335 520,000.00 4.379 4.440 288
3133XMVN8 1309 896 MC1 Federal Home Loan Bank 11/09/2007 1,000,000.00 4.500 11/07/2008 1,000,000.00 364 1,000,000.00 4.438 4.500 311
3133XNFZ7 1311 896 MC1 Federal Home Loan Bank 11/28/2007 1,000,000.00 4.400 11/28/2008 ' . 1,000,000.00 366 1,000,000.00 4.340 4.400 332
31359ME7 1265 896 MC1 Federal Nat'I Mtg. Assoc. 01/23/2006 500,000.00 5.000 01/23/2009 500,000.00 1,096 500,000.00 4.932 5.000 388
31331YKR0 ' 1315 896 MC1 Federal Farm Credit Bank 12/28/2007 1,000,000.00 4.350 03/26/2009 1,000,000.00 454 1,000,000.00 4.295 4.355 450
3133XKKBO 1287 • 896 MC1 Federal Home Loan Bank 04/17/2007 1,000,000.00 5.150 04/17/2009 1,000,000.00 731 1,000,000.00 5.079 5.150. 472
3133XL6D0 1288 ' 896 MC1 Federal Home Loan Bank 06/04/2007 1,000,000.00 5.300 06/04/2009 1,000,000.00 '731 1,000,000.00 5.227 5.300 520
3133XFLG9 1292 896 FAC Federal Home Loan Bank 06/21/2007 1,000,256.47 5.250 06/12/2009 1,000,000.00 722 1,000,000.00 5.159 • 5.230 528
• 31398AHQ8 1304 896 MC1 Federal Nat'I Mtg. Assoc. 10/22/2007 1,000,000.00 4.710 . 10/22/2009 1,000,000.00 731 1,00(000.'00 4.645 4.710 660
3133XMTS0 1308 • 896 MC1 Federal Home Loan Bank 11/05/2007 1,000,000.00 4.500 11/05/2009 1,000,000.00 731 1,000,000.00 4.438 4.500 674
378892PY 1282 125 MUN UTGO's 01/09/2007 497,073.13 4.700 12/01/2009 500,000.00 1,057 500,000.00 4.963 5.032 700
31359M4L4 1295 551 MC1 Federal Nat'I Mtg. Assoc. 07/27/2007 999,172.07 5.250 01/22/2010 1,000,000.00 • 910 1,000,000.00 5.221 5.293 752
31359M4W0 1289 514 MC1 Federal Nat'I Mtg. Assoc. 06/04/2007 998,981.78 5.330 01/29/2010 1,000,000.00 970 1,000,000.00 5.306 5.380 759
3133XMAY7 .1305 896 ' MC1 Federal Home Loan Bank 10/04/2007 • 1,003,611.29 5.200 09/10/2010 1,000,000.00 1,072 1,000,000.00 • 4.983 5.053 983
3133XNME6 • ' 1314 896 MC1 Federal Home Loan Bank 12/17/2007 1,000,000.00 4.250 09/17/2010 1,000,000.00 1,005 1,000,000.00 • 4.194 4.252 990
31398AJK9 1307 896 MC1 Federal Nat'I Mtg. Assoc. 11/05/2007 1,000,000.00 4.750 11/05/2010 1,000,000.00 1,096 1,000,000.00 4.685 4.750 1,039
31359MH48 1312 896 MC1 Federal Nat'I Mtg. Assoc. 12/10/2007 1,001,240.00 5.300 02/22/2011 1,000,000.00 1,170 1,000,000.00 5.183 ' 5.255 1,148
3136F7Z8 1275 610 MC1 Federal Nat'I Mtg. Assoc. 09/15/2006 500,000.00 5.400 09/15/2011 500,000.00 1,826 500,000.00 5.326 5.400 1,353
3136F7Z8 1276 515 MC1 Federal Nat'I Mtg. Assoc. 09/15/2006 500,000.00 5.400 09/15/2011 500,000.00 1,826 . , 500,000.00 5.326 5.400 1,353
3133XGWP 1277 896 MC1 Federal Home Loan Bank 09/22/2006 1,000,000.00 5.430 09/22/2011 1,000,000.00 1,826 1,000,000.00 5.356 5.430 1,360
3133XHFM 1278 896 MC1 Federal Home Loan Bank 10/17/2006 1,000,000.00 5.300 10/17/2011 1,000,000.00 1,826 1,000,000.00 5.227 5.300 1,385
3133XMQN4 1306 896 MC1 Federal Home Loan Bank 11/07/2007 1,000,000.00 5.000 11/07/2011 1,000,000.00 1,461 1,000,000.00 4.932 5.000 1,406
3128X6MQ6 1303 896 MC1 Federal Home Loan 10/01/2007 1,000,000.00 5.250 10/01/2012 1,000,000.00 1,827 1,000,000.00 5.178 5.250 1,735
Portfolio BOND
AP
• • Run Date: 04/08/2008 ® IM (P vmRe P t 6.42
r1 Ver. 5.00]
•
City of Yaki olio
Inventory by Mat Report • Page 2
•
•
•
rY Y p
Sec. Purchase Book Current Maturity Maturity • Total Par YT M __.__.__ Days to
CUSIP Investment # Fund Type Issuer Date Value Rate Date Amount Days Value 360 365 Maturity
Subtotal and Average 30,683,238.54 30,749,612.50 30,670,000.00 5.195 5.267 619
•
Net Maturities and Average 30,683,238.54 30,749,612.50 30,670,000.00 5.195- 5.267 619 .
•
•
•
•
•
•
•
•
•
•
•
•
• •
Portfolio BOND
AP
Run Date: 04/08/2008 - 08:02 - IM (PRF SymRept 6.42
Report Ver. 5.00j
•
f •
ot
Q > »Y
/ / cr II-�` ` City of Yakima
129 North
1 - City Of Yakima Portfolio Second Street
V �), i Inventory by Maturity Report By Call Date Yakima, WA 98901
C '' (509)576 -6639
o %i oa , December 31, 2007
Sec. Purchase Book Current Maturity /Call Maturity Total Par YTM/YTC Days to
CUSIP Investment # Fund Type Issuer Date Value Rate Date Amount Days Value 360 365 Mat. /Call
3128X5EW 1281 513 FAC Federal Home Loan 12/22/2006 1,000,169.87 5.500 01/18/2008 1,027,500.00 392 1,000,000.00 5.051 5.121. 17
3133XLUJO 1294 896 MC1 Federal Home Loan Bank 07/30/2007 1,000,000.00 5.300 01/30/2008C 1,026,500.00 184 1,000,000.00 5.227 5.300 29
912828AT 1166 364 - TRC U.S. Treasury 03/21/2003 500,056.89 3.000' 02/15/2008 507,500.00 1,792 500,000.00 2.860 2.900 45 •
3133XKXT7 1291 612 TRC Federal Home Loan Bank 06/19/2007 499,938.02 5.230 02/21/2008 519,612.50 247 500,000.00 5.228 5.301 51
31359MH48 1312 896 MC1 Federal Nat'I Mtg. Assoc. 12/10/2007 1,001,240.00' 5.300 02/22/2008C 1,000,000.00 74 1,000,000.00 4.538 4.601 52
31359MG4 1268 896 MC1 Federal Nat'I Mtg. Assoc. 02/27/2006 1,000,000.00 5.000 02/27/2008 . . 1,025,000.00 730 1,000,000.00 4.932 5.000 57'
31331YKR0 1315 896 MC1 Federal Farm Credit Bank 12/28/2007 1,000,000.00 4.350 03/26/2008C 1,010,875.00 89 1,000,000.00 4.288 4.348 85
3133XDKN 1261 551 MC1 Federal Home Loan Bank 10/17/2005 1,000,000.00 4.700 04/17/2008 : 1,000,000.00 913 1,000,000.00 4.636 4.700 107
3133XKKBO 1287 896 , MC1 Federal Home Loan Bank 04/17/2007 1,000,000.00 5.150 04/17/2008C 1,000,000.00 366 . 1,000,000.00 5.079 5.150 107
3133XDHT1 1296 896 FAC Federal Home Loan Bank 08/08/2007 1,099,653.99 5.000 04/28/2008 • 1,100,000.00 264 1,100,000.00 5.019 5.089 118
3133XMVN8 1309 896 MC1 Federal Home Loan Bank 11/09/2007 1,000,000.00 4.500 05/07/2008C 1,000,000.00 180 1,000,000.00 4.437 4.499 127
3133XNFZ7 1311 • 896 MC1 Federal Home Loan Bank 11/28/2007 - 1,000,000.00 4.400 05/08/2008C 1,000,000.00 162 1,000,000.00 4.340 4.400 128
3133XL6D0 1288 896 MC1 Federal Home Loan Bank . 06/04/2007 1,000,000.00 5.300 06/04/2008C 1,000;000.00 366 1,000,000.00 5.227 5.300 155
3133XFN69 1297 896 FAC Federal Home Loan Bank 08/08/2007 1,000,417.50 5.125 06/18/2008 1,000,000.00 • 315 1,000,000.00 11.915 12.080 169
31359M4L4 1295 551 MC1 .Federal Nat'I Mtg. Assoc. 07/27/2007 999,172.07 5.250 07/22/2008C 1,000,000.00 361 1,000,000.00 5.281 5.354 ' 203
3133XMTS0 1308 896 MC1 Federal Home Loan Bank 11/05/2007 1,000,000.00 4.500 08/05/2008C 1,000,000.00 274 1,000,000.00 4.438 4.500 217
3133XJUA4 1290 896 FAC Federal Home Loan Bank 06/06/2007 999,790.59 5.250 08/14/2008 1,000,000.00 435 1,000,000.00 5.206 5.278 226
3133XJUA4 1293 896 FAC Federal Home Loan Bank 06/21/2007 999,812.10 5.250 08/14/ 1,000,000.00. 420 1,000,000.00 5.203 5.275 226
3133MGVB9 1313 473 FAC Federal Home Loan Bank 12/14/2007 553,956.71 5.500 08/15/2008 550,000.00 245 550,000.00 4.246 4.305 227
31359M5T6 1298 141 FAC Federal Nat'I Mtg. Assoc. 09/06/2007 500,940.98 5.125 09/02/2008 500,000.00 362 500,000.00 9.643 9.777 245
3133XMAY7 1305 896 MC1 Federal Home Loan Bank 10/04/2007 1,003,611.29 5.200 09/10/2008C 1,000,000.00 342 1,000,000.00 4.695 4.760 253
3136F7Z8 1275 610 MC1 Federal Nat'I Mtg. Assoc. 09/15/2006 . 500,000.00 5.400 09/15/2008C 500,000.00 731 500,000.00 5.326 5.400 258
3136F7Z8 1276 515 MC1 Federal Nat'l Mtg. Assoc. 09/15/2006 500,000.00 5.400 09/15/2008C 500,000.00 731 500,000.00 5.326 5.400 258
3133XGWP 1277 896 MC1 Federal Home Loan Bank 09/22/2006 1,000,000.00 5.430 09/22/2008C 1,000,000.00 731 1,000,000.00 5.356 5.430 265
3128X6MQ6 1303 896 MC1 Federal Home Loan 10/01/2007 1,000,000.00 5.250 10/01/20080 ' 1,000,000.00 366 1,000,000.00 5.178 5.250 274
059185580 1310 513 MUN bALTIMORE UTGO 11/15/2007 528,167.15 6.500 10/15/2008 - 520,000.00 335 520,000.00 4 4.440 288
3133XHFM 1278 896 MC1 Federal Home Loan Bank 10/17/2006 1,000,000.00 5.300 10/17/2008C 1,000,000.00 731 1,000,000.00 5.227 5.300 290
31398AHQ8 1304 896 MC1 Federal Nat'l Mtg. Assoc. 10/22/2007 1,000,000.00 4.710 10/22/2008C 1,000,000.00 366 1,000,000.00 4.645 4.710 295
31398AJK9 1307 896 MC1 Federal Nat'l Mtg. Assoc. 11/05/2007 1,000,000.00 4.750 11/05/2008C 1,000,000.00 366 1,000,000.00 4.685 4.750 309
3133XMQN4 1306 896 MC1 Federal Home Loan Bank 11/07/2007 1,000,000.00 5.000 11/07/2008C 1,000,000.00 366 1,000,000.00 4.932 5.000 311
31359ME7 1265 896 MC1 Federal Nat'I Mtg. Assoc. 01/23/2006 - 500,000.00 5.000 01/23/2009 500,000.00 1,096 500,000.00 4.932 5.000 388
3133XFLG9 1292 896 FAC Federal Home Loan Bank 06/21/2007 1,000,256.47 5.250 06/12/2009 1,000,000.00 722 1,000,000.00 5.159 5.230 528
378892PY 1282 125 MUN UTGO's 01/09/2007 497,073.13 4.700 12/01/2009 500,000.00 1,057 500,000.00 4.963 5.032 700
31359M4W0 , 1289 514 MC1 Federal Nat'I Mtg. Assoc. 06/04/2007 998,981.78 5.330 01/29/2010 1,000,000.00 970 1,000,000.00 5.306 5.380 759
3133XNME6 1314 896 • - MC1 Federal Home Loan Bank 12/17/2007 1,000,000.00 4.250 09/17/2010 1,000,000.00 1,005 1,000,000.00 4.194 4.252 990
Portfolio BOND
AP
Run Date: 04/08/2008 IM (P mRe . j
•
•
er. 5.00j
•
City of Yaki olio
•
Inventory by Matu y Report Page 2
•
Sec. Purchase Book Current Maturity/Call Maturity Total Par YTM/YTC __.._ Days to
CUSIP Investment# Fund Type Issuer Date Value Rate Date Amount Days Value 360 365 Mat. /Call
Subtotal and Average 30,683,238.54 30,786,987.50 30,670,000.00 5.166 5.238 246
Net Maturities and Average 30,683,238.54 30,786,987.50 30,670,000.00 5.166 5.238 246
•
•
•
•
•
•
•
•
•
•
•
•
•
• Portfolio BOND
AP
Run Date: 04/10/2008 - 07:36 IM (PRF_IM) SymRept 6.42
Report Ver: 5.00j
•
- City of Yakima
I ),� City of Yakima Portfolio 129 North second street
711 ,,,
Sales /Call Report Yakima
(509)5 WA 76 -6639 98901
J , �
` ce .1. °" S orted by Maturity Date -Fund
October 1, 2007 - December 31, 2007
Issuer Purchas8edem. Date Par Rate at Book Value Redemption Redemption Total
CUSIP Investment # Fund Sec. Type DateMatur. Date Value Redem. at Redem. Principal Interest Amount Net Income
01/18/2008
3136F7QM 1264 473 FNMA 01/18/2006 10/18/2007 1,000,000.00 5.000 1,000,000.00 1,000,000.00 12,500.00 1,012,500.00 12,500.00
MC 1 01/18/2008 Call
Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 12,500.00 1,012,500.00 12,500.00
04/16/2008
•
3133XKJN6 1286 513 FHLB 04/16/2007 10/16/2007 1,000,000.00 5.250 1,000,000.00 1,000,000.00. 26,250.00 1,026,250.00 26,250.00
- MC1 04/16/2008 Call
Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 26,250.00 1,026,250.00 26,250.00
10/03/2008
31359MY6 1279 476 FNMA 11/13/2006 10/03/2007 1,000,000.00 5.125 999,491.76 1,000,000.00 25,625.00 1,025,625.00 26,133.24
MC 1 10/03/2008 Call
Subtotal 1,000,000.00 • 999,491.76 1,000,000.00 25,625.00 1,025,625.00 26,133.24
11/20/2008
•
3136F76A 1280 896 FNMA' 11/20/2006 11/20/2007 1,000,000.00' 5.200 1,000,000.00 1,000,000.00 26,000.00 1,026,000.00 26,000.00
MC 1 11/20/2008 Call
Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 26,000.00 1,026,000.00 26,000.00
12/28/2009 •
31359M2U 1285 896 FNMA 04/03/2007.12/28 /2007 1,000,000.00 5.250 1,000,000.00 1,000,000.00 26,250.00 1,026,250.00 26,250.00
MC 1 12/28/2009 Call
Subtotal • 1,000,000.00' 1,000,000.00 1,000,000.00 26,250.00 1,026,250.00 26,250.00
Managed Pool Withdrawals Withdrawal. Withdrawal Current Withdrawal . Withdrawal
• Date Amount Rate Amount Amount
SYS1050 1050 896 STOFWA 01/01/2007 10/01/2007 950,000.00 4.561 • 950,000.00 • 950,000.00
SYS1050 • 1050 896 STOFWA 01/01/2007 10/04/2007 750,000.00 4.561 750,000.00 750,000.00
SYS1050 1050 896 • STOFWA 01/01/2007 10/05/2007 1,800,000.00 4.561 1,800,000.00 1,800,000.00 .
SYS1050 1050 896 STOFWA 01/01/2007 10/09/2007 1,800,000.00 4.561 1,800,000.00 1,800,000.00
SYS1050 1050 • 896 STOFWA 01/01/2007 10/10/2007 250,000.00 4.561 250,000.00 ' 250,000.00
SYS1050 1050 896 STOFWA 01/01/2007 10/11/2007 400,000.00 • 4.561 400,000.00 400,000.00
SYS1050 1050 896 STOFWA 01/01/2007 10/12/2007 850,000.00 4.561 850,000.00 850,000.00
Portfolio BOND
AP
Run Date: 04/08/2008 - 08 • - - SA (PRF_, m Rept 6.42
. 40
Ver. 5.00
S City of Yakima io _
Sales /Call R OPage 2
•
• . October 1, 2007 - December 31, 2007
Issuer PurchasEtedem. Date Par Rate at Book Value Redemption Redemption Total
CUSIP Investment # Fund Sec. Type DateMatur. Date • Value Redem. at Redem. Principal . Interest Amount Net Income
Managed Pool Withdrawals Withdrawal Withdrawal Current Withdrawal Withdrawal
•
Date Amount Rate Amount Amount
SYS1050 1050 896 STOFWA 01/01/2007 10/17/2007 800,000.00 4.561 800,000.00 800,000.00
•SYS1050 1050 896 STOFWA 01/01/2007 10/22/2007 1,100,000.00 4.561 1,100,000.00 1,100,000.00
SYS1050 1050 896 STOFWA 01/01/2007 11/01/2007 1,300,000.00 4.561 1,300,000.00 1,300,000.00
SYS1263 1263- 896 LGIP 01/01/2007 11/05/2007 211,207.18 4.561 211,207.18 211,207.18
SYS1050 1050 896 STOFWA 01/01/2007 11/05/2007 1,650,000.00 4.561 1,650,000.00 1,650,000.00
SYS1050 1050 896 STOFWA 01/01/2007 11/06/2007 1,200,000.00 4.561 1,200,000.00 1,200,000.00 ,
SYS1050 1050 896 STOFWA 01/01/2007 11/07/2007 2,800,000.00 4.561 2,800,000.00 2,800,000.00,
SYS1050 1050 '896 STOFWA 01/01/2007 11/08/2007 400,000.00 4.561 • 400,000.00 .400,000.00
SYS1050 • 1050 896 STOFWA 01/01/2007 11/15/2007 600,000.00 4.561 • 600,000.00 600,000.00
SYS1050 1050 • 896 STOFWA 01/01/2007 11/21/2007 500,000.00 4.561, • . 500,000.00 500,000.00
SYS1050 1050 896 STOFWA .01/01/2007. 11/26/2007 • 500,000.00 4.561 500,000.00 _ 500,000.00 •
SYS1050 1050 896 STOFWA 01/01/2007 11/28/2007 900,000.00 4.561 900,000.00 900,000.00
SYS1050 1050 896 STOFWA 01/01/2007 12/03/2007 900,000.00 4.561 900,000.00 900,000.00
SYS1050 1050 . 896 STOFWA 01/01/2007 12/06/2007 , 1,400,000.00 4.561 1,400,000.00' 1,400,000.00
SYS1050 1050 896 STOFWA, 01/01/2007 12/07/2007 1,600,000.00 4.561 1,600,000.00 1,600,000.00
SYS1050 1050 896 STOFWA 01/01/2007 12/10/2007 300,000.00 • 4.561 300,000.00 300,000.00
SYS1050 1050 896 STOFWA 01/01/2007 12/13/2007 200,000.00 4.561 200,000.00 • 200,000.00
SYS1050 1050 896 STOFWA • 01/01/2007 12/14/2007 950,000.00 4.561 950,000.00 950,000.00
SYS1050 1050 896 STOFWA 01/01/2007 12/19/2007 200,000.00 4.561 200,000.00 200,000.00
SYS1050 1050 • 896 STOFWA 01/01/2007 12/21/2007 400,000.00 4.561 400,000.00 400,000.00
SYS1050 • 1050 896 STOFWA 01/01/2007 12/28/2007 500,000.00 4.561 500,000.00 500,000.00
Subtotal 25,211,207.18 25,211,207.18 25,211,207.18
Total Sales and Withdrawals ' • 30,211,207.18 4,999,491.76 • 30,211,207.18 116,625.00 30,327,832.18 117,133.24
•
•
Portfolio BOND
' AP
Run Date: 04/08/2008 - 08:04 - - SA (PRF_SA) SymRept 6.42
• • Report Ver. 5.00
•
• l
/7.17 _�� City of Yakima
<;, City of Yakima Portfolio 129 North Second Street
� t , „ ' { Maturity Report.
Yakima, WA 98901
,4t *4 (509)576 -6639
� -� �x , Sorted by Maturity Date
•,:'. !-'' Received or due during October 1, 2007 - December 31, 2007 •
Sec. Maturity Purchase Rate Book Value Maturity Net
CUSIP Investment # Fund Type Issuer Par Value Date Date at Maturity at Maturity Interest Proceeds Income
3133X4JT 1207 474 MC1 FHLB 1,000,000.00 12/17/2007 03/17/2004 3.125 1,000,000.00 7,812.50 1,007,812.50 7,812.50
Total Maturities 1,000,000.00 1,000,000.00 • 7,812.50 1,007,812.50 7,812.50
•
•
Portfolio BOND
AP
Run Date: 04/08/2008 - MA (PRF ymRept 6.42
ID rt Ver. 5 .00
. • . . .
' City of Yakima Portfolio 129 N oun seCOr,d str et
o'
( t T 3 Yakima, WA 98901
�.q ; �`/ Purchases Report
•��,„d : Sorted by Fund -Fund (SOS >57s ss39
�', +gie�r>RP' - • October 1, 2007 - December 31, 2007 •
•
Sec. • Original Purchase Principal ' , Accrued Interest Rate at Maturity YTM • Ending
CUSIP Investment # Fund Type Issuer Par Value Date Payment Periods Purchased . at Purchase Purchase Date 365 Book Value
Sewer Operating • .
3133MGVB9 1313 473 FAC FHLB 550,000.00 12/14/2007 02/15 - 08/15 554,257.00 9,999.31 5.500 08/15/2008 4.305 553,956.71
Subtotal 550,000.00 554,257.00 9,999.31 553,956.71
Emp Health Ben Res.
• 059185580 1310 513 MUN BALT 520,000.00 11/15/2007 05/01 - 10/15 529,490.00 • 2,816.67 6.500 10/15/2008 4.440 528,167.15
Subtotal 520,000.00 529,490.00 2,816.67 • 528,167.15
Treasurer's Surplus Cash
3128X6MQ6 1303 896 MC1 FHLMC . 1,000,000.00 10/01/2007 04/01 - 10/01 1,000,000.00 • 5.250 10/01/2012 5.250 1,000,000.00
3133XMAY7 1305 896 MC1 FHLB 1,000,000.00 10/04/2007 03/10 - 09/10 1,003,935.52 3,466.67 5.200 09/10/2010 5.053 1,003,611.29
31398AHQ8 1304 896 MC1 FNMA 1,000;000.00 10/22/200704/22 -10/22 1,000,000.00 4.710 10/22/2009 4.710 1,000,000.00
3133XMTS0 1308 896 MC1 FHLB 1,000,000.00 11/05/200705/05 -11/05 1,000,000.00 4.500 11/05/2009 4.500 1,000,000.00
. 31398AJK9 1307 896 MC1 FNMA 1,000,000.00 11/05/200705/05 -11/05 1,000,000 :00 4.750 11/05/2010 4.750 1,000,000.00
3133XMQN4 1306 896 MC1 FHLB 1,000,000.00 11/07/200705/07 - 11/07 1,000,000.00 • 5.000 11/07/2011. 5.000 1,000,000.00
.3133XMVN8 1309 896 MC1 FHLB 1,000,000.00 11/09/200705/07 -11/07 1,000,000.00 250.00 4.500 11/07/2008 4.500 1,000,000.00
3133XNFZ7 1311 896 MC1 FHLB 1,000,000.00 11/28/2007 05/28 - 11/28 1,000,000.00 4.400 11/28/2008 4.400 1,000,000.00
31359MH48 1312 896 • MC1 FNMA . - 1,000,000,00 12/10/2007 / - / 1,001,240.00 . - 10,600.00 5.300 02/22/2011 5.255 1,001,240.00
3133XNME6 1314 896 MC1 FHLB 1,000,000.00 12/17/200706/17 -12/17 1,000,000.00 4.250 09/17/2010 4.252 1,000,000.00
31331YKR0 1315 896 MC1 FFCB . 1,000,000.00 12/28/2007 03/26 - Final Pmt. 1,000,000.00 241.67 4.350 03/26/2009 4.355 1,000,000.00
Subtotal 11,000,000.00 11,005,175.52 - 6,641.66 . . 11,004,851.29
Managed Pool Deposits Deposit Deposit Deposit . -
Amount Date Amount Rate
SYS1050 1050 896 LA1 STOFWA 950,000.00 10/03/2007 950,000.00 • 5.213
SYS1050 • 1050 896 LA1 STOFWA 100,000.00 10/15/2007 100,000.00 . 5.213 .
SYS1050 1050 896 LA1 STOFWA 1,300,000.00 10/16/2007 1,300,000.00 5.213
SYS1050 • • 1050 896 LA1 STOFWA 1,300,000.00 10/18/2007 1,300,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 400,000.00 10/19/2007 . 400,000.00 • 5.213
SYS1050 • . 1050 896 LA1 STOFWA 100,000.00 10/24/2007 100,000.00 5.213 .
•
-SYS1050 1050 • 896 LA1 STOFWA 300,000.00 10/25/2007 300,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 1,200,000.00 10/29/2007 • 1,200,000.00 5.213 ,
SYS1050 1050 , 896 LA1 STOFWA 250,000.00 10/30/2007 250,000.00 5.213
Data Error = the accrued Interest at Purchase transaction was deleted or does not match the investment screen.
•
. • • Portfolio BOND
AP
Run Date 04/08/2008 - 08:06 • PU (PRF_PU) SymRept 6.42
0 Report Ver. 5 .00
•
City of Yakima Portfolio
Purchases Report Page 2
. October 1, 2007 - December 31, 2007
Sec. Original Purchase Principal Accrued Interest Rate at Maturity YTM Ending
CUSIP Investment # Fund Type Issuer Par Value Date Payment Periods Purchased • at Purchase Purchase Date 365 Book Value
Managed Pool Deposits Deposit Deposit Deposit
Amount Date Amount . Rate
SYS1050 • 1050 896 LA1 STOFWA 2,500,000.00 10/31/2007 2,500,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 211,207.18 11/05/2007 211,207.18 5.213
SYS1050 1050 896 LA1 STOFWA 4,000,000.00 11/09/2007 4,000,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 1,700,000.00 11/13/2007 1,700,000.00 5.213 •
SYS1050 1050 896 LA1 STOFWA 200,000.00 11/14/2007 200,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 200,000.00 11/19/2007 200,000.00 5.213
SYS1050 1050 896 • LA1 STOFWA ' 700,000.00 11/20/2007 700,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 500,000.00 11/27/2007 • 500,000.00. 5.213
SYS1050 1050 896 LA1 STOFWA 100,000.00 11/29/2007 100,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 1,950,000.00 11/30/2007 1,950,000:00 5.213
SYS1050 1050 896 LA1 STOFWA 700,000.00 12/05/2007 700,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 1,400,000.00 12/18/2007 . 1,400,000.00 5.213
SYS1050 1050 896 LA1 STOFWA • 200,000.00 12/26/2007 200,000.00 5.213
SYS1050 1050 896 LA1 STOFWA 2,400,000.00 12/31/2007 2,400,000.00 5.213
Subtotal 22,661,207.18 . 22,66t207.18
' Total Purchases and Deposits 34,731,207.18 • 34,750,129.70 6,174.32 12,086,975.15
Portfolio BOND •
AP
Run Date: 04/08/2008 - PU (PmRept 6.42
. rt Ver. 5,00
III CITY OF YAKIMA " •
SCHEDULE OF GENERAL OBLIGATION •
AND REVENUE BOND ACTIVITY
For the Period 10/01/2007 through 12/31/2007
•
PREVIOUS AMOUNT AMOUNT ENDING .
FUND DESCRIPTION BALANCE REDEEMED ISSUED BALANCE
GENERAL OBLIGATION BONDS
272 PFD CONVENTION CENTER - unrefunded 1 $1,085,000 $0 $0 $1,085,000
272 PFD CONVENTION CENTER - refunded 4,910,000 0 0 4,910,000
281 PARKS AND RECREATION 695,000 65,000 0 630,000
. 281 FIRE /DOWNTOWN /RIVER ROAD 4,070,000 • 0 0 ' 4,070,000 •
282 STREETS 175,000 0 0 175,000
283 LAW & JUSTICE /I -82 Refunded 3,225,000 425,000 0 2,800,000 .
284 FIRE Refunded . 2,010,000 230,000 0 1,780,000
285 G. 0. LINE OF CREDIT • • 24,569 0 0 24,569 •
287 CONVENTION CENTER Unrefunded 235,000 • 235,000 0
. 287 CONVENTION CENTER Refunded 4,035,000 35,000 0 4,000,000 .
000 SUNDOME EXPANSION 1,430,528 64,615 0 1,365,913
SUB -T0TAL 21,895,097 • 1,054,615 • 0 . 20,840,482
1111 REVENUE BONDS
484 WATER/SEWER Refunded 1,970,000 0 • 0 • • 1,970,000
486 WATER 2,070,000 0 : • 0 2
488 SEWER Refunded • 685 335 0 350,000
• 485 SEWER -APPLE TREE 523 16,728 9 506,317
• 491 IRRIGATION 4,910;000 0 0 _ 4,910,000
493 SEWER- 15,525,000 670,000 0 14,855,000
SUB -TOTAL 25,683,045 1,021,728 0 24,661,317
GRAND TOTAL $47,578,142 52,076,343 $0 $45,501.799 .
•
•
,
erp 4/9/2008 9:20 AM
LID CASH BALANCES LID BONDS AND NOTES PAYABLE
As Of Quarter Ending December 31, 2007 As Of Quarter Ending December 31, 2007
LID Current LID Original New LID Invested By
District District Bond Beginning Quarter Amount Districts Ending Quarter
No. Cash Balance Assessment Balance Paid Added Balance
1055 296.31 182,759.24 18,000.00 9,000.00 0.00 9,000.00 Equipment Rental
1056 24.94 218,481.02 159,000.00 18,100.00 0.00 140,900.00 Equipment Rental
1057 43.18 179,550.01 125,000.00 19,400.00 0.00 105,600.00 Equipment Rental
1058 34.66 160,868.69 127,000.00 11,800.00 0.00 115,200.00 Equipment Rental
Totals $399.09 $784,410.91 $429,000.00 $58,300.00 $0.00 $370,700.00
•
•
ERP 4/10/ 7:42 AM 12 -31 -07 LTD's & LTD Nis Page II
., 411
•
City of Yakima
LID WARRANTS PAYABLE
AS OF QUARTER ENDING DECEMBER31, 2007
Balance Amount Amount
Account Number Previous Quarter Issued Redeemed Balance
21101.059 • $5,408.56 $0.00 $0.00 $5,408.56
21 101.060 $27,456.52 $4,547.61 .$0.00 $32,004.13
Total Warrants Payable $32,865.08 $4,547.61 $0.00 $37,412.69
(1) Costs to LID in progress for which final assessment has not been confirmed.
•
•
ERP 4/8/2008 7:20 AM 12 -31 -07 LID's & LTD.xls Page 1 of 1
City of Yakima
LID BONDS / NOTES PAYABLE
vs.
LID GUARANTY FUND
AS OF QUARTER ENDING DECEMBER 31, 2007
Outstanding Bonds and Notes Payable $370,700.00
10% of Outstanding Balance $37,070.00
•
Guaranty Fund -221 $77,340.05
10% of Outstanding LID'S Bonds and Notes Payable ($37,070.00)
Amount above (below) statutory minimum $40,270.05
ERP 4/8/2008 7:30 AM 12 -31 -07 LTD's & LTD.xls Page 1 of 1
CITY OF YAKIMA
WARRANT ACTIVITY
PAYROLL FUND
(For the Period October 1, 2007 to December 31, 2007)
Outstanding Warrants 09/30/07 $1,592.50 '
October Warrants:
Issued $2,512,758.54
Canceled ($35.15)
Redeemed ($2,508,794.62)
Net Activity 3,928.77
Outstanding Warrants 10/31/07 $5,521.27
November Warrants:
Issued $2,571,167.65
Canceled $0.00
Redeemed ($2,571,605.42)
Net Activity (437.77)
Outstanding Warrants 11/30/07 $5,083.50
December Warrants:
Issued $2,575,940.99
Canceled $0.00
Redeemed ($2,579,062.62)
Net Activity (3,121.63)
Outstanding Warrants 12/31/07 $1,961.87
•
payroll warrants /tab
CITY OF YAKIMA
WARRANT ACTIVITY
CLAIMS ACCOUNTS PAYABLE FUND
(For the Period October 1, 2007 to December 31', 2007)
Outstanding Warrants 09/30/07 1 $906,382.69
October Warrants:
Issued $5,148,214.43
Canceled ($7,246.97)
Redeemed _ ($5,700,664.35)
Net Activity (559,696.89)
Outstanding Warrants 10/31/07 $346,685.80
November Warrants:
Issued $5,227,834.02
Canceled ($573.66)
Redeemed ($4,251,461.92)
Net Activity 975,798.44
Outstanding Warrants 11/30/07 $1,322,484.24
December Warrants:
Issued $3,978,538.62
Canceled ($65,852.22)
Redeemed ($4,536,990.57).
Net Activity . (624,304.17)
Outstanding Warrants 12/31/07 $698,180.07
claims warrants /tab
CITY OF YAKIMA
REPORT OF CASH BALANCES
December 31, 2007
Key Bank 387,335.57
Bank of New York (Fiscal Agent)(1) 0.00 ,
U.S. Bank (Housing loan repayments) 165,230.77
Bank of America (Housing Rehab) 63,392.63
Yakima Federal Savings and Loan Association (Housing) , 158,140.44
Bank of America (Claims Control) 528,976.95
U. S. Bank (Payroll Control) 4,497.54 "
Inmate Trust - Key Bank 15,898.99
t Welfare - Ke Bank
Inmate Key 12,255.23
Municipal Court - Key Bank 199,177.09
Petty Cash (2) 3,175.00
Police - Special Investigations(2) 7,500.00
Change Funds (3) 3,680.00
Travel Advance 4,850.00
Rental Deposit (Bank of America) 3,075.00
Total Cash On Hand and
In Bank Accounts 12/31/07 $1,557,185.21
1 Balance is zero as all coupons and principal has been paid to bond holders.
2 Represents impressed amounts. Cash on hand plus receipts for paid items equals this amount
per Resolution 2006 -34
3 Change for customers established by Resolution 2006 -34
qtr cash bal /tab