Using the MS Excel Financial Analysis Template, complete the following workbook tabs using Kohl's financial information in completing the assignment. Complete these workbook tabs according to the directions set forth in the individual tabs.
TAB - "Common-size FS" and
TAB - "Financial Ratios"
You will analyze financial statements submitted by Kohl's for the five-fiscal year period (December 31),2009 -2013. In this assignment, you will:
- Obtain financial ratios for an industry group using electronic databases and Annual Reports on Form 10-K of public companies.
- Analyze common-size financial statements of a company and financial ratios of a company and its industry group to identify conditions, trends, and relationships that warrant investigation.