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 Liquidity Ratios 
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Monsanto Co., liquidity ratios (quarterly data)

Microsoft Excel
Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012 Aug 31, 2012 May 31, 2012 Feb 29, 2012 Nov 30, 2011
Current ratio 1.41 1.28 1.35 1.44 1.36 1.29 1.21 1.47 1.43 1.23 2.05 2.58 1.96 1.63 1.89 2.86 2.29 1.87 2.32 2.92 2.45 1.96 2.29 2.28 1.93 1.66
Quick ratio 0.80 0.75 0.76 0.90 0.78 0.71 0.66 0.83 0.60 0.64 1.20 1.48 1.06 0.90 1.02 1.76 1.39 1.16 1.47 1.96 1.62 1.27 1.45 1.50 1.24 1.02
Cash ratio 0.34 0.38 0.29 0.23 0.31 0.29 0.26 0.20 0.18 0.27 0.72 0.29 0.50 0.45 0.47 0.48 0.76 0.71 0.90 0.80 1.01 0.80 0.85 0.47 0.66 0.57

Based on: 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30), 10-K (reporting date: 2013-08-31), 10-Q (reporting date: 2013-05-31), 10-Q (reporting date: 2013-02-28), 10-Q (reporting date: 2012-11-30), 10-K (reporting date: 2012-08-31), 10-Q (reporting date: 2012-05-31), 10-Q (reporting date: 2012-02-29), 10-Q (reporting date: 2011-11-30).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Monsanto Co. current ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Monsanto Co. quick ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Monsanto Co. cash ratio improved from Q4 2017 to Q1 2018 but then slightly deteriorated from Q1 2018 to Q2 2018.

Current Ratio

Monsanto Co., current ratio calculation (quarterly data)

Microsoft Excel
Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012 Aug 31, 2012 May 31, 2012 Feb 29, 2012 Nov 30, 2011
Selected Financial Data (US$ in millions)
Current assets 10,056 10,560 8,651 10,018 9,882 9,652 8,157 9,055 8,483 10,467 10,625 10,589 10,699 11,398 9,675 11,237 11,550 12,496 10,077 11,141 11,534 12,060 9,658 9,783 10,024 9,734
Current liabilities 7,149 8,258 6,398 6,958 7,289 7,500 6,729 6,180 5,939 8,501 5,177 4,097 5,472 6,999 5,112 3,931 5,051 6,698 4,336 3,814 4,709 6,161 4,221 4,282 5,193 5,853
Liquidity Ratio
Current ratio1 1.41 1.28 1.35 1.44 1.36 1.29 1.21 1.47 1.43 1.23 2.05 2.58 1.96 1.63 1.89 2.86 2.29 1.87 2.32 2.92 2.45 1.96 2.29 2.28 1.93 1.66
Benchmarks
Current Ratio, Competitors2
lululemon athletica inc.
Nike Inc.

Based on: 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30), 10-K (reporting date: 2013-08-31), 10-Q (reporting date: 2013-05-31), 10-Q (reporting date: 2013-02-28), 10-Q (reporting date: 2012-11-30), 10-K (reporting date: 2012-08-31), 10-Q (reporting date: 2012-05-31), 10-Q (reporting date: 2012-02-29), 10-Q (reporting date: 2011-11-30).

1 Q2 2018 Calculation
Current ratio = Current assets ÷ Current liabilities
= 10,056 ÷ 7,149 = 1.41

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Monsanto Co. current ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.

Quick Ratio

Monsanto Co., quick ratio calculation (quarterly data)

Microsoft Excel
Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012 Aug 31, 2012 May 31, 2012 Feb 29, 2012 Nov 30, 2011
Selected Financial Data (US$ in millions)
Cash and cash equivalents 2,409 3,102 1,856 1,614 2,281 2,129 1,676 1,205 1,050 2,277 3,701 1,179 2,732 3,136 2,367 1,898 3,805 4,496 3,668 2,921 4,443 4,637 3,283 1,716 3,123 3,007
Short-term investments 8 6 10 60 60 11 12 47 47 28 40 40 45 249 254 143 310 310 302 302 302 302
Trade receivables, net 2,520 2,115 2,161 3,913 2,605 2,196 1,926 3,168 1,828 2,106 1,636 3,998 2,357 2,247 2,014 4,229 2,515 2,283 1,715 3,610 2,219 2,168 1,897 3,727 2,341 1,993
Miscellaneous receivables 772 987 827 763 772 917 755 744 699 1,000 803 877 711 870 817 803 668 774 748 812 638 700 620 674 661 639
Total quick assets 5,701 6,204 4,852 6,296 5,668 5,302 4,417 5,128 3,589 5,430 6,187 6,082 5,800 6,293 5,238 6,930 7,033 7,802 6,385 7,486 7,610 7,815 6,102 6,419 6,427 5,941
 
