The URL can be used to link to this page

Home My WebLink About21 Attachment 3 BPRa3 Reserves ATTACHMENT PRELIMINARY FY22 YEAR-END RESERVE BALANCES 2022 Activity Unaudited Variance Preliminary Proposed Post- Invest Asset Sale Funding @ Additional All Other NETACTIVITY Balance Transfers Transfers 12/31/2021 Income Proceeds Budget Fundings Activity,Net TOTAL 12/31/2022 4/5/2023 Balance Goal To Goal ELECTRIC UTILITY CaIOES Balance is pre-cash flow of Purchase Power variance Dec'22&Jan'23 General Fund $ 5,851,908 $ 39,495 $ $ $ 1,160,114 $ (529,129) $ 670,480 $ 6,522,389 $ 2,350,000 $ 8,872,389 $ 6,807,000 $ 2,065,389 30% Capital Reserve 11,270,380 78,737 - (38,513) 40,224 11,310,604 - 11,310,604 7,235,000 4,075,604 56% Vehicle Reserve 259,508 12,541 4,536 675,000 (181,169) 510,908 770,416 770,416 450,000 320,416 71% Deferred Liabilites Rsv. 2,094,398 13,474 13,474 2,107,871 2,107,871 2,000,000 107,871 5% Rate Reserve 6,454,689 64,690 326,000 390,690 6,845,380 (2,350,000) 4,495,380 6,755,000 (2,259,620) -33% E subtotal-Reserves $ 25,930,884 $ 208,937 $ 4,536 $ 1,001,000 $ 1,160,114 $ (748,812) $ 1,625,775 $ 27,556,660 $ $ 27,556,660 $ 23,247,000 $ 4,309,660 19% Y2Y Change $ 1,625,776 $ 1,625,776 6% 6% RESTRICTED Auction Revenues AB32-B 21 Use AB32 Cap&Trade 1,059,951 4,999 514,604 (1,000,000) (480,398) 579,554 579,554 550,000 29,554 5% Facility Fees 9,126 2,468 173,490 175,958 185,084 185,084 185,000 84 0% POB funds 3 - - (3) (3) - - - - LCFS credits - 68,049 68,049 68,049 68,049 68,000 49 2022 COP Payment Fd 76,881 76,881 76,881 76,881 68,000 8,881 2022 COP Project Fund 21,578 6,500,000 22,984 6,544,562 6,544,562 6,544,562 6,545,000 (438) E Total Reserves $ 26,999,965 $ 237,981 $ 587,189 $ 7,577,881 $ 1,356,588 $ (1,748,815) $ 8,010,825 $ 35,010,790 $ $ 35,010,790 $ 30,663,000 $ 4,347,790 14% WATER UTILITY CalOES&Grant General Fund $ 5,274,230 $ 56,256 $ 292,566 $ 2,059,319 $ 2,408,141 $ 7,682,371 $ 7,682,371 $ 5,567,000 $ 2,115,371 38% Capital Reserve 1,015,747 6,074 6,074 1,021,821 1,021,821 3,928,000 (2,906,179) -74% Vehicle Reserve 484,446 8,456 60,871 240,000 - (411,038) (101,711) 382,735 382,735 450,000 (67,265) -15% DL Surcharge 163,065 2,628 110,914 (99,060) 14,483 177,548 177,548 178,000 (452) 0% MW&PR PP Connec.Fee 78,093 1,200 - - 1,200 79,292 79,292 79,000 292 0% Deferred Liabilites Rsv. 106,642 1,638 1,638 108,280 108,280 108,000 280 0% W subtotal Reserves $ 7,122,223 $ 76,252 $ 60,871 $ 240,000 $ 403,480 $ 1,549,221 $ 2,329,824 $ 9,452,047 $ - $ 9,452,047 $ 10,310,000 $ (857,953) -8% Y2YChange $ 2,329,824 $ 2,329,824 33% 33% W RESTRICTED Facility Fees 2,273,803 23,464 909,475 (574,956) 357,983 2,631,787 2,631,787 2,632,000 (213) 0% 2015 COP Payment Fund 137,914 (5,627) (5,627) 132,287 132,287 132,000 287 2022 COP Payment Fund - 136,297 136,297 136,297 136,297 136,000 297 0% 2022 COP Project Fund - 52,904 15,940,000 17,078 (4,130,317) 11,879,665 11,879,665 11,879,665 11,880,000 (335) DLAD Fund 691,416 2,793 1,877 (575,135) (570,466) 120,950 120,950 121,000 (50) 0% Grant Funds 252,929 - (252,929) (252,929) - - - - #DIV/0! West River St.A.D, 38,214 587 587 38,801 38,801 39,000 (199) -1% TSA SAD II Impv.Fd. 18,435 283 283 18,718 18,718 19,000 (282) -1% W Total Reserves $ 10,534,933 $ 156,283 $ 60,871 $ 16,180,000 $ 1,331,910 $ (3,853,446) $ 13,875,618 $ 24,410,550 $ $ 24,410,550 $ 25,269,000 $ (858,450) -3% Operating(General Fund)Reserve Goal-50%of annual expenditures,before Depreciation&Purchase Power. Above report amounts excluded non-cash Reserve cash balances are impacted by changes in working The General Fund serves as the operating reserve. unrealized gain/loss and discounts/premiums capital(example Accounts Payable Increase(Decrease), Capital Reserve Goal-average annual budget for capital replacement on investments. Receivables Decrease(Increase). Genearlly consistent year Vehicle Reserve Goal-sufficient funds to fund necessary expenditures forecasted to year. Deferrred Liabiliites Reserve Goal-dollar amount determined by Board of Directors Rate Reserve Goal-only Electric,minimum reserve equal to six months of budgeted purchased power cost. 3/26/2023 6:21 PM Reserve Account Recons 2022 Summary