Homework Help is Here – Start Your Trial Now!
Business
Finance
Required: Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT) and Target (TGT), given the following numbers for 2012-2020. Check your numbers to make sure that Profit margin x Asset turnover Financial leverage = Return on equity. The data file, DuPont Analysis Walmart Target Data.xlsx, is available in Connect or via the Additional Student Resources page. (Note: The data are in $ millions.)* WMT Year Sales Revenue Net Income Assets Stockholders' Equity 2020 $ 559,151 $ 13,510 $ 252,496 $ 87,531 2019 $ 523,964 $ 14,881 $ 236,495 $ 81,552 2018 $ 514,343 $ 6,670 $ 219,295 $ 79,634 2017 $ 500,343 $ 10,523 $ 204,522 $ 80,822 2016 $ 485,873 $14,293 $ 198,825 $ 80,535 2015 $ 482,130 $ 15,080 $ 199,581 $ 83,611 2014 $ 485,651 $ 17,099 $ 203,490 $ 85,937 2013 $ 476,294 $ 16,695 $ 204,541 $ 81,339 2012 $ 468,651 $ 17,756 $ 203,105 $ 81,738 TGT Year Sales Revenue Net Income 2020 $ 93,561 $ 4,368 Assets $ 54,248 Stockholders' Equity $ 14,440 2019 $ 78,112 $ 3,281 $ 42,779 $ 11,833 2018 $ 75,356 $ 2,937 $ 41,290 $ 11,297 2017 $ 71,879 $ 2,914 $ 40,303 $ 11,651 2016 $ 69,495 $ 2,737 $ 37,431 $ 10,915 2015 $ 73,785 $ 3,363 $ 40,262 $ 12,957 2014 $ 72,618 $ (1,636) $ 41,172 $ 13,997 2013 $ 71,279 $1,971 $ 44,553 $ 16,231 2012 $ 73,301 $ 2,999 $ 48,163 $ 16,558 Source: XBRL (Calcbench) from company financial statements. Complete this question by entering your answers in the tabs below. WMT TGT Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT). Note: Do not round your intermediate calculations. Round your answers to 4 decimal places. Year Profit Margin Asset Turnover 2020 2019 2018 2017 2016 2015 2014 2013 2012 Financial Leverage Return on Equity

Required: Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT) and Target (TGT), given the following numbers for 2012-2020. Check your numbers to make sure that Profit margin x Asset turnover Financial leverage = Return on equity. The data file, DuPont Analysis Walmart Target Data.xlsx, is available in Connect or via the Additional Student Resources page. (Note: The data are in $ millions.)* WMT Year Sales Revenue Net Income Assets Stockholders' Equity 2020 $ 559,151 $ 13,510 $ 252,496 $ 87,531 2019 $ 523,964 $ 14,881 $ 236,495 $ 81,552 2018 $ 514,343 $ 6,670 $ 219,295 $ 79,634 2017 $ 500,343 $ 10,523 $ 204,522 $ 80,822 2016 $ 485,873 $14,293 $ 198,825 $ 80,535 2015 $ 482,130 $ 15,080 $ 199,581 $ 83,611 2014 $ 485,651 $ 17,099 $ 203,490 $ 85,937 2013 $ 476,294 $ 16,695 $ 204,541 $ 81,339 2012 $ 468,651 $ 17,756 $ 203,105 $ 81,738 TGT Year Sales Revenue Net Income 2020 $ 93,561 $ 4,368 Assets $ 54,248 Stockholders' Equity $ 14,440 2019 $ 78,112 $ 3,281 $ 42,779 $ 11,833 2018 $ 75,356 $ 2,937 $ 41,290 $ 11,297 2017 $ 71,879 $ 2,914 $ 40,303 $ 11,651 2016 $ 69,495 $ 2,737 $ 37,431 $ 10,915 2015 $ 73,785 $ 3,363 $ 40,262 $ 12,957 2014 $ 72,618 $ (1,636) $ 41,172 $ 13,997 2013 $ 71,279 $1,971 $ 44,553 $ 16,231 2012 $ 73,301 $ 2,999 $ 48,163 $ 16,558 Source: XBRL (Calcbench) from company financial statements. Complete this question by entering your answers in the tabs below. WMT TGT Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT). Note: Do not round your intermediate calculations. Round your answers to 4 decimal places. Year Profit Margin Asset Turnover 2020 2019 2018 2017 2016 2015 2014 2013 2012 Financial Leverage Return on Equity

