18 - Laserfiche WebLink

Scenario 5: Stoneridge PFAS Project- Reserve Replenishment 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* $2.1 $6.6 $11.6 $17.0 4 Miscellaneous Revenues $1.6 $1.6 $1.6 $1.7 5 Subtotal-Revenues $59.0 $65.2 $71.6 $77.5 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 $3.4 $3.4 $3.4 17 Subtotal-Additional Expenses $2.6 $3.9 $7.7 $9.6 18 19 Add/(Subtract)from Reserves ($7.4) ($1.9) $1.7 $3.2 20 Fund 100 Ending Balance $24.9 $23.0 $24.7 $27.8 21 Fund 100 Target Balance $23.4 $23.9 $25.1 $26.7 22 Above/(Below)Target $1.5 ($0.9) ($0.3) $1.1 23 24 *Rate Revenue Adjustment 7.5% 7.5% 7.5% 7.5% 25 26 Fund 120 27 Beginning Balance $25.7 $15.1 $20.1 $31.6 28 Capital Funding $18.3 $19.8 $20.4 $21.1 29 Bond Proceeds $0.0 $12.0 $12.0 $0.0 30 Capital Expenses2 ($29.1) ($26.9) ($21.2) ($27.5) 31 Interest $0.1 $0.2 $0.3 $0.3 32 Ending Balance $15.1 $20.1 $31.6 $25.5 33 Minimum Balance $14.9 $9.2 $27.5 $15.3 'Capital Funding adjusted for inflation. 2Capital Expenses include the Chain of Lakes PFAS debt financed project Rates and Impacts CY 2022 CY 2023 CY 2024 CY 2025 CY 2026 Fixed/Volume-Based Charges Total Fixed Charges($/year) $25,716,708 $28,190,556 $31,144,141 $33,977,752 $35,883,654 Volume-Based Charge($/ccf) $2.06 $2.34 $2.46 $2.61 $2.66 Customer Impacts Blended Volume Charge($/ccf) $3.82 $4.25 $4.47 $4.75 $4.84 Monthly Usage(ccf) 10 10 10 10 10 Blended Monthly Charge $38.20 $42.50 $44.70 $47.50 $48.40 Difference($) $4.30 $2.20 $2.80 $0.90