Chapter 14 - Master it! 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 cast of equity, Use a market risk premium of 7 percent. Create hyperlinks to go to the FINRA bond quote website and the SEC EDGAR database and find the information for the company bonds. Create a table that calculates the cost of debt for the company. Assume the tax rate is 35 percent. b 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 Stock quote link Stock price: Dividend: 1,183.50 $ $ Key statistics link Beta: Shares outstanding: Analysts' estimates link 5-year growth: Bond center link: Risk-free rate: Market risk premium: Market value of equity: Market value of equity: Cost of equity Dividend discount model: CAPM: Cost of equity: . Hyperlinks for bond quotes and SEC EDGAR web sites Maturity Quoted Price YTM Book Value Market Value Market Value Weight Market Values Total market value Cost of debt Tax rate: 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: Weight of debt: Weight of equity: | WACC: Chapter 14 - Master it! 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 cast of equity, Use a market risk premium of 7 percent. Create hyperlinks to go to the FINRA bond quote website and the SEC EDGAR database and find the information for the company bonds. Create a table that calculates the cost of debt for the company. Assume the tax rate is 35 percent. b 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 Stock quote link Stock price: Dividend: 1,183.50 $ $ Key statistics link Beta: Shares outstanding: Analysts' estimates link 5-year growth: Bond center link: Risk-free rate: Market risk premium: Market value of equity: Market value of equity: Cost of equity Dividend discount model: CAPM: Cost of equity: . Hyperlinks for bond quotes and SEC EDGAR web sites Maturity Quoted Price YTM Book Value Market Value Market Value Weight Market Values Total market value Cost of debt Tax rate: 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: Weight of debt: Weight of equity: | WACC