I NEED HELP PLEASE TO FILL OUT THIS EXCEL FORM, I DON'T KNOW THE ANSWERS : ALL WEBSITES WERE PROVIDED IN THIS You want to calculate the WACC for auto parts retailer AutoZone (AZO). Complete the following steps to construct a spreadsheet that can be updated.

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

NOTE: The following calculations were done using the 10-Q dated June 7, 2019 and using market information available in July 2013. Therefore, the current WACC may vary significantly. Since AutoZone does not pay a dividend, we used the CAPM estimate for the cost of equity. - USE THESE LINKS TO FILL IN THE BLUE BOXES BELOW a. Hyperlinks for stock information and risk-free rate Ticker symbol: AZO Yahoo! Finance stock quote: tps://finance.yahoo.com/quote/AZO?ltr=1 Yahoo! Finance key statistics: https://finance.yahoo.com/quote/AZO/key-statistics?ltr=1 Yahoo! Finance analysts estimates : https://finance.yahoo.com/quote/AZO/analysis?ltr=1 Yahoo! Finance bond center: https://finance.yahoo.com/bonds

Stock quote link Stock price: Key statistics link Beta: Shares outstanding: Bond center link: Risk-free rate: Market risk premium: Market value of equity: $- Cost of equity Dividend discount model: CAPM: 0.00% Cost of equity: #DIV/0! b. Hyperlinks for bond quotes and SEC EDGAR web sites (FILL THIS CHART IN USING THESE HYPERLINKS FOR BOND QUOTES. ANSWERS WILL APPEAR IN BLUE SECTION ) - FINRA bond quote : https://finra-markets.morningstar.com/MarketData/Default.jsp?sdkVersion=2.62.9 - SEC EDGAR database : https://www.sec.gov/cgi-bin/browse-edgar?company=&match=&CIK=AZO&filenum=&State=&SIC=&owner=include&action=getcompany