Stock Analysis on Net

Monsanto Co. (NYSE:MON)

This company has been moved to the archive! The financial data has not been updated since April 5, 2018.

Analysis of Reportable Segments

Microsoft Excel

Segment Profit Margin

Monsanto Co., profit margin by reportable segment

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 26.67% 22.95% 21.54% 24.27% 23.33% 26.25%
Agricultural Productivity 9.47% 3.30% 27.20% 26.30% 23.18% 12.84%

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

Segment profitability ratio Reportable segment The company
Segment profit margin Seeds and Genomics Seeds and Genomics segment profit margin ratio improved from 2015 to 2016 and from 2016 to 2017.
Agricultural Productivity Agricultural Productivity segment profit margin ratio deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Segment Profit Margin: Seeds and Genomics

Monsanto Co.; Seeds and Genomics; segment profit margin calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
EBIT 2,910 2,292 2,206 2,607 2,412 2,570
Net sales 10,913 9,988 10,243 10,740 10,340 9,789
Segment Profitability Ratio
Segment profit margin1 26.67% 22.95% 21.54% 24.27% 23.33% 26.25%

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment profit margin = 100 × EBIT ÷ Net sales
= 100 × 2,910 ÷ 10,913 = 26.67%

Segment profitability ratio Reportable segment The company
Segment profit margin Seeds and Genomics Seeds and Genomics segment profit margin ratio improved from 2015 to 2016 and from 2016 to 2017.

Segment Profit Margin: Agricultural Productivity

Monsanto Co.; Agricultural Productivity; segment profit margin calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
EBIT 353 116 1,294 1,345 1,048 477
Net sales 3,727 3,514 4,758 5,115 4,521 3,715
Segment Profitability Ratio
Segment profit margin1 9.47% 3.30% 27.20% 26.30% 23.18% 12.84%

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment profit margin = 100 × EBIT ÷ Net sales
= 100 × 353 ÷ 3,727 = 9.47%

Segment profitability ratio Reportable segment The company
Segment profit margin Agricultural Productivity Agricultural Productivity segment profit margin ratio deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Segment Return on Assets (Segment ROA)

Monsanto Co., ROA by reportable segment

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 17.35% 14.53% 12.73% 14.81% 14.85% 16.12%
Agricultural Productivity 7.73% 2.93% 28.19% 30.69% 23.72% 11.14%

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

Segment profitability ratio Reportable segment The company
Segment ROA Seeds and Genomics Seeds and Genomics segment ROA improved from 2015 to 2016 and from 2016 to 2017.
Agricultural Productivity Agricultural Productivity segment ROA deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Segment ROA: Seeds and Genomics

Monsanto Co.; Seeds and Genomics; segment ROA calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
EBIT 2,910 2,292 2,206 2,607 2,412 2,570
Total assets 16,768 15,772 17,330 17,598 16,246 15,944
Segment Profitability Ratio
Segment ROA1 17.35% 14.53% 12.73% 14.81% 14.85% 16.12%

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment ROA = 100 × EBIT ÷ Total assets
= 100 × 2,910 ÷ 16,768 = 17.35%

Segment profitability ratio Reportable segment The company
Segment ROA Seeds and Genomics Seeds and Genomics segment ROA improved from 2015 to 2016 and from 2016 to 2017.

Segment ROA: Agricultural Productivity

Monsanto Co.; Agricultural Productivity; segment ROA calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
EBIT 353 116 1,294 1,345 1,048 477
Total assets 4,565 3,964 4,590 4,383 4,418 4,280
Segment Profitability Ratio
Segment ROA1 7.73% 2.93% 28.19% 30.69% 23.72% 11.14%

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment ROA = 100 × EBIT ÷ Total assets
= 100 × 353 ÷ 4,565 = 7.73%

Segment profitability ratio Reportable segment The company
Segment ROA Agricultural Productivity Agricultural Productivity segment ROA deteriorated from 2015 to 2016 but then slightly improved from 2016 to 2017.

Segment Asset Turnover

Monsanto Co., asset turnover by reportable segment

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 0.65 0.63 0.59 0.61 0.64 0.61
Agricultural Productivity 0.82 0.89 1.04 1.17 1.02 0.87

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

Segment activity ratio Reportable segment The company
Segment asset turnover Seeds and Genomics Seeds and Genomics segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.
Agricultural Productivity Agricultural Productivity segment asset turnover ratio deteriorated from 2015 to 2016 and from 2016 to 2017.

Segment Asset Turnover: Seeds and Genomics

