Required: Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Amazon and Kroger given these numbers for 2012-2020. Check your numbers to make sure that Profit margin × Asset turnover × Financial leverage = Return on equity. (Source: XBRL (Calcbench)). To access the data file, click on DuPont Analysis Amazon Kroger Data. (Note the data is in $ millions.) Note. Negative amounts should be entered with a minus sign. Round your answers to 4 decimal places. =34:03 Amazon (AMZN) Year Sales Revenue Net Income Assets Stockholder's Equity 2020 $ 386,064 $ 21,331 $ 321,195 $ 93,404 2019 $ 280,522 $ 11,588 $ 225,248 $ 62,060 2018 $ 232,887 $ 10,073 $ 162,648 $ 43,549 2017 $ 177,866 $ 3,033 $ 131,310 $ 27,709 2016 $ 135,987 $ 2,371 $ 83,402 $ 19,285 2015 $ 107,006 $ 596 $ 64,747 $ 13,384 2014 $ 88,988 ($241) $ 54,505 $ 10,741 2013 $ 74,452 2012 $ 61,093 $ 274 ($39) $ 40,159 $ 9,746 $ 32,555 $ 8,192 Kroger (KR) Year Sales Revenue Net Income Assets Stockholders' Equity 2020 $ 132,498 $ 2,556 $ 48,256 $ 9,576 2019 $ 122,286 $ 1,640 $ 45,256 $ 8,602 2018 $ 121,162 $ 3,076 $ 38,118 $ 7,886 2017 $ 122,662 $ 1,889 $ 37,197 $ 6,905 2016 $ 115,337 $ 1,957 $ 36,505 $ 6,710 2015 $ 109,830 $ 2,049 $ 33,897 $ 6,798 2014 $ 108,465 $ 1,747 $ 30,497 $ 5,442 2013 $ 98,375 $ 1,531 $ 29,281 $ 5,395 2012 $ 96,619 $ 1,508 $ 24,634 $ 4,214 Answer is complete but not entirely correct. Amazon (AMZN) Profit Year Margin Asset Turnover Financial Leverage Return on Equity 2020 0.0553 1.2020 3.4388 0.2284 2019 0.0413 1.2454 3.6295 0.1867 2018 0.0433 1.4318 3.7348 0.2313 2017 0.0254 × 1.3546 4.6947 × 0.2736 2016 0.0174 1.6305 4.3247 0.1229 2015 0.0056 1.6527 4.8376 0.0445 2014 (0.0027) 1.6327 5.0745 (0.0224) 2013 0.0037 1.8539 4.1206 0.0281 2012 (0.0006) 1.8766 3.9740 (0.0048) Answer is complete but not entirely correct. Kroger (KR) Profit Asset Financial Return on Year Margin Turnover Leverage Equity 2020 0.0193 2.7457 5.0393 0.2669 2019 0.0134 2.7021 5.2611 0.1907 2018 0.0254 3.1786 4.8336 0.3901 2017 0.0254 × 3.2976 5.3870 0.2736 2016 0.0170 3.1595 5.4404 0.2917 2015 0.0187 3.2401 4.9863 0.3014 2014 0.0161 3.5566 5.6040 0.3210 2013 0.0156 3.3597 5.4274 0.2838 2012 0.0157 3.9039 5.8458 0.3579

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter3: Evaluation Of Financial Performance
Section: Chapter Questions
Problem 10P
icon
Related questions
Question

Please please help me with the incorrect cells in this problem!!

