### Author: Abt Associates Inc.

Date Created: Date Modified: 5/10/2011 Purpose: The file calculates equivalent annual interest payment and interest effect over various time intervals. Calculations are used in to determine the regulatory impact on facilities.
File Contents: Worksheet Contents Interest Calculation-10yr Calculates equivalent annual interest payment over 10 years Interest Calculation-20yr Calculates equivalent annual interest payment over 20 years Interest Calculation-25yr Calculates equivalent annual interest payment over 25 years Interest Calculation-30yr Calculates equivalent annual interest payment over 30 yearsRecord for the Proposed Section 316(b) Rule for Phase III Facilities

Cap Outlay 1.00 Interest 7.0% Term 10.00 Beg of Period 0.001 = BoP; 0 = EoP Fixed Payment 0.14

Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Prin Bal bop 1.00000.9276 0.8502 0.7673 0.6786 0.5838 0.4823 0.3736 0.25740.1331 0.00000.0000 0.00000.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Payment 0.14240.14240.14240.14240.14240.14240.14240.14240.14240.14240.00000.0000 0.00000.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Interest 0.07000.0649 0.0595 0.0537 0.0475 0.0409 0.0338 0.0262 0.0180 0.0093 0.00000.0000 0.00000.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Pmnt 0.07240.07740.0829 0.0887 0.0949 0.1015 0.1086 0.1162 0.12440.1331 0.00000.0000 0.00000.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Bal eop 0.9276 0.8502 0.7673 0.6786 0.5838 0.4823 0.3736 0.25740.1331 0.00000.00000.0000 0.00000.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
Present Values Payment 1.0000 Interest 0.3236 Prin Pmnt 0.6764
Annualized Values Payment 0.1424 Interest 0.0461equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0963

November 1, 2004 2 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]Record for the Proposed Section 316(b) Rule for Phase III Facilities

Year 24 25 26 27 28 29 30 Prin Bal bop

0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Payment 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Interest 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Pmnt 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Bal eop0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

November 1, 2004 3 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]Record for the Proposed Section 316(b) Rule for Phase III Facilities

Cap Outlay 1.00 Interest 7.0% Term 20.00 Beg of Period 0.001 = BoP; 0 = EoP Fixed Payment 0.09

Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Prin Bal bop 1.00000.9756 0.9495 0.9216 0.8917 0.8597 0.8255 0.7889 0.7497 0.7078 0.66300.6150 0.5636 0.5087 0.4499 0.3870 0.3197 0.2477 0.1707 0.0882 0.0000 0.0000 0.0000 Payment 0.09440.09440.09440.09440.09440.09440.09440.09440.09440.09440.09440.09440.09440.09440.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0000 0.0000 0.0000 Interest 0.07000.0683 0.0665 0.0645 0.06240.0602 0.0578 0.0552 0.0525 0.0495 0.04640.0430 0.0395 0.0356 0.0315 0.0271 0.0224 0.0173 0.0119 0.0062 0.0000 0.0000 0.0000 Prin Pmnt 0.02440.0261 0.0279 0.0299 0.03200.0342 0.0366 0.0392 0.0419 0.0448 0.04800.0513 0.0549 0.0588 0.0629 0.0673 0.0720 0.0771 0.0824 0.0882 0.0000 0.0000 0.0000 Prin Bal eop 0.9756 0.9495 0.9216 0.8917 0.8597 0.8255 0.7889 0.7497 0.7078 0.66300.61500.5636 0.5087 0.4499 0.3870 0.3197 0.2477 0.1707 0.0882 0.0000 0.0000 0.0000 0.0000
Present Values Payment 1.0000 Interest 0.5441 Prin Pmnt 0.4559
Annualized Values Payment 0.0944 Interest 0.0514equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0430

November 1, 2004 4 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]Record for the Proposed Section 316(b) Rule for Phase III Facilities

Year 24 25 26 27 28 29 30 Prin Bal bop

0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Payment 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Interest 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Pmnt 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Bal eop0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

November 1, 2004 5 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]Record for the Proposed Section 316(b) Rule for Phase III Facilities

