how to do a trend analysis and a comparative analysis for Kohl's?

Team Names ________________________________________________________________ Chapter 3 Team 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 team 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 5,247/2,974=1.76 (5,247-3,795)/2,974=.488 11,944/3,795=3.15 0/(7,987/365)=0 5,076/2,714=1.87 (5,076-4038)/2,714=.382 12,265/4,038=3.04 0/(8,154/365)=0 ? 7,987/13,038=0.61 8,010/13,038=.61 ? 8,154/13,360=.61 8,145/13,360=.61 441/150=2.94 274/7,987=.0343 274/13,038=.0210 274/5,028=.0545 13,038/5,028=2.5931 . 0343X.0210X2.5931=.0019 251/157=1.60 157/8,154=.0193 157/13,360=.0118 157/5,215=.0301 13,360/5,215=2.5618 . 0193X.0118X2.5618=.0006 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.)? Team Names ________________________________________________________________ -Their cash came from operating activities which for them is essentially selling merchandise. They spent it on a variety of things such as Treasury stock purchases, paying dividends, purchase of PPE, buying merchandise, among other things as well. As far as growth, the company is attempting to grow more, this is shown by their purchase of PPE