Answer the following questions using Microsoft Word, Excel, or both.

Team Names ________________________________________________________________ Chapter 3 Case - Fall 2017 Financial Statement Analysis Answer the following questions using Microsoft Word, Excel, or both. Print out and turn in the hard copy at the start of class on Monday, September 18. Each case should turn in only one copy with all team members' names and course sections listed. 1. Access the Securities and Exchange Commission EDGAR system (https://www.sec.gov/edgar/searchedgar/companysearch.html) to view the most recent annual financial statements and information for Kohls Retail Department Store. a. Click on the CIK number (in red) for Kohls Corp. b. Scroll down to find their latest 10K submission (Annual Report) and click on Interactive Data. c. If you would like to use Excel for your case calculations you can click on View Excel Document. The data will open in an Excel file. 2. Calculate the following ratios using the 2017 and 2016 financial statements provided in the 10K annual report. Show your calculations. Ratio Current Ratio Quick Ratio Inventory Turnover Days Sales Outstanding Fixed Asset Turnover Total Asset Turnover Debt Ratio (Debt/Assets) Times Interest Earned Net Profit Margin Return on Assets Return on Equity Equity Multiplier DuPont Equation (ROE) 2017 2016 Industry Average 2.2 .3 4.3 times 5.1 days 51.6 3.8 29.45% 15.0 1.52% 4.0% 5.2% .90 5.2% 3. Complete both a trend and comparative analysis for Kohls. Comment on their liquidity position, asset utilization, debt management, and profitability over time and vs. competitors. Is Kohls in a stronger or weaker financial position than its average competitor? Why? 4. Review the Statements of Cash Flows for 2017 and 2016 (ignore the supplemental information at the bottom). Where did their cash come from and what did they spend it on? What information can you determine about the company from their cash flow analysis about growth, dividend policy, and general cash management (matching maturities, etc.)