Question

Calculate the firm’s WACC (using 2018 numbers). (You will need to collect information on the long-term debt and common stock equity from the Balance Sheet. The firm has no preferred stock).

Use the WACC to calculate NPV and evaluate IRR for proposed capital budgeting projects. Assume the projects are mutually exclusive and the firm has the money available to fund the project
A 7.5% percent annual coupon bond with 20 years to maturity, selling for 104 percent of par. The bonds make semiannual payments. What is the before tax cost of debt? If the tax rate is 40%, what is the after-tax cost of debt?
The firm’s beta is 1.2. The risk-free rate is 4.0% and the expected market return is 9%. What is the cost of equity using CAPM?

Answer 1

Before tax cost of debt is 7.12%

After tax cost of debt is 4.27%

Cost of equity is 10%

Step-by-step explanation:

The before-tax cost of debt can be determined using excel rate formula as found below:

=rate(nper,pmt,-pv,fv)

nper is the number of semiannual payments the bond has i.e 20*2=40

pmt is the amount of semiannual payment=$1000*7.5%*6/12=$ 37.50

pv is the current price =$1000*104%=$1,040.00

fv is the face value of $1000

=rate(40,37.50,-1040,1000)=3.56%

The 3.56% is semiannual yield, hence 7.12% per year (3.56%*2)

After-tax cost of debt=7.12%*(1-t) where is the tax rate of 40% or 0.4

after-tax cost of debt=7.12%*(1-0.40)=4.27%

Cost of equity is determined using the below CAPM formula:

Ke=Rf+Beta*(Mr-Rf)

Rf is the risk free rate of 4%

Beta is 1.2

Mr is the market return of 9%

Ke=4%+1.2(9%-4%)=10.00%