Loading...
10. Scandia Final 2023 Budget 12-20-2022_Small - OLD VERSIONPg. 1 of 73 Pg. 2 of 73 Pg. 3 of 73 Pg. 4 of 73 Pg. 5 of 73 Pg. 6 of 73 Pg. 7 of 73 Pg. 8 of 73 Pg. 9 of 73 Pg. 10 of 73 Pg. 11 of 73 Pg. 12 of 73 Pg. 13 of 73 Pg. 14 of 73 Pg. 15 of 73 Pg. 16 of 73 Pg. 19 of 73 Pg. 20 of 73 Pg. 21 of 73 Pg. 22 of 73 Pg. 23 of 73 Pg. 24 of 73 Pg. 25 of 73 Pg. 26 of 73 Pg. 27 of 73 Pg. 28 of 73 Pg. 29 of 73 Pg. 30 of 73 Pg. 31 of 73 Pg. 32 of 73 Pg. 33 of 73 Pg. 34 of 73 Pg. 35 of 73 Pg. 36 of 73 Pg. 37 of 73 Pg. 38 of 73 Pg. 39 of 73 Pg. 40 of 73 Pg. 41 of 73 Pg. 42 of 73 Pg. 43 of 73 Pg. 44 of 73 Pg. 45 of 73 Pg. 46 of 73 Pg. 47 of 73 Pg. 48 of 73 Pg. 49 of 73 Pg. 50 of 73 Pg. 51 of 73 Pg. 52 of 73 Pg. 53 of 73 Pg. 54 of 73 Pg. 55 of 73 Pg. 56 of 73 Pg. 57 of 73 Pg. 58 of 73 Pg. 59 of 73 Pg. 60 of 73 Pg. 61 of 73 Pg. 62 of 73 Pg. 63 of 73 Pg. 64 of 73 Pg. 65 of 73 Pg. 66 of 73 Pg. 71 of 73 Pg. 72 of 73 Pg. 73 of 73 Inflation Assumptions 1 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2 Inflation on rates 15.000% 25.00% 25.00% 25.00% 25.00% 25.00% 3 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 4 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 5 CIP Inflation Factor 0.00% 0.00% 0.00% 4.00% 4.00% 4.00% 2022 2023 2024 2025 2026 2027 Budget Proposed Projected REVENUE 6 Charges for services 19,500 25,800 33,500 42,600 53,600 65,900 7 Special assessments 0 0 0 0 0 0 8 Intergovernmental 0 0 0 0 0 0 9 Interest 92 200 200 500 700 1,100 10 Miscellaneous 0 0 10,000 0 0 0 11 SHA Expansion (State Bonding) 0 0 574,500 0 0 0 12 13 Total Revenue 19,592 26,000 618,200 43,100 54,300 67,000 EXPENSES 14 Wages 10,700 11,300 11,500 11,700 11,900 12,100 15 Materials 500 700 700 700 700 700 16 Professional services 2,250 3,150 3,200 3,300 3,400 3,500 17 Repair and maintenance 3,300 4,200 4,300 4,400 4,500 4,600 18 Other 2,400 2,500 2,600 2,700 2,800 2,900 19 Depreciation 55,100 5,100 5,200 5,300 5,400 5,500 20 Debt service 0 0 0 0 0 0 21 22 Total Expenses 74,250 26,950 27,500 28,100 28,700 29,300 23 Revenue Over / (Under) Expenses (54,658) (950)590,700 15,000 25,600 37,700 OTHER FINANCING SOURCES / (USES) 24 Bond Proceeds 0 0 0 0 0 0 25 Transfers In 0 0 0 0 0 0 26 Purchase of capital assets (2,600) (4,500) (574,000) (8,200) (3,000)(52,500) 27 Advance to other fund 0 0 0 0 0 0 28 Transfers Out- 0 0 0 0 0 0 29 Total Other Sources / (Uses)(2,600) (4,500) (574,000) (8,200) (3,000)(52,500) 30 Change in balance sheet 31 Ending Cash 14,233 13,900 35,800 47,900 75,900 66,600 32 Target Cash 10,925 11,150 11,400 11,650 11,900 12,150 33 Over (Under) Target 3,308 2,750 24,400 36,250 64,000 54,450 FUND 612 FINANCIAL MANAGEMENT PLAN Uptown Sewer Fund