18 - Laserfiche WebLink

Scenario 4: Chain of Lakes PFAS Project-SRF Loan Funding 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.4 $4.3 $7.6 $11.0 4 Miscellaneous Revenues $1.6 $1.6 $1.6 $1.6 5 Subtotal-Revenues $58.3 $62.9 $67.6 $71.4 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 $2.6 $0.0 $0.0 $0.0 17 Subtotal-Additional Expenses $2.6 $0.5 $4.3 $6.2 18 19 Add/(Subtract)from Reserves ($8.1) ($0.8) $1.1 $0.5 20 Fund 100 Ending Balance $24.2 $23.4 $24.6 $25.0 21 Fund 100 Target Balance $23.3 $23.7 $24.7 $26.2 22 Above/(Below)Target $0.9 ($0.3) ($0.2) ($1.2) 23 24 *Rate Revenue Adjustment 5.0% 5.0% 5.0% 5.0% 25 26 Fund 120 27 Beginning Balance $25.7 $15.1 $16.7 $24.7 28 Capital Funding $18.3 $16.3 $17.0 $17.7 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.2 $0.2 $0.2 32 Ending Balance $15.1 $16.7 $24.7 $15.1 33 Minimum Balance $14.9 $9.2 $27.5 $15.3 'Capital Funding adjusted for inflation(similar to Scenario 5). 'Capital Expenses include the Chain of Lakes PFAS debt financed project.