SOUTH BEND MUNICIPAL SEWAGE WORKS
<br />South Bend, Indiana
<br />Statement of Revenue Requirements
<br />Operation and Maintenance Expenses (A)
<br />Taxes Other Than Income Taxes (B)
<br />Sewage Works Portion of Public Works Building
<br />Corporation Debt Service (Schedule A -1)
<br />Estimated Combined Annual Debt Service (Schedule E -1)
<br />Annual Extensions and Replacements (Schedule E -1)
<br />Total Revenue Requirements
<br />Less Operating Revenues (C)
<br />Revenue Increase Required
<br />Divide by: Adjustable Operating Revenues
<br />Percent Rate Increase Required
<br />(A) Operation and Maintenance Expenses
<br />Prior Year Operation and Maintenance Expenses
<br />Times: Estimated Increase
<br />Total Estimated Operation and Maintenance Expenses
<br />(B) Taxes Other Than Income Taxes
<br />Calculation of FICA Tax
<br />Prior Year Adjusted FICA Tax
<br />Times: Estimated Increase
<br />Total Estimated FICA Tax
<br />Calculation of Payment in Lieu of Taxes
<br />Prior Year Payment in Lieu of Taxes
<br />Times: 3% increase
<br />Total Estimated Payment in Lieu of Taxes
<br />Total Estimated Taxes Other Than Income Taxes
<br />(C) Operating Revenues
<br />Prior Year Adjustable Operating Revenues
<br />Times: Proposed Rate Increase (3)
<br />Total Adjustable Operating Revenues
<br />Plus: Other Operating Revenue
<br />Total Operating Revenues
<br />EXHIBIT E
<br />Pro Forma Projected
<br />2013 2014 2015 2016
<br />$ 15,184,263 $ 15,639,791 $ 16,108,985 $ 16,592,255
<br />3,153,498 3,252,406 3,349,979 3,450,479
<br />82,844 82,487 82,991 62,807
<br />9,515,476 (1) 9,299,031 10,243,744 11,182,864
<br />3,696,186 (2) 4,889,911 4,985,498 5,151,190
<br />$ 31,632,269 33,163,626 34,771,197 36,459,595
<br />(31,632,269) (33,163,655) (34,771,610)
<br />1,531,357 1,607,542 1,687,985
<br />30,627,720 32,159,106 33,767,061
<br />5% 5% 5%
<br />$ 15,184,263 $ 15,639,791 $ 16,108,985
<br />3% 3% 3%
<br />$ 15,639,791 $ 16,108,985 $ 16,592,255
<br />$ 382,121 $ 393,585 $ 405,393
<br />3% 3% 3%
<br />393,585 405,393 417,555
<br />$ 2,775,554 $ 2,858,821 $ 2,944,586
<br />3% 3% 3%
<br />2,858,821 2,944,586 3,032,924
<br />$ 3,252,406 $ 3,349,979 $ 3,450,479
<br />$ 30,627,720 30,627,720 32,159,106
<br />5% 5%
<br />30,627,720 32,159,106 33,767,061
<br />1,004,549 1,004,549 1,004,549
<br />$ 31,632,269 $ 33,163,655 $ 34,771,610
<br />(1) 2013 Debt Service Payment from Exhibit B with the addition of the accrued interest paid on the 1998 SRF Loan
<br />and 2004 Bonds.
<br />(2) Pro Forma 2013 Extension and Replacements is calculated as the remaining funds available after payment of all
<br />other revenue requirements.
<br />(3) The prior year rate increase in 2013 was included within the adjustments on Exhibit C.
<br />-20-
<br />
|