Sign in

Paying users zone. Data is covered by hidden .

Get 1 month access to Target Corp. for $15.99, or
get full access to entire website for at least 3 months from $49.99.

We accept:

Microsoft Excel

LibreOffice Calc

Target Corp. (TGT)

DuPont Analysis: Decomposition of ROE
Quarterly Data

Difficulty: Beginner

Decomposing ROE involves expressing net income divided by shareholders’ equity as the product of component ratios.

Two-Component Disaggregation of ROE
Three-Component Disaggregation of ROE
Five-Component Disaggregation of ROE
Two-Way Decomposition of ROA
Four-Way Decomposition of ROA
Decomposition of Net Profit Margin

Two-Component Disaggregation of ROE

Target Corp., decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	ROA	×	Leverage

Feb 2, 2019
Nov 3, 2018
Aug 4, 2018
May 5, 2018
Feb 3, 2018
Oct 28, 2017
Jul 29, 2017
Apr 29, 2017
Jan 28, 2017
Oct 29, 2016
Jul 30, 2016
Apr 30, 2016
Jan 30, 2016
Oct 31, 2015
Aug 1, 2015
May 2, 2015
Jan 31, 2015
Nov 1, 2014
Aug 2, 2014
May 3, 2014
Feb 1, 2014
Nov 2, 2013
Aug 3, 2013
May 4, 2013

Based on: 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

The primary reason for the decrease in Return on Equity (ROE) over Q4 2019 is the decrease in Financial Leverage.

Three-Component Disaggregation of ROE

Target Corp., decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	Net Profit Margin	×	Asset Turnover	×	Leverage

Feb 2, 2019
Nov 3, 2018
Aug 4, 2018
May 5, 2018
Feb 3, 2018
Oct 28, 2017
Jul 29, 2017
Apr 29, 2017
Jan 28, 2017
Oct 29, 2016
Jul 30, 2016
Apr 30, 2016
Jan 30, 2016
Oct 31, 2015
Aug 1, 2015
May 2, 2015
Jan 31, 2015
Nov 1, 2014
Aug 2, 2014
May 3, 2014
Feb 1, 2014
Nov 2, 2013
Aug 3, 2013
May 4, 2013

Based on: 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

The primary reason for the decrease in Return on Equity (ROE) over Q4 2019 is the decrease in profitability measured by Net Profit Margin.

Five-Component Disaggregation of ROE

