2017-18 Fiscal Year Report Actual vs. Budget

FY 2017-18 Highlights

•Revenue exceeded annual budget by $3.5 million

Major variances include:

• Transfer tax exceeded annual budget by $1.0 million.

• Home sales up 4% over last year (132 vs 127)
• Average Sales Price increased 7% to $2.3 million

• Property taxes exceeded annual budget by $0.8 million:

• Secured property tax +$484 K
• Supplemental property tax +$294 K

• Mutual Aid \ Strike Team revenue was $0.5 million as we participated in battling seasons severe wildfires.

• Recreation revenue up $0.2 million due to increased contract program offerings

Transfer Tax – Recent History

Property Tax – History / FY 18-19 Budget

Note: In the Ten Year Plan, we use the 10 year average growth rate of 4.4%

FY 2017-18 Highlights

Major variances include (continued):

• The following categories also contributed to the revenue gain:

• Business Licenses + $138 K
• Building Permits + $132 K
• Motor Vehicle License Fee + $129 K

• Interest
• Ambulance Fees
• Utility Users Tax
• Community and Veterans

Hall Rental + $ 50 K

+ $ 90 K + $ 71 K + $ 61 K

•Overall, expenditures were under budget by ~$16,000

• All operating departments were under budget with the exception of Fire.

The drivers of the overage in fire were:

• Higher overtime costs, offset by lower regular salaries and retirement costs, which resulted in a budget overage of $235 K.

• This overage is more than offset by the $480 K received for our assistance in battling state’s wildfire’s.

• Premiums for workers compensation and liability insurance were $152 higher than budget.

•In summary, General Fund operating net revenue (revenue less expenses) exceeded budget by $3.5 million.

Update on CalPERS Pension

Components of our pension cost

• Our pension costs consist of the following:

• Normal cost = the present value of the future benefits to be received that is “earned” in the current year of service.

• Actuary’s calculate this based on a series of assumptions, including:

• Demographic: Years of service, salary at time of retirement, retirement ag age of death

• Financial: CalPERS portfolio earnings (discount rate)
• Expressed as a % of payroll and paid in monthly installments.

• Unfunded Actuarial Liability (UAL) = Excess of actuarial accrued liability over value of the pension fund assets.

• Caused by lower than expected investment returns, changes in demogra other assumption changes (lowering assumed discount rate).

• Amortized over 20-30 years.
• Expressed as a $ amount and paid annually.

Employees eligible for retirement:
Safety Tier 1 – 11 eligible, 2 retiring in 2018-19 Misc Tier 1 – 7 eligible, 2 retiring in 2018-19

Payoff of Unfunded Liability is included in our long range plan.

City of Piedmont Pension Tiers – Statistics

Funded CalPERS

City of Piedmont UAL Layers – Safety Tier

• Purpose of the slide is to show what comprises the UAL (Unfunded Accrued Liability), and what affects each year.

• Note – The payoff of the UAL is included in our long term plan.

What is Happening at CalPERS?

• CalPERS’ Portfolio – Annual Earnings is Forecast for next 20 yrs = of 6.6%

• Anticipating Negative Cash Flow for another 9-10 years (due to increasing number of retiree’s).

• Began cutting discount rate. First year affected is 2018-19.

• Policy regarding Amortization on Unfunded Liability to change in 2021.

CalPERS – Recent Changes Change in discount rate from 7.50%:

Rate • 6/30/16 valuation
• 6/30/17 valuation
• 6/30/18 valuation

Initial Full 7.375% 18/19 7.25% 19/20 22/23 23/24 24/25 7.00% 20/21

Risk Mitigation Strategy
• Move to more conservative investments over time • Lower discount rate in concert
• Likely get to 6.0% over 20+ years per Bartel.

Amortization Changes

• Beginning with UAL layers established on or after June 30, 2019 (which affects payments beginning in FY 2021-22) the following changes will be made:

• Amortization of Investment Gain\Loss and Demographic changes will b shortened from 30 to 20 years.

• Eliminate all “Ramp Up and Ramp Down” except for the ramp up on Investment Gain\Loss. This will reduce the amount of “negative amort which will lower interest paid.

• Good news is total interest paid will decrease, but payments wi————-

How will these changes affect the City ?

• Last year, engaged Bartel and Associates to estimate these future co

• Projections assumed discount rate will decline from 7.375% in 2018-19 to 7. 2020-21 per CalPERS policy. And a further decrease to 6.0% over the next 20

• Will need to refresh Bartel’s assumptions to include recent amortization changes.

• ROI for FY ending 6/30/17 was 11.2 %

• However our Unfunded liability increased slightly due primarily to the chang discount rate.

• FY ending 6/30/18 ROI was 8.4 %

• Both our Normal cost and our UAL payments will increase significant steadily over the next 15 years

Effect on General Fund