Current liabilities 7,149 8,258 6,398 6,958 7,289 7,500 6,729 6,180 5,939 8,501 5,177 4,097 5,472 6,999 5,112 3,931 5,051 6,698 4,336 3,814 4,709 6,161 4,221 4,282 5,193 5,853
Liquidity Ratio
Quick ratio1 0.80 0.75 0.76 0.90 0.78 0.71 0.66 0.83 0.60 0.64 1.20 1.48 1.06 0.90 1.02 1.76 1.39 1.16 1.47 1.96 1.62 1.27 1.45 1.50 1.24 1.02
Benchmarks
Quick Ratio, Competitors2
lululemon athletica inc.
Nike Inc.

Based on: 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30), 10-K (reporting date: 2013-08-31), 10-Q (reporting date: 2013-05-31), 10-Q (reporting date: 2013-02-28), 10-Q (reporting date: 2012-11-30), 10-K (reporting date: 2012-08-31), 10-Q (reporting date: 2012-05-31), 10-Q (reporting date: 2012-02-29), 10-Q (reporting date: 2011-11-30).

1 Q2 2018 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 5,701 ÷ 7,149 = 0.80

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Monsanto Co. quick ratio deteriorated from Q4 2017 to Q1 2018 but then improved from Q1 2018 to Q2 2018 exceeding Q4 2017 level.

Cash Ratio

Monsanto Co., cash ratio calculation (quarterly data)

Microsoft Excel
Feb 28, 2018 Nov 30, 2017 Aug 31, 2017 May 31, 2017 Feb 28, 2017 Nov 30, 2016 Aug 31, 2016 May 31, 2016 Feb 29, 2016 Nov 30, 2015 Aug 31, 2015 May 31, 2015 Feb 28, 2015 Nov 30, 2014 Aug 31, 2014 May 31, 2014 Feb 28, 2014 Nov 30, 2013 Aug 31, 2013 May 31, 2013 Feb 28, 2013 Nov 30, 2012 Aug 31, 2012 May 31, 2012 Feb 29, 2012 Nov 30, 2011
Selected Financial Data (US$ in millions)
Cash and cash equivalents 2,409 3,102 1,856 1,614 2,281 2,129 1,676 1,205 1,050 2,277 3,701 1,179 2,732 3,136 2,367 1,898 3,805 4,496 3,668 2,921 4,443 4,637 3,283 1,716 3,123 3,007
Short-term investments 8 6 10 60 60 11 12 47 47 28 40 40 45 249 254 143 310 310 302 302 302 302
Total cash assets 2,409 3,102 1,864 1,620 2,291 2,189 1,736 1,216 1,062 2,324 3,748 1,207 2,732 3,176 2,407 1,898 3,850 4,745 3,922 3,064 4,753 4,947 3,585 2,018 3,425 3,309
 
Current liabilities 7,149 8,258 6,398 6,958 7,289 7,500 6,729 6,180 5,939 8,501 5,177 4,097 5,472 6,999 5,112 3,931 5,051 6,698 4,336 3,814 4,709 6,161 4,221 4,282 5,193 5,853
Liquidity Ratio
Cash ratio1 0.34 0.38 0.29 0.23 0.31 0.29 0.26 0.20 0.18 0.27 0.72 0.29 0.50 0.45 0.47 0.48 0.76 0.71 0.90 0.80 1.01 0.80 0.85 0.47 0.66 0.57
Benchmarks
Cash Ratio, Competitors2
lululemon athletica inc.
Nike Inc.

Based on: 10-Q (reporting date: 2018-02-28), 10-Q (reporting date: 2017-11-30), 10-K (reporting date: 2017-08-31), 10-Q (reporting date: 2017-05-31), 10-Q (reporting date: 2017-02-28), 10-Q (reporting date: 2016-11-30), 10-K (reporting date: 2016-08-31), 10-Q (reporting date: 2016-05-31), 10-Q (reporting date: 2016-02-29), 10-Q (reporting date: 2015-11-30), 10-K (reporting date: 2015-08-31), 10-Q (reporting date: 2015-05-31), 10-Q (reporting date: 2015-02-28), 10-Q (reporting date: 2014-11-30), 10-K (reporting date: 2014-08-31), 10-Q (reporting date: 2014-05-31), 10-Q (reporting date: 2014-02-28), 10-Q (reporting date: 2013-11-30), 10-K (reporting date: 2013-08-31), 10-Q (reporting date: 2013-05-31), 10-Q (reporting date: 2013-02-28), 10-Q (reporting date: 2012-11-30), 10-K (reporting date: 2012-08-31), 10-Q (reporting date: 2012-05-31), 10-Q (reporting date: 2012-02-29), 10-Q (reporting date: 2011-11-30).

1 Q2 2018 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 2,409 ÷ 7,149 = 0.34

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Monsanto Co. cash ratio improved from Q4 2017 to Q1 2018 but then slightly deteriorated from Q1 2018 to Q2 2018.