Stock Analysis on Net

Allergan PLC (NYSE:AGN)

이 회사는 아카이브로 이동되었습니다! 이 재무 데이터는 2020년 5월 7일부터 업데이트되지 않았습니다.

듀퐁 분석: ROE, ROA및 순이익률의 세분화 
분기별 데이터

Microsoft Excel

ROE 두 가지 구성 요소로 세분화

Allergan PLC, ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = ROA × 재무 레버리지 비율
2020. 3. 31. -4.28% = -2.81% × 1.52
2019. 12. 31. -9.06% = -5.57% × 1.63
2019. 9. 30. -15.82% = -9.80% × 1.61
2019. 6. 30. -14.25% = -8.91% × 1.60
2019. 3. 31. -11.73% = -7.36% × 1.59
2018. 12. 31. -7.83% = -5.01% × 1.56
2018. 9. 30. 3.30% = 2.18% × 1.51
2018. 6. 30. -2.24% = -1.46% × 1.53
2018. 3. 31. -2.55% = -1.65% × 1.55
2017. 12. 31. -5.59% = -3.49% × 1.60
2017. 9. 30. -10.18% = -6.09% × 1.67
2017. 6. 30. 15.86% = 9.56% × 1.66
2017. 3. 31. 16.16% = 9.58% × 1.69
2016. 12. 31. 19.65% = 11.61% × 1.69
2016. 9. 30. 15.99% = 9.99% × 1.60
2016. 6. 30. 5.77% = 3.34% × 1.73
2016. 3. 31. 6.05% = 3.44% × 1.76
2015. 12. 31. 5.11% = 2.88% × 1.77
2015. 9. 30. = × 1.84
2015. 6. 30. = × 1.92
2015. 3. 31. = × 1.95

보고서 기준: 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31), 10-K (보고 날짜: 2016-12-31), 10-Q (보고 날짜: 2016-09-30), 10-Q (보고 날짜: 2016-06-30), 10-Q (보고 날짜: 2016-03-31), 10-K (보고 날짜: 2015-12-31), 10-Q (보고 날짜: 2015-09-30), 10-Q (보고 날짜: 2015-06-30), 10-Q (보고 날짜: 2015-03-31).


ROE 세 가지 구성 요소로 세분화

Allergan PLC, ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 순이익률(Net Profit Margin Ratio) × 자산 회전율 × 재무 레버리지 비율
2020. 3. 31. -4.28% = -15.44% × 0.18 × 1.52
2019. 12. 31. -9.06% = -32.76% × 0.17 × 1.63
2019. 9. 30. -15.82% = -58.50% × 0.17 × 1.61
2019. 6. 30. -14.25% = -54.25% × 0.16 × 1.60
2019. 3. 31. -11.73% = -45.94% × 0.16 × 1.59
2018. 12. 31. -7.83% = -32.28% × 0.16 × 1.56
2018. 9. 30. 3.30% = 14.50% × 0.15 × 1.51
2018. 6. 30. -2.24% = -9.86% × 0.15 × 1.53
2018. 3. 31. -2.55% = -11.51% × 0.14 × 1.55
2017. 12. 31. -5.59% = -25.88% × 0.13 × 1.60
2017. 9. 30. -10.18% = -46.82% × 0.13 × 1.67
2017. 6. 30. 15.86% = 79.17% × 0.12 × 1.66
2017. 3. 31. 16.16% = 82.42% × 0.12 × 1.69
2016. 12. 31. 19.65% = 102.76% × 0.11 × 1.69
2016. 9. 30. 15.99% = 107.27% × 0.09 × 1.60
2016. 6. 30. 5.77% = 31.97% × 0.10 × 1.73
2016. 3. 31. 6.05% = 29.44% × 0.12 × 1.76
2015. 12. 31. 5.11% = 25.98% × 0.11 × 1.77
2015. 9. 30. = × × 1.84
2015. 6. 30. = × × 1.92
2015. 3. 31. = × × 1.95

보고서 기준: 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31), 10-K (보고 날짜: 2016-12-31), 10-Q (보고 날짜: 2016-09-30), 10-Q (보고 날짜: 2016-06-30), 10-Q (보고 날짜: 2016-03-31), 10-K (보고 날짜: 2015-12-31), 10-Q (보고 날짜: 2015-09-30), 10-Q (보고 날짜: 2015-06-30), 10-Q (보고 날짜: 2015-03-31).


ROE를 5개 구성 요소로 세분화

Allergan PLC, ROE 분해 (분기별 데이터)

