On the spreadsheet you submit, first, you will present the data you are using in the same format as slide 10 of the chapter 6 PPT I have uploaded. In the columns beside these, you will calculate the following for the latest year only (K52,53), and submit the spreadsheet showing your work such that I can see the formulas in the formula bar. Interpret your results as per the chapter information; the chapter has examples of Nordstrom and Walmart with interpretations. The 10K might have many extra items that are not on slide 10; you will use only the items on slide 10. Again, first on your spreadsheet you will copy the income/ balance sheet items on slide 10 and take the corresponding numbers for the items from the 10k for the latest year only. Next, you will calculate the following (be sure to SHOW YOUR WORK): Gross margin percent Net profit margin percent Current ratio Quick ratio Asset turnover Return on Assets January 31, 2018 2019 $ in millions, except per share amounts) ASSETS Current assets: Cash and cash equivalents Short-term investments Accounts receivable, net Inventories, net Prepaid expenses and other current assets Total current assets Property, plant and equipment, net Deferred income taxes Other assets, net 792.6 $ 62.7 245.4 2,428.0 230.8 3.759.5 970.7 320.5 231.2 2,253.5 207.4 3,983.3 1,026.7 215.8 331.0 5,333.0 $ 990.5 188.2 306.1 5,468.1 $ $ 120.6 113.4 $ 513.4 21.4 69.9 718.1 437.4 89.4 77,4 724.8 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Short-term borrowings Accounts payable and accrued liabilities Income taxes payable Merchandise credits and deferre revenue Total current liabilities Long-term debt Pension/postretirement benefit obligations Deferred gains on sale-leasebacks Other long-term liabilities Commitments and contingencies Stockholders' equity: Preferred Stock. $0.01 par value: authorized 2.0 shares, none issued and outstanding Common Stock, $0.01 par value; authorized 240.0 shares, issued and outstanding 121.5 and 124.5 Additional paid-in capital Retained earnings Accumulated other comprehensive loss, net of tax Total Tiffany & Co. stockholders' equity Non-controlling interests Total stockholders equity 883.4 312.4 31.1 257.1 882.9 287.4 40.5 2843 1.2 1.275.4 2,045.6 (204.8) 3.117.4 13.5 3.130.9 5,333.0 $ 1.2 1,256.0 2,114.2 (138.0 3.233.4 14.8 3.248.2 5.468.1 $ See notes to consolidated financial statements. TIFFANY & CO K-52 $ 2019 4,442.1 $ 1,631.1 2,811.0 2,020.7 790.3 Years Ended January 31, 2018 2017 4,169.8 $ 4,001.8 1,559.1 1,502.8 2,610.7 2,499.0 1,801.3 1,752.6 809.4 746.4 42.0 46.0 6.9 23.8 760.5 676.6 390.4 230.5 370.1 $ 446.1 (in millions, except per share amounts) Net sales Cost of sales Gross profit Selling, general and administrative expenses Earnings from operations Interest expense and financing costs Other expense, net Earnings from operations before income taxes Provision for income taxes Net earnings Net earnings per share: Basic Diluted Weighted average number of common shares: Basic Diluted 39.7 7.1 743.5 157.1 586.4 $ $ $ $ $ 4.77 $ 4.75 $ 2.97 $ 2.96 $ 3.57 3.55 124.5 122.9 123.5 125.1 125.5 125.1 See notes to consolidated financial statements
