City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 97 Note 8 Long-Term Liabilities A. Governmental Activities The following is a summary of changes in long-term debts for the governmental activities for the year ended June 30, 2024: BalanceJuly 1, 2023 Balance Due within Due in More(As restated) Additions Deletions June 30, 2024 One Year Than One YearGovernmental Activities:Direct Borrowings: Financed purchase - vehicle 1,005,284$ 213,979$ (271,226)$ 948,037$ 308,689$ 639,348$ Financed purchase - fire engine - 1,237,932 (112,270) 1,125,662 231,842 893,820 HUD Section 108 Loan, variable rate, due 2035 586,000 - (50,000) 536,000 50,000 486,000 G3-Sun Ridge- Computer system - 855,235 (171,047) 684,188 171,047 513,141 Lease liabilities - 325,832 (105,479) 220,353 108,580 111,773 Subscription liabilities 987,411 945,328 (838,318) 1,094,421 589,862 504,559 Compensated absences 4,824,476 3,614,453 (3,450,123) 4,988,806 1,447,930 3,540,876 Claims payable 10,023,095 4,835,937 (4,358,929) 10,500,103 1,735,273 8,764,830 Total Governmental Activities17,426,266$ 12,028,696$ (9,357,392)$ 20,097,570$ 4,643,223$ 15,454,347$ Enterprise Financed Purchase The City entered into finance purchase agreements (Master Agreement) with Enterprise Fleet Management Trust for vehicles. At June 30, 2024, the balance on the financed vehicles was $948,037. At the end of the term, the City has the option to purchase the vehicles. The future debt service payments as of June 30, 2024, are as follows: Year EndingJune 30, Principal Interest Total2025 308,689$ 63,425$ 372,114$ 2026 266,253 57,150 323,403 2027 238,979 53,192 292,171 2028 110,415 26,291 136,706 2029 23,701 5,688 29,389 Total 948,037$ 205,746$ 1,153,783$ Financed Purchase Fire Engine On September 29, 2023, the City entered into a finance purchase agreement (Master Agreement) with JP Morgan Equipment Finance for a fire engine, an Enforcer 1500 GPM Pumper Type 1 Fire Engine. The cost of the financed equipment was $1,237,932. The City makes semi-annual payments of $138,916 over a finance period of 66 months, including interest payments at a rate of 5.42 percent. At the end of the term, the equipment becomes the property of the City. The outstanding balance at June 30, 2024, was $1,125,662. The future debt service payments as of June 30, 2024, are as follows: Year EndingJune 30, Principal Interest Total2025 231,842$ 45,991$ 277,833$ 2026 241,930 35,903 277,833 2027 252,458 25,376 277,834 2028 263,443 14,390 277,833 2029 135,989 2,927 138,916 Total 1,125,662$ 124,587$ 1,250,249$
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 98 Note 8 Long-Term Liabilities (Continued) A. Governmental Activities (Continued) HUD Section 108 Loan On August 28, 2015, the City entered into an agreement with the U.S. Department of Housing and Urban Development to borrow up to $1,250,000. The City used these funds to reimburse Axis Community Health, Inc. for construction costs of their new health clinic. In FY 2015/16, the City requested an advance of $950,000 on this loan. Principal payments are due August 1 of each year. Loan payments are made from the Community Development Block Grant Special Revenue Fund. The outstanding balance at June 30, 2024, was $536,000. The City's outstanding notes from direct borrowing related to governmental activities of $536,000 are secured with collateral for a second priority lien on the real property on nine parcels beginning at a point on the northwestern line of Railroad Avenue. Additionally, the direct borrowing related to governmental activities contain a provision that in an event of default, all right, title, and interest of the City in and to the guaranteed loan funds and guaranteed loan funds investment accounts shall immediately vest in the Secretary of Housing and Urban Development for use in making payment on the note. Furthermore, direct borrowing related to governmental activities contains a subjective provision clause that allows the lender to accelerate payment of the principal amount. The future debt service payments as of June 30, 2024, are as follows: Year EndingJune 30, Principal Interest Total2025 50,000$ 15,843$ 65,843$ 2026 50,000 14,491 64,491 2027 50,000 13,092 63,092 2028 50,000 11,659 61,659 2029 50,000 10,195 60,195 2030-2034 250,000 26,964 276,964 2035 36,000 618 36,618 Total 536,000$ 92,862$ 628,862$ HUD Section 108 LoanDirect Borrowing Sun Ridge Purchase Agreement On January 5, 2024, the City entered into a financed purchase agreement with Sun Ridge Systems, Inc. for aided dispatch and Records Management Software. The cost of the financed equipment was $855,235. The City makes annual payments of $188,113 over a finance period of 48 months, including interest payments at a rate of 0.1 percent. At the end of the term, the City will own perpetual licenses to the software. The outstanding balance at June 30, 2024, was $684,188. Principal and interest to maturity are as follows: Year EndingJune 30, Principal Interest Total2025 171,047$ 17,066$ 188,113$ 2026 171,047 17,066 188,113 2027 171,047 17,066 188,113 2028 171,047 17,066 188,113 Total 684,188$ 68,264$ 752,452$
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 99 Note 8 Long-Term Liabilities (Continued) A. Governmental Activities (Continued) Lease Liabilities As of June 30, 2024, the City had one active lease for the use of leased equipment. The lease has interest rate of 2.90 percent. As of June 30, 2024, the remaining lease liability is $220,353. Principal and interest to maturity are as follows: Year Ending June 30, Principal Interest Total2025 108,580$ 4,956$ 113,536$ 2026 111,773 1,764 113,537 Total 220,353$ 6,720$ 227,073$ Subscription Liabilities The City has entered into subscriptions for information technology arrangements. The terms of the arrangements ranges from 12 to 36 months with implicit interest rate ranges from 1.85 percent to 3.33 percent. Principal and interest to maturity are as follows: Year Ending June 30, Principal Interest Total2024 589,862$ 23,812$ 613,674$ 2025 346,846 11,045 357,891 2026 157,713 3,348 161,061 Total 1,094,421$ 38,205$ 1,132,626$ B. Business-Type Activities The following is a summary of changes in long-term debts for the business-type activities for the year ended June 30, 2024: Balance Balance Due within Due in MoreJuly 1, 2023 Additions Deletions June 30, 2024 One Year Than One YearBusiness-type Activities:Direct Borrowings: California clean water SRF loan 9,238,640$ -$ (342,508)$ 8,896,132$ 345,934$ 8,550,198$ Golf course financed purchase agreement 113,957 11,027 (37,524) 87,460 33,057 54,403 Golf course leases - 320,902 (98,977) 221,925 102,077 119,848 Bonds:Water Revenue Bonds, Series 2017 1,900,000 - (1,900,000) - - - Water Revenue Bonds, Series 2024 - 17,275,000 - 17,275,000 400,000 16,875,000 Premium on Water Revenue Bonds, Series 2024 - 1,959,574 - 1,959,574 - 1,959,574 Subscription liabilities 504,169 403,433 (140,104) 767,498 124,958 642,540 Total business-type activities11,756,766$ 19,969,936$ (2,519,113)$ 29,207,589$ 1,006,026$ 28,201,563$
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 100
Note 8 Long-Term Liabilities (Continued) B. Business-Type Activities (Continued) California Clean Water State Revolving Fund (SRF) Loan In June 2015, the City entered into an agreement with the California State Water Resources Control Board for State Revolving Fund project financing in the amount of $19,875,720 to fund the City of Pleasanton Recycled Water Project. The loan is secured by and payable solely from net revenues from the ownership or operation of the Citys Water Enterprise. The agreement also requires that the City maintain and fund a separate account in an amount equal to one year of debt service. The City satisfied the debt service requirement by maintaining $438,935 in restricted cash balance. The agreement was amended in September 2015 to reduce the project funding to $11,317,177. The project was completed in October 2016 and the City had drawn a total of $11,088,917. The loan bears annual interest of 1.0 percent, and principal and interest payments are due October 31 of each year. The outstanding balance at June 30, 2024, was $8,896,132. Annual debt service requirements to maturity are as follows: Year EndingJune 30, Principal Interest Total2025 345,934$ 88,961$ 434,895$ 2026 349,393 85,502 434,895 2027 352,887 82,008 434,895 2028 356,416 78,479 434,895 2029 359,980 74,915 434,895 2030-2034 1,854,621 319,851 2,174,472 2035-2039 1,949,225 700,248 2,649,473 2040-2044 2,048,655 125,817 2,174,472 2045-2047 1,279,021 17,665 1,296,686 Total 8,896,132$ 1,573,446$ 10,469,578$ Direct Borrowing California Clean Water SRF Loan The City's outstanding note from direct borrowings related to business-type activities of $8,896,132 is secured by a lien on and pledge of the Water Enterprise Fund, net water revenues and any water reserve fund. In addition, the agreement contains a subjective acceleration clause that allows the lender to accelerate payment of the entire principal. Golf Course Finance Purchase Agreement On February 10, 2016, the City entered into a finance purchase agreement with U.S. Bancorp Government Leasing and Finance, Inc. (U.S. Bancorp) for golf course maintenance equipment. The cost of the financed equipment was $321,373. The City makes quarterly payments of $16,830 over a finance period of 60 months, including interest payments at a rate of 1.78 percent. At the end of the term, the equipment becomes the property of the City. On August 8, 2018, the City entered into a finance purchase agreement with U.S. Bancorp for golf course maintenance equipment. This is an addendum to the agreement with U.S. Bancorp dated February 10, 2016. The cost of the financed equipment was $119,597.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 101
Note 8 Long-Term Liabilities (Continued) B. Business-Type Activities (Continued) Golf Course Finance Purchase Agreement The City makes quarterly payments of $6,603 over a finance period of 60 months, including interest payments at a rate of 3.86 percent. At the end of the term, the property becomes the property of the City. On September 16, 2021, the City entered into a finance purchase agreement with U.S. Bancorp for golf course maintenance equipment (Property Schedule No. 3). This is an addendum to the agreement with U.S. Bancorp dated February 10, 2016. The cost of the financed equipment was $151,273. The City makes quarterly payments of $7,954 over a finance period of 60 months, including interest payments at a rate of 1.94 percent. At the end of the term, the property becomes the property of the City. On February 14, 2024, the City entered into a finance purchase agreement with Wells Fargo Financial Leasing, Inc. for golf course equipment. The cost of the financed equipment was $11,025. The City makes monthly payments in the amount of $266.50 over a finance period of 48 months, including interest payments at a rate of 0.64 percent. At the end of the term, the property becomes the property of the City. On May 22, 2022, the City entered into an operating lease agreement with Vantage Tag Systems for golf course equipment. The cost of the leased equipment was $133,295. The City makes monthly payments in the amount of $2,352 over a finance period of 60 months, including interest payments at a rate of 0.24 percent. On August 11, 2022, the City entered into an operating lease agreement with Wells Fargo Equipment Finance for golf course operating equipment. The cost of the leased equipment was $279,731. The City makes monthly payments in the amount of $6,600 over a finance period of 45 months, including interest payments at a rate of 0.26 percent. Annual debt service requirements to maturity are as follows: Year EndingJune 30, Principal Interest Total Principal Interest Total2025 33,057$ 1,949$ 35,006$ 102,077$ 5,349$ 107,426$ 2026 33,854 1,162 35,016 92,057 2,170 94,227 2027 18,730 377 19,107 27,791 435 28,226 2028 1,819 47 1,866 - - - Total 87,460$ 3,535$ 90,995$ 221,925$ 7,954$ 229,879$ Direct Borrowing Golf Course LeasesGolf Course Financed PurchaseDirect Borrowing The City's outstanding notes from direct borrowings related to business-type activities of $309,385 are secured by a lien on the financed equipment. The agreements contain (1) a provision that in an event of default, the timing of repayment of outstanding amounts become immediately due, and (2) lessor may require the City to return any or all of the property.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 102
Note 8 Long-Term Liabilities (Continued) B. Business-Type Activities (Continued) Water Revenue Bonds, Series 2017 In February 2017, the City issued $7,100,000 of Water Revenue Bonds, Series 2017 to finance certain improvements for the expansion of the municipal recycled water system of the City. The bonds bear interest at 2.15 percent with interest payments made semi-annually on February 1 and August 1, commencing August 1, 2017. Principal payments are due annually on February 1, commencing February 1, 2018. The Bonds are payable solely from net water revenues. The debt was paid off in April 2024. Water Revenue Bonds, Series 2024 In June 2024, the City issued $17,275,000 of Water Revenue Bonds, to finance certain improvements to the Citys water system. The bonds bear interest at 5.00 percent with interest payments made semi-annually on April 1 and October 1, commencing October 1, 2024. Principal payments are due annually on April 1, commencing April 1, 2025. The Bonds are payable solely from net water revenues. The bonds were priced at a premium, bringing total proceeds to $19,000,000. The outstanding balance at June 30, 2024, was $17,275,000. The bonds are payable from any source of available water funds of the City. Failure to pay any installment of the principal of any bonds and any installment of interest of any bonds constitutes an event of default. The Trustee may, at the written direction of the owners of a majority in aggregate principal amount of the bonds at the time outstanding, declare the principal and interest accrued to be due and payable immediately. Annual debt service requirements to maturity are as follows: Year EndingJune 30, Principal Interest Total2025 400,000$ 712,594$ 1,112,594$ 2026 270,000 843,750 1,113,750 2027 285,000 830,250 1,115,250 2028 300,000 816,000 1,116,000 2029 315,000 801,000 1,116,000 2030-2034 1,820,000 3,753,000 5,573,000 2035-2039 2,320,000 3,250,500 5,570,500 2040-2044 2,960,000 2,609,500 5,569,500 2045-2049 3,780,000 1,791,250 5,571,250 2050-2054 4,825,000 747,000 5,572,000 Total 17,275,000$ 16,154,844$ 33,429,844$
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 103
Note 8 Long-Term Liabilities (Continued) B. Business-Type Activities (Continued) Subscription Liabilities The City has entered into subscriptions for information technology arrangements. The terms of the arrangements ranges from 12 to 144 months with implicit interest rate ranges from 1.85 percent to 3.33 percent. Principal and interest to maturity are as follows: Year EndingJune 30, Principal Interest Total2025 124,958$ 22,685$ 147,643$ 2026 112,203 19,326 131,529 2027 114,391 16,269 130,660 2028 117,511 13,149 130,660 2029 38,559 9,941 48,500 2030-2034 212,939 29,561 242,500 2035-2036 46,937 1,563 48,500 Total 767,498$ 112,494$ 879,992$ C. Debt Without City Commitment Conduit Debt In September 2005, the City issued Variable Rate Demand Certificates of Participation (COP) for the Pleasanton Assisted Living Project (The Parkview) financing in the amount of $19,700,000. The COPs have a final maturity date of November 1, 2040. The assisted living facility is owned and operated by BLPPartnership, Inc. and payments on the COP debt will be made by the corporation from revenues derived from the operation of the facility. The City is not obligated in any manner for repayment of the COPs. Accordingly, the COPs are not reported as a liability in the accompanying basic financial statements. The aggregate amount of conduit debt outstanding as of June 30, 2024, was $14,942,187. D. Legal Debt Limit As of June 30, 2024, the City's debt limit based on the legal debt margin (15 percent of 25 percent of the City's assessed valuation subject to taxation) was $1,149,483,458. E. Arbitrage and Debt Covenant Compliance The Tax Reform Act of 1986 instituted certain arbitrage restrictions with respect to the issuance of tax-exempt bonds after August 31, 1986. Arbitrage regulations pertain to the investment of tax-exempt bond proceeds at an interest yield greater than the interest yield paid to bondholders. Generally, all interest paid to bondholders can be retroactively rendered taxable if applicable rebates are not reported and paid to the U.S. Treasury at least every five years. The City has evaluated each bond issued subject to the arbitrage rebate requirements and has determined that no arbitrage liability exists at June 30, 2024. As of June 30, 2024, the City was in compliance with all bond covenants as they pertain to reserve and sinking fund requirements.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 104
Note 9 Risk Management The City is exposed to various risks of loss related to third party personal injuries and/or damage to property, employment practices liability, workers' compensation claims, and damage to or destruction of City property and vehicles. The City has a self-retained limit for these various risks as shown below in the table. Over the City's self-retained limits, the City has coverage through a number of risk sharing public entity pools. For example, general liability claims over $250,000 are covered through the Bay Cities Joint Powers Insurance Authority (BCJPIA) and the California Affiliated Risk Management Authority (CARMA). Similarly, employment practices liability claims between $75,000 and $1,000,000 are covered through the Employment Risk Management Authority (ERMA) and claims between $1,000,000 and $3,000,000 through Beazley Insurance, a Lloyd Company. In the opinion of City management, premiums paid to BCJPIA (which in turn pays premiums to others including CARMA and ERMA, depending on the risk involved) represent the best available estimate of the ultimate cost of its participation in these various risk sharing pools. The City's self-insured retained limits and maximum coverage for its significant risk sharing public entity pools are as follows: Self-InsuredCoverage Retained Limit Maximum Coverage Maximum Coverage ThroughGeneral Liability 250,000$ 34,500,000$ BCJPIA/CARMAEmployment Practices Liability 75,000 3,000,000 BCJPIA/ERMA/Beazley Insurance, a Lloyd Company Workers' Compensation N/A Up to statutory limit BCJPIA/LAWCXAll Risk Property 10,000 1,000,000,000 BCJPIA/APIPAuto Physical Damage Various Up to replacement cost BCJPIA/APIPCyber Liability 100,000 4,000,000 BCJPIA/APIPCommercial Crime Bond 10,000 3,000,000 BCJPIA/FDCM/GAICWithin the past three fiscal years, all claims that have settled have been within the maximum coverage. The City accounts for and finances its uninsured risks of loss and liability insurance premiums in a Self-Insurance Retention Internal Service Fund, which also includes its Workers Compensation Program. The Workers Compensation Program makes payments needed to pay prior and current year claims and to establish a reserve for future losses. The net position of the Workers Compensation Program at June 30, 2024, had a negative balance of $3,720,781 reflecting a decrease in claims liability from the prior year. The claims liability of $9,676,000 is reported as claims payable as of June 30, 2024. Payments in future years from funds of the City participating in the Workers Compensation Program are anticipated to recover the full cost of the claims liability. In the Self Insurance Retention Internal Service Fund, at June 30, 2024, reserves of $2,145,717 are reported in net position and claims liabilities of $824,103 are reported as claims payable. The Workers' Compensation Program claims liabilities and the general and employment practices claims liabilities in the Self Insurance Retention Fund are based on the results of actuarial studies and include IBNR claims amounts. Claims liabilities are calculated considering the effects of inflation, recent claim settlement trends including frequency and amount of payouts and other economic and social factors.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 105
Note 9 Risk Management (Continued) The aggregate change in the balance of claims liabilities for the internal service funds were as follows: 2024 2023Unpaid claims, beginning of year 10,023,095$ 9,670,859$ Incurred claims and changes in estimates 2,703,850 3,900,330 Claim payments (2,226,842) (3,548,094) Unpaid claims, end of year 10,500,103$ 10,023,095$ Current portion 1,735,273$ 1,737,267$ June 30, Note 10 Membership in Insurance Pool, Investment in Joint Ventures, and Jointly Governed Organization The City participates in nine joint venture activities through formally organized and separate entities established under the Joint Exercise of Powers Act of the State of California. As separate legal entities, these entities exercise full powers and authorities within the scope of the related Joint Powers Agreements including the preparation of annual budgets, accountability for all funds, the power to make and execute contracts and the right to sue and be sued. A. Bay Cities Joint Powers Insurance Authority The City is a member of Bay Cities Joint Powers Insurance Authority (BCJPIA). BCJPIA was created in 1986 to develop effective risk management programs to reduce the amount and frequency of losses, to provide for pooled self-insurance among member agencies and to jointly purchase and provide administrative and other services including, but not limited to claims adjusting, data processing, risk management, loss prevention, accounting services, actuarial services, and legal services in connection with the program. BCJPIA consists of fifteen cities, four towns, one fire authority and one police authority all located within the metropolitan Bay Area. The Citys proportionate share of BCJPIAs net position depends on a number of factors as there are inflows into the Citys account with BCJPIA based on premium deposits and interest earned and there are outflows for expenditures for matters such as administration, claims handling, incurred losses and a reserve for claims incurred but not yet reported (IBNR). Accordingly, it is difficult to ascertain what the Citys proportionate share is at any given time. Nevertheless, if there is excess equity in the Citys account for a program year that is five years old and for which there are no longer any outstanding claims for that program year, the BCJPIA Board of Directors may declare a dividend and distribute such dividend to the member entities based on what is in each members equity account. Financial statements for BCJPIA may be obtained from BCJPIA 1750 Creekside Oaks Drive, Suite 200, Sacramento, California 95833. B. Local Agency Workers' Compensation Excess Joint Powers Authority In 2010, the City joined the Local Agency Workers Compensation Excess Joint Powers Authority (LAWCX). LAWCX was formed on July 1, 1992, as a state-wide joint powers authority to self-insure andpool excess workers compensation losses. LAWCX was established for California self-insured workers compensation joint powers authorities, individual agencies and special districts. LAWCX is governed by a Board of Directors with a representative from each member entity. Financial statements for LAWCX may beobtained from LAWCX, 1750 Creekside Oaks Drive, Suite 200, Sacramento, California 95833.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 106
Note 10 Membership in Insurance Pool, Investment in Joint Ventures, and Jointly Governed Organization (Continued) C. Livermore-Amador Valley Waste Management Agency The Livermore-Amador Valley Waste Management Agency (LAVWMA) was formed in 1974. LAVWMA operates the export pipeline connecting with the East Bay Discharge Authoritys systems and discharges treated wastewater into San Francisco Bay. The current members of the Agency are Dublin San Ramon Services District (DSRSD), the City of Livermore, and the City of Pleasanton. Sewer revenue bonds issued by LAVWMA are being repaid with user charges assessed to member agencies. The City accounts for its investment in LAVWMA by the equity method in the Sewer Enterprise Fund. The City records its share of earnings and losses in the Proprietary Funds Statement of Revenues, Expenses, and Changes in Net Position as "Equity interest in gain from joint ventures, and the carrying value of the City's investment in LAVWMA is recorded in the Proprietary Funds Statement of Net Position as "Net investment in joint ventures." The Citys equity interest in LAVWMA was $19,535,695 as of June 30, 2024. Financial statements for LAVWMA may be obtained from DSRSD, 7051 Dublin Boulevard, Dublin, California 94568. D. Livermore-Amador Valley Transit Authority The Livermore-Amador Valley Transit Authority (LAVTA) was formed in 1985 by a joint exercise of powers agreement between the County of Alameda and the cities of Dublin, Livermore and Pleasanton to provide transportation services within the cities limits and portions of the unincorporated County. LAVTA operates under the name Wheels. Financial statements for LAVTA may be obtained from LAVTA, 1362 Rutan Court, Suite 100, Livermore, California 94551. E. Tri-Valley Transportation Council The Tri-Valley Transportation Council (TVTC) was formed in 1991 by a joint exercise of powers agreement between the cities of Dublin, Livermore, Pleasanton and San Ramon, the Town of Danville and the Counties of Alameda and Contra Costa for the purposes of preparing a transportation plan and providing transportation facilities within the Tri-Valley area. Financial statements for TVTC may be obtained from the Town of Danville, Attn: TVTC Administrator, 500 La Gonda Way, Danville, CA 94526. F. Livermore-Pleasanton Fire Department On December 3, 1996, the cities of Pleasanton and Livermore signed a Joint Powers Agreement (JPA) to form a joint fire department, Livermore-Pleasanton Fire Department (LPFD), covering both cities. On February 12, 2018, the cities signed an amended and restated JPA that, among other things, reinforced the joint obligation to fund retirement benefits including unfunded liabilities. Fire protection services are provided by the City of Pleasanton employees under the joint power agreement. The LPFD prepares its budget, including contributions required from each City, to fund operating and capital needs for the year. In January 2013, the City of Livermore began functioning as Treasurer for LPFD. The City of Pleasantons share of LPFDs costs is approximately 50 percent. The City accounts for its investment in LPFD by the equity method in the Governmental Activities in the Statement of Net Position. During the year ended June 30, 2024, the City contributed $25,080,876 to LPFD representing its share of costs. The Citys equity/(deficit) interest in LPFD was ($40,976,747) as of June 30, 2023 based on the most recent audited financial information of the LPFD.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 107
Note 10 Membership in Insurance Pool, Investment in Joint Ventures, and Jointly Governed Organization (Continued) F. Livermore-Pleasanton Fire Department (Continued) The Citys portion of most recent audited financial information of the LPFD for the fiscal year ended June 30, 2023, is summarized as follows: Assets:Current 4,985,846$ Noncurrent 562,279 Total assets5,548,125 Deferred outflows of resources:Related to pensions 11,820,228 Related to OPEB 2,097,500 Total deferred outflows of resources13,917,728 Liabilities:Current 2,869,285 NoncurrentOther long-term liabilities 4,161,083 Net pension liability 44,828,999 Net OPEB liability 4,083,500 Total liabilities55,942,867 Deferred inflows of resources:Related to pensions 1,074,233 Related to OPEB 3,425,500 Total deferred inflows of resources4,499,733 Net Pension:(40,976,747) Deferred inflows of resources:Revenues 23,538,717 Expenses (23,694,291) Change in net position(155,574) Net Position:Beginning of the year (40,821,173) End of the year (40,976,747)$
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 108
Note 10 Membership in Insurance Pool, Investment in Joint Ventures, and Jointly Governed Organization (Continued) F. Livermore-Pleasanton Fire Department (Continued) The City records its share of earnings and losses in the Livermore-Pleasanton Fire Department Custodial Fund and the carrying value of the City's investment in LPFD is recorded in the Statement of Net Position as "Net Deficit in LPFD". The information related to pension and OPEB are of measurement date June 30, 2023. Financial statements for LPFD may be obtained from the City of Livermore at 1052 South Livermore Avenue, Livermore, California 94550. G. East Bay Regional Communications System Authority In 2007, the City joined the East Bay Regional Communications System Authority (EBRCSA). The EBRCSA was formed to govern the regional communications system servicing Alameda and Contra Costa Counties, as well as many cities and special districts within the East Bay. Currently, there are forty-three agencies consisting of both counties, thirty cities, six special districts, three colleges, Dublin-San Ramon Services District and the California Department of Transportation, serving a population of over 2.5 million people. The EBRCSA is governed by a twenty-three member board of directors selected from participating counties, cities and districts. Financial statements for EBRCSA may be obtained from EBRCSA, 4985 Broder Boulevard, Dublin, California 94568. H. Alameda County Transportation Commission The Alameda County Transportation Commission (ACTC) was formed in 2010 as a result of the merger between the Alameda County Congestion Management Agency (ACCMA) and the Alameda County Transportation Improvement Agency (ACTIA) to more cost effectively plan and deliver transportation programs in Alameda County. Members include the fourteen cities in Alameda County, the five County Board of Supervisors, the Bay Area Rapid Transit District and AC Transit. Financial statements for Alameda CTC may be obtained from ACTC, 1111 Broadway, Suite 800, Oakland, California 94607.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 109
Note 11 Fund Balances As of June 30, 2024, fund balances are composed of the following: CapitalProjects FundMiscellaneousCapital NonmajorGeneralLower IncomeMiscellaneousImprovementGovernmentalFundHousing FundGrants FundPrograms Fund Funds TotalNonspendable: Advances to other funds500,000$ -$ -$ -$ -$ 500,000$ Subtotal 500,000 - - - - 500,000 Restricted:Accessibility programs - - - - 133,382 133,382 Assessment District Construction - - - - 1,108,578 1,108,578 Asset forfeiture - - - - 29,173 29,173 Budgeted Developer Projects - - - - 7,660,480 7,660,480 Community Access Television - - - - 1,536,494 1,536,494 Community Development Block Grants - - - - 522,386 522,386 Geological Hazard Assessment Districts - - - - 1,389,419 1,389,419 Grants - - 1,297,977 - - 1,297,977 Housing - 17,438,063 - - 752,894 18,190,957 Johnson Drive Economic Development Zone - - - - 982,163 982,163 Landscape and Lighting Districts - - - - 435,867 435,867 Landscape Maintenance NPID - - - - 1,090,873 1,090,873 Library Trust - - - - 59,325 59,325 Marilyn Kane Trail Reserve - - - - 115,066 115,066 Miscellaneous Donations/Developer Contributions - - - - 1,512,463 1,512,463 Opioid Settlements - - - - 116,657 116,657 Park Development - - - - 8,885,580 8,885,580 PARS Section 115 Pension Trust 19,474,282 - - - - 19,474,282 Public Facilities Capital Improvements - - - - 1,993,968 1,993,968 Public Safety - - - - 135,695 135,695 Resource Management - - - - 540,708 540,708 Street Maintenance - - - - 19,290,245 19,290,245 Traffic Impact - - - - 10,397,977 10,397,977 Tri-Valley Transportation - - - - 2,307,651 2,307,651 Various Specific Plans - - - - 844,015 844,015 Subtotal 19,474,282 17,438,063 1,297,977 - 61,841,059 100,051,381 Committed: Business Support Program - - - - 2,412,387 2,412,387 COVID Response and Recovery Program Reserve 319,150 - - - - 319,150 Downtown & North Pleasanton - - - - 3,712,832 3,712,832 Mobile Outreach Vehicle Program Reserve 280,000 - - - - 280,000 Strategic Plan Implementation Reserve 379,428 - - - - 379,428 Emergency Reserve 500,000 - - - - 500,000 Rainy Day Reserve 6,620,550 - - - - 6,620,550 Subtotal 8,099,128 - - - 6,125,219 14,224,347 Assigned: Capital Projects - - - 27,796,322 11,410,255 39,206,577 Other Purposes - - - - 738,930 738,930 Subtotal - - - 27,796,322 12,149,185 39,945,507 Unassigned 33,881,954 - - - - 33,881,954 Total 61,955,364$ 17,438,063$ 1,297,977$ 27,796,322$ 80,115,463$ 188,603,189$ Special Revenue Funds
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 110
Note 12 Defined Benefit Pension Plan The City participates in the following Pension Plans administered by the California Public Employees Retirement System (CalPERS): 1. Agent Multiple-Employer Defined Benefit Pension Plans (Agent Multiple) for its Miscellaneous and Safety Fire employees. An agent multiple-employer plan is one in which the assets of the participating government employers are pooled for investment purposes but separate accounts are maintained for each individual employer. 2. Cost-Sharing Multiple-Employer Defined Benefit Pension Plan (Cost Sharing) for its Safety Police employees. A cost-sharing multiple-employer defined benefit pension plan is a plan in which the pension obligations to the employees of more than one employer are pooled and pension plan assets can be used to pay benefits of the employees of any employer that provides pensions through the plan. A. General Information about the Pension Plans and Summary of Balances by Plan Plan Descriptions - All qualified permanent employees are eligible to participate in the City's separate Safety (Police) cost-sharing plan, Safety (Fire) agent multiple-employer defined benefit pension plan, and Miscellaneous (all other) agent multiple-employer defined benefit pension plan that are administered by CalPERS. The Miscellaneous and Safety Fire Plans are agent multiple-employer defined benefit pension plans which act as a common investment and administrative agent for its participating member employers. Benefit provisions under the Plans are established by State statute and City resolution. CalPERS issues publicly available reports that include a full description of the pension plans regarding benefit provisions, assumptions, and membership information that can be found on the CalPERS website. As discussed in Note 10F, the City is a member of a Joint Powers Agreement (JPA), along with the City of Livermore, of the Livermore-Pleasanton Fire Department (LPFD). The employees of the LPFD are the City of Pleasanton's employees, however, as agreed to in the JPA, the City shares the Safety Fire Plan affiliated with the LPFD with the City of Livermore with a share of 50 percent. Based on this arrangement with the City of Livermore, the City of Pleasanton only records its 50 percent share of the collective net pension liability and related deferred inflows/outflows, which is included in its Net Investment (Deficit) in LPFD on the Governmental Activities Statement of Net Position, using the equity method of accounting. Information specific to the City's share of net pension liability and deferred outflows/inflows are included in Note 12D. The City's Safety Police Plan is a cost-sharing multiple-employer defined benefit pension plan administered by CalPERS since the plan has less than 100 active members, commonly referred to as risk pool. The City has two retirement benefit tiers in the Safety Police Plan and a PEPRA classification. Tier 1 is for employees hired prior to January 1, 2013. Tier 2 is for employees hired on or after January 1, 2013. PEPRA is for employees new to CalPERS hired on or after January 1, 2013.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 111
Note 12 Defined Benefit Pension Plan (Continued) A. General Information about the Pension Plans and Summary of Balances by Plan (Continued) Below is a summary of the deferred outflows of resources, net pension liabilities and deferred inflows of resources, by plan: Deferred outflows Net Pension Deferred inflowsof Resources Liability of ResourcesAgent Plans:Miscellaneous 31,931,329$ 126,488,027$ (673,302)$ Safety (Fire) 11,735,146 46,512,254 (655,686) Cost Sharing Plan:Safety (Police) 23,380,712 52,399,265 (3,926,139) Total 67,047,187$ 225,399,546$ (5,255,127)$ Each plan is discussed in detail below. Funding Policy In March 2018, the City established a Section 115 Pension Trust Fund with Public Agency Retirement Services (PARS). PARS, the trust administrator, partners with U.S. Bank and HighMark Capital Management to provide trustee and investment advisory services, respectively. This trust was established to set aside moneys to meet the City's future pension contributions or unfunded liabilities. The fair value on the account at June 30, 2024, was $51.1 million. Financial statements of PARS may be obtained from PARS, 4350 Von Karman Avenue, Suite 100, Newport Beach, California 92660. B. Miscellaneous Plan Benefits Provided CalPERS provides retirement and disability benefits, annual cost of living adjustments and death benefits to plan members, who must be public employees, and their beneficiaries. Benefits are based on years of credited service, equal to one year of full time employment, age and the average of the final one year of compensation for Tier 1 members and the average of the final three years' of compensation for PEPRA members. Members with at least five years of total service are eligible to retire at age 50 with statutorily reduced benefits. All members are eligible for non-duty disability benefits after 10 years of service. The death benefit is one of the following: the Basic Death Benefit, the 1959 Survivor Benefit, or the Optional Settlement 2W Death Benefit. The cost of living adjustments for each plan are applied as specified by the Public Employees' Retirement Law. The plan's provisions and benefits in effect at June 30, 2024, are summarized as follows: Tier 1 PEPRAHire datePrior to January 1, 2013On or afterJanuary 1, 2013Benefit formula 2.7% @ 55 2% @ 62Benefit vesting schedule 5 years of service 5 years of serviceBenefit payments M onthly for life M onthly for lifeRetirement age 50-55 52-67M onthly benefits, as a % of eligible compensation 2.0% to 2.7% 1.0% to 2.5%Required employee contribution rates 8.00% 8.00%Required employer contribution rates 13.41% 13.41%M iscellaneous
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 112
Note 12 Defined Benefit Pension Plan (Continued) B. Miscellaneous Plan (Continued) Employees Covered At June 30, 2022, valuation date, the following employees were covered by the benefit terms of the Miscellaneous Plan: MiscellaneousActive employees 302Transferred employees 114Separated employees 157Retired employees and beneficiaries 460Total 1033 Contributions Section 20814(c) of the California Public Employees' Retirement Law requires that the employer contribution rates for all public employers are determined on an annual basis by the actuary and shall be effective on July 1 following notice of change in the rate. Funding contributions for the plan are determined annually on an actuarial basis as of June 30 by CalPERS. The actuarially determined rate is the estimated amount necessary to finance the costs of benefits earned by employees during the year, with an additional amount to finance any unfunded accrued liability. The City is required to contribute the difference between the actuarially determined rate and the contribution rates of employees. Net Pension Liability The City's net pension liability for the Miscellaneous Plan is measured as the total pension liability, less the pension plan's fiduciary net position. The net pension liability of the plan is measured as of June 30, 2023, using an annual actuarial valuation as of June 30, 2022, rolled forward to June 30, 2023, using standard update procedures. Changes in the Net Pension Liability The changes in the Net Pension Liability for the Miscellaneous Plan are as follows: Total Pension Plan Fiduciary Net Net PensionLiability Position Liability/(Asset)(a) (b) (c) = (a) - (b)Balance at June 30, 2022 (Valuation Date) 341,151,526$ 223,378,142$ 117,773,384$ Changes Recognized for the Measurement Period:Service Cost 6,560,486 - 6,560,486 Interest on the total pension liability 23,622,848 - 23,622,848 Changes of benefit terms 269,560 - 269,560 Changes in assumptions - - - Differences between actual and expected experience 7,067,947 - 7,067,947 Plan to plan resource movement - - - Contribution - employer - 12,386,262 (12,386,262) Contribution - employee - 2,571,878 (2,571,878) Net investment income - 14,012,320 (14,012,320) Benefit payments, including refunds of employee contributions (18,818,315) (18,818,315) - Administrative expense - (164,262) 164,262 Other Miscellaneous Income/(Expense) - - - Net Changes during July 1, 2022 to June 30, 2023 18,702,526 9,987,883 8,714,643 Balance at June 30, 2023 (Measurement Date) 359,854,052$ 233,366,025$ 126,488,027$ Increase (Decrease)Miscellaneous Plan
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 113
Note 12 Defined Benefit Pension Plan (Continued) B. Miscellaneous Plan (Continued) Sensitivity of the Net Pension Liability to Changes in the Discount Rate The following presents the net pension liability of the City for the Miscellaneous Plan, calculated using the discount rate for the Plan, as well as what the City's net pension liability would be if it were calculated using a discount rate that is 1- percentage point lower or 1- percentage point higher than the current rate: Discount Rate Current Discount Discount Rate - 1% (5.90%) Rate (6.90%) + 1% (7.90%)Miscellaneous Plan172,790,082$ 126,488,027$ 88,091,146$ Plan's Net Pension Liability/(Asset) Pension Expenses and Deferred Outflows/Inflows of Resources Related to Pension For the year ended June 30, 2024, the City recognized pension expense of $20,166,599 for the Miscellaneous Plan. At June 30, 2024, the City reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred outflows Deferred inflowsof Resources of ResourcesContribution made after the measurement date 12,700,406$ -$ Changes of assumptions 3,958,543 - Difference between expected and actual experience 4,831,860 (673,302) Net difference between projected and actual earningson pension plan investments 10,440,520 - Total 31,931,329$ (673,302)$ The $12,700,406 reported as deferred outflows of resources related to contributions subsequent to the measurement date for the Miscellaneous Plan will be recognized as a reduction of the net pension liability in the year ending June 30, 2025. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized as future pension expense as follows: Measurement Deferred Outflows/Period (Inflows)Ending June 30 of Resources2024 6,899,229$ 2025 3,843,076 2026 7,564,213 2027 251,103 2028 - Thereafter - 18,557,621$ The expected average remaining service lifetime (EARSL) for the Miscellaneous Plan for the measurement period June 30, 2023, is 3.1 years, which was obtained by dividing the total service years of 3,246 (the sum of remaining service lifetimes of the active employees) by 1,033 (the total number of participants: active, inactive, and retired). Actuarial assumptions and information regarding the discount rate are discussed in Note 12E.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 114
Note 12 Defined Benefit Pension Plan (Continued) C. Safety (Police) Plan Benefits Provided CalPERS provides retirement and disability benefits, annual cost of living adjustments and death benefits to plan members, who must be public employees, and their beneficiaries. Benefits are based on years of credited service, equal to one year of full time employment, age and the average of the final one year of compensation for Tier 1 members and the average of the final three years' of compensation for Tier 2 and PEPRA members. Members with five years of total service are eligible to retire at age 50 with statutorily reduced benefits. All members are eligible for non-duty disability benefits after ten years of service. The death benefit is one of the following: the Basic Death Benefit, the 1959 Survivor Benefit, or the Optional Settlement 2W Death Benefit. The cost of living adjustments for each plan are applied as specified by the Public Employees' Retirement Law. The plan's provisions and benefits in effect at June 30, 2024, are summarized as follows: Tier 1 Tier 2 PEPRABenefit formula 3% @ 50 3% @ 55 2.7% @ 57Benefit vesting schedule 5 years of service 5 years of service 5 years of serviceBenefit payments Monthly for life Monthly for life Monthly for lifeRetirement age 50 50-55 50-57Monthly benefits, as a % of eligible compensation 3%, 50+ yrs 2.4%-3%, 50 yrs - 55+ yrs, respectively2%-2.7%, 50 yrs - 57+ yrs, respectivelyRequired employee contribution rates 9.00% 9.00% 13.75%Required employer contribution rates 27.11% 22.83% 13.54%Safety (Police) Plan Beginning in FY 2016/17, CalPERS collects employer contributions for the cost-sharing plan as a percentage of payroll for the normal cost portion as noted in the rates above and as a dollar amount for contributions toward the unfunded liability and side fund. The City's required contribution for the unfunded liability and side fund was $5,509,599 in FY 2023/24. Employees Covered At June 30, 2022, valuation date, the following employees were covered by the benefit terms of the Miscellaneous Plan: Safety (Police) Safety (Police) Safety (Police)Classic Tier 2 PEPRAActive employees 37 12 30Transferred employees 10 4 3Separated employees 9 4 8Retired employees and beneficiaries 135 3 0Total 191 23 41 Contributions Section 20814(c) of the California Public Employees' Retirement Law requires that the employer contribution rates for all public employers are determined on an annual basis by the actuary and shall be effective on July 1 following notice of change in the rate. Funding contributions for the plan are determined annually on an actuarial basis as of June 30 by CalPERS. The actuarially determined rate is the estimated amount necessary to finance the costs of benefits earned by employees during the year, with an additional amount to finance any unfunded accrued liability. The City is required to contribute the difference between the actuarially determined rate and the contribution rates of employees.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 115
Note 12 Defined Benefit Pension Plan (Continued) C. Safety (Police) Plan (Continued) For the year ended June 30, 2024, the contributions recognized as part of pension expense for the plan were as follows: Safety (Police)Contributions - employer 5,509,599$ Pension Liabilities, Pension Expenses and Deferred Outflows/Inflows of Resources Related to Pensions - As of June 30, 2024, the City reported net pension liabilities for its proportionate shares of the net pension liability of the plan as follows: Total Pension Plan Fiduciary Net PensionLiability Net Position Liability(a) (b) ( c) = (a) - (b)Balance at 6/30/22 (Valuation Date) 195,788,521$ 147,744,466$ 48,044,055$ Balance at 6/30/23 (Measurement Date) 202,386,166 149,986,901 52,399,265 Net Changes during 2022-2023 6,597,645$ 2,242,435$ 4,355,210$ Safety (Police) The City's net pension liability for the plan is measured as the proportionate share of net pension liability. The net pension liability of the plan is measured as of June 30, 2023, and the total pension liability for the plan used to calculate the net pension liability was determined by an actuarial valuation as of June 30, 2022, rolled forward to June 30, 2023, using standard update procedures. The City's proportion of the net pension liability was based on a projection of the City's long-term share of contributions to the pension plan relative to the projected contributions of all participating employers, actuarially determined. The City's proportionate share of the net pension liability for the plan as of June 30, 2022, and 2023 was as follows: Safety (Police)Proportion - June 30, 2022 0.41594%Proportion - June 30, 2023 0.42002%0.00408% Sensitivity of the Proportionate Share of the Net Pension Liability to Changes in the Discount Rate The following presents the City's proportionate share of the net pension liability for the plan, calculated using the discount rate for the plan, as well as what the City's proportionate share of the net pension liability would be if it were calculated using a discount rate that is 1-percentage point lower or 1-percentage point higher than the current rate: Discount Rate Current Discount Discount Rate - 1% (5.90%) Rate (6.90%) + 1% (7.90%)Safety (Police) Plan80,163,046$ 52,399,265$ 29,700,399$ Plan's Net Pension Liability/(Asset)
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 116
Note 12 Defined Benefit Pension Plan (Continued) C. Safety (Police) Plan (Continued) For the year ended June 30, 2024, the City recognized pension expense of $10,124,586 for the Safety (Police) Plan. At June 30, 2024, the City reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred outflows Deferred inflowsof Resources of ResourcesContribution made after the measurement date 5,509,599$ -$ Changes of assumptions 3,058,091 - Difference between expected and actual experience 3,847,072 (329,350) Net difference between projected and actual earningson pension plan investments 7,170,825 - Differences between actual contributions and theproportionate share of contributions - (3,596,789) Adjustments due to difference in proportions 3,795,125 Total 23,380,712$ (3,926,139)$ The $5,509,599 reported as deferred outflows of resources related to contributions subsequent to the measurement date will be recognized as a reduction of the collective net pension liability in the year ending June 30, 2025. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized as future pension expense as follows: Measurement Deferred Outflows/Period (Inflows)Ending June 30 of Resources2024 4,755,451$ 2025 3,306,874 2026 5,682,637 2027 200,012 2028 - Thereafter - 13,944,974$ The expected average remaining service lifetime (EARSL) for the Cost Sharing Safety Plan for the measurement period June 30, 2023, is 3.8 years, which was obtained by dividing the total service years of 600,538 (the sum of remaining service lifetimes of the active employees) by 160,073 (the total number of participants: active, inactive, and retired). Actuarial assumptions and information regarding the discount rate are discussed in Note 12E.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 117
Note 12 Defined Benefit Pension Plan (Continued) D. LPFD Safety (Fire) Plan As discussed in Notes 10F and 12A, the employees of the LPFD are the City of Pleasanton's employees, however, as agreed to in the JPA, the City shares equally the Safety Fire Plan affiliated with the LPFD with the City of Livermore, therefore the following tables show only the City of Pleasanton's 50 percent share. As there is a special funding arrangement with the City of Livermore, the City of Pleasanton only records its 50 percent share of the net pension liability and related deferred inflows/outflows, which is included in its Net Investment (Deficit) in LPFD on the Governmental Activities Statement of Net Position, using the equity method of accounting. Benefits Provided CalPERS provides retirement and disability benefits, annual cost of living adjustments and death benefits to plan members, who must be public employees, and their beneficiaries. Benefits are based on years of credited service, equal to one year of full time employment, age and the average of the final one year of compensation for Tier 1 and Tier 2 members and the average of the final three years' of compensation for Tier 3 and PEPRA members. Members with five years of total service are eligible to retire at age 50 with statutorily reduced benefits. All members are eligible for non-duty disability benefits after ten years of service. The death benefit is one of the following: the Basic Death Benefit, the 1959 Survivor Benefit, or the Optional Settlement 2W Death Benefit. The cost of living adjustments for each plan are applied as specified by the Public Employees' Retirement Law. Tier 1 Tier 2 PEPRABenefit formula 3% @ 50 3% @ 55 2.7% @ 57Benefit vesting schedule 5 years of service 5 years of service 5 years of serviceBenefit payments Monthly for life Monthly for life Monthly for lifeRetirement age 50 50-55 50-57Monthly benefits, as a % of eligible compensation 3%, 50+ yrs 2.4%-3%, 50 yrs - 55+ yrs, respectively2%-2.7%, 50 yrs - 57+ yrs, respectivelyRequired employee contribution rates 9.00% 9.00% 12.00%Required employer contribution rates 20.18% 20.18% 20.18%Safety (Fire) Plan Employees Covered At June 30, 2022, valuation date, the following employees were covered by the benefit terms of the Safety (Fire) Plan: Safety (Fire)Active employees 118Transferred employees 12Separated employees 16Retired employees and beneficiaries 169Total 315
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 118
Note 12 Defined Benefit Pension Plan (Continued) D. LPFD Safety (Fire) Plan (Continued) Contributions Section 20814(c) of the California Public Employees' Retirement Law requires that the employer contribution rates for all public employers are determined on an annual basis by the actuary and shall be effective on July 1 following notice of change in the rate. Funding contributions for the plan are determined annually on an actuarial basis as of June 30 by CalPERS. The actuarially determined rate is the estimated amount necessary to finance the costs of benefits earned by employees during the year, with an additional amount to finance any unfunded accrued liability. The City is required to contribute the difference between the actuarially determined rate and the contribution rates of employees. Net Pension Liability The City's net pension liability for the Safety (Fire) Plan is measured as the total pension liability, less the pension plan's fiduciary net position. The net pension liability of each plan is measured as of June 30, 2023, using an annual actuarial valuation as of June 30, 2022, rolled forward to June 30, 2023, using standard update procedures. Changes in the Net Pension Liability The changes in the Net Pension Liability for the Safety (Fire) Plan (City of Pleasanton only) is as follows: Total Pension Plan Fiduciary Net Net PensionLiability Position Liability/(Asset)(a) (b) (c) = (a) - (b)Balance at June 30, 2022 (Valuation Date) 131,178,900$ 86,349,902$ 44,828,999$ Changes Recognized for the Measurement Period:Service Cost 2,496,745 2,496,745 Interest on the total pension liability 8,977,803 8,977,803 Changes of benefit terms 52,228 52,228 Changes of assumptions - - Difference between expected and actual experience 1,208,237 1,208,237 Plan to plan resource movement - - - Contributions from the employer 4,668,296 (4,668,296) Contributions from employees 1,096,046 (1,096,046) Net investment income 5,350,913 (5,350,913) Benefit payments, including refunds of employee - contributions (7,149,304) (7,149,304) - Administrative expenses - (63,498) 63,498 Other Miscellaneous Income/(Expense) - - - Net Changes during July 1, 2022 to June 30, 2023 5,585,709 3,902,453 1,683,256 Balance at June 30, 2023 (Measurement Date) 136,764,609$ 90,252,355$ 46,512,254$ Safety (Fire) PlanIncrease (Decrease)
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 119
Note 12 Defined Benefit Pension Plan (Continued) D. LPFD Safety (Fire) Plan (Continued) Sensitivity of the Net Pension Liability to Changes in the Discount Rate The following presents the net pension liability of the City of Pleasanton for the Safety (Fire) Plan, calculated using the discount rate for the Plans, as well as what the City's net pension liability would be if it were calculated using a discount rate that is 1-percentage point lower or 1-percentage point higher than the current rate: Discount Rate Current Discount Discount Rate - 1% (5.90%) Rate (6.90%) + 1% (7.90%)Safety (Fire) Plan63,316,698$ 46,512,254$ 32,487,704$ Plan's Net Pension Liability/(Asset) Pension Expenses and Deferred Outflows/Inflows of Resources Related to Pension For the year ended June 30, 2024, the City recognized pension expense of $6,130,982 for the Safety (Fire) Plan. At June 30, 2024, the City reported deferred outflows of resources and deferred inflows of resources related to pensions from the following sources: Deferred outflows Deferred inflowsof Resources of ResourcesContribution made after the measurement date 4,777,708$ -$ Changes of assumptions 1,944,749 - Difference between expected and actual experience 945,577 (655,686) Net difference between projected and actual earningson pension plan investments 4,067,112 - Total 11,735,146$ (655,686)$ The $4,777,708 reported as deferred outflows of resources related to contributions subsequent to the measurement date for the Safety (Fire) Plan (City of Pleasanton only) will be recognized as a reduction of the net pension liability in the year ending June 30, 2025. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to pensions will be recognized as pension expense as follows: Measurement Deferred Outflows/Period (Inflows)Ending June 30 of Resources2024 1,499,656$ 2025 1,276,033 2026 3,257,605 2027 268,458 2028 - Thereafter - 6,301,752$ The expected average remaining service lifetime (EARSL) for the Safety Plan for the measurement period June 30, 2023 is 4.6 years, which was obtained by dividing the total service years of 1,441 (the sum of remaining service lifetimes of the active employees) by 315 (the total number of participants: active, inactive, and retired). Actuarial assumptions and information regarding the discount rate are discussed in Note 12E.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 120
Note 12 Defined Benefit Pension Plan (Continued) E. Information Common to the Miscellaneous and Safety Plans Actuarial Assumptions The total pension liabilities in the June 30, 2023, actuarial valuations were determined using the following actuarial assumptions for the Miscellaneous and Safety Plans: Actuarial Cost MethodActuarial Assumptions:Discount RateInflationSalary IncreasesMortality Rate Table1Post Retirement Benefit IncreaseEntry Age Actuarial Cost Method6.90%2.30%Varies by Entry Age and ServiceDerived using CalPERS Membership Data for all Funds. The lesser of contract COLA or 2.30% until Purchasing PowerProtection Allowance floor on purchasing power applies, 2.30%thereafter.1The mortality table used was developed based on CalPERS-specific data. The probabilities of mortality are based on the 2021CalPERS Experience Study and Review of Actuarial Assumptions. Mortality rates incorporate full generational mortalityimprovement using 80% of Scale MP-2020 published by the Society of Actuaries. For more details on this table, please refer to the2021 experience study report from November 2021 that can be found on the CalPERS website. Long-term Expected Rate of Return The long-term expected rate of return on pension plan investments was determined using a building -block method in which expected future real rates of return (expected returns, net of pension plan investment expense and inflation) are developed for each major asset class. In determining the long-term expected rate of return, CalPERS took into account both short-term and long-term market return expectations. Using historical returns of all of the funds asset classes, expected compound (geometric) returns were calculated over the next 20 years using a building-block approach. The expected rate of return was then adjusted to account for assumed administrative expenses of 10 Basis points. The expected real rates of return by asset class are as follows: Assumed Asset Class1Asset Allocation Real Return1,2Global Equity - Cap-weighed 30.00% 4.54%Global Equity - Non-Cap-weighted 12.00% 3.84%Private Equity 13.00% 7.28%Treasury 5.00% 0.27%Mortgage-backed Securities 5.00% 0.50%Investment Grade Corporates 10.00% 1.56%High Yield 5.00% 2.27%Emerging Market Debt 5.00% 2.48%Private Debt 5.00% 3.57%Real Assets 15.00% 3.21%Leverage -5.00% -0.59%100.00%1 An expected inflation of 2.30% used for this period.2 Figures are based on the 2021 Asset Liability Management Study
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 121
Note 12 Defined Benefit Pension Plan (Continued) E. Information Common to the Miscellaneous and Safety Plans (Continued) Discount Rate The discount rate used to measure the total pension liability was 6.90%. The projection of cash flows used to determine the discount rate assumed that contributions from plan members will be made at the current member contribution rates and that contributions from employers will be made at statutorily required rates, actuarially determined. Based on those assumptions, the Plans fiduciary net position was projected to be available to make all projected future benefit payments of current plan members. Therefore, the long-term expected rate of return on plan investments was applied to all periods of projected benefit payments to determine the total pension liability. Change of Assumptions There were no changes of assumptions in 2023. Pension Plan Fiduciary Net Position Detailed information about the pension plan's fiduciary net position is available in the separately issued CalPERS financial reports. Note 13 Post-Employment Health Care Benefits A. Plan Description and Benefits Provided Through its post- employment health care plan, the City provides post- retirement health care benefits, in accordance with certain employee agreements, to all employees who retire directly from the City. The plan benefit provisions and obligations to contribute are established, or may be amended, by City Council action. The effective date and benefit varies based upon the employee's classification and related memorandum of understanding (MOU). PCEA/AFSCME Local 955 (Pleasanton City Employees' Association) MOU For PCEA employees who service retired before 7/1/2012, the City shall pay 4 percent for each year of service of the City's contribution toward the monthly premium for employee and one dependent at the rate of the lowest cost HMO early retiree plan. Retirees will retire with the same retiree benefit co-pay and plan design as provided to retirees on 6/30/2011. For PCEA employees who were hired prior to 6/1/2011 and retire after 7/1/2012, the City shall pay 4 percent for each year of service of the City's contribution toward the monthly premium for employee and one dependent. The City's contribution for retiree medical is established as the same dollar contribution paid for active employees at the employee plus one rate of the lowest cost HMO early retiree plan. If hired after 6/1/2011, the City shall pay for each year of service equivalent to 4 percent of the City's contribution toward the monthly premium for single coverage. The City's contribution for the retiree medical is established as the same dollar contribution paid for active employees at the single rate of the lowest cost HMO early retiree plan. Retiree health benefits will cease once the employee becomes Medicare eligible.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 122
Note 13 Post-Employment Health Care Benefits (Continued) A. Plan Description and Benefits Provided (Continued) POA (Police Officer's Association) MOU For POA employees who retired prior to 7/1/2009, the City shall pay for each year of service with the City of Pleasanton 4 percent of the monthly premium for employee and one dependent of the City's current Kaiser S-1 Health Plan. For POA employees who were hired prior to 1/1/2009 and retire on or after 7/1/2009, the City shall pay for each year of service with the City of Pleasanton 4 percent of the monthly premium for employee and one dependent of the City's lowest cost HMO health plan. Effective July 1st of each year of the agreement, the monthly contribution paid by the City shall be increased by the same dollar increase in medical insurance as is provided to active employees as set forth in Section 14.1 of the agreement up to the lowest cost HMO two-party rate. If hired after 1/1/2009 and retired from service, the City shall provide the following benefit: Employees who service retire prior to the completion of 20 years of full-time service shall receive 4 percent for each year of service of the single plan rate for the lowest cost HMO. Employees who retire after the completion of the 20 years of full time service will receive 4 percent for each year of service of the two-party rate for the lowest cost HMO. For all employees who are hired on or after 1/1/2012, and retire from service, the City shall provide the following benefit: Commencing upon the date of hire, the employee will be credited with 4 percent for each year of service of the single plan rate for the lowest cost HMO. Upon reaching Medicare eligibility age, the City's contribution toward the medical premium shall cease. IAFF (International Association of Firefighters) MOU For IAFF employees who retired prior to 1/1/2008, the City shall pay for each year of service 4 percent of the monthly premium for employee and one dependent of the City's current Kaiser Health Plan coverage. For IAFF employees who were hired before 7/1/2012 and retire after 1/1/2008, the City shall pay 4 percent for each year of service of the City's contribution toward the monthly premium for employee and one dependent. The City's contribution for retiree medical is established as the same dollar contribution paid for active employees at the employee plus one rate of the lowest cost HMO early retiree plan. If hired on or after 7/1/2012, the City shall pay for each year of service equivalent to 4 percent of the City's contribution toward the monthly premium for single coverage. The City's contribution for retiree medical is established as the same dollar contribution paid for active employees at the single rate of the lowest cost HMO early retiree plan. Retiree health benefits will cease once the employee becomes Medicare eligible. Management and Confidential MOU For Management and Confidential employees hired before 1/1/2009, who retired prior to 7/1/2009, the City shall pay for each year of service 4 percent of the monthly premium for the employee and one dependent of the City's current Kaiser early retiree (under age 65) health plan rate.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 123
Note 13 Post-Employment Health Care Benefits (Continued) A. Plan Description and Benefits Provided (Continued) Management and Confidential MOU (Continued) Managers hired prior to 1/1/2009 who work a minimum of five years as full-time managers with the City of Pleasanton are eligible to count prior years of service completed with another PERS municipal agency toward service requirements for retiree medical benefits. Employees hired before 1/1/2009 who promote to management positions may count prior years of service completed with another PERS municipal agency for the retiree medical benefit. For Management and Confidential employees who were hired prior to 1/21/2009 and retire on a service retirement from the City of Pleasanton, the City shall pay 4 percent for each year of service of the City's contribution toward the monthly premium for employee and one dependent. For all service retirements the formula accelerates beginning with 10 years of service (10 years = 75%, 15 years = 80%, 20 years = 90%, 25 years = 100%). Managers hired prior to 1/1/2009 who work a minimum of five years as a full-time manager with the City of Pleasanton are eligible to count prior years of service completed with another PERS municipal agency toward service requirements for retiree medical benefits. If hired on or after 1/21/2009, the City shall pay 4 percent for each year of service of the City's contribution toward the monthly premium for single coverage. For all service retirements, the formula accelerates beginning with 10 years of service (10 years = 75%, 15 years = 80%, 20 years = 90%, 25 years = 100%). The City's contribution for retiree medical is established as the same dollar contribution paid for active employees at the single rate of the lowest cost HMO early retiree plan. Retiree health benefits including reimbursements will cease once employees become Medicare eligible. In the case where the employee eligible for two-party coverage is deceased, the amount the City is obligated to pay shall be reduced by one half (1/2). If a spouse remarries, the obligations by the City shall terminate. Domestic Partners shall be treated in the same manner as spouses for continuation of benefits. For all employees mentioned above who retire for disability, the City shall pay a percentage of the monthly premium in accordance with the applicable MOU. The City allows retirees to participate in the early retiree medical plan, which at the time of retirement has the same premium rates as active employees. Because the rate is a "blended rate," payments for the active employees include an implied subsidy of what would normally be a higher rate for retirees if the retirees were enrolled in a stand-alone health plan. The premium rate paid by a retiree depends on the retiree's former classification, years of service, and the formula specified in the applicable MOU. Employees Covered by Benefit Terms Membership in the plans consisted of the following at the measurement date of June 30, 2023: Non-Fire FireActive plan members 342 125Inactive employees or beneficiaries currentlyreceiving benefit payments 368 108Inactive employees entitled to but not yet receiving benefit payments 51 10Total 761 243
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 124
Note 13 Post-Employment Health Care Benefits (Continued) B. Funding Policy In April 2011, the City established an Other Post Employment Health Benefit (OPEB) irrevocable trust, the City of Pleasanton Group Account, with the California Employer's Retiree Benefit Trust Program (CERBT) administered by the California Public Employees' Retirement System (CalPERS) as an agent multiple-employer plan. This trust is used to accumulate resources to fund future benefits, however, it does not represent the activities of the plan. Financial statements of CERBT are included in the CalPERS Annual Comprehensive Financial Report (ACFR). Copies of the CalPERS ACFR may be obtained from the CalPERS Executive Office - 400 P Street, Sacramento, California 95814. C. Net OPEB Liability Actuarial Methods and Assumptions The City's net OPEB liability was measured as of June 30, 2023, and the total OPEB liability used to calculate the net OPEB liability was determined by an actuarial valuation dated June 30, 2023, that was rolled forward using standard update procedures to determine the June 30, 2023 total OPEB liability as of June 30, 2023, based on the following actuarial methods and assumptions: Valuation Date June 30, 2023Measurement Date June 30, 2023Actuarial Assumptions:Discount Rates General InflationPayroll GrowthMortality, Retirement, Disability, TerminationMortality ImprovementMedical TrendHealthcare Participation for Future Retirees Current actives - 100%Current retirees - 100% if in payment status, 30% will re-elect at age 65 if not payment status6.25%Non-Medicare - 8.50% for 2025, decreasing to an ultimate rate of 3.45% in 2076Medicare (Non-Kaiser) - 7.50% for 2025, decreasing to an ultimate rate of 3.45% in 2076 Medicare (Kaiser) - 6.25% for 2025, decreasing to an ultimate rate of 3.45% in 2076Scale MP-2021 Projection ScaleCalPERS 2019 Experience Study2.75% per annum, in aggregateMerit - CalPERS 2000-2019 Experience Study2.5% per annum The long-term expected rate of return on OPEB plan investments was determined using a building-block method in which expected future real rates of return (expected returns, net of OPEB plan investment expense and inflation) are developed for each major asset class. These ranges are combined to produce the long-term expected rate of return by weighting the expected future real rates of return by the target asset allocation percentage and by adding expected inflation. The target allocation and best estimates of arithmetic real rates of return for each major asset class are summarized in the following table:
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 125
Note 13 Post-Employment Health Care Benefits (Continued) C. Net OPEB Liability (Continued) Long-TermExpected RealAsset Class Target Allocation Rate of ReturnGlobal Equity 49% 4.56%Fixed Income 23% 1.56%TIPS 5% -0.08%Commodities 3% 1.22%REITs 20% 4.06%Total 100%Assumed Long-term rate of inflation is 2.5%.Long-term expected rate of return is 6.25%. Discount Rate The discount rate used to measure the total OPEB liability was 6.25 percent. The projection of cash flows used to determine the discount rate assumed that City contributions will be made at rates equal to the actuarially determined contribution rates. Based on those assumptions, the OPEB plan's fiduciary net position was projected to be available to make all projected OPEB payments for current active and inactive employees and beneficiaries. Therefore, the long-term expected rate of return on OPEB plan investments was applied to all periods of projected benefit payments to determine the total OPEB liability. D. City of Pleasanton Retiree Healthcare Plan Changes in Net OPEB Liability The changes in the net OPEB liability for the City of Pleasanton Retiree Healthcare Plan is as follows: Total OPEB Plan Fiduciary Net Net OPEBLiability Position Liability/(Asset)(a) (b) (c) = (a) - (b)Balance at June 30, 2022 73,029,000$ 56,335,000$ 16,694,000$ Changes recognized for the measurement period:Service cost 1,252,000 - 1,252,000 Interest 4,515,000 - 4,515,000 Difference between expected and actual experience (897,000) - (897,000) Changes of assumptions 5,105,000 - 5,105,000 Contributions from the employer - 4,081,000 (4,081,000) Net investment income - 3,617,000 (3,617,000) Benefit payments and refunds (4,076,000) (4,076,000) - Administrative expenses - (21,000) 21,000 Net changes during July 1, 2022 to June 30, 2023 5,899,000 3,601,000 2,298,000 Balance at June 30, 2023 (Measurement Date) 78,928,000$ 59,936,000$ 18,992,000$ Increase (Decrease) Detailed information about the OPEB plan's fiduciary net position is available in the separately issued plan financial report that may be obtained from CERBT. The benefit payments and refunds include implied subsidy benefit payments in the amount of $4,076,000.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 126
Note 13 Post-Employment Health Care Benefits (Continued) D. City of Pleasanton Retiree Healthcare Plan Changes in Net OPEB Liability (Continued) Sensitivity of the Net OPEB Liability to Changes in the Discount Rate and Healthcare Cost Trend Rates The following presents the net OPEB liability of the City for the City of Pleasanton Retiree Healthcare Plan, as well as what the City's net OPEB liability would be if it were calculated using a discount rate that is 1-percentage-point lower (5.25%) or 1-percentage-point higher (7.25%) than the current discount rate: Discount Rate Current Discount Discount Rate - 1% (5.25%) Rate (6.25%) + 1% (7.25%)28,598,000$ 18,992,000$ 10,987,000$ Plan's Net OPEB Liability/(Asset) The following presents the net OPEB liability of the City for the City of Pleasanton Retiree Healthcare Plan, as well as what the City's net OPEB liability would be if it were calculated using healthcare cost trend rates that are 1-percentage-point lower or 1-percentage-point higher than the current healthcare cost trend rates: Healthcare Trend Current Healthcare Healthcare Trend Rate -1 Percent Trend Rate 1% Increase10,491,000$ 18,992,000$ 29,226,000$ Plan's Net OPEB Liability/(Asset) OPEB Expense and Deferred Outflows/Inflows of Resources Related to OPEB For the year ended June 30, 2024, the City recognized OPEB income of $2,054,000, a reduction in expense for the City of Pleasanton Retiree Healthcare Plan. At June 30, 2024, the City reported deferred outflows and inflows of resources related to OPEB from the following sources: Deferred outflows Deferred inflowsof Resources of ResourcesEmployer contributions made subsequent to the measurement date 4,286,000$ -$ Differences between expected and actual experience - (6,509,000) Changes in assumptions 4,104,000 (571,000) Net difference between projected and actualearnings on plan investments 3,656,000 - Total 12,046,000$ (7,080,000)$ OPEB Plan The $4,286,000 reported as deferred outflows of resources related to contributions subsequent to the measurement date will be recognized as a reduction of the OPEB liability in the year ending June 30, 2025.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 127
Note 13 Post-Employment Health Care Benefits (Continued) D. City of Pleasanton Retiree Healthcare Plan Changes in Net OPEB Liability (Continued) OPEB Expense and Deferred Outflows/Inflows of Resources Related to OPEB (Continued) Other amounts reported as deferred outflows of resources and deferred inflows of resources related to OPEB will be recognized as part of OPEB expense as follows: Deferred OutflowsMeasurement Period /(Inflows)Ending June 30of Resources2024 (1,635,000)$ 2025 (1,647,000) 2026 3,075,000 2027 804,000 2028 83,000 Thereafter - 680,000$ E. Livermore-Pleasanton Fire Department Retiree Healthcare Plan As discussed in Note 10F, the City is a member of a Joint Powers Agreement (JPA), along with the City of Livermore, of the Livermore-Pleasanton Fire Department (LPFD). The employees of the LPFD are the City of Pleasanton's employees, however, as agreed to in the JPA, the City equally shares the Safety Fire Plan affiliated with the LPFD with the City of Livermore. As there is a special funding arrangement with the City of Livermore, the City of Pleasanton only records its 50 percent share of the collective net OPEB liability and related deferred inflows/outflows, which is included in its Net Investment (Deficit) in LPFD on the Governmental Activities Statement of Net Position, using the equity method of accounting. The changes in the net OPEB liability for the Livermore-Pleasanton Fire Department (LPFD) (City of Pleasanton only) Retiree Healthcare Plan is as follows: Total OPEB Plan Fiduciary Net Net OPEBLiability Position Liability/(Asset)(a) (b) (c) = (a) - (b)Balance at June 30, 2022 16,935,000$ 12,851,500$ 4,083,500$ Changes recognized for the measurement period:Service cost 332,000 - 332,000 Interest 1,056,000 - 1,056,000 Difference between expected and actual experience (688,000) - (688,000) Assumption changes 1,032,000 - 1,032,000 Contributions From the Employer - 759,500 (759,500) Net Investment Income - 825,000 (825,000) Benefit Payments and Refunds (758,500) (758,500) - Administrative Expenses - (4,500) 4,500 Net Changes during July 1, 2022 to June 30, 2023 973,500 821,500 152,000 Balance at June 30, 2023 (Measurement Date) 17,908,500$ 13,673,000$ 4,235,500$ Increase (Decrease)
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 128
Note 13 Post-Employment Health Care Benefits (Continued) E. Livermore-Pleasanton Fire Department Retiree Healthcare Plan (Continued) Sensitivity of the Net OPEB Liability to Changes in the Discount Rate and Healthcare Cost Trend Rates The following presents the City's portion of the net OPEB liability for the LPFD Retiree Healthcare Plan, as well as what City's net OPEB liability would be if it were calculated using a discount rate that is 1-percentage- point lower (5.25%) or 1-percentage-point higher (7.25%) than the current discount rate: Discount Rate Current Discount Discount Rate - 1% (5.25%) Rate (6.25%) + 1% (7.25%)6,440,500$ 4,235,500$ 2,394,000$ Plan's Net OPEB Liability/(Asset) The following presents the City's portion of the net OPEB liability for the LPFD Retiree Healthcare Plan, as well as what the City's net OPEB liability would be if it were calculated using healthcare cost trend rates that are 1-percentage- point lower or 1-percentage-point higher than the current healthcare cost trend rates: Healthcare Trend Current Healthcare Healthcare Trend Rate -1 Percent Trend Rate 1% Increase2,244,500$ 4,235,500$ 6,631,500$ Plan's Net OPEB Liability/(Asset) OPEB Expense and Deferred Outflows/Inflows of Resources Related to OPEB For the year ended June 30, 2024, the City recognized OPEB expense of $62,000 for the LPFD Retiree Healthcare Plan. At June 30, 2024, the City reported deferred outflows and inflows of resources related to OPEB from the following sources: Deferred outflows Deferred inflowsof Resources of ResourcesEmployer contributions made subsequent to the measurement date 547,500$ -$ Differences between expected and actual experience - (2,992,000) Changes in assumptions 1,065,000 (113,000) Net difference between projected and actualearnings on plan investments 833,000 - Total 2,445,500$ (3,105,000)$ OPEB Plan
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 129
Note 13 Post-Employment Health Care Benefits (Continued) E. Livermore-Pleasanton Fire Department Retiree Healthcare Plan (Continued) OPEB Expense and Deferred Outflows/Inflows of Resources Related to OPEB (Continued) The $547,500 reported as deferred outflows of resources related to contributions subsequent to the measurement date will be recognized as a reduction of the OPEB liability in the year ending June 30, 2025. Other amounts reported as deferred outflows of resources and deferred inflows of resources related to OPEB will be recognized as part of OPEB expense as follows: Deferred OutflowsMeasurement Period /(Inflows)Ending June 30of Resources2024 (568,000)$ 2025 (560,000) 2026 (13,500) 2027 (134,500) 2028 55,000 Thereafter 14,000 (1,207,000)$ Note 14 Commitments and Contingencies A. Animal Shelter The County of Alameda owns and operates the East County Animal Shelter. The facility was placed in service during FY 1995/96. The cities of Pleasanton, Dublin and Livermore and the County of Alameda (County) shared in the cost of the animal shelter constructed on County property. The cities pay their pro rata share of the operating costs based on their usage of the animal shelter. The Citys share of FY 2023/24 operating costs for the facility was $151,393. B. Lawsuits in the Normal Course of Business The City is presently involved in certain matters of litigation that have arisen in the normal course of conducting City business. City management believes, based upon consultation with the City Attorney, that these cases, in the aggregate, are not expected to result in a material adverse financial impact on the City. Additionally, City management believes that the Citys risk sharing programs are sufficient to cover any potential losses should an unfavorable outcome materialize. C. LAVWMA Bonds The City has recorded an investment in joint venture for its participation in the Livermore-Amador Valley Water Management Agency (LAVWMA). LAVWMA issued $105,345,000 of the 2011 Sewer Revenue Refunding Bonds (2011 Bonds) on September 28, 2011, to refinance the costs of improvements to the wastewater disposal system, including the Export Pipeline Expansion/Rehabilitation Project originally constructed with bonds issued in 2001. The 2011 Bonds are secured by the pledge of the net revenues of the Agency. The Citys contribution to debt service is limited to sewer connection fees collected on behalf of LAVWMA.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 130
Note 14 Commitments and Contingencies (Continued) D. Construction Commitments The City had several outstanding or planned construction projects as of June 30, 2024. These projects are evidenced by contractual commitments with consultants and contractors, and include the following major projects: Project DescriptionAmountJohnson Drive Economic Development Zone (Costco)* 8,804,844$ Near-term Water Improvements 7,457,313 Annual Street Resurfacing and Preventative Maintenance 6,547,068 Sunol Boulevard/I-680 Interchange Improvements 4,543,036 Hopyard Road and Owens Drive Intersection Improvements 4,183,298 West Las Positas Boulevard Multimodal Reconstruction 2,249,379 33,784,938$ *The Transportation and Cost Allocation Agreement for the Johnson Drive EconomicDevelopment ("JDEDZ") reflected above shows the City's commitment portion to theCostco development project. It should be noted that the amount and agreement presentedto Council and established in 2018 were presented as preliminary and estimated totalproject costs; since then, project costs and estimates have increased.
City of Pleasanton Notes to the Basic Financial Statements (Continued) For the Year Ended June 30, 2024 131
Note 15 Changes to or within the Financial Reporting Entity and Error Corrections During scal year 2024, changes to or within the nancial reporting entity restatements and error corrections of beginning net position and fund net position are as follows: June 30, 2023 Change to or withinAs Previously the Financial ReportingError June 30, 2023Reported Entity Corrections As RestatedGovernment-WideGovernmental Activities 585,334,316$ -$ (20,297,428)$ 565,036,888$ Business-Type Activities 202,855,910 - (242,715) 202,613,195 Total primary government 788,190,226$ -$ (20,540,143)$ 767,650,083$ Governmental Funds:Major Funds:Lower Income Housing Fund 13,116,518$ -$ 3,012,389$ 16,128,907$ Miscellaneous Grants Fund - 690,720 - 690,720 Nonmajor Funds 69,830,248 (690,720) 3,078,620 72,218,148 Total Governmental Funds 82,946,766$ -$ 6,091,009$ 89,037,775$ Proprietary Funds:Major Funds:Water Enterprise Fund 84,389,526$ -$ 1,674$ 84,391,200$ Sewer Enterprise Fund 75,856,341 - 34,047 75,890,388 Nonmajor Funds 1,647,293 - (278,436) 1,368,857 Internal Service Funds (65,537,651) - (141,108) (65,678,759) Total Proprietary Funds 96,355,509$ -$ (383,823)$ 95,971,686$ Fiduciary Funds:Custodial Funds (2,645,711)$ -$ 9,529,000$ 6,883,289$ The error corrections are resulted from below by different opinion units: Governmental Activities are related to the loan related allowance, receivable write off, and finance purchase corrections which involved capital assets and financed-purchase liabilities corrections. Business-Type Activities are related to the finance purchase corrections which involved capital assets and financed-purchase liabilities corrections. Governmental Funds are related to the loan related allowance, receivable write off, as well as correcting the loan related unavailable revenue. Proprietary funds are related to the capital assets and financed-purchase liabilities corrections. Custodial funds are related to removing the claims payable long-term liabilities.
132
This page intentionally left blank.
REQUIRED SUPPLEMENTARY INFORMATION(UNAUDITED)
133
This page intentionally left blank.
134
General FundVariance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES:Taxes 124,910,400$ 125,758,400$ 126,812,309$ 1,053,909$ Assessments - - - -Licenses and permits 3,217,000 3,217,000 3,914,590 697,590Intergovernmental 468,000 544,000 1,293,318 749,318Franchises 3,105,000 3,105,000 3,440,134 335,134Charges for services 1,531,200 1,541,200 1,369,709 (171,491)Use of money and property 490,000 490,000 4,027,009 3,537,009 Fines and forfeitures 202,000 202,000 176,156 (25,844) Plan check fees 2,490,000 1,540,000 2,007,539 467,539 Contributions 7,000 7,000 50,612 43,612 Development fees 490,500 490,500 224,214 (266,286) Miscellaneous 9,517,992 9,546,527 10,280,673 734,146 Total revenues146,429,092 146,441,627 153,596,263 7,154,636 EXPENDITURES:Current:General government 26,379,994 28,513,695 24,931,058 3,582,637 Public safety 63,415,886 66,080,840 64,105,373 1,975,467 Community development 12,391,918 11,690,159 10,323,389 1,366,770 Public works 28,735,223 29,705,146 29,672,059 33,087 Community activities 16,222,111 16,654,701 16,028,593 626,108 Capital outlay 503,000 446,473 1,484,449 (1,037,976) Debt service:Principal 5,000 5,000 991,828 (986,828) Interest - - 59,733 (59,733) Total expenditures147,653,132 153,096,014 147,596,482 5,499,532 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(1,224,040) (6,654,387) 5,999,781 12,654,168 OTHER FINANCING SOURCES (USES):Transfers in 1,743,780 1,743,780 1,751,842 8,062 Transfers out (3,275,628) (4,260,284) (4,260,284) - Inception of lease and subscription liability - - 1,178,880 1,178,880 Total other financing sources (uses)(1,531,848) (2,516,504) (1,329,562) 1,186,942 NET CHANGE IN FUND BALANCE(2,755,888)$ (9,170,891)$ 4,670,219 13,841,110$ FUND BALANCE:Beginning of year 57,285,145 End of year 61,955,364$ City of PleasantonRequired Supplementary Information (Unaudited)Budgetary Comparison Schedule For the Year Ended June 30, 2024Budgeted Amounts 135
Lower Income Housing Special Revenue FundVariance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES:Use of money and property 470,000$ 470,000$ 1,782,160$ 1,312,160$ Development fees 1,750,000 1,750,000 333,208 (1,416,792)Miscellaneous 160,000 160,000 272 (159,728)Total revenues2,380,000 2,380,000 2,115,640 (264,360) EXPENDITURES:Current:Community development 937,524 1,182,947 806,484 376,463 Total expenditures937,524 1,182,947 806,484 376,463 NET CHANGE IN FUND BALANCE1,442,476$ 1,197,053$ 1,309,156 112,103$ FUND BALANCE:Beginning of year, as restated (Note 15) 16,128,907 End of Year 17,438,063$ City of PleasantonRequired Supplementary Information (Unaudited)Budgetary Comparison ScheduleFor the Year Ended June 30, 2024Budgeted Amounts 136
Miscellaneous Grants Special Revenue FundVariance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 652,570$ 12,023,206$ 5,433,296$ (6,589,910)$ Use of money and property 29,000 29,000 38,870 9,870Total Revenues681,570 12,052,206 5,472,166 (6,580,040) EXPENDITURES:Current:Public safety 126,910 166,910 60,094 106,816 Community development - 644,361 94,314 550,047 Community activities 160,500 166,262 129,661 36,601 Capital outlay 4,229,502 12,260,015 4,580,840 7,679,175 Total Expenditures4,516,912 13,237,548 4,864,909 8,372,639 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(3,835,342) (1,185,342) 607,257 1,792,599 NET CHANGE IN FUND BALANCE(3,835,342)$ (1,185,342)$ 607,257 1,792,599$ FUND BALANCE:Beginning of year 690,720 End of year 1,297,977$ Budgeted AmountsCity of PleasantonRequired Supplementary Information (Unaudited)Budgetary Comparison Schedule For the Year Ended June 30, 2024 137
This page intentionally left blank.
138
City of PleasantonRequired Supplementary Information (Unaudited)Notes to the Budgetary Comparison SchedulesFor the Year Ended June 30, 2024Budget and Budgetary AccountingBudgetary InformationThe following procedures are performed by the City in establishing the budgetary data reflected in the basic financialstatements:1. Prior to July 1 of every odd numbered year, the City Manager submits to the City Council a proposed two-yearoperating budget for the subsequent two fiscal years. The operating budget includes proposed expenditures and projectedrevenues.2. Public hearings are conducted to obtain public comments.3. The budget is legally adopted through passage of a Council resolution.4. The transfer of budgeted amounts between funds must be approved by the City Council.5. A budget review is presented to the City Council by the City Manager mid-year and approved.6.A budget review is presented to the City Council by the City Manager for the second year of the two-year budget andapproved.7.After adoption, thebudgetis transferred to the general ledgerfor staff to manage expenses andrevenues against thebudget.8.Thebudgetedfunds are adopted on abasis consistent with generally accepted accountingprinciples in the UnitedStates.9.Expenditures may not legally exceed budgeted appropriations at the fund level. Management does not have theauthority to amend the budget without the approval of the City Council. However, the City Manager may authorizetransfers from one account to another within the same fund.10. The City did not adopt a budget for the Library Trust Special Revenue Fund for the fiscal year ended June 30, 2024.Excess of Expenditures Over AppropriationsExpenditures exceeded appropriations in the AB1379 CASp Certification and Training Special Revenue Fund by$5,907. Sufficient funds are available in the fund to cover the costs.139
Measurement period 2022-23 2021-22 2020-21 2019-20 2018-19Total pension liabilityService cost 6,560,486$ 6,535,478$ 5,876,564$ 5,723,859$ $ 5,641,356 Interest 23,622,848 22,361,074 21,730,715 20,882,221 20,052,323 Changes of benefit terms 269,560 - - - - Changes of assumptions - 10,556,117 - - -Differences between expected and actual experience 7,067,947 (1,795,474) 702,330 568,594 6,305,281 Benefit payments, including refunds of employee contributions (18,818,315) (17,101,661) (15,998,179) (15,037,274) (14,355,824) Net change in total pension liability18,702,526 20,555,534 12,311,430 12,137,400 17,643,136 Total pension liability - beginning341,151,526 320,595,992 308,284,562 296,147,162 278,504,026 Total pension liability - ending (a)359,854,052$ 341,151,526$ 320,595,992$ 308,284,562$ 296,147,162$ Pension fiduciary net positionContributions - employer 12,386,262$ 11,399,801$ 10,488,757$ 9,500,835$ 8,420,069$ Contributions - employee 2,571,878 2,424,706 2,341,839 2,374,586 2,216,373 Net investment income 14,012,320 (18,614,805) 45,976,982 9,803,632 12,305,193 Benefit payments, including refunds of employee contributions (18,818,315) (17,101,661) (15,998,179) (15,037,274) (14,355,824) Net Plan to Plan Resource Movement(164,262) - - - -Administrative expense- (152,884) (202,601) (276,948) (134,160) Other Miscellaneous Income/(Expense)1- - - - 437 Net change in plan fiduciary net position9,987,883 (22,044,843) 42,606,798 6,364,831 8,452,088 Plan fiduciary net position - beginning2223,378,142 245,422,985 202,816,187 196,451,356 187,999,268 Plan fiduciary net position - ending (b)233,366,025$ 223,378,142$ 245,422,985$ 202,816,187$ 196,451,356$ Plan net pension liability - ending (a) - (b)126,488,027$ 117,773,384$ 75,173,007$ 105,468,375$ 99,695,806$ Plan fiduciary net position as a percentage64.85% 65.48% 76.55% 65.79% 66.34%of the total pension liabilityCovered payroll332,269,976$ 31,210,496$ 30,480,102$ 29,158,730$ 28,365,628$ Plan net pension liability as a percentage of covered payroll391.97% 377.35% 246.63% 361.70% 351.47%Notes to Schedule:
City of PleasantonRequired Supplementary Information (Unaudited) Schedule of Changes in the Net Pension Liability and Related Ratios 3Includes one years payroll grow th using 2.80% payroll grow th assumption for fiscal years ended in 2022 and 2023; 2.75% payroll grow th assumption for fiscalyears ended in 2018 through 2021; 3.00% payroll grow th assumption for fiscal years ended in 2014 through 2017.
For the Year Ended June 30, 2024Last Ten Fiscal YearsAgent Multiple-Employer Defined Benefit Pension Plan - Miscellaneous Plan 1During Fiscal Year 2017-18, as a result of Governmental Accounting Standards Board Statement (GASB) No. 75, Accounting and Financial Reporting forPostemployment Benefit Plans Other than Pensions (GASB 75), CalPERS reported its proportionate share of activity related to postemployment benefits forparticipation in the State of Californias agent OPEB plan. Accordingly, CalPERS recorded a one-time expense as a result of the adoption of GASB 75. Additionally,CalPERS employees participate in various State of California agent pension plans and during Fiscal Year 2017 -18, CalPERS recorded a correction to previouslyreported financial statements to properly reflect its proportionate share of activity related to pensions in accordance with GASB Statement No. 68, Accounting andFinancial Reporting for Pensions (GASB 68).2 Includes any beginning of year adjustment.Changes of Benefit Terms: The figures above generally include any liability impact that may have resulted from voluntary benefit changes that occurre d on or beforethe Measurement Date. However, offers of Two Years Additional Service Credit (a.k.a. Golden Handshakes) that occurred after the Valuation Date are not includedin the figures above, unless the liability impact is deemed to be material by the plan actuaryChanges of Assumptions: There were no assumption changes in 2023. Effective with the June 30, 2021 valuation date (June 30, 2022 measurement date), theaccounting discount rate was reduced from 7.15% to 6.90%. In determining the long-term expected rate of return, CalPERS took into account long-term marketreturn expectations as well as the expected pension fund cash flows. In addition, demographic assumptions and the price inflation assumption were changed inaccordance with the 2021 CalPERS Experience Study and Review of Actuarial Assumptions. The accounting discount rate was 7.15% for measurement dates June30, 2017 through June 30, 2021, 7.65% for measurement dates June 30, 2015 through June 30, 2016, and 7.50% for measurement date June 30, 2014. 140
Measurement period 2017-18 2016-17 2015-16 2014-15 2013-14Total pension liabilityService cost 5,553,995$ 5,161,399$ 4,642,360$ 4,620,237$ 4,784,381$ Interest 18,845,304 18,145,556 17,579,426 16,848,783 16,162,509 Changes of benefit terms - - - - - Changes of assumptions (1,677,841) 14,750,758 - (4,043,655) - Differences between expected and actual experience 939,844 (892,842) (600,717) (1,853,569) - Benefit payments, including refunds of employee contributions (13,377,947) (12,579,145) (12,124,179) (10,532,758) (9,911,617) Net change in total pension liability10,283,355 24,585,726 9,496,890 5,039,038 11,035,273 Total pension liability - beginning268,220,671 243,634,945 234,138,055 229,099,017 218,063,744 Total pension liability - ending (a)278,504,026$ 268,220,671$ 243,634,945$ 234,138,055$ 229,099,017$ Pension fiduciary net positionContributions - employer 7,497,182$ 6,881,221$ 7,313,803$ 12,476,826$ 6,912,621$ Contributions - employee 2,169,969 2,201,929 1,841,400 1,936,755 1,956,863 Net investment income 15,054,343 18,392,392 995,694 3,697,901 23,466,228 Benefit payments, including refunds of employee contributions (13,377,947) (12,579,145) (12,124,179) (10,532,758) (9,911,617) Net Plan to Plan Resource Movement(437) - - 47 -Administrative expense(276,528) (240,366) (100,483) (185,591) - Other Miscellaneous Income/(Expense)1(525,132) - - - -Net change in plan fiduciary net position10,541,450 14,656,031 (2,073,765) 7,393,180 22,424,095 Plan fiduciary net position - beginning2177,457,818 162,801,787 164,875,552 157,482,372 135,058,277 Plan fiduciary net position - ending (b)187,999,268$ 177,457,818$ 162,801,787$ 164,875,552$ 157,482,372$ Plan net pension liability - ending (a) - (b)90,504,758$ 90,762,853$ 80,833,158$ 69,262,503$ 71,616,645$ Plan fiduciary net position as a percentage67.50% 66.16% 66.82% 70.42% 68.74%of the total pension liabilityCovered payroll327,648,324$ 25,556,540$ 25,673,931$ 25,009,403$ 24,742,104$ Plan net pension liability as a percentage of covered payroll327.34% 355.15% 314.85% 276.95% 289.45% City of PleasantonRequired Supplementary Information (Unaudited) Schedule of Changes in the Net Pension Liability and Related Ratios (Continued)For the Year Ended June 30, 2024Last Ten Fiscal YearsAgent Multiple-Employer Defined Benefit Pension Plan - Miscellaneous Plan (Continued) 141
Measurement period 2022-23 2021-22 2020-21 2019-20 2018-19Total pension liabilityService cost 4,993,490$ 4,807,206$ 4,598,453$ 4,298,858$ $ 4,160,503 Interest 17,955,605 17,212,474 16,797,644 16,332,352 15,816,781 Changes of benefit terms 104,456 Changes of assumptions - 7,425,405 - - -Differences between expected and actual experience 2,416,474 (1,310,737) (1,653,484) (711,914) 2,043,232 Benefit payments, including refunds of employee contributions (14,298,608) (13,428,832) (12,753,324) (12,486,579) (11,760,936) Net change in total pension liability11,171,417 14,705,516 6,989,289 7,432,717 10,259,580 Total pension liability - beginning262,357,800 247,652,284 240,662,995 233,230,278 222,970,698 Total pension liability - ending (a)273,529,217$ 262,357,800$ 247,652,284$ 240,662,995$ 233,230,278$ Pension fiduciary net positionContributions - employer $9,336,592 8,674,723$ 8,417,815$ 7,673,223$ 6,628,841$ Contributions - employee 2,192,091 1,971,096 2,075,602 1,916,617 1,764,603 Net investment income 10,701,826 (14,383,039) 35,672,512 7,564,086 9,564,819 Benefit payments, including refunds of employee contributions (14,298,608) (13,428,832) (12,753,324) (12,486,579) (11,760,936) Net Plan to Plan Resource Movement- - - - -Administrative expense (126,995) (118,349) (156,562) (214,671) (104,319) Other Miscellaneous Income/(Expense)1- - - - 340 Net change in plan fiduciary net position7,804,906 (17,284,401) 33,256,043 4,452,676 6,093,348 Plan fiduciary net position - beginning2172,699,803 189,984,204 156,728,161 152,275,485 146,182,137 Plan fiduciary net position - ending (b)180,504,709$ 172,699,803$ 189,984,204$ 156,728,161$ 152,275,485$ Plan net pension liability - ending (a) - (b)93,024,508$ 89,657,997$ 57,668,080$ 83,934,834$ 80,954,793$ City Share (50%)46,512,254$ 44,828,999$ 28,834,040$ 41,967,417$ 40,477,397$ Plan fiduciary net position as a percentage65.99% 65.83% 76.71% 65.12% 65.29%of the total pension liabilityCovered payroll317,521,016$ 16,423,661$ 16,924,746$ 15,581,217$ 14,695,194$ Plan net pension liability as a percentage of covered payroll530.93% 545.91% 340.73% 538.69% 550.89%Notes to Schedule:
City of PleasantonRequired Supplementary Information (Unaudited) Schedule of Changes in the Net Pension Liability and Related RatiosFor the Year Ended June 30, 2024Last Ten Fiscal YearsAgent Multiple-Employer Defined Benefit Pension Plan - Safety (Fire) Plan 1During Fiscal Year 2017-18, as a result of Governmental Accounting Standards Board Statement (GASB) No. 75, Accounting and Financial Reporting forPostemployment Benefit Plans Other than Pensions (GASB 75), CalPERS reported its proportionate share of activity related to postemployment benefits forparticipation in the State of Californias agent OPEB plan. Accordingly, CalPERS recorded a one-time expense as a result of the adoption of GASB 75. Additionally,CalPERS employees participate in various State of California agent pension plans and during Fiscal Year 2017 -18, CalPERS recorded a correction to previouslyreported financial statements to properly reflect its proportionate share of activity related to pensions in accordance with GASB Statement No. 68, Accounting andFinancial Reporting for Pensions (GASB 68).2 Includes any beginning of year adjustment.3Includes one years payroll grow th using 2.80% payroll grow th assumption for fiscal years ended in 2022 and 2023; 2.75% payroll grow th assumption for fiscalyears ended in 2018 through 2021; 3.00% payroll grow th assumption for fiscal years ended in 2014 through 2017.Changes of Benefit Terms: The figures above generally include any liability impact that may have resulted from voluntary benefit changes that occurre d on or beforethe Measurement Date. However, offers of Two Years Additional Service Credit (a.k.a. Golden Handshakes) that occurred after the Valuation Date are not includedin the figures above, unless the liability impact is deemed to be material by the plan actuary.Changes of Assumptions: There were no assumption changes in 2023. Effective with the June 30, 2021 valuation date (June 30, 2022 measurement date), theaccounting discount rate was reduced from 7.15% to 6.90%. In determining the long-term expected rate of return, CalPERS took into account long-term marketreturn expectations as well as the expected pension fund cash flows. In addition, demographic assumptions and the price inflation assumption were changed inaccordance with the 2021 CalPERS Experience Study and Review of Actuarial Assumptions. The accounting discount rate was 7.15% for measurement dates June30, 2017 through June 30, 2021, 7.65% for measurement dates June 30, 2015 through June 30, 2016, and 7.50% for measurement date June 30, 2014. 142
Measurement period 2017-18 2016-17 2015-16 2014-15 2013-14Total pension liabilityService cost 4,233,715$ 4,380,642$ 3,675,812$ 3,440,755$ 3,647,581$ Interest 15,101,959 14,640,730 14,305,583 13,761,314 13,303,540 Changes of benefit termsChanges of assumptions (592,040) 11,484,814 - (3,164,073) -Differences between expected and actual experience (1,188,776) (1,709,382) (250,882) (1,720,368) -Benefit payments, including refunds of employee contributions (10,928,666) (10,503,998) (10,185,743) (9,722,438) (9,192,267) Net change in total pension liability6,626,192 18,292,806 7,544,770 2,595,190 7,758,854 Total pension liability - beginning216,344,506 198,051,700 190,506,930 187,911,740 180,152,886 Total pension liability - ending (a)222,970,698$ 216,344,506$ 198,051,700$ 190,506,930$ 187,911,740$ Pension fiduciary net positionContributions - employer 6,172,990$ 6,071,682$ 5,361,714$ 4,930,309$ 4,539,230$ Contributions - employee 1,765,387 1,551,969 1,391,002 1,221,550 1,168,645 Net investment income 11,736,933 14,098,740 671,305 2,855,434 19,743,524 Benefit payments, including refunds of employee contributions (10,928,666) (10,503,998) (10,185,743) (9,722,438) (9,192,267) Net Plan to Plan Resource Movement(340) - - (285) -Administrative expense (215,135) (187,549) (79,149) (146,155) -Other Miscellaneous Income/(Expense)1(408,545) - - - -Net change in plan fiduciary net position8,122,624 11,030,844 (2,840,871) (861,585) 16,259,132 Plan fiduciary net position - beginning2138,059,513 127,028,669 129,869,540 130,731,125 114,471,993 Plan fiduciary net position - ending (b)146,182,137$ 138,059,513$ 127,028,669$ 129,869,540$ 130,731,125$ Plan net pension liability - ending (a) - (b)76,788,561$ 78,284,993$ 71,023,031$ 60,637,390$ 57,180,615$ City Share (50%)38,394,281$ 39,142,497$ 35,511,516$ 30,318,695$ 28,590,308$ Plan fiduciary net position as a percentage65.56% 63.81% 64.14% 68.17% 69.57%of the total pension liabilityCovered payroll314,858,791$ 15,376,607$ 14,128,499$ 13,131,650$ 13,543,667$ Plan net pension liability as a percentage of covered payroll516.79% 509.12% 502.69% 461.77% 422.19% City of PleasantonRequired Supplementary Information (Unaudited) Schedule of Changes in the Net Pension Liability and Related Ratios (Continued)For the Year Ended June 30, 2024Last Ten Fiscal YearsAgent Multiple-Employer Defined Benefit Pension Plan - Safety (Fire) Plan (Continued) 143
Measurement period 2022-23 2021-22 2020-21 2019-20 2018-19Safety (Police)Plan's proportion of the Net Pension Liability (Asset) 0.42% 0.42% 0.57% 0.59% 0.56%Plan's proportion share of the Net Pension Liability (Asset) 52,399,265$ 48,044,055$ 20,034,837$ 39,511,056$ 34,825,255$ Plan's Covered Payroll11,914,244$ 11,998,567$ 11,514,575$ 10,927,991$ 10,690,900$ Plan's Proportionate Share of the Net Pension Liability/(Asset)as a percentage of its Covered Payroll 439.80% 400.41% 174.00% 361.56% 325.75%Plan's Proportionate Share of the Fiduciary Net Position as a percentage of the Plan's Total Pension Liability 0.50% 0.53% 0.61% 0.54% 0.56% City of PleasantonRequired Supplementary Information (Unaudited) Schedule of Proportionate Share of Net Pension LiabilityFor the Year Ended June 30, 2024Last Ten Fiscal YearsCost-Sharing Multiple-Employer Defined Benefit Pension Plan - Safety (Police) Plan 144
Measurement period 2017-18 2016-17 2015-16 2014-15 2013-14Safety (Police)Plan's proportion of the Net Pension Liability (Asset) 0.53% 0.52% 0.57% 0.55% 0.62%Plan's proportion share of the Net Pension Liability (Asset) 31,176,806$ 30,840,762$ 29,660,239$ 22,831,189$ 23,281,243$ Plan's Covered Payroll9,744,448$ 9,915,346$ 9,905,680$ 9,507,583$ 9,746,121$ Plan's Proportionate Share of the Net Pension Liability/(Asset)as a percentage of its Covered Payroll 319.94% 311.04% 299.43% 240.14% 238.88%Plan's Proportionate Share of the Fiduciary Net Position as a percentage of the Plan's Total Pension Liability 0.57% 0.56% 0.56% 0.58% 0.58% City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Proportionate Share of Net Pension Liability (Continued)For the Year Ended June 30, 2024Last Ten Fiscal YearsCost-Sharing Multiple-Employer Defined Benefit Pension Plan - Safety (Police) Plan (Continued) 145
Fiscal Year2023-2024 2022-23 2021-22 2020-21 2019-20Actuarially Determined Contribution212,700,406$ 12,386,262$ 11,399,801$ 10,448,757$ 9,500,835$ Contributions in Relation to the Actuarially Determined Contribution2(12,700,406) (12,386,262) (11,399,801) (10,448,757) (9,500,835) Contribution Deficiency (Excess) -$ -$ -$ -$ -$ Covered payroll333,173,535$ 32,269,976$ 31,210,496$ 30,480,102$ 29,158,730$ Contributions as a percentage of covered payroll338.28% 38.38% 36.53% 34.28% 32.58%Notes to Schedule:Methods and assumptions used to determine contribution rates:Actuarial cost method Entry Age Normal Cost MethodAmortization method/period For details, see June 30, 2020 Funding Valuation Report.Asset valuation method Fair valueInflation 2.50%Salary increases Varies by entry age and servicePayroll Growth 2.75%Investment rate of returnRetirement ageMortality City of PleasantonRequired Supplementary Information (Unaudited) Schedule of Plan Contributions - PensionsFor the Year Ended June 30, 2024Last Ten Fiscal Years1Agent Multiple-Employer Defined Benefit Pension Plan - Miscellaneous Plan The probabilities of mortality are based on the 2017 CalPERS Experience Study for theperiod from 1997 to 2015. Mortality rates include 15 years of projected mortalityimprovement using 90% of Scale MP-2016 published by the Society of Actuaries. The actuarial methods and assumptions used to set the actuarially determined contributions for Fiscal Year 2022-23 were derived from the June 30,2020 funding valuation report.7.00% net of pension plan investment expenses; includes Inflation. 1As prescribed in GASB 68, paragraph 46, the information presented in the Schedule of Plan Contributions should also be presented as of theemployers most recent fiscal year-end. The employer is responsible for determining this information as prescribed by the standard as this data isnot available to CalPERS. 2Employers are assumed to make contributions equal to the actuarially determined contributions. How ever, some employers may choose to makeadditional contributions tow ards their unfunded liability. Employer contributions for such plans exceed the actuarially determined contributions.3Includes one years payroll growth using 2.80% payroll growth assumption for fiscal years ended in 2022 and 2023; 2.75% payroll grow thassumption for fiscal years ended in 2018 through 2021; 3.00% payroll grow th assumption for fiscal years ended in 2014 through 2017.The probabilities of retirement are based on the 2017 CalPERS Experience study for theperiod from 1997 to 2015.146
Fiscal Year2018-19 2017-18 2016-17 2015-16 2014-15Actuarially Determined Contribution28,420,069$ 7,497,182$ 6,881,221$ 6,313,803$ 6,476,826$ Contributions in Relation to the Actuarially Determined Contribution2(8,420,069) (7,497,182) (6,881,221) (7,313,803) (12,476,826) Contribution Deficiency (Excess) -$ -$ -$ (1,000,000)$ (6,000,000)$ Covered payroll328,365,628$ 27,648,324$ 25,556,540$ 25,673,931$ 25,009,403$ Contributions as a percentage of covered payroll329.68% 27.12% 26.93% 28.49% 49.89%City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Plan Contributions - Pensions (Continued)For the Year Ended June 30, 2024Last Ten Fiscal YearsAgent Multiple-Employer Defined Benefit Pension Plan - Miscellaneous Plan (Continued) 147
Fiscal Year2023-24 2022-23 2021-22 2020-21 2019-20Actuarially Determined Contribution2 9,555,416$ 9,382,776$ 8,681,086$ 8,310,958$ 7,679,832$ Contributions in Relation to the Actuarially Determined Contribution2 - Pleasanton Share(4,777,708) (4,691,388) (4,340,543) (4,155,479) (3,839,916)Contributions in Relation to the Actuarially Determined Contribution2 - Livermore Share(4,777,708) (4,691,388) (4,340,543) (4,155,479) (3,839,916)Contribution Deficiency (Excess) -$ -$ -$ -$ -$ Covered payroll318,011,604$ 17,521,016$ 16,423,661$ 16,924,746$ 15,581,217$ Contributions as a percentage of covered payroll326.53% 26.78% 26.43% 24.55% 24.64%Notes to Schedule:Methods and assumptions used to determine contribution rates:Actuarial cost method Entry Age Normal Cost MethodAmortization method/period For details, see June 30, 2020 Funding Valuation Report.Asset valuation method Fair valueInflation 2.50%Salary increases Varies by entry age and servicePayroll Growth 2.75%Investment rate of returnRetirement ageMortalityThe probabilities of retirement are based on the 2017 CalPERS Experience study for the period from 1997 to 2015.The probabilities of mortality are based on the 2017 CalPERS Experience Study for theperiod from 1997 to 2015. Mortality rates include 15 years of projected mortalityimprovement using 90% of Scale MP-2016 published by the Society of Actuaries. 2Employers are assumed to make contributions equal to the actuarially determined contributions. How ever, some employers may choose to makeadditional contributions tow ards their unfunded liability. Employer contributions for such plans exceed the actuarially determined contributions.3Includes one years payroll growth using 2.80% payroll growth assumption for fiscal years ended in 2022 and 2023; 2.75% payroll grow thassumption for fiscal years ended in 2018 through 2021; 3.00% payroll grow th assumption for fiscal years ended in 2014 through 2017.The actuarial methods and assumptions used to set the actuarially determined contributions for Fiscal Year 2022-23 were derived from the June 30,2020 funding valuation report.7.00% net of pension plan investment expenses; includes Inflation. 1As prescribed in GASB 68, paragraph 46, the information presented in the Schedule of Plan Contributions should also be presented as of theemployers most recent fiscal year-end. The employer is responsible for determining this information as prescribed by the standard as this data isnot available to CalPERS. Agent Multiple-Employer Defined Benefit Pension Plan - Safety (Fire) Plan City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Plan Contributions - PensionsFor the Year Ended June 30, 2024Last Ten Fiscal Years 148
Fiscal Year2018-19 2017-18 2016-17 2015-16 2014-15Actuarially Determined Contribution2 6,117,340$ 6,009,558$ 6,313,962$ 5,390,058$ 4,880,354$ Contributions in Relation to the Actuarially Determined Contribution2 - Pleasanton Share(3,058,670) (3,004,779) (3,156,981) (2,695,029) (2,440,177)Contributions in Relation to the Actuarially Determined Contribution2 - Livermore Share(3,058,670) (3,004,779) (3,156,981) (2,695,029) (2,440,177)Contribution Deficiency (Excess) -$ -$ -$ -$ -$ Covered payroll314,695,194$ 14,858,791$ 15,376,607$ 14,128,499$ 13,131,650$ Contributions as a percentage of covered payroll320.81% 20.22% 20.53% 19.08% 18.58%City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Plan Contributions - Pensions (Continued)For the Year Ended June 30, 2024Last Ten Fiscal YearsAgent Multiple-Employer Defined Benefit Pension Plan - Safety (Fire) Plan (Continued) 149
Fiscal Year2023-2024 2022-23 2021-22 2020-21 2019-20Actuarially Determined Contribution5,509,599$ 5,421,096$ 4,906,207$ 4,329,030$ 3,699,768$ Contributions in relation to the actuarially determined contribution (5,509,599) (5,421,096) (4,906,207) (4,329,030) (3,699,768) Contribution deficiency (excess) -$ -$ -$ -$ -$ Covered payroll 12,247,843$ 11,914,244$ 11,998,567$ 11,514,575$ 10,927,991$ Contributions as a percentage of covered payroll244.98% 45.50% 40.89% 37.60% 33.86%Cost-Sharing Multiple-Employer Defined Benefit Pension Plan - Safety (Police) Plan City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Plan Contributions - PensionsFor the Year Ended June 30, 2024Last Ten Fiscal Years 150
Fiscal Year2018-19 2017-18 2016-17 2015-16 2014-15Actuarially Determined Contribution3,321,452$ 2,516,591$ 3,542,737$ 1,599,423$ 2,638,355$ Contributions in relation to the actuarially determined contribution (3,321,452) (2,516,591) (6,159,217) (3,190,123) (7,138,355) Contribution deficiency (excess) -$ -$ (2,616,480)$ (1,590,700)$ (4,500,000)$ Covered payroll 10,690,900$ 9,744,448$ 9,915,346$ 9,905,680$ 9,507,583$ Contributions as a percentage of covered payroll231.07% 25.83% 62.12% 32.20% 75.08%City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Plan Contributions - Pensions (Continued)For the Year Ended June 30, 2024Last Ten Fiscal YearsCost-Sharing Multiple-Employer Defined Benefit Pension Plan - Safety (Police) Plan (Continued) 151
Measurement period, year ending: June 30, 2023 June 30, 2022 June 30, 2021 June 30, 2020Total OPEB liabilityService cost 1,252,000$ 1,252,000$ 1,453,000$ 1,433,000$ Interest 4,515,000 4,419,000 5,589,000 5,500,000 Differences between expected and actual experience (897,000) - (14,053,000) -Changes of assumptions 5,105,000 - (696,000) (1,419,000) Benefit payments, including refunds of member contributions (4,076,000) (4,186,000) (4,185,000) (4,254,000) Net change in total OPEB liability5,899,000 1,485,000 (11,892,000) 1,260,000 Total OPEB liability - beginning73,029,000 71,544,000 83,436,000 82,176,000 Total OPEB liability - ending (a)78,928,000$ 73,029,000$ 71,544,000$ 83,436,000$ OPEB fiduciary net positionContributions - employer 4,081,000$ 3,993,000$ 4,210,000$ 5,413,000$ Net investment income (loss) 3,617,000 (8,739,000) 14,078,000 1,798,000 Benefit payments, including refunds of member contributions (4,076,000) (4,186,000) (4,185,000) (4,254,000) Administrative expense (21,000) (25,000) (19,000) (24,000) Net change in plan fiduciary net position3,601,000 (8,957,000) 14,084,000 2,933,000 Plan fiduciary net position - beginning 56,335,000 65,292,000 51,208,000 48,275,000 Plan fiduciary net position - ending (b)59,936,000 56,335,000 65,292,000 51,208,000 Plan net OPEB liability (asset) - ending (a) - (b)18,992,000$ 16,694,000$ 6,252,000$ 32,228,000$ Plan fiduciary net position as a percentage ofthe total OPEB liability (asset)75.94% 77.14% 91.26% 61.37%Covered payroll49,782,000$ 45,835,000$ 44,216,000$ 42,264,000$ 38.15% 36.42% 14.14% 76.25% City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Changes in Net OPEB Liability and Related RatiosFor the Year Ended June 30, 2024Last Ten Fiscal Years1 Plan net OPEB liability (asset) as a percentage of covered payroll1Historical information is required only for the measurement periods for which GASB 75 is applicable. Fiscal Year 2018 was the first year ofimplementation. Future years' information will be displayed up to 10 years as information becomes available.
City of Pleasanton Retiree Healthcare Plan - Agent Multiple-Employer Plan 152
Measurement period, year ending: June 30, 2019 June 30, 2018 June 30, 2017Total OPEB liabilityService cost 1,779,000$ 1,727,000$ 1,677,000$ Interest 6,193,000 5,939,000 5,673,000 Differences between expected and actual experience (12,135,000) - - Changes of assumptions (1,540,000) - - Benefit payments, including refunds of member contributions (4,201,000) (3,670,000) (3,285,000) Net change in total OPEB liability(9,904,000) 3,996,000 4,065,000 Total OPEB liability - beginning92,080,000 88,084,000 84,019,000 Total OPEB liability - ending (a)82,176,000$ 92,080,000$ 88,084,000$ OPEB fiduciary net positionContributions - employer 5,521,000$ 4,800,000$ 5,898,000$ Net investment income (loss) 2,753,000 3,211,000 3,662,000 Benefit payments, including refunds of member contributions (4,201,000) (3,670,000) (3,285,000) Administrative expense (9,000) (75,000) (19,000) Net change in plan fiduciary net position4,064,000 4,266,000 6,256,000 Plan fiduciary net position - beginning 44,211,000 39,945,000 33,689,000 Plan fiduciary net position - ending (b)48,275,000 44,211,000 39,945,000 Plan net OPEB liability (asset) - ending (a) - (b)33,901,000$ 47,869,000$ 48,139,000$ Plan fiduciary net position as a percentage ofthe total OPEB liability (asset)58.75% 48.01% 45.35%Covered payroll40,367,000$ 39,630,000$ 37,661,000$ 83.98% 120.79% 127.82% City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Changes in Net OPEB Liability and Related Ratios (Continued)For the Year Ended June 30, 2024Last Ten Fiscal Years1 1Historical information is required only for the measurement periods for which GASB 75 is applicable. Fiscal Year 2018 was the first year ofimplementation. Future years' information will be displayed up to 10 years as information becomes available.
City of Pleasanton Retiree Healthcare Plan - Agent Multiple-Employer Plan (Continued) Plan net OPEB liability (asset) as a percentage of covered payroll153
Measurement dateJune 30, 2023 June 30, 2022 June 30, 2021 June 30, 2020Total OPEB liabilityService cost 664,000$ 672,000$ 748,000$ 738,000$ Interest 2,112,000 2,038,000 2,610,000 2,535,000 Differences between expected and actual experience (1,376,000) - (8,077,000) -Changes of assumptions 2,064,000 - 272,000 (602,000) Benefit payments, including refunds of member contributions (1,517,000) (1,547,000) (1,544,000) (1,570,000) Net change in total OPEB liability1,947,000 1,163,000 (5,991,000) 1,101,000 Total OPEB liability - beginning33,870,000 32,707,000 38,698,000 37,597,000 Total OPEB liability - ending (a)35,817,000$ 33,870,000$ 32,707,000$ 38,698,000$ OPEB fiduciary net positionContributions - employer 1,519,000$ 1,915,000$ 2,021,000$ 2,241,000$ Net investment income (loss) 1,650,000 (3,924,000) 6,222,000 798,000 Benefit payments, including refunds of member contributions (1,517,000) (1,547,000) (1,544,000) (1,570,000) Administrative expense (9,000) (9,000) (9,000) (10,000) Net change in plan fiduciary net position1,643,000 (3,565,000) 6,690,000 1,459,000 Plan fiduciary net position - beginning 25,703,000 29,268,000 22,578,000 21,119,000 Plan fiduciary net position - ending (b)27,346,000 25,703,000 29,268,000 22,578,000 Plan net OPEB liability (asset) - ending (a) - (b)8,471,000$ 8,167,000$ 3,439,000$ 16,120,000$ City Share (50%)4,235,500$ 4,083,500$ 1,719,500$ 8,060,000$ Plan fiduciary net position as a percentage ofthe total OPEB liability (asset)76.35% 75.89% 89.49% 58.34%Covered payroll26,519,000$ 24,605,000$ 23,584,000$ 22,179,000$ 31.94% 33.19% 14.58% 72.68% City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Changes in Net OPEB Liability and Related Ratios 1Historical information is required only for the measurement periods for which GASB 75 is applicable. Fiscal Year 2018 was the first year ofimplementation. Future years' information will be displayed up to 10 years as information becomes available.
Livermore Pleasanton Fire Department Retiree Healthcare Plan - Agent Multiple-Employer PlanFor the Year Ended June 30, 2024Last Ten Fiscal Years1 Plan net OPEB liability (asset) as a percentage of covered payroll154
Measurement dateJune 30, 2019 June 30, 2018 June 30, 2017Total OPEB liabilityService cost 819,000$ 795,000$ 772,000$ Interest 2,525,000 2,405,000 2,281,000 Differences between expected and actual experience (2,710,000) - -Changes of assumptions 1,151,000 - -Benefit payments, including refunds of member contributions (1,544,000) (1,341,000) (1,160,000) Net change in total OPEB liability241,000 1,859,000 1,893,000 Total OPEB liability - beginning37,356,000 35,497,000 33,604,000 Total OPEB liability - ending (a)37,597,000$ 37,356,000$ 35,497,000$ OPEB fiduciary net positionContributions - employer 2,298,000$ 2,110,000$ 2,379,000$ Net investment income (loss) 1,198,000 1,378,000 1,555,000 Benefit payments, including refunds of member contributions (1,544,000) (1,341,000) (1,160,000) Administrative expense (4,000) (32,000) (8,000) Net change in plan fiduciary net position1,948,000 2,115,000 2,766,000 Plan fiduciary net position - beginning 19,171,000 17,056,000 14,290,000 Plan fiduciary net position - ending (b)21,119,000 19,171,000 17,056,000 Plan net OPEB liability (asset) - ending (a) - (b)16,478,000$ 18,185,000$ 18,441,000$ City Share (50%)8,239,000 9,092,500 9,220,500 Plan fiduciary net position as a percentage ofthe total OPEB liability (asset)56.17% 51.32% 48.05%Covered payroll21,990,000$ 21,285,000$ 19,761,000$ 74.93% 85.44% 93.32% City of PleasantonRequired Supplementary Information (Unaudited)Schedule of Changes in Net OPEB Liability and Related Ratios (Continued) 1Historical information is required only for the measurement periods for which GASB 75 is applicable. Fiscal Year 2018 was the first year ofimplementation. Future years' information will be displayed up to 10 years as information becomes available.
Livermore Pleasanton Fire Department Retiree Healthcare Plan - Agent Multiple-Employer Plan (Continued)For the Year Ended June 30, 2024Last Ten Fiscal Years1 Plan net OPEB liability (asset) as a percentage of covered payroll155
Fiscal year 2024 2023 2022 2021 2020Actuarially determined contribution 2,529,000$ 2,421,000$ 4,066,000$ 3,991,000$ 5,480,000$ Contributions in relation to the actuarially determined contribution(4,286,000) (4,081,000) (3,993,000) (4,210,000) (5,413,000) Contributions in relation to the actuarially determined contribution4,286,000 4,081,000 3,993,000 4,210,000 5,413,000 Contribution deficiency (excess) (1,757,000)$ (1,660,000)$ 73,000$ (219,000)$ 67,000$ Covered payroll 51,890,000$ 49,782,000$ 45,835,000$ 44,216,000$ 42,264,000$ Contributions as a percentage of covered payroll28.26% 8.20% 8.71% 9.52% 12.81%Notes to Schedule:Methods and assumptions used to determine contribution rates:Valuation Date June 30, 2021Actuarial cost method Entry Age Normal, Level % of payAmortization method Level % of payAmortization Period 15-year fixed period for 2023/24Asset valuation method Investment gains and losses spread over 5-year rolling periodDiscount Rate 6.25%General Inflation 2.50%Medical TrendMortalityMortality Improvement For the Year Ended June 30, 2024Last Ten Fiscal Years1City of Pleasanton Retiree Healthcare Plan - Agent Multiple-Employer PlanCity of PleasantonRequired Supplementary Information (Unaudited) Schedule of OPEB Contributions The actuarial methods and assumptions used to set the actuarially determined contributions for Fiscal Year 2021-22 were derived from the June 30,2020 funding valuation report.Based on CalPERS 2000-2019 Experience StudyMortality projected fully generational with Scale MP-2021Non-Medicare - 6.50% for 2023, decreasing to an ultimate rate of3.75% in 2076Medicare (Non-Kaiser) - 5.65% for 2023, decreasing to an ultimaterate of 3.75% in 2076 Medicare (Kaiser) - 4.60% for 2023, decreasing to an ultimate rate of3.75% in 20761Historical information is required only for the measurement periods for which GASB 75 is applicable. Fiscal Year 2018 was the first year of implementation. Futureyears' information will be displayed up to 10 years as information becomes available. 156
Fiscal year 2019 2018Actuarially determined contribution 5,368,000$ 4,971,000$ Contributions in relation to the actuarially determined contribution(5,521,000) (4,800,000) Contributions in relation to the actuarially determined contribution5,521,000 4,800,000 Contribution deficiency (excess) (153,000)$ 171,000$ Covered payroll 40,367,000$ 39,630,000$ Contributions as a percentage of covered payroll2 13.68% 12.11%For the Year Ended June 30, 2024Last Ten Fiscal YearsCity of Pleasanton Retiree Healthcare Plan - Agent Multiple-Employer Plan (Continued)City of PleasantonRequired Supplementary Information (Unaudited) Schedule of OPEB Contributions (Continued) 157
Fiscal year 2024 2023 2022 2021 2020Actuarially determined contribution 1,308,000$ 1,258,000$ 2,078,000$ 2,032,000$ 2,267,000$ Contributions in relation to the actuarially determined contribution (City of Livermore's Share)(654,000) (759,500) (957,500) (1,010,500) (1,120,500) Contributions in relation to the actuariallyShare's Share)(547,500) (759,500) (957,500) (1,010,500) (1,120,500) Contribution deficiency (excess) 106,500$ (261,000)$ 163,000$ (1,010,500)$ (1,120,500)$ Covered payroll226,808,000$ 26,519,000$ 24,605,000$ 23,584,000$ 22,179,000$ Contributions as a percentage of covered payroll24.10% -5.73% -7.78% -8.57% -10.10%Notes to Schedule:Methods and assumptions used to determine contribution rates:Valuation Date June 30, 2021Actuarial cost method Entry Age Normal, Level % of payAmortization method Level % of payAmortization Period 15-year fixed period for 2023/24Asset valuation method Investment gains and losses spread over 5-year rolling periodDiscount Rate 6.25%General Inflation 2.50%Medical TrendMortalityMortality Improvement Last Ten Fiscal Years1City of PleasantonRequired Supplementary Information (Unaudited)Schedule of OPEB ContributionsFor the Year Ended June 30, 2024Livermore Pleasanton Fire Department Retiree Healthcare Plan - Agent Multiple-Employer PlanThe actuarial methods and assumptions used to set the actuarially determined contributions for Fiscal Year 2021-22 were derived from the June 30,2020 funding valuation report.Non-Medicare - 6.50% for 2023, decreasing to an ultimate rate of3.75% in 2076Medicare (Non-Kaiser) - 5.65% for 2023, decreasing to an ultimaterate of 3.75% in 2076 Medicare (Kaiser) - 4.60% for 2023, decreasing to an ultimate rate of3.75% in 2076Based on CalPERS 2000-2019 Experience StudyMortality projected fully generational with Scale MP-2021 1Historical information is required only for the measurement periods for which GASB 75 is applicable. Fiscal Year 2018 was the first year of implementation. Futureyears' information will be displayed up to 10 years as information becomes available. 158
Fiscal year 2019 2018Actuarially determined contribution 2,216,000$ 2,143,000$ Contributions in relation to the actuarially determined contribution (City of Livermore's Share)(1,149,000) (1,055,000) Contributions in relation to the actuariallyShare's Share)(1,149,000) (1,055,000) Contribution deficiency (excess) (82,000)$ 33,000$ Covered payroll2 21,990,000$ 21,285,000$ Contributions as a percentage of covered payroll2 -10.45% -9.91%For the Year Ended June 30, 2024Last Ten Fiscal Years1Livermore Pleasanton Fire Department Retiree Healthcare Plan - Agent Multiple-Employer Plan (Continued)City of PleasantonRequired Supplementary Information (Unaudited) Schedule of OPEB Contributions (Continued) 159
This page intentionally left blank.
160
SUPPLEMENTARY INFORMATION
161
This page intentionally left blank.
162
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 122,000$ 122,000$ 848,366$ 726,366$ Total Revenues122,000 122,000 848,366 726,366 EXPENDITURES:Current:Public works - - 34,265 (34,265) Capital outlay 5,543,381 25,569,646 2,203,603 23,366,043 Total Expenditures5,543,381 25,569,646 2,237,868 23,331,778 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(5,421,381) (25,447,646) (1,389,502) 24,058,144 OTHER FINANCING SOURCES (USES)Transfers in 3,500,000 3,690,628 3,690,628 - Transfers out (1,800,000) (1,800,000) (1,800,000) - Total other financing sources (uses)1,700,000 1,890,628 1,890,628 - NET CHANGE IN FUND BALANCE(3,721,381)$ (23,557,018)$ 501,126 24,058,144$ FUND BALANCE:Beginning of year 27,295,196 End of year 27,796,322$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualMiscellaneous Capital Improvement Programs Capital Projects FundFor the Year Ended June 30, 2024 163
This page intentionally left blank.
164
NONMAJOR GOVERNMENTAL FUNDSCentral Business District ("CBD") Parking In-Lieu -This fund accounts for fees collected from developers in the downtown areain lieu of providing required parking. The City will use this money to build downtown parking structures in the future.The Drug Abuse Resistance Education ("D.A.R.E.") Trust -This fund accounts for private donations made to specifically enhancethe City's D.A.R.E. program.Landscape Maintenance North Pleasanton Improvement District (N.P.I.D.) -This fund accounts for the portion of the N.P.I.D. #3funds that have been designated for the temporary maintenance of freeway on-ramps landscape.Asset Forfeiture- This fund accounts for the proceeds from assets forfeited as a result of investigations of criminal offenses,generally narcotics related. In accordance with the Health and Safety Code Section 11489, the funds must be used for lawenforcement and prosecution efforts.Resource Management -This fund accounts for Measure D revenues from Alameda County as well as other mitigation revenues.The City has developed a variety of recycling programs in accordance with state and county requirements.Miscellaneous Donations -This fund is used to account for donations made to the City for equipment or to enhance services inaccordance with the donor's requests.Landscape and Lighting Districts-Residents of five different subdivisions (Ponderosa 84-1, Windsor 93-1, Bond 93-2, Moller 95-1 and Oak Tree Farms 94-1) participate in landscape maintenance districts that pay to maintain and repair designated landscaped andopen space areas. It is administered by the City but paid for by the homeowners through annual assessments placed on their propertytax bills.
SPECIAL REVENUE FUNDSSpecial Revenue Fundsaccount for the proceeds of specific revenue sources that are restricted, assigned or committed toexpenditure for specified purposes other than debt service or capital projects.
Library Trust -This fund was established in FY 2000/01 to account for donations made to the library. Funds will be expended forequipment and enhanced services in accordance with donor's requests.
Geologic Hazard Assessment Districts -Residents of four different subdivisions (Lemoine, Laurel Creek, Moller and Oak TreeFarm) participate in assessment districts that will pay for any landslide repairs and related geologic work. It is administered by theCity but paid for by the homeowners through annual assessments placed on their property tax bills.HOME Program -The HOME Investment Partnerships Program (HOME) is funded through a federal grant from the U.S.Department of Housing and Urban Development. The City receives its annual formula allocation and the funds must be used forhousing projects that benefit lower income persons.Abandoned Vehicle -The City receives funds from a vehicle registration surcharge for abatement of abandoned vehicles. The fundsare used to cover the costs associated with the handling of abandoned vehicles.Urban Forestry Program -This fund was created to promote conservation and public education in regard to Pleasanton's streettrees, park trees and trees on private property. Revenue sources include donations and fines assessed for damaging heritage trees.Measure B Transportation Improvements -This fund accounts for moneys received from voter-approved Measure B which is to beused for street construction, repair, and maintenance and for bicycle and pedestrian safety projects.Gas Tax -The City receives its share of gas tax from the State and uses the funds to construct, reconstruct and maintain streetsthroughout the City as designated in the annual capital improvement program.165
SPECIAL REVENUE FUNDS (CONTINUED)
Measure F Vehicle Registration Fees -This fund accounts for moneys received from voter approved Measure F which is to be usedfor repair and maintenance of local streets and roads and the improvement of traffic flow, public transportation, and bicyclist,pedestrian, and driver safety.
Community Development Block Grant -The Community Development Block Grant (CDBG) program is funded through a federalgrant from the U.S. Department of Housing and Urban Development. CDBG funds must be used for projects and activities thatbenefit at least 70 percent lower income persons. Eligible projects include capital improvements, housing rehabilitation, publicservices, and economic development activities.NONMAJOR GOVERNMENTAL FUNDS (CONTINUED)Community Access Television- Under City Ordinance No. 2013, Section 6.54.060 of the Pleasanton Municipal Code, the Citycollects one percent (1%) of gross revenues from Cable Operators to support PEG (public, educational and governmental) channelfacilities. This fund accounts for collection of PEG revenues and the capital expenditures related to PEG channel facilities.
Pleasanton Garbage Service Rate Reserve -This fund accounts for the Rate Reserve Calculation proceeds received from PleasantonGarbage Services (PGS) during FY 2019/20, as per the Rate Reserve Agreement, dated March 20, 2018, between the City and PGS.The funds will be allocated to future projects at a later date.
Downtown Economic Loan- This fund was established in FY 1995/96 to provide design and other assistance to downtownmerchants to improve their facades. Proposed expenditures in the future will be loans to merchants.
Business Support Program -This fund accounts for the loans provided to independently or locally owned micro-enterprises,restaurants and retail businesses located in Pleasanton to assist them in remaining solvent during the COVID-19 emergency.
Marilyn Murphy Kane Trail Reserve- This fund accounts for the unspent portion of a donation received for the construction of theMarilyn Murphy Kane Trail. The remaining funds will be spent on design and construction services to install additional trees alongthe Marilyn Murphy Kane Trail on the City's Bernal property.Measure BB Transportation Improvements -This fund accounts for moneys received from voter-approved Measure BB which isto be used for transportation priorities that includes streets and roads improvements, bicycle/pedestrian enhancements, and transitrelated projects.AB1379 CASp Certification and Training -This fund accounts for the fees collected from business license applicants as mandatedby Assembly Bill No. 1379 and are to be used for increased certified access specialist (CASp) training and certification within theCity and to facilitate compliance with construction-related accessibility requirements.
HBPOA Maintenance District -This fund receives revenue from the Hacienda Business Park Owners Association to maintain thetraffic signals within their business park. The City administers the maintenance contracts.Specific Plans -Under Government Code Section 65450-65457, the City has established specific plans to develop policies,programs, and regulations for implementing its general plan in site-specific areas. Fees collected under these plans for theconstruction of infrastructure in these specific areas of the City are accounted for in this fund. This fund currently consists of theHappy Valley Specific Plan, the Vineyard Avenue Corridor Specific Plan, and the Stoneridge Drive Specific Plan.
Johnson Drive Economic Development Zone -This fund was established in FY 2022/23 for transportation related projects withinthe Johnson Drive Economic Development Zone (JDEDZ). Funding for these projects will come from fees collected from futuredevelopers at the time they pull permits to develop their property within the JDEDZ.Opioid Settlements -This fund accounts for proceeds received from the State of California Opioid settlement and bankruptcylawsuits. Moneys received are to be used for opioid remediation activities.166
Tri-Valley Transportation -The City, as a member of the Tri-Valley Transportation Council, collects a fee from developers tofinance projects to reduce traffic related impacts caused by future developments.
NONMAJOR GOVERNMENTAL FUNDS (CONTINUED)CAPITAL PROJECTS FUNDSCapital Projects Fundsaccount for financial resources to be used for the acquisition or construction of major capital facilities otherthan those financed by Proprietary and Special Revenue Funds.CIP for Downtown and North Pleasanton -This fund was set up in FY 2007/08 to account for the purchase of land and to constructparking facilities and other improvements in the Downtown Area and in North Pleasanton.Public Facilities -This fund receives revenues from developers of properties. The moneys are used for the purchase of equipment orconstruction of facilities related to the new property development as adopted in the annual miscellaneous capital improvementprogram.Park Development -This fund receives revenues from developers of properties and the funds may only be used for the design,development, and construction of new parks within the City.Park Capital Improvement Program -This fund is used to account for the construction, reconstruction, and maintenance of Cityparks as adopted in the annual parks capital improvement program.Street Capital Improvement Program -This fund receives contributions from the General Fund to be used for the construction,reconstruction and maintenance of City streets as adopted in the annual streets capital improvement program.Traffic Impact -This fund receives revenues from developers of commercial and residential properties. The funds may only be usedfor traffic and street improvements.Budgeted Developer Projects - This fund receives revenue from developers for specific capital improvement projects.Assessment District Construction -This fund includes the construction funds of Assessment District NPID 1 and AssessmentDistrict Stoneridge Business Center. Projects funded by this fund include street and intersection improvements. 167
This page intentionally left blank..
168
Asset CBD Parking ResourceD.A.R.E. TrustForfeiture In-Lieu Management ASSETSPooled cash and investments 17,731$ 29,107$ 708,274$ 595,801$ Receivables:Accounts - - - 53,609 Taxes - - - - Notes and loans - - - - Accrued interest 40 66 1,606 722 Total assets17,771$ 29,173$ 709,880$ 650,132$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable -$ -$ -$ 1,231$ Accrued liabilities - - - 2,850 Unearned revenues - - - 105,343 Due to other funds - - - - Advances from other funds - - - - Total liabilities- - - 109,424 Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted 17,771 29,173 - 540,708 Committed - - - - Assigned - - 709,880 - Total fund balances17,771 29,173 709,880 540,708 Total liabilities, deferred inflows of resources and fund balances17,771$ 29,173$ 709,880$ 650,132$ (Continued) Special Revenue FundsCity of PleasantonCombining Balance SheetJune 30, 2024Nonmajor Governmental Funds 169
GeologicLandscape Landscape HazardMiscellaneous and Lighting Maintenance AssessmentDonations Districts N.P.I.D. DistrictsASSETSPooled cash and investments 439,639$ 463,753$ 1,065,323$ 1,386,013$ Receivables:Accounts 5,000 19 872 233 Taxes - - - - Notes and loans - - 22,274 - Accrued interest 215 1,076 2,404 3,173 Total assets444,854$ 464,848$ 1,090,873$ 1,389,419$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable -$ 28,981$ -$ -$ Accrued liabilities - - - - Unearned revenues - - - - Due to other funds - - - - Advances from other funds - - - - Total liabilities- 28,981 - - Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted 444,854 435,867 1,090,873 1,389,419 Committed - - - - Assigned - - - - Total fund balances444,854 435,867 1,090,873 1,389,419 Total liabilities, deferred inflows of resources and fund balances444,854$ 464,848$ 1,090,873$ 1,389,419$ (Continued) Special Revenue FundsCity of PleasantonCombining Balance Sheet (Continued)June 30, 2024Nonmajor Governmental Funds 170
Measure BTransportation HOME AbandonedImprovements Gas Tax Program VehicleASSETSPooled cash and investments 410,505$ 7,495,266$ -$ 117,623$ Receivables:Accounts - 2,500 372,355 - Taxes - 750,201 - - Notes and loans - - 918,987 - Accrued interest 948 16,851 206,263 301 Total assets411,453$ 8,264,818$ 1,497,605$ 117,924$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable 10,670$ 426,996$ 29,588$ -$ Accrued liabilities - - 87 - Unearned revenues - - - - Due to other funds - - 342,681 - Advances from other funds - - - - Total liabilities10,670 426,996 372,356 - Deferred inflows of resources:Unavailable revenues - - 372,355 - Total deferred inflows of resources- - 372,355 - Fund balances:Restricted 400,783 7,837,822 752,894 117,924 Committed - - - - Assigned - - - - Total fund balances400,783 7,837,822 752,894 117,924 Total liabilities, deferred inflows of resources and fund balances411,453$ 8,264,818$ 1,125,250$ 117,924$ (Continued) Special Revenue FundsCity of PleasantonNonmajor Governmental FundsCombining Balance Sheet (Continued)June 30, 2024 171
HBPOA CommunityUrban Forestry Library Maintenance DevelopmentProgram Trust District Block GrantASSETSPooled cash and investments 1,118,639$ 59,325$ -$ 1,856$ Receivables:Accounts - - 23,804 87,493 Taxes - - - - Notes and loans - - - 354,883 Accrued interest 2,211 - - 167,503 Total assets1,120,850$ 59,325$ 23,804$ 611,735$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable 53,241$ -$ 22,744$ 4,447$ Accrued liabilities - - - 866 Unearned revenues - - - 84,036 Due to other funds - - 1,060 - Advances from other funds - - - - Total liabilities53,241 - 23,804 89,349 Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted 1,067,609 59,325 - 522,386 Committed - - - - Assigned - - - - Total fund balances1,067,609 59,325 - 522,386 Total liabilities, deferred inflows of resources and fund balances1,120,850$ 59,325$ 23,804$ 611,735$ (Continued) Special Revenue FundsNonmajor Governmental FundsCity of PleasantonCombining Balance Sheet (Continued)June 30, 2024 172
Community Marilyn MurphyDowntown Access Kane TrailEconomic Loan Television Reserve Specific PlansASSETSPooled cash and investments 28,985$ 1,526,645$ 114,805$ 842,101$ Receivables:Accounts - 43,895 - - Taxes - 12,542 - - Notes and loans - - - - Accrued interest 65 3,444 261 1,914 Total assets29,050$ 1,586,526$ 115,066$ 844,015$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable -$ 50,032$ -$ -$ Accrued liabilities - - - - Unearned revenues - - - - Due to other funds - - - - Advances from other funds - - - - Total liabilities- 50,032 - - Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted - 1,536,494 115,066 844,015 Committed - - - - Assigned 29,050 - - - Total fund balances29,050 1,536,494 115,066 844,015 Total liabilities, deferred inflows of resources and fund balances29,050$ 1,586,526$ 115,066$ 844,015$ (Continued) Special Revenue FundsCity of PleasantonCombining Balance Sheet (Continued)Nonmajor Governmental FundsJune 30, 2024 173
Measure FVehicle Measure BB AB1379 CASp BusinessRegistration Transportation Certification and SupportFees Improvements Training ProgramASSETSPooled cash and investments 743,621$ 6,109,141$ 136,909$ 1,673,058$ Receivables:Accounts 59,783 - - 58,632 Taxes - 396,455 - - Notes and loans - - - 676,195 Accrued interest 1,596 13,324 313 4,502 Total assets805,000$ 6,518,920$ 137,222$ 2,412,387$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable -$ 349,371$ 3,840$ -$ Accrued liabilities - - - - Unearned revenues - - - - Due to other funds - - - - Advances from other funds - - - - Total liabilities- 349,371 3,840 - Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted 805,000 6,169,549 133,382 Committed - - - 2,412,387 Assigned - - - - Total fund balances805,000 6,169,549 133,382 2,412,387 Total liabilities, deferred inflows of resources and fund balances805,000$ 6,518,920$ 137,222$ 2,412,387$ (Continued) Special Revenue FundsCity of PleasantonCombining Balance Sheet (Continued)Nonmajor Governmental FundsJune 30, 2024 174
Capital Projects FundsJohnson Drive CIP forPleasanton Economic Downtown andGarbage Service Development Opioid NorthRate Reserve Zone Settlements PleasantonASSETSPooled cash and investments 4,070,429$ 979,942$ 134,917$ 3,279,010$ Receivables:Accounts - - - - Taxes - - - - Notes and loans - - - 426,416 Accrued interest 9,322 2,221 290 7,406 Total assets4,079,751$ 982,163$ 135,207$ 3,712,832$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable 2,660$ -$ 18,550$ -$ Accrued liabilities - - - - Unearned revenues - - - - Due to other funds - - - - Advances from other funds - - - - Total liabilities2,660 - 18,550 - Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted 4,077,091 982,163 116,657 - Committed - - - 3,712,832 Assigned - - - - Total fund balances4,077,091 982,163 116,657 3,712,832 Total liabilities, deferred inflows of resources and fund balances4,079,751$ 982,163$ 135,207$ 3,712,832$ (Continued) City of PleasantonCombining Balance Sheet (Continued)Nonmajor Governmental FundsJune 30, 2024Special Revenue Funds 175
Park Capital Street CapitalPark Improvement ImprovementPublic Facilities Development Program ProgramASSETSPooled cash and investments 1,993,578$ 8,905,202$ 3,643,933$ 7,938,457$ Receivables:Accounts - - - 10,227 Taxes - - - - Notes and loans - - - - Accrued interest 2,014 20,219 4,619 21,210 Total assets1,995,592$ 8,925,421$ 3,648,552$ 7,969,894$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable 1,624$ 39,841$ 2,506$ -$ Accrued liabilities - - - - Unearned revenues - - - - Due to other funds - - - - Advances from other funds - - 205,685 - Total liabilities1,624 39,841 208,191 - Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted 1,993,968 8,885,580 - - Committed - - - - Assigned - - 3,440,361 7,969,894 Total fund balances1,993,968 8,885,580 3,440,361 7,969,894 Total liabilities, deferred inflows of resources and fund balances1,995,592$ 8,925,421$ 3,648,552$ 7,969,894$ (Continued) City of PleasantonCombining Balance Sheet (Continued)Nonmajor Governmental FundsJune 30, 2024Capital Projects Funds 176
Budgeted AssessmentDeveloper District Tri-ValleyTraffic Impact Projects Construction TransportationASSETSPooled cash and investments 10,827,536$ 7,643,176$ 1,105,972$ 2,302,585$ Receivables:Accounts - - - - Taxes - - - - Notes and loans - - - - Accrued interest 23,252 17,304 2,606 5,066 Total assets10,850,788$ 7,660,480$ 1,108,578$ 2,307,651$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable 452,811$ -$ -$ -$ Accrued liabilities - - - - Unearned revenues - - - - Due to other funds - - - - Advances from other funds - - - - Total liabilities452,811 - - - Deferred inflows of resources:Unavailable revenues - - - - Total deferred inflows of resources- - - - Fund balances:Restricted 10,397,977 7,660,480 1,108,578 2,307,651 Committed - - - - Assigned - - - - Total fund balances10,397,977 7,660,480 1,108,578 2,307,651 Total liabilities, deferred inflows of resources and fund balances10,850,788$ 7,660,480$ 1,108,578$ 2,307,651$ (Continued) City of PleasantonCombining Balance Sheet (Continued)Nonmajor Governmental FundsJune 30, 2024Capital Projects Funds 177
Total NonmajorGovernmentalFundsASSETSPooled cash and investments 77,908,857$ Receivables:Accounts 718,422 Taxes 1,159,198 Notes and loans 2,398,755 Accrued interest 544,327 Total assets82,729,559$ LIABILITIES, DEFERRED INFLOWS OFRESOURCES, AND FUND BALANCESLiabilities:Accounts payable 1,499,133$ Accrued liabilities 3,803 Unearned revenues 189,379 Due to other funds 343,741 Advances from other funds 205,685 Total liabilities2,241,741 Deferred inflows of resources:Unavailable revenues 372,355 Total deferred inflows of resources372,355 Fund balances:Restricted 61,841,059 Committed 6,125,219 Assigned 12,149,185 Total fund balances80,115,463Total liabilities, deferred inflows of resources and fund balances82,729,559$ (Concluded) City of PleasantonCombining Balance Sheet (Continued)Nonmajor Governmental FundsJune 30, 2024 178
Asset CBD Parking ResourceD.A.R.E. TrustForfeiture In-Lieu Management REVENUES:Assessments -$ -$ -$ -$ Intergovernmental - - - 342,931 Use of money and property 819 1,238 30,129 29,319 Fines and forfeitures - - - - Development fees - - - - Contributions - - - - Miscellaneous - - - 356 Total revenues819 1,238 30,129 372,606 EXPENDITURES:Current:General government - - - 424,794 Public safety 862 - - - Community development - - - - Public works - - - - Community activities - - - - Capital outlay - - - - Debt service:Principal retirement - - - 30,736 Interest and fiscal charges - - - 674 Total expenditures862 - - 456,204 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(43) 1,238 30,129 (83,598) OTHER FINANCING SOURCES (USES):Transfers in - - - - Transfers out - - - - Total other financing sources (uses)- - - - NET CHANGES IN FUND BALANCES(43) 1,238 30,129 (83,598) FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 17,814 27,935 679,751 624,306 Change within financial reporting entity(nonmajor to major) - - - - Error corrections - - - - Beginning of year, as restated (Note 15) 17,814 27,935 679,751 624,306 End of year 17,771$ 29,173$ 709,880$ 540,708$ (Continued) Combining Statement of Revenues, Expenditures, and Changes in Fund BalancesCity of PleasantonNonmajor Governmental FundsFor the Year Ended June 30, 2024Special Revenue Funds 179
GeologicLandscape Landscape HazardMiscellaneous and Lighting Maintenance AssessmentDonations Districts N.P.I.D. DistrictsREVENUES:Assessments -$ 130,394$ -$ 85,785$ Intergovernmental - - - - Use of money and property 6,635 17,850 45,456 55,561 Fines and forfeitures - - - - Development fees - - - - Contributions 104,021 - - - Miscellaneous - 12,680 - 1,353 Total revenues110,656 160,924 45,456 142,699 EXPENDITURES:Current:General government - - - -Public safety 4,000 - - - Community development - - - - Public works - 141,835 8,305 46,328 Community activities 59,763 - - - Capital outlay - - - - Debt service:Principal retirement - - - - Interest and fiscal charges - - - - Total expenditures63,763 141,835 8,305 46,328 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES46,893 19,089 37,151 96,371 OTHER FINANCING SOURCES (USES):Transfers in - - - - Transfers out (18,714) - - - Total other financing sources (uses)(18,714) - - - NET CHANGES IN FUND BALANCES28,179 19,089 37,151 96,371 FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 416,675 416,778 1,016,398 1,293,048 Change within financial reporting entity(nonmajor to major) - - - - Error corrections - - 37,324 - Beginning of year, as restated (Note 15) 416,675 416,778 1,053,722 1,293,048 End of year 444,854$ 435,867$ 1,090,873$ 1,389,419$ (Continued) City of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)Nonmajor Governmental FundsFor the Year Ended June 30, 2024Special Revenue Funds 180
Measure BTransportation HOME AbandonedImprovements Gas Tax Program VehicleREVENUES:Assessments -$ -$ -$ -$ Intergovernmental - 4,223,472 123,118 26,854 Use of money and property 56,434 162,625 19,518 5,435 Fines and forfeitures - - - - Development fees - - - - Contributions - - - - Miscellaneous - 4,076 19 - Total revenues56,434 4,390,173 142,655 32,289 EXPENDITURES:Current:General government - - - - Public safety - - - 26,854 Community development - - 131,198 - Public works - 7,500 - - Community activities - - - - Capital outlay 140,726 2,302,825 - - Debt service:Principal retirement - - - - Interest and fiscal charges - - - - Total expenditures140,726 2,310,325 131,198 26,854 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(84,292) 2,079,848 11,457 5,435 OTHER FINANCING SOURCES (USES):Transfers in - - - - Transfers out - - - - Total other financing sources (uses)- - - - NET CHANGES IN FUND BALANCES(84,292) 2,079,848 11,457 5,435 FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 485,075 5,757,974 (123,118) 112,489 Change within financial reporting entity(nonmajor to major) - - - - Error corrections - - 864,555 - Beginning of year, as restated (Note 15) 485,075 5,757,974 741,437 112,489 End of year 400,783$ 7,837,822$ 752,894$ 117,924$ (Continued) Combining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)Nonmajor Governmental FundsCity of PleasantonFor the Year Ended June 30, 2024Special Revenue Funds 181
HBPOA CommunityUrban Forestry Library Maintenance DevelopmentProgram Trust District Block GrantREVENUES:Assessments -$ -$ -$ -$ Intergovernmental - - - 182,387 Use of money and property 2,125 - - - Fines and forfeitures 33,700 - - - Development fees - - - - Contributions 914,979 - - - Miscellaneous 1,040 - 164,776 177 Total revenues951,844 - 164,776 182,564 EXPENDITURES:Current:General government - - - - Public safety - - - - Community development - - - 158,854 Public works 42,474 - 164,776 - Community activities - - - - Capital outlay 249,706 - - - Debt service:Principal retirement - - - 50,000 Interest and fiscal charges - - - 17,164 Total expenditures292,180 - 164,776 226,018 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES659,664 - - (43,454) OTHER FINANCING SOURCES (USES):Transfers in - - - - Transfers out (25,000) - - - Total other financing sources (uses)(25,000) - - - NET CHANGES IN FUND BALANCES634,664 - - (43,454) FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 432,945 59,325 - - Change within financial reporting entity(nonmajor to major) - - - - Error corrections - - - 565,840 Beginning of year, as restated (Note 15) 432,945 59,325 - 565,840 End of year 1,067,609$ 59,325$ -$ 522,386$ (Continued) City of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)Nonmajor Governmental FundsSpecial Revenue FundsFor the Year Ended June 30, 2024 182
Community Marilyn MurphyDowntown Access Kane TrailEconomic Loan Television Reserve Specific PlansREVENUES:Assessments -$ -$ -$ -$ Intergovernmental - - - - Use of money and property 1,233 89,664 4,884 38,241 Fines and forfeitures - - - - Development fees - - - - Contributions - - - - Miscellaneous - 220,805 - - Total revenues1,233 310,469 4,884 38,241 EXPENDITURES:Current:General government - 518,731 - - Public safety - - - - Community development - - - - Public works - - - - Community activities - - - - Capital outlay - 15,896 - - Debt service:Principal retirement - - - - Interest and fiscal charges - - - - Total expenditures- 534,627 - - EXCESS OF REVENUES OVER(UNDER) EXPENDITURES1,233 (224,158) 4,884 38,241 OTHER FINANCING SOURCES (USES):Transfers in - - - - Transfers out - - - (1,832) Total other financing sources (uses)- - - (1,832) NET CHANGES IN FUND BALANCES1,233 (224,158) 4,884 36,409 FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 27,817 1,760,652 110,182 807,606 Change within financial reporting entity(nonmajor to major) - - - - Error corrections - - - - Beginning of year, as restated (Note 15) 27,817 1,760,652 110,182 807,606 End of year 29,050$ 1,536,494$ 115,066$ 844,015$ (Continued) Nonmajor Governmental FundsCity of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)For the Year Ended June 30, 2024Special Revenue Funds 183
Measure FVehicle Measure BB AB1379 CASp BusinessRegistration Transportation Certification and SupportFees Improvements Training ProgramREVENUES:Assessments -$ -$ -$ -$ Intergovernmental 356,097 2,349,468 - - Use of money and property 2,388 77,670 3,990 59,269 Fines and forfeitures - - - - Development fees - - - - Contributions - - - - Miscellaneous - - 31,506 - Total revenues358,485 2,427,138 35,496 59,269 EXPENDITURES:Current:General government - - - 37,400 Public safety - - - - Community development - - 10,907 - Public works - - - - Community activities - - - - Capital outlay - 600,199 - - Debt service:Principal retirement - - - - Interest and fiscal charges - - - - Total expenditures- 600,199 10,907 37,400 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES358,485 1,826,939 24,589 21,869 OTHER FINANCING SOURCES (USES):Transfers in - - - - Transfers out - - - (350,000) Total other financing sources (uses)- - - (350,000) NET CHANGES IN FUND BALANCES358,485 1,826,939 24,589 (328,131) FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 446,515 4,342,610 108,793 1,626,946 Change within financial reporting entity(nonmajor to major) - - - - Error corrections - - - 1,113,572 Beginning of year, as restated (Note 15) 446,515 4,342,610 108,793 2,740,518 End of year 805,000$ 6,169,549$ 133,382$ 2,412,387$ (Continued) Special Revenue FundsCity of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)For the Year Ended June 30, 2024Nonmajor Governmental Funds 184
FormerlyNonmajor Special RevenueFundJohnson DrivePleasanton EconomicGarbage Service Development Opioid Miscellaneous Rate Reserve Zone Settlements GrantsREVENUES:Assessments -$ -$ -$ Intergovernmental - - 58,421Use of money and property 116,835 41,685 (4,120)Fines and forfeitures - - - Development fees - - - Contributions - - - Miscellaneous 864,049 - - Total revenues980,884 41,685 54,301 EXPENDITURES:Current:General government - - - Public safety - - - Community development - - - Public works 139,847 - - Community activities - - 18,549 Capital outlay - - - Debt service:Principal retirement - - - Interest and fiscal charges - - - Total expenditures139,847 - 18,549 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES841,037 41,685 35,752 OTHER FINANCING SOURCES (USES):Transfers in - - -Transfers out - - - Total other financing sources (uses)- - - NET CHANGES IN FUND BALANCES841,037 41,685 35,752FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 3,236,054 940,478 80,905 690,720 Change within financial reporting entity(nonmajor to major) - - - (690,720) Error corrections - - - - Beginning of year, as restated (Note 15) 3,236,054 940,478 80,905 - End of year 4,077,091$ 982,163$ 116,657$ -$ (Continued) City of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)Nonmajor Governmental FundsFor the Year Ended June 30, 2024Special Revenue Funds 185
CIP forDowntown and Park CapitalNorth Park ImprovementPleasanton Public Facilities Development ProgramREVENUES:Assessments -$ -$ -$ -$ Intergovernmental - - - - Use of money and property 154,707 60,351 452,679 5,119 Fines and forfeitures - - - - Development fees - 1,300,930 - - Contributions - - - - Miscellaneous - - - - Total revenues154,707 1,361,281 452,679 5,119 EXPENDITURES:Current:General government - - - - Public safety - - - - Community development - - - - Public works - - - - Community activities - - - - Capital outlay - 16,716 551,911 559,235 Debt service:Principal retirement - - - - Interest and fiscal charges - - - - Total expenditures- 16,716 551,911 559,235 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES154,707 1,344,565 (99,232) (554,116) OTHER FINANCING SOURCES (USES):Transfers in - - - 1,674,786 Transfers out - - - - Total other financing sources (uses)- - - 1,674,786 NET CHANGES IN FUND BALANCES154,707 1,344,565 (99,232) 1,120,670 FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 3,060,796 649,403 8,984,812 2,319,691 Change within financial reporting entity(nonmajor to major) - - - - Error corrections 497,329 - - - Beginning of year, as restated (Note 15) 3,558,125 649,403 8,984,812 2,319,691 End of year 3,712,832$ 1,993,968$ 8,885,580$ 3,440,361$ (Continued) City of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)Nonmajor Governmental FundsFor the Year Ended June 30, 2024Capital Projects Funds 186
Street Capital Budgeted AssessmentImprovement Developer DistrictProgram Traffic Impact Projects ConstructionREVENUES:Assessments -$ -$ -$ -$ Intergovernmental - - - - Use of money and property 392,206 402,352 307,965 52,027 Fines and forfeitures - - - - Development fees - 691,036 - - Contributions - - 36,770 - Miscellaneous 40,755 - - - Total revenues432,961 1,093,388 344,735 52,027 EXPENDITURES:Current:General government - - - - Public safety - - - - Community development - - - - Public works 1,259 - - 41,028 Community activities - - - - Capital outlay 62,655 475,253 62,928 11,665 Debt service:Principal retirement - - - - Interest and fiscal charges - - - - Total expenditures63,914 475,253 62,928 52,693 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES369,047 618,135 281,807 (666) OTHER FINANCING SOURCES (USES):Transfers in 83,527 - - - Transfers out (1,500,000) - - - Total other financing sources (uses)(1,416,473) - - - NET CHANGES IN FUND BALANCES(1,047,426) 618,135 281,807 (666) FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 9,017,320 9,779,842 7,378,673 1,109,244 Change within financial reporting entity(nonmajor to major) - - - - Error corrections - - - - Beginning of year, as restated (Note 15) 9,017,320 9,779,842 7,378,673 1,109,244 End of year 7,969,894$ 10,397,977$ 7,660,480$ 1,108,578$ (Continued) City of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)Nonmajor Governmental FundsFor the Year Ended June 30, 2024Capital Projects Funds 187
CapitalProjects FundTotal NonmajorTri-Valley GovernmentalTransportation FundsREVENUES:Assessments -$ 216,179$ Intergovernmental - 7,662,748 Use of money and property 97,285 2,789,574 Fines and forfeitures - 33,700 Development fees 76,572 2,068,538 Contributions - 1,055,770 Miscellaneous - 1,341,592 Total revenues173,857 15,168,101 EXPENDITURES:Current:General government - 980,925 Public safety - 31,716 Community development - 300,959 Public works - 593,352 Community activities - 78,312 Capital outlay - 5,049,715 Debt service: -Principal retirement - 80,736 Interest and fiscal charges - 17,838 Total expenditures- 7,133,553 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES173,857 8,034,548 OTHER FINANCING SOURCES (USES):Transfers in - 1,758,313 Transfers out - (1,895,546) Total other financing sources (uses)- (137,233) NET CHANGES IN FUND BALANCES173,857 7,897,315 FUND BALANCES:Beginning of year, as previously presented as of June 30, 2023 2,133,794 69,830,248 Change within financial reporting entity(nonmajor to major) - (690,720) Error corrections - 3,078,620 Beginning of year, as restated (Note 15) 2,133,794 72,218,148 End of year 2,307,651$ 80,115,463$ (Concluded) City of PleasantonCombining Statement of Revenues, Expenditures, and Changes in Fund Balances (Continued)Nonmajor Governmental FundsFor the Year Ended June 30, 2024 188
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 200$ 200$ 819$ 619$ Total Revenues200 200 819 619 EXPENDITURES:Current:Public safety 9,400 9,400 862 8,538 Total Expenditures9,400 9,400 862 8,538 NET CHANGE IN FUND BALANCE(9,200)$ (9,200)$ (43) 9,157$ FUND BALANCE:Beginning of year 17,814 End of year 17,771$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualD.A.R.E Trust Special Revenue FundFor the Year Ended June 30, 2024 189
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 100$ 100$ 1,238$ 1,138$ Total Revenues100 100 1,238 1,138 EXPENDITURES:Current:Public safety 3,000 3,000 - 3,000 Total Expenditures3,000 3,000 - 3,000 NET CHANGE IN FUND BALANCE(2,900)$ (2,900)$ 1,238 4,138$ FUND BALANCE:Beginning of year 27,935 End of year 29,173$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualAsset Forfeiture Special Revenue FundFor the Year Ended June 30, 2024 190
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 10,000$ 10,000$ 30,129$ 20,129$ Total Revenues10,000 10,000 30,129 20,129 NET CHANGE IN FUND BALANCE10,000$ 10,000$ 30,129 20,129$ FUND BALANCE:Beginning of year 679,751 End of year 709,880$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualCBD Parking In-Lieu Special Revenue FundFor the Year Ended June 30, 2024 191
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 354,000$ 354,000$ 342,931$ (11,069)$ Use of money and property 15,500 15,500 29,319 13,819 Miscellaneous - - 356 356 Total Revenues369,500 369,500 372,606 3,106 EXPENDITURES:Current:General government 664,695 664,695 424,794 239,901 Debt service:Principal retirement - - 30,736 (30,736) Interest and fiscal charges - - 674 (674) Total Expenditures664,695 664,695 456,204 208,491 NET CHANGE IN FUND BALANCE(295,195)$ (295,195)$ (83,598) 211,597$ FUND BALANCE:Beginning of year 624,306 End of year 540,708$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualResource Management Special Revenue FundFor the Year Ended June 30, 2024 192
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 1,800$ 1,800$ 6,635$ 4,835$ Contributions 67,000 217,000 104,021 (112,979) Total Revenues68,800 218,800 110,656 (108,144) EXPENDITURES:Current:Public safety 4,000 4,000 4,000 - Community activities 91,000 136,000 59,763 76,237 Total Expenditures95,000 140,000 63,763 76,237 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(26,200) 78,800 46,893 (31,907) OTHER FINANCING (USES):Transfers out - (200,000) (18,714) 181,286 Total other financing (uses)- (200,000) (18,714) 181,286 NET CHANGE IN FUND BALANCE(26,200)$ (121,200)$ 28,179 149,379$ FUND BALANCE:Beginning of year 416,675 End of year 444,854$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualMiscellaneous Donations Special Revenue FundFor the Year Ended June 30, 2024 193
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Assessments 129,947$ 129,947$ 130,394$ 447$ Use of money and property 2,550 2,550 17,850 15,300 Miscellaneous 11,559 11,559 12,680 1,121 Total Revenues144,056 144,056 160,924 16,868 EXPENDITURES:Current:Public works 190,240 190,240 141,835 48,405 Total Expenditures190,240 190,240 141,835 48,405 NET CHANGE IN FUND BALANCE(46,184)$ (46,184)$ 19,089 65,273$ FUND BALANCE:Beginning of year, as restated (Note 15) 416,778 End of year 435,867$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualLandscape and Lighting Districts Special Revenue FundFor the Year Ended June 30, 2024 194
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 15,000$ 15,000$ 45,456$ 30,456$ Miscellaneous 15,534 15,534 - (15,534) Total Revenues30,534 30,534 45,456 14,922 EXPENDITURES:Current:Public works 23,500 23,500 8,305 15,195 Total Expenditures23,500 23,500 8,305 15,195 NET CHANGE IN FUND BALANCE7,034$ 7,034$ 37,151 30,117$ FUND BALANCE:Beginning of year, as restated (Note 15) 1,053,722 End of year 1,090,873$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualLandscape Maintenance N.P.I.D. Special Revenue FundFor the Year Ended June 30, 2024 195
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Assessments 85,900$ 85,900$ 85,785$ (115)$ Use of money and property 17,100 17,100 55,561 38,461 Miscellaneous 1,229 1,229 1,353 124 Total Revenues104,229 104,229 142,699 38,470 EXPENDITURES:Current:Public works 195,557 218,557 46,328 172,229 Total Expenditures195,557 218,557 46,328 172,229 NET CHANGE IN FUND BALANCE(91,328)$ (114,328)$ 96,371 210,699$ FUND BALANCE:Beginning of year 1,293,048 End of year 1,389,419$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualGeologic Hazard Assessment Districts Special Revenue FundFor the Year Ended June 30, 2024 196
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 3,003$ 3,003$ 56,434$ 53,431$ Total Revenues3,003 3,003 56,434 53,431 EXPENDITURES:Capital outlay - 379,945 140,726 239,219 Total Expenditures- 379,945 140,726 239,219 NET CHANGE IN FUND BALANCE3,003$ (376,942)$ (84,292) 292,650$ FUND BALANCE:Beginning of year 485,075 End of year 400,783$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualMeasure B Transportation Improvements Special Revenue FundFor the Year Ended June 30, 2024 197
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 4,212,921$ 4,039,018$ 4,223,472$ 184,454$ Use of money and property 20,000 20,000 162,625 142,625 Miscellaneous - - 4,076 4,076 Total Revenues4,232,921 4,059,018 4,390,173 331,155 EXPENDITURES:Current:Public works - - 7,500 (7,500) Capital outlay 5,575,000 10,419,112 2,302,825 8,116,287 Total Expenditures5,575,000 10,419,112 2,310,325 8,108,787 NET CHANGE IN FUND BALANCE(1,342,079)$ (6,360,094)$ 2,079,848 8,439,942$ FUND BALANCE:Beginning of year 5,757,974 End of year 7,837,822$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualGas Tax Special Revenue FundFor the Year Ended June 30, 2024 198
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 201,466$ 201,466$ 123,118$ (78,348)$ Use of money and property - - 19,518 19,518 Miscellaneous - - 19 19 Total Revenues201,466 201,466 142,655 (58,811) EXPENDITURES:Current:Community development 132,481 373,657 131,198 242,459 Total Expenditures132,481 373,657 131,198 242,459 NET CHANGE IN FUND BALANCE68,985$ (172,191)$ 11,457 183,648$ FUND BALANCE:Beginning of year, as restated (Note 15) 741,437 End of year 752,894$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualHOME Program Special Revenue FundFor the Year Ended June 30, 2024 199
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 30,000$ 30,000$ 26,854$ (3,146)$ Use of money and property 2,600 2,600 5,435 2,835 Total Revenues32,600 32,600 32,289 (311) EXPENDITURES:Current:Public safety 30,000 30,000 26,854 3,146 Total Expenditures30,000 30,000 26,854 3,146 NET CHANGE IN FUND BALANCE2,600$ 2,600$ 5,435 2,835$ FUND BALANCE:Beginning of year 112,489 End of year 117,924$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualAbandoned Vehicle Special Revenue FundFor the Year Ended June 30, 2024 200
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 100$ 100$ 2,125$ 2,025$ Fines and forfeitures - - 33,700 33,700 Contributions 50,000 650,000 914,979 264,979 Miscellaneous 500 500 1,040 540 Total Revenues50,600 650,600 951,844 301,244 EXPENDITURES:Current:Public works 29,500 29,500 42,474 (12,974) Capital outlay - 330,645 249,706 80,939 Total Expenditures29,500 360,145 292,180 67,965 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES21,100 290,455 659,664 369,209 OTHER FINANCING (USES):Transfers out (25,000) (25,000) (25,000) - Total other financing (uses)(25,000) (25,000) (25,000) - NET CHANGE IN FUND BALANCE(3,900)$ 265,455$ 634,664 369,209$ FUND BALANCE:Beginning of year 432,945 End of year 1,067,609$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualUrban Forestry Program Special Revenue FundFor the Year Ended June 30, 2024 201
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Miscellaneous 150,000$ 150,000$ 164,776$ 14,776$ Total Revenues150,000 150,000 164,776 14,776 EXPENDITURES:Current:Community development 150,000 300,000 164,776 135,224 Total Expenditures150,000 300,000 164,776 135,224 NET CHANGE IN FUND BALANCE-$ (150,000)$ - 150,000$ FUND BALANCE:Beginning of year - End of year -$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualHBPOA Maintenance District Special Revenue FundFor the Year Ended June 30, 2024 202
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 436,730$ 436,730$ 182,387$ (254,343)$ Miscellaneous 42,883 42,883 177 (42,706) Total Revenues479,613 479,613 182,564 (297,049) EXPENDITURES:Current:Community development 383,057 383,057 158,854 224,203 Debt service:Principal retirement 24,282 24,282 50,000 (25,718) Interest and fiscal charges 17,165 17,165 17,164 1 Total Expenditures424,504 424,504 226,018 198,486 NET CHANGE IN FUND BALANCE55,109$ 55,109$ (43,454) (98,563)$ FUND BALANCE:Beginning of year, as restated (Note 15) 565,840 End of year 522,386$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualCommunity Development Block Grant Special Revenue FundFor the Year Ended June 30, 2024 203
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 500$ 500$ 1,233$ 733$ Total Revenues500 500 1,233 733 NET CHANGE IN FUND BALANCE500$ 500$ 1,233 733$ FUND BALANCE:Beginning of year 27,817 End of year 29,050$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualDowntown Economic Loan Special Revenue FundFor the Year Ended June 30, 2024 204
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 26,000$ 26,000$ 89,664$ 63,664$ Miscellaneous 250,000 250,000 220,805 (29,195) Total Revenues276,000 276,000 310,469 34,469 EXPENDITURES:Current:General government 70,000 70,000 518,731 (448,731) Capital outlay 150,000 625,000 15,896 609,104 Total Expenditures220,000 695,000 534,627 160,373 NET CHANGE IN FUND BALANCE56,000$ (419,000)$ (224,158) 194,842$ FUND BALANCE:Beginning of year 1,760,652 End of year 1,536,494$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualCommunity Access Television Special Revenue FundFor the Year Ended June 30, 2024 205
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 1,500$ 1,500$ 4,884$ 3,384$ Total Revenues1,500 1,500 4,884 3,384 NET CHANGE IN FUND BALANCE1,500$ 1,500$ 4,884 3,384$ FUND BALANCE:Beginning of year 110,182 End of year 115,066$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualMarilyn Murphy Kane Trail Reserve Special Revenue FundFor the Year Ended June 30, 2024 206
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 9,600$ 9,600$ 38,241$ 28,641$ Total Revenues9,600 9,600 38,241 28,641 EXPENDITURES:Capital outlay - 133,902 - 133,902 Total Expenditures- 133,902 - 133,902 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES9,600 (124,302) 38,241 162,543 OTHER FINANCING (USES):Transfers out - - (1,832) (1,832) Total other financing (uses)- - (1,832) (1,832) NET CHANGE IN FUND BALANCE9,600$ (124,302)$ 36,409 160,711$ FUND BALANCE:Beginning of year 807,606 End of year 844,015$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualSpecific Plans Special Revenue FundFor the Year Ended June 30, 2024 207
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 380,459$ 380,459$ 356,097$ (24,362)$ Use of money and property 3,000 3,000 2,388 (612) Total Revenues383,459 383,459 358,485 (24,974) EXPENDITURES:Capital outlay 450,000 799,822 - 799,822 Total Expenditures450,000 799,822 - 799,822 NET CHANGE IN FUND BALANCE(66,541)$ (416,363)$ 358,485 774,848$ FUND BALANCE:Beginning of year 446,515 End of year 805,000$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualMeasure F Vehicle Registration Fees Special Revenue FundFor the Year Ended June 30, 2024 208
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental 2,283,405$ 2,283,405$ 2,349,468$ 66,063$ Use of money and property 8,000 8,000 77,670 69,670 Total Revenues2,291,405 2,291,405 2,427,138 135,733 EXPENDITURES:Capital outlay 3,720,000 6,959,098 600,199 6,358,899 Total Expenditures3,720,000 6,959,098 600,199 6,358,899 NET CHANGE IN FUND BALANCE(1,428,595)$ (4,667,693)$ 1,826,939 6,494,632$ FUND BALANCE:Beginning of year 4,342,610 End of year 6,169,549$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualMeasure BB Transportation Improvements Special Revenue FundFor the Year Ended June 30, 2024 209
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 500$ 500$ 3,990$ 3,490$ Miscellaneous 30,000 30,000 31,506 1,506 Total Revenues30,500 30,500 35,496 4,996 EXPENDITURES:Current:Community development 5,000 5,000 10,907 (5,907) Total Expenditures5,000 5,000 10,907 (5,907) NET CHANGE IN FUND BALANCE25,500$ 25,500$ 24,589 (911)$ FUND BALANCE:Beginning of year 108,793 End of year 133,382$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualAB1379 CASp Certification and Training Special Revenue FundFor the Year Ended June 30, 2024 210
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property -$ -$ 59,269$ 59,269$ Miscellaneous 350,000 350,000 - (350,000) Total Revenues350,000 350,000 59,269 (290,731) EXPENDITURES:Current:Community development - 60,000 37,400 22,600 Total Expenditures- 60,000 37,400 22,600 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES350,000 290,000 21,869 (268,131) OTHER FINANCING (USES):Transfers out (350,000) (350,000) (350,000) - Total other financing (uses)(350,000) (350,000) (350,000) - NET CHANGE IN FUND BALANCE-$ (60,000)$ (328,131) (268,131)$ FUND BALANCE:Beginning of year, as restated (Note 15) 2,740,518 End of year 2,412,387$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualBusiness Support Program Special Revenue FundFor the Year Ended June 30, 2024 211
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property -$ -$ 116,835$ 116,835$ Miscellaneous - - 864,049 864,049 Total Revenues- - 980,884 980,884 EXPENDITURES:Current:Public works 653,111 653,111 139,847 513,264 Total Expenditures653,111 653,111 139,847 513,264 NET CHANGE IN FUND BALANCE(653,111)$ (653,111)$ 841,037 1,494,148$ FUND BALANCE:Beginning of year 3,236,054 End of year 4,077,091$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualPleasanton Garbage Service Rate Reserve Special Revenue FundFor the Year Ended June 30, 2024 212
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property -$ -$ 41,685$ 41,685$ Total Revenues- - 41,685 41,685 EXPENDITURES:Capital outlay 552,497 552,497 - 552,497 Total Expenditures552,497 552,497 - 552,497 NET CHANGE IN FUND BALANCE(552,497)$ (552,497)$ 41,685 594,182$ FUND BALANCE:Beginning of year 940,478 End of year 982,163$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualJohnson Drive Economic Development Zone Special Revenue FundFor the Year Ended June 30, 2024 213
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Intergovernmental -$ 56,100$ 58,421$ 2,321$ Use of money and property - - (4,120) (4,120) Total Revenues- 56,100 54,301 (1,799) EXPENDITURES:Current:Community activities - 50,000 18,549 31,451 Total Expenditures- 50,000 18,549 31,451 NET CHANGE IN FUND BALANCE-$ 6,100$ 35,752 29,652$ FUND BALANCE:Beginning of year 80,905 End of year 116,657$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualOpioid Settlements Special Revenue FundFor the Year Ended June 30, 2024 214
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 40,000$ 40,000$ 154,707$ 114,707$ Total Revenues40,000 40,000 154,707 114,707 EXPENDITURES:Capital outlay 2,250,000 3,040,525 - 3,040,525 Total Expenditures2,250,000 3,040,525 - 3,040,525 NET CHANGE IN FUND BALANCE(2,210,000)$ (3,000,525)$ 154,707 3,155,232$ FUND BALANCE:Beginning of year, as restated (Note 15) 3,558,125 End of year 3,712,832$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualCIP for Downtown & North Pleasanton Capital Projects FundFor the Year Ended June 30, 2024 215
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property -$ -$ 60,351$ 60,351$ Development fees 754,985 6,689,216 1,300,930 (5,388,286) Total Revenues754,985 6,689,216 1,361,281 (5,327,935) EXPENDITURES:Capital outlay 3,097,131 5,366,913 16,716 5,350,197 Total Expenditures3,097,131 5,366,913 16,716 5,350,197 NET CHANGE IN FUND BALANCE(2,342,146)$ 1,322,303$ 1,344,565 22,262$ FUND BALANCE:Beginning of year 649,403 End of year 1,993,968$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualPublic Facilities Capital Projects FundFor the Year Ended June 30, 2024 216
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 99,859$ 99,859$ 452,679$ 352,820$ Total Revenues99,859 99,859 452,679 352,820 EXPENDITURES:Capital outlay 300,000 8,672,422 551,911 8,120,511 Total Expenditures300,000 8,672,422 551,911 8,120,511 NET CHANGE IN FUND BALANCE(200,141)$ (8,572,563)$ (99,232) 8,473,331$ FUND BALANCE:Beginning of year 8,984,812 End of year 8,885,580$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualPark Development Capital Projects FundFor the Year Ended June 30, 2024 217
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property -$ -$ 5,119$ 5,119$ Total Revenues- - 5,119 5,119 EXPENDITURES:Current:Public works - 3,100 - 3,100 Capital outlay 1,065,500 2,618,098 559,235 2,058,863 Total Expenditures1,065,500 2,621,198 559,235 2,061,963 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(1,065,500) (2,621,198) (554,116) 2,067,082 OTHER FINANCING SOURCES:Transfers in 1,500,000 1,856,072 1,674,786 (181,286) Total other financing sources1,500,000 1,856,072 1,674,786 (181,286) NET CHANGE IN FUND BALANCE434,500$ (765,126)$ 1,120,670 1,885,796$ FUND BALANCE:Beginning of year 2,319,691 End of year 3,440,361$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualPark Capital Improvement Program Capital Project FundFor the Year Ended June 30, 2024 218
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 100,000$ 100,000$ 392,206$ 292,206$ Miscellaneous - - 40,755 40,755 Total Revenues100,000 100,000 432,961 332,961 EXPENDITURES:Current:Public works - - 1,259 (1,259) Capital outlay 750,000 7,223,857 62,655 7,161,202 Total Expenditures750,000 7,223,857 63,914 7,159,943 EXCESS OF REVENUES OVER(UNDER) EXPENDITURES(650,000) (7,123,857) 369,047 7,492,904 OTHER FINANCING SOURCES (USES):Transfers in - 83,527 83,527 - Transfers out (1,500,000) (1,500,000) (1,500,000) - Total other financing sources (uses)(1,500,000) (1,416,473) (1,416,473) - NET CHANGE IN FUND BALANCE(2,150,000)$ (8,540,330)$ (1,047,426) 7,492,904$ FUND BALANCE:Beginning of year 9,017,320 End of year 7,969,894$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualStreet Capital Improvement Program Capital Projects FundFor the Year Ended June 30, 2024 219
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 14,405$ 14,405$ 402,352$ 387,947$ Development fees 996,439 996,439 691,036 (305,403) Total Revenues1,010,844 1,010,844 1,093,388 82,544 EXPENDITURES:Capital outlay 1,400,000 11,343,079 475,253 10,867,826 Total Expenditures1,400,000 11,343,079 475,253 10,867,826 NET CHANGE IN FUND BALANCE(389,156)$ (10,332,235)$ 618,135 10,950,370$ FUND BALANCE:Beginning of year 9,779,842 End of year 10,397,977$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualTraffic Impact Capital Projects FundFor the Year Ended June 30, 2024 220
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 29,112$ 29,112$ 307,965$ 278,853$ Contributions - - 36,770 36,770 Total Revenues29,112 29,112 344,735 315,623 EXPENDITURES:Capital outlay - 6,735,619 62,928 6,672,691 Total Expenditures- 6,735,619 62,928 6,672,691 NET CHANGE IN FUND BALANCE29,112$ (6,706,507)$ 281,807 6,988,314$ FUND BALANCE:Beginning of year 7,378,673 End of year 7,660,480$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualBudgeted Developer Projects Capital Projects FundFor the Year Ended June 30, 2024 221
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property -$ -$ 52,027$ 52,027$ Total Revenues- - 52,027 52,027 EXPENDITURES:Current:Community development - - 41,028 (41,028) Capital outlay - 1,197,475 11,665 1,185,810 Total Expenditures- 1,197,475 52,693 1,144,782 NET CHANGE IN FUND BALANCE-$ (1,197,475)$ (666) 1,196,809$ FUND BALANCE:Beginning of year 1,109,244 End of year 1,108,578$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualAssessment District Construction Capital Projects FundFor the Year Ended June 30, 2024 222
Variance withFinal BudgetActual PositiveOriginal Final Amounts (Negative)REVENUES: Use of money and property 6,000$ 6,000$ 97,285$ 91,285$ Development fees 476,415 476,415 76,572 (399,843) Total Revenues482,415 482,415 173,857 (308,558) EXPENDITURES:Capital outlay - 1,852,517 - 1,852,517 Total Expenditures- 1,852,517 - 1,852,517 NET CHANGE IN FUND BALANCE482,415$ (1,370,102)$ 173,857 1,543,959$ FUND BALANCE:Beginning of year 2,133,794 End of year 2,307,651$ Budgeted AmountsCity of PleasantonSchedule of Revenues, Expenditures, and Changes in Fund Balance - Budget and ActualTri-Valley Transportation Capital Projects FundFor the Year Ended June 30, 2024 223
This page intentionally left blank.
224
NONMAJOR ENTERPRISE FUND FINANCIAL STATEMENTSEnterprise Fundsaccount for operations that are financed and operated in a manner similar to private business enterprises, wherethe intent of the governing body is that the costs (including depreciation) of providing goods and services to the general public on acontinuing basis be recovered through user charges.Transit - This fund receives revenue from Measure BB sales tax and is used for transit related services. Cemetery -This fund accounts for the operations of the Pleasanton Pioneer Cemetery. The City currently contracts with Graham-Hitch Mortuary for cemetery management, sales and burial coordination. The Cemetery Fund is supported by an operating subsidycontribution from the General Fund.Housing Authority -This fund represents the activities of the Pleasanton Housing Authority. The purpose is to provide and maintainthe maximum number of housing units and services for low and moderate income families at rents they can afford. 225
This page intentionally left blank.
226
HousingTransit Cemetery Authority TotalASSETSCurrent assets:Pooled cash and investments 709,559$ 863,616$ 356,234$ 1,929,409$ Receivable:Accounts 99,009 22,717 - 121,726 Accrued interest 1,537 1,908 - 3,445 Total current assets810,105 888,241 356,234 2,054,580 Noncurrent assets:Capital assets:Nondepreciable - 10,000 51,751 61,751 Depreciable, net 164,063 736,933 - 900,996 Total capital assets 164,063 746,933 51,751 962,747 Total noncurrent assets164,063 746,933 51,751 962,747 Total assets974,168 1,635,174 407,985 3,017,327 LIABILITIESCurrent liabilities:Accounts payable 213,915 36,382 - 250,297 Accrued payroll 3,273 3,636 - 6,909 Advances from other funds - 500,000 - 500,000 Unearned revenues - 919,085 - 919,085 Total current liabilities217,188 1,459,103 - 1,676,291 Total liabilities217,188 1,459,103 - 1,676,291 NET POSITIONInvestment in capital assets 164,063 746,933 51,751 962,747 Restricted for transportation 592,917 - - 592,917 Unrestricted (deficit) - (570,862) 356,234 (214,628)Total net position756,980$ 176,071$ 407,985$ 1,341,036$ June 30, 2024Business-Type Activities - Enterprise Funds City of PleasantonCombining Statement of Net PositionNonmajor Enterprise Funds 227
HousingTransit Cemetery Authority TotalOPERATING REVENUES:Charges for services -$ 191,901$ -$ 191,901$ Miscellaneous 1,587 3,573 - 5,160 Total operating revenues1,587 195,474 - 197,061 OPERATING EXPENSES:Personnel services 34,689 38,616 - 73,305 Transportation 66,010 - - 66,010 Repairs and maintenance - - - - Materials, supplies and services 485,726 315,881 - 801,607 Depreciation 25,723 31,486 - 57,209 Total operating expenses612,148 385,983 - 998,131 OPERATING (LOSS)(610,561) (190,509) - (801,070) NONOPERATING INCOME:Intergovernmental 586,743 - - 586,743 Investment income 21,602 33,508 - 55,110 Total nonoperating income608,345 33,508 - 641,853 NET INCOME BEFORE TRANSFERS(2,216) (157,001) - (159,217) TRANSFERS:Transfers in 81,396 50,000 - 131,396 Total Transfers81,396 50,000 - 131,396 CHANGES IN NET POSITION79,180 (107,001) - (27,821) NET POSITION:Beginning of year, as previously presented as of June 30, 2023 677,800 561,508 407,985 1,647,293 Error corrections - (278,436) - (278,436) Beginning of year, as restated (Note 15) 677,800 283,072 407,985 1,368,857 End of year 756,980$ 176,071$ 407,985$ 1,341,036$ Business-Type Activities - Enterprise Funds For the Year Ended June 30, 2024City of PleasantonCombining Statement of Revenues, Expenses and Changes in Net PositionNonmajor Enterprise Funds 228
HousingTransit Cemetery Authority TotalCASH FLOWS FROM OPERATING ACTIVITIES:Cash receipts from customers 32$ 318,755$ -$ 318,787$ Cash payments to suppliers for goods and services (419,121) (333,120) - (752,241) Cash payments to or on behalf of employees (31,701) (35,431) - (67,132) Net cash (used in ) operating activities(450,790) (49,796) - (500,586) CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES:Interfund receipts 81,396 50,000 - 131,396Intergovernmental receipts 601,504 - - 601,504 Net cash provided by noncapital financing activities682,900 50,000 - 732,900 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES:Acquisition of capital assets (146,699) - - (146,699) Net cash (used in) capital and relatedfinancing activities(146,699) - - (146,699) CASH FLOWS FROM INVESTING ACTIVITIES:Investment earnings 21,246 33,242 - 54,488 Net cash provided by investing activities21,246 33,242 - 54,488 Net change in cash and cash equivalents106,657 33,446 - 140,103 CASH AND CASH EQUIVALENTS:Beginning of year 602,902 830,170 356,235 1,789,307 End of year 709,559$ 863,616$ 356,235$ 1,929,410$ CASH AND CASH EQUIVALENTS:Cash and investments 709,559 863,616 356,235 1,929,410 Total cash and cash equivalents709,559$ 863,616$ 356,235$ 1,929,410$ Reconciliation of Operating (Loss) toto Net Cash (Used in) Operating Activities:Operating (loss) (610,561) (190,509) - (801,070) Adjustments to reconcile operating (loss)to net cash (used in) operating activities:Depreciation 25,723 31,486 - 57,209(Increase) decrease in accounts receivable, net - 1,100 - 1,100Increase (decrease) in accounts payable 132,615 (17,239) - 115,376Increase (decrease) in payroll payable 2,988 3,185 - 6,173Increase(decrease) in unearned revenue (1,555) 122,181 - 120,626Net cash (used in) operating activities (450,790)$ (49,796)$ -$ (500,586)$ For the Year Ended June 30, 2024Business-Type Activities - Enterprise Funds City of PleasantonCombining Statement of Cash FlowsNonmajor Enterprise Funds 229
This page intentionally left blank.
230
Retiree Insurance Reserve - This fund is establishing reserves for future medical insurance obligations for retirees.PARS Section 115 -This fund is to provide additional annual payments to PERS that are needed to offset the impact of smoothingor negative amortization of the City's Unfunded Pension Liability.City Enhancement -This fund is to provide for unplanned and traditionally unfunded priority projects that arise such as employeeworkplace enhancement and miscellaneous emergency renovation projects which are not part of the City's Repair and ReplacementPlan.Self Insurance Retention -This fund pays insurance premiums and claims that fall under the City's various limits and includesworkers' compensation.INTERNAL SERVICE FUNDSInternal Service Fundsaccount for the financing of goods or services provided by a department for other departments on a cost-reimbursement basis.Employee Benefits -This fund accounts for unemployment insurance benefit costs and accrued unused employee vacation leave.Revenues come from benefit accrual charges placed on all City operating programs. This fund also includes the accounting for themajority of the City's Net Pension Liability.Public Art Acquisition and Maintenance -This fund is to provide a source of public funding for the design, selection, acquisition,purchase, renovation, conservation, and installation of City-owned public art.Replacement / Renovation -This fund charges various user departments based on usage of equipment, vehicles, and facilities anduses the money to replace or renovate these items. 231
Public ArtEmployee Acquisition and Replacement/Self-InsuranceBenefits Maintenance Renovation RetentionASSETSCurrent assets:Pooled cash and investments 5,967,369$ 399,714$ 23,081,373$ 9,509,474$ Restricted cash and investments - - 112,539 - Receivable (net):Accounts 7,571 - 15,739 25,717 Accrued Interest 10,568 845 48,841 12,304 Prepaid items - - 1,158,892 - Total current assets 5,985,508 400,559 24,417,384 9,547,495 Noncurrent assets:Advances to other funds - - 977,813 - Capital assets, nondepreciable - 367,893 - - Capital assets, depreciable/amortizable (net) - - 11,118,459 - Total noncurrent assets - 367,893 12,096,272 - Total assets5,985,508 768,452 36,513,656 9,547,495 DEFERRED OUTFLOWS OF RESOURCESRelated to pensions 52,056,809 - - - Related to OPEB - - - - Total deferred outflows of resources52,056,809 - - - LIABILITIESCurrent Liabilities:Accounts payable 1,152,177 7,296 434,224 122,455 Accrued liabilities - - - - Accrued interest - - 12,115 - Accrued compensated absences, due within one year1,447,930 - - - Claims payable, due within one year - - - 1,735,273 Financed purchase, due within one year - - 540,531 - Total current liabilities2,600,107 7,296 986,870 1,857,728 Noncurrent liabilities:Accrued compensated absences, due in more than one year3,540,876 - - -Net pension liability 165,992,501 - - - Net OPEB liability - - - - Claims payable, due in more than one year- - - 8,764,830 Financed purchase, due in more than one year - - 1,533,168 - Total noncurrent liabilities169,533,377 - 1,533,168 8,764,830 Total liabilities172,133,484 7,296 2,520,038 10,622,558DEFERRED INFLOWS OF RESOURCESRelated to pensions 4,530,800 - - - Related to OPEB - - - - Total deferred inflows of resources4,530,800 - - - NET POSITIONNet investment in capital assets - 367,893 9,044,760 - Restricted - - 112,539 - Unrestricted (deficit) (118,621,967) 393,263 24,836,319 (1,075,063) Total net position(118,621,967)$ 761,156$ 33,993,618$ (1,075,063)$ (Continued) June 30, 2024City of PleasantonCombining Statement of Net PositionAll Internal Service Funds 232
RetireeInsurance PARS Section CityReserve 115 EnhancementTotalASSETSCurrent assets:Pooled cash and investments 1,286,509$ -$ 537,497$ 40,781,936$ Restricted cash and investments - 31,588,706 - 31,701,245 Receivable (net):Accounts - - - 49,027 Accrued Interest 3,032 - 1,219 76,809 Prepaid items - - - 1,158,892 Total current assets 1,289,541 31,588,706 538,716 73,767,909 Noncurrent assets:Advances to other funds - - - 977,813 Capital assets, nondepreciable - - - 367,893 Capital assets, depreciable/amortizable (net) - - - 11,118,459 Total noncurrent assets - - - 12,464,165 Total assets1,289,541 31,588,706 538,716 86,232,074 DEFERRED OUTFLOWS OF RESOURCESRelated to pensions - - - 52,056,809 Related to OPEB 10,817,974 - - 10,817,974 Total deferred outflows of resources10,817,974 - - 62,874,783 LIABILITIESCurrent Liabilities:Accounts payable 68,866 - - 1,785,018 Accrued liabilities - - - - Accrued interest - - - 12,115 Accrued compensated absences, due within one year- - - 1,447,930 Claims payable, due within one year - - - 1,735,273 Financed purchase, due within one year - - - 540,531 Total current liabilities 68,866 - - 5,520,867 Noncurrent liabilities:Accrued compensated absences, due in more than one year- - - 3,540,876Net pension liability - - - 165,992,501 Net OPEB liability 17,055,865 - - 17,055,865 Claims payable, due in more than one year- - - 8,764,830 Financed purchase, due in more than one year - - - 1,533,168 Total noncurrent liabilities17,055,865 - - 196,887,240 Total liabilities17,124,731 - - 202,408,107DEFERRED INFLOWS OF RESOURCESRelated to pensions - - - 4,530,800 Related to OPEB 6,358,233 - - 6,358,233 Total deferred inflows of resources6,358,233 - - 10,889,033 NET POSITIONNet investment in capital assets - - - 9,412,653 Restricted - 31,588,706 - 31,701,245 Unrestricted (deficit) (11,375,449) - 538,716 (105,304,181) Total net position(11,375,449)$ 31,588,706$ 538,716$ (64,190,283)$ (Concluded) June 30, 2024City of PleasantonCombining Statement of Net Position (Continued)All Internal Service Funds 233
Public ArtEmployee Acquisition and Replacement/ Self-InsuranceBenefits Maintenance Renovation RetentionOPERATING REVENUES:Sales and service charges 172,520$ 104,000$ 7,073,032$ 8,101,059$ Miscellaneous - - - 89,316 Total operating revenues172,520 104,000 7,073,032 8,190,375OPERATING EXPENSES:Transportation - - 264,771 -Personnel services & OPEB adjustment 12,255,480 - - -Repairs and maintenance - - 785,992 -Materials, supplies and services 3,300 16,695 1,220,616 7,287,182 Depreciation and amortization - 1,467 2,039,738 - Total operating expenses12,258,780 18,162 4,311,117 7,287,182 OPERATING INCOME (LOSS)(12,086,260) 85,838 2,761,915 903,193 NONOPERATING INCOME (LOSS):Investment income (loss) 199,957 5,922 706,279 253,585 Gain on disposal of capital assets - - 100,408 - Interest and fiscal charges - - (151,031) - Total nonoperating income (loss)199,957 5,922 655,656 253,585 INCOME BEFORE TRANSFERS(11,886,303) 91,760 3,417,571 1,156,778 TRANSFERS:Transfers out - - (1,118,132) - Total transfers- - (1,118,132) - CHANGES IN NET POSITION(11,886,303) 91,760 2,299,439 1,156,778 NET POSITION:Beginning of year, as previously presented as of June 30, 2023 (110,696,324) 669,396 31,835,287 1,728,819 Transfer in between the Employee Benefits and Self Insurance Retention 3,960,660 - - (3,960,660) Error corrections - - (141,108) - Beginning of year, as restated (Note 15) (106,735,664) 669,396 31,694,179 (2,231,841) End of year (118,621,967)$ 761,156$ 33,993,618$ (1,075,063)$ (Continued) For the Year Ended June 30, 2024City of PleasantonCombining Statement of Revenues, Expenses and Changes in Net PositionAll Internal Service Funds 234
RetireeInsurance PARS Section CityReserve 115 Enhancement TotalOPERATING REVENUES:Sales and service charges 5,046,123$ -$ -$ 20,496,734$ Miscellaneous - - - 89,316Total operating revenues5,046,123 - - 20,586,050 OPERATING EXPENSES:Transportation - - - 264,771 Personnel services & OPEB adjustment (2,198,606) - - 10,056,874 Repairs and maintenance - - - 785,992 Materials, supplies and services 8,324 - - 8,536,117 Depreciation and amortization - - - 2,041,205 Total operating expenses(2,190,282) - - 21,684,959 OPERATING INCOME (LOSS)7,236,405 - - (1,098,909) NONOPERATING INCOME (LOSS):Investment income (loss) (47,458) 3,529,175 13,680 4,661,140 Gain on disposal of capital assets - - - 100,408 Interest and fiscal charges - - - (151,031) Total nonoperating income (loss)(47,458) 3,529,175 13,680 4,610,517 INCOME BEFORE TRANSFERS7,188,947 3,529,175 13,680 3,511,608 TRANSFERS:Transfers out (905,000) - - (2,023,132) Total transfers(905,000) - - (2,023,132) CHANGES IN NET POSITION6,283,947 3,529,175 13,680 1,488,476 NET POSITION:Beginning of year, as previously presented as of June 30, 2023 (17,659,396) 28,059,531 525,036 (65,537,651) Transfer in between the Employee Benefits and Self Insurance Retention - - - - Error corrections - - - (141,108) Beginning of year, as restated (Note 15) (17,659,396) 28,059,531 525,036 (65,678,759) End of year (11,375,449)$ 31,588,706$ 538,716$ (64,190,283)$ (Concluded) For the Year Ended June 30, 2024City of PleasantonCombining Statement of Revenues, Expenses and Changes in Net Position (Continued)All Internal Service Funds 235
Public ArtEmployee Acquisition and Replacement/ Self-InsuranceBenefits Maintenance Renovation RetentionCASH FLOWS FROM OPERATING ACTIVITIES:Cash receipts from customers 175,123$ 105,393$ 7,057,293$ 8,164,658$ Cash payments to suppliers (646,224) (9,399) (3,516,825) (7,268,129)Cash payments to or on behalf of employees 147,690 - - (1,000)Claims incurred - - - 477,008Net cash provided by operating activities(323,411) 95,994 3,540,468 1,372,537 CASH FLOWS FROM NONCAPITAL RELATEDFINANCING ACTIVITIES:Interfund receipts - - (1,118,132) - Interfund payments - - (753,414) - Net cash provided by noncapital financing activities- - (1,871,546) - CASH FLOWS FROM CAPITAL AND RELATEDFINANCING ACTIVITIES:Acquisition of capital assets - - (905,769) - Proceeds from issuance of debts - - 1,237,932 - Principal payments on capital debt - - (475,776) - Interest paid on capital debt - - (138,916) - Proceeds from sales of capital assets - - 156,885 - Net cash (used in) capital and relatedfinancing activities- - (125,644) - CASH FLOWS FROM INVESTING ACTIVITIES:Investment earnings (loss) 198,878 5,570 695,334 250,577 Net cash provided by (used in) investing activities198,878 5,570 695,334 250,577 Net change in cash and cash equivalents(124,533) 101,564 2,238,612 1,623,114 CASH AND CASH EQUIVALENTS:Beginning of year 6,091,902 298,150 20,955,300 7,886,360End of year 5,967,369$ 399,714$ 23,193,912$ 9,509,474$ CASH AND CASH EQUIVALENTS:Cash and investments 5,967,369$ 399,714$ 23,081,373$ 9,509,474$ Cash and investments with fiscal agent - - 112,539 - Total cash and cash equivalents5,967,369$ 399,714$ 23,193,912$ 9,509,474$ NONCASH ITEMS:Acquisition of subscription assets-$ -$ 92,280$ -$ Acquisition of financed assets-$ -$ 213,979$ -$ Issuance of subscription liability-$ -$ 92,280$ -$ Issuance of financed purchase liability-$ -$ 213,979$ -$ (Continued) For the Year Ended June 30, 2024City of PleasantonCombining Statement of Cash FlowsAll Internal Service Funds 236
RetireeInsurance PARS Section CityReserve 115 Enhancement TotalCASH FLOWS FROM OPERATING ACTIVITIES:Cash receipts from customers 5,046,123$ -$ -$ 20,548,590$ Cash payments to suppliers (158,755) - - (11,599,332)Cash payments to or on behalf of employees (3,414,687) - - (3,267,997)Claims incurred - - - 477,008Net cash provided by operating activities1,472,681 - - 6,158,269 CASH FLOWS FROM NONCAPITAL RELATEDFINANCING ACTIVITIES:Interfund receipts - - (1,118,132) Interfund payments (905,000) - - (1,658,414) Net cash provided by noncapital financing activities(905,000) - - (2,776,546) CASH FLOWS FROM CAPITAL AND RELATEDFINANCING ACTIVITIES:Acquisition of capital assets - - - (905,769) Proceeds from issuance of debts - - - 1,237,932 Principal payments on capital debt - - - (475,776) Interest paid on capital debt - - - (138,916) Proceeds from sales of capital assets - - - 156,885 Net cash (used in) capital and relatedfinancing activities- - - (125,644) CASH FLOWS FROM INVESTING ACTIVITIES:Investment earnings (loss) (50,462) 3,529,175 13,293 4,642,365 Net cash provided by (used in) investing activities(50,462) 3,529,175 13,293 4,642,365 Net change in cash and cash equivalents517,219 3,529,175 13,293 7,898,444 CASH AND CASH EQUIVALENTS:Beginning of year 769,290 28,059,531 524,204 64,584,737 End of year 1,286,509$ 31,588,706 537,497$ 72,483,181$ CASH AND CASH EQUIVALENTS:Cash and investments 1,286,509$ -$ 537,497$ 40,781,936$ Cash and investments with fiscal agent - 31,588,706 - 31,701,245 Total cash and cash equivalents1,286,509$ 31,588,706 537,497$ 72,483,181$ NONCASH ITEMS:Acquisition of subscription assets-$ -$ -$ 92,280$ Acquisition of financed assets-$ -$ -$ 213,979$ Issuance of subscription liability-$ -$ -$ 92,280$ Issuance of financed purchase liability-$ -$ -$ 213,979$ (Continued) For the Year Ended June 30, 2024City of PleasantonCombining Statement of Cash Flows (Continued)All Internal Service Funds 237