Docstoc

02. IEUA - Financial Affairs as of Mar 2011

Document Sample
02. IEUA - Financial Affairs as of Mar 2011 Powered By Docstoc
					               TREASURER'S REPORT OF FINANCIAL AFFAIRS
                               For the Month Ended March 31, 2011




 All investment transactions have been executed in accordance with the criteria stated in
 the Agency's Investment Policy (Resolution No. 2010-6-10) adopted by the Inland Empire
 Utilities Agency's Board of Directors during its regular meeting held on June 16, 2010.

 The funds anticipated to be available during the next six-month period are expected to be
 sufficient to meet all foreseen expenditures during the period.

* A Municipal Water District
                                        INLAND EMPIRE UTILITIES AGENCY
                                            Cash and Investment Summary
                                                      Month Ended
                                                     March 31, 2011


Cash, Bank Deposits, and                                                   March         February      Variance
   Bank Investment Account                                                $11,189,162    $25,284,853   (14,095,691)

Investments
 Local Agency Investment Fund (LAIF)                                      $38,230,611    $34,230,611     4,000,000
 Certificates of Deposit                                                    5,000,000      5,000,000           -
 State Municipal Bonds                                                      2,040,651      2,043,310        (2,659)
 Medium Term Notes                                                          3,554,120      3,200,541       353,579
 U.S. Government Sponsored Entities                                        15,993,878     14,993,680     1,000,198
Total Investments                                                         $64,819,260    $59,468,142     5,351,118



Total Cash and Investments Available to the Agency                        $76,008,422    $84,752,995    (8,744,573)



Restricted Deposits
 Debt Service Reserves                                                     $4,707,754     $4,742,249       (34,495)
 Construction Repair & Improvement Funds                                   20,504,618     20,501,466         3,152
 CCRA Deposits Held by Member Agencies                                     11,222,731     10,952,835      269,896
 Escrow Deposits                                                            2,314,209      1,835,201      479,008
         Total Restricted Deposits                                        $38,749,312    $38,031,751      717,561




Total Cash, Investments, and Restricted Deposits                      $114,757,735      $122,784,746    (8,027,011)




                                                        Page 2
                                                               INLAND EMPIRE UTILITIES AGENCY
                                                                   Cash and Investment Summary
                                                                           Month Ended
                                                                          March 31, 2011




ubtotal Corporate Medium Term Notes


       Total Cash, Investments, and Restricted Deposits as of 9-30-2000



                                                                             Page 3
                                                        INLAND EMPIRE UTILITIES AGENCY
                                                            Cash and Investment Summary
                                                                          Month Ended
                                                                         March 31, 2011
               6.52%
Total Cash, Investments, and Restricted Deposits as of 9-30-2000
Less: Total Cash, Investments, and Restricted Deposits as of 8-31-2000

 Fed Home Loan 6.57% Bond



                                                                                                     6

                                                                                          #   2,003,347




                                                                            Page 4
INLAND EMPIRE UTILITIES AGENCY
    Cash and Investment Summary
            Month Ended
           March 31, 2011




                 -6.54%




              Page 5
                                            INLAND EMPIRE UTILITIES AGENCY
                                               Cash and Investment Summary
                                                           Month Ended
                                                          March 31, 2011

Cash, Bank Deposits, and
   Bank Investment Account
 Demand (Checking) Accounts
   Citizens Business Bank Demand/Sweep Account                                $7,750,677
   Citizens Business Bank 24-Hour Fitness Membership Account                      22,798
   Workers' Compensation Account                                                  53,270
   Bank of America Payroll Account                                                36,103
   Bank of America Payroll Taxes Account                                          34,184
         Subtotal Demand Deposits                                             $7,897,032

 Other Cash and Bank Accounts
  Petty Cash                                                                     $2,250
        Subtotal Other Cash                                                      $2,250

 Citizens Business Bank Preferred Money Market Account                        $1,141,921

 Wells Fargo Premium Market Rate Savings Account                              $2,001,507

 US Bank Pre-Investment Money Market Account                                   $146,452
                   Total Cash and Bank Accounts                              $11,189,162

