HomeMy WebLinkAbout13.a.Att 4-Replacement Page 75, Table 14, Reserve Projections Page 348 of 349
Attachment 4
Table 14—Reserve Projections
Sewer Self-insurance
O&M Fund Construction Fund Totals
Fund (Capital)
Actual Balance as of June 30, 2020 $65,959,541 $73,802,435 $6,758,581 $146,520,557
Projected Balance as of June 30,2021 $43,644,698 $61,605,266** $6,133,581 $111,83,544
Change in Reserve balances during
FY 2021-22:
Net Increases from Revenue over Expenses: $1,989,633 $3,656,246 $366,419 $6,012,298
Planned Transfers in FY 2021-22
($5,169,332) $- $- ($5,169,332)
Projected Balance as of $40,464,998 $65,261,511 $6,500,000 $112,226,509
June 30,2022
Change year over year ($3,179,699) $3,656,246 $366,419 $842,965
Reference: Table 7 Table 13 Self-Insurance See Figure 3
Table 1
Percentage change year over year -7.3% 5.9% 6.0% 0.8%
Ending balance
at 6/30/21 is Funds were set
projected to be aside in
above policy Recent years to
Explanation required level be used toward
due to the funding of
projected O&M future year's
savings in Capital Budgets
FY 2020-21
Comparison to Policy Target-Start of Budget Year
50%of following 3 times
5/12 of annual
Policy Target following year's Year's non-debt deductible of
0&M Budget funded Capital Budget $500,000 plus
$5 million
Reserve Policy Target end of
June 30,2021 $37,905,876 $33,225,750 $6,500,000 $77,631,626
Projected Balance minus Reserve Policy
Target at June 30,2021 $5,738,821 $28,379,516 ($366,419) $33,751,918
Comparison to Policy Target-End of Budget Year
Reserve Policy Target end of
June 30,2022 $40,464,998 $32,506,441 $6,500,000 $79,471,439
Projected Balance less Reserve Policy Target
($0) $32,755,070 ($0) $32,755,070
at June 30,2022
Reserve calculations subject to close of financial results for the year and may differ from projection.
** Excludes projected carryforward of$29,123,770(also to be adjusted for any closeout savings). Projected
reserves at 6/30/2021 and 6/30/2022 would be that amount higher with inclusion of the carryforward.
May 20, 2021 Regular Board Meeting Agenda Packet- Page 4�? of 457