Loading...
HomeMy WebLinkAbout0002_2_Investment Report 12 2016 thru 11 2017BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 3,639,953$ 416,250$ (958,946)$ 3,097,256$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 3,639,953 416,250 (958,946) 3,098,556 INVESTMENTS City Investments: City Local Agency Investment Fund 10,519,815 - 10,519,815 City Local Agency Investment Fund for the PFA 330,938 - - 330,938 City CAMP Investments: CAMP Pool Account 28,055 - - 28,055 U.S. Treasury Bond / Note 10,415,403 - - 10,415,403 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 530,253 - - 530,253 Federal Agency Bond / Note 8,285,516 - - 8,285,516 Corporate Note 6,410,361 - - 6,410,361 Certificate of Deposit 4,074,552 - - 4,074,552 Housing CAMP Investments: Housing CAMP Pool Account 10,606 - - 10,606 Housing U.S. Treasury Bond / Notes 1,655,896 - - 1,655,896 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 95,951 - - 95,951 Housing Federal Agency Bond / Notes 1,585,941 - - 1,585,941 Housing Corporate Notes 1,318,456 - - 1,318,456 Housing Certificate of Deposit 400,000 - - 400,000 Successor Investments: Successor Local Agency Investment Fund 3,996,855 - - 3,996,855 Successor CAMP Investments: Successor CAMP Pool Account 19,594 - - 19,594 Successor U.S. Treasury Bond / Notes 1,755,118 - - 1,755,118 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 95,951 - - 95,951 Successor Federal Agency Bond / Notes 1,881,365 - - 1,881,365 Successor Corporate Notes 1,120,612 - - 1,120,612 Successor Certificate of Deposit 400,000 - - 400,000 Sub-total Investments 55,281,869 - - 55,281,869 Market Value Adjustment: Unrealized Gain/ (Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/ (Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/ (Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 55,794,271 - - 55,794,271 Total Pooled Cash and Investments 59,434,224$ 416,250$ (958,946)$ 58,892,827$ TOTAL POOLED CASH AND INVESTMENTS 58,892,827$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 16, 2016. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson January 11, 2017 Director of Administrative Services Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF DECEMBER 31, 2016 FUND NO FUND NAME AMOUNT 100 General Fund 10,697,005$ 101 Supplemental Law Enforcement Fund 70,990 104 Traffic Offender Fund 14,217 106 Affordable Housing In Lieu Fund 1,019,944 107 Developer Agreement Revenue 1,250,962 110 State Gas Tax Fund 1,533,483 111 TUMF C.I.P. Fund 2,706 112 Measure A Fund 1,206,701 114 SB1186 CASP Education Program Fund 6,521 115 Traffic Safety Fund 150,004 116 City Hall-Public Works DIF Fund 1,273,325 117 Community Center DIF Fund 567,768 118 Lake Side Facility DIF Fund 705,420 119 Animal Shelter DIF Fund 45,450 121 T.R.I.P.-2014A 128 135 Lighting & Landscape Maintenance Fund - Dist. No. 1 407,174 140 Geothermal Fund 20,032 150 C.D.B.G. Fund 6,333 155 CSA152 -- N.P.D.E.S.39,388 160 PEG Grant Fund 33,490 205 Traffic Impact Fee Fund 3,919,087 211 Storm Drain C.I.P. Fund 2,409,837 221 Quimby Park C.I.P. Fund 16,787 231 Library C.I.P. Fund 1,741,805 232 City Fire Protection Fund 72,352 254 AD 89-1 Railroad Canyon Rd. Improvement Fund 126,253 268 CFD 2006-2 Viscaya Improvement 221 300 Insurance Service 928,134 320 Facilities Service 528,677 332 CFD 2006-1 Improvement Area B, Summerly 6,668 334 CFD 2015-5 Trieste - Far West Industries 18,922 336 CFD 2006-1FF Summerly Improvement Area FF 17,006 337 CFD 2016-2 Canyon Hills 9,484 345 CFD 2003-2S Improvement Area D, Canyon Hills 3,028 346 CFD 2014-1 Southshore Debt Service Fund 63,494 347 CFD 2006-1 Improvement Area A, Summerly 11,055 350 CFD 98-1 Summerhill Debt Service Fund 31,978 352 AD 86-1 Debt Service Fund 659,115 354 CFD 90-2 Successor RDA Debt Service Fund 250,448 357 CFD 2003-2 Canyon Hills Debt Service Fund 44,080 366 CFD 2005-6 City Center Townhomes Debt Service Fund 33,013 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF DECEMBER 31, 2016 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF DECEMBER 31, 2016 368 CFD 2006-2 Viscaya Debt Service Fund 61,261 369 CFD 2004-3 Area 1 Rosetta Canyon Debt Service Fund 37,511 371 CFD 2005-1 Serenity Debt Service Fund 19,425 372 CFD 2005-2 Alberhill Ranch Debt Service Fund 14,282 374 CFD 2005-4 Lakeview Villas Debt Service Fund 44,752 375 CFD 2006-4 Tract No. 30698 & 32129 Debt Service Fund 15,760 376 CFD 2006-3 La Strada Debt Service Fund 19,579 377 CFD 2006-6 Tessara Debt Service Fund 8,899 378 CFD 2006-8 Tract No. 31957 Debt Service Fund 45,821 384 CFD 2003-2 Area B Canyon Hills Debt Service Fund 28,380 385 CFD 2004-3 Area 2 Rosetta Canyon Debt Service Fund 45,101 386 CFD 2007-4 Mekenna Debt Service Fund 5,238 387 CFD 2007-5 Red Kite Debt Service Fund 63,072 388 CFD 2007-6 Holiday Inn Debt Service Fund 3,764 389 CFD 88-3 (2008A) West Lake Elsinore Debt Service Fund 25,368 390 CFD 2003-2 Area C Canyon Hills Debt Service Fund 30,516 392 CFD 95-1 City Center Debt Service Fund 20,412 393 AD 93-1 Debt Service Fund 23,524 394 CFD 2005-5 (2012A) Wasson Canyon Debt Service Fund 25,050 520 Successor Agency RDA Area II 2,011,817 530 Successor Agency RDA Area III 1,031,351 540 Successor Area RDA Diamond Stadium 2,611,589 604 Endowment Trust Fund 31,388 605 Public Improvement Trust Fund 866,721 606 Mobile Source Air Polution Reduction Fund 258,674 608 Trust Deposit & Pre Paid Expense Fund 5,846,622 617 Successor Agency Housing Fund 12,144,468 620 Cost Recovery System Fund 2,892,439 631 Lake Destratification Equipment Replacement Fund 214,069 731 LEPFA 2011 Series B 2 734 LEPFA 2013 Series C 409,888 736 LEPFA 2013 Series A 20 780 LEPFA General 93,578 Total Pooled Cash & Investments 58,892,827$ Yield Purchase Date Maturity Rate 0.719%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 13,619,815$ (3,100,000)$ 10,519,815$ City for the PFA 330,938$ -$ 330,938$ Successor Agency 3,996,855$ -$ 3,996,855$ Total Investments Held with Local Agency Investment Fund:17,947,607$ (3,100,000)$ 14,847,607$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING DECEMBER 31, 2016 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 2,965,408$ 413,698$ (1,313,526)$ 2,065,580$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 2,965,408 413,698 (1,313,526) 2,066,880 INVESTMENTS City Investments: City Local Agency Investment Fund 22,542,326 - 22,542,326 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 56,643 - - 56,643 U.S. Treasury Bond / Note 10,433,804 - - 10,433,804 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 527,901 - - 527,901 Federal Agency Bond / Note 7,683,131 - - 7,683,131 Corporate Note 6,397,224 - - 6,397,224 Certificate of Deposit 4,674,552 - - 4,674,552 Housing CAMP Investments: Housing CAMP Pool Account 14,513 - - 14,513 Housing U.S. Treasury Bond / Notes 1,683,598 - - 1,683,598 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 95,551 - - 95,551 Housing Federal Agency Bond / Notes 1,361,048 - - 1,361,048 Housing Corporate Notes 1,418,403 - - 1,418,403 Housing Certificate of Deposit 500,000 - - 500,000 Successor Investments: Successor Local Agency Investment Fund 9,503,663 - - 9,503,663 Successor CAMP Investments: Successor CAMP Pool Account 21,140 - - 21,140 Successor U.S. Treasury Bond / Notes 1,832,796 - - 1,832,796 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 95,551 - - 95,551 Successor Federal Agency Bond / Notes 1,608,343 - - 1,608,343 Successor Corporate Notes 1,220,559 - - 1,220,559 Successor Certificate of Deposit 500,000 - - 500,000 Sub-total Investments 72,521,375 - - 72,521,375 Market Value Adjustment: Unrealized Gain/ (Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/ (Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/ (Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 73,033,777 - - 73,033,777 Total Pooled Cash and Investments 75,999,186$ 413,698$ (1,313,526)$ 75,100,657$ TOTAL POOLED CASH AND INVESTMENTS 75,100,657$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 16, 2016. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson February 21, 2017 Director of Administrative Services Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF JANUARY 31, 2017 FUND NO FUND NAME AMOUNT 100 General Fund 9,501,162$ 106 Affordable Housing In Lieu Fund 1,024,168 107 Developer Agreement Revenue 1,256,495 110 State Gas Tax Fund 1,582,702 111 TUMF C.I.P. Fund 2,719 112 Measure A Fund 1,399,159 114 SB1186 CASP Education Program Fund 6,559 116 City Hall-Public Works DIF Fund 1,279,177 117 Community Center DIF Fund 570,343 118 Lake Side Facility DIF Fund 708,600 119 Animal Shelter DIF Fund 45,600 121 T.R.I.P.-2014A 150 130 Lighting & Landscape Maintenance Fund - City-wide 66,708 135 Lighting & Landscape Maintenance Fund - Dist. No. 1 581,757 140 Geothermal Fund 20,126 155 CSA152 -- N.P.D.E.S.187,399 160 PEG Grant Fund 33,612 205 Traffic Impact Fee Fund 3,937,042 211 Storm Drain C.I.P. Fund 4,283,473 221 Quimby Park C.I.P. Fund 16,861 231 Library C.I.P. Fund 1,749,910 232 City Fire Protection Fund 145,239 254 AD 89-1 Railroad Canyon Rd. Improvement Fund 126,253 268 CFD 2006-2 Viscaya Improvement 222 300 Insurance Service 933,110 305 Information Systems Service 64,452 310 Support Service 5,327 315 Fleet Service 140,608 320 Facilities Service 577,340 331 CFD 2006-1CC Summerly Improvement Area CC 56,484 332 CFD 2006-1 Improvement Area B, Summerly 89,302 334 CFD 2015-5 Trieste - Far West Industries 19,020 336 CFD 2006-1FF Summerly Improvement Area FF 26,558 337 CFD 2016-2 Canyon Hills 9,378 345 CFD 2003-2S Improvement Area D, Canyon Hills 847,874 346 CFD 2014-1 Southshore Debt Service Fund 63,793 347 CFD 2006-1 Improvement Area A, Summerly 122,688 350 CFD 98-1 Summerhill Debt Service Fund 1,007,595 352 AD 86-1 Debt Service Fund 659,115 354 CFD 90-2 Successor RDA Debt Service Fund 1,087,005 357 CFD 2003-2 Canyon Hills Debt Service Fund 480,548 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF JANUARY 31, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF JANUARY 31, 2017 366 CFD 2005-6 City Center Townhomes Debt Service Fund 150,645 368 CFD 2006-2 Viscaya Debt Service Fund 288,835 369 CFD 2004-3 Area 1 Rosetta Canyon Debt Service Fund 805,361 371 CFD 2005-1 Serenity Debt Service Fund 342,194 372 CFD 2005-2 Alberhill Ranch Debt Service Fund 706,080 374 CFD 2005-4 Lakeview Villas Debt Service Fund 49,691 375 CFD 2006-4 Tract No. 30698 & 32129 Debt Service Fund 20,506 376 CFD 2006-3 La Strada Debt Service Fund 18,722 377 CFD 2006-6 Tessara Debt Service Fund 13,601 378 CFD 2006-8 Tract No. 31957 Debt Service Fund 50,696 384 CFD 2003-2 Area B Canyon Hills Debt Service Fund 910,633 385 CFD 2004-3 Area 2 Rosetta Canyon Debt Service Fund 938,865 387 CFD 2007-5 Red Kite Debt Service Fund 69,980 388 CFD 2007-6 Holiday Inn Debt Service Fund 3,652 389 CFD 88-3 (2008A) West Lake Elsinore Debt Service Fund 1,290,178 390 CFD 2003-2 Area C Canyon Hills Debt Service Fund 394,683 392 CFD 95-1 City Center Debt Service Fund 98,018 393 AD 93-1 Debt Service Fund 775,326 394 CFD 2005-5 (2012A) Wasson Canyon Debt Service Fund 187,695 510 Successor Agency RDA Area I 1,205,573 520 Successor Agency RDA Area II 3,981,535 530 Successor Agency RDA Area III 1,704,897 540 Successor Area RDA Diamond Stadium 4,040,461 604 Endowment Trust Fund 31,536 605 Public Improvement Trust Fund 870,809 606 Mobile Source Air Polution Reduction Fund 259,816 608 Trust Deposit & Pre Paid Expense Fund 5,852,834 617 Successor Agency Housing Fund 12,159,918 620 Cost Recovery System Fund 2,869,513 631 Lake Destratification Equipment Replacement Fund 199,066 731 LEPFA 2011 Series B 2 780 LEPFA General 93,703 Total Pooled Cash & Investments 75,100,657$ Yield Purchase Date Maturity Rate 0.751%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 10,519,815$ 12,022,511$ 22,542,326$ City for the PFA 330,938$ (330,938)$ -$ Successor Agency 3,996,855$ 5,506,808$ 9,503,663$ Total Investments Held with Local Agency Investment Fund:14,847,607$ 17,198,381$ 32,045,989$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING JANUARY 31, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 7,591,143$ 249,880$ (1,235,686)$ 6,605,337$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 7,591,143 249,880 (1,235,686) 6,606,637 INVESTMENTS City Investments: City Local Agency Investment Fund 18,542,326 - 18,542,326 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 81,097 - - 81,097 U.S. Treasury Bond / Note 9,758,274 - - 9,758,274 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 527,082 - - 527,082 Federal Agency Bond / Note 7,634,195 - - 7,634,195 Corporate Note 6,577,036 - - 6,577,036 Commercial Paper 621,031 621,031 Certificate of Deposit 4,649,552 - - 4,649,552 Housing CAMP Investments: Housing CAMP Pool Account 24,836 - - 24,836 Housing U.S. Treasury Bond / Notes 1,569,551 - - 1,569,551 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 95,412 - - 95,412 Housing Federal Agency Bond / Notes 1,351,226 - - 1,351,226 Housing Corporate Notes 1,448,371 - - 1,448,371 Housing Certificate of Deposit 600,000 - - 600,000 Successor Investments: Successor Local Agency Investment Fund 8,403,663 - - 8,403,663 Successor CAMP Investments: Successor CAMP Pool Account 31,119 - - 31,119 Successor U.S. Treasury Bond / Notes 1,758,734 - - 1,758,734 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 95,412 - - 95,412 Successor Federal Agency Bond / Notes 1,558,547 - - 1,558,547 Successor Corporate Notes 1,250,528 - - 1,250,528 Successor Certificate of Deposit 600,000 - - 600,000 Sub-total Investments 67,528,623 - - 67,528,623 Market Value Adjustment: Unrealized Gain/ (Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/ (Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/ (Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 68,041,025 - - 68,041,025 Total Pooled Cash and Investments 75,632,168$ 249,880$ (1,235,686)$ 74,647,662$ TOTAL POOLED CASH AND INVESTMENTS 74,647,662$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 16, 2016. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson March 21, 2017 Director of Administrative Services Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF FEBRUARY 28, 2017 FUND NO FUND NAME AMOUNT 100 General 9,824,018$ 101 Supplemental Law Enforcement 8,333 104 Traffic Offender 3,000 106 Affordable Housing In Lieu 1,037,441 107 Developer Agreement Revenue 756,495 110 State Gas Tax 1,310,422 112 Measure A 1,516,619 114 SB1186 CASP Education Program 6,765 116 City Hall-Public Works DIF 1,251,605 117 Community Center DIF 440,081 118 Lake Side Facility DIF 677,670 119 Animal Shelter DIF 45,600 121 T.R.I.P.-2014A 150 135 Lighting & Landscape Maintenance - Dist. No. 1 579,141 140 Geothermal 20,126 155 CSA152 -- N.P.D.E.S.25,629 205 Traffic Impact Fee 3,926,998 211 Storm Drain C.I.P. 4,273,023 231 Library C.I.P. 1,750,810 232 City Fire Protection 158,168 254 Railroad Canyon Improvement Area 89-1 126,253 268 CFD 2006-2 Viscaya Improvement 222 300 Insurance Service 933,110 305 Information Systems Service 5,178 315 Fleet Service 94,933 320 Facilities Service 548,577 331 CFD 2006-1CC Summerly Improvement Area CC 10,944 332 CFD 2006-1 Improvement Area B, Summerly 36,168 334 CFD 2015-5 Trieste - Far West Industries 19,020 336 CFD 2006-1FF Summerly Improvement Area FF 31,333 337 CFD 2016-2 Canyon Hills 9,378 345 CFD 2003-2S Improvement Area D, Canyon Hills 326,190 346 CFD 2014-1 Southshore 63,793 347 CFD 2006-1 Improvement Area A, Summerly 38,204 350 CFD 98-1 Summerhill 913,716 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 1,100,597 357 CFD 2003-2 Canyon Hills Improvement Area 257,162 366 CFD 2005-6 City Center Townhomes Debt Service 91,996 368 CFD 2006-2 Viscaya 149,560 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 334,472 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF FEBRUARY 28, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF FEBRUARY 28, 2017 371 CFD 2005-1 Serenity 159,634 372 CFD 2005-2 Alberhill Ranch Improvement Area 239,907 374 CFD 2005-4 Lakeview Villas 49,691 375 CFD 2006-4 Clurman Debt Service 20,506 376 CFD 2006-3 La Strada 18,722 377 CFD 2006-6 Tessara 13,601 378 CFD 2006-8 Running Deer Estates 50,696 384 CFD 2003-2 Area B Canyon Hills Improvement Area 302,930 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 385,446 387 CFD 2007-5 Red Kite 69,980 388 CFD 2007-6 Holiday Inn Express 3,652 389 CFD 88-3 (2008A) West Lake Elsinore Series A 1,211,410 390 CFD 2003-2 Area C Canyon Hills Improvement Area 112,325 392 CFD 95-1 City Center 76,370 393 AD 93-1 Cottonwood Hills 413,577 394 CFD 2005-5 (2012A) Wasson Canyon 174,299 500 Capital Improvement Plan 6,907,761 510 Successor Agency RDA Area I 584,235 520 Successor Agency RDA Area II 3,338,610 530 Successor Agency RDA Area III 1,390,590 540 Successor Area RDA Diamond Stadium 3,847,761 604 Endowment Trust - Korn Memorial 31,536 605 Public Improvement Trust 712,378 606 Mobile Source Air Polution Reduction 259,816 608 Trust Deposit & Pre Paid Expense 5,583,377 617 Successor Agency Housing 12,151,041 620 Cost Recovery System 2,976,727 631 Lake Destratification Equipment Replacement 199,066 Total Pooled Cash & Investments 74,647,662$ Yield Purchase Date Maturity Rate 0.777%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 22,542,326$ (4,000,000)$ 18,542,326$ City for the PFA -$ -$ -$ Successor Agency 9,503,663$ (1,100,000)$ 8,403,663$ Total Investments Held with Local Agency Investment Fund:32,045,989$ (5,100,000)$ 26,945,989$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING FEBRUARY 28, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 5,438,789$ 243,442$ (641,894)$ 5,040,336$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 5,438,789 243,442 (641,894) 5,041,636 INVESTMENTS City Investments: City Local Agency Investment Fund 18,542,326 - 18,542,326 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 26,764 - - 26,764 U.S. Treasury Bond / Note 10,315,437 - - 10,315,437 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 526,547 - - 526,547 Federal Agency Bond / Note 6,737,579 - - 6,737,579 Corporate Note 6,975,791 - - 6,975,791 Commercial Paper 621,031 621,031 Certificate of Deposit 4,649,552 - - 4,649,552 Housing CAMP Investments: Housing CAMP Pool Account 25,954 - - 25,954 Housing U.S. Treasury Bond / Notes 1,666,450 - - 1,666,450 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 95,321 - - 95,321 Housing Federal Agency Bond / Notes 1,252,741 - - 1,252,741 Housing Corporate Notes 1,448,371 - - 1,448,371 Housing Certificate of Deposit 600,000 - - 600,000 Successor Investments: Successor Local Agency Investment Fund 8,403,663 - - 8,403,663 Successor CAMP Investments: Successor CAMP Pool Account 4,783 - - 4,783 Successor U.S. Treasury Bond / Notes 1,807,128 - - 1,807,128 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 95,321 - - 95,321 Successor Federal Agency Bond / Notes 1,458,923 - - 1,458,923 Successor Corporate Notes 1,325,301 - - 1,325,301 Successor Certificate of Deposit 600,000 - - 600,000 Sub-total Investments 67,529,614 - - 67,529,614 Market Value Adjustment: Unrealized Gain/ (Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/ (Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/ (Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 68,042,016 - - 68,042,016 Total Pooled Cash and Investments 73,480,805$ 243,442$ (641,894)$ 73,083,653$ TOTAL POOLED CASH AND INVESTMENTS 73,083,653$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 16, 2016. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson April 18, 2017 Director of Administrative Services Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF MARCH 31, 2017 FUND NO FUND NAME AMOUNT 100 General 12,364,839$ 101 Supplemental Law Enforcement 16,667 104 Traffic Offender 5,625 106 Affordable Housing In Lieu 1,050,537 107 Developer Agreement Revenue 777,495 110 State Gas Tax 1,343,740 112 Measure A 1,516,619 114 SB1186 CASP Education Program 7,010 115 Traffic Safety 59,948 116 City Hall-Public Works DIF 1,261,313 117 Community Center DIF 446,621 118 Lake Side Facility DIF 687,018 119 Animal Shelter DIF 49,776 121 T.R.I.P.-2014A 150 135 Lighting & Landscape Maintenance - Dist. No. 1 573,646 140 Geothermal 20,126 155 CSA152 -- N.P.D.E.S.70,999 205 Traffic Impact Fee 3,951,289 211 Storm Drain C.I.P. 1,001,023 231 Library C.I.P. 1,727,835 232 City Fire Protection 167,180 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 933,110 315 Fleet Service 183,555 320 Facilities Service 493,507 331 CFD 2006-1CC Summerly Improvement Area CC 5,406 332 CFD 2006-1 Improvement Area B, Summerly 30,629 334 CFD 2015-5 Trieste - Far West Industries 5,823 336 CFD 2006-1FF Summerly Improvement Area FF 24,833 337 CFD 2016-2 Canyon Hills 9,378 345 CFD 2003-2S Improvement Area D, Canyon Hills 315,252 346 CFD 2014-1 Southshore 63,793 347 CFD 2006-1 Improvement Area A, Summerly 32,281 350 CFD 98-1 Summerhill 900,485 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 934,378 357 CFD 2003-2 Canyon Hills Improvement Area 246,470 366 CFD 2005-6 City Center Townhomes Debt Service 86,377 368 CFD 2006-2 Viscaya 140,267 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 319,295 371 CFD 2005-1 Serenity 153,896 372 CFD 2005-2 Alberhill Ranch Improvement Area 234,369 374 CFD 2005-4 Lakeview Villas 48,499 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF MARCH 31, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF MARCH 31, 2017 375 CFD 2006-4 Clurman Debt Service 12,614 376 CFD 2006-3 La Strada 13,138 377 CFD 2006-6 Tessara 6,170 378 CFD 2006-8 Running Deer Estates 43,266 384 CFD 2003-2 Area B Canyon Hills Improvement Area 281,362 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 378,198 387 CFD 2007-5 Red Kite 64,396 388 CFD 2007-6 Holiday Inn Express 3,652 389 CFD 88-3 (2008A) West Lake Elsinore Series A 1,158,797 390 CFD 2003-2 Area C Canyon Hills Improvement Area 97,816 392 CFD 95-1 City Center 73,832 393 AD 93-1 Cottonwood Hills 396,759 394 CFD 2005-5 (2012A) Wasson Canyon 138,220 500 Capital Improvement Plan 6,608,293 510 Successor Agency RDA Area I 583,515 520 Successor Agency RDA Area II 3,337,610 530 Successor Agency RDA Area III 1,390,310 540 Successor Area RDA Diamond Stadium 3,502,965 604 Endowment Trust - Korn Memorial 31,536 605 Public Improvement Trust 712,378 606 Mobile Source Air Polution Reduction 277,500 608 Trust Deposit & Pre Paid Expense 5,589,055 617 Successor Agency Housing 12,147,669 620 Cost Recovery System 2,994,108 631 Lake Destratification Equipment Replacement 194,066 Total Pooled Cash & Investments 73,083,653$ Yield Purchase Date Maturity Rate 0.821%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 18,542,326$ -$ 18,542,326$ City for the PFA -$ -$ -$ Successor Agency 8,403,663$ -$ 8,403,663$ Total Investments Held with Local Agency Investment Fund:26,945,989$ -$ 26,945,989$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING MARCH 31, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 3,306,581$ 80,685$ (406,966)$ 2,980,301$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 3,306,581 80,685 (406,966) 2,981,601 INVESTMENTS City Investments: City Local Agency Investment Fund 18,574,656 - - 18,574,656 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 123,528 - - 123,528 U.S. Treasury Bond / Note 10,125,476 - - 10,125,476 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 523,989 - - 523,989 Federal Agency Bond / Note 6,731,466 - - 6,731,466 Corporate Note 7,098,552 - - 7,098,552 Commercial Paper 621,031 - - 621,031 Certificate of Deposit 4,649,552 - - 4,649,552 Housing CAMP Investments: Housing CAMP Pool Account 131,915 - - 131,915 Housing U.S. Treasury Bond / Notes 1,714,228 - - 1,714,228 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 94,854 - - 94,854 Housing Federal Agency Bond / Notes 1,127,682 - - 1,127,682 Housing Corporate Notes 1,320,701 - - 1,320,701 Housing Certificate of Deposit 700,000 - - 700,000 Successor Investments: Successor Local Agency Investment Fund 8,419,110 - - 8,419,110 Successor CAMP Investments: Successor CAMP Pool Account 227,323 - - 227,323 Successor U.S. Treasury Bond / Notes 1,772,046 - - 1,772,046 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 94,854 - - 94,854 Successor Federal Agency Bond / Notes 1,352,501 - - 1,352,501 Successor Corporate Notes 1,144,926 - - 1,144,926 Successor Certificate of Deposit 700,000 - - 700,000 Sub-total Investments 67,599,023 - - 67,599,023 Market Value Adjustment: Unrealized Gain/ (Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/ (Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/ (Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 68,111,425 - - 68,111,425 Total Pooled Cash and Investments 71,418,007$ 80,685$ (406,966)$ 71,093,026$ TOTAL POOLED CASH AND INVESTMENTS 71,093,026$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 16, 2016. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson May 15, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF APRIL 30, 2017 FUND NO FUND NAME AMOUNT 100 General 11,163,373$ 101 Supplemental Law Enforcement 25,000 104 Traffic Offender 7,875 106 Affordable Housing In Lieu 1,124,695 107 Developer Agreement Revenue 761,477 110 State Gas Tax 1,303,863 112 Measure A 1,657,761 114 SB1186 CASP Education Program 7,022 115 Traffic Safety 60,184 116 City Hall-Public Works DIF 1,264,049 117 Community Center DIF 448,351 118 Lake Side Facility DIF 689,683 119 Animal Shelter DIF 49,956 121 T.R.I.P.-2014A 151 135 Lighting & Landscape Maintenance - Dist. No. 1 565,322 140 Geothermal 20,205 155 CSA152 -- N.P.D.E.S.70,362 205 Traffic Impact Fee 3,944,735 211 Storm Drain C.I.P. 1,003,870 220 Street Lighting C.I.P.11,000 231 Library C.I.P. 1,741,304 232 City Fire Protection 167,782 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 937,373 305 Information Systems Service 49,696 310 Support Service 5,698 315 Fleet Service 299,978 320 Facilities Service 587,711 331 CFD 2006-1CC Summerly Improvement Area CC 4,411 332 CFD 2006-1 Improvement Area B, Summerly 29,741 334 CFD 2015-5 Trieste - Far West Industries 5,846 336 CFD 2006-1FF Summerly Improvement Area FF 24,936 337 CFD 2016-2 Canyon Hills 9,415 345 CFD 2003-2S Improvement Area D, Canyon Hills 315,899 346 CFD 2014-1 Southshore 64,044 347 CFD 2006-1 Improvement Area A, Summerly 30,684 350 CFD 98-1 Summerhill 902,051 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 934,923 357 CFD 2003-2 Canyon Hills Improvement Area 246,227 366 CFD 2005-6 City Center Townhomes Debt Service 85,917 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF APRIL 30, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF APRIL 30, 2017 368 CFD 2006-2 Viscaya 140,132 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 319,956 371 CFD 2005-1 Serenity 153,587 372 CFD 2005-2 Alberhill Ranch Improvement Area 234,727 374 CFD 2005-4 Lakeview Villas 48,304 375 CFD 2006-4 Clurman Debt Service 12,301 376 CFD 2006-3 La Strada 12,440 377 CFD 2006-6 Tessara 5,753 378 CFD 2006-8 Running Deer Estates 42,995 384 CFD 2003-2 Area B Canyon Hills Improvement Area 279,522 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 379,009 386 CFD 2007-4 Mekenna Court 34,750 387 CFD 2007-5 Red Kite 63,891 388 CFD 2007-6 Holiday Inn Express 3,667 389 CFD 88-3 (2008A) West Lake Elsinore Series A 745,560 390 CFD 2003-2 Area C Canyon Hills Improvement Area 95,831 392 CFD 95-1 City Center 73,033 393 AD 93-1 Cottonwood Hills 395,628 394 CFD 2005-5 (2012A) Wasson Canyon 138,307 500 Capital Improvement Plan 6,894,070 510 Successor Agency RDA Area I 585,779 520 Successor Agency RDA Area II 2,849,996 530 Successor Agency RDA Area III 1,396,103 540 Successor Area RDA Diamond Stadium 3,255,770 604 Endowment Trust - Korn Memorial 31,660 605 Public Improvement Trust 715,176 606 Mobile Source Air Polution Reduction 278,538 608 Trust Deposit & Pre Paid Expense 5,597,388 617 Successor Agency Housing 12,075,298 620 Cost Recovery System 2,628,497 631 Lake Destratification Equipment Replacement 194,858 650 CFD 2003-1 Law & Fire Service 2,559 Total Pooled Cash & Investments 71,093,026$ Yield Purchase Date Maturity Rate 0.884%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 18,542,326$ 32,330$ 18,574,656$ City for the PFA -$ -$ -$ Successor Agency 8,403,663$ 15,448$ 8,419,110$ Total Investments Held with Local Agency Investment Fund:26,945,989$ 47,777$ 26,993,766$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING APRIL 30, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 2,938,996$ 371,547$ (920,497)$ 2,390,046$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 2,938,996 371,547 (920,497) 2,391,346 INVESTMENTS City Investments: City Local Agency Investment Fund 32,574,656 - - 32,574,656 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 202,312 - - 202,312 U.S. Treasury Bond / Note 9,874,253 - - 9,874,253 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 505,060 - - 505,060 Federal Agency Bond / Note 6,931,088 - - 6,931,088 Corporate Note 7,248,465 - - 7,248,465 Commercial Paper 621,031 - - 621,031 Certificate of Deposit 4,649,552 - - 4,649,552 Housing CAMP Investments: Housing CAMP Pool Account 143,009 - - 143,009 Housing U.S. Treasury Bond / Notes 1,714,228 - - 1,714,228 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 91,598 - - 91,598 Housing Federal Agency Bond / Notes 1,127,682 - - 1,127,682 Housing Corporate Notes 1,345,687 - - 1,345,687 Housing Certificate of Deposit 700,000 - - 700,000 Successor Investments: Successor Local Agency Investment Fund 8,419,110 - - 8,419,110 Successor CAMP Investments: Successor CAMP Pool Account 190,311 - - 190,311 Successor U.S. Treasury Bond / Notes 1,772,046 - - 1,772,046 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 91,598 - - 91,598 Successor Federal Agency Bond / Notes 1,402,407 - - 1,402,407 Successor Corporate Notes 1,169,912 - - 1,169,912 Successor Certificate of Deposit 700,000 - - 700,000 Sub-total Investments 81,824,636 - - 81,824,636 Market Value Adjustment: Unrealized Gain/ (Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/ (Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/ (Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 82,337,038 - - 82,337,038 Total Pooled Cash and Investments 85,276,034$ 371,547$ (920,497)$ 84,728,384$ TOTAL POOLED CASH AND INVESTMENTS 84,728,384$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 16, 2016. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson June 12, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF MAY 31, 2017 FUND NO FUND NAME AMOUNT 100 General 14,465,192$ 101 Supplemental Law Enforcement 25,000 104 Traffic Offender 10,250 106 Affordable Housing In Lieu 1,268,099 107 Developer Agreement Revenue 791,477 110 State Gas Tax 1,434,112 112 Measure A 1,204,045 114 SB1186 CASP Education Program 7,281 115 Traffic Safety 134,066 116 City Hall-Public Works DIF 1,282,656 117 Community Center DIF 460,886 118 Lake Side Facility DIF 707,600 119 Animal Shelter DIF 57,960 121 T.R.I.P.-2014A 151 130 Lighting & Landscape Maintenance Fund - City-wide 201,662 135 Lighting & Landscape Maintenance - Dist. No. 1 732,940 140 Geothermal 20,205 155 CSA152 -- N.P.D.E.S.69,804 205 Traffic Impact Fee 4,014,382 211 Storm Drain C.I.P. 1,098,100 220 Street Lighting C.I.P.33,000 231 Library C.I.P. 1,752,854 232 City Fire Protection 185,055 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 937,373 315 Fleet Service 211,988 320 Facilities Service 535,703 331 CFD 2006-1CC Summerly Improvement Area CC 70,258 332 CFD 2006-1 Improvement Area B, Summerly 109,254 334 CFD 2015-5 Trieste - Far West Industries 5,846 336 CFD 2006-1FF Summerly Improvement Area FF 47,037 337 CFD 2016-2 Canyon Hills 9,415 345 CFD 2003-2S Improvement Area D, Canyon Hills 1,137,165 346 CFD 2014-1 Southshore 64,044 347 CFD 2006-1 Improvement Area A, Summerly 136,434 350 CFD 98-1 Summerhill 1,442,608 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 1,723,207 357 CFD 2003-2 Canyon Hills Improvement Area 647,914 366 CFD 2005-6 City Center Townhomes Debt Service 183,142 368 CFD 2006-2 Viscaya 330,920 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF MAY 31, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF MAY 31, 2017 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 1,029,589 371 CFD 2005-1 Serenity 475,015 372 CFD 2005-2 Alberhill Ranch Improvement Area 902,111 374 CFD 2005-4 Lakeview Villas 53,361 375 CFD 2006-4 Clurman Debt Service 17,358 376 CFD 2006-3 La Strada 12,055 377 CFD 2006-6 Tessara 10,773 378 CFD 2006-8 Running Deer Estates 48,014 384 CFD 2003-2 Area B Canyon Hills Improvement Area 1,115,216 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 1,179,018 386 CFD 2007-4 Mekenna Court 39,769 387 CFD 2007-5 Red Kite 71,016 388 CFD 2007-6 Holiday Inn Express 9,525 389 CFD 88-3 (2008A) West Lake Elsinore Series A 1,943,869 390 CFD 2003-2 Area C Canyon Hills Improvement Area 461,037 392 CFD 95-1 City Center 151,211 393 AD 93-1 Cottonwood Hills 1,119,425 394 CFD 2005-5 (2012A) Wasson Canyon 260,955 500 Capital Improvement Plan 8,896,791 510 Successor Agency RDA Area I 1,299,330 520 Successor Agency RDA Area II 2,844,398 530 Successor Agency RDA Area III 1,393,218 540 Successor Area RDA Diamond Stadium 2,637,780 604 Endowment Trust - Korn Memorial 31,660 605 Public Improvement Trust 715,176 606 Mobile Source Air Polution Reduction 298,780 608 Trust Deposit & Pre Paid Expense 5,360,055 617 Successor Agency Housing 11,335,220 620 Cost Recovery System 2,490,444 631 Lake Destratification Equipment Replacement 191,762 Total Pooled Cash & Investments 84,728,384$ Yield Purchase Date Maturity Rate 0.925%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 18,574,656$ 14,000,000$ 32,574,656$ City for the PFA -$ -$ -$ Successor Agency 8,419,110$ -$ 8,419,110$ Total Investments Held with Local Agency Investment Fund:26,993,766$ 14,000,000$ 40,993,766$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING MAY 31, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 3,269,683$ 51,446$ (1,229,395)$ 2,091,734$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 3,269,683 51,446 (1,229,395) 2,093,034 INVESTMENTS City Investments: City Local Agency Investment Fund 36,574,656 - - 36,574,656 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 70,934 - - 70,934 U.S. Treasury Bond / Note 10,732,484 - - 10,732,484 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 493,050 - - 493,050 Federal Agency Bond / Note 6,931,088 - - 6,931,088 Corporate Note 6,449,016 - - 6,449,016 Commercial Paper 621,031 - - 621,031 Certificate of Deposit 4,649,552 - - 4,649,552 Housing CAMP Investments: Housing CAMP Pool Account 46,352 - - 46,352 Housing U.S. Treasury Bond / Notes 1,992,225 - - 1,992,225 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 89,486 - - 89,486 Housing Federal Agency Bond / Notes 1,127,682 - - 1,127,682 Housing Corporate Notes 1,145,666 - - 1,145,666 Housing Certificate of Deposit 700,000 - - 700,000 Successor Investments: Successor Local Agency Investment Fund 8,419,110 - - 8,419,110 Successor CAMP Investments: Successor CAMP Pool Account 17,792 - - 17,792 Successor U.S. Treasury Bond / Notes 1,999,498 - - 1,999,498 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 89,486 - - 89,486 Successor Federal Agency Bond / Notes 1,402,407 - - 1,402,407 Successor Corporate Notes 1,095,341 - - 1,095,341 Successor Certificate of Deposit 700,000 - - 700,000 Sub-total Investments 85,697,486 - - 85,697,486 Market Value Adjustment: Unrealized Gain/(Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/(Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/(Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 86,209,889 - - 86,209,889 Total Pooled Cash and Investments 89,479,571$ 51,446$ (1,229,395)$ 88,302,923$ TOTAL POOLED CASH AND INVESTMENTS 88,302,923$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 13, 2017. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson July 17, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF JUNE 30, 2017 FUND NO FUND NAME AMOUNT 100 General 14,537,187$ 101 Supplemental Law Enforcement 50,000 104 Traffic Offender 13,500 106 Affordable Housing In Lieu 1,446,305 107 Developer Agreement Revenue 825,477 110 State Gas Tax 1,448,686 111 TUMF C.I.P. 2,719 112 Measure A 1,356,559 114 SB1186 CASP Education Program 7,496 115 Traffic Safety 166,109 116 City Hall-Public Works DIF 1,288,311 117 Community Center DIF 460,886 118 Lake Side Facility DIF 707,600 119 Animal Shelter DIF 57,960 121 T.R.I.P.-2014A 151 135 Lighting & Landscape Maintenance - Dist. No. 1 722,813 140 Geothermal 20,205 155 CSA152 -- N.P.D.E.S.99,478 205 Traffic Impact Fee 4,325,318 211 Storm Drain C.I.P. 1,226,322 220 Street Lighting C.I.P.53,000 231 Library C.I.P. 1,760,429 232 City Fire Protection 210,663 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 139,785 315 Fleet Service 121,553 320 Facilities Service 502,373 331 CFD 2006-1CC Summerly Improvement Area CC 70,258 332 CFD 2006-1 Improvement Area B, Summerly 109,254 334 CFD 2015-5 Trieste - Far West Industries 5,846 336 CFD 2006-1FF Summerly Improvement Area FF 44,982 337 CFD 2016-2 Canyon Hills 9,415 345 CFD 2003-2S Improvement Area D, Canyon Hills 1,137,165 346 CFD 2014-1 Southshore 64,044 347 CFD 2006-1 Improvement Area A, Summerly 136,434 350 CFD 98-1 Summerhill 1,442,608 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 1,723,207 357 CFD 2003-2 Canyon Hills Improvement Area 647,914 366 CFD 2005-6 City Center Townhomes Debt Service 183,142 368 CFD 2006-2 Viscaya 330,920 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF JUNE 30, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF JUNE 30, 2017 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 1,029,589 371 CFD 2005-1 Serenity 475,015 372 CFD 2005-2 Alberhill Ranch Improvement Area 902,111 374 CFD 2005-4 Lakeview Villas 53,361 375 CFD 2006-4 Clurman Debt Service 17,358 376 CFD 2006-3 La Strada 12,055 377 CFD 2006-6 Tessara 10,773 378 CFD 2006-8 Running Deer Estates 48,014 384 CFD 2003-2 Area B Canyon Hills Improvement Area 1,115,216 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 1,178,507 386 CFD 2007-4 Mekenna Court 32,269 387 CFD 2007-5 Red Kite 71,016 388 CFD 2007-6 Holiday Inn Express 9,525 389 CFD 88-3 (2008A) West Lake Elsinore Series A 1,943,869 390 CFD 2003-2 Area C Canyon Hills Improvement Area 461,037 392 CFD 95-1 City Center 151,211 393 AD 93-1 Cottonwood Hills 1,119,425 394 CFD 2005-5 (2012A) Wasson Canyon 260,955 500 Capital Improvement Plan 8,247,587 510 Successor Agency RDA Area I 2,761,364 520 Successor Agency RDA Area II 4,811,472 530 Successor Agency RDA Area III 2,165,814 540 Successor Area RDA Diamond Stadium 2,938,835 604 Endowment Trust - Korn Memorial 31,660 605 Public Improvement Trust 715,176 606 Mobile Source Air Polution Reduction 269,646 608 Trust Deposit & Pre Paid Expense 5,077,343 617 Successor Agency Housing 11,322,151 620 Cost Recovery System 2,542,473 631 Lake Destratification Equipment Replacement 286,654 Total Pooled Cash & Investments 88,302,923$ Yield Purchase Date Maturity Rate 0.978%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 32,574,656$ 4,000,000$ 36,574,656$ City for the PFA -$ -$ -$ Successor Agency 8,419,110$ -$ 8,419,110$ Total Investments Held with Local Agency Investment Fund:40,993,766$ 4,000,000$ 44,993,766$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING JUNE 30, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 1,375,467$ 161,216$ (725,848)$ 810,835$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 1,375,467 161,216 (725,848) 812,135 INVESTMENTS City Investments: City Local Agency Investment Fund 36,634,037 - - 36,634,037 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 85,989 - - 85,989 U.S. Treasury Bond / Note 11,889,447 - - 11,889,447 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 465,513 - - 465,513 Federal Agency Bond / Note 5,800,544 - - 5,800,544 Corporate Note 6,449,016 - - 6,449,016 Commercial Paper 621,031 - - 621,031 Certificate of Deposit 4,649,552 - - 4,649,552 Housing CAMP Investments: Housing CAMP Pool Account 34,350 - - 34,350 Housing U.S. Treasury Bond / Notes 2,092,831 - - 2,092,831 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 84,584 - - 84,584 Housing Federal Agency Bond / Notes 1,047,567 - - 1,047,567 Housing Corporate Notes 1,145,666 - - 1,145,666 Housing Certificate of Deposit 700,000 - - 700,000 Successor Investments: Successor Local Agency Investment Fund 8,438,499 - - 8,438,499 Successor CAMP Investments: Successor CAMP Pool Account 23,895 - - 23,895 Successor U.S. Treasury Bond / Notes 2,033,943 - - 2,033,943 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 84,584 - - 84,584 Successor Federal Agency Bond / Notes 1,367,280 - - 1,367,280 Successor Corporate Notes 1,095,341 - - 1,095,341 Successor Certificate of Deposit 700,000 - - 700,000 Sub-total Investments 85,794,300 - - 85,794,300 Market Value Adjustment: Unrealized Gain/(Loss) at 06-30-16 City 441,611 - - 441,611 Unrealized Gain/(Loss) at 06-30-16 SARDA 70,791 - - 70,791 Total Unrealized Gain/(Loss) at 06-30-16 per GASB 31 512,402 - - 512,402 Total Investments 86,306,702 - - 86,306,702 Total Pooled Cash and Investments 87,682,169$ 161,216$ (725,848)$ 87,118,837$ TOTAL POOLED CASH AND INVESTMENTS 87,118,837$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 13, 2017. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson August 15, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF JULY 31, 2017 FUND NO FUND NAME AMOUNT 100 General 14,907,597$ 101 Supplemental Law Enforcement 50,000 104 Traffic Offender 15,250 106 Affordable Housing In Lieu 1,599,635 107 Developer Agreement Revenue 451,833 110 State Gas Tax 1,403,266 111 TUMF C.I.P. 2,719 112 Measure A 1,361,716 114 SB1186 CASP Education Program 7,532 115 Traffic Safety 166,507 116 City Hall-Public Works DIF 1,303,687 117 Community Center DIF 469,704 118 Lake Side Facility DIF 720,390 119 Animal Shelter DIF 62,690 121 T.R.I.P.-2014A 182 135 Lighting & Landscape Maintenance - Dist. No. 1 719,809 140 Geothermal 20,283 155 CSA152 -- N.P.D.E.S.71,632 205 Traffic Impact Fee 4,409,138 211 Storm Drain C.I.P. 1,243,253 220 Street Lighting C.I.P.53,113 231 Library C.I.P. 1,778,042 232 City Fire Protection 221,119 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 136,198 320 Facilities Service 452,912 331 CFD 2006-1CC Summerly Improvement Area CC 70,173 332 CFD 2006-1 Improvement Area B, Summerly 109,756 334 CFD 2015-5 Trieste - Far West Industries 189 336 CFD 2006-1FF Summerly Improvement Area FF 44,892 337 CFD 2016-2 Canyon Hills 9,451 345 CFD 2003-2S Improvement Area D, Canyon Hills 1,150,350 346 CFD 2014-1 Southshore 64,288 347 CFD 2006-1 Improvement Area A, Summerly 136,679 350 CFD 98-1 Summerhill 1,464,489 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 1,760,013 357 CFD 2003-2 Canyon Hills Improvement Area 662,394 366 CFD 2005-6 City Center Townhomes Debt Service 184,616 368 CFD 2006-2 Viscaya 331,146 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 1,049,704 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF JULY 31, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF JULY 31, 2017 371 CFD 2005-1 Serenity 483,946 372 CFD 2005-2 Alberhill Ranch Improvement Area 920,227 374 CFD 2005-4 Lakeview Villas 53,341 375 CFD 2006-4 Clurman Debt Service 17,201 376 CFD 2006-3 La Strada 11,675 377 CFD 2006-6 Tessara 10,547 378 CFD 2006-8 Running Deer Estates 47,931 384 CFD 2003-2 Area B Canyon Hills Improvement Area 1,131,608 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 1,196,351 386 CFD 2007-4 Mekenna Court 24,215 387 CFD 2007-5 Red Kite 70,846 388 CFD 2007-6 Holiday Inn Express 9,550 389 CFD 88-3 (2008A) West Lake Elsinore Series A 1,969,113 390 CFD 2003-2 Area C Canyon Hills Improvement Area 463,567 392 CFD 95-1 City Center 150,941 393 AD 93-1 Cottonwood Hills 1,133,544 394 CFD 2005-5 (2012A) Wasson Canyon 265,235 500 Capital Improvement Plan 7,720,179 510 Successor Agency RDA Area I 1,711,486 520 Successor Agency RDA Area II 4,815,918 530 Successor Agency RDA Area III 2,165,480 540 Successor Area RDA Diamond Stadium 2,767,224 604 Endowment Trust - Korn Memorial 31,780 605 Public Improvement Trust 717,903 606 Mobile Source Air Polution Reduction 213,788 608 Trust Deposit & Pre Paid Expense 4,926,302 617 Successor Agency Housing 11,668,764 620 Cost Recovery System 2,681,022 631 Lake Destratification Equipment Replacement 287,436 Total Pooled Cash & Investments 87,118,837$ Yield Purchase Date Maturity Rate 1.051%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 36,574,656$ 59,381$ 36,634,037$ City for the PFA -$ -$ -$ Successor Agency 8,419,110$ 19,388$ 8,438,499$ Total Investments Held with Local Agency Investment Fund:44,993,766$ 78,770$ 45,072,536$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING JULY 31, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 2,655,347$ 53,908$ (1,393,741)$ 1,315,515$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 2,655,347 53,908 (1,393,741) 1,316,815 INVESTMENTS City Investments: City Local Agency Investment Fund 18,634,037 - - 18,634,037 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 99,014 - - 99,014 U.S. Treasury Bond / Note 12,422,743 - - 12,422,743 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 422,211 - - 422,211 Federal Agency Bond / Note 5,451,132 - - 5,451,132 Corporate Note 6,449,016 - - 6,449,016 Commercial Paper - - - - Certificate of Deposit 5,214,318 - - 5,214,318 Housing CAMP Investments: Housing CAMP Pool Account 36,111 - - 36,111 Housing U.S. Treasury Bond / Notes 2,262,470 - - 2,262,470 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 76,298 - - 76,298 Housing Federal Agency Bond / Notes 798,017 - - 798,017 Housing Corporate Notes 1,145,666 - - 1,145,666 Housing Certificate of Deposit 799,961 - - 799,961 Successor Investments: Successor Local Agency Investment Fund 8,438,499 - - 8,438,499 Successor CAMP Investments: Successor CAMP Pool Account 33,199 - - 33,199 Successor U.S. Treasury Bond / Notes 2,178,267 - - 2,178,267 Successor Municipal Bond / notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 76,298 - - 76,298 Successor Federal Agency Bond / Notes 1,137,254 - - 1,137,254 Successor Corporate Notes 1,095,341 - - 1,095,341 Successor Certificate of Deposit 799,961 - - 799,961 Sub-total Investments 67,920,445 - - 67,920,445 Market Value Adjustment: Unrealized Gain/(Loss) at 06-30-17 City (219,221) - - (219,221) Unrealized Gain/(Loss) at 06-30-17 SARDA (38,492) - - (38,492) Total Unrealized Gain/(Loss) at 06-30-17 per GASB 31 (257,713) - - (257,713) Total Investments 67,662,732 - - 67,662,732 Total Pooled Cash and Investments 70,318,079$ 53,908$ (1,393,741)$ 68,979,547$ TOTAL POOLED CASH AND INVESTMENTS 68,979,547$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 13, 2017. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson September 15, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF AUGUST 31, 2017 FUND NO FUND NAME AMOUNT 100 General 9,930,114$ 106 Affordable Housing In Lieu 1,364,388 107 Developer Agreement Revenue 555,526 110 State Gas Tax 1,581,415 112 Measure A 1,541,126 114 SB1186 CASP Education Program 7,702 115 Traffic Safety 29,812 116 City Hall-Public Works DIF 1,262,288 117 Community Center DIF 473,018 118 Lake Side Facility DIF 725,573 119 Animal Shelter DIF 69,084 121 T.R.I.P.-2014A 131 135 Lighting & Landscape Maintenance - Dist. No. 1 698,592 140 Geothermal 19,971 155 CSA152 -- N.P.D.E.S.68,687 205 Traffic Impact Fee 4,299,498 211 Storm Drain C.I.P. 1,276,782 220 Street Lighting C.I.P.52,999 231 Library C.I.P. 1,756,699 232 City Fire Protection 234,480 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 210,976 320 Facilities Service 410,372 332 CFD 2006-1 Improvement Area B, Summerly 19,913 336 CFD 2006-1FF Summerly Improvement Area FF 25,871 337 CFD 2016-2 Canyon Hills 9,394 345 CFD 2003-2S Improvement Area D, Canyon Hills 534,594 346 CFD 2014-1 Southshore 63,302 347 CFD 2006-1 Improvement Area A, Summerly 24,473 350 CFD 98-1 Summerhill 696,730 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 1,756,433 357 CFD 2003-2 Canyon Hills Improvement Area 111,270 366 CFD 2005-6 City Center Townhomes Debt Service 71,217 368 CFD 2006-2 Viscaya 96,482 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 133,881 371 CFD 2005-1 Serenity 61,879 372 CFD 2005-2 Alberhill Ranch Improvement Area 80,742 374 CFD 2005-4 Lakeview Villas 52,179 375 CFD 2006-4 Clurman Debt Service 16,518 376 CFD 2006-3 La Strada 10,540 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF AUGUST 31, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF AUGUST 31, 2017 377 CFD 2006-6 Tessara 9,883 378 CFD 2006-8 Running Deer Estates 46,702 384 CFD 2003-2 Area B Canyon Hills Improvement Area 215,101 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 352,621 386 CFD 2007-4 Mekenna Court 23,497 387 CFD 2007-5 Red Kite 68,970 388 CFD 2007-6 Holiday Inn Express 3,623 390 CFD 2003-2 Area C Canyon Hills Improvement Area 75,400 392 CFD 95-1 City Center 37,224 393 AD 93-1 Cottonwood Hills 70,950 394 CFD 2005-5 (2012A) Wasson Canyon 140,046 500 Capital Improvement Plan 6,878,457 520 Successor Agency RDA Area II 4,751,476 530 Successor Agency RDA Area III 2,135,317 540 Successor Area RDA Diamond Stadium 2,651,960 604 Endowment Trust - Korn Memorial 31,293 605 Public Improvement Trust 705,717 606 Mobile Source Air Polution Reduction 229,669 608 Trust Deposit & Pre Paid Expense 4,906,776 617 Successor Agency Housing 11,658,866 620 Cost Recovery System 2,555,276 631 Lake Destratification Equipment Replacement 284,125 Total Pooled Cash & Investments 68,979,547$ Yield Purchase Date Maturity Rate 1.084%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 36,634,037$ (18,000,000)$ 18,634,037$ Successor Agency 8,438,499$ -$ 8,438,499$ Total Investments Held with Local Agency Investment Fund:45,072,536$ (18,000,000)$ 27,072,536$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING AUGUST 31, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 2,886,371$ 222,845$ (1,025,694)$ 2,083,521$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 2,886,371 222,845 (1,025,694) 2,084,821 INVESTMENTS City Investments: City Local Agency Investment Fund 14,834,037 - - 14,834,037 City Local Agency Investment Fund for the PFA - - - - City CAMP Investments: CAMP Pool Account 166,856 - - 166,856 U.S. Treasury Bond / Note 11,119,620 - - 11,119,620 Supra-National Agency Bond / Note 748,200 748,200 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 342,850 - - 342,850 Federal Agency Bond / Note 5,605,635 - - 5,605,635 Corporate Note 6,873,827 - - 6,873,827 Commercial Paper - - - - Certificate of Deposit 5,214,318 - - 5,214,318 Housing CAMP Investments: Housing CAMP Pool Account 59,644 - - 59,644 Housing U.S. Treasury Bond / Notes 1,982,287 - - 1,982,287 Housing Supra-National Agency Bond 124,700 124,700 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 61,667 - - 61,667 Housing Federal Agency Bond / Notes 872,777 - - 872,777 Housing Corporate Notes 1,220,632 - - 1,220,632 Housing Certificate of Deposit 799,961 - - 799,961 Successor Investments: Successor Local Agency Investment Fund 8,438,499 - - 8,438,499 Successor CAMP Investments: Successor CAMP Pool Account 56,883 - - 56,883 Successor U.S. Treasury Bond / Notes 1,917,145 - - 1,917,145 Successor Supra-National Agency Bond 149,640 149,640 Successor Municipal Bond / Notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 61,667 - - 61,667 Successor Federal Agency Bond / Notes 1,167,157 - - 1,167,157 Successor Corporate Notes 1,170,307 - - 1,170,307 Successor Certificate of Deposit 799,961 - - 799,961 Sub-total Investments 64,138,904 - - 64,138,904 Market Value Adjustment: Unrealized Gain/(Loss) at 06-30-17 City (219,221) - - (219,221) Unrealized Gain/(Loss) at 06-30-17 SARDA (38,492) - - (38,492) Total Unrealized Gain/(Loss) at 06-30-17 per GASB 31 (257,713) - - (257,713) Total Investments 63,881,191 - - 63,881,191 Total Pooled Cash and Investments 66,767,561$ 222,845$ (1,025,694)$ 65,966,012$ TOTAL POOLED CASH AND INVESTMENTS 65,966,012$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 13, 2017. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson October 13, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF SEPTEMBER 30, 2017 FUND NO FUND NAME AMOUNT 100 General 9,473,003$ 106 Affordable Housing In Lieu 1,420,294 107 Developer Agreement Revenue 555,526 110 State Gas Tax 1,634,164 112 Measure A 1,541,126 114 SB1186 CASP Education Program 7,854 115 Traffic Safety 29,812 116 City Hall-Public Works DIF 1,270,378 117 Community Center DIF 478,468 118 Lake Side Facility DIF 733,363 119 Animal Shelter DIF 72,564 121 T.R.I.P.-2014A 131 135 Lighting & Landscape Maintenance - Dist. No. 1 687,455 140 Geothermal 19,971 155 CSA152 -- N.P.D.E.S.68,687 205 Traffic Impact Fee 4,386,233 211 Storm Drain C.I.P. 1,276,782 220 Street Lighting C.I.P.74,999 231 Library C.I.P. 1,768,249 232 City Fire Protection 241,990 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 207,557 320 Facilities Service 550,409 332 CFD 2006-1 Improvement Area B, Summerly 17,113 336 CFD 2006-1FF Summerly Improvement Area FF 25,871 337 CFD 2016-2 Canyon Hills 9,394 345 CFD 2003-2S Improvement Area D, Canyon Hills 531,794 346 CFD 2014-1 Southshore 63,302 347 CFD 2006-1 Improvement Area A, Summerly 21,673 350 CFD 98-1 Summerhill 693,930 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 809,888 357 CFD 2003-2 Canyon Hills Improvement Area 109,170 366 CFD 2005-6 City Center Townhomes Debt Service 69,642 368 CFD 2006-2 Viscaya 94,907 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 132,306 371 CFD 2005-1 Serenity 60,304 372 CFD 2005-2 Alberhill Ranch Improvement Area 79,167 374 CFD 2005-4 Lakeview Villas 52,179 375 CFD 2006-4 Clurman Debt Service 16,518 376 CFD 2006-3 La Strada 10,540 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF SEPTEMBER 30, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF SEPTEMBER 30, 2017 377 CFD 2006-6 Tessara 9,883 378 CFD 2006-8 Running Deer Estates 46,702 384 CFD 2003-2 Area B Canyon Hills Improvement Area 213,526 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 351,046 386 CFD 2007-4 Mekenna Court 23,497 387 CFD 2007-5 Red Kite 68,970 388 CFD 2007-6 Holiday Inn Express 3,623 390 CFD 2003-2 Area C Canyon Hills Improvement Area 70,500 392 CFD 95-1 City Center 35,649 393 AD 93-1 Cottonwood Hills 68,150 394 CFD 2005-5 (2012A) Wasson Canyon 137,246 500 Capital Improvement Plan 4,983,881 520 Successor Agency RDA Area II 4,751,476 530 Successor Agency RDA Area III 2,135,317 540 Successor Area RDA Diamond Stadium 2,532,806 603 Endowment Trust - Carl Graves 963,064 604 Endowment Trust - Korn Memorial 31,293 605 Public Improvement Trust 705,717 606 Mobile Source Air Polution Reduction 315,721 608 Trust Deposit & Pre Paid Expense 4,912,825 617 Successor Agency Housing 11,651,869 620 Cost Recovery System 1,589,831 631 Lake Destratification Equipment Replacement 281,340 Total Pooled Cash & Investments 65,966,012$ Yield Purchase Date Maturity Rate 1.111%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 18,634,037$ (3,800,000)$ 14,834,037$ Successor Agency 8,438,499$ -$ 8,438,499$ Total Investments Held with Local Agency Investment Fund:27,072,536$ (3,800,000)$ 23,272,536$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING SEPTEMBER 30, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 3,565,095$ 175,325$ (392,513)$ 3,347,907$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 3,565,095 175,325 (392,513) 3,349,207 INVESTMENTS City Investments: City Local Agency Investment Fund 11,909,873 - - 11,909,873 City CAMP Investments: CAMP Pool Account 21,871 - - 21,871 U.S. Treasury Bond / Note 11,046,756 - - 11,046,756 Supra-National Agency Bond / Note 1,353,761 1,353,761 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 323,045 - - 323,045 Federal Agency Bond / Note 4,682,363 - - 4,682,363 Corporate Note 7,448,317 - - 7,448,317 Certificate of Deposit 5,214,318 - - 5,214,318 Housing CAMP Investments: Housing CAMP Pool Account 7,928 - - 7,928 Housing U.S. Treasury Bond / Notes 1,978,326 - - 1,978,326 Housing Supra-National Agency Bond 225,627 225,627 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 58,150 - - 58,150 Housing Federal Agency Bond / Notes 747,972 - - 747,972 Housing Corporate Notes 1,305,707 - - 1,305,707 Housing Certificate of Deposit 799,961 - - 799,961 Successor Investments: Successor Local Agency Investment Fund 8,461,338 - - 8,461,338 Successor CAMP Investments: Successor CAMP Pool Account 4,742 - - 4,742 Successor U.S. Treasury Bond / Notes 1,916,939 - - 1,916,939 Successor Supra-National Agency Bond 250,567 250,567 Successor Municipal Bond / Notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 58,150 - - 58,150 Successor Federal Agency Bond / Notes 1,042,397 - - 1,042,397 Successor Corporate Notes 1,255,382 - - 1,255,382 Successor Certificate of Deposit 799,961 - - 799,961 Sub-total Investments 61,264,083 - - 61,264,083 Market Value Adjustment: Unrealized Gain/(Loss) at 06-30-17 City (219,221) - - (219,221) Unrealized Gain/(Loss) at 06-30-17 SARDA (38,492) - - (38,492) Total Unrealized Gain/(Loss) at 06-30-17 per GASB 31 (257,713) - - (257,713) Total Investments 61,006,370 - - 61,006,370 Total Pooled Cash and Investments 64,571,464$ 175,325$ (392,513)$ 64,355,576$ TOTAL POOLED CASH AND INVESTMENTS 64,355,576$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 13, 2017. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson November 20, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF OCTOBER 31, 2017 FUND NO FUND NAME AMOUNT 100 General 11,036,645$ 106 Affordable Housing In Lieu 1,467,801 107 Developer Agreement Revenue 316,653 110 State Gas Tax 915,928 112 Measure A 1,526,642 114 SB1186 CASP Education Program 9,338 115 Traffic Safety 62,955 116 City Hall-Public Works DIF 1,133,612 117 Community Center DIF 9,148 118 Lake Side Facility DIF 44,111 119 Animal Shelter DIF 62,168 121 T.R.I.P.-2014A 132 135 Lighting & Landscape Maintenance - Dist. No. 1 681,971 140 Geothermal 20,068 155 CSA152 -- N.P.D.E.S.87,464 205 Traffic Impact Fee 4,159,085 211 Storm Drain C.I.P. 1,244,493 220 Street Lighting C.I.P.75,284 221 Quimby Park C.I.P.40,466 231 Library C.I.P. 1,792,522 232 City Fire Protection 67,068 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 204,534 305 Information Systems Service 45,218 320 Facilities Service 720,656 332 CFD 2006-1 Improvement Area B, Summerly 16,861 336 CFD 2006-1FF Summerly Improvement Area FF 25,467 337 CFD 2016-2 Canyon Hills 9,440 345 CFD 2003-2 Improvement Area D, Canyon Hills 528,612 346 CFD 2014-1 Southshore 63,609 347 CFD 2006-1 Improvement Area A, Summerly 21,079 350 CFD 98-1 Summerhill 683,137 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 815,888 357 CFD 2003-2 Canyon Hills Improvement Area 110,483 366 CFD 2005-6 City Center Townhomes Debt Service 69,878 368 CFD 2006-2 Viscaya 95,608 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 130,998 371 CFD 2005-1 Serenity 61,189 372 CFD 2005-2 Alberhill Ranch Improvement Area 81,316 374 CFD 2005-4 Lakeview Villas 52,220 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF OCTOBER 31, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF OCTOBER 31, 2017 375 CFD 2006-4 Clurman Debt Service 16,386 376 CFD 2006-3 La Strada 10,166 377 CFD 2006-6 Tessara 9,677 378 CFD 2006-8 Running Deer Estates 46,674 384 CFD 2003-2 Area B Canyon Hills Improvement Area 210,441 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 346,434 386 CFD 2007-4 Mekenna Court 23,369 387 CFD 2007-5 Red Kite 68,880 388 CFD 2007-6 Holiday Inn Express 3,640 390 CFD 2003-2 Area C Canyon Hills Improvement Area 70,418 392 CFD 95-1 City Center 35,552 393 AD 93-1 Cottonwood Hills 68,659 394 CFD 2005-5 (2012A) Wasson Canyon 137,842 500 Capital Improvement Plan 8,005,552 510 Successor Agency RDA Area I 4,560,465 540 Successor Area RDA Diamond Stadium 2,466,047 603 Endowment Trust - Carl Graves 967,961 604 Endowment Trust - Korn Memorial 31,445 605 Public Improvement Trust 692,764 606 Mobile Source Air Polution Reduction 231,224 608 Trust Deposit & Pre Paid Expense 4,350,961 617 Successor Agency Housing 11,483,686 620 Cost Recovery System 959,501 631 Lake Destratification Equipment Replacement 282,719 Total Pooled Cash & Investments 64,355,576$ Yield Purchase Date Maturity Rate 1.143%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 14,834,037$ (2,924,164)$ 11,909,873$ Successor Agency 8,438,499$ 22,839$ 8,461,338$ Total Investments Held with Local Agency Investment Fund:23,272,536$ (2,901,324)$ 20,371,211$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING OCTOBER 31, 2017 BANK DEPOSITS OUTSTANDING BOOK CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE Bank Accounts: General Checking Account 2,014,231$ 121,437$ (723,426)$ 1,412,243$ Cash On Hand: Cashier Drawers #1 & #2 - - - 300 City of Lake Elsinore Petty Cash Fund - - - 1,000 Total Cash Accounts 2,014,231 121,437 (723,426) 1,413,543 INVESTMENTS City Investments: City Local Agency Investment Fund 10,409,873 - - 10,409,873 City CAMP Investments: CAMP Pool Account 97,181 - - 97,181 U.S. Treasury Bond / Note 10,598,785 - - 10,598,785 Supra-National Agency Bond / Note 1,353,761 1,353,761 Municipal Bond / Note 290,464 - - 290,464 Federal Agency Collateralized Mortgage Obligation 261,403 - - 261,403 Federal Agency Bond / Note 4,682,363 - - 4,682,363 Corporate Note 7,915,944 - - 7,915,944 Certificate of Deposit 5,239,318 - - 5,239,318 Housing CAMP Investments: Housing CAMP Pool Account 38,237 - - 38,237 Housing U.S. Treasury Bond / Notes 1,952,612 - - 1,952,612 Housing Supra-National Agency Bond 225,627 225,627 Housing Municipal Bond / Notes 30,084 - - 30,084 Housing Federal Agency Collateralized Mortgage 46,850 - - 46,850 Housing Federal Agency Bond / Notes 698,143 - - 698,143 Housing Corporate Notes 1,370,963 - - 1,370,963 Housing Certificate of Deposit 799,961 - - 799,961 Successor Investments: Successor Local Agency Investment Fund 8,461,338 - - 8,461,338 Successor CAMP Investments: Successor CAMP Pool Account 34,462 - - 34,462 Successor U.S. Treasury Bond / Notes 1,891,476 - - 1,891,476 Successor Supra-National Agency Bond 250,567 250,567 Successor Municipal Bond / Notes 30,084 - - 30,084 Successor Federal Agency Collaterized Mortgage 46,850 - - 46,850 Successor Federal Agency Bond / Notes 992,568 - - 992,568 Successor Corporate Notes 1,320,638 - - 1,320,638 Successor Certificate of Deposit 799,961 - - 799,961 Sub-total Investments 59,839,513 - - 59,839,513 Market Value Adjustment: Unrealized Gain/(Loss) at 06-30-17 City (219,221) - - (219,221) Unrealized Gain/(Loss) at 06-30-17 SARDA (38,492) - - (38,492) Total Unrealized Gain/(Loss) at 06-30-17 per GASB 31 (257,713) - - (257,713) Total Investments 59,581,800 - - 59,581,800 Total Pooled Cash and Investments 61,596,032$ 121,437$ (723,426)$ 60,995,343$ TOTAL POOLED CASH AND INVESTMENTS 60,995,343$ I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on June 13, 2017. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. Jason P. Simpson December 22, 2017 Assistant City Manager Date C I T Y O F L A K E E L S I N O R E INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF NOVEMBER 30, 2017 FUND NO FUND NAME AMOUNT 100 General 8,462,429$ 106 Affordable Housing In Lieu 1,507,209 107 Developer Agreement Revenue 316,653 110 State Gas Tax 969,756 112 Measure A 1,640,750 114 SB1186 CASP Education Program 9,007 115 Traffic Safety 86,508 116 City Hall-Public Works DIF 1,133,612 117 Community Center DIF 9,148 118 Lake Side Facility DIF 44,111 119 Animal Shelter DIF 62,168 121 T.R.I.P.-2014A 132 135 Lighting & Landscape Maintenance - Dist. No. 1 670,816 140 Geothermal 20,068 155 CSA152 -- N.P.D.E.S.87,036 160 PEG Grant 5,970 205 Traffic Impact Fee 4,174,144 211 Storm Drain C.I.P. 1,244,493 220 Street Lighting C.I.P.101,284 221 Quimby Park C.I.P.40,466 231 Library C.I.P. 1,783,864 232 City Fire Protection 67,068 254 Railroad Canyon Improvement Area 89-1 126,253 300 Insurance Service 226,711 320 Facilities Service 672,420 332 CFD 2006-1 Improvement Area B, Summerly 16,262 333 CFD 2015-3 Terracina 15,935 335 CFD 2003-2E Canyon Hills Improvement Area E 51,686 336 CFD 2006-1FF Summerly Improvement Area FF 24,884 337 CFD 2016-2 Canyon Hills 9,440 338 CFD 2006-1 IA-JJ Summerly Improvement Area 8,794 339 CFD 2006-1 IA-KK Summerly Improvement Area 11,711 345 CFD 2003-2 Improvement Area D, Canyon Hills 527,429 346 CFD 2014-1 Southshore 63,609 347 CFD 2006-1 Improvement Area A, Summerly 20,053 350 CFD 98-1 Summerhill 682,538 352 AD 86-1 Northwest Sewer 659,115 354 CFD 90-2 Tuscany Hills 814,262 357 CFD 2003-2 Canyon Hills Improvement Area 109,713 366 CFD 2005-6 City Center Townhomes 69,450 368 CFD 2006-2 Viscaya 95,180 C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF NOVEMBER 30, 2017 FUND NO FUND NAME AMOUNT C I T Y O F L A K E E L S I N O R E POOLED CASH AND INVESTMENTS BY FUND AS OF NOVEMBER 30, 2017 369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 130,399 371 CFD 2005-1 Serenity 60,590 372 CFD 2005-2 Alberhill Ranch Improvement Area 80,717 374 CFD 2005-4 Lakeview Villas 52,006 375 CFD 2006-4 Clurman 16,172 376 CFD 2006-3 La Strada 9,739 377 CFD 2006-6 Tessara 9,420 378 CFD 2006-8 Running Deer Estates 46,417 384 CFD 2003-2 Area B Canyon Hills Improvement Area 208,222 385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 345,835 386 CFD 2007-4 Mekenna Court 16,650 387 CFD 2007-5 Red Kite 68,452 388 CFD 2007-6 Holiday Inn Express 3,640 390 CFD 2003-2 Area C Canyon Hills Improvement Area 68,878 392 CFD 95-1 City Center 34,953 393 AD 93-1 Cottonwood Hills 67,033 394 CFD 2005-5 (2012A) Wasson Canyon 137,415 500 Capital Improvement Plan 7,186,677 510 Successor Agency RDA Area I 4,556,395 540 Successor Area RDA Diamond Stadium 2,395,167 603 Endowment Trust - Carl Graves 968,178 604 Endowment Trust - Korn Memorial 31,445 605 Public Improvement Trust 692,764 606 Mobile Source Air Polution Reduction 225,224 608 Trust Deposit & Pre Paid Expense 4,350,461 617 Successor Agency Housing 11,302,999 620 Cost Recovery System 1,009,064 631 Lake Destratification Equipment Replacement 278,293 Total Pooled Cash & Investments 60,995,343$ Yield Purchase Date Maturity Rate 1.172%Daily 24-Hour Agency Beginning Balance Net Increase/(Decrease)Ending Balance City 11,909,873$ (1,500,000)$ 10,409,873$ Successor Agency 8,461,338$ -$ 8,461,338$ Total Investments Held with Local Agency Investment Fund:20,371,211$ (1,500,000)$ 18,871,211$ Note: Per California State Treasurer, LAIF Statute 16429.1: Separate accounts for each governmental unit shall be maintained. LAIF accounts are subject to a $65 million cap per agency. C I T Y O F L A K E E L S I N O R E LOCAL AGENCY INVESTMENT FUND TRANSACTION SUMMARY FOR THE MONTH ENDING NOVEMBER 30, 2017