Calculation guide
Discount usable interest tax savings at the debt rate and subtract financing costs paid today.
Inputs
Unlevered project NPV
Example entry 1000 (in the selected currency).
Debt principal
Example entry 500 (in the selected currency).
Debt interest rate
Example entry 5 %. Allowed range 0 to 100.
Marginal tax rate
Example entry 25 %. Allowed range 0 to 100.
Years to maturity
Example entry 5. Use whole numbers.
Upfront financing costs
Example entry 10 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Unlevered project NPV | 1,000 |
| Debt principal | 500 |
| Debt interest rate | 5% |
| Marginal tax rate | 25% |
| Years to maturity | 5 |
| Upfront financing costs | 10 |
| Result | Value |
|---|---|
| Adjusted present value | 1,017.059229 |
| Present value of tax savings | 27.059229 |
Calculation steps
Adjusted present value = ((Unlevered project NPV + (((Debt principal × Marginal tax rate) ÷ 100) × (1 − ((1 + (Debt interest rate ÷ 100)) ^ (0 − Years to maturity))))) − Upfront financing costs)
((1,000 + (((500 × 25) ÷ 100) × (1 − ((1 + (5 ÷ 100)) ^ (0 − 5))))) − 10) = 1,017.059229
Present value of tax savings = ((Adjusted present value − Unlevered project NPV) + Upfront financing costs)
((1,017.059229 − 1,000) + 10) = 27.059229
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Unlevered project NPV | 1,000 | 1,100 | Adjusted present value | 1,017.059229 | 1,117.059229 |
| Debt principal | 500 | 550 | Adjusted present value | 1,017.059229 | 1,019.765152 |
| Debt interest rate | 5% | 6% | Adjusted present value | 1,017.059229 | 1,021.592728 |
| Marginal tax rate | 25% | 28% | Adjusted present value | 1,017.059229 | 1,020.306337 |
| Years to maturity | 5 | 6 | Adjusted present value | 1,017.059229 | 1,021.723075 |
| Upfront financing costs | 10 | 11 | Adjusted present value | 1,017.059229 | 1,016.059229 |
