Need A Step By Step Explanation in Excel Format

Big Door Company has 8.2 million shares outstanding, which are currently trading for about $19 per share and have a levered equity beta of 1.5. Big Door has 18,400 outstanding bonds, with a 7% coupon rate, payable semi-annually and due in 10 years. The bonds are rated BBB. Currently the credit spread for BBB is 162 basis points over equivalent-maturity Government of Canada debt. The current yield on 10-year Canada bonds is 3%, compounded semi-annually. The riskfree interest rate is 2.9%, and the market risk premium is 6.4%. The company has a 35% tax rate. (Do not round intermediate calculations.) a. Calculate Big Door's WACC. (Round your answer to 2 decimal places.) WACC b. Calculate Big Door's unlevered beta, using the following formula: (Round your answer to 2 decimal places.) U=1+(1Tc)D/Elevered+debt(1Tc)D/E c. If Big Door was 50% debt-financed, what would be its WACC? Assume that the beta of its debt is unchanged by the capital structure change. (Round your answer to 2 decimal places.)