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.

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Monsanto Co., adjusted current assets

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Current assets 8,651 8,157 10,625 9,675 10,077 9,658
Adjustments
Add: Allowance for doubtful trade receivables 78 94 59 72 68 64
Add: Excess of FIFO over LIFO cost1 144 150 154 160 169 143
Less: Current deferred tax assets2 743 635 579 534
After Adjustment
Adjusted current assets 8,873 8,401 10,095 9,272 9,735 9,331

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 Excess of FIFO over LIFO cost. See details »

2 Current deferred tax assets. See details »


Adjustments to Total Assets

Monsanto Co., adjusted total assets

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Total assets 21,333 19,736 21,920 21,981 20,664 20,224
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 458 464 467 491 435 318
Add: Allowance for doubtful trade receivables 78 94 59 72 68 64
Add: Excess of FIFO over LIFO cost2 144 150 154 160 169 143
Less: Current deferred tax assets3 743 635 579 534
Less: Noncurrent deferred tax assets4 564 613 277 450 454 551
After Adjustment
Adjusted total assets 21,449 19,831 21,580 21,619 20,303 19,664

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 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Excess of FIFO over LIFO cost. See details »

3 Current deferred tax assets. See details »

4 Noncurrent deferred tax assets. See details »


Adjustments to Current Liabilities

Monsanto Co., adjusted current liabilities

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Current liabilities 6,398 6,729 5,177 5,112 4,336 4,221
Adjustments
Less: Current deferred tax liabilities1 3 70 38 30
Less: Current deferred revenues 727 568 370 438 517 396
Less: Current restructuring reserves 37 227 170
After Adjustment
Adjusted current liabilities 5,634 5,934 4,634 4,604 3,781 3,795

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 Current deferred tax liabilities. See details »


Adjustments to Total Liabilities

Monsanto Co., adjusted total liabilities

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Total liabilities 14,875 15,191 14,915 14,067 7,936 8,188
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 458 464 467 491 435 318
Less: Current deferred tax liabilities2 3 70 38 30
Less: Noncurrent deferred tax liabilities3 192 68 340 509 469 313
Less: Deferred revenues 841 603 417 485 655 641
Less: Restructuring reserves 46 244 217
After Adjustment
Adjusted total liabilities 14,254 14,740 14,405 13,494 7,209 7,522

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Current deferred tax liabilities. See details »

3 Noncurrent deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Monsanto Co., adjusted total Monsanto Company shareowners’ equity

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Total Monsanto Company shareowners’ equity 6,438 4,534 6,990 7,875 12,559 11,833
Adjustments
Less: Net deferred tax assets (liabilities)1 372 545 677 506 526 742
Add: Allowance for doubtful trade receivables 78 94 59 72 68 64
Add: Excess of FIFO over LIFO cost2 144 150 154 160 169 143
Add: Deferred revenues 841 603 417 485 655 641
Add: Restructuring reserves 46 244 217
Add: Noncontrolling interest 20 11 15 39 169 203
After Adjustment
Adjusted total shareowners’ equity 7,195 5,091 7,175 8,125 13,094 12,142

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 Net deferred tax assets (liabilities). See details »

2 Excess of FIFO over LIFO cost. See details »


Adjustments to Capitalization Table

Monsanto Co., adjusted capitalization table

US$ in millions

Microsoft Excel
Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Short-term debt, including current portion of long-term debt 870 1,587 615 233 51 36
Long-term debt, excluding current portion 7,254 7,453 8,429 7,528 2,061 2,038
Total reported debt 8,124 9,040 9,044 7,761 2,112 2,074
Total Monsanto Company shareowners’ equity 6,438 4,534 6,990 7,875 12,559 11,833
Total reported capital 14,562 13,574 16,034 15,636 14,671 13,907
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 458 464 467 491 435 318
Adjusted total debt 8,582 9,504 9,511 8,252 2,547 2,392
Adjustments to Equity
Less: Net deferred tax assets (liabilities)2 372 545 677 506 526 742
Add: Allowance for doubtful trade receivables 78 94 59 72 68 64
Add: Excess of FIFO over LIFO cost3 144 150 154 160 169 143
Add: Deferred revenues 841 603 417 485 655 641
Add: Restructuring reserves 46 244 217
Add: Noncontrolling interest 20 11 15 39 169 203
Adjusted total shareowners’ equity 7,195 5,091 7,175 8,125 13,094 12,142
After Adjustment
Adjusted total capital 15,777 14,595 16,686 16,377 15,641 14,534

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 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Net deferred tax assets (liabilities). See details »

3 Excess of FIFO over LIFO cost. See details »


Adjustments to Revenues

Monsanto Co., adjusted net sales

US$ in millions

Microsoft Excel
12 months ended: Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Net sales 14,640 13,502 15,001 15,855 14,861 13,504
Adjustment
Add: Increase (decrease) in deferred revenues 238 186 (68) (170) 14 (69)
After Adjustment
Adjusted net sales 14,878 13,688 14,933 15,685 14,875 13,435

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).


Adjustments to Reported Income

Monsanto Co., adjusted net income attributable to Monsanto Company

US$ in millions

Microsoft Excel
12 months ended: Aug 31, 2017 Aug 31, 2016 Aug 31, 2015 Aug 31, 2014 Aug 31, 2013 Aug 31, 2012
As Reported
Net income attributable to Monsanto Company 2,260 1,336 2,314 2,740 2,482 2,045
Adjustments
Add: Deferred income tax expense (benefit)1 46 28 (288) (45) 126 241
Add: Increase (decrease) in allowance for doubtful trade receivables (16) 35 (13) 4 4 (34)
Add: Increase (decrease) in LIFO reserve2 (6) (4) (6) (9) 26 (43)
Add: Increase (decrease) in deferred revenues 238 186 (68) (170) 14 (69)
Add: Increase (decrease) in restructuring reserves (198) 27 217 (24)
Less: Income on discontinued operations 13 17 28 13 11 6
Add: Other comprehensive income (loss), net of tax 382 (8) (1,691) 174 (269) (960)
Add: Comprehensive income (loss), net of tax, attributable to noncontrolling interest 14 (24) 7 32 16 8
After Adjustment
Adjusted net income 2,707 1,559 444 2,713 2,388 1,158

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 Deferred income tax expense (benefit). See details »

2 Increase (decrease) in LIFO reserve. See details »