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 years
Record 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.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

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 bop0.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.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

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 bop0.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.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

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 bop0.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.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

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 bop0.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]