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

a.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. b.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. c. Finally, calculate the market value weights for debt and equity. What is the WACC for AutoZone?

a. Hyperlinks for stock information and risk-free rate Ticker symbol: AZO Yahoo! Finance Stock Quote Yahoo! Finance Key Statistics Yahoo! Finance Analysis Estimates Yahoo! Finance Bond Center Stock quote link Stock price: Dividend: 1,186.06 $ N/A(N/A) Key statistics link Beta: Shares outstanding: 0.92 23,380,000 Analysts' estimates link 5-year growth: 5.50% Bond center link: Risk-free rate: 0.10% Market risk premium: 7.00% Market value of equity: $ 27,730,082,800 Cost of equity Dividend discount model: CAPM: #VALUE! Cost of equity: b. Hyperlinks for bond quotes and SEC EDGAR web sites Quoted Price Market Value Weight Maturity YTM Book Value Market Value Market Values Total market value = Cost of debt = Tax rate: Aftertax cost of debt: Cost of equity: Market value of equity: Aftertax cost of debt: Market value of debt: c. Weight of debt: Weight of equity: WACC: a. Hyperlinks for stock information and risk-free rate Ticker symbol: AZO Yahoo! Finance Stock Quote Yahoo! Finance Key Statistics Yahoo! Finance Analysis Estimates Yahoo! Finance Bond Center Stock quote link Stock price: Dividend: 1,186.06 $ N/A(N/A) Key statistics link Beta: Shares outstanding: 0.92 23,380,000 Analysts' estimates link 5-year growth: 5.50% Bond center link: Risk-free rate: 0.10% Market risk premium: 7.00% Market value of equity: $ 27,730,082,800 Cost of equity Dividend discount model: CAPM: #VALUE! Cost of equity: b. Hyperlinks for bond quotes and SEC EDGAR web sites Quoted Price Market Value Weight Maturity YTM Book Value Market Value Market Values Total market value = Cost of debt = Tax rate: Aftertax cost of debt: Cost of equity: Market value of equity: Aftertax cost of debt: Market value of debt: c. Weight of debt: Weight of equity: WACC