Consolidated Balance Sheets USD ($) $ in Thousands Feb. 03, Jan. 28, 2018 2017 Assets: Cash and cash equivalents Accounts receivable Merchandise inventories Other current assets Total current assets $ 187,028 39,650 1,463,561 39,612 1,729,851 $ 346,985 48,230 1,406,403 36,303 1,837,921 Land and land improvements Buildings and leasehold improvements Furniture, fixtures and equipment Buildings under construction Buildings and equipment under capital leases Less accumulated depreciation and amortization Property and equipment, net Other assets Total assets 64,003 3,096,838 1,041,758 1,464 23,648 (2,531,435) 1,696,276 247,042 3,673,169 64,313 3,106,481 1,065,291 9,024 23,648 (2,478,490) 1,790,267 259,948 3,888, 136 835,747 160,927 1,107 41,920 1,039,701 839,305 87,201 3,281 46,730 976,517 Liabilities: Trade accounts payable and accrued expenses Current portion of long-term debt Current portion of capital lease obligations Accrued Income Taxes, Current Total current liabilities Long-term debt Capital lease obligations Other liabilities Deferred income taxes Subordinated debentures Commitments and contingencies Total liabilities 365,429 2880 240,173 116,831 200,000 526,106 3,988 238,424 225,684 200,000 1,965,014 2,170,719 Stockholders' equity: Additional paid-in capital Accumulated other comprehensive loss Retained earings Less treasury stock, at cost, Class A-95,764,516 and 91,667,544 shares Total stockholders' equity 946,147 (15,444) 4,365,219 (3,589,006) 1,708,155 943,467 (11,137) 4,153,844 (3,369,995) 1,717,417 Total liabilities and stockholders' equity 3,673,169 3,888,136 Dillard's - Income Statement - USD ($) $ in Thousands Year Ended Jan. 28, Feb. 03, 2018 2017 Income Statement Total net sales 6,422,676 6,418,009 Cost of Merchandise Sold 4,199,718 4,166,411 Jan. 30, 2016 6,754,545 4,350,805 Selling, General and Administrative Expense Depreciation and amortization Rentals Interest Expense Write off of Deferred Debt Issuance Cost Gain on disposal of assets Asset impairment and store closing charges Income before income taxes and income on and equity in losses of joint ventures 1,692,145 231,595 28,012 62,580 797 (4,860) 0 212,689 1,655,658 243,657 25,954 63,059 0 (905) 6,500 257,675 1,669,916 250,011 26,732 60,923 0 (12,626) 408,784 Income taxes (benefit) Income on and equity in losses of joint ventures Net income (7,800) 835 $ 221,324 88,500 45 $ 169,220 140,770 1,356 $ 269,370 Earnings per common share: Basic (in dollars per share) Diluted (in dollars per share) $7.51 $7.51 $4.93 $4.93 $ 6.91 $6.91 BONUS #1 : Besides using copy (Ctrl + C) within the Feb 3, 2018 column and then paste (Ctrl + V) on the Jan 28,2017 column, what is one other method to get the numbers from the Feb 3, 2018 column into the Jan 28, 2017 column without manually typing out each number. Describe the Excel shortcuts and your process below. Answer: 7. Calculate Dillard's gross profit percentage for the year end Jan 28, 2017 and complete the following statement. Answer: For every $1 in net sales revenue, Dillard's earns _in gross profit and has in cost of goods sold expense. 8. Calculate the inventory turnover for Dillard's for the year end February 3, 2018. Answer: 9. How long, in days, does it take Dillard's on average to sell its inventory? Answer: 10. Do you think Wal-Mart's inventory turnover is higher (meaning it sells inventory faster) or lower (meaning it takes Wal-mart longer to sell its inventory) than Dillard's? Why? Answer: BONUS #2: Instead of typing a "+" between multiple numbers or using the SUM function to calculate the total of the three numbers below, what Excel shortcut can be used? Hint: it 58,744 1,456 Number 1 Number 2 Number 3 Total