Fundamentals of Financial Management, Concise Edition (MindTap Course List)
Fundamentals of Financial Management, Concise Edition (MindTap Course List)
9th Edition
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Eugene F. Brigham, Joel F. Houston
Chapter4: Analysis Of Financial Statements
Section: Chapter Questions
Problem 7DQ: From the Google Finance site, use the DuPont analysis to determine the total assets turnover ratio...
See similar textbooks
icon
Related questions
Question
None
P 9-1 (LO 9.5) Compute the DuPont ratios... Required: Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT) and Target (TGT), given the following numbers for 2012-2020. Check your numbers to make sure that Profit margin × Asset turnover x Financial leverage = Return on equity. The data file, DuPont Analysis Walmart Target Data.xlsx, is available in Connect or via the Additional Student Resources page. (Note: The data are in $ millions.)* WMT Year Sales Revenue Net Income Assets Stockholders' Equity 2020 $ 559,151 $ 13,510 $ 252,496 $ 87,531 2019 $ 523,964 $ 14,881 $ 236,495 $ 81,552 2018 $ 514,343 $ 6,670 $ 219,295 $ 79,634 2017 $ 500,343 $ 10,523 $ 204,522 $ 80,822 2016 $ 485,873 $14,293 $ 198,825 $ 80,535 2015 $ 482,130 $ 15,080 $ 199,581 $ 83,611 2014 $ 485,651 $ 17,099 $ 203,490 $ 85,937 2013 $ 476,294 $ 16,695 $ 204,541 $ 81,339 2012 $ 468,651 $ 17,756 $ 203,105 $ 81,738 TGT Year Sales Revenue Net Income Assets 2020 $93,561 $ 4,368 $ 54,248 Stockholders' Equity $ 14,440 2019 $ 78,112 $ 3,281 $ 42,779 $ 11,833 2018 $ 75,356 $ 2,937 $ 41,290 $ 11,297 2017 $ 71,879 $ 2,914 $ 40,303 $ 11,651 2016 $ 69,495 $ 2,737 $ 37,431 $ 10,915 2015 $ 73,785 $ 3,363 $ 40,262 $ 12,957 2014 $ 72,618 $ (1,636) $ 41,172 $ 13,997 2013 $ 71,279 $ 1,971 $ 44,553 $ 16,231 2012 $ 73,301 $ 2,999 $ 48,163 $ 16,558 *Source: XBRL (Calcbench) from company financial statements. Complete this question by entering your answers in the tabs below. WMT TGT Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT). Note: Do not round your intermediate calculations. Round your answers to 4 decimal places. Year Profit Margin Asset Turnover 2020 2019 2018 2017 2016 2015 2014 2013 2012 Financial Leverage Return on Equity < WMT TGT >
Transcribed Image Text:P 9-1 (LO 9.5) Compute the DuPont ratios... Required: Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT) and Target (TGT), given the following numbers for 2012-2020. Check your numbers to make sure that Profit margin × Asset turnover x Financial leverage = Return on equity. The data file, DuPont Analysis Walmart Target Data.xlsx, is available in Connect or via the Additional Student Resources page. (Note: The data are in $ millions.)* WMT Year Sales Revenue Net Income Assets Stockholders' Equity 2020 $ 559,151 $ 13,510 $ 252,496 $ 87,531 2019 $ 523,964 $ 14,881 $ 236,495 $ 81,552 2018 $ 514,343 $ 6,670 $ 219,295 $ 79,634 2017 $ 500,343 $ 10,523 $ 204,522 $ 80,822 2016 $ 485,873 $14,293 $ 198,825 $ 80,535 2015 $ 482,130 $ 15,080 $ 199,581 $ 83,611 2014 $ 485,651 $ 17,099 $ 203,490 $ 85,937 2013 $ 476,294 $ 16,695 $ 204,541 $ 81,339 2012 $ 468,651 $ 17,756 $ 203,105 $ 81,738 TGT Year Sales Revenue Net Income Assets 2020 $93,561 $ 4,368 $ 54,248 Stockholders' Equity $ 14,440 2019 $ 78,112 $ 3,281 $ 42,779 $ 11,833 2018 $ 75,356 $ 2,937 $ 41,290 $ 11,297 2017 $ 71,879 $ 2,914 $ 40,303 $ 11,651 2016 $ 69,495 $ 2,737 $ 37,431 $ 10,915 2015 $ 73,785 $ 3,363 $ 40,262 $ 12,957 2014 $ 72,618 $ (1,636) $ 41,172 $ 13,997 2013 $ 71,279 $ 1,971 $ 44,553 $ 16,231 2012 $ 73,301 $ 2,999 $ 48,163 $ 16,558 *Source: XBRL (Calcbench) from company financial statements. Complete this question by entering your answers in the tabs below. WMT TGT Compute the DuPont ratios (profit margin, asset turnover, and financial leverage ratios) for Walmart (WMT). Note: Do not round your intermediate calculations. Round your answers to 4 decimal places. Year Profit Margin Asset Turnover 2020 2019 2018 2017 2016 2015 2014 2013 2012 Financial Leverage Return on Equity < WMT TGT >
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Planning
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
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
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
SEE MORE TEXTBOOKS