Loading...
HomeMy WebLinkAbout09/15/2009 08A 2nd Quarter 2009 Treasury Report S BUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDA STATEMENT Item No. For Meeting Of 9 -15 -2009 ITEM TITLE: 2nd Quarter 2009 Treasury Report SUBMITTED BY: Finance Department CONTACT PERSON/TELEPHONE: Rita DeBord, Finance Director / 575 -6070 Cindy Epperson, Deputy Director of Acct/ Budget 575 - 60700 SUMMARY EXPLANATION: The Treasury Report for the second Quarter of 2009 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 S • 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: Note: Although the national economic conditions summarized below are grim, it should be noted that the City invests in high quality government sponsored entities and has sufficient liquidity to meet its near -term obligations. In the second quarter, the national economy continues to struggle in most sectors, but the decreases in most areas are beginning to moderate, suggesting that the effect of the various stimulus programs and the aggressive actions be the FED are beginning to bear fruit. July's Continued... Resolution Ordinance Other (Specify) Report Contract Mail to (name and address): Phone: Funding Source APPROVED FOR SUBMITTAL: City Manager I STAFF RECOMMENDATION: Accept Report. BOARD /COMMISSION RECOMMENDATION: N/A COUNCIL ACTION: 1 1 • • III Unemployment report actually showed a .1% drop in the nation's unemployment rate. Any optimism this may create, however, must be tempered with the possibility that the rate only went down because many unemployed have extinguished their benefits and are no longer considered in the calculation: The other question that merits thought_ is how long can the government stimulus programs be sustained and what will be the true long -term costs of those ,, measures. Many corporations have reported better earnings that expected, but much of those better than expected earnings are being borne on the backs of the unemployed, as corporate payrolls have shrunk. Julys employment report states that 6.7 million jobs have been lost in the county since the recession began in December 2007. The job losses in the workforce have shown measureable results in national productivity. June's report on capacity' utilization and industrial production still present a poor picture of manufacturing activity, for June cane in at 68.0, which is 12% below the average for the period measured from 1972 -2008. But the good news is that June's reduction was only .4% where May's was down 12 %. For the second quarter as a whole, output fell at a rate of 11.6 %, a more moderate contraction than the first quarter, when output fell at 19.1%. Consumer credit for June, the measurement of credit card debt and auto loans primarily, fell at an annualized rate of 5% to about 2.5 trillion. Consumer debt to equity is approximately 90.1%. This means consumers have altered their spending habits and are paying down debt and saving, rather thanspending on credit. (This, of course, is reducing tax revenue to state and local governments nationally.) In other national economic highlights: , • First -time claims for unemployment benefits, measured on a weekly basis, have decreased below the 600,000 per week level for 6 consecutive in a row. This is a leading indicator suggesting to many that unemployment may be peaking i4 • Consumer confidence, while showing some signs of improvement in May and June is sti ll weak as consumers are unwilling to spend on credit • _ National retail sales numbers are still weak, being led mostly by durable goods. The anomaly in this picture is the "Cash for Clunkers" stimulus program. This has had a significant affect on auto sales, and recently, the President extended this popular pr ogram • The decline in housing starts and permits is slowing as eligible consumers seem to be taking advantage of the first time home buyers credit. Locally, the decline in the sale of single family homes is slowing and median home prices are rising, suggesting that consumers are once again able to obtain affordable mortgages • The Federal Reserve's "Beige Book ", which is a bi- monthly survey of economic activity • through the 12 Federal Reserve districts, indicates that in many districts the stagnation or decline in economic activity is beginning to slow. The major concern expressed throughout most of the Districts is the slowdown in commercial real estate market 1 . • Inflation, both on the producer and consumer levels, is finally positive, allaying fe deflation. This is due mostly to recovery in commodity prices, most notably oil, which is currently around $70 a barrel - 2 of 5 • Inflation, both on the producer and consumer levels, is finally positive, allaying fears of deflation. This is due mostly to recovery in commodity prices, most notably oil, which is currently around $70 a barrel These conditions are anticipated to persist, but seem to be improving, but will probably remain negative through much of 2009 and possibly part of 2010. The City's Investment Portfolio: Since all the Fed's actions at this time are committed to keeping a low interest rate environment, it is likely that due to the conservative and short average maturity of the City's portfolio, earnings will suffer in 2009. However, as the Treasury issues unprecedented amounts of debt, the potential exists for interest rates to rise; we will be poised to take advantage of this situation. Conversely, should rates remain low; short positions will allow the City to move into longer maturities more quickly when the economic recovery becomes more evident. Funds available for investment 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. Current investment portfolio includes those investments urchased in September and October in an effort to improve returns through the remainder of 2008 and through 2009. The effective yield on the City's portfolio for the quarter ended 6/30/2009 was 1.72 %, with a current yield to maturity of 1.44% (the Local Government Investment Pool yielded .6157% for July). Approximately 66% of the City's $57 million portfolio was in overnight securities at June 30th, with more than half of that liquidity required to support expenditures on current projects and meet near -term obligations. The average life of the total portfolio on June 30th was 335 days. It is a time for caution in the credit markets, and we anticipate a low interest rate environment, as recessionary economic indicators persist. Due to the uncertainty in the financial market, current investments are focused on short term (one to two year) maturities with a 3 to 12 month call option. Note: The City is not invested in any Structured Investment Vehicles (SIV's) or Collateralized Debt Obligations (CDO's). These types of investments, along with certain asset - backed Commercial Paper seem to be the epi- center of the major credit failures. The City has not purchased these types of instruments. The City does hold bonds and notes drawn on such entities as the Federal Home Loan Bank, Freddie Mac, Fannie Mae and other Government Sponsored or controlled Enterprises. The stock of many of these entities' is currently suffering, but they have unlimited lines of credit with the US Treasury, which makes their bonds credit quality tantamount to Treasuries. The City's exposure to this general credit crisis is low. (3of5 if , Description of Treasurer's Reports ,• • Portf Summary 1�� This report shows investment position totals by category of investment, the p ercentage 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 'theicurrent balances of the City's bonded debt. • LID Cash Balances, & LID Bonds & Notes Payable p . 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. I II O • 4of5 - • 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. • 5 of 5 • .vu o ,-Y; 5 y' '1 fj u .,., + . ) Cit ma + 0 �{ ��j City of Yakima olio 129 North Sec reet .'q f t � ,.ti, �r Portfolio Management Yakima, WA 98901 V : , (509)576 -6639 ■ '-' 44 Portfolio Summary . • ' June 30, 2009 • Par Market Book % of Days to YTM Investments Value Value Value Portfolio Term Maturity Local Government Investment Pool 37,734,752.44 37,734,752.44 37,734,752.44 65.64 1 1 0.736 Federal Agency Coupon - Callable 19,250,000.00 19,357,855.00 19,249,016.48 33.49 1,149 995 2.794 Municipal Bonds 500,000.00 502,470.00 499,363.72 0.87 1,057 153 5.032 57,484,752.44 • 57,595,077.44 57,483,132.64 100.00% 395 335 1.462 Investments Total Earnings June 30 Month Ending Fiscal Year To Date Current Year 68,648.80 489,999.86 Average Daily Balance 57,941,784.94 57,385,337.78 • Effective Rate of Return 1.44% 1.72% Note: This worksheet identifies all city investments in the General Ledger except LID Notes of $334,600 , LID warrants of $693,872, a pass through note having an amortized cost of $13,411 and a savings account of $20,000. Z' G /i1/2:e>�>9 Tim Jensen, Treasury Services ffi r • • Reporting period 06/01/2009- 06/30/2009 . Portfolio BOND AP Run Date: 08/11/2009 - 14:53 PM (PRF PM1) SymRept 6.42 • . Report Ver. 5.00 �,.--:-.. By Call Date /,4, .. ; �.. , ,,, 1 City of Yakima ►+ � " ' ' / t� City of Yakima Portfolio 129 N orth Second Street } ' Q " �444041#1t s r b i ' Yakima, WA 98901 l. ',4-:4!,.:t.-., �i -,V I n ventory by Maturity Report rM ,00.:Ai a r.,4st v (509)576 -6639 - June 30, 2009 YTM/YTC Sec. Purchase Book Current Maturity /Call Maturity Total Par . Days to CUSIP Investment# Fund Type Issuer Date Value Rate Date Amount Days Value 360 365 Mat. /Call 3133XTH41 1344 515 MC1 Federal Home Loan Bank 04/17/2009 2,000,000.00 2.250 07/17/2009C 2,000,000.00 91 2,000,000.00 2.219 2.250 16 3128X8YT3 1348 896 MC1 Federal Home Loan. 04/30/2009 1,000,000.00 3.000 07/30/2009C 1,000,000.00 91 1,000,000.00 2.959 3.000 29 3133XPW75 1319 896 MC1 Federal Home Loan Bank 02/25/2008 250,000.00 3.000 08/25/2009 250,000.00 547 250,000.00 2.959 3.000 55 31331GWS4 1350 896 MC1 Federal Farm Credit Bank 05/28/2009 2,000,000.00 1.590 08/28/2009C 2,000,000.00 92 2,000,000.00 1.568 1.590 58 3136FHJ97 1351 896 MC1 Federal Nat'l Mtg. Assoc. 06/29/2009 1,000,000.00 • 2.250 09/29/2009C 1,000,000.00 92 1,000,000.00 2.219 2.250 90 3133XSC89 1335 896 MC1 Federal Home Loan Bank 10/06/2008 2,000,000.00 3.375 10/06/2009C 2,000,000.00 365 2,000,000.00 3.329 3.375 97 3133XSBV9 1334 896 MC1 Federal Home Loan Bank 10/07/2008 1,000,000.00 4.300 10/07/2009C 1,000,000.00 365 1,000,000.00 4.241 4.300 98 31331GDF3 1337 479 MC1 Federal Farm Credit Bank 10/15/2008 1,000,000.00 4.250 10/15/20090 1,000,000.00 365 1,000,000.00 4.192 4.250 106 3128X8WY4 1346 896 MC1 Federal Home Loan , 04/22/2009 1,000,000.00 3.050 '10/22/2009C 1,000,000.00 183 1,000,000.00 3.008 3.050 113 3133XSGS1 1339 513 MC1 Federal Home Loan Bank 10/27/2008 1,000,000.00 3.750 10/27/20090 1,000,000.00 365 1,000,000.00 3.699 3.750 118 3128X8XP2 1347 896 MC1 Federal Home Loan 04/27/2009 2,000,000.00 2.100 10/27/2009C 2,000,000.00 183 2,000,000.00 2.071 2.100 118 378892PY 1282 125 MUN UTGO's 01/09/2007 499,363.72 4.700 12/01/2009 500,000.00 1,057 500,000.00 4.963 5.032 153 3133XSN95 1342 896 MC1 Federal Home Loan Bank 11/24/2008 1,000,000.00 3.150 05/23/2010C 1,000,000.00 545 1,000,000.00 3.107 3.150 326 3133XPRE6 1318 896 MC1 Federal Home Loan Bank 02/25/2008 1,000,000.00 3.100. 08/25/2010 1,000,000.00 912 1,000,000.00 3.058 3.100 420 31398ASQ6 1340 896 MC1 Federal Nat'l Mtg. Assoc. 10/30/2008 999,016.48 4.000 07/07/2011 1,000,000.00 980 1,000,000.00 3,995 4.050 736 3136FHQU2 1349 551 MC1 Federal Nat'l Mtg. Assoc. 05/18/2009 2,000,000.00 1.750 11/18/2011 2,000,000.00 914 2,000,000.00 1.726 1.750 870 Subtotal and Average 19,748,380.20 19,750,000.00 19,750,000.00 2.811 2.850 225 • Net Maturities and Average 19,748,380.20 19,750,000.00 19,750,000.00 2.811 2.850 225 Portfolio BOND AP Run Date: 08110120 I M ( ymRept 6.42 ort Ver. 5.00j / Yakima f 1 4 N 01 - „� City of Yakirn rtfoho 129 North nd Street V ! .�' Yakima, WA 98901 ,A A � , , i Inventory by. Maturity Report x �� r �e r ; (509)576 -6639 q`°± a t '' `' June. 30, 2009 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 3133XPW75 1319 896 MC1 Federal Home Loan Bank 02/25/2008 250,000.00 3.000 08/25/2009 250,000.00 547 250,000.00 2.959 3.000 55 378892PY 1282 125 MUN UTGO's 01/09/2007 499,363.72 - 4.700 12/01/2009 500,000.00 1,057 500,000.00 4.963 5.032 153 3133XPRE6 1318 896 MC1 Federal Home Loan Bank 02/25/2008 1,000,000.00 3.100 08/25/2010 1,000,000.00 912 1,000,000.00 3.058 3.100 420 3133XSC89 1335 896 MC1 Federal Home Loan Bank 10/06/2008 2,000,000.00 3.375 10/06/2010 2,000,000.00 730 2,000,000.00 3.329 3.375 462 31398ASQ6 1340 896 MC1 Federal Nat'l Mtg. Assoc. 10/30/2008 999,016.48 4.000 07/07/2011 1,000,000.00 980 1,000,000.00 3.995 4.050 736 3133XSGS1 1339 513 MC1 Federal Home Loan Bank 10/27/2008 1,000,000.00 3.750 10/27/2011 1,000,000.00 1,095 1,000,000.00 3.699 3.750 848 3136FHQU2 1349 551 MC1 Federal Nat'l Mtg. Assoc. 05/18/2009 2,000,000.00 1.750 11/18/2011 2,000,000.00 914 2,000,000.00 1.726 1.750 870 3133XSN95 1342 896 MC1 Federal Home Loan Bank 11/24/2008 1,000,000.00 3.150 11/23/2011 1,000,000.00 1,094 1,000,000.00 3.107 3.150 875 31331GWS4 1350 896 MC1 Federal Farm Credit Bank 05/28/2009 2,000,000.00 1.590 11/28/2011 2,000,000.00 914 2,000,000.00 1.568 1.590 880 3136FHJ97 1351 896 MC1 Federal Nat'l Mtg. Assoc. 06/29/2009 1,000,000.00 2.250 12/29/2011 1,000,000.00 913 . 1,000,000.00 2.219 2.250 911 3133XTH41 1344 515 MC1 Federal Home Loan Bank 04/17/2009 2,000,000.00 2.250 04/17/2012 2,000,000.00 1,096 2,000,000.00 2.219 2.250 1,021 - 3128X8XP2 1347 896 MC1 Federal Home Loan 04/27/2009 2,000,000.00 2.100 07/27/2012 2,000,000.00 1,187 2,000,000.00 2.072 2.100 1,122 3133XSBV9 1334 896 MC Federal Home Loan Bank 10/07/2008 1,000,000.00 4.300 10/07/2013 1,000,000.00 1,826 1,000,000.00 4.241 4.300 1,559 31331GDF3 1337 479 MC1 Federal Farm Credit Bank 10/15/2008 1,000,000.00 4.250 10/15/2013 1,000,000.00 1,826 1,000,000.00 4.192 4.250 1,567 3128X8WY4 1346 896 MC1 Federal Home Loan 04/22/2009 1,000,000.00 3.050 04/22/2014 1,000,000.00 1,826 1,000,000.00 3.008 3.050 1,756 3128X8YT3 1348 896 MC1 Federal Home Loan 04/30/2009 1,000,000.00 3.000 04/30/2014 1,000,000.00 1,826 1,000,000.00 2.959 3.000 1,764 Subtotal and Average 19,748,380.20 19,750,000.00 19,750,000.00 2.811 2.850 974 Net Maturities and Average 19,748,380.20 19,750,000.00 • 19,750,000.00 2.811 , 2.850 . 974 • • • Portfolio BOND AP Run Date: 08/10/2009 - 15:29 IM (PRF IM) SymRept 6.42 Report Ver. 5.00j , • • rl v ' 1 / ti t,1 City of Yakima S h 1 r ^� °°,, ��1 u � l1 City of Yakima Portfolio 129 North Second Street " ' , " , Yakima, WA 98901 ' .* ��a ",' Sales /Call Report. :; $, ,� - - , (509)576 -6639 ;, - -4, , • Sorted by Maturity Date - Fund April 1, 2009 - June 30, 2009 Issuer Purchaslitedem. 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 04/28/2010 3128X7HZ0 1321 896 FHLMC 04/28/2008 04/28/2009 1,000,000.00 3.050 1,000,000.00 1,000,000.00 15,250.00 1,015,250.00 15,250.00 MC1 04/28/2010 Call Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 15,250.00 1,015,250.00 15,250.00 05/05/2010 3133XR2K5 1323 896 FHLB 05/05/2008 05/05/2009 1,000,000.00 3.150 1,000,000.00 1,000,000.00 15,750.00 1,015,750.00 15,750.00 MC1 • 05/05/2010 Call Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 15,750.00 1,015,750.00 15,750.00 04/28/2011 31398AQS4 1320 896 FNMA 04/28/2008 04/28/2009 1,000,000.00 3.500 1,000,000.00 1,000,000.00 17,500.00 1,017,500.00 17,500.00 MC1 04/28/2011 Call Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 17,500.00 1,017,500.00 17,500.00 • 12/09/2011 3133XSPAO 1343 896 FHLB 12/09/2008 06/09/2009 1,000,000.00 3.125 1,000,000.00 1,000,000.00 15,625.00 1,015,625.00 15,625.00 MC1 12/09/2011 Call Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 15,625.00 1,015,625.00 15,625.00 10/01/2012 3133XSAN8 1332 896 FHLB 10/01/2008 04/01/2009 1,000,000.00 4.000 1,000,000.00 1,000,000.00 20,000.00 1,020,000.00 20,000.00 MC1 10/01/2012 Call Subtotal 1,000,000.00 1,000,000.00 1,000,000.00 20,000.00 1,020,000.00 20,000.00 Managed Pool Withdrawals Withdrawal Withdrawal Current Withdrawal Withdrawal Date Amount Rate Amount Amount SYS1050 1050 896 STOFWA 01/01/2009 04/06/2009 1,400,000.00 0.734 1,400,000.00 1,400,000.00 SYS1050 1050 896 STOFWA 01/01/2009 04/07/2009 1,200,000.00 0.734 1,200,000.00 1,200,000.00 SYS1050 1050 896 STOFWA 01/01/2009 04/08/2009 950,000.00 0.734 950,000.00 950,000.00 SYS1050 1050 896 STOFWA 01/01/2009 04/09/2009 300,000.00 0.734 300,000.00 300,000.00 SYS1050 1050 896 . STOFWA 01/01/2009 04/13/2009 400,000.00 0.734 400,000.00 400,000.00 SYS1050 1050 896 STOFWA 01/01/2009 04/16/2009 100,000.00 0.734 100,000.00 100,000.00 SYS1050 1050 896 STOFWA 01/01/2009 04/17/2009 2,200,000.00 0.734 2,200,000.00 2,200,000.00 Portfolio BOND AP Run Date: 08/10/2009 - 0 SA (PRF Rept 6.42 ® � Ver. 5.00 0 City of Yakima Po Sales/Call Re April 1, , 20 2009 9 - -June' 09 . ge 2 Issuer PurchasRedem. 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/2009 04/20/2009 150,000.00 0.734 150,000.00 150,000.00 SYS1050 1050 896 STOFWA 01/01/2009 04/22/2009 1,800,000.00 0.734 1,800,000.00 1,800,000.00 SYS1050 1050 896 STOFWA 01/01/2009 04/27/2009 2,200,000.00 0.734 2,200,000.00 2,200,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/01/2009 700,000.00 0.734 700,000.00 700,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/06/2009 600,000.00 0.734 600,000.00 600,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/07/2009 1,800,000.00 0.734 1,800,000.00 1,800,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/13/2009 200,000.00 0.734 200,000.00 200,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/14/2009 100,000.00 0.734 100,000.00 100,000.00 SYS1050 1050 ' 896 STOFWA 01/01/2009 05/18/2009 2,250,000.00 0.734 2,250,000.00 2,250,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/20/2009 450,000.00 0.734 450,000.00 450,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/21/2009 100,000.00 0.734 100,000.00 100,000.00 SYS1050 1050 896 STOFWA 01/01/2009 05/28/2009 2,000,000.00 0.734 2,000,000.00 2,000,000.00 SYS1050 1050 896 STOFWA 01/01/2009 06/01/2009 230,000.00 0.734 230,000.00 230,000.00 • SYS1050 1050 896 ' STOFWA 01/01/2009 06/05/2009 1,000,000.00 0.734 1,000,000.00 1,000,000.00 SYS1050 1050 896 STOFWA 01/01/2009 06/08/2009 . 2,600,000.00 0.734 2,600,000.00 2,600,000.00 SYS1050 1050 896 STOFWA 01/01/2009 06/15/2009 700,000.00 0.734 700,000.00 • 700,000.00 SYS1050 1050 896 STOFWA 01/01/2009 06/23/2009 1,250,000.00 0.734 1,250,000.00 1,250,000.00 SYS1050 1050 896 STOFWA 01/01/2009 06/25/2009 1,250,000.00 0.734 1,250,000.00 1,250,000.00 SYS1050 1050 896 STOFWA 01/01/2009 06/29/2009 900,000.00 0.734 900,000.00 900,000.00 Subtotal 26,830,000.00 26,830,000.00 26,830,000.00 Total Sales and Withdrawals 31,830,000.00 5,000,000.00 31,830,000.00 84,125.00 31,914,125.00 84,125.00 Portfolio BOND AP Run Date: 08/10/2009 - 15:30 SA (PRF_SA) SymRept 6.42 Report Ver. 5.00 • c„.. �$',,�r Yakima Portfolio 129 North S Street k 4 City of Yak 4. VV ' "` < - Yakima, WA 98901 t �� F "t Ma turity Report */ (509)576 -6639 ,; 11// Sorted by Maturity Date �� ;;: Received or due during April 1, 2009 - June 30, 2009 Sec. Maturity Purchase Rate Book Value Maturity Net CUSIP Investment # Fund Type Issuer Par Value Date Date at Maturity at Maturity Interest Proceeds Income 3133XSD70 1333 896 FAC FHLB 1,000,000.00 04/02/2009 10/02/2008 3.250 1,000,000.00 16,430.56 1,016,430.56 16,430.56 3133XQVZ2 1322 551 FAC FHLB 1,000,000.00 04/28/2009 04/28/2008 2.520 1,000,000.00 12,600.00 1,012,600.00 12,600.00 3133XSKC1 1341 896 FAC FHLB 1,000,000.00 04/30/2009 10/30/2008 3.090 1,000,000.00 15,621.67 1,015,621.67 15,621.67 3133XFLG9 1292 896 FAC FHLB 1,000,000.00 06/12/2009 06/21/2007 5.250 1,000,000.00 26,250.00 1,026,250.00 26,250.00 Total Maturities 4,000,000.00 4,000,000.00 70,902.23 4,070,902.23 70,902.23 Portfolio BOND ill AP Run Date: 08/10/200 MA (P 4nRept 6.42 411), Ver. 5 .00 • N � , Yakima �,s iex� ,: ," City of Yakima olio 129 North and Street r�. / Purchases Report Yakima, WA 98901 ;. V� �� (509}576 -6639 ,'. .¢ - ; y'� Sorted by Fund - Fund a "' April 1, 2009 - June 30, 2009 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 Risk Management 3133XTH41 1344 515 MC1 FHLB 2,000,000.00 04/17/2009 10/17 - 04/17 2,000,000.00 2.250 04/17/2012 2.250 2,000,000.00 Subtotal 2,000,000.00 2,000,000.00 0.00 2,000,000.00 Equipment Rental 3136FHQU2 1349 551 MC1 FNMA 2,000,000.00 05/18/200911/18 - 05/18 2,000,000.00 1.750 11/18/2011 1.750 2,000,000.00 Subtotal 2,000,000.00 2,000,000.00 0.00 2,000,000.00 Treasurer's Surplus Cash . 3128X8WY4 1346 896 MC1 FHLMC 1,000,000.00 04/22/200910/22 - 04/22 1,000,000.00 3.050 04/22/2014 3.050 1,000,000.00 3128X8XP2 1347 896 MC1 FHLMC 2,000,000.00 04/27/2009 07/27 - 01/27 2,000,000.00 2.100 07/27/2012 2.100 2,000,000.00 3128X8YT3 1348 896 MC1 FHLMC 1,000,000.00 04/30/2009 10/30 - 04/30 1,000,000.00 3.000 04/30/2014 3.000 1,000,000.00 31331GWS4 1350 896 • MC1 FFCB 2,000,000.00 05/28/200911/28 -05/28 2,000,000.00 1.590 11/28/2011 1.590 2,000,000.00 3136FHJ97 1351 896 MC1 FNMA 1,000,000.00 06/29/2009 12/29 - 06/29 1,000,000.00 2.250 12/29/2011 2.250 1,000,000.00 Subtotal 7,000,000.00 7,000,000.00 0.00 7,000,000.00 Managed Pool Deposits Deposit Deposit Deposit Amount Date Amount Rate SYS1050 1050 896 LA1 STOFWA 1,250,000.00 04/01/2009 1,250,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 1,300,000.00 04/02/2009 1,300,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 400,000.00 04/03/2009 400,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 750,000.00 04/10/2009 750,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 300,000.00 04/14/2009 300,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 200,000.00 04/15/2009 200,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 300,000.00 04/21/2009 300,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 2,850,000.00 04/28/2009 2,850,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 100,000.00 04/29/2009 100,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 1,600,000.00 04/30/2009 1,600,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 250,000.00 05/04/2009 250,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 1,000,000.00 05/05/2009 1,000,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 7,000,000.00 05/08/2009 7,000,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 650,000.00 05/19/2009 650,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 100,000.00 05/22/2009 100,000.00 1.182 • • . Portfolio BOND AP Run Date: 08/10/2009 - 15:33 PU (PRF_PU) SymRept 6.42 Report Ver. 5 .00 City of Yakima Portfolio • Purchases Report Page 2 April 1, 2009- June 30, 2009 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 1,800,000.00 05/29/2009 1,800,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 100,000.00 06/03/2009 100,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 400,000:00 06/09/2009 400,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 1,000,000.00 06/10/2009 1,000,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 200,000.00 06/11/2009 200,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 1,000,000.00 06/12/2009 1,000,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 100,000.00 ,06/16/2009 100,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 150,000.00 06/18/2009 150,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 250,000.00 06/22/2009 250,000.00 1.182 SYS1050 1050 896 LA1 STOFWA 1,950,000.00 06/30/2009 1,950,000.00 1.182 Subtotal 25,000,000.00 25,000,000.00 • Total Purchases and Deposits 36,000,000.00 36,000,000.00 0.00 ' 11,000,000.00 Portfolio BOND Al' 40 Run Date: 08/10/20 PU ( ymRept 6.42 port Ver. 5.00 0 CITY OF YAKIMA SCHEDULE OF GENERAL OBLIGATION AND REVENUE BOND ACTIVITY For the Period 4/1/2009 through 6/30/2009 PREVIOUS AMOUNT AMOUNT ENDING FUND DESCRIPTION BALANCE REDEEMED ISSUED BALANCE GENERAL OBLIGATION BONDS 272 PFD CONVENTION CENTER - unrefunded. $885,000 $210,000 $0 $675,000 272 PFD CONVENTION CENTER - refunded 4,900,000 10,000 0 4,890,000 281 PARKS AND RECREATION 560,000 0 0 560,000 281 FIRE /DOWNTOWN/RIVER ROAD 3,810,000 265,000 0 3,545,000 283 LAW & JUSTICE/I -82 Refunded 2,360,000 0 0 2,360,000 284 FIRE Refunded 1,545,000 0 0 1,545,000 285 G. 0. LINE OF CREDIT 0 0 0 0 , 287 CONVENTION CENTER Refunded 3,720,000 0 0 3,720,000 000 SUNDOME EXPANSION 1,298,052 0 0 1,298,052 281 2008 LTGO Infrastructure and Fire truck 2,895,000 0 0 2,895,000 SUB -TOTAL 21,973,052 485,000 0 21,488,052 O VENUE BONDS 488 WATER/WASTEWATER Refunded 3,385,000 0 3,385,000 488 SEWER Refunded 0 0 0 491 IRRIGATION 4,805,000 0 4,805,000 493 SEWER 14,170,000 0 14,170,000 488 WASTEWATER IMPROVEMENTS 5,365,000 0 5,365,000 SUB -TOTAL 27,725,000 0 0 27,725,000 GRAND TOTAL $49,698,052 $485,000 $0 $49,213,052 • • LID CASH BALANCES LID BONDS AND NOTES PAYABLE As Of Quarter Ending June 30th.,2009 As Of Quarter Ending June 30th.,2009 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 - 3,522.80 182,759.24 4,500.00 0.00 0.00 4,500.00 Equipment Rental 1056 30,368.17 218,481.02 125,400.00 0.00 0.00 125,400.00 Equipment Rental 1057 6,459.15 179,550.01 100,000.00 0.00 0.00 100,000.00 Equipment Rental 1058 25,704.27 160,868.69 104,700.00 0.00 0.00 104,700.00 Equipment Rental Totals $59,008.79 $784,410.91 $334,600.00 $0.00 $0.00 $334,600.00 Payments are typically made at the end of the year 110 0 0 • City of Yakima LID WARRANTS PAYABLE AS OF QUARTER ENDING JUNE 30TH, 2009 Balance Amount Amount Account Number Previous Quarter Issued Redeemed Balance 21101.059 $5,408.56 $0.00 $0.00 $5,408.56 Englewood Terrace 21101.060 200,086.66 29,197.14 0.00 229,283.80 85th and Kale 21 101.061 192,057.13 267,122.56 0.00 459,179.69 Simpson Lane Ilk otal Warrants Payable $397,552.35 $296,319.70 $0.00 $693,872.05 (1) Costs to LID in progress for which fmal assessment has not been confirmed. • City of Yakima LID BONDS / NOTES PAYABLE vs. LID GUARANTY FUND AS OF QUARTER ENDING JUNE 30TH, 2009 Outstanding Bonds and Notes Payable $334,600.00 10% of Outstanding Balance $33,460.00 Guaranty Fund -221 $79,602.25 10% of Outstanding LID's Bonds and Notes Payable ($33,460.00) Amount above (below) statutory minimum $46,142.25 0 CITY OF YAKIMA WARRANT ACTIVITY CLAIMS ACCOUNTS PAYABLE FUND (For the Period April 1, 2009 to June 30, 2009) Outstanding Warrants 03/31/09 $417,206.86 April Warrants: Issued $6,055,600.62 Canceled (7,351.31) Redeemed (4,933,942.60) Net Activity 1,114, 306.71 • Outstanding Warrants 04/30/09 I $1,531,513.57 I May Warrants: Issued $4,209,294.32 Canceled (12,574.70) Redeemed (3,893,047.12) Net Activity 303,672.50 Outstanding Warrants 05/31/09 I $1,835,186.07 June Warrants: Issued $6,642,305.54 Canceled (77.11) Redeemed (7,141,440.48) Net Activity (499,212.05) Outstanding Warrants 06/30/09 I $1,335,974.02 I • claims warrants /tab CITY OF YAKIMA WARRANT ACTIVITY PAYROLL FUND (For the Period April 1, 2009 to June 30, 2009) Outstanding Warrants 03/31/09 $1,120.51 April Warrants: Issued $2,919,062.21 Canceled 0.00 Redeemed ($2,916,875.75) Net Activity 2,186.46 Outstanding Warrants 04/30/09 I $3,306.97 0 May Warrants: Issued $2,935,643.12 Canceled 0.00 Redeemed (2,930,198.87) Net Activity 5,444.25 Outstanding Warrants 05/31/09 I $8,751.22 June Warrants: Issued $2,937,247.30 Canceled 0.00 Redeemed (2,940,510.01) Net Activity (3,262.71) Outstanding Warrants 06/30/09 $5,488.51 0 payroll warrants /tab • CITY OF YAKIMA REPORT OF CASH BALANCES June 30, 2009 Key Bank 41,9,361.88 Bank of New York (Fiscal Agent)(1) 0.00 U.S. Bank (Housing loan repayments) 579,763.37 Bank of America (Housing Rehab) 63,668.33 Yakima Federal Savings and Loan Association (Housing) 163,718.47 Bank of America (Claims Control) 1,207,178.47 U. S. Bank (Payroll Control) 9,208.18 fil Inmate Trust - Key Bank 10,093.42 Inmate Welfare - Key Bank 11,881.90 Municipal Court Key Bank 157,141.35 Petty Cash (2) 3,475.00 Police - Special Investigations(2) 7,500.00 Change Funds (3) 3,780.00 Travel Advance 4,800.00 Total Cash On Hand and In Bank Accounts 6/30/09 $2,641,570.37 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 R2008 -32 3 Change for customers established by Resolution R2008 -32 4 qtr cash bal /tab