The URL can be used to link to this page

Home My Public Portal AboutExhibit MSD 86C Bond Interest Payment OnlyExhibit MSD 86C Projected Fiscal Year 2011 2012 2013 2014 2015 2016 2011 2012 2013 2014 2015 2016 Existing Revenue Bonds 19,290,600 19,415,200 19,550,800 19,686,000 19, 834,400 19,973,200 19,270,300 19,392,400 19,528,800 19,660,900 19,811,800 19,947,200 Table 3-10 astewater Debt Service Requirements Proposed Existing Proposed Revenue SRF SRF Bonds Loans Loans $ $ $ Payments to Sinking Fund 0 19,113,700 0 2,622,700 21,311,100 1,711,000 16,611,100 21,401,300 4,062,800 28,436,100 21,483,500 6,307,900 39,436,100 21,355,600 8,553,000 47,136,100 21,728,600 10,797,800 Payments to Bondholders 0 18,292,600 0 1,430,600 20,232,600 500,000 9,736,100 21,395,200 3,003,300 22,523,600 21,345,500 5,248,400 33,936,100 21,545,900 7,493,500 43,286,100 21,324,600 9,738,600 Commercial Paper Notes Total $ $ 0 38,404,300 0 45,060,000 0 61,626,000 0 75,913,500 0 89,179,100 0 99,635,700 0 37,562,900 0 41,555,600 0 53,663,400 0 68,778,400 0 82,787,300 0 94,296,500 Table 3-11 Comparison of Projected Wastewater Revenue Under Existing Rates With Projected Revenue Requirements Line No. Description 1 Revenue Under Existing Rates (a) Additional Revenue Required Fiscal Revenue Year Increase 2 3 4 5 6 2012 2013 2014 2015 4.3% 8.5% 11.5% 11.3% 2016 11.6% 7 Total Additional Revenue 8 Total Service Charge Revenue 9 Other Operating Revenue 10 Connection Fee Revenue 11 Interest Income - Reserve Funds 12 Interest Income - Operations 13 Interest Income - Arnold 14 Subtotal Other Revenue 15 Total Revenue Months Effective 16 Operation and Maintenance Expense 17 Additional O&M (b) 18 Net Revenue 12 12 12 12 12 Fiscal Year Ending June 30, 2013 - 2016 2011 - 2016 2011 2012 2013 2014 2015 2016 4 -Year Total 6 -Year Total $ $ $ $ $ $ $ $ 213,795,600 212,030,000 211,019,700 210,681,800 210,501,800 210,431,800 842,635,100 1,268,460,700 8,357,500 9,073,800 9,059,300 9,051,600 9,048,600 36,233,300 44,590,800 17,149,000 18,678,000 18,662,000 18,655,800 73,144,800 73,144,800 25,133,300 27,394,800 27,385,700 79,913,800 79,913,800 27,512,800 30,004,000 57,516,800 57,516,800 31,424,300 31,424,300 31,424,300 0 8,357,500 26,222,800 52,870,600 82,621,200 116,518,400 278,233,000 286,590,500 213,795,600 220,387,500 237,242,500 263,552,400 293,123,000 326,950,200 1,120,868,100 1,555,051,200 (750,500) 3,382,400 1,427,200 527,800 (495,500) (1,672,500) (213,000) 2,418,900 1,250,000 1,288,000 1,327,000 1,367,000 1,408,000 1,450,000 5,552,000 8,090,000 888,800 956,900 1,147,200 1,384,600 1,603,700 1,782,000 5,917,500 7,763,200 30,800 50,600 52,800 49,800 51,300 51,100 205,000 286,400 650,700 631,000 610,500 589,100 566,800 543,600 2,310,000 3,591,700 2,069,800 6,308,900 4,564,700 3,918,300 3,134,300 2,154,200 13,771,500 22,150,200 215,865,400 226,696,400 241,807,200 267,470,700 296,257,300 329,104,400 1,134,639,600 1,577,201,400 134,394,800 138,803,800 145,469,000 151,971,700 156,751,700 162,141,600 616,334,000 889,532,600 0 0 112,400 2,159,800 7,484,100 7,942,500 17,698,800 17,698,800 81,470,600 87,892,600 96,225,800 113,339,200 132,021,500 159,020,300 500,606,800 669,970,000 Debt Service 19 Existing Senior Revenue Bonds 19,290,600 19,415,200 19,550,800 19,686,000 19,834,400 19,973,200 79,044,400 117,750,200 20 Proposed Senior Revenue Bonds 0 2,622,700 16,611,100 28,436,100 39,436,100 47,136,100 131,619,400 134,242,100 21 Total Senior Revenue Bonds 19,290,600 22,037,900 36,161,900 48,122,100 59,270,500 67,109,300 210,663,800 251,992,300 22 Existing State Revolving Fund Loans (c) 19,113,700 21,311,100 21,401,300 21,483,500 21,355,600 21,728,600 85,969,000 126,393,800 23 Proposed State Revolving Fund Loans (c) 0 1,711,000 4,062,800 6,307,900 8,553,000 10,797,800 29,721,500 31,432,500 24 Total State Revolving Fund Loans 25 Commercial Paper 26 Total Debt Service 27 Routine Annual Improvements 28 Cash Financing of Major Improvements 29 Additions to Operating Reserve 30 Net Annual Balance (d) 31 Beginning of Year Balance (e) 32 End of Year Balance (e) Actual Debt Service (f) 33 Senior Bonds 34 SRF Loans Debt Service Coverage 35 Revenue Bonds (g) 36 Total Debt (h) 19,113,700 23,022,100 25,464,100 27,791,400 29,908,600 32,526,400 115,690,500 157,826,300 0 0 0 0 0 0 0 0 38,404,300 45,060,000 61,626,000 75,913,500 89,179,100 99,635,700 326,354,300 409,818,600 2,378,600 2,461,900 2,535,700 2,611,800 2,690,100 2,770,900 10,608,500 15,449,000 37,250,000 38,438,000 31,677,000 33,267,000 38,308,000 55,850,000 159,102,000 234,790,000 674,500 738,500 1,126,200 1,418,000 1,673,900 974,600 5,192,700 6,605,700 2,763,200 1,194,200 (739,100) 128,900 170,400 (210,900) (650,700) 3,306,700 1,696,900 4,460,100 5,654,300 4,915,200 5,044,100 5,214,500 5,654,300 1,696,900 4,460,100 5,654,300 4,915,200 5,044,100 5,214,500 5,003,600 5,003,600 5,003,600 19,270,300 20,823,000 29,264,900 42,184,500 53,747,900 63,233,300 188,430,600 228,523,900 18,292,600 20,732,600 24,398,500 26,593,900 29,039,400 31,063,200 111,095,000 150,120,200 4.23 x 4.22 x 3.29 x 2.69 x 2.46 x 2.51 x 2.66 x 2.93 x 2.17 x 2.12 x 1.79 x 1.65 x 1.59 x 1.69 x 1.67 x 1.77 x (a) Revenue under existing wastewater rates effective July 1, 2010. (b) O&M costs related to anticipated regulatory projects. These projects include improved disinfection at the Missouri River WWTP in 2013 and 2014; expansion of the Missouri River WWTP in 2015; and Capacity, Management, Operation, and Maintenance (CMOM) program activities related to anticipated Consent Decree requirements in 2016. (c) Debt service on State Revolving Fund (SRF) Loans are net of the state's interest subsidy (d) Negative balances indicate need to drawdown available fund balance (e) Does not include funds set aside for a minimum operating reserve equal to 60 days of operating expenses. (f) Payment to Bondholders per Table 3-10, paid through Sinking Fund. (g) The Bond Ordinance requires net revenue to equal or exceed 1.25x actual senior lien debt service. (h) The Bond Ordinance requires net revenue to equal or exceed 1.15x total actual debt service, Table 3-21 Comparison of Existing and Proposed Wastewater Rates Line No. Type of Monthly Charge Base Charge - $Bill 1 Billing & Collection Charge 2 System Availability Charge 3 Total Base (Residential) Service Charge Compliance Charge - S/Bill (b) 4 Tier 1 5 Tier 2 6 Tier 3 7 Tier 4 8 Tier 5 FY 2011 FY 2012 Existing Approved Proposed Wastewater Charges 2011 2012(a) 2013 2014 2015 2016 2.60 2.65 3.25 3.45 3.60 3.75 8.80 9.20 10.00 11.50 13.20 15.10 11.40 11.85 13.25 14.95 16.80 18.85 30.85 31.95 23.00 16.00 9.00 2.35 30.85 31.95 40.25 42.60 44.10 45.40 30.85 31.95 85.75 90.70 93.85 96.65 30.85 31.95 125.70 133.00 137.65 141.70 30.85 31.95 165.65 175.30 181.35 186.75 Volume Charge 9 Metered - $/Ccf 2.02 2.11 2.31 2.61 2.94 3.32 Unmetered - $/Bill 10 Each Room 1.32 1.38 1.50 1.70 1.91 2.16 11 Each Water Closet 4.93 5.15 5.64 6.37 7.17 8.10 12 Each Bath 4.11 4.30 4.70 5.31 5.98 6.75 13 Each Separate Shower 4.11 4.30 4.70 5.31 5.98 6.75 Extra Strength Surcharges - $/ton (b) 14 Suspended Solids over 300 mg/I 15 BOD over 300 mg/I 16 COD over 600 mg/1 Typical Residential Bill - $Bill (c) 17 User Charge Portion 18 Capital Charge Portion 222.62 231.35 231.35 231.35 252.82 260.93 596.72 620.14 620.14 620.14 635.32 654.84 298.36 310.07 310.07 310.07 317.66 327.42 24.28 26.19 27.57 29.91 32.80 34.79 1.26 2.54 4.16 5.92 7.52 10.62 19 Total 27.56 28.73 31.73 35.83 40.32 45.41 Ccf - Hundred Cubic Feet mg/1- milligram per liter (a) 2012 approved rates to be effective July 1, 2011. (b) Applicable only to non-residential customers. (c) Based on contributed wastewater volume of 8 Ccf per month.