Answer and Explanation:
The computation is shown below:
1, The cost of debt before tax is
Given that
NPER = 10%
PMT - $1,000 × 7% = $70
PV = $886
FV = $1,000
The formula is given below:
= RATE(NPER;PMT;-PV;FV;TYPE)
After applying the above formula, the before tax cost of debt is 8.76%
2. The after tax cost of debt is
= 8.76% × (1 - 0.30)
= 6.13%
3. The total equity is
= $20 per share × 2million shares
= $40 million
4. The cost of equity is
= Risk free rate of return + Beta × (Market rate of return - risk free rate)
= 4% + 1.2 × (9% - 4%)
= 10%
5. The weight of debt is
= ($886 × 20 ÷ $1,000 ) ÷ (886 × 20 ÷ $1,000 + $40)
= 30.70%
6. The WACC is
= Weight of debt × after tax cost of debt + weight of equity × cost of equity
= 30.70% × 6.13% + (1 - 0.3070) × 10%
= 8.81%