The URL can be used to link to this page

Home My WebLink AboutResolution 2017-174 N.C.S. 12/18/2017Resolution No. 2017-174 N.C.S. of the City of Petaluma, California RESOLUTION TO RECEIVE AND FILE THE CITY TREASURER'S QUARTERLY REPORT DATED SEPTEMBER 30, 2017 WHEREAS, the City Investment policy requires the City Treasurer to provide a quarterly investment report to the Council for compliance with the adopted City Investment Policy. NOW, THEREFORE, BE IT RESOLVED that the City Council has received the City Treasurer's Quarterly Report dated September 30, 2017 and directs the City Clerk to file the report. Under the power and authority conferred upon this Council by the Charter of said City REFERENCE: I hereby certify the foregoing Resolution was introduced and adopted by the Approv d as to Council of the City of Petaluma at a Regular meeting on the 181h day of December r 2017, by the following vote: City Attorney AYES: Albertson, Vice Mayor Barrett, Mayor Glass, Healy, Kearney, King, Miller NOES: None ABSENT: None ABSTAIN: ATTEST Resolution No. 2017-174 N.C.S. Page 1 Exhibit 1 City of Petaluma Quarterly Investment Report July 1 to September 30, 2017 OV, This report is presented in accordance with the City's investment policy and the California Govermnent Code. The policy and Government Code requires the Treasurer to certify that sufficient cash flow is available for the next six months to meet the expected demand or provide an explanation as to why sufficient cash may not be available. The attached report outlines the current investments, weighted average and yields of pooled investments. The month end account statement of assets managed by Public Financial Management, LLC (PFM), the Local Agency Investment Funds (LAIF) quarterly statement, and the City's performance summary of portfolio investments' as compared to applicable benchmarks are included. The report also includes the Treasurer's certification of adequate cash flow. We respectfully submit the quarterly investment report for the quarter ending September 30, 2017. Resolution No. 2017-174 N.C.S. Page 2 CITY OF PETALUMA, CALIFORNIA CITY TREASURER'S QUARTERLY REPORT For the quarter ending September 30, 2017 Cash activity for the fiscal year: Cash and Investments, Beginning of the quarter, 6/30/17 Cash Receipts Cash Disbursements Cash and Investments, End of the Quarter, 9/30/17 Cash and Investment Portfolio at Investments Managed by City Treasurer: Assessment Districts Bonds Local Agency Investment Funds (LAIF) CAMP Pool (CA Asset Management Prog) PFM Investments Securities ** Certificate of Deposits Checking Accounts Subtotal Investments Managed by Fiscal Agents: CAMP Debt Issue Accounts Trustee Money Market Accounts Subtotal Total Cash and Investments September 30, 2017 $ 135,132,210 70,883,841 (80,261,968) $ 125,754,082 Percent Fair Market Par Value of Value* (Cost) Portfolio 307,390 307,390 0.24% 60,205,176 60,426,008 48.05% 30,585,064 30,585,064 24.32% 25,074,876 25,258,492 20.09% 250,000 250,000 0.20% 3,691,807 3,691,807 2.94% 120,114,313 120,518,762 95.84% 434,358 434,358 0.35% 4,800,962 4,800,962 3.82% 5,235,321 5,235,321 4.16% 125,349, 634 125,754,082 100.00 % I certify that this report contains the total amounts of cash and investments at September 30, 2017. The investments are in conformity with the Investment Policy. A copy of the Investment Policy is available for review in the Finance Department. The City Treasurer's cash management program provides sufficient liquidity to meet expenditure requirements for the next six months. We respectfully submit the quarterly gvestinent report for the quarter ending September 30, 2017. P William Mushallo, Finance Director D ecat *Fair market values are furnished by the State of California, Local Agency Investment Fund and California Asset Management Program. ** See*detail attached Resolution No. 2017-174 N.C.S. Page 3 CITY OF PETALU1-vL&, CALIFORNIA CITY TREASURER'S QUARTERLY REPORT For the quarter ending September 30, 2017 Investments Dfanaged 41, City 'Treasurer: Assessment District Bond (AD) 2000-01 373,535.08 (66,144.82) 307,390.26 Sub -Total Assessment Districts Mond (AD) Accounts 373,535.08 - (66,144,82) 307,390.26 LAW 60,124,444.45 138,45893 60,262,903.38 LAIF accrued interest 138,458.93 163,105.11 (138,458.93) 163,105.11 Sub -Total LAIC 60,262,903.38 301,564.04 (138,458.93) 60,426,008.49 CAMP Pool -Treasurers Investment Money Market 35,454 172.64 3,132,229.46 (8,001,337.82) 30,585,064.28 Sub -Total CA14H' Pool illanaged Account 35,454,172.64 3,132,229.46 (8,001,337.82) 30,585,064.28 Federal Agency Bonds/Discount Notes 14,991,670.35 927,587.85 (1;686,968.16) 14,232,290,04 Fed Agency accrued interest 32,309.63 42,090.29 (37,740.29) 36,659.63 US Treasury Bonds/Notes 10,191,523.84 2,050,583.98 (1,287,898.44) 10,954,209.38 US Treasury accrued interest 21,279.72 33,603.59 (19,550.63) 35,332.68 Sub -Total PFM Securities Managed Account ** 25,236,783.54 3,053,865.71 (3,032,157.52) 25,258,491.73 Subtotal 121,327,394,64 6,487,659.21 (11,238,099.09) 116,576,954.76 Certificate of Deposits: Umpqua Bank 250,000.00 60.95 (60,95) 250,000.00 Sub -Total Certificate of Deposits 250,000.00 60,95 (60,95) 250,000.00 Cheeidng Accounts: Exchange -General Operating 8,238,960:53 28,675,96391 (33,311,557.17) 3,603,367.27 Exchange -Payroll 6,984.01 5,905,891.00 (5,906,207.52) 6,667.49 Thomas Lee Charity Trust 1,817.38 - 1,817.38 Police Trust 79,942.67 12.08 79,954.75 Sub -Total Checking Accounts 8,327,704.59 34,581,866.99 (39,217,764.69) 3,691,806.89 Total Cash and Investments Managed by the City Treasurer 129,905,099.23 41,069,587.15 (50,455,924.73) 120,518,761.65 Investments Dlauaged by Trustees Fiscal Agents; CAMP -AD 23, 24, 25 Accounts Money Market 433,119.26 1,238.93 434,358.19 Sub -Total CAMP -Debt Issue Accounts 433,119.26 1,238.93 - 434,358.19 Bank ofNew York 40,169,57 - 40,169.57 US Bank First American Treas 4,753,821.60. 29,813,014,84 (29,806,043.65) 4,760,792.79 Sub -Total Trustees Money Market Account 4,793,991.17 29,813,014.84 (29,806,043.65) 4,800,962.36 Total Cash and Investments Managed by Fiscal Agents 5,227,110.43 29,814,253.77 (29,806,043.65) 5,235,320.55 TOTAL CASH AND INVEST rvIENTS 135,132,209,66 70,883,840.92 (80,261,968.38) 125,754,032.20 ++ See detail attached Accrued interest (235,097.42) General Ledger 125,518,984.78 Resolution No, 2017-174 N.C.S. Page 4 CITY OF PETALUMA, CALIFORNIA CITY TREASURER'S QUARTERLY REPORT For the quarter ending September 30, 2017 Cost vs. Fair Market Value Unrealized Cost FV US Treasury Bond/Note Federal Agency Bond/Discount Note Corporate Note Certificate of Deposit 10,954,209.38 14,232,290.04 - 10,924,704.58 14,150,171.40 - (29,504.80) (82,118.55) - - Sub -Total PFM Treasurer's Invest. Securities 25,186,499.42 25,074,876.07 (111,623.35) CAMP Pool Money Market Fund 30,585,064,28 30,585,064.28 - -Total CAMP Treasurer's Investments 55,771,563,70 55,659,940.35 (111,623.35) _Sub Accrued Interest 71,992.31 CAMP Total Investment Managed Securities Held 55,731,932.66 CAMP Debt Issue Managed Accounts L134,358.19 434,358.19 - PFM CAMP Total Treasurer's Investments ** 56,205,921.89 56,094,298.54 (111,623.35) LAIF 60,262,903.38 60,205,175.80 (57,727.58) LAIF amortized cost rate 0,99904207100 ** See detail attached Resolution No. 2017-174 N.C.S. Page 5 60 4 City of Petaluma, California Cash/Investment by Type -September 30, 2017 Total Cash/Investments $ 125,754,082 Other 307,390 Cash 0.24% 3,691,807 UAMY Investments 25,258,492 20.09% CA Pool Asset Mgmt Prog 30,585,064 24.32 % ?I Agents 2,35,321 .16% C. � '' Managed Account Detail Of Securities Held For the Month Ending September 30, 2017 - r tl i t �ETALUMA..TREASURERS INVESTMENTS ,�,31,,00 .1/-1�251�'5�S .,. Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value U.S. Treasury Bond / Note - US TREASURY NOTES 91282BA34 630,000.00 AA+ Aaa 11/05/15 11/09/15 631,279.69 1.18 2,646.52 630,492.94 628,966.17 OTD 12/02/2013 1.250% 11/30/2018 US TREASURY NOTES 912828A75 325,000.00 AA+ Aaa 12/01/15 12/04/1S 327,754,88 1.22 1.232.00 326,130.48 325,355.55 DTD 12/31/2013 1.500% 12/31/2018 US TREASURY NOTES 912828C65 875,000.00 AA+ Aaa 03/02/16 03/04/16 890,175.78 1.05 39.06 882,454.36 677,563.75 aDTD 03/31/20141.625% 03/31/2019 o EUS TREASURY NOTES 91282SD23 640,000.00 AA+ Aaa 11/10/16 11/14/16 648,750.00 1.06 4.352.17 645.648.43 641.799.68 pDTD 04/30/20141.625% 04/30/2019 ZUS TREASURY NOTES 91282SG61 1,450,000.00 AA+ Aaa 12/01/16 12/05/16 1,452,265.63 1.45 7,309.43 1,451,651.90 1,449,773.80 o DTD 12/01/20141.500% 11/30/2019 N SUS TREASURY NOTES 912828H52 1,100,000.00 AA+ Aaa 01/03/17 01/05/17 1.091,234.38 1.52 2,316.58 1,093,310.92 1,092.781.80 DTD 02/02/2015 1.250% 01/31/2020 .9,JNITED STATES TREASURY NOTES 912828350 425,000.00 AA+ Aaa 02/01/17 02/03/17 422.426.76 1.58 500.43 422.966.63 423,240.08 (2t)TD 03/02/2015 1.375% 02/29/2020 �iJN1TED STATES TREASURY NOTES 912828J50 1.050,000.00 AA+ Aaa 08/31/17 09/01/17 1,049.958.98 1.38 1,236.36 1,049,960.34 1,045.651.95 DTD 03/02/2015 1.375% 02/29/2020 US TREASURY NOTES 91282SUVO 700,000.00 AA+ Aaa 03/15/17 03/17/17 687,941.41 1.71 21.63 690,044.92 692,589.80 DTD 04/01/2013 1.M% 03/31/2020 US TREASURY NOTES 91282SK58 1,000,000.00 AA+ Aaa 04/03/17 04/05/17 995,507.81 1.53 5.754.08 996,210.50 995,000.00 DTD 04/30/2015 1.375% 04/30/2020 US TREASURY NOTES 912828XH8 1,750,000.00 AA+ Aaa 06/26/17 06/28/17 1,756,289.06 1.50 7.186.65 1,755,759.30 1.751,435.00 DTD 06/30120151.625% 06/30/2020 US TREASURY NOTES 912828XM7 1,000,000.00 AA+ Aaa 07/05/17 07/07/17 1,000,625.00 1.60 2,737.77 1,000.581-59 1,000,547,00 DTD 07/31/20151.625% 07/31/2020 Security Type Sub -Total 10,945,000.00 10,954,209.38 1.42 35,332.68 10,945,212.31 10,924,704.58 Federal Agency Collateralized Mortgage Obligation FNMA SERIES 2015-M7 ASQ2 3136ANJY4 49,066.71 AA+ Aaa 04/15/15 04/30/15 49,557.19 0.83 63.38 49,101.38 49.040.72 DTD 04/01120151.550% 04/01/2018 '12 PFM Asset Management LLC Account 531-00 Page 5 � r Managed Account Detail of Securities Held For the Month Ending September 30, 2017 r CITY O,F PETALUMA; TREASURER S �rNVES1"MENTS� Security Type/Description S&P Moody's Trade Settle Original YTM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value FNMA SERIES M4 FA DTD 03/01/2015 0.790% 09/01/2018 FNMA SERIES 2015-MI5 ASQ2 DTD 11/01/2015 1.898% 01/01/2019 FNMA SERIES 2015-M10 FA ,DTD 06/01/2015 0.831% 03/01/2019 FNMA SERIES 2016-M9 ASQ2 ODTD 06/01/2016 1.785% 06/01/2019 o ANNIE MAE SERIES 201S-M13 ASQ2 NDTD 10/01/2015 1.646% 09/01/2019 0 :FNMA SERIES 2015-M12 FA ,LPTD 09/01/2015 1.577% 04/01/2020 J -P'FHLMC SERIES K013 Al -'DTD 05/01/2011 2..902% 08/25/2020 v&HMS K714 A2 DTD 01/01/2014 3.034% 10/25/2020 FHLMC SERIES K717 Al DTD 12/01/2014 2.3420/a 02/01/2021 3136AMTM1 30,613.85 AA+ Aaa 03/12/15 03/31/15 30,606.02 0.38 20.16 30,613.85 30,598.67 3136AOSW1 65,923.22 AA+ Aaa 11/06/15 11/30/15 66,582.44 1.20 104.27 66,121.68 65,987.77 3136ANA98 281.269.00 AA+ Aaa 06/12/15 06/30/15 281,187.62 0.43 194.87 281,269.00 281,264.78 3136ASPX8 74,025.26 AA+ Aaa 06/09/16 06/30/16 74,765.47 1.05 110.11 74,394.56 74,070.20 3136AODOO 163,406.75 AA+ Aaa 10/07/15 10/30/15 165,043.09 1.08 224.14 164,107.08 163,308.38 3136AP3Z3 231,354.54 AA+ Aaa 09/10/15 09/30/15 231.271.25 0.54 304.08 231,354.54 231,697.73 3137AA4V2 169.348.51 AA+ Aaa 06/23/17 06/28/17 172570.10 1.60 409.54 172,570.10 172,019.10 3137B6ZM6 175,000.00 AA+ Aaa 09/21/17 09/26/17 179,860.35 1.15 442.46 179,860.35 179,574.48 3137BFDP3 182,270.58 AA+ Aaa 04/18/17 04/21/17 184,976.16 1.81 355.73 184,583.01 183,608.06 Security Type Sub -Total Federal Agency Bond / Note 1,422,278.42 1,436,419.69 1.01 2,228.74 1,433,975.57 1,431,169.89 FHLB NOTES 3130ASPK3 1,200,000.00 AA+ Aaa 08/10/16 08/12/16 1,195,704.00 0.81 1,125.00 1,198,1S3.56 1,192.935.60 DTD 07/08/2016 0,625% 08/07/2018 FHLB GLOBALAOTE 3130A9AE1 600,000.00 AA+ Aaa 06/25/16 08/26/16 599,S92-00 0.91 2,625.00 599.804.05 597,367.20 DTD 08/26/2016 0.875% 10/01/2018 FHLMC REFERENCE NOTE 3137EAED7 350,000.00 AA+ Aaa 09/15/16 09/16/16 349,849.50 0.90 1,437.67 349,924.60 348,261.55 DTD 09/16/2016 0.875% 10/12/2018 w 'PFM Asset Management LL£ Account 531-00 Page 6 00 Security Type/Description Dated Date/Coupon/Maturity CUSIP FNMA BENCHMARK NOTE DTD 09/01/2015 1.1250/c 10/19/2018 FNMA NOTES DTD 11/03/2015 1.125% 12/14/2018 rFHLB NOTES DTD 12/08/2016 1.250% 01/16/2019 0 FNMA BENCHMARK NOTE p-DTD 02/23120161.000% 02/26/2019 ZFREDDIE MAC NOTES P DTD 03/21/2016 1.1259/o 04/15/2019 N '-':'FHLB GLOBAL NOTE 'DTD 06/03/2016 1.125% 06/21/2019 � FHLB GLOBAL NOTE 'DTD 06/03/2016 1.125% 06/21/2019 �,FHLMC REFERENCE NOTE DTD 07/20/2016 0.875% 07/19/2019 FNMA BENCHMARK NOTE DTD 08/02/2016 0.8750/a 08/02/2019 FNMA NOTES DTD 09/02/2016 1.000% 08/28/2019 FNMA NOTES DTD 09/02/2016 1.000% 08/28/2019 FNMA NOTES DTD 02/28120171.500% 02/28/2020 FHLMC AGENCY NOTES DTD 04/20/2017 1.375% 04/20/2020 FNMA NOTES DTD 08/01/2017 1.500% 07/30/2020 Managed Account Detail of Securities Held For the Month Ending September 30, 2017 S&P Moody's Trade Settle Original YTM Accrued Amortized Market Par Rating Rating Date Date Cost at Cost Interest Cost Value 3135GOE58 1,150,000.00 AA+ Aaa 08/27/15 09/01/15 1,148.137.00 1.18 5,821.88 1,149,366.87 1,146.403.95 3135GOG72 850,000.00 AA+ Aaa 09/01/16 09/02/16 853,510.50 0.94 2.842.19 851,859.61 847,046.25 3130AAE46 475,000.00 AA+ Aaa 12/07/16 12/08/16 474,981.00 1.25 1,236.98 474.987.34 473,842.43 3135GO353 1,200.000.00 AA+ Aaa 02/19/16 02/23/16 1.197,168.00 1.08 1.166.67 1,198,668.10 1,192.359.60 3137EADZ9 650,000.00 AA+ Aaa 03/30/16 03/31/16 651,547.00 1.05 3371.88 650,789.17 646,698.65 3130A8D66 760,000.00 AA+ Aaa 06/02/16 06/03/16 759,680.80 1.14 2,375.00 759,817.82 755,306.24 3130ASDB6 1,050,000.00 AA+ Aaa 06/27/16 06/29/16 1,059,516.65 0.82 3,281.25 1,055,531.66 1,043,515.20 3137EAEB1 900,000.00 AA+ Aaa 07/19/16 07/20/16 897,822.00 0.96 1,575.00 898,684.70 889.580.70 3135GON33 600,000.00 AA+ Aaa 07/29/16 08/02/16 598,992.00 0.93 860.42 599,379.82 592,925.40 3135GOP49 600,000.00 AA+ Aaa 08/31/16 09/02/16 599,064.00 1.05 550.00 599,398.95 594,121.20 3135GOP49 850,000.00 AA+ Aaa 10/03/16 10/05/16 849,490.00 1.02 779.17 849.663.33 841.671.70 3135GOT29 315,000.00 AA+ Aaa 02/24/17 02/28/17 314,798.40 1.52 433.13 314,837.46 314,250.93 3137EAEF2 500,000.00 AA+ Aaa 04/19/17 04/20/17 498.290.00 1.49 3,074.65 498,540.21 496,814.50 3135GOT60 750,000.00 AA+ Aaa 07/28/17 08/01/17 747,727.50 1.60 11875.00 747,851.33 745,900.50 sv PFM Asset Management LLC Account 531-00 Page 7 Managed Account Detail of Securities Held For the Month Ending September 30, 2017 Security Type/Description S&P Moody's Trade Settle Original YCM Accrued Amortized Market Dated Date/Coupon/Maturity CUSIP Par Rating Rating Date Date Cost at Cost Interest Cost Value Security Type Sub -Total 12,800,000.00 12,795,870.35 1.06 34,430.89 12,797,258.58 12,719,001.60 Managed Account Sub -Total CAMP Pool 25,167,278.42 25,186,499.42 1.22 71,992.31 25,176,446.46 25,074,876.07 30,585,064.28 AAAM NR 30,585,064.28 0.00 30,585,064.28 30.585.064.28 11414oney Market Sub -Total 30,585,064.28 30,585,064.28 0.00 30,585,064.28 30,585,064.28 ti 0 Securities Sub -Total $55,752,342.70 $55,771,563.70 1.220/6 $71,992.31 $55,761,510.74 $55,659,940.35 0 Accrued Interest $71,992.31 0 NTotal Investments $55,731,932.66 0 .A z Cn -9 UP 2.PFM Asset Management LLC Account 531-00 Page 8 0 " ° ' Account Statement For the Month Ending September 30, 2017 �: Trade Settlement Share or Dollar Amount Total Date Date Transaction Description Unit Price of Transaction Shares Owned 09/25/17 09/25/17 Purchase- Principal3136ASPXS 1.00 8,349.76 30,730,844.69 09/25/17 09/25/17 Purchase - Principal 3137BFDP3 1.00 3,529.02 30,734,373.71 09/25/17 09/25/17 Purchase - Principal 3137AA4V2 1.00 4,302.96 30,738,676.67 09/26/17 09/26/17 Redemption - Principal 3137B6ZM6 1.00 (179,860.35) 30,558,816.32 CD 09/26/17 0 09/26/17 Redemption - Interest 3137B6ZM6 1.00 (368.72) 30,558,447.60 �. 09/26/17 09/26/17 IP Fees August 2017 1.00 (2,139.39) 30,556,308.21 0 09/26/17 z 09/26/17 U.S. Bank Fees July 2017 1.00 (115.55) 30,556,192.66 0 ^, 09/29/17 10/02/17 Accrual Income Div Reinvestment - Distributions 1.00 28,871.62 30,585,064.28 7Closing Balance 30,585,064.28 Month of Fiscal YTD Z September January -September C� �n Opening Balance 30,631,639.35 30,383,319.93 Closing Balance 30,585,064.28 Purchases 1,185,907.80 25,499,622.55 Average Monthly Balance 30,611,272.57 Redemptions (Excl. Checks) (1,232,482.87) (25,297,878,20) Monthly Distribution Yield 1.150/0 Check Disbursements 0.00 10.00 Closing Balance 30,585,064.28 30,585,064.28 Cash Dividends and Income 28,871.62 245,137.45 It `'TFM Asset Management LLC Account 531-00 Page 15 BETTY T. YEE California State Controller LOCAL AGENCY INVESTMENT FUND REMITTANCE ADVICE Agency Name Account Number PETALUMA 98-49-650 As of 10/13/2017, your Local Agency Investment Fund account has been directly credited with the interest earned on your deposits for the quarter ending 09/30/2017, Earnings Ratio .00002942867511750 Interest Rate . 1.07% Dollar Day Total $ 5,542,387,144.87 Quarter End Principal Balance $ 60,262,903.38 Quarterly Interest Earned $ 163,105.11 Resolution No.2017-174 N.C.S. Page12 ttrvesrs,�yr State of California Pooled Money Investment Account Market Valuation 9/30/2017 Carrying Cost'Plus t)esertptlon Acciued IpterestFurch. Amortized Cost i atrValue Accrued; )ntere$t United States Treasury: Bills $ 14,674,811,264.34 $ 14,728,634 539.67 $ 14,723 448 000.00 NA Notes $ 18,827,121,137.72 18,825,793,811.24 $ 18,779,355,000.00 $ 35,404,702.50 Federal Agency: SBA $ 882 001 016.40 $ 882,001,016.40 $ 872,264,699.96 $ 1,109,845.38 MBS-REMICs $ 36,639,144.19 $ 36639144.19 $ 38144,662.40 $ 171,758.71 Debentures $ 1 328 997,141.66 $ 1,328 621 620.83 $ 1 324,530 000.00 $ 2,307,558.76 Debentures FR $ - $ $ - $ - Debentures CL $ 250,000,000.00 $ 250,000,000.00 $ 249,152,500.00 $ 732,860.50 Discount Notes $ 9,694 389,458.06 $ 9,721,523,694.20 $ 9,720,621,000.00 NA GNMA $ - $ $ - $ Su ranational Debentures $ 450315,184.02 $ 450,217,961.80 $ 448,745,000.00 $ 1,053,298.00 Su ranational Debentures FIR $ 50,000,000.00 $ 50,000,000.00 $ 50,076,500.00 $ 156,944.44 CDs and YCDs FIR $ 625,000,000.00 $ 625 000 000.00 $ 625 000,000.00 $ 1,539,891.61 Bank Notes $ 700,000,000.00 $ 700,000,000.00 $ 699,891,966.88 $ 3,317,666.66 CDs and YCDs $ 12 325,000 000.00 $ 12,325,000,000.00 $ 12,323,151,274.56 $ 32,191,583.30 Commercial Paper $ 6177 895,486,11 $ 6,189,905,611.10 $ 6 189 559 750.03 NA Corporate: Bonds FIR $ - $ $ - $ - Bonds $ - $ $ - $ - Repurchase Agreements $ - $ $ - $ - Reverse Repurchase $ - $ $ - $ - Time Deposits $ 5,636 740,000.00 $ 5,636 740 000.00 $ 5,636,740,000.00 NA AB 55 & GF Loans $ 695,865,000.00 $ 695,865,000.00 $ 695,865,000.00 NA TOTAL $ 72,364,774,832.50 $ 72,445,942,399.43 $ 72 376 544 353.83 $ 77,986,109.85 Fair Value Including Accrued Interest $ 72,454,529,463.68 Governmental Accounting Standards Board (GASB) Statement #72 Repurchase Agreements, Time Deposits, AB 55 & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost) The value of each participating dollar equals the fair value divided by the amortized cost (0,999042071), As an example: if an agency has an account balance of $20,000,000.00, then the agency would report its participation In the LAIF valued at $19,980,'841.43 or $20,000,000.00 x 0.999042071. Resolution No. 2017-174 N.C.S. Page 13 of Petaluma Performance Summaries Returns as of September, 30; 2017 City of Petaluma BAML reasury Index, Past Quarter 0,27% 0,24% Past 6 Months 0,51 % 0.41 % Past Year 0.45% 0.24% Past 3 Years 0.88% 0.76% Past 5 Years 0.72% 0.63% Effective Duration 1.81 years 1,81 years Yield 1.22% 1.47% Notes; 1. Bank of America Merrill Lynch (BAML) Indices provided by Bloomberg Financial Markets. 2. CAMP Cash Reserve Pool holdings excluded from performance, yield and duration calculations. 3, Performance numbers for periods greater than one year are presented on an annualized basis. 4. The City's Treasury benchmark was the Merrill Lynch 1-3 Year Index from inception to 6/30/12. Then the benchmark switched to the Merrill Lynch 1 Year Treasury Index. On 6/30/11 the benchmark returned to the Merrill Lynch 1-3 Year Treasury Index, 5. Inception date is 12/31/01. 6. Yield for the City is calculated as the Yield to Maturity at Cost. The Yield for the City's Treasury benchmark is calculated as the Yield to Maturity at Market. Resolution No. 2017-174 N.C.S. Page 14