Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft® Office® website. There are also additional tutorials via the web that offer support for office products.
Select one of the publicly traded corporations listed below and obtain the most current SEC Form 10-K (annual financial report) from the company's web site (Do not use the Annual Report that is sent to shareholders):
- Kroger Corporation
- plus use the links below to retrieve data for Kroger
http://ir.kroger.com/CustomPage/Index?keyGenPage=210301 (annual financial reports)
http://ir.kroger.com/Docs (SEC filings 10-K)
Calculate and analyze the following ratios for your selected company for the last two years from the SEC Form 10-K:
- Debt Ratio
- Time Interest Earned
Compare and contrast your company's ratios to industry and competitor standard ratios obtained from Yahoo Finance, Morningstar, MotleyFool, Macroaxis or other Internet sources, and provide a detailed answer and analysis as to why your company's ratios are different than the industry/competitor standard.
Prepare your analysis in 200 words in Microsoft® Word. The use of Microsoft® Word tables is encouraged.
Cite the source of the industry/competitor ratio information.