Required:
Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Amazon and Kroger given these numbers
for 2012-2020. Check your numbers to make sure that Profit margin × Asset turnover × Financial leverage = Return on equity. (Source:
XBRL (Calcbench)). To access the data file, click on DuPont Analysis Amazon Kroger Data. (Note the data is in $ millions.)
Note. Negative amounts should be entered with a minus sign. Round your answers to 4 decimal places.
=34:03
Amazon (AMZN)
Year
Sales Revenue
Net Income
Assets
Stockholder's Equity
2020
$ 386,064
$ 21,331
$ 321,195
$ 93,404
2019
$ 280,522
$ 11,588
$ 225,248
$ 62,060
2018
$ 232,887
$ 10,073
$ 162,648
$ 43,549
2017
$ 177,866
$ 3,033
$ 131,310
$ 27,709
2016
$ 135,987
$ 2,371
$ 83,402
$ 19,285
2015
$ 107,006
$ 596
$ 64,747
$ 13,384
2014
$ 88,988
($241)
$ 54,505
$ 10,741
2013
$ 74,452
2012
$ 61,093
$ 274
($39)
$ 40,159
$ 9,746
$ 32,555
$ 8,192
Kroger (KR)
Year
Sales Revenue
Net Income
Assets
Stockholders' Equity
2020
$ 132,498
$ 2,556
$ 48,256
$ 9,576
2019
$ 122,286
$ 1,640
$ 45,256
$ 8,602
2018
$ 121,162
$ 3,076
$ 38,118
$ 7,886
2017
$ 122,662
$ 1,889
$ 37,197
$ 6,905
2016
$ 115,337
$ 1,957
$ 36,505
$ 6,710
2015
$ 109,830
$ 2,049
$ 33,897
$ 6,798
2014
$ 108,465
$ 1,747
$ 30,497
$ 5,442
2013
$ 98,375
$ 1,531
$ 29,281
$ 5,395
2012
$ 96,619
$ 1,508
$ 24,634
$ 4,214
Answer is complete but not entirely correct.
Amazon (AMZN)
Profit
Year
Margin
Asset
Turnover
Financial
Leverage
Return on
Equity
2020
0.0553
1.2020
3.4388
0.2284
2019
0.0413
1.2454
3.6295
0.1867
2018
0.0433
1.4318
3.7348
0.2313
2017
0.0254 ×
1.3546
4.6947 ×
0.2736
2016
0.0174
1.6305
4.3247
0.1229
2015
0.0056
1.6527
4.8376
0.0445
2014
(0.0027)
1.6327
5.0745
(0.0224)
2013
0.0037
1.8539
4.1206
0.0281
2012
(0.0006)
1.8766
3.9740
(0.0048)
Transcribed Image Text:Required: Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Amazon and Kroger given these numbers for 2012-2020. Check your numbers to make sure that Profit margin × Asset turnover × Financial leverage = Return on equity. (Source: XBRL (Calcbench)). To access the data file, click on DuPont Analysis Amazon Kroger Data. (Note the data is in $ millions.) Note. Negative amounts should be entered with a minus sign. Round your answers to 4 decimal places. =34:03 Amazon (AMZN) Year Sales Revenue Net Income Assets Stockholder's Equity 2020 $ 386,064 $ 21,331 $ 321,195 $ 93,404 2019 $ 280,522 $ 11,588 $ 225,248 $ 62,060 2018 $ 232,887 $ 10,073 $ 162,648 $ 43,549 2017 $ 177,866 $ 3,033 $ 131,310 $ 27,709 2016 $ 135,987 $ 2,371 $ 83,402 $ 19,285 2015 $ 107,006 $ 596 $ 64,747 $ 13,384 2014 $ 88,988 ($241) $ 54,505 $ 10,741 2013 $ 74,452 2012 $ 61,093 $ 274 ($39) $ 40,159 $ 9,746 $ 32,555 $ 8,192 Kroger (KR) Year Sales Revenue Net Income Assets Stockholders' Equity 2020 $ 132,498 $ 2,556 $ 48,256 $ 9,576 2019 $ 122,286 $ 1,640 $ 45,256 $ 8,602 2018 $ 121,162 $ 3,076 $ 38,118 $ 7,886 2017 $ 122,662 $ 1,889 $ 37,197 $ 6,905 2016 $ 115,337 $ 1,957 $ 36,505 $ 6,710 2015 $ 109,830 $ 2,049 $ 33,897 $ 6,798 2014 $ 108,465 $ 1,747 $ 30,497 $ 5,442 2013 $ 98,375 $ 1,531 $ 29,281 $ 5,395 2012 $ 96,619 $ 1,508 $ 24,634 $ 4,214 Answer is complete but not entirely correct. Amazon (AMZN) Profit Year Margin Asset Turnover Financial Leverage Return on Equity 2020 0.0553 1.2020 3.4388 0.2284 2019 0.0413 1.2454 3.6295 0.1867 2018 0.0433 1.4318 3.7348 0.2313 2017 0.0254 × 1.3546 4.6947 × 0.2736 2016 0.0174 1.6305 4.3247 0.1229 2015 0.0056 1.6527 4.8376 0.0445 2014 (0.0027) 1.6327 5.0745 (0.0224) 2013 0.0037 1.8539 4.1206 0.0281 2012 (0.0006) 1.8766 3.9740 (0.0048)
Answer is complete but not entirely correct.
Kroger (KR)
Profit
Asset
Financial
Return on
Year
Margin
Turnover
Leverage
Equity
2020
0.0193
2.7457
5.0393
0.2669
2019
0.0134
2.7021
5.2611
0.1907
2018
0.0254
3.1786
4.8336
0.3901
2017
0.0254 ×
3.2976
5.3870
0.2736
2016
0.0170
3.1595
5.4404
0.2917
2015
0.0187
3.2401
4.9863
0.3014
2014
0.0161
3.5566
5.6040
0.3210
2013
0.0156
3.3597
5.4274
0.2838
2012
0.0157
3.9039
5.8458
0.3579
Transcribed Image Text:Answer is complete but not entirely correct. Kroger (KR) Profit Asset Financial Return on Year Margin Turnover Leverage Equity 2020 0.0193 2.7457 5.0393 0.2669 2019 0.0134 2.7021 5.2611 0.1907 2018 0.0254 3.1786 4.8336 0.3901 2017 0.0254 × 3.2976 5.3870 0.2736 2016 0.0170 3.1595 5.4404 0.2917 2015 0.0187 3.2401 4.9863 0.3014 2014 0.0161 3.5566 5.6040 0.3210 2013 0.0156 3.3597 5.4274 0.2838 2012 0.0157 3.9039 5.8458 0.3579
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Fundamentals of Financial Management, Concise Edi…
Fundamentals of Financial Management, Concise Edi…
Finance
ISBN:
9781305635937
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning