Answer:
NPV of the project = $14,906,309.99
Explanation:
Note: See the attached excel file for calculation of the NPV of the project (in bold red color).
The weighted average cost of capital (WACC) used in calculating the discounting factor used in the attached excel file is calculated as follows:
Cost of equity = Treasury bills current yield + (Stock returns covariance with the market portfolio / Standard deviation of the returns on the market portfolio^2) * Expected market risk premium = 3.4% + (0.0415 / 20%^2) * 6.7% = 10.35%
After tax cost of debt = Bond yield to maturity * (100% - Tax rate) = 6.5% * (100% - 21%) = 5.14%
Market value of debt = $55,000,000
Market value of equity = Shares of common stock outstanding * Market price per share = 4,200,000 * $35 = $147,000,000
Total market value = Market value of equity + Market value of debt = $147,000,000 + $55,000,000 = $202,000,000
Equity share in the market value = $147,000,000 / $202,000,000 = 72.77%
Debt share in the market value = $55,000,000 / $202,000,000 = 27.23%
WACC = (Cost of equity * Equity share in the market value) + (After tax cost of debt * Debt share in the market value) = (10.35% * 72.77%) + (5.14% * 27.23%) = 8.93%
From attached excel file, we have:
NPV of the project = $14,906,309.99
