18 - Laserfiche WebLink

Scenario 4B- 5.5% Proforma and Rates Line Pro Forma($millions) FY 2023 FY 2024 FY 2025 FY 2026 1 Revenues 2 Existing Rate Revenues $55.3 $57.0 $58.4 $58.8 3 Additional Rate Revenues* $1.5 $4.8 $8.4 $12.1 4 Miscellaneous Revenues $1.6 $1.6 $1.6 $1.7 5 Subtotal-Revenues $58.4 $63.4 $68.4 $72.6 6 7 Baseline Expenses 8 O&M Expenses $45.0 $43.8 $42.1 $43.9 9 Debt Service $3.1 $3.1 $3.1 $3.1 10 Capital Funding' $15.7 $16.3 $17.0 $17.7 11 Subtotal-Baseline Expenses $63.8 $63.2 $62.2 $64.7 12 13 Additional Expenses 14 O&M Expenses $0.0 $0.0 $2.9 $4.8 15 Debt Service $0.0 $0.5 $1.4 $1.4 16 Capital Funding' $0.7 $0.7 $0.7 $0.7 17 Subtotal-Additional Expenses $0.7 $1.2 $5.0 $6.9 18 19 Add/(Subtract)from Reserves ($6.1) ($1.0) $1.2 $1.0 20 Fund 100 Ending Balance $26.2 $25.2 $26.4 $27.3 21 Fund 100 Target Balance $23.3 $23.8 $24.8 $26.3 22 Above/(Below)Target $2.9 $1.4 $1.6 $1.0 23 24 *Rate Revenue Adjustment 5.5% 5.5% 5.5% 5.5% 25 26 Fund 120 27 Beginning Balance $25.7 $13.2 $15.5 $24.3 28 Capital Funding3 $16.4 $17.1 $17.7 $18.4 29 Bond Proceeds $0.0 $12.0 $12.0 $0.0 30 Capital Expenses' ($29.1) ($26.9) ($21.2) ($27.5) 31 Interest $0.1 $0.1 $0.2 $0.2 32 Ending Balance $13.2 $15.5 $24.3 $15.4 33 Minimum Balance $14.9 $9.2 $27.5 $15.3 'Capital Funding adjusted for inflation(similar to Scenario 5). 2Additional Capital Funding of$725K/year bring Fund 120 to target level. 3Includes Additional Capital funding of$725K/per year. 'Capital Expenses include the Chain of Lakes PFAS debt financed project.