Monsanto Co.; Seeds and Genomics; segment asset turnover calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
Net sales 10,913 9,988 10,243 10,740 10,340 9,789
Total assets 16,768 15,772 17,330 17,598 16,246 15,944
Segment Activity Ratio
Segment asset turnover1 0.65 0.63 0.59 0.61 0.64 0.61

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 10,913 ÷ 16,768 = 0.65

Segment activity ratio Reportable segment The company
Segment asset turnover Seeds and Genomics Seeds and Genomics segment asset turnover ratio improved from 2015 to 2016 and from 2016 to 2017.

Segment Asset Turnover: Agricultural Productivity

Monsanto Co.; Agricultural Productivity; segment asset turnover calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
Net sales 3,727 3,514 4,758 5,115 4,521 3,715
Total assets 4,565 3,964 4,590 4,383 4,418 4,280
Segment Activity Ratio
Segment asset turnover1 0.82 0.89 1.04 1.17 1.02 0.87

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment asset turnover = Net sales ÷ Total assets
= 3,727 ÷ 4,565 = 0.82

Segment activity ratio Reportable segment The company
Segment asset turnover Agricultural Productivity Agricultural Productivity segment asset turnover ratio deteriorated from 2015 to 2016 and from 2016 to 2017.

Segment Capital Expenditures to Depreciation

Monsanto Co., capital expenditures to depreciation by reportable segment

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 1.29 1.23 1.30 1.46 1.25 0.97
Agricultural Productivity 2.96 1.46 1.58 1.41 1.02 1.37

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Seeds and Genomics Seeds and Genomics segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 not reaching 2015 level.
Agricultural Productivity Agricultural Productivity segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.

Segment Capital Expenditures to Depreciation: Seeds and Genomics

Monsanto Co.; Seeds and Genomics; segment capital expenditures to depreciation calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
Property, plant and equipment purchases 757 727 762 831 619 493
Depreciation and amortization expense 585 593 586 568 495 510
Segment Financial Ratio
Segment capital expenditures to depreciation1 1.29 1.23 1.30 1.46 1.25 0.97

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment capital expenditures to depreciation = Property, plant and equipment purchases ÷ Depreciation and amortization expense
= 757 ÷ 585 = 1.29

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Seeds and Genomics Seeds and Genomics segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 not reaching 2015 level.

Segment Capital Expenditures to Depreciation: Agricultural Productivity

Monsanto Co.; Agricultural Productivity; segment capital expenditures to depreciation calculation

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Selected Financial Data (US$ in millions)
Property, plant and equipment purchases 483 196 205 174 122 153
Depreciation and amortization expense 163 134 130 123 120 112
Segment Financial Ratio
Segment capital expenditures to depreciation1 2.96 1.46 1.58 1.41 1.02 1.37

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).

1 2017 Calculation
Segment capital expenditures to depreciation = Property, plant and equipment purchases ÷ Depreciation and amortization expense
= 483 ÷ 163 = 2.96

Segment financial ratio Reportable segment The company
Segment capital expenditures to depreciation Agricultural Productivity Agricultural Productivity segment capital expenditures to depreciation ratio deteriorated from 2015 to 2016 but then improved from 2016 to 2017 exceeding 2015 level.

Net sales

Monsanto Co., net sales by reportable segment

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 10,913 9,988 10,243 10,740 10,340 9,789
Agricultural Productivity 3,727 3,514 4,758 5,115 4,521 3,715
Total 14,640 13,502 15,001 15,855 14,861 13,504

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).


EBIT

Monsanto Co., ebit by reportable segment

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 2,910 2,292 2,206 2,607 2,412 2,570
Agricultural Productivity 353 116 1,294 1,345 1,048 477
Total 3,263 2,408 3,500 3,952 3,460 3,047

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).


Depreciation and amortization expense

Monsanto Co., depreciation and amortization expense by reportable segment

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 585 593 586 568 495 510
Agricultural Productivity 163 134 130 123 120 112
Total 748 727 716 691 615 622

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).


Total assets

Monsanto Co., total assets by reportable segment

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 16,768 15,772 17,330 17,598 16,246 15,944
Agricultural Productivity 4,565 3,964 4,590 4,383 4,418 4,280
Total 21,333 19,736 21,920 21,981 20,664 20,224

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).


Property, plant and equipment purchases

Monsanto Co., property, plant and equipment purchases by reportable segment

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
Seeds and Genomics 757 727 762 831 619 493
Agricultural Productivity 483 196 205 174 122 153
Total 1,240 923 967 1,005 741 646

Based on: 10-K (reporting date: 2017-08-31), 10-K (reporting date: 2016-08-31), 10-K (reporting date: 2015-08-31), 10-K (reporting date: 2014-08-31), 10-K (reporting date: 2013-08-31), 10-K (reporting date: 2012-08-31).