Fort Walton Beach — Annual Comprehensive Financial Report, September 30, 2023 — reading text

highest classifications by a higher by a major rating classifications by a major major rating service service rating service 1 (1) No more than 5% of the total portfolio may be invested in securities that fall below these rating guidelines. All pension trust funds were in compliance with respective investment policies regarding credit rate risk as of September 30, 2023. The Moody's rating ranges of the different investment classes held by each respective plan at September 30, 2023, are as follows: General Pension Police Pension Plan Plan Fire Pension Plan Corporate debt A1-A3 A1-A3 A1-A3 U.S. Treasury Aaa Aaa Aaa U.S. government agency pools N/A N/A N/A The Beal Memorial Cemetery investment policy does not limit investments to those with specific credit ratings for domestic or international equities. The overall rating of fixed income investments shall be at least investment grade based on the rating of two of the three Nationally Recognized Statistical Rating Organizations (NRSRO). 41  CITY OF FORT WALTON BEACH, FLORIDA NOTES TO THE FINANCIAL STATEMENTS SEPTEMBER 30, 2023 3. DEPOSITS AND INVESTMENTS – CONTINUED Investments – Continued Concentration of Credit Risk – The City limits the amount that may be invested in any one issuer based on the type of investment. Investments issued by or explicitly guaranteed by the U.S. Government and investments in mutual funds, external investment pools, and other pooled investments are exempt from concentration of credit risk disclosures. The General Employees’ Retirement Fund and the Firefighters’ Retirement Fund investment policies limit investment concentration as follows:  Equities – No more than 5% of the Plan’s assets, at the time of purchase, shall be invested in the common stock, capital stock, or convertible stock of any one issuing company, nor shall the aggregate investment in any one issuing company exceed 5% of the outstanding capital stock of the company.  Fixed Income – The value of bonds issued by any single corporation shall not exceed 10% of the Plan’s total fair value.  Other Limitations – Investments in corporate common stock and convertible bonds shall not exceed 75% of the Plan’s assets at fair value, and foreign securities shall not exceed 25% of the Plan’s fair value. The Police Officers’ Retirement Fund investment policy limits investment concentration as follows:  Equities – No more than 5% of the Plan’s assets, at the time of purchase, shall be invested in the common stock, capital stock, or convertible stock of any one issuing company, nor shall the aggregate investment in any one issuing company exceed 5% of the outstanding capital stock of the company.  Fixed Income – The value of bonds issued by any single corporation shall not exceed 3% of the Plan’s total fair value.  Other Limitations – Investments in corporate common stock and convertible bonds shall not exceed 70% of the Plan’s assets at fair value, and foreign securities shall not exceed 25% of the Plan’s fair value. All pension trust fund plans were in compliance with respective investment policies regarding concentration of credit risk as of September 30, 2023. 42  CITY OF FORT WALTON BEACH, FLORIDA NOTES TO THE FINANCIAL STATEMENTS SEPTEMBER 30, 2023 3. DEPOSITS AND INVESTMENTS – CONTINUED Investments – Continued Concentration of Credit Risk – Continued The Beal Memorial Cemetery investment policy limits investment concentrations as follows:  Domestic Equities – No more than 5% of the fair value of the total equity portfolio may be invested in the equity of any one corporation; ownership of the shares of one company shall not exceed 2% of those outstanding and not more than 25% of equity at fair value may be held in any one sector.  International Equities – No more than 5% of the fair value of the total equity portfolio may be invested in the common equity of any one corporation; ownership of the shares of one company shall not exceed 2% of those outstanding and not more than 25% of equity at fair value may be held in any one sector.  Fixed Income Investments – Securities of any one issuer shall not exceed 5% of a total bond portfolio at time of purchase. Investments in Entities That Calculate Net Asset Value (NAV) per Share The fair values of investments in real estate funds and external investment pools held by the pension trust funds are based on the investments’ NAV per share, as provided by the investee. Unfunded Redemption Redemption Fair Value Commitments Frequency Notice Period Real estate funds $ 11,368,580 None Quarterly 0 - 90 days Infrastructure funds 5,432,868 None Quarterly 0 - 90 days The real estate funds consist of three open-ended commingled funds that invest in office, industrial, retail, and multi-family real estate assets throughout the United States. Although the funds are private investments, they can be redeemed on a quarterly basis, subject to available liquidity. The infrastructure funds consist of three open-ended funds that invest in long-duration core infrastructure assets throughout North America, Europe, and Australia. Although the funds are private investments, they can be redeemed on a quarterly basis, subject to available liquidity. 43  CITY OF FORT WALTON BEACH, FLORIDA NOTES TO THE FINANCIAL STATEMENTS SEPTEMBER 30, 2023 4. FAIR VALUE OF INVESTMENTS The City measures and records its investments using fair value measurement guidelines established by generally accepted accounting principles. These guidelines recognize a three-tiered fair value hierarchy, as follow:  Level 1 – Quoted prices (unadjusted) for identical assets in active markets that a government can access at the measurement date.  Level 2 – Inputs other than quoted prices included within Level 1 that are observable for an asset, either directly or indirectly.  Level 3 – Unobservable inputs for an asset. The following table presents the investments carried at fair value on September 30, 2023: Fair Value Level 1 Level 2 Level 3 Money market funds $ 415,395 $ - $ 415,395 $ - Debt securities U.S. Treasury bonds 15,535,668 15,535,668 - - U.S. Government Agency obligations 1,475,788 - 1,475,788 - U.S. Government Agency collateralized mortgage obligations (CMO's) 6,895,765 - 6,895,765 - Corporate bonds 16,229,950 - 16,229,950 - Municipal bonds 2,110,060 - 2,110,060 - Total debt securities 42,247,231 15,535,668 26,711,563 - Equity securities Mutual funds and exchange-traded funds 68,118,821 415,395 67,703,426 - Total equity securities 68,118,821 415,395 67,703,426 - * Infrastructure investment funds 5,432,868 - - - * Real estate investment funds 11,368,580 - - - Total investments measured at fair value 127,582,895 $ 15,951,063 $ 94,830,384 $ - Total investments measured at amortized cost 8,588,345 Total investments at September 30, 2023 $ 136,171,240 * In accordance with GASB 72, certain investments that were measured at NAV per share (or its equivalent) have not been classified in the fair value hierarchy. Money market funds, debt securities, and equity securities classified in Level 2 are determined by broker quotes that utilize matrix pricing models and other observable market inputs. 44  CITY OF FORT WALTON BEACH, FLORIDA NOTES TO THE FINANCIAL STATEMENTS SEPTEMBER 30, 2023 5. RECEIVABLES Receivables on September 30, 2023, were as follows: Governmental Activities Business-Type Activities Other Govt General Funds Utilities Sanitation Stormwater Total Taxes $ 30,934 $ - $ - $ - $ - $ 30,934 Accounts 154,429 - 1,022,420 356,797 78,536 1,612,182 Less allowance for doubtful accounts - - (146,154) (41,507) (10,041) (197,702) Assessments 32,217 - 2,358 - - 34,575 Notes 478,517 - - - - 478,517 Leases receivble 4,042,776 - 84,246 - - 4,127,022 Other - 30 3,827 - - 3,857 Total receivables, net $ 4,738,873 $ 30 $ 966,697 $ 315,290 $ 68,495 $ 6,089,385 During fiscal year 2015, the City sold a building for $462,000 and will receive $442,000 of the proceeds over twelve years ($2,917 monthly payments started November 2014). This note receivable bears interest at 5% per year and includes a balloon payment of $250,065 due to the City in October 2026. The balance of this note receivable is $310,117 as of September 30, 2023. During fiscal year 2014, the City sold a recreational center for $425,000 and will receive the proceeds over twelve years ($3,000 monthly principal only payments started October 2015). The City has calculated imputed interest on the receivable, but it has not been recorded as the imputed amount was deemed to be immaterial to the financial statements. The balance of this note receivable is $128,000 as of September 30, 2023. During