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 Name 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 1
Record 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.0000 0.9276 0.8502 0.7673 0.6786 0.5838 0.4823 0.3736 0.2574 0.1331 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

Payment 0.1424 0.1424 0.1424 0.1424 0.1424 0.1424 0.1424 0.1424 0.1424 0.1424 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

Interest 0.0700 0.0649 0.0595 0.0537 0.0475 0.0409 0.0338 0.0262 0.0180 0.0093 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

Prin Pmnt 0.0724 0.0774 0.0829 0.0887 0.0949 0.1015 0.1086 0.1162 0.1244 0.1331 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

Prin Bal eop 0.9276 0.8502 0.7673 0.6786 0.5838 0.4823 0.3736 0.2574 0.1331 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

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 1
Record 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 2
Record 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.0000 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

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.0700 0.0672 0.0642 0.0610 0.0576 0.0540 0.0501 0.0459 0.0414 0.0366 0.0315 0.0260 0.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.0684 0.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 1
Record 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 2
Record 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.0000 0.9756 0.9495 0.9216 0.8917 0.8597 0.8255 0.7889 0.7497 0.7078 0.6630 0.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.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0944 0.0000 0.0000 0.0000

Interest 0.0700 0.0683 0.0665 0.0645 0.0624 0.0602 0.0578 0.0552 0.0525 0.0495 0.0464 0.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.0244 0.0261 0.0279 0.0299 0.0320 0.0342 0.0366 0.0392 0.0419 0.0448 0.0480 0.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.6630 0.6150 0.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 1
Record 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 2
Record 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.0000 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

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.0700 0.0689 0.0677 0.0664 0.0651 0.0636 0.0621 0.0604 0.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.0194 0.0207 0.0222 0.0237 0.0254 0.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 1
Record 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 2
Record 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.0000 0.9894 0.9781 0.9660 0.9530 0.9391 0.9243 0.9084 0.8914 0.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.0700 0.0693 0.0685 0.0676 0.0667 0.0657 0.0647 0.0636 0.0624 0.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.0130 0.0139 0.0148 0.0159 0.0170 0.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.9894 0.9781 0.9660 0.9530 0.9391 0.9243 0.9084 0.8914 0.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 1
Record 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