Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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,194

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: Robert F. Meigs, Jan R. Williams, Mark S. Bettner, Susan F. Haka, Sue Haka

11th Edition

0072516682, 978-0072516685

More Books

Students also viewed these Accounting questions

Question

How are governmental mega projects procured?

Answered: 1 week ago

Question

=+ Who are the buyers/users of the products abroad?

Answered: 1 week ago