The URL can be used to link to this page

Home My WebLink AboutCC AG PKT 2008-05-27 #D . . . CITY OF SEAL BEACH ADMINISTRATIVE SERVICES DEPARTMENT MONTHLY INVESTMENT REPORT April-08 Prior Month Cash and Investments: February Cash and Investments: RDA LowlMod Housing Funds RDA Riverfront Fund RDA Debt Service Fund RDA Tax Increment Fund Trust and Agency Fu~ds, Component Unit Assessment Districts Capital Projects Water Enterprise Fund Sewer Enterprise Fund Special Revenue Funds General Fund Reserved for Fiscal Policies Designated for Change in Economic Conditions Designated for Self-Insurance Reserved for Compensated Absences Designated for Labor Contracts Designated for Capital Projects Restricted Deposit Accounts Available General Fund Balance $48,881,518.35 I $52,363,156.32 I 1,535,007.04 1,609,514.99 0.00 1,815,901.75 291,029.05 531,476.36 109,566.12 9,120,434.73 2,803,522.20 1,928,883.99 32,617,820.09 (5,891,000.00) (1,,750~00.o.OO) .' (900;~O()~OO) (670;000.00) (300,000.00) (1;000,000.(:)0) _ . _. (4,941,87.5.~7). 12,064,994.82 Agenda Item D CITY OF SEAL BEACH ADMINISTRATIVE SERVICES DEPARTMENT MONTHLY AGING REPORT April-OS Percent of Current Current Aging Interval Date of Maturity Investments Portfolio Book Value Market Value o days 4/30/2008 - 4/30/2008 1 94.89% $49,685,422.55 $49,685,422.55 1 - 245 days 5/1/2008 - 12/31/2008 6 3.44% $1,798,000.00 $1,801,376.77 246-610 days 1/1/2009 - 12/31/2009 'j 0.57% $298,000.00 $298,000.00 611-975 days 1/1/2010 - 12/31/2010 . ..~.. .. ..6... . . 1.10% $578,357.00 $578,357.00 Total 16 100.00% $52,359,779.55 $52,363,156.32 . . . . . . April-08 MONTHLY INVESTMENT REPORT Type of Investment Institution Investment Term: %of Portfolio Yield Earnings Allowance Earnings Accrual Interest Received Purchase Price Current Value $1,125,516.77 Source of Current Value Checking . Bank of America open 2.15% 1.000% Balance is per bank statement. Account is reconciled to the General Ledger within two months of monthend SI4,509.72 51,125,516.77 Checking Bank of America open 0.06% 1.000% Section 125 Balance is per bank statement. Account is reconciled to the General Ledger within two months of monthend. $323.45 $32,800.67 $32,800.67 Escrow Union Bank of Califomia open 0.00% $0.00 $0.00 State Pool Local Agency open 76.39% 3.770% $125,663,97 $1,302,187.46 539,999,140.5 I $39,999,140.51 Investment Fund State Pool Local Agency-RDA open 16.29% 3.770% 526,792;02 $27;964.60 $8;527,964.60 $8,527.964.60 Investment Fund Certificate of Dep. Broadway Federal Bank In12004 8122/2010 0.15% 3.350% $224.33 580,357.00 $80,357.00 Sutton Bank Liquid without early withdrawl penalty 7/512005 Cert.OfDep. Safekeeper r~{'liIli!.ililtJfILiL?0';J~:;3~:~Wt'i~";:..utt\r,:lI\,lt!;'f;;"~:.';"~!1;mmlf{1";,,);1,[JbJc1J1:f1ci.~~:(!)\1J!j~: ?'. ~(m.I(iJiJi~;i~#.fA~~~:";;f,~t~ihl' .., ; ;;'Vk.:~lh . : ,1~Q]!X~itf~ li.v.;m~;7:1 ~Ul,~iWiii(;; . l,l;l:';;'~ IL~?::}i~'l;S;.;f,:. ;"" Liquid without early withdrawl penalty 2/812006 Cert.OfDep. Safekeepa ;Slj~;rrr11f:v!&:"!!1r.,;~.:t:l"it2(i]1.]flil1f,;ur;tr;il\\!t~:4:;:f~I'~@;fkJjllj;j.j1.>' :'~:r[:!?2)li~M""':-; 'as:t~Xf ,:;~ ,}@n~l'{~',~ ;i,:'.,:'~!lt~~r~'i;Frifl!t; > i.. < : '1:1tl,mJ]' '.' :..'t3';PJ~I)lt!W.: ;. ~J-4".~l'J'V:llFJ;n)' "1~.'t;li!1'0~iU~~~ill"i,if..;'. CertOfDep. Safekeepa i1!Atnif1J~.J'12l~'~:"!:fiM{.JIT1iI~ m;'[iJ.m~~~:S!;t\Uflii!111_U~11li!1 ,m~;'~P, ib"tffl:.D ',,;..\': 'j:'\'U~I~J ;. ...r"':i, t'::'J! "W~l!.!i1'.!)'F ,'~:' :' :~::lllJlll ..'i. .'". ,t\,>>i\tltJUml)" .' ',:<...'::,\ll!}';JJ!l;!!:il:, 'rc)2 ff~l:~.:;;~:L~.E.. " Cert.OfDep. Safekeepa Certificate ofDep. 1st Bank of Beverly Hills 4/6/2005 4/612008 4.050% S337.50 50.00 $100,000.00 matured 4/6 One Bank & Trost Liquid without early withdrawl penalty 4/612006 Cert.OfDep. Safekeeper Certificate ofDep. Georgia Trost Bank 8/1 012006 8/1012009 0.19% 3.900% $325.00 $0.00 $100,000.00 $100,000.00 One Bank & Trost Cert.OfDep. Safekeeper Certificate ofDep. El Paso FCU 8/1612006 8/1612009 0.19% 3.900% $321. 75 $0.00 599,000,00 $99,000.00 One Bank & Trust Cert.OfDep. Safekeeper Certificate of Dep. Tuscaloosa VA FCU 812112006 812112009 0.19% 3.700% $305.25 $0.00 $99,000.00 $99,000.00 One Bank & Trost Cert.OfDep. Safekeeper Certificate of Dep, Pacific Trost Bank 4/1412005 4/1412010 0.19".4. 4.050% $337.50 $0.00 $100,000.00 $100,000.00 One Bank & Trost Liquid without early withdrawl penalty 4/1412006 Cert.OfDep. Safekeeper Certificate of Dep. Professional Bank 411912005 1011812010 0.19% 3.700% $305.25 $0.00 599,000.00 $99,000.00 One Bank & Trust Y:\Investments\FY 2007-08 Investment Reports\Investment Report - April 20085/13120084:50 PM Page 1 April-OS MONTHLY INVESTMENT REPORT %of Yield Earnings Earnings Interest Purchase Source of Type of Investment Institution Investment Tenn: Portfolio Allowance Accrual Received Price Current Value Current Value Certificate of Dep. Alliance Bank 6/2212.005 6fl2/2010 0.19% 4.250"10 $354.17 $0.00 $100,000.00 $100,000.00 One Bank & Trust Liquid without early withdrawl penalty 612212006 Cert.Of Dep. Safekeeper Certificate of Dep. Telesis Community, CA 7/12/2005 7/12/2010 0.19% 4,000% $330.00 $0.00 $99,000.00 $99,000.00 One Bank & Trust Uquid without early withdrawl penalty 7/12/2006 CertOfDep. Safek:eeper Certificate of Dep. State Bank of India 812312005 812312010 0.19% 4.400% $366.67 $0.00 $100,000.00 $100,000.00 One Bank & Trust Uquid without early withdrawl penalty 8/2312006 Cert.OfDep. Safekeeper Agency Issue Federal Home Loan 613012003 6/3012008 variable $0.00 $0.00 $500,000.00 $501,250.00 Bank of America 31339XP73 Multi-Step Coupon Note step up Safekeeping Report Agency Issue Fannie Mae 8/1512005 8/1512008 4.500% $937.50 $0.00 $500,000.00 5502,968;75 Bank of America 31359MYT4 Global Notes Safekeeping Report Total Agency Issues 1.92% Medium Tenn Note General Elee. Cptl. Unsee< 611912003 6/1512008 0.95% . 2.450% $510.42 $0.00 $500,000.00 $499,1"58:02 Bank of America 36966RFYJ Safekeeping Report Subtotal Cash and Investments availablefor designated reserves and budgeted expenditures: $52,959,779.55 $52,363,156.32 Prior month subtotal Cash and Investments available for desi ated reserves and bud eted ditures: . :_~~.",s..4R.8~MNJ,J.~.. Y:\Investments\FY 2007-08 Investment Reports\Investment Report - ApriI20085/13fl0084:50 PM Page 2 . . . . April-08 Type of Investment Institution Held by TTIl6tee/or 2000 Sewer COP": BNY Western Trust Company Project Account Reserve Account Held by TTIl6tee/or 2000A/or RDA BNY Western Trust Company Reserve Account Held by Trustee/or 2000B lor RDA BNY Western Trust Company Reserve Account Held by Trustee/or Countywide 96 Bonds BNY Western Trust Company Reserve Account Held by TTIl6tee/or Countywide 96 Bonds BNY Western Trust Company Project Account Investment Term: 4/112008 413012008 4/112008 413012008 4/112008 413012008 4/112008 413012008 4/112008 413012008 Earnings Rates and TotBllnvestment Portfolio Value 4/112008 413012008 %of Portfolio . Yield MONTHLY INVESTMENT REPORT 0.48% 1.46% 5.40% 5.40% 1.50% 3.70% Earnings Allowance 0.67% Y:\Investments\FY 2007-08 Investment Reports\Investment Report - April 20085/13120084:50 PM Page 3 Earnings Accrual Interest Received Purchase Price . Current Value Source of Current Value $98,269.01 Fiscal Agent Statement $294,401.26 Fiscal Agent Statement $695,118.79 Fiscal Agent Statement $65,942.11 Fiscal Agent Statement 'i. (1 ':;011 (HJ Fiscal Agent Statement $50,664.41 Fiscal Agent $52,512,089.74 April-08 Yield MONTHLY INVESTMENT REPORT . Type of Invesbnent %of Portfolio Earnings Allowance Institution Invesbnent Term: In compliance with the California Code Section 53646 and Resolution Number 4552; the Treasurer of the City of Seal Beach hereby certifies that sufficient investment liquidity and anticipated revenue are available to meet the City's budgeted expenditure requirements for the next six months. Investments in the report meet the requirements of the City of Seal Beach's adopted invesbnent policy. Respectfully submitted, ~ Ro~ Director of Administrative Serviceslfreasurer NOTED AND APPROVED: ~-- 1 David N. Carmany City Manager Y:\lnvesbnents\FY 2007-08 Invesbnent Reports\Investment Report - April 20085/13/20084:50 PM Page 4 . . Earnings Accrual Interest Received Purchase Price Current Value Source of Current Value .