You want to calculate the WACC for auto parts retailer AutoZone (AZO). Complete the following steps to construct a spreadsheet that can be updated.

You want to calculate the WACC for auto parts retailer AutoZone (AZO). Complete the following steps to construct a spreadsheet that can be updated.

1. Using an input for the ticker symbol, create hyperlinks to the web pages that you will need to find all of the information necessary to calculate the cost of equity. Use a market risk premium of 7 percent when using CAPM.
2. Create hyperlinks to go to the FINRA bond quote website and the SEC EDGAR database and find the information for the company’s bonds. Create a table that calculates the cost of debt for the company. Assume the tax rate is 35 percent.
3. Finally, calculate the market value weights for debt and equity. What is the WACC for AutoZone?

Risk free rateBetaMarket risk premiumHence,Cost of equity 2.19%0.677%6.8800% Total debtInterest expensesCost of debtTax rateAfter tax cost of debt $ 4,712.00 million150.4 million3.19%...