• The City began addressing the issue earlier this year:

• In May we opened a Section 115 Irrevocable Trust account with the Public Agency Retirement Services (PARS) with a contribution of $2.0 million.

• Projections indicate total expenditures (which includes planned capital transfer exceed revenues in 2023 through 2030. In these years the City may draw from PARS account to ensure a balanced budget.

• In order to not allow the General Fund reserve to drop below 18% of expenditures will need an additional $0.75 million contribution this year, as noted at our previous meeting.

Review of Proposed 2017-18 Year End General Fund Transfers

Year End General Fund Transfers • Recap of variance to budget (000’s):

Year End General Fund Transfers

• We recommend allocation as follows:

• $2.5 million to the Facilities Maintenance Fund.
• $0.75 million to the Pension Rate stabilization fund (PARS)

Equipment Replacement Fund

• At June 30, 2018, the Equipment Replacement fund balance was —- million.

• Based on a review of estimated equipment needs for the next 1 years, and planned annual transfers into the fund, no additional funding is currently needed.

Status of Trust Funds – OPEB and Legacy Police & Fire Pension Fund

• Police & Fire Fund
• Twelve remaining beneficiaries (5 primary, 7 survivor). • Annual benefit payments currently ~$225,000.
• As of 6/30/18, the plan is OVER funded by ~10.5 million

• OPEB Fund

• Currently OPEB is UNDER funded by ~$13.7 million…however,

• Retiree benefits has been reduced to the PEMCHA minimum for all hirees May 1, 2018.

• Will realize a significant cash savings when these employees retire. Cur the average annual cost for a retiree is ~$10,000 compared to ~$1,600 the PEMCHA minimum.

Status of Trust Funds – OPEB and Legacy Police & Fire Pension Fund

• Due to the small number of retiree’s remaining in the Police and fund, coupled with the changes made to the OPEB fund:

• We are projecting the overage in the Police & Fire fund will grow and o the under funded OPEB trust in approximately 12 years. Around 2030.

• Increased funding of OPEB is not recommended at this time. Employee contribute an estimated $100,000 to the fund through payroll deduction FY 2018-19.

Facilities Maintenance Fund

• The maintenance and improvement of city facilities has necessarily been a high priority for the City Council

• Staff completed a review of all City facilities in March of this year report detailed the following through FY 2021-22:

• Annual Operations: Annual recurring expenses required to maintain City facilities, including regular such as janitorial, alarm, pest control, heating systems, fire safety, and annual inspections.

• Annual Maintenance & Repairs: Cost of maintaining, repairing, or replacing various miscellaneous it of the City’s facilities that are malfunctioning, broken, or otherwise have reached their serviceable life.

• Consultant Services: Professional consulting services involving investigation, analysis, and recommendation which form the basis of the project’s next steps. Also included in this category are expenses related t project management services on an as-needed basis since the breath of the projects exceeds Staff capabilities.

• Deferred Maintenance Projects: Planned and prioritized major construction projects of a specific na undertaken to replace, achieve compliance, and/or modernize existing facilities that have been prev deferred.

(a) Assumes the $800,000 bequest from the estate of Anne Kroeger received in FY 2015-16 will be used for Recreation Center upgrades.

Assume 3% annual growth after FY 22-23

Cash Flow Forecast and Investment Results

Cash Flow Forecast

• Prepared a four year cash flow forecast to determine if we invest idle cash.

• Cash flow is very choppy.

• Heavily dependent on property tax receipts

• Flow will allow us to invest approximately $6 – $7 million longer term (up to three years) fixed income securities

Multi-Bank Securities

•Opened account with Multi-Bank Securities •Specializes in fixed income securities •Dedicated account representative
•Easy to use investment platform

• Platform has the ability to assure CD’s purchased do not exceed the maximum insurable by the FDIC ($250,000 pe institution)

Investment Strategy

• In the past, the City invested all Idle cash in LAIF (Local Agency Investment Fund).

• Began investing idle cash with MBS Securities in April.

• In process of building three year CD ladder

• CD’s are currently the best yielding fixed income security allowable under our investment policy, and its fully insured.

Investment Strategy
• Portfolio @ 10/31/18 (000’s):

• Current LAIF Yield is 2.16%. • Was 1.35% back in January

• CD ladder will increase interest earned (as compared to LAIF) in FY 2018-19 by approximately $35,000

Transfer Tax Update Year to Date – October 31

Transfer Tax Update

YTD receipts fairly consistent with past 4 years

• Average seasonality indicates annual transfer tax to be in the $3.0 – $3.2 million range

Transfer Tax Update

• Receipt pattern tends to be choppy the first six months, but fairly consistent the remainder of the year

• Average seasonality indicates annual transfer tax to be in the $3.0 – $3.2 million range

Questions ? Contact City Clerk at 510/420-3040.