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