Target Corp., decomposition of ROE (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROE	=	Tax Burden	×	Interest Burden	×	EBIT Margin	×	Asset Turnover	×	Leverage

Feb 2, 2019
Nov 3, 2018
Aug 4, 2018
May 5, 2018
Feb 3, 2018
Oct 28, 2017
Jul 29, 2017
Apr 29, 2017
Jan 28, 2017
Oct 29, 2016
Jul 30, 2016
Apr 30, 2016
Jan 30, 2016
Oct 31, 2015
Aug 1, 2015
May 2, 2015
Jan 31, 2015
Nov 1, 2014
Aug 2, 2014
May 3, 2014
Feb 1, 2014
Nov 2, 2013
Aug 3, 2013
May 4, 2013

Based on: 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

The primary reason for the decrease in Return on Equity (ROE) over Q4 2019 is the decrease in effect of taxes measured by Tax Burden.

Two-Way Decomposition of ROA

Target Corp., decomposition of ROA (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROA	=	Net Profit Margin	×	Asset Turnover

Feb 2, 2019
Nov 3, 2018
Aug 4, 2018
May 5, 2018
Feb 3, 2018
Oct 28, 2017
Jul 29, 2017
Apr 29, 2017
Jan 28, 2017
Oct 29, 2016
Jul 30, 2016
Apr 30, 2016
Jan 30, 2016
Oct 31, 2015
Aug 1, 2015
May 2, 2015
Jan 31, 2015
Nov 1, 2014
Aug 2, 2014
May 3, 2014
Feb 1, 2014
Nov 2, 2013
Aug 3, 2013
May 4, 2013

Based on: 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

The primary reason for the decrease in Return on Assets (ROA) over Q4 2019 is the decrease in profitability measured by Net Profit Margin.

Four-Way Decomposition of ROA

Target Corp., decomposition of ROA (quarterly data)

Microsoft Excel

LibreOffice Calc

	ROA	=	Tax Burden	×	Interest Burden	×	EBIT Margin	×	Asset Turnover

Feb 2, 2019
Nov 3, 2018
Aug 4, 2018
May 5, 2018
Feb 3, 2018
Oct 28, 2017
Jul 29, 2017
Apr 29, 2017
Jan 28, 2017
Oct 29, 2016
Jul 30, 2016
Apr 30, 2016
Jan 30, 2016
Oct 31, 2015
Aug 1, 2015
May 2, 2015
Jan 31, 2015
Nov 1, 2014
Aug 2, 2014
May 3, 2014
Feb 1, 2014
Nov 2, 2013
Aug 3, 2013
May 4, 2013

Based on: 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

The primary reason for the decrease in Return on Assets (ROA) over Q4 2019 is the decrease in effect of taxes measured by Tax Burden.

Decomposition of Net Profit Margin

Target Corp., decomposition of Net Profit Margin (quarterly data)

Microsoft Excel

LibreOffice Calc

	Net Profit Margin	=	Tax Burden	×	Interest Burden	×	EBIT Margin

Feb 2, 2019
Nov 3, 2018
Aug 4, 2018
May 5, 2018
Feb 3, 2018
Oct 28, 2017
Jul 29, 2017
Apr 29, 2017
Jan 28, 2017
Oct 29, 2016
Jul 30, 2016
Apr 30, 2016
Jan 30, 2016
Oct 31, 2015
Aug 1, 2015
May 2, 2015
Jan 31, 2015
Nov 1, 2014
Aug 2, 2014
May 3, 2014
Feb 1, 2014
Nov 2, 2013
Aug 3, 2013
May 4, 2013

Based on: 10-K (filing date: 2019-03-13), 10-Q (filing date: 2018-11-27), 10-Q (filing date: 2018-08-27), 10-Q (filing date: 2018-05-29), 10-K (filing date: 2018-03-14), 10-Q (filing date: 2017-11-20), 10-Q (filing date: 2017-08-21), 10-Q (filing date: 2017-05-22), 10-K (filing date: 2017-03-08), 10-Q (filing date: 2016-11-23), 10-Q (filing date: 2016-08-24), 10-Q (filing date: 2016-05-25), 10-K (filing date: 2016-03-11), 10-Q (filing date: 2015-11-25), 10-Q (filing date: 2015-08-25), 10-Q (filing date: 2015-05-28), 10-K (filing date: 2015-03-13), 10-Q (filing date: 2014-11-26), 10-Q (filing date: 2014-08-27), 10-Q (filing date: 2014-05-29), 10-K (filing date: 2014-03-14), 10-Q (filing date: 2013-11-27), 10-Q (filing date: 2013-08-28), 10-Q (filing date: 2013-05-30).

The primary reason for the decrease in Net Profit Margin over Q4 2019 is the decrease in effect of taxes measured by Tax Burden.

	Target Corp.	Other companies (not purchased previously)
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Long-term Trends
Analysis
Financial Reporting Quality

Price of access to Target Corp.^*

1 month

$15.99

* You can pay in USD, CHF, GBP or EUR.

	All companies
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Long-term Trends
Analysis
Financial Reporting Quality

Prices of access to the entire website^*

3 months

$49.99

6 months

12% off

~~$99.98~~

$87.49

9 months

25% off

~~$149.97~~

$112.49

12 months

37% off

~~$199.96~~

$124.99

* You can pay in USD, CHF, GBP or EUR.