Record for the Final Section 316(b) Existing Facilities Rule

1 2 3 4

5 6 7 8 9 10 11 12 13 14 A B

**Author:** Abt Associates Inc. **Date Created:** 9/1/2011 **Date Modified:** 2/27/2012 **Purpose:** Calculates equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations.

**Worksheet Contents**  Calculations Summary Reports the annualized interest payment value for each term analyzed. Interest Calculation-10yr Calculates the annualized interest payment value for a 10 year term. Interest Calculation-15yr Calculates the annualized interest payment value for a 15 year term. Interest Calculation-20yr Calculates the annualized interest payment value for a 20 year term. Interest Calculation-25yr Calculates the annualized interest payment value for a 25 year term. Interest Calculation-30yr Calculates the annualized interest payment value for a 30 year term.

EPA-HQ-OW-2008-0667-DRAFT-3431 FileInfo 1

## Record for the Final Section 316(b) Existing Facilities Rule



## Summary of Annualized Interest Payment Values equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations **Term (years)**  **Range Nam e**  **Value 10**  Interest_10_yrs 0.0461 **15** Interest_15_yrs 0.0485 **20** Interest_20_yrs 0.0514 **25** Interest_25_yrs 0.0541 **30** Interest_30_yrs 0.0567

EPA-HQ-OW-2008-0667-DRAFT-3431 Calculations Summary 1Record for the Final Section 316(b) Existing Facilities Rule

Cap Outlay 1.00 Interest **7.0%** Term **10.00** Beg of Period **0.00**1 = 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.00000.00000.00000.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.00000.00000.00000.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.01800.0093 0.00000.00000.00000.00000.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.00000.00000.00000.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.00000.00000.00000.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.0461**equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0963

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-10yr 1Record for the Final Section 316(b) Existing Facilities Rule

24 25 26 27 28 29 30 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-10yr 2Record for the Final Section 316(b) Existing Facilities Rule

Cap Outlay 1.00 Interest **7.0%** Term **15.00** Beg of Period **0.00**1 = BoP; 0 = EoP Fixed Payment 0.11

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.9602 0.9176 0.8721 0.8233 0.7712 0.7153 0.6556 0.5917 0.5233 0.4502 0.3719 0.2881 0.1985 0.1026 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Payment 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.1098 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Interest 0.07000.0672 0.0642 0.06100.0576 0.05400.0501 0.0459 0.04140.0366 0.0315 0.02600.0202 0.0139 0.0072 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Pmnt 0.0398 0.0426 0.0456 0.0488 0.0522 0.0558 0.0597 0.0639 0.06840.0732 0.0783 0.0838 0.0896 0.0959 0.1026 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 Prin Bal eop 0.9602 0.9176 0.8721 0.8233 0.7712 0.7153 0.6556 0.5917 0.5233 0.4502 0.3719 0.2881 0.1985 0.1026 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.4421 Prin Pmnt 0.5579
Annualized Values Payment 0.1098 Interest **0.0485**equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0613

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-15yr 1Record for the Final Section 316(b) Existing Facilities Rule

24 25 26 27 28 29 30 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-15yr 2Record for the Final Section 316(b) Existing Facilities Rule

Cap Outlay 1.00 Interest **7.0%** Term **20.00** Beg of Period **0.00**1 = 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.61500.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.04300.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.0514**equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0430

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-20yr 1Record for the Final Section 316(b) Existing Facilities Rule

24 25 26 27 28 29 30 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-20yr 2Record for the Final Section 316(b) Existing Facilities Rule

Cap Outlay 1.00 Interest **7.0%** Term **25.00** Beg of Period **0.00**1 = 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.0541**equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0317

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-25yr 1Record for the Final Section 316(b) Existing Facilities Rule

24 25 26 27 28 29 30 0.1551 0.0802 0.0000 0.0000 0.0000 0.0000 0.0000 0.0858 0.0858 0.0000 0.0000 0.0000 0.0000 0.0000 0.0109 0.0056 0.0000 0.0000 0.0000 0.0000 0.0000 0.0750 0.0802 0.0000 0.0000 0.0000 0.0000 0.0000 0.0802 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-25yr 2Record for the Final Section 316(b) Existing Facilities Rule

Cap Outlay 1.00 Interest **7.0%** Term **30.00** Beg of Period **0.00**1 = 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.0567**equivalent annual interest payment for use in annualized interest payment and interest tax effect calculations Prin Pmnt 0.0239

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-30yr 1Record for the Final Section 316(b) Existing Facilities Rule

24 25 26 27 28 29 30 0.4343 0.3841 0.3304 0.2730 0.2115 0.1457 0.0753 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0806 0.0304 0.0269 0.0231 0.0191 0.0148 0.0102 0.0053 0.0502 0.0537 0.0575 0.0615 0.0658 0.0704 0.0753 0.3841 0.3304 0.2730 0.2115 0.1457 0.0753 0.0000

EPA-HQ-OW-2008-0667-DRAFT-3431 Interest Calculation-30yr 2