HomeMy WebLinkAbout0002_2_OB Investment Reports - Exhibit A - SA RDA Dec. 2017 - Mar. 2018BANK DEPOSITS OUTSTANDING BOOK
CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE
Bank Accounts:
General Checking Account 3,436,281$ 82,776$ (808,789)$ 2,710,268$
Cash On Hand:
Cashier Drawers #1 & #2 - - - 300
City of Lake Elsinore Petty Cash Fund - - - 1,000
Total Cash Accounts 3,436,281 82,776 (808,789) 2,711,568
INVESTMENTS
City Investments:
City Local Agency Investment Fund 8,409,873 - - 8,409,873
City CAMP Investments:
CAMP Pool Account 61,216 - - 61,216
U.S. Treasury Bond / Note 11,044,109 - - 11,044,109
Supra-National Agency Bond / Note 1,353,761 1,353,761
Municipal Bond / Note 290,464 - - 290,464
Federal Agency Collateralized Mortgage Obligation 228,595 - - 228,595
Federal Agency Bond / Note 4,682,363 - - 4,682,363
Corporate Note 7,550,944 - - 7,550,944
Certificate of Deposit 5,239,318 - - 5,239,318
Housing CAMP Investments:
Housing CAMP Pool Account 17,503 - - 17,503
Housing U.S. Treasury Bond / Notes 2,016,937 - - 2,016,937
Housing Supra-National Agency Bond 225,627 225,627
Housing Municipal Bond / Notes 30,084 - - 30,084
Housing Federal Agency Collateralized Mortgage 40,958 - - 40,958
Housing Federal Agency Bond / Notes 698,143 - - 698,143
Housing Corporate Notes 1,335,963 - - 1,335,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 18,955 - - 18,955
Successor U.S. Treasury Bond / Notes 1,965,697 - - 1,965,697
Successor Supra-National Agency Bond 250,567 250,567
Successor Municipal Bond / Notes 30,084 - - 30,084
Successor Federal Agency Collaterized Mortgage 40,958 - - 40,958
Successor Federal Agency Bond / Notes 992,568 - - 992,568
Successor Corporate Notes 1,270,638 - - 1,270,638
Successor Certificate of Deposit 799,961 - - 799,961
Sub-total Investments 57,856,583 - - 57,856,583
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 57,598,870 - - 57,598,870
Total Pooled Cash and Investments 61,035,151$ 82,776$ (808,789)$ 60,310,438$
TOTAL POOLED CASH AND INVESTMENTS 60,310,438$
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 January 11, 2018
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 DECEMBER 31, 2017
FUND NO FUND NAME AMOUNT
100 General 8,480,713$
106 Affordable Housing In Lieu 1,593,331
107 Developer Agreement Revenue 321,653
110 State Gas Tax 966,418
112 Measure A 1,640,750
114 SB1186 CASP Education Program 9,138
115 Traffic Safety 114,853
116 City Hall-Public Works DIF 1,142,511
117 Community Center DIF 15,143
118 Lake Side Facility DIF 52,680
119 Animal Shelter DIF 65,996
121 T.R.I.P.-2014A 132
135 Lighting & Landscape Maintenance - Dist. No. 1 664,722
140 Geothermal 20,068
155 CSA152 -- N.P.D.E.S.65,265
160 PEG Grant 5,970
205 Traffic Impact Fee 4,209,738
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,790,164
232 City Fire Protection 75,329
254 Railroad Canyon Improvement Area 89-1 126,253
300 Insurance Service 241,922
320 Facilities Service 629,416
332 CFD 2006-1 Improvement Area B, Summerly 15,663
333 CFD 2015-3 Terracina 15,336
335 CFD 2003-2E Canyon Hills Improvement Area E 51,103
336 CFD 2006-1FF Summerly Improvement Area FF 24,301
337 CFD 2016-2 Canyon Hills 9,440
338 CFD 2006-1 IA-JJ Summerly Improvement Area 8,211
339 CFD 2006-1 IA-KK Summerly Improvement Area 11,711
345 CFD 2003-2 Improvement Area D, Canyon Hills 526,247
346 CFD 2014-1 Southshore 63,609
347 CFD 2006-1 Improvement Area A, Summerly 19,026
350 CFD 98-1 Summerhill 681,939
352 AD 86-1 Northwest Sewer 659,115
354 CFD 90-2 Tuscany Hills 812,637
357 CFD 2003-2 Canyon Hills Improvement Area 108,943
366 CFD 2005-6 City Center Townhomes 69,022
368 CFD 2006-2 Viscaya 94,752
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, 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 DECEMBER 31, 2017
369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 129,800
371 CFD 2005-1 Serenity 59,991
372 CFD 2005-2 Alberhill Ranch Improvement Area 80,118
374 CFD 2005-4 Lakeview Villas 51,792
375 CFD 2006-4 Clurman 15,958
376 CFD 2006-3 La Strada 9,311
377 CFD 2006-6 Tessara 9,163
378 CFD 2006-8 Running Deer Estates 46,160
384 CFD 2003-2 Area B Canyon Hills Improvement Area 206,169
385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 345,236
386 CFD 2007-4 Mekenna Court 16,394
387 CFD 2007-5 Red Kite 68,024
388 CFD 2007-6 Holiday Inn Express 3,640
390 CFD 2003-2 Area C Canyon Hills Improvement Area 67,338
392 CFD 95-1 City Center 34,354
393 AD 93-1 Cottonwood Hills 65,407
394 CFD 2005-5 (2012A) Wasson Canyon 136,987
395 CFD 2018-1 Wasson Canyon II Improvement Area 45,000
500 Capital Improvement Plan 7,010,748
510 Successor Agency RDA Area I 4,556,395
540 Successor Area RDA Diamond Stadium 1,747,286
603 Endowment Trust - Carl Graves 968,395
604 Endowment Trust - Korn Memorial 31,445
605 Public Improvement Trust 692,764
606 Mobile Source Air Polution Reduction 245,286
608 Trust Deposit & Pre Paid Expense 4,353,511
617 Successor Agency Housing 11,224,595
620 Cost Recovery System 1,022,264
631 Lake Destratification Equipment Replacement 277,444
Total Pooled Cash & Investments 60,310,438$
Yield Purchase Date Maturity Rate
1.239%Daily 24-Hour
Agency Beginning Balance Net Increase/(Decrease)Ending Balance
City 10,409,873$ (2,000,000)$ 8,409,873$
Successor Agency 8,461,338$ -$ 8,461,338$
Total Investments Held with
Local Agency Investment Fund:18,871,211$ (2,000,000)$ 16,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 DECEMBER 31, 2017
BANK DEPOSITS OUTSTANDING BOOK
CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE
Bank Accounts:
General Checking Account 3,551,189$ 442,447$ (289,512)$ 3,704,125$
Cash On Hand:
Cashier Drawers #1 & #2 - - - 300
City of Lake Elsinore Petty Cash Fund - - - 1,000
Total Cash Accounts 3,551,189 442,447 (289,512) 3,705,425
INVESTMENTS
City Investments:
City Local Agency Investment Fund 26,444,165 - - 26,444,165
City CAMP Investments:
CAMP Pool Account 67,412 - - 67,412
U.S. Treasury Bond / Note 11,957,366 - - 11,957,366
Supra-National Agency Bond / Note 1,353,761 1,353,761
Municipal Bond / Note 290,464 - - 290,464
Federal Agency Collateralized Mortgage Obligation 209,725 - - 209,725
Federal Agency Bond / Note 4,382,831 - - 4,382,831
Corporate Note 7,550,944 - - 7,550,944
Certificate of Deposit 4,664,318 - - 4,664,318
Housing CAMP Investments:
Housing CAMP Pool Account 12,194 - - 12,194
Housing U.S. Treasury Bond / Notes 2,130,477 - - 2,130,477
Housing Supra-National Agency Bond 225,627 225,627
Housing Municipal Bond / Notes 30,084 - - 30,084
Housing Federal Agency Collateralized Mortgage 37,545 - - 37,545
Housing Federal Agency Bond / Notes 698,143 - - 698,143
Housing Corporate Notes 1,335,963 - - 1,335,963
Housing Certificate of Deposit 699,961 - - 699,961
Successor Investments:
Successor Local Agency Investment Fund 8,487,026 - - 8,487,026
Successor CAMP Investments:
Successor CAMP Pool Account 11,635 - - 11,635
Successor U.S. Treasury Bond / Notes 2,079,237 - - 2,079,237
Successor Supra-National Agency Bond 250,567 250,567
Successor Municipal Bond / Notes 30,084 - - 30,084
Successor Federal Agency Collaterized Mortgage 37,545 - - 37,545
Successor Federal Agency Bond / Notes 992,568 - - 992,568
Successor Corporate Notes 1,270,638 - - 1,270,638
Successor Certificate of Deposit 699,961 - - 699,961
Sub-total Investments 75,950,240 - - 75,950,240
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 75,692,527 - - 75,692,527
Total Pooled Cash and Investments 79,243,716$ 442,447$ (289,512)$ 79,397,951$
TOTAL POOLED CASH AND INVESTMENTS 79,397,951$
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 February 12, 2018
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 JANUARY 31, 2018
FUND NO FUND NAME AMOUNT
100 General 8,729,445$
106 Affordable Housing In Lieu 1,703,258
107 Developer Agreement Revenue 343,045
110 State Gas Tax 1,015,133
112 Measure A 1,785,091
114 SB1186 CASP Education Program 8,335
116 City Hall-Public Works DIF 928,838
117 Community Center DIF 13,498
118 Lake Side Facility DIF 41,813
119 Animal Shelter DIF 67,659
121 T.R.I.P.-2014A 133
130 Lighting & Landscape Maintenance Fund - City-wide 93,642
135 Lighting & Landscape Maintenance - Dist. No. 1 918,036
140 Geothermal 20,156
155 CSA152 -- N.P.D.E.S.113,906
160 PEG Grant 5,979
205 Traffic Impact Fee 4,271,257
211 Storm Drain C.I.P. 1,253,930
220 Street Lighting C.I.P.101,672
221 Quimby Park C.I.P.47,044
231 Library C.I.P. 1,807,759
232 City Fire Protection 78,624
254 Railroad Canyon Improvement Area 89-1 126,253
300 Insurance Service 1,175,167
305 Information Systems Service 386,604
310 Support Service 12,031
320 Facilities Service 628,305
331 CFD 2006-1CC Summerly Improvement Area CC 74,462
332 CFD 2006-1 Improvement Area B, Summerly 102,052
334 CFD 2015-5 Trieste - Far West Industries 82,789
335 CFD 2003-2E Canyon Hills Improvement Area E 5,231
336 CFD 2006-1FF Summerly Improvement Area FF 117,677
337 CFD 2016-2 Canyon Hills 9,481
340 CFD 2006-1 IA-EE Summerly Improvement Area 34,836
345 CFD 2003-2 Improvement Area D, Canyon Hills 1,402,685
346 CFD 2014-1 Southshore 63,888
347 CFD 2006-1 Improvement Area A, Summerly 135,857
350 CFD 98-1 Summerhill 1,266,095
352 AD 86-1 Northwest Sewer 659,115
354 CFD 90-2 Tuscany Hills 1,681,088
357 CFD 2003-2 Canyon Hills Improvement Area 544,479
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, 2018
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, 2018
366 CFD 2005-6 City Center Townhomes 193,105
368 CFD 2006-2 Viscaya 320,112
369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 917,378
371 CFD 2005-1 Serenity 392,979
372 CFD 2005-2 Alberhill Ranch Improvement Area 797,524
374 CFD 2005-4 Lakeview Villas 56,925
375 CFD 2006-4 Clurman 20,872
376 CFD 2006-3 La Strada 8,731
377 CFD 2006-6 Tessara 19,326
378 CFD 2006-8 Running Deer Estates 51,234
384 CFD 2003-2 Area B Canyon Hills Improvement Area 1,243,900
385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 1,225,412
386 CFD 2007-4 Mekenna Court 21,348
387 CFD 2007-5 Red Kite 75,282
388 CFD 2007-6 Holiday Inn Express 6,463
389 CFD 88-3 (2008A) West Lake Elsinore Series A 1,126,292
390 CFD 2003-2 Area C Canyon Hills Improvement Area 446,990
392 CFD 95-1 City Center 116,496
393 AD 93-1 Cottonwood Hills 808,947
394 CFD 2005-5 (2012A) Wasson Canyon 275,532
395 CFD 2018-1 Wasson Canyon II Improvement Area 45,006
500 Capital Improvement Plan 7,351,288
510 Successor To RDA Area I, II, & III 10,187,507
540 Successor To RDA Diamond Stadium 3,133,805
603 Endowment Trust - Carl Graves 973,071
604 Endowment Trust - Korn Memorial 31,583
605 Public Improvement Trust 695,800
606 Mobile Source Air Polution Reduction 246,302
608 Trust Deposit & Pre Paid Expense 4,234,744
617 Successor Agency Housing 11,241,268
620 Cost Recovery System 998,759
631 Lake Destratification Equipment Replacement 277,625
Total Pooled Cash & Investments 79,397,951$
Yield Purchase Date Maturity Rate
1.350%Daily 24-Hour
Agency Beginning Balance Net Increase/(Decrease)Ending Balance
City 8,409,873$ 18,034,292$ 26,444,165$
Successor Agency 8,461,338$ 25,688$ 8,487,026$
Total Investments Held with
Local Agency Investment Fund:16,871,211$ 18,059,980$ 34,931,192$
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, 2018
BANK DEPOSITS OUTSTANDING BOOK
CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE
Bank Accounts:
General Checking Account 1,783,553$ 56,860$ (210,282)$ 1,630,132$
Cash On Hand:
Cashier Drawers #1 & #2 - - - 300
City of Lake Elsinore Petty Cash Fund - - - 1,000
Total Cash Accounts 1,783,553 56,860 (210,282) 1,631,432
INVESTMENTS
City Investments:
City Local Agency Investment Fund 22,444,165 - - 22,444,165
City CAMP Investments:
CAMP Pool Account 192,154 - - 192,154
U.S. Treasury Bond / Note 11,511,581 - - 11,511,581
Supra-National Agency Bond / Note 1,353,761 1,353,761
Municipal Bond / Note 290,464 - - 290,464
Federal Agency Collateralized Mortgage Obligation 167,441 - - 167,441
Federal Agency Bond / Note 4,382,831 - - 4,382,831
Corporate Note 7,975,658 - - 7,975,658
Certificate of Deposit 4,664,318 - - 4,664,318
Housing CAMP Investments:
Housing CAMP Pool Account 34,233 - - 34,233
Housing U.S. Treasury Bond / Notes 2,104,254 - - 2,104,254
Housing Supra-National Agency Bond 225,627 225,627
Housing Municipal Bond / Notes 30,084 - - 30,084
Housing Federal Agency Collateralized Mortgage 29,844 - - 29,844
Housing Federal Agency Bond / Notes 698,143 - - 698,143
Housing Corporate Notes 1,360,935 - - 1,360,935
Housing Certificate of Deposit 699,961 - - 699,961
Successor Investments:
Successor Local Agency Investment Fund 7,487,026 - - 7,487,026
Successor CAMP Investments:
Successor CAMP Pool Account 34,675 - - 34,675
Successor U.S. Treasury Bond / Notes 2,053,014 - - 2,053,014
Successor Supra-National Agency Bond 250,567 250,567
Successor Municipal Bond / Notes 30,084 - - 30,084
Successor Federal Agency Collaterized Mortgage 29,844 - - 29,844
Successor Federal Agency Bond / Notes 992,568 - - 992,568
Successor Corporate Notes 1,295,610 - - 1,295,610
Successor Certificate of Deposit 699,961 - - 699,961
Sub-total Investments 71,038,803 - - 71,038,803
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 70,781,090 - - 70,781,090
Total Pooled Cash and Investments 72,564,643$ 56,860$ (210,282)$ 72,412,522$
TOTAL POOLED CASH AND INVESTMENTS 72,412,522$
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 March 13, 2018
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 FEBRUARY 28, 2018
FUND NO FUND NAME AMOUNT
100 General 9,366,780$
106 Affordable Housing In Lieu 1,769,959
107 Developer Agreement Revenue 343,045
110 State Gas Tax 1,085,994
112 Measure A 1,785,091
114 SB1186 CASP Education Program 9,119
115 Traffic Safety 23,286
116 City Hall-Public Works DIF 928,838
117 Community Center DIF 13,498
118 Lake Side Facility DIF 41,813
119 Animal Shelter DIF 67,659
121 T.R.I.P.-2014A 133
135 Lighting & Landscape Maintenance - Dist. No. 1 913,042
140 Geothermal 20,156
155 CSA152 -- N.P.D.E.S.113,418
160 PEG Grant 5,979
205 Traffic Impact Fee 4,301,375
211 Storm Drain C.I.P. 1,261,850
220 Street Lighting C.I.P.101,672
221 Quimby Park C.I.P.47,044
231 Library C.I.P. 1,798,455
232 City Fire Protection 78,624
254 Railroad Canyon Improvement Area 89-1 126,253
300 Insurance Service 1,193,293
305 Information Systems Service 302,818
310 Support Service 6,497
320 Facilities Service 570,453
331 CFD 2006-1CC Summerly Improvement Area CC 29,606
332 CFD 2006-1 Improvement Area B, Summerly 49,954
334 CFD 2015-5 Trieste - Far West Industries 43,332
335 CFD 2003-2E Canyon Hills Improvement Area E 4,647
336 CFD 2006-1FF Summerly Improvement Area FF 48,497
337 CFD 2016-2 Canyon Hills 9,481
340 CFD 2006-1 IA-EE Summerly Improvement Area 34,253
345 CFD 2003-2 Improvement Area D, Canyon Hills 894,696
346 CFD 2014-1 Southshore 63,888
347 CFD 2006-1 Improvement Area A, Summerly 54,411
350 CFD 98-1 Summerhill 1,001,502
352 AD 86-1 Northwest Sewer 659,115
354 CFD 90-2 Tuscany Hills 1,695,650
357 CFD 2003-2 Canyon Hills Improvement Area 321,366
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, 2018
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, 2018
366 CFD 2005-6 City Center Townhomes 135,253
368 CFD 2006-2 Viscaya 205,088
369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 436,620
371 CFD 2005-1 Serenity 211,739
372 CFD 2005-2 Alberhill Ranch Improvement Area 344,634
374 CFD 2005-4 Lakeview Villas 56,711
375 CFD 2006-4 Clurman 20,658
376 CFD 2006-3 La Strada 8,303
377 CFD 2006-6 Tessara 19,069
378 CFD 2006-8 Running Deer Estates 38,478
384 CFD 2003-2 Area B Canyon Hills Improvement Area 586,518
385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 689,256
386 CFD 2007-4 Mekenna Court 21,091
387 CFD 2007-5 Red Kite 74,854
388 CFD 2007-6 Holiday Inn Express 6,463
389 CFD 88-3 (2008A) West Lake Elsinore Series A 999,341
390 CFD 2003-2 Area C Canyon Hills Improvement Area 149,708
392 CFD 95-1 City Center 95,863
393 AD 93-1 Cottonwood Hills 437,482
394 CFD 2005-5 (2012A) Wasson Canyon 198,192
395 CFD 2018-1 Wasson Canyon II Improvement Area 40,006
500 Capital Improvement Plan 6,345,919
510 Successor To RDA Area I, II, & III 9,172,598
540 Successor To RDA Diamond Stadium 2,328,333
603 Endowment Trust - Carl Graves 973,071
604 Endowment Trust - Korn Memorial 31,583
605 Public Improvement Trust 695,800
606 Mobile Source Air Polution Reduction 246,302
608 Trust Deposit & Pre Paid Expense 4,237,244
617 Successor Agency Housing 11,152,193
620 Cost Recovery System 989,988
631 Lake Destratification Equipment Replacement 277,625
Total Pooled Cash & Investments 72,412,522$
Yield Purchase Date Maturity Rate
1.412%Daily 24-Hour
Agency Beginning Balance Net Increase/(Decrease)Ending Balance
City 26,444,165$ (4,000,000)$ 22,444,165$
Successor Agency 8,487,026$ (1,000,000)$ 7,487,026$
Total Investments Held with
Local Agency Investment Fund:34,931,192$ (5,000,000)$ 29,931,192$
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, 2018
BANK DEPOSITS OUTSTANDING BOOK
CASH ACCOUNTS BALANCE IN TRANSIT CHECKS BALANCE
Bank Accounts:
General Checking Account 2,298,649$ 23,449$ (998,616)$ 1,323,482$
Cash On Hand:
Cashier Drawers #1 & #2 - - - 300
City of Lake Elsinore Petty Cash Fund - - - 1,000
Total Cash Accounts 2,298,649 23,449 (998,616) 1,324,782
INVESTMENTS
City Investments:
City Local Agency Investment Fund 18,644,165 - - 18,644,165
City CAMP Investments:
CAMP Pool Account 100,483 - - 100,483
U.S. Treasury Bond / Note 11,206,202 - - 11,206,202
Supra-National Agency Bond / Note 1,653,536 1,653,536
Municipal Bond / Note 290,464 - - 290,464
Federal Agency Collateralized Mortgage Obligation 143,891 - - 143,891
Federal Agency Bond / Note 3,909,151 - - 3,909,151
Corporate Note 8,274,125 - - 8,274,125
Certificate of Deposit 4,964,318 - - 4,964,318
Housing CAMP Investments:
Housing CAMP Pool Account 66,856 - - 66,856
Housing U.S. Treasury Bond / Notes 2,051,809 - - 2,051,809
Housing Supra-National Agency Bond 275,589 275,589
Housing Municipal Bond / Notes 30,084 - - 30,084
Housing Federal Agency Collateralized Mortgage 25,665 - - 25,665
Housing Federal Agency Bond / Notes 698,143 - - 698,143
Housing Corporate Notes 1,335,942 - - 1,335,942
Housing Certificate of Deposit 699,961 - - 699,961
Successor Investments:
Successor Local Agency Investment Fund 7,487,026 - - 7,487,026
Successor CAMP Investments:
Successor CAMP Pool Account 42,207 - - 42,207
Successor U.S. Treasury Bond / Notes 2,000,569 - - 2,000,569
Successor Supra-National Agency Bond 300,529 300,529
Successor Municipal Bond / Notes 30,084 - - 30,084
Successor Federal Agency Collaterized Mortgage 25,665 - - 25,665
Successor Federal Agency Bond / Notes 992,568 - - 992,568
Successor Corporate Notes 1,295,610 - - 1,295,610
Successor Certificate of Deposit 699,961 - - 699,961
Sub-total Investments 67,244,603 - - 67,244,603
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 66,986,890 - - 66,986,890
Total Pooled Cash and Investments 69,285,539$ 23,449$ (998,616)$ 68,311,672$
TOTAL POOLED CASH AND INVESTMENTS 68,311,672$
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 April 10, 2018
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 MARCH 31, 2018
FUND NO FUND NAME AMOUNT
100 General 7,923,203$
106 Affordable Housing In Lieu 1,808,755
107 Developer Agreement Revenue 350,045
110 State Gas Tax 1,214,675
112 Measure A 1,911,619
114 SB1186 CASP Education Program 9,316
115 Traffic Safety 48,706
116 City Hall-Public Works DIF 943,400
117 Community Center DIF 23,308
118 Lake Side Facility DIF 55,835
119 Animal Shelter DIF 73,923
121 T.R.I.P.-2014A 133
135 Lighting & Landscape Maintenance - Dist. No. 1 898,348
140 Geothermal 20,156
155 CSA152 -- N.P.D.E.S.112,437
160 PEG Grant 11,801
205 Traffic Impact Fee 4,321,910
211 Storm Drain C.I.P. 1,053,401
220 Street Lighting C.I.P.101,672
221 Quimby Park C.I.P.51,844
231 Library C.I.P. 1,804,005
232 City Fire Protection 92,142
254 Railroad Canyon Improvement Area 89-1 126,253
300 Insurance Service 1,209,051
305 Information Systems Service 181,359
310 Support Service 1,296
320 Facilities Service 525,634
331 CFD 2006-1CC Summerly Improvement Area CC 29,007
332 CFD 2006-1 Improvement Area B, Summerly 49,355
334 CFD 2015-5 Trieste - Far West Industries 42,749
335 CFD 2003-2E Canyon Hills Improvement Area E 4,064
336 CFD 2006-1FF Summerly Improvement Area FF 47,913
337 CFD 2016-2 Canyon Hills 9,481
340 CFD 2006-1 IA-EE Summerly Improvement Area 33,669
345 CFD 2003-2 Improvement Area D, Canyon Hills 893,513
346 CFD 2014-1 Southshore 63,888
347 CFD 2006-1 Improvement Area A, Summerly 53,385
350 CFD 98-1 Summerhill 1,000,903
352 AD 86-1 Northwest Sewer 659,115
354 CFD 90-2 Tuscany Hills 1,546,617
357 CFD 2003-2 Canyon Hills Improvement Area 320,596
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, 2018
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, 2018
366 CFD 2005-6 City Center Townhomes 134,825
368 CFD 2006-2 Viscaya 204,661
369 CFD 2004-3 Area 1 Rosetta Canyon Improvement Area 436,021
371 CFD 2005-1 Serenity 211,140
372 CFD 2005-2 Alberhill Ranch Improvement Area 344,035
374 CFD 2005-4 Lakeview Villas 56,497
375 CFD 2006-4 Clurman 20,444
376 CFD 2006-3 La Strada 7,876
377 CFD 2006-6 Tessara 18,812
378 CFD 2006-8 Running Deer Estates 24,978
384 CFD 2003-2 Area B Canyon Hills Improvement Area 582,664
385 CFD 2004-3 Area 2 Rosetta Canyon Improvement Area 685,557
386 CFD 2007-4 Mekenna Court 20,834
387 CFD 2007-5 Red Kite 74,427
388 CFD 2007-6 Holiday Inn Express 6,463
389 CFD 88-3 (2008A) West Lake Elsinore Series A 993,391
390 CFD 2003-2 Area C Canyon Hills Improvement Area 148,168
392 CFD 95-1 City Center 95,264
393 AD 93-1 Cottonwood Hills 435,423
394 CFD 2005-5 (2012A) Wasson Canyon 197,764
395 CFD 2018-1 Wasson Canyon II Improvement Area 24,297
500 Capital Improvement Plan 5,054,714
510 Successor To RDA Area I, II, & III 9,177,392
540 Successor To RDA Diamond Stadium 1,197,805
603 Endowment Trust - Carl Graves 973,287
604 Endowment Trust - Korn Memorial 31,583
605 Public Improvement Trust 695,800
606 Mobile Source Air Polution Reduction 264,759
608 Trust Deposit & Pre Paid Expense 4,219,642
617 Successor Agency Housing 11,065,204
620 Cost Recovery System 1,003,440
631 Lake Destratification Equipment Replacement 276,028
Total Pooled Cash & Investments 68,311,672$
Yield Purchase Date Maturity Rate
1.524%Daily 24-Hour
Agency Beginning Balance Net Increase/(Decrease)Ending Balance
City 22,444,165$ (3,800,000)$ 18,644,165$
Successor Agency 7,487,026$ -$ 7,487,026$
Total Investments Held with
Local Agency Investment Fund:29,931,192$ (3,800,000)$ 26,131,192$
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, 2018