Perform a Trend (Horizontal) Analysis of the Balance Sheet in the yellow-shaded cells. Sample formulas are provided to get you started.
MACY'S INC. 10-K Feb. 1. 2020 Horizontal Analysis Consolidated Balance Sheets (millions, except footnotes) February 1. 2020 February 2 2019 $ Chg %Chgl ($4771 (417) $1.162 400 5,263 620 ASSETS Cash and cash equivalents Receivables Merchandise inventories Prepaid expenses and other current assets Total Current Assets Property and equipment - net Right of use assets Goodwill Other intangible assets - net Other assets Total Assets $685 409 5,188 528 6,810 6,633 2.668 3.908 439 714 $21.172 7.445 6,637 3,908 478 726 $19.194 $496 1153% LIABILITIES AND SHAREHOLDERS' Short-term debt Merchandise accounts payable Accounts payable and accrued liabilities Income taxes Total current liabilities Long-term debt Long-term lease liabilities Deferred income taxes Other liabilities Total noncurrent liabilities Shareholders' equity Common stock (309.0 and 307.5 shares Additional paid-in capital Accumulated equity (ie, retained'earningsi Treasury stock Accumulated other comprehensive loss Total Macy's Inc. Shareholders' Equity Noncontrolling interest Total Shareholders' Equity Total Liabilities and Shareholders' Equity $539 1682 3,448 81 5,750 3,621 2,918 1,169 1,337 9.045 $43 1,655 3,366 168 5,232 4,708 1,238 1580 7.526 621 7,989 (1241) (995) 6.377 652 8,050 (1.3181 1951 6.136 0 6,377 $21.172 6, +36 $19.194 Macy's, Inc. From Fiscal 2018 to Fiscal 2019 26. What was the dollar-amount of change in Inventory? 27. What was the percentage change in Inventory? 28. What was the direction of the change Lincrease or decrease) 29. Which asset line item had the largest dollar increase? 30. Which asset line item had the largest percentage change? 31. Which liability line item had largest dollar increase? 32. Which liability line item had the largest percentage change? 33. What was the total dollar amount of the change in stockholders' equity? 34. What was the direction of the change Lincrease or decrease) 35. Was this change in equity more from |earnings, issuing stock, or something