Microsoft Excel
ROE = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율 × 재무 레버리지 비율
2020. 3. 31. -4.28% = × × -20.94% × 0.18 × 1.52
2019. 12. 31. -9.06% = × × -26.99% × 0.17 × 1.63
2019. 9. 30. -15.82% = × × -60.05% × 0.17 × 1.61
2019. 6. 30. -14.25% = × × -54.39% × 0.16 × 1.60
2019. 3. 31. -11.73% = × × -47.82% × 0.16 × 1.59
2018. 12. 31. -7.83% = × × -37.73% × 0.16 × 1.56
2018. 9. 30. 3.30% = × × -6.88% × 0.15 × 1.51
2018. 6. 30. -2.24% = × × -42.26% × 0.15 × 1.53
2018. 3. 31. -2.55% = × × -47.45% × 0.14 × 1.55
2017. 12. 31. -5.59% = × × -60.85% × 0.13 × 1.60
2017. 9. 30. -10.18% = × × -64.25% × 0.13 × 1.67
2017. 6. 30. 15.86% = 1.24 × 0.89 × 71.48% × 0.12 × 1.66
2017. 3. 31. 16.16% = 1.20 × 0.89 × 77.21% × 0.12 × 1.69
2016. 12. 31. 19.65% = 1.15 × 0.91 × 98.64% × 0.11 × 1.69
2016. 9. 30. 15.99% = 1.07 × 0.91 × 109.87% × 0.09 × 1.60
2016. 6. 30. 5.77% = 1.60 × 0.67 × 29.79% × 0.10 × 1.73
2016. 3. 31. 6.05% = 1.58 × 0.69 × 27.19% × 0.12 × 1.76
2015. 12. 31. 5.11% = 1.66 × 0.66 × 23.53% × 0.11 × 1.77
2015. 9. 30. = × × × × 1.84
2015. 6. 30. = × × × × 1.92
2015. 3. 31. = × × × × 1.95

보고서 기준: 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31), 10-K (보고 날짜: 2016-12-31), 10-Q (보고 날짜: 2016-09-30), 10-Q (보고 날짜: 2016-06-30), 10-Q (보고 날짜: 2016-03-31), 10-K (보고 날짜: 2015-12-31), 10-Q (보고 날짜: 2015-09-30), 10-Q (보고 날짜: 2015-06-30), 10-Q (보고 날짜: 2015-03-31).


ROA 두 가지 구성 요소로 세분화

Allergan PLC, ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 순이익률(Net Profit Margin Ratio) × 자산 회전율
2020. 3. 31. -2.81% = -15.44% × 0.18
2019. 12. 31. -5.57% = -32.76% × 0.17
2019. 9. 30. -9.80% = -58.50% × 0.17
2019. 6. 30. -8.91% = -54.25% × 0.16
2019. 3. 31. -7.36% = -45.94% × 0.16
2018. 12. 31. -5.01% = -32.28% × 0.16
2018. 9. 30. 2.18% = 14.50% × 0.15
2018. 6. 30. -1.46% = -9.86% × 0.15
2018. 3. 31. -1.65% = -11.51% × 0.14
2017. 12. 31. -3.49% = -25.88% × 0.13
2017. 9. 30. -6.09% = -46.82% × 0.13
2017. 6. 30. 9.56% = 79.17% × 0.12
2017. 3. 31. 9.58% = 82.42% × 0.12
2016. 12. 31. 11.61% = 102.76% × 0.11
2016. 9. 30. 9.99% = 107.27% × 0.09
2016. 6. 30. 3.34% = 31.97% × 0.10
2016. 3. 31. 3.44% = 29.44% × 0.12
2015. 12. 31. 2.88% = 25.98% × 0.11
2015. 9. 30. = ×
2015. 6. 30. = ×
2015. 3. 31. = ×

보고서 기준: 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31), 10-K (보고 날짜: 2016-12-31), 10-Q (보고 날짜: 2016-09-30), 10-Q (보고 날짜: 2016-06-30), 10-Q (보고 날짜: 2016-03-31), 10-K (보고 날짜: 2015-12-31), 10-Q (보고 날짜: 2015-09-30), 10-Q (보고 날짜: 2015-06-30), 10-Q (보고 날짜: 2015-03-31).


ROA를 4개의 구성 요소로 세분화

Allergan PLC, ROA 분해 (분기별 데이터)