Investments
 Local Agency Investment Fund (LAIF)
  LAIF Non-Restricted Fund                                                   $38,230,611
        Subtotal Local Agency Investment Fund                                $38,230,611

 Certificates of Deposit
  Citizens Business Bank                                                      $5,000,000
         Subtotal Certificates of Deposit                                     $5,000,000




                                                               Page 6
                                           INLAND EMPIRE UTILITIES AGENCY
                                              Cash and Investment Summary
                                                        Month Ended
                                                       March 31, 2011

 State Municipal Bonds
   Illinois State Municipal Bonds                                            $2,040,651
          Subtotal State Municipal Bonds                                     $2,040,651

 Medium Term Notes
  Bear Stearns Company                                                       $1,080,107   `
  Bank of America                                                             1,046,866
  Wells Fargo                                                                 1,062,456
  Wells Fargo                                                                   364,691
        Subtotal Medium Term Notes                                           $3,554,120

 U.S. Government Sponsored Entities
   Federal Farm Credit Bonds                                                 $1,000,000
   Freddie Mac Bonds                                                          3,999,000
   Federal Home Loan Bank Bonds                                               3,000,000
   Fannie Mae Bonds                                                           7,994,878
         Subtotal U.S. Government Sponsored Entities                        $15,993,878       $15,993,878


                  Total Investments                                         $64,819,260

Restricted Deposits
 Debt Service Reserves
  05A Debt Service Reserve Accounts                                          $2,188,744
  08A Debt Service Reserve Accounts                                                  36
  08B Debt Service Reserve Accounts                                           2,479,454
  10A Debt Service Reserve Accounts                                              31,143
  US Bank - Other Debt Serv. Accounts                                             8,377
        Subtotal Debt Service Reserves                                       $4,707,754


 Construction Project Accounts
  08A Construction & Improvement Accounts                                   $19,122,468
  08A Construction & Repair Accounts                                          1,382,150
        Subtotal Construction Project Accounts                              $20,504,618


                                                          Page 7
                                        INLAND EMPIRE UTILITIES AGENCY
                                           Cash and Investment Summary
                                                          Month Ended
                                                         March 31, 2011



 CCRA Deposits Held by Member Agencies
  City of Chino                                                             $1,116,808
  Cucamonga Valley Water District                                            2,625,721
  City of Fontana                                                            3,842,516
  City of Montclair                                                            809,329
  City of Ontario                                                            1,123,668
  City of Chino Hills                                                          781,261
  City of Upland                                                               923,428
        Subtotal CCRA Deposits Held by Member Agencies                     $11,222,731


 Escrow Deposits
  Bank of Sacramento (Coonstruction)                                          $158,279
  Union Bank (Taisei-T&K Joint Venture)                                         989,613
  California Business Bank ( Mike Bubalo Inc.)                                   71,137
  City National Bank (SSC Construction Inc.)                                  1,069,700
  Union Bank (Canyon Springs Enterprise)                                         25,480
         Subtotal Escrow Deposits                                            $2,314,209


                   Total Restricted Deposits                               $38,749,312

Total Cash, Investments, and Restricted Deposits as of March 31, 2011     $114,757,735



 Total Cash, Investments, and Restricted Deposits as of 03/31/11          $114,757,735
 Less: Total Cash, Investments, and Restricted Deposits as of 2/28/11      122,784,746
         Total Monthly Increase (Decrease)                                  ($8,027,011)




                                                            Page 8
INLAND EMPIRE UTILITIES AGENCY
   Cash and Investment Summary
           Month Ended
          March 31, 2011




             Page 9
INLAND EMPIRE UTILITIES AGENCY
   Cash and Investment Summary
            Month Ended
           March 31, 2011




        S/B 0
                $0          0




                 Page 10
                                                                        INLAND EMPIRE UTILITIES AGENCY
                                                                            Cash and Investment Detail
                                                                                       Month Ended
                                                                                      March 31, 2011

                                                                   Par           Cost Basis             Term      March         March         %      Maturity   Market
                          Investments                             Amount          Amount               (Days)   Amortization    Value        Yield    Date      Value

Cash, Bank Deposits, and
    Bank Investment Account

Citizens Business Bank
    Demand/Sweep Account                                            $7,750,677     $7,750,677           N/A         N/A         $7,750,677   0.400     N/A       $7,750,677
    Preferred MMA                                                    1,141,921      1,141,921           N/A         N/A          1,141,921   0.200     N/A        1,141,921
                                                 Subtotal CBB       $8,892,598     $8,892,598                                   $8,892,598   0.374               $8,892,598
Citizens Business Bank
    24 Hour Fitness Membership Account                                $22,798         $22,798           N/A         N/A            $22,798   N/A       N/A          $22,798
     Workers' Compensation Account                                     53,270          53,270           N/A         N/A             53,270   N/A       N/A           53,270
                                                 Subtotal CBB         $76,068         $76,068                                      $76,068                          $76,068

Bank of America
   Payroll Checking                                                   $36,103         $36,103           N/A         N/A            $36,103   N/A       N/A          $36,103
   Payroll Tax Checking                                                34,184          34,184           N/A         N/A             34,184   N/A       N/A           34,184
                                                Subtotal B of A       $70,287         $70,287                                      $70,287   N/A                    $70,287

Wells Fargo
  Premium Market Rate Savings Account*                              $2,001,507     $2,001,507           N/A         N/A         $2,001,507   0.450     N/A       $2,001,507
                              Total WF Premium Market               $2,001,507     $2,001,507                                   $2,001,507   0.450               $2,001,507

US Bank
   Federated Automated MMA                                           $146,452       $146,452            N/A         N/A           $146,452   0.010     N/A         $146,452
                                     Total USB Money Market          $146,452       $146,452                                      $146,452   0.010                 $146,452

Petty Cash                                                             $2,250          $2,250           N/A         N/A             $2,250   N/A       N/A           $2,250


Total Cash, Bank Deposits and
  Bank Investment Accounts                                        $11,189,162    $11,189,162                                   $11,189,162                      $11,189,162

Investments
LAIF Accounts
  Non-Restricted Funds                                             $38,230,611   $38,230,611            N/A         N/A        $38,230,611   0.500     N/A      $38,230,611
                                        Subtotal LAIF Accounts     $38,230,611   $38,230,611                                   $38,230,611   0.500              $38,230,611

Certificates of Deposit

 Citizens Business Bank                                             $3,000,000     $3,000,000           365         N/A         $3,000,000   0.750   07/28/11    $3,000,000
 Citizens Business Bank                                              2,000,000      2,000,000           365         N/A          2,000,000   0.600   10/21/11     2,000,000
                               Subtotal Certificate of Deposits     $5,000,000     $5,000,000                                   $5,000,000   0.690               $5,000,000




                                                                                          Page 11
                                                        INLAND EMPIRE UTILITIES AGENCY
                                                            Cash and Investment Detail
                                                                       Month Ended
                                                                      March 31, 2011

                                                   Par           Cost Basis             Term      March          March         %      Maturity   Market
                        Investments               Amount          Amount               (Days)   Amortization     Value        Yield    Date      Value
U.S. Government Sponsored Entities


  Freddie Mac 2.40% Bond                             2,000,000      1,999,000          1,440                      1,999,000   2.390   05/13/13     2,005,040
  Federal Farm Credit 0.97% Bond                     1,000,000      1,000,000          1,080                      1,000,000   0.970   08/19/13       994,890
  Fannie Mae 1.00% Bond                              1,000,000      1,000,000          1,080                      1,000,000   1.000   08/27/13       994,940
  Fannie Mae 1.28% Bond                              1,000,000        999,000          1,075              28        999,077   1.250   12/30/13       996,210
  Freddie Mac Step Up 1.00% Bond                     1,000,000      1,000,000          1,095                      1,000,000   1.000   01/28/14       997,220
  Federal Home Loan Bank 2.157% Step Bond            1,500,000      1,500,000          1,271                      1,500,000   1.000   09/15/14     1,499,865
  Freddie Mac Step Up 1.125% Step Bond               1,000,000      1,000,000          1,460                      1,000,000   1.140   10/29/14       986,870
  Federal Home Loan Bank 2.724% Step Bond            1,500,000      1,500,000          1,800                      1,500,000   2.010   03/24/16     1,495,350
    Subtotal U.S. Gov't Sponsored Entities         $10,000,000     $9,998,000                                    $9,998,077                       $9,970,385

Investment - Sinking Fund

  Fannie Mae 1.94% Bond ($158,943 Unrestricted)     $3,000,000     $2,994,000          1,080            170      $2,995,801   1.870   05/06/13    $3,004,320
  Fannie Mae 3.178% Step Bond                        3,000,000      3,000,000          1,303                      3,000,000   1.990   09/23/14     3,019,770
    Subtotal U.S. Gov't Sponsored Entities          $6,000,000     $5,994,000                                    $5,995,801                       $6,024,090

    Total U.S. Gov't Sponsored Entities            $16,000,000   $15,992,000                            198     $15,993,878   1.640              $15,994,475

State Municipal Bonds

  Illinois State Municipal Bonds 1.3%               $1,000,000     $1,007,880           169           (1,429)    $1,000,691   1.300   04/15/11    $1,000,520
  Illinois State Municipal Bonds 2.55%               1,000,000      1,046,150          1,145          (1,230)     1,039,960   2.550   01/01/14     1,005,670
     Total State Municipal Bonds                    $2,000,000     $2,054,030                         (2,659)    $2,040,651   1.925               $2,006,190

Medium Term Notes

  Bear Stearns Company 1.0%                         $1,000,000     $1,105,040           643           (4,957)    $1,080,107   1.000   08/10/12    $1,076,600
  Bank Of America 2.069%                             1,000,000      1,053,940           716           (2,741)     1,046,866   2.069   09/11/12     1,052,970
  Wells Fargo Company 1.199%                         1,000,000      1,079,380           716           (3,385)     1,062,456   1.199   10/23/12     1,060,020
  Arden Realty/General Electric 3.259%                 340,000        364,691          1,410                        364,691   3.259   03/01/15       364,912
    Total Medium Term Notes                         $3,340,000     $3,603,051                        (11,083)    $3,554,120   1.610               $3,554,502

Total Investments                                 $64,570,611    $64,879,692                                    $64,819,260                      $64,785,778
Source of Investment Market Value: US Bank




                                                                          Page 12
                                                          INLAND EMPIRE UTILITIES AGENCY
                                                              Cash and Investment Detail
                                                                         Month Ended
                                                                        March 31, 2011

                                                     Par           Cost Basis             Term      March         March          %      Maturity   Market
                       Investments                  Amount          Amount               (Days)   Amortization    Value         Yield    Date      Value
Restricted Deposits
Debt Service Reserves and Arbitrage Accounts

05A Debt Service Reserve Accts
  US Bank Debt Serv. Accounts                         $2,188,744     $2,188,744           N/A         N/A         $2,188,744    1.080     N/A       $2,188,744
    Subtotal '05A Debt Service Accts                  $2,188,744     $2,188,744                                   $2,188,744    1.080               $2,188,744

08A Debt Service Reserve Accounts
  US Bank Payment Fund                                       $36            $36           N/A         N/A                 $36   0.000                       $36
    Subtotal '08A Debt Service Accts                         $36            $36                                           $36   0.000                       $36

08B Debt Service Reserve Accounts
  US Bank Debt Serv. Accounts                         $2,479,454     $2,479,454           N/A         N/A         $2,479,454    1.020     N/A       $2,479,454
    Subtotal '08B Debt Service Accts                  $2,479,454     $2,479,454                                   $2,479,454    1.020               $2,479,454

10A Debt Service Reserve Accounts
  US Bank Debt Serv. Accounts                            $31,143        $31,143           N/A         N/A            $31,143    0.150     N/A          $31,143
    Subtotal '10A Debt Service Accts                     $31,143        $31,143                                      $31,143    0.150                  $31,143

Other US Bank Debt Service Accts               791+66+7517
  IMMA ( Money Market)                                    $8,377         $8,377           N/A         N/A             $8,377    0.100     N/A           $8,377
    Subtotal USB Other Accts                              $8,377         $8,377                                       $8,377    0.100                   $8,377
Total Debt Service Reserves                          $4,707,754     $4,707,754                                    $4,707,754                        $4,707,754

08A Construction Project Accounts
  CAMP Construction & Improvement                    $19,119,528   $19,119,528            N/A         N/A        $19,119,528    0.180              $19,119,528
  CAMP Dividend                                            2,940         2,940            N/A         N/A              2,940                             2,940
    Subtotal Construction & Improvement              $19,122,468   $19,122,468                                   $19,122,468    0.180              $19,122,468

  CAMP Construction & Repair                          $1,381,938     $1,381,938           N/A         N/A         $1,381,938    0.180               $1,381,938
  CAMP Dividend                                              212            212           N/A         N/A                212                               212
    Subtotal Construction & Repair                    $1,382,150     $1,382,150                                   $1,382,150    0.180               $1,382,150
Total 2008A Construction Project Accts              $20,504,618    $20,504,618                                   $20,504,618    0.180              $20,504,618




                                                                            Page 13
                                                                 INLAND EMPIRE UTILITIES AGENCY
                                                                     Cash and Investment Detail
                                                                                 Month Ended
                                                                                March 31, 2011

                                                           Par             Cost Basis             Term      March          March          %      Maturity     Market
                       Investments                        Amount            Amount               (Days)   Amortization     Value         Yield    Date        Value

CCRA Deposits Held by Member Agencies                                                             N/A         N/A                        N/A       N/A
  City of Chino                                              $1,116,808      $1,116,808                                     $1,116,808                         $1,116,808
  Cucamonga Valley Water District                             2,625,721       2,625,721                                      2,625,721                          2,625,721
  City of Fontana                                             3,842,516       3,842,516                                      3,842,516                          3,842,516
  City of Montclair                                             809,329         809,329                                        809,329                            809,329
  City of Ontario                                             1,123,668       1,123,668                                      1,123,668                          1,123,668
  City of Chino Hills                                           781,261         781,261                                        781,261                            781,261
  City of Upland                                                923,428         923,428                                        923,428                            923,428
Total CCRA Deposits Held by Member Agencies*                $11,222,731     $11,222,731                                    $11,222,731                        $11,222,731
Totals through 3/31/2011 with 6 of 7 agencies reporting
Escrow Deposits                                                                                   N/A         N/A                        N/A       N/A
 Coonstruction Inc.                                           $158,279        $158,279                                       $158,279                           $158,279
 Taisei - T&K Joint Venture                                     989,613         989,613                                        989,613                            989,613
 Mike Bubalo Construction Inc.                                   71,137          71,137                                         71,137                             71,137
 SSC Construction                                             1,069,700       1,069,700                                      1,069,700                          1,069,700
 Canyon Springs Enterprise                                       25,480          25,480                                         25,480                             25,480
    Subtotal Escrow Deposits                                 $2,314,209      $2,314,209                                     $2,314,209                         $2,314,209

Total Restricted Deposits                                  $38,749,312     $38,749,312                                    $38,749,312                        $38,749,312

Total Cash, Investments, and Restricted Deposits as of
March 31, 2011                                            $114,509,086    $114,818,167                                   $114,757,735                       $114,724,253




                                                                                    Page 14
                   INLAND EMPIRE UTILITIES AGENCY
                       Cash and Investment Detail
                                Month Ended
                               March 31, 2011

               Par        Cost Basis             Term      March        March    %      Maturity   Market
Investments   Amount       Amount               (Days)   Amortization   Value   Yield    Date      Value




                                   Page 15
INLAND EMPIRE UTILITIES AGENCY
    Cash and Investment Detail
           Month Ended
          March 31, 2011
          UPDATE M3 FOR CALCULATION
          ON MATURITY DISTRIBUTION
             3/31/2011




          0 - 30 days




                        118
                        201




              Page 16
INLAND EMPIRE UTILITIES AGENCY
    Cash and Investment Detail
           Month Ended
          March 31, 2011
          UPDATE M3 FOR CALCULATION
          ON MATURITY DISTRIBUTION
             3/31/2011



                    763
                    859
                    867
                    990
                   1018
                   1245
                   1289
                   1794




                    756
                   1253




                        15
                       991




                    490
                    521
                    563
                   1411




             Page 17
INLAND EMPIRE UTILITIES AGENCY
    Cash and Investment Detail
           Month Ended
          March 31, 2011
          UPDATE M3 FOR CALCULATION
          ON MATURITY DISTRIBUTION
             3/31/2011




             Page 18
INLAND EMPIRE UTILITIES AGENCY
    Cash and Investment Detail
           Month Ended
          March 31, 2011
          UPDATE M3 FOR CALCULATION
          ON MATURITY DISTRIBUTION
             3/31/2011




             Page 19
INLAND EMPIRE UTILITIES AGENCY
    Cash and Investment Detail
           Month Ended
          March 31, 2011
          UPDATE M3 FOR CALCULATION
          ON MATURITY DISTRIBUTION
             3/31/2011




             Page 20
            INLAND EMPIRE UTILITIES AGENCY
                Cash and Investment Detail
                             Month Ended
                            March 31, 2011
UPDATE M3 FOR CALCULATION
ON MATURITY DISTRIBUTION




                                         w/laif
                                    0     0.0000%   0
                 14.2857%          17     5.0649%   6
                  9.5238%          19     3.3766%   7




                               Page 21
            INLAND EMPIRE UTILITIES AGENCY
                Cash and Investment Detail
                             Month Ended
                            March 31, 2011
UPDATE M3 FOR CALCULATION
ON MATURITY DISTRIBUTION




                              #REF!          #REF!




                               Page 22
            INLAND EMPIRE UTILITIES AGENCY
                Cash and Investment Detail
                             Month Ended
                            March 31, 2011
UPDATE M3 FOR CALCULATION
ON MATURITY DISTRIBUTION




                                4.49%




                               Page 23
            INLAND EMPIRE UTILITIES AGENCY
                Cash and Investment Detail
                             Month Ended
                            March 31, 2011
UPDATE M3 FOR CALCULATION
ON MATURITY DISTRIBUTION




                               Page 24
            INLAND EMPIRE UTILITIES AGENCY
                Cash and Investment Detail
                             Month Ended
                            March 31, 2011
UPDATE M3 FOR CALCULATION
ON MATURITY DISTRIBUTION




                               Page 25
                                              INLAND EMPIRE UTILITIES AGENCY
                                                    Investment Activities
                                                                 Month Ended
                                                                March 31, 2011




March Purchases
                                                                                   Par Amount     Investment
No.   Date         Transaction                Investment Security                   Purchased        Yield
1 03/15/11          Purchase Federal Home Loan Bank Bond (Step Up)               $    1,500,000     2.157%
2 03/24/11          Purchase Federal Home Loan Bank Bond (Step Up)                    1,500,000     1.968%
3 03/31/11          Purchase General Electric Medium Term Note                          340,000     3.259%


                               Total March Purchases                             $   3,340,000




March Investment Maturities, Calls & Sales
                                                                                   Par Amount     Investment
No.       Date     Transaction                Investment Security                 Matured/Sold       Yield
1     03/08/11       Full Call Freddie Mac Bond                                  $    2,000,000     1.870%




                               Total March Maturities, Calls & Sales             $   2,000,000




                                                                    Page 26
     INLAND EMPIRE UTILITIES AGENCY
           Investment Activities
                Month Ended
               March 31, 2011




##



                  Page 27
INLAND EMPIRE UTILITIES AGENCY
      Investment Activities
           Month Ended
          March 31, 2011




                                 149




             Page 28
INLAND EMPIRE UTILITIES AGENCY
      Investment Activities
           Month Ended
          March 31, 2011




             Page 29
INLAND EMPIRE UTILITIES AGENCY
      Investment Activities
           Month Ended
          March 31, 2011




             Page 30
INLAND EMPIRE UTILITIES AGENCY
      Investment Activities
           Month Ended
          March 31, 2011




              2E+06




             Page 31
                                                      INLAND EMPIRE UTILITIES AGENCY
                                                         Cash and Investment Summary
                                                                 Month Ended
                                                                March 31, 2011




Directed Investment Category                                                 Amount Invested     Yield
Investment in the Local Agency Investment Fund                                    $38,230,611   0.500%    50.5%
Investments in Certificates of Deposit                                              5,000,000   0.690%     6.6%
Medium Term Notes                                                                   3,554,120   1.610%     4.7%
State Municipal Bonds                                                               2,040,651   1.925%     2.7%
U.S. Government Sponsored Entities                                                 15,993,878   1.640%    21.1%
                                                                                 $64,819,260    0.902%
  Bank Investment Accounts
Citizens Business Bank - Demand/Sweep Account                                      $7,750,677   0.400%
Citizens Business Bank - Preferred Money Market Account                             1,141,921   0.200%
Premium Market Rate Savings Account                                                 2,001,507   0.450%
                                                                                  $10,894,105   0.388%    14.4%

    Total Portfolio                                                               $75,713,365            100.0%
        Investment Portfolio Rate of Return                                                     0.828%

Restricted/Transitory/Other Demand Accounts                                  Amount Invested     Yield
US Bank - 2005A Debt Service Account                                              $2,188,744    1.080%
US Bank - 2008A Debt Service Accounts                                                      36   0.000%
US Bank - 2008B Debt Service Accounts                                               2,479,454   1.020%
US Bank - 2010A Debt Service Accounts                                                  31,143   0.150%
US Bank - 2008A Construction & Improvement Project Accounts                       20,504,618    0.180%
CCRA Deposits Held by Member Agencies                                             11,222,731      N/A
Citizens Business Bank - 24 Hour Fitness Membership Account                            22,798     N/A
Citizens Business Bank - Workers' Compensation Account                                 53,270     N/A
US Bank - Pre-Investment Money Market Account                                         146,452   0.010%
Other Accounts**                                                                       72,537     N/A
    Total Other Accounts                                                          $36,730,160
       Average Yield of Other Accounts                                                          0.506%

Total Agency Directed Deposits                                                   $112,443,526



                                                                   Page 32
                                                    INLAND EMPIRE UTILITIES AGENCY
                                                       Cash and Investment Summary
                                                                        Month Ended
                                                                       March 31, 2011

*Note: As of 3/31/2010 the CBB Demand/Sweep and Preferred Money Market
accounts have been re-classified to the "Directed Investment Category".
** Note: Bank of America Payroll Deposits used as compensating balances for bank
services.


Total Deposits                                                                          $112,443,526
Check                                                                                   $112,443,526
                                                                                                 $0

Total Deposits                                                                          $112,443,526

Add: Escrow Total                                                                          2,314,209
Total Deposits                                                                          $114,757,735
Less: Total Cash, Investments and Deposits                                               114,757,735
Check                                                                                             $0




                                                                           Page 33
                                                           INLAND EMPIRE UTILITIES AGENCY
                                                              Cash and Investment Summary
                                                                          Month Ended
                                                                         March 31, 2011




                         Subtotal Corporate Medium Term Notes


Total Cash, Investments, and Restricted Deposits as of 9-30-2000


Total Cash, Investments, and Restricted Deposits as of 9-30-2000             6.52%
Less: Total Cash, Investments, and Restricted Deposits as of 8-31-2000                      149

 Fed Home Loan 6.57% Bond




                                                                            Page 34
INLAND EMPIRE UTILITIES AGENCY
   Cash and Investment Summary
           Month Ended
          March 31, 2011




             Page 35
INLAND EMPIRE UTILITIES AGENCY
   Cash and Investment Summary
                     Month Ended
                    March 31, 2011




                                                                          IEUA
                                                           FY 10/11 - FY 11/12 Investment Policy


                   Investment Type

US Treasury Notes, Bonds, Bills or Certificates
Federal or US Gov't obligations, participations or other
instruments
State Municipal Securities (Any)
California Local Agency Municipal Securities
Commercial Paper (No more than 10%/issuer)
Commercial Paper (No more than 10%/issuer)

Repurchase Agmt
Med. Deposits, Certificates of Deposit, Placement
Time Term Notes
Service Certificates
USB/MMA invested solely in US Securities
Bank Deposits (Demand, Savings, Market Rate)
CalTrust or Local Govt Investment Pool
LAIF

     In selecting the financial institutions for the deposit or investment of funds, the consideration shall inc
  equity/asset ratio data and continue to monitor the financial institutions' credit characteristics and financia
during which funds are deposited or invested. The minimum qualifications for approved depository/financia
 must be at least three (3) years old; have total assets in excess of ten (10) billion dollars; a core capital/as
          have total assets in excess of five hundred million dollars ($500,000,000); and a core capital/ass




                        Page 36
INLAND EMPIRE UTILITIES AGENCY
   Cash and Investment Summary
           Month Ended
          March 31, 2011




             Page 37
INLAND EMPIRE UTILITIES AGENCY
   Cash and Investment Summary
           Month Ended
          March 31, 2011




             Page 38
                                                              INLAND EMPIRE UTILITIES AGENCY
                                                                 Cash and Investment Summary
                                                                              Month Ended
                                                                             March 31, 2011




                                                                      IEUA
                                                        FY 10/11 - FY 11/12 Investment Policy
                                                                                            Max             Current
                                                    Min. Rating       Max Length      Portfolio Amount Portfolio Amount

                                                       None             None                 None

                                                       None             None                 None            18.5%
                                                        A               None                 10%             2.5%
                                                         A              None                 None
                                                         A             270 Days              20%
                                                        A-1            270 Days              20%

                                                         A             90 days               40%
                                                         A             5 Years               10%             3.9%
                                                       None
                                                 Highest avail by 2    5 Years              20%              6.1%
                                                  rating agencies       None                20%
                                                       None             None                None            32.80%
                                                   CGC 53601 (p)        None           $20 million/acct
                                                       None             None             $50 Million      $29.2 M/36%

     In selecting the financial institutions for the deposit or investment of funds, the consideration shall include the depository’s latest
  equity/asset ratio data and continue to monitor the financial institutions' credit characteristics and financial history throughout the period
during which funds are deposited or invested. The minimum qualifications for approved depository/financial institutions include: (i) that they
 must be at least three (3) years old; have total assets in excess of ten (10) billion dollars; a core capital/asset ratio of 5% or better; or (ii)
          have total assets in excess of five hundred million dollars ($500,000,000); and a core capital/asset ratio of 6% or better.




                                                                                   Page 39
 INLAND EMPIRE UTILITIES AGENCY
    Cash and Investment Summary
            Month Ended
           March 31, 2011




2003347




              Page 40
INLAND EMPIRE UTILITIES AGENCY
   Cash and Investment Summary
           Month Ended
          March 31, 2011




             Page 41
                                                                 INLAND EMPIRE UTILITIES AGENCY
                                                                    Cash and Investment Summary
                                                                                    Month Ended
                                                                                   March 31, 2011




                          IEUA
           FY 10/11 - FY 11/12 Investment Policy


                                                                                 Collateral Required

                                                                           Full faith and credit of US

                                                                           Full faith and credit of US



                                                                           $500 Million in Assets
                                                                           LOC or Surety Bond
                                                                           US obligations min of 102% of
                                                                           the value of the repo + value of
                                                                           US corps operating in US
                                                                           Full amt by FDIC
                                                                           SEC registered with assets over
                                                                           $500 M
                                                                           FDIC + US Gov Sec or Prom.
                                                                           Must have an investment
                                                                           Oversight by the PMIB

or the deposit or investment of funds, the consideration shall include the depository’s latest
onitor the financial institutions' credit characteristics and financial history throughout the period
ed. The minimum qualifications for approved depository/financial institutions include: (i) that they
 total assets in excess of ten (10) billion dollars; a core capital/asset ratio of 5% or better; or (ii)
e hundred million dollars ($500,000,000); and a core capital/asset ratio of 6% or better.




                                                                                       Page 42
             Inland Empire Utilities Agency
             Treasurer's Report of Financial Affairs
                   For the Month Ended March 31, 2011
                        Combined Agency Portfolio
                            $112,443,526


                                          Medium Term Notes
            LAIF                                3%
            34%
                                                     Bank Investments
                                                           10%

                                                              Certificates of Deposit
                                                                        4%


                                                         U.S. Government
                                                        Sponsored Entities
                                                               14%
Restricted/Transitory/
   Other Accounts
         33%                                State Municipal Bonds
                                                     2%




                                Page 43
                    Inland Empire Utilities Agency
                    Treasurer's Report of Financial Affairs
                         For the Month Ended March 31, 2011
                    U.S. Government Sponsored Entities Portfolio
                                 $15,993,878
         Federal Home Loan
            Bank Bonds                               Federal Farm Credit
                19%                                         Bond
                                                             6%




Freddie Mac Bonds
      25%                                              Fannie Mae Bonds
                                                             50%




                                  Page 44
                  Inland Empire Utilities Agency
                  Treasurer's Report of Financial Affairs
                  For the Month Ended March 31, 2011
                     Unrestricted Agency Investment Portfolio
                                 $75,713,365


                                                             Local Agency
 State Municipal Bonds                                     Investment Fund
          3%                                                     50%


 U.S. Government
Sponsored Entities
       21%



    Certificates of Deposit
                                                      Medium Term Notes
              7%
                              Bank Investments              5%
                                    14%




                                   Page 45
                                         Inland Empire Utilities Agency
                                      Treasurer's Report of Financial Affairs
                                             For the Month Ended March 31, 2011
                                      Directed Investment Portfolio Maturity Distribution
                                                         $75,713,365



          $50,000,000

          $45,000,000

          $40,000,000

          $35,000,000

          $30,000,000

          $25,000,000

          $20,000,000

          $15,000,000

          $10,000,000

           $5,000,000

                  $0
                         0-30 Days    31-90 Days     91-180 Days     181-365 Days     366-730 Days   Over 2 Yrs
LAIF + CalTrust         $38,230,611
Bank Invest             $10,894,105
GSE+CD+MTN+MUNI             $0        $1,000,691      $3,000,000      $2,000,000       $3,189,429    17,398,529
Percent                   64.89%        1.32%           3.96%           2.64%               4.21%     22.98%




                                                         Page 46
                                                      Inland Empire Utilities Agency
                                                Treasurer's Report of Financial Affairs
                                                         For the Month Ended March 31, 2011
                                                               Agency Yield Comparison



1.500%



          1.186%     1.191%
                                 1.145%
                                             1.099%       1.086%

                                                                         0.987%
                                                                                      0.948%          0.929%
1.000%                                                                                                         0.907%
                                                                                                                                 0.848%                          0.828%
                                                                                                                                          0.813%      0.793%




0.500%             0.588%
         0.547%                0.560%      0.528%                  0.513%                                                                 0.538%
                                                      0.531%                                                                                          0.512%
                                                                                  0.500%
                                                                                                   0.480%                                                        0.500%
                                                                                                                0.454%           0.462%


                      0.160%      0.160%                0.150%         0.150%      0.150%           0.130%
         0.140%                                                                                                 0.130%           0.130%      0.150%     0.130%
                                            0.120%                                                                                                                0.090%

0.000%



                                                        Agency Yield                  LAIF Yield                 90-Day T-Bill




                                                                                Page 47
 149      2003347




Page 48
          0.15




          1.02
          1.02
          0.15



          0.15




Page 49
          1.02
          1.02
          0.15


          1.02
          1.02
          0.15




Page 50
                                                                                               INLAND EMPIRE UTILITIES AGENCY
                                                                                                                   Transaction Report




   DO NOT INCLUDE THIS PAGE IN BOARD PACKAGE
                                                       Graph Data Sheet

          Agency Composition(net of escrow accts)                                                                      Portfolio Maturity

   Restricted/Transitory/Other Accounts         $36,730,160                 Maturity                                   Percent              GSE+CD+MTN+MUNI Bank Invest   LAIF + CalTrust
   LAIF                                         $38,230,611                 0-30 Days                                              64.89%                  $0 $10,894,105   $38,230,611
   Medium Term Notes                             $3,554,120                 31-90 Days                                              1.32%          $1,000,691
   Bank Investments                              10,894,105                 91-180 Days                                             3.96%          $3,000,000
   Certificates of Deposit                       $5,000,000                 181-365 Days                                            2.64%          $2,000,000
   Premium Market Rate Savings Account                                      366-730 Days                                            4.21%          $3,189,429
   U.S. Government Sponsored Entities            15,993,878                 Over 2 Yrs                                             22.98%          17,398,529                               Includes FIGIC Investements
   State Municipal Bonds                         $2,040,651                 Various Period                                          0.00%                  $0
   Total                                       $112,443,526                 Total                                                    100%          26,588,649  10,894,105    75,713,365
                                                                                                                                     100%
                                                                                        $0 Check figure s/b 0.00
                                                                                                                                            These figures should be adjusted monthly
                                32.67%    Restricted/Transitory/Other Accounts
                                34.00%    LAIF
                                 9.69%    Bank Investments
                                 3.16%    Medium Term Notes
                                 4.45%    Certificates of Deposit                                                                                                                              0.480000
                                 0.00%    Premium Market Rate Savings Account
                                14.22%    U.S. Government Sponsored Entities
                                 1.81%    State Municipal Bonds
                              100.000%

                                                                                                                                                     Portfolio Composition
                                                                                                                                                                    $38,230,611
                                                                                                                                            Local Agency Investment Fund
US Government Sponsored Entities Portfolio                                                                                                  Medium Term Notes         $3,554,120
   Fannie Mae Bonds                                7,994,878      49.99%                                                                    Bank Investments          10,894,105
   Freddie Mac Bonds                               3,999,000      25.00%                                                                    Certificates of Deposit     5,000,000
   Federal Home Loan Bank Bonds                    3,000,000      18.76%                                                                    High Yield Savings
   Federal Farm Credit Bond                        1,000,000       6.25%                                                                                              15,993,878
                                                                                                                                            U.S. Government Sponsored Entities
   Freddie Mac Discount Notes                                      0.00%                                                                    State Municipal Bonds       2,040,651
   Total                                         15,993,878      100.00%                                                                    Total                   $75,713,365

                                                                                                                                                             50.49%   LAIF
                                                                                                                                                              4.69%   MTN
                                          Check fig s/b -0-                             $0                                                                   14.39%   Bank Investments
                                                                                                                                                              6.60%   CD's
                                                                                                                                                             21.12%   US Govt Bonds
                                                                                                                                                              2.70%   State Muni Bonds
        Investment Portfolio Yield                                                                                                                         100.00%
                                             Agency Yield      LAIF Yield    90-Day T-Bill                                                  Check fig s/b -0-                  $0
                              1/31/2007        4.984%           5.156%         5.093%
                              2/28/2007        4.974%           5.181%         5.152%
                              3/31/2007        4.967%           5.214%         5.062%
                              4/30/2007        4.900%           5.222%         4.987%
                             10/31/2007        5.145%           5.137%         3.990%
                             11/30/2007        4.770%           4.962%         3.500%
                             12/31/2007        4.929%           4.801%         3.050%
                              7/31/2009        1.487%           1.035%         0.180%
                              8/31/2009        1.294%           0.925%         0.170%
                              9/30/2009        1.260%           0.750%         0.120%
                             10/31/2009        1.339%           0.646%         0.070%
                             11/30/2009        1.513%           0.611%         0.040%
                             12/31/2009        1.502%           0.569%         0.040%
                              1/31/2010        1.473%           0.558%         0.060%
                              2/28/2010        1.479%           0.577%         0.140%
                              3/31/2010        1.186%           0.547%         0.140%
                              4/30/2010        1.191%           0.588%         0.160%
                              5/31/2010        1.145%           0.560%         0.160%
                              6/30/2010        1.099%           0.528%         0.120%
                              7/31/2010        1.086%           0.531%         0.150%
                              8/31/2010        0.987%           0.513%         0.150%
                              9/30/2010        0.948%           0.500%         0.150%
                             10/31/2010        0.929%           0.480%         0.130%
                             11/30/2010        0.907%           0.454%         0.130%
                             12/31/2010        0.848%           0.462%         0.130%
                              1/31/2011        0.813%           0.538%         0.150%
                              2/28/2011        0.793%           0.512%         0.130%
                              3/31/2011        0.828%           0.500%         0.090%




                C:\Docstoc\Working\pdf\054c3f2c-7ae9-42bd-b3cb-757ed17c9d24.xlsx

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:5/15/2012
language:English
pages:51