Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please calculate the following activity ratios Inventory Turnover, Asset Turnover, Fixed Asset Turnover, Average Collection Period, for years 2015-2020 if there is not enough information
Please calculate the following activity ratios Inventory Turnover, Asset Turnover, Fixed Asset Turnover, Average Collection Period, for years 2015-2020 if there is not enough information to calculate please put N/A. Thanks
EXHIBIT 1 Macy's, Inc.'s Income Statements, 2015-2019 ($ in millions, except per share amounts) 2019 2018 2017* 2016 2015 Net sales $ 24,560 $ 24,971 $ 24,939 $ 25,908 $ 27,079 Gross margin (a) 9,389 9,756 9,758 10,242 10,583 Operating income 970 1,738 1,864 1,371 2,028 Net income 564 1,098 1,555 619 1,070 Net income attributable to Macy's, Inc. shareholders 564 1,108 1,566 627 1,072 $1.82 $3.6 S5.13 $2.03 $3.26 Basic earnings per share attributable to Macy's, Inc. shareholders Diluted earnings per share attributable to Macy's, Inc. shareholders $1.81 $3.56 $5.1 $2.02 $3.22 Average number of shares outstanding 309.7 307.7 305.4 308.5 328.4 Cash dividends paid per share $ 1.51 $ 1.51 $ 1.51 $ 1.49 $ 1.39 Depreciation and amortization $ 981 $ 962 $ 991 $ 1,058 $ 1,061 Capital expenditures $ 1,157 S 932 S 760 $ 912 $ 1,113 Balance Sheet Data (at year end): Cash and cash equivalents $ 685 $ 1,162 $ 1,455 $ 1,297 $ 1,109 Property and equipment-net 6,633 6,637 6,672 7,017 7,616 Total assets 21,172 19,194 19,583 20,082 20,576 Short-term debt 539 43 22 309 642 Long-term debt 3,621 4,708 5,861 6,562 6,995 Total Shareholders' equity 6,377 6,436 5,733 4,375 4,253 53 weeks Source: Macy's, Inc. 2019 10-K. EXHIBIT 2 Macy's, Inc.'s Results of Operations, 2017-2019 ($ in millions, except per share amounts) 2019 2018 Amount % to Sales Amount % to Sales 2017 Amount % to Sales Net sales $24.560 $24.971 $24,939 (0.8)% 1.7% (2.2)% Increase (decrease) in comparable sales Credit card revenues, net 771 3.1% 768 3.1% 702 2.8% Cost of sales (15.171) (61.8)% (15,215) (60.9)% (15,181) (60.9)% (8.998) (36.6% (9.039) (36.2) Selling, general and administrative expenses (8.954) (35.99% Gains on sale of real estate 162 0.6% 389 1.5% 544 2.2% (354) (1.4) (136) (0.5)% (186) (0.7)% Restructuring, impairment, store closing and other costs Operating income 970 3.9% 1,738 7% 1.864 7.5% Benefit plan income, net 31 39 57 Settlement charges (58) (88) (105) Interest expense.net (185) (236) (310) Gains (losses) on early retirement of (30) (33) 10 debt 728 1,420 1,516 (164) (322) 39 Income before income taxes Federal, state and local income tax benefit (expense) Net income 564 1,098 1,555 10 11 Net loss attributable to noncontrolling interest Net income attributable to Macy's. Inc. shareholders $564 2.3% $1,108 4.4% $1,566 6.3% $1.81 $3.56 $5.1 Diluted earnings per share attributable to Macy's. Inc. shareholders Supplemental Financial Measure $9,389 38% $9.756 39% $9.758 39.1% Gross margin Digital sales as a percent of comparable sales on an owned basis 26% 23% 22% Supplemental Non-GAAP Financial Measures (0.7)% 2% (1.9)% Increase (decrease) in comparable sales on an owned plus licensed basis $2.91 $4.18 $3.79 Adjusted diluted earnings per share attributable to Macy's, Inc. shareholders Adjusted EBITDA $2.336 $2.877 $3,109 ROIC 17.1% 19.9% 20.8% Source: Macy's, Inc. 2019 10-K. EXHIBIT 3 Macy's, Inc.'s Balance Sheets, 2018-2019 ($ in millions) February 1, 2020 February 2, 2019 ASSETS Current Assets: Cash and cash equivalents $ 685 $ 1,162 Receivables 409 400 5.188 5,263 Merchandise inventories Prepaid expenses and other current assets Total Current Assets 528 620 6,810 7.445 Property and Equipment-net 6,633 6.637 Right of Use Assets 2,668 Goodwill 3,908 3,908 Other Intangible Assets-net 439 478 Other Assets 714 726 $ 21,172 S 19.194 Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Short-term debt 539 $ 43 Merchandise accounts payable 1.682 1,655 Accounts payable and accrued liabilities 3,448 3.366 Income taxes 81 168 5.750 5.232 Total Current Liabilities Long-Term Debt 3,621 4.708 Long-Term Lease Liabilities 2.918 Deferred Income Taxes 1,169 1,238 Other Liabilities 1,337 1.580 Shareholders' Equity Common stock (309.0 and 307.5 shares outstanding) 3 3 Additional paid-in capital 621 652 Accumulated equity 7.989 8.050 Treasury stock (1.241) (1.318) (995) (951) Accumulated other comprehensive loss Total Macy's, Inc. Shareholders' Equity 6,377 6.436 Noncontrolling interest Total Shareholders' Equity 6.377 6,436 Total Liabilities and Shareholders' Equity $ 21,172 $ 19,194 EXHIBIT 1 Macy's, Inc.'s Income Statements, 2015-2019 ($ in millions, except per share amounts) 2019 2018 2017* 2016 2015 Net sales $ 24,560 $ 24,971 $ 24,939 $ 25,908 $ 27,079 Gross margin (a) 9,389 9,756 9,758 10,242 10,583 Operating income 970 1,738 1,864 1,371 2,028 Net income 564 1,098 1,555 619 1,070 Net income attributable to Macy's, Inc. shareholders 564 1,108 1,566 627 1,072 $1.82 $3.6 S5.13 $2.03 $3.26 Basic earnings per share attributable to Macy's, Inc. shareholders Diluted earnings per share attributable to Macy's, Inc. shareholders $1.81 $3.56 $5.1 $2.02 $3.22 Average number of shares outstanding 309.7 307.7 305.4 308.5 328.4 Cash dividends paid per share $ 1.51 $ 1.51 $ 1.51 $ 1.49 $ 1.39 Depreciation and amortization $ 981 $ 962 $ 991 $ 1,058 $ 1,061 Capital expenditures $ 1,157 S 932 S 760 $ 912 $ 1,113 Balance Sheet Data (at year end): Cash and cash equivalents $ 685 $ 1,162 $ 1,455 $ 1,297 $ 1,109 Property and equipment-net 6,633 6,637 6,672 7,017 7,616 Total assets 21,172 19,194 19,583 20,082 20,576 Short-term debt 539 43 22 309 642 Long-term debt 3,621 4,708 5,861 6,562 6,995 Total Shareholders' equity 6,377 6,436 5,733 4,375 4,253 53 weeks Source: Macy's, Inc. 2019 10-K. EXHIBIT 2 Macy's, Inc.'s Results of Operations, 2017-2019 ($ in millions, except per share amounts) 2019 2018 Amount % to Sales Amount % to Sales 2017 Amount % to Sales Net sales $24.560 $24.971 $24,939 (0.8)% 1.7% (2.2)% Increase (decrease) in comparable sales Credit card revenues, net 771 3.1% 768 3.1% 702 2.8% Cost of sales (15.171) (61.8)% (15,215) (60.9)% (15,181) (60.9)% (8.998) (36.6% (9.039) (36.2) Selling, general and administrative expenses (8.954) (35.99% Gains on sale of real estate 162 0.6% 389 1.5% 544 2.2% (354) (1.4) (136) (0.5)% (186) (0.7)% Restructuring, impairment, store closing and other costs Operating income 970 3.9% 1,738 7% 1.864 7.5% Benefit plan income, net 31 39 57 Settlement charges (58) (88) (105) Interest expense.net (185) (236) (310) Gains (losses) on early retirement of (30) (33) 10 debt 728 1,420 1,516 (164) (322) 39 Income before income taxes Federal, state and local income tax benefit (expense) Net income 564 1,098 1,555 10 11 Net loss attributable to noncontrolling interest Net income attributable to Macy's. Inc. shareholders $564 2.3% $1,108 4.4% $1,566 6.3% $1.81 $3.56 $5.1 Diluted earnings per share attributable to Macy's. Inc. shareholders Supplemental Financial Measure $9,389 38% $9.756 39% $9.758 39.1% Gross margin Digital sales as a percent of comparable sales on an owned basis 26% 23% 22% Supplemental Non-GAAP Financial Measures (0.7)% 2% (1.9)% Increase (decrease) in comparable sales on an owned plus licensed basis $2.91 $4.18 $3.79 Adjusted diluted earnings per share attributable to Macy's, Inc. shareholders Adjusted EBITDA $2.336 $2.877 $3,109 ROIC 17.1% 19.9% 20.8% Source: Macy's, Inc. 2019 10-K. EXHIBIT 3 Macy's, Inc.'s Balance Sheets, 2018-2019 ($ in millions) February 1, 2020 February 2, 2019 ASSETS Current Assets: Cash and cash equivalents $ 685 $ 1,162 Receivables 409 400 5.188 5,263 Merchandise inventories Prepaid expenses and other current assets Total Current Assets 528 620 6,810 7.445 Property and Equipment-net 6,633 6.637 Right of Use Assets 2,668 Goodwill 3,908 3,908 Other Intangible Assets-net 439 478 Other Assets 714 726 $ 21,172 S 19.194 Total Assets LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities: Short-term debt 539 $ 43 Merchandise accounts payable 1.682 1,655 Accounts payable and accrued liabilities 3,448 3.366 Income taxes 81 168 5.750 5.232 Total Current Liabilities Long-Term Debt 3,621 4.708 Long-Term Lease Liabilities 2.918 Deferred Income Taxes 1,169 1,238 Other Liabilities 1,337 1.580 Shareholders' Equity Common stock (309.0 and 307.5 shares outstanding) 3 3 Additional paid-in capital 621 652 Accumulated equity 7.989 8.050 Treasury stock (1.241) (1.318) (995) (951) Accumulated other comprehensive loss Total Macy's, Inc. Shareholders' Equity 6,377 6.436 Noncontrolling interest Total Shareholders' Equity 6.377 6,436 Total Liabilities and Shareholders' Equity $ 21,172 $ 19,194Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started