Microsoft Excel
ROA = 세금 부담 × 이자 부담 × EBIT 마진 × 자산 회전율
2020. 3. 31. -2.81% = × × -20.94% × 0.18
2019. 12. 31. -5.57% = × × -26.99% × 0.17
2019. 9. 30. -9.80% = × × -60.05% × 0.17
2019. 6. 30. -8.91% = × × -54.39% × 0.16
2019. 3. 31. -7.36% = × × -47.82% × 0.16
2018. 12. 31. -5.01% = × × -37.73% × 0.16
2018. 9. 30. 2.18% = × × -6.88% × 0.15
2018. 6. 30. -1.46% = × × -42.26% × 0.15
2018. 3. 31. -1.65% = × × -47.45% × 0.14
2017. 12. 31. -3.49% = × × -60.85% × 0.13
2017. 9. 30. -6.09% = × × -64.25% × 0.13
2017. 6. 30. 9.56% = 1.24 × 0.89 × 71.48% × 0.12
2017. 3. 31. 9.58% = 1.20 × 0.89 × 77.21% × 0.12
2016. 12. 31. 11.61% = 1.15 × 0.91 × 98.64% × 0.11
2016. 9. 30. 9.99% = 1.07 × 0.91 × 109.87% × 0.09
2016. 6. 30. 3.34% = 1.60 × 0.67 × 29.79% × 0.10
2016. 3. 31. 3.44% = 1.58 × 0.69 × 27.19% × 0.12
2015. 12. 31. 2.88% = 1.66 × 0.66 × 23.53% × 0.11
2015. 9. 30. = × × ×
2015. 6. 30. = × × ×
2015. 3. 31. = × × ×

보고서 기준: 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31), 10-K (보고 날짜: 2016-12-31), 10-Q (보고 날짜: 2016-09-30), 10-Q (보고 날짜: 2016-06-30), 10-Q (보고 날짜: 2016-03-31), 10-K (보고 날짜: 2015-12-31), 10-Q (보고 날짜: 2015-09-30), 10-Q (보고 날짜: 2015-06-30), 10-Q (보고 날짜: 2015-03-31).


순이익률(Net Profit Margin Ratio)의 세분화

Allergan PLC, 순이익률의 분해(분기별 데이터)

Microsoft Excel
순이익률(Net Profit Margin Ratio) = 세금 부담 × 이자 부담 × EBIT 마진
2020. 3. 31. -15.44% = × × -20.94%
2019. 12. 31. -32.76% = × × -26.99%
2019. 9. 30. -58.50% = × × -60.05%
2019. 6. 30. -54.25% = × × -54.39%
2019. 3. 31. -45.94% = × × -47.82%
2018. 12. 31. -32.28% = × × -37.73%
2018. 9. 30. 14.50% = × × -6.88%
2018. 6. 30. -9.86% = × × -42.26%
2018. 3. 31. -11.51% = × × -47.45%
2017. 12. 31. -25.88% = × × -60.85%
2017. 9. 30. -46.82% = × × -64.25%
2017. 6. 30. 79.17% = 1.24 × 0.89 × 71.48%
2017. 3. 31. 82.42% = 1.20 × 0.89 × 77.21%
2016. 12. 31. 102.76% = 1.15 × 0.91 × 98.64%
2016. 9. 30. 107.27% = 1.07 × 0.91 × 109.87%
2016. 6. 30. 31.97% = 1.60 × 0.67 × 29.79%
2016. 3. 31. 29.44% = 1.58 × 0.69 × 27.19%
2015. 12. 31. 25.98% = 1.66 × 0.66 × 23.53%
2015. 9. 30. = × ×
2015. 6. 30. = × ×
2015. 3. 31. = × ×

보고서 기준: 10-Q (보고 날짜: 2020-03-31), 10-K (보고 날짜: 2019-12-31), 10-Q (보고 날짜: 2019-09-30), 10-Q (보고 날짜: 2019-06-30), 10-Q (보고 날짜: 2019-03-31), 10-K (보고 날짜: 2018-12-31), 10-Q (보고 날짜: 2018-09-30), 10-Q (보고 날짜: 2018-06-30), 10-Q (보고 날짜: 2018-03-31), 10-K (보고 날짜: 2017-12-31), 10-Q (보고 날짜: 2017-09-30), 10-Q (보고 날짜: 2017-06-30), 10-Q (보고 날짜: 2017-03-31), 10-K (보고 날짜: 2016-12-31), 10-Q (보고 날짜: 2016-09-30), 10-Q (보고 날짜: 2016-06-30), 10-Q (보고 날짜: 2016-03-31), 10-K (보고 날짜: 2015-12-31), 10-Q (보고 날짜: 2015-09-30), 10-Q (보고 날짜: 2015-06-30), 10-Q (보고 날짜: 2015-03-31).