Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Item 6 - Attachment A - Whale Rock Fund Analysis 20230208
CHANGES IN FINANCIAL POSITION - WR 2021-22 2021-22 2022-23 2023-24 2024-25 2025-26 2026-27 2027-28 Link to Backup Info Budget Actuals Current Year Budget Proposed Budget Budget Budget Budget Budget REVENUES BY TYPE Member Agency Contribution (46706)949,126$ 949,126$ 1,126,924$ 1,242,717$ 1,297,986$ 1,318,766$ 1,328,496$ 1,337,888$ Member Agency CIP (Actual + Reserve) (46707)1,401,425$ 1,401,424$ 810,311$ 693,949$ 624,957$ 314,108$ 242,401$ 106,411$ Water Distribution Revenue (46711)299,608$ 143,701$ 365,400$ 535,400$ 588,940$ 612,498$ 636,998$ 662,477$ Investment & Property Revenue (44101)58,713$ (107,365)$ 1,000$ #1,000$ #1,000$ 1,000$ #1,000$ #1,000$ Other Revenue (44310)6,000$ 7,772$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ 6,000$ TOTAL 2,714,871$ 2,394,658$ 2,309,635$ 2,479,067$ 2,518,883$ 2,252,372$ 2,214,894$ 2,113,777$ EXPENDITURE BY CATEGORY Salaries & Benefits 606,272$ 695,766$ 690,983$ 681,107$ 703,958$ 729,047$ 743,711$ 758,696$ Operating Expenditures 609,664$ 309,075$ 618,139$ 829,636$ 910,106$ 923,758$ 937,614$ 951,678$ Capital Outlay (PLUS CARRYOVER)1,716,683$ 76,315$ 2,285,449$ 194,167$ 2,111,089$ 329,029$ 577,500$ 773,300$ Transfers Out 187,511$ 186,211$ 190,202$ 274,374$ 279,861$ 285,459$ 291,168$ 296,991$ TOTAL 3,120,129$ 1,267,367$ 3,784,773$ 1,979,284$ 4,005,014$ 2,267,293$ 2,549,993$ 2,780,666$ EXPENDITURE BY FUNCTION General Government 187,511$ 186,211$ 190,202$ 274,374$ 279,861$ 285,459$ 291,168$ 296,991$ Reservoir Operation 2,932,619$ 1,081,156$ 3,594,571$ 1,704,910$ 3,725,153$ 1,981,834$ 2,258,825$ 2,483,675$ TOTAL 3,120,129$ 1,267,367$ 3,784,773$ 1,979,284$ 4,005,014$ 2,267,293$ 2,549,993$ 2,780,666$ Expenditure Lines Balance TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE CHANGES IN FINANCIAL POSITION Working Capital - Beginning 3,225,851$ 3,226,161$ 4,353,743$ 2,843,266$ 3,321,632$ 1,814,084$ 1,777,746$ 1,421,230$ Revenues over (under) Expenditure (405,258)$ 1,127,291$ (1,475,138)$ 499,783$ (1,486,131)$ (14,921)$ (335,099)$ (666,889)$ Working Capital - Year End (before CalPers Down Payment)2,820,593$ 4,353,452$ 2,878,605$ 3,343,049$ 1,835,501$ 1,799,163$ 1,442,647$ 754,341$ CalPers Down Payment 109,229$ -$ 35,339$ 21,417$ 21,417$ 21,417$ 21,417$ 21,417$ Working Capital - Year End 2,711,364$ 4,353,452$ 2,843,266$ 3,321,632$ 1,814,084$ 1,777,746$ 1,421,230$ 732,924$ Per Audited Financials 4,353,743$ Variance to Audit 291.23$ (290)$ Operating Reserve (20%)280,689$ 238,210$ 299,865$ 357,023$ 378,785$ 387,653$ 394,499$ 401,473$ Capital Outlay Reserve Balance 1,914,603$ 1,914,603$ 1,963,792$ 2,463,575$ 977,442$ 962,522$ 627,423$ (39,467)$ UFL Trust Fund 21,417$ -$ 22,620$ 22,620$ 22,620$ 22,620$ 22,620$ 22,620$ Unreserved Working Capital - Year End 494,655$ 2,200,639$ 556,989$ 478,414$ 435,236$ 404,951$ 376,688$ 348,297$