Cap Outlay 1.00 Interest 7.0% Term 25.00 Beg of Period 0.001 = BoP; 0 = EoP Fixed Payment 0.09

Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Prin Bal bop 1.00000.9842 0.9673 0.9492 0.9298 0.9091 0.8869 0.8632 0.8378 0.8106 0.7816 0.7505 0.7172 0.6816 0.6435 0.6027 0.5591 0.5124 0.4625 0.4090 0.3518 0.2907 0.2252 Payment 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 0.0858 Interest 0.07000.0689 0.0677 0.06640.0651 0.0636 0.0621 0.06040.0586 0.0567 0.0547 0.0525 0.0502 0.0477 0.0450 0.0422 0.0391 0.0359 0.0324 0.0286 0.0246 0.0203 0.0158 Prin Pmnt 0.0158 0.0169 0.0181 0.01940.0207 0.0222 0.0237 0.02540.0272 0.0291 0.0311 0.0333 0.0356 0.0381 0.0408 0.0436 0.0467 0.0499 0.0534 0.0572 0.0612 0.0655 0.0700 Prin Bal eop 0.9842 0.9673 0.9492 0.9298 0.9091 0.8869 0.8632 0.8378 0.8106 0.7816 0.7505 0.7172 0.6816 0.6435 0.6027 0.5591 0.5124 0.4625 0.4090 0.3518 0.2907 0.2252 0.1551
Present Values Payment 1.0000 Interest 0.6306 Prin Pmnt 0.3694
Annualized Values Payment 0.0858 Interest 0.0541equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0317

November 1, 2004 6 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]Record for the Proposed Section 316(b) Rule for Phase III Facilities

Year 24 25 26 27 28 29 30 Prin Bal bop

0.1551 0.0802 0.0000 0.0000 0.0000 0.0000 0.0000 Payment 0.0858 0.0858 0.0000 0.0000 0.0000 0.0000 0.0000 Interest 0.0109 0.0056 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Pmnt 0.0750 0.0802 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Bal eop0.0802 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

November 1, 2004 7 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]Record for the Proposed Section 316(b) Rule for Phase III Facilities

Cap Outlay 1.00 Interest 7.0% Term 30.00 Beg of Period 0.001 = BoP; 0 = EoP Fixed Payment 0.08

Year 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Prin Bal bop 1.00000.98940.9781 0.96600.95300.9391 0.9243 0.90840.89140.8732 0.8537 0.8329 0.8106 0.7868 0.7613 0.7340 0.7048 0.6735 0.6401 0.6043 0.5660 0.5250 0.4812 Payment 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 Interest 0.07000.0693 0.0685 0.0676 0.0667 0.0657 0.0647 0.0636 0.06240.0611 0.0598 0.0583 0.0567 0.0551 0.0533 0.0514 0.0493 0.0471 0.0448 0.0423 0.0396 0.0368 0.0337 Prin Pmnt 0.0106 0.0113 0.0121 0.01300.0139 0.0148 0.0159 0.01700.0182 0.0195 0.0208 0.0223 0.0238 0.0255 0.0273 0.0292 0.0313 0.0334 0.0358 0.0383 0.0410 0.0438 0.0469 Prin Bal eop 0.98940.9781 0.96600.95300.9391 0.9243 0.90840.89140.8732 0.8537 0.8329 0.8106 0.7868 0.7613 0.7340 0.7048 0.6735 0.6401 0.6043 0.5660 0.5250 0.4812 0.4343
Present Values Payment 1.0000 Interest 0.7032 Prin Pmnt 0.2968
Annualized Values Payment 0.0806 Interest 0.0567equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0239

November 1, 2004 8 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]Record for the Proposed Section 316(b) Rule for Phase III Facilities

Year 24 25 26 27 28 29 30 Prin Bal bop

0.4343 0.3841 0.3304 0.2730 0.2115 0.1457 0.0753 Payment 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 Interest 0.0304 0.0269 0.0231 0.0191 0.0148 0.0102 0.0053 Prin Pmnt 0.0502 0.0537 0.0575 0.0615 0.0658 0.0704 0.0753 Prin Bal eop0.3841 0.3304 0.2730 0.2115 0.1457 0.0753 0.0000

November 1, 2004 9 of 9 EPA-HQ-OW-2008-0667-DRAFT-1438.xls - [Tab]