Jacks Construction Co. (JCC) has 80,000 bonds outstanding that are currently selling at par (face) value. Bonds with similar characteristics are currently yielding 8.5%. The company also has 4 million shares of common stock outstanding. The stock has a beta of 1.1 and sells for $40 a share. The U.S. Treasury bill is currently yielding 4% and the market risk premium is 8%. The corporate tax rate is 35%.

a. What is JCC's after-tax cost of debt? (6 points)

b. What is JCC's cost of equity? (6 points)

c. What is the proportion (weight) of debt in JCC's capital structure? (4 points)

d. What is the proportion (weight) of equity in JCC's capital structure? (4 points)

e. What is JCC's WACC? (6 points)

Please attach an excel file I can download so I can see the work myself. It will not help for me just to get a picture of the work without being able to see the formulas and actual numbers. Please attach EXCEL file for good rating. Thank you.