Page 22 - City of Moreno Valley Invstment and Cash Management Program
P. 22

Investment
        REPORTS




        4. TRANSACTIONS


        Sample Transaction Ledger. May 31, 2018 to June 30, 2018.

        Transaction  Settlement  CUSIP  Quantity  Security Description  Price  Acq/Disp  Amount  Interest  Total  Gain/Loss
        Type        Date                                                   Yield          Pur/Sold  Amount
        ACQUISITIONS
        Purchase  06/01/2018  60934N104  1,574.72  Federated Investors Government  1.000  1.60 %  1,574.72  0.00  1,574.72  0.00
                                                 Obligations Fund
        Purchase  06/11/2018  60934N104  9,375.00  Federated Investors Government  1.000  1.60 %  9,375.00  0.00  9,375.00  0.00
                                                 Obligations Fund
        Purchase  06/13/2018  60934N104  1,680,000.00  Federated Investors Government  1.000  1.60 %  1,680,000.00  0.00  1,680,000.00  0.00
                                                 Obligations Fund
        Purchase  06/13/2018  60934N104  5,313.75  Federated Investors Government  1.000  1.60 %  5,313.75  0.00  5,313.75  0.00
                                                 Obligations Fund
        Purchase  06/14/2018  89236TDP7  1,000,000.00  Toyota Motor Credit Corp Note  97.831  3.25 %  978,310.00  11,050.00  989,360.00  0.00
                                                 2.6% Due 1/11/2022
                   SAMPLE
        Purchase  06/15/2018  24422ETG4  280,000.00  John Deere Capital Corp Note  97.219  3.44 %  272,213.20  2,156.00  274,369.20  0.00
                                                 2.8% Due 3/6/2023
        Purchase  06/15/2018  60934N104  4,892.20  Federated Investors Government  1.000  1.60 %  4,892.20  0.00  4,892.20  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  63,997.19  Federated Investors Government  1.000  1.60 %  63,997.19  0.00  63,997.19  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  52,652.39  Federated Investors Government  1.000  1.60 %  52,652.39  0.00  52,652.39  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  45,358.48  Federated Investors Government  1.000  1.60 %  45,358.48  0.00  45,358.48  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  26,672.89  Federated Investors Government  1.000  1.60 %  26,672.89  0.00  26,672.89  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  31,118.34  Federated Investors Government  1.000  1.60 %  31,118.34  0.00  31,118.34  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  609.58  Federated Investors Government  1.000  1.60 %  609.58  0.00  609.58  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  257.83  Federated Investors Government  1.000  1.60 %  257.83  0.00  257.83  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  16,458.18  Federated Investors Government  1.000  1.60 %  16,458.18  0.00  16,458.18  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  29,630.84  Federated Investors Government  1.000  1.60 %  29,630.84  0.00  29,630.84  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  28,865.85  Federated Investors Government  1.000  1.60 %  28,865.85  0.00  28,865.85  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  1,540.00  Federated Investors Government  1.000  1.60 %  1,540.00  0.00  1,540.00  0.00
                                                 Obligations Fund
        Purchase  06/15/2018  60934N104  1,846.25  Federated Investors Government  1.000  1.60 %  1,846.25  0.00  1,846.25  0.00
                                                 Obligations Fund
        Purchase  06/18/2018  60934N104  67,369.96  Federated Investors Government  1.000  1.60 %  67,369.96  0.00  67,369.96  0.00
                                                 Obligations Fund

        5. BALANCES


        Sample Funds with Fiscal Agents.
         Account         Account    Investment      Issuer      Value     Market  Stated   Yield     Price     % of
         Name           Number                                   Date     Value    Rate                       Portfolio
         WELLS FARGO CFD #5
         Series B Revenue  22333500   Cash      Cash           06/30/18   0        0.00%   0.00%    1.00000   0.000%
         Series B Revenue  22333500   Money Mkt Fund  Wf Government Fund  06/30/18   38  1.80%  0.91%  1.00000   0.001%
         Series A Principal  22333501   Money Mkt Fund  Wf Government Fund  06/30/18   2,578  1.80%  0.91%  1.00000   0.050%
         Series A Reserve  22333502   Money Mkt Fund  Wf Government Fund  06/30/18   4  1.80%  0.91%  1.00000   0.000%
         Series B Reserve  22333503   Money Mkt Fund  Wf Government Fund  06/30/18   547,094  1.80%  0.91%  1.00000   10.647%
         Series B Admin Fund  22333504   Money Mkt Fund  Wf Government Fund  06/30/18   1  1.80%  0.91%  1.00000   0.000%
         Series B Interest  22333507   Money Mkt Fund  Wf Govt Fund  06/30/18   231,991  1.80%  1.80%  1.00000  4.515%
                                                                          781,706
         WELLS FARGO Community Facilities Disctrict 87-1 (IA-1)
        22
         Special Tax Funds  22631800   Money Market Fund  WF Government Fund  06/30/18   1,140,530  1.80%  0.91%  1.00000   22.196%
         Interest Acct  22631801   Money Market Fund  WF Government Fund  06/30/18   6,165  1.80%  0.91%  1.00000   0.120%
         Reserve Fund   22631802   Money Market Fund  WF Government Fund  06/30/18   196  1.80%  0.91%  1.00000   0.004%
         Reserve Fund   22631804   Money Market Fund  WF Government Fund  06/30/18   1,030,067  1.80%  0.91%  1.00000   20.046%
         Admin Exp Acct  22631805   Money Market Fund  WF Government Fund  06/30/18   10,485  1.80%  0.91%  1.00000   0.204%
         Debt Service Acct  22631809   Money Market Fund  WF Government Fund  06/30/18   24,859  1.80%  0.91%  1.00000   0.484%
         Debt Service Acct  22631809   Us Treasuty Note  US Treasury  06/30/18   507,731  1.00%  1.00%  1.00000   9.881%
         Special Tax Funds  22631900   Money Market Fund  WF Government Fund  06/30/18   311,466  1.80%  0.91%  1.00000   6.061%
         Interest Acct  22631901   Money Market Fund  WF Government Fund  06/30/18   1,853  1.80%  0.91%  1.00000   0.036%
         Principal Fund  22631902   Money Market Fund  WF Government Fund  06/30/18   43  1.80%  0.91%  1.00000   0.001%
         Reserve Fund   22631904   Money Market Fund  WF Government Fund  06/30/18   366,717  1.80%  0.91%  1.00000   7.137%
         Admin Exp Acct  22631905   Money Market Fund  WF Government Fund  06/30/18   2,143  1.80%  0.91%  1.00000   0.042%
         Surplus Acct   22631907   Money Market Fund  WF Government Fund  06/30/18  4,482  1.80%  0.91%  1.00000   0.087%
         WELLS FARGO 2013 Total Road Improvement COPs                     3,406,737
         Revenue Fund   46612400   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%   1.00000   0.000%
         Interest Fund  46612401   Money Mkt Fund  WF Government Fund  06/30/18   360  1.80%  0.91%  1.00000   0.007%
         Principal Fund  46612402   Money Mkt Fund  WF Government Fund  06/30/18   383  1.80%  0.91%  1.00000   0.007%
         Reserve Fund   46612403   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%   1.00000   0.000%
         Admin Fund     46612404   Money Mkt Fund  WF Government Fund  06/30/18   2,755  1.80%  0.91%  1.00000   0.054%
         Surplus Fund   46612405   Money Mkt Fund  WF Government Fund  06/30/18  0  1.80%  0.91%    1.00000   0.000%
                                                                          3,498
         WELLS FARGO 2013 Partial Refunding of the 2005 Lease Revenue Bonds
         Revenue Fund   48360700   Money Mkt Fund  WF Government Fund  06/30/18   8  1.80%  0.91%   1.00000   0.000%
         Interest Fund  48360701   Money Mkt Fund  WF Government Fund  06/30/18   46  1.80%  0.91%  1.00000   0.001%
         Principal Fund  48360702  Money Mkt Fund  WF Government Fund  06/30/18   188  1.80%  0.91%  1.00000  0.004%
                                                                          242
         WELLS FARGO 2013 Community Facilities District  7 Improvement Area 1
         Special Tax Fund  77025300   Money Mkt Fund  WF Government Fund  06/30/18   328,075  1.80%  0.91%  1.00000   6.385%
         Bond Fund      77025301   Money Mkt Fund  WF Government Fund  06/30/18   262,791  1.80%  0.91%  1.00000   5.114%
         Reserve Fund   77025302   Money Mkt Fund  WF Government Fund  06/30/18   171,156  1.80%  0.91%  1.00000   3.331%
         Admin Exp Acct  77025305  Money Mkt Fund  WF Government Fund  06/30/18   3  1.80%  0.91%   1.00000   0.000%
                                                                          762,025
         WELLS FARGO 2016 Taxable Refunding Lease Revenue Bonds (Electric Utility)
         Revenue Fund   77157100   Money Mkt Fund  WF Government Fund  06/30/18   197  1.80%  0.91%  1.00000   0.004%
         Interest Fund  77157101   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%   1.00000   0.000%
         Principal Fund  77157102   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%  1.00000   0.000%
         Reserve Fund   77157103   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%   1.00000   0.000%
         Capitalized Interest   77157104   Money Mkt Fund  WF Government Fund  06/30/18   181,624  1.80%  0.91%  1.00000   3.535%
         Fund
                                                                          181,821
         WELLS FARGO 2014 Partial Refunding of the 2005 Lease Revenue Bonds
         Revenue Fund   83478300   Money Mkt Fund  WF Government Fund  06/30/18   23  1.80%  0.91%  1.00000   0.000%
         Interest Fund  83478301   Money Mkt Fund  WF Government Fund  06/30/18   142  1.80%  0.91%  1.00000   0.003%
         Principal Fund  83478302   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%  1.00000   0.000%
                                                                          165
         WELLS FARGO 2014 Partial Refunding of the 2005 Lease Revenue Bonds
         Revenue Fund   84457000   Money Mkt Fund  WF Government Fund  06/30/18   2,290  1.80%  0.91%  1.00000   0.045%
         Interest Fund  84457001   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%   1.00000   0.000%
         Principal Fund  84457002  Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%   1.00000   0.000%
         Reserve Fund   84457005   Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%   1.00000   0.000%
         Construction Fund  84457006  Money Mkt Fund  WF Government Fund  06/30/18   0  1.80%  0.91%  1.00000   0.000%
         Construction Fund  84457006  Government Pool  Local Agency   06/30/18   0  0.01%  0.01%    1.00000   0.000%
                                                Investment Fund
                                                                          2,290
                                                Totals                    5,138,484                           100.000%
         Type                                       Issuer                Market
                                                                          Value
         SUMMARY OF BOND PROCEEDS WITH FISCAL AGENTS
         1                                      Construction Funds        689,355
         2                                      Principal & Interest Accounts  1,988,637
         3                                      Debt Service Reserve Funds  2,115,234
         4                                      Custody Accounts          328,144
         5                                      Arbitrage Rebate Accounts  4,482
         6                                      Other Accounts            12,632
                                                Total Fiscal Agent Funds  5,138,484
   17   18   19   20   21   22   23   24   25   26   27