Loading...
HomeMy WebLinkAbout13 Attachment 3 BPRa3 ReservesVariance 12/31/2020 Invest Income Asset Sale Proceeds Funding @ Budget Additional Fundings All Other Activity, Net NET ACTIVITY TOTAL Goal To Goal ELECTRIC UTILITY BOD approved 4/2021 to Rate Reserve >(490,000) BOD approved 11/2021 to Capital Reserve >(7,431,000) General Fund 11,393,734$47,547$-$-$(7,921,000)$2,413,221$(5,460,232)$5,933,503$-$5,933,503$5,626,000$307,503$5% Capital Reserve 3,636,649 13,417 -257,486 7,431,000 (68,309)7,633,595 11,270,244 -11,270,244 5,708,000 5,562,244 97% Vehicle Reserve 626,347 2,500 66,500 214,556 (650,395)(366,839)259,508 259,508 406,000 (146,492)-36% Deferred Liabilites Rsv.2,085,918 8,479 8,479 2,094,398 -2,094,398 2,000,000 94,398 5% Rate Reserve 5,938,528 26,083 490,000 516,083 6,454,610 -6,454,610 6,458,000 (3,390)0% E subtotal- Reserves 23,681,177$98,027$66,500$472,042$-$1,694,517$2,331,086$26,012,263$-$26,012,263$20,198,000$5,814,263$29% Y2Y Change 2,331,086$2,331,086$ 10%10% RESTRICTED Auction Revenues AB32 - B'21 Use AB32 - B'22 $ Use AB32 Cap & Trade 1,606,959 5,807 847,185 (1,400,000)(547,008)1,059,951 1,059,951 1,000,000 59,951 6% Facility Fees 748,126 3,386 261,440 (1,003,825)(739,000)9,126 9,126 9,000 126 1% POB funds 3 ----3 3 -3 E Total Reserves 26,036,266$107,220$913,685$472,042$261,440$(709,308)$1,045,078$27,081,344$-$27,081,344$21,207,000$5,874,344$28% WATER UTILITY BOD approved 4/2021 from OpRsv to OpGF $1,618,447 General Fund 3,085,600$30,808 1,618,447 710,924 2,360,179$5,445,779$-$5,445,779$4,897,000$548,779$11% Operating Reserve 1,618,447 (1,618,447)(1,618,447)0 -0 -0 Capital Reserve -1,015,747 1,015,747 1,015,747 -1,015,747 2,384,000 (1,368,253)-57% Vehicle Reserve 197,987 1,760 4,750 279,950 --286,460 484,446 -484,446 406,000 78,446 19% DL Surcharge 147,937 601 110,744 (96,216)15,128 163,065 163,065 163,000 65 0% MW & PR PP Connec.Fees 77,788 304 --304 78,093 78,093 78,000 93 0% Deferred Liabilites Rsv.106,226 416 416 106,642 -106,642 107,000 (358)0% W subtotal Reserves 5,233,985$33,888$4,750$1,295,697$110,744$614,708$2,059,787$7,293,772$-$7,293,772$8,035,000$(741,228)$-9% Y2Y Change 2,059,788$2,059,788$ 39%39% W RESTRICTED Facility Fees 1,839,196 6,699 784,087 (356,179)434,607 2,273,803 2,273,803 2,274,000 (197)0% Prop55 Loan Reserve 340,762 (340,762)(340,762)0 0 -0 Bonds, 2015 COPs 137,681 233 233 137,914 137,914 138,000 (86)0% DLAD SRF Loan Reserve 826,526 (826,526)(826,526)---- DLAD Fund 1,530,476 (839,061)(839,061)691,416 691,416 691,000 416 0% West River St. A.D,38,065 149 149 38,214 38,214 38,000 214 1% TSA SAD II Impv.Fd.18,363 72 72 18,435 18,435 18,000 435 2% W Total Reserves 9,965,053$40,809$4,750$1,295,697$894,831$(1,747,586)$488,501$10,453,554$-$10,453,554$11,194,000$(740,446)$-7% Operating (General Fund) Reserve Goal - 50% of annual expenditures, before Depreciation & Purchase Power. There is no "Operating Reserve" defined in District Code; the General Fund serves as the operating reserve. Capital Reserve Goal - average annual budget for capital replacement Vehicle Reserve Goal - sufficient funds to fund necessary expenditures forecasted Deferrred Liabiliites Reserve Goal - dollar amount determined by Board of Directors Rate Reserve Goal - only Electric, minium reserve equal to six months of budgeted purchased power cost. Above report amounts excluded non-cash unrealized gain/loss and discounts/premiums on investments. ATTACHMENT 3 PRELIMINARY FY21 YEAR-END RESERVE BALANCES 2021 Activity Proposed Transfers 3/2/2022 Post- Transfers Balance Preliminary Balance 12/31/2021 Reserve cash balances are impacted by changes in working capital (example Accounts Payable Increase (Decrease), Receivables Decrease (Increase). Genearlly consistent year to year. 2/20/2022 5:32 PM Reserve Account Recons 2021 Summary