Analysis of Short-term (Operating) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Short-term Activity Ratios (Summary)
Monsanto Co., short-term (operating) activity ratios (quarterly data)
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).
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Monsanto Co. inventory turnover ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Monsanto Co. receivables turnover ratio improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018. |
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Monsanto Co. payables turnover ratio decreased from Q4 2017 to Q1 2018 but then increased from Q1 2018 to Q2 2018 exceeding Q4 2017 level. |
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Monsanto Co. working capital turnover ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Monsanto Co. number of days of inventory outstanding deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Monsanto Co. number of days of receivables outstanding improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018. |
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Monsanto Co. operating cycle deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Monsanto Co. number of days of payables outstanding increased from Q4 2017 to Q1 2018 but then decreased significantly from Q1 2018 to Q2 2018. |
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Monsanto Co. cash conversion cycle deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
Inventory Turnover
Monsanto Co., inventory turnover calculation (quarterly data)
| 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) | ||||||||||||||||||||||||||||||||||
| Cost of goods sold | 2,053) | 1,346) | 1,346) | 1,844) | 2,122) | 1,391) | 1,424) | 1,809) | 1,934) | 1,318) | 1,359) | 1,843) | 2,158) | 1,459) | 1,397) | 1,919) | 2,385) | 1,580) | 1,278) | 1,986) | 2,402) | 1,542) | 1,217) | 1,856) | 2,043) | 1,343) | ||||||||
| Inventory, net | 4,015) | 4,033) | 3,340) | 3,189) | 3,621) | 3,839) | 3,241) | 3,370) | 3,704) | 3,872) | 3,496) | 3,625) | 3,978) | 4,300) | 3,597) | 3,552) | 3,692) | 3,873) | 2,947) | 2,884) | 3,095) | 3,571) | 2,839) | 2,514) | 2,862) | 3,136) | ||||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Inventory turnover1 | 1.64 | 1.65 | 2.01 | 2.13 | 1.86 | 1.71 | 2.00 | 1.91 | 1.74 | 1.72 | 1.95 | 1.89 | 1.74 | 1.67 | 2.02 | 2.02 | 1.96 | 1.87 | 2.45 | 2.48 | 2.27 | 1.86 | 2.28 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Inventory Turnover, 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
Inventory turnover
= (Cost of goods soldQ2 2018
+ Cost of goods soldQ1 2018
+ Cost of goods soldQ4 2017
+ Cost of goods soldQ3 2017)
÷ Inventory, net
= (2,053 + 1,346 + 1,346 + 1,844)
÷ 4,015 = 1.64
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Inventory turnover | An activity ratio calculated as cost of goods sold divided by inventory. | Monsanto Co. inventory turnover ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
Receivables Turnover
Monsanto Co., receivables turnover calculation (quarterly data)
| 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) | ||||||||||||||||||||||||||||||||||
| Net sales | 5,019) | 2,658) | 2,686) | 4,230) | 5,074) | 2,650) | 2,562) | 4,189) | 4,532) | 2,219) | 2,355) | 4,579) | 5,197) | 2,870) | 2,630) | 4,250) | 5,832) | 3,143) | 2,202) | 4,248) | 5,472) | 2,939) | 2,098) | 4,219) | 4,748) | 2,439) | ||||||||
| 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) | ||||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Receivables turnover1 | 5.79 | 6.93 | 6.77 | 3.71 | 5.56 | 6.34 | 7.01 | 4.20 | 7.49 | 6.81 | 9.17 | 3.82 | 6.34 | 6.93 | 7.87 | 3.65 | 6.13 | 6.60 | 8.67 | 4.09 | 6.64 | 6.46 | 7.12 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Receivables Turnover, 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
Receivables turnover
= (Net salesQ2 2018
+ Net salesQ1 2018
+ Net salesQ4 2017
+ Net salesQ3 2017)
÷ Trade receivables, net
= (5,019 + 2,658 + 2,686 + 4,230)
÷ 2,520 = 5.79
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Receivables turnover | An activity ratio equal to revenue divided by receivables. | Monsanto Co. receivables turnover ratio improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018. |
Payables Turnover
Monsanto Co., payables turnover calculation (quarterly data)
| 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) | ||||||||||||||||||||||||||||||||||
| Cost of goods sold | 2,053) | 1,346) | 1,346) | 1,844) | 2,122) | 1,391) | 1,424) | 1,809) | 1,934) | 1,318) | 1,359) | 1,843) | 2,158) | 1,459) | 1,397) | 1,919) | 2,385) | 1,580) | 1,278) | 1,986) | 2,402) | 1,542) | 1,217) | 1,856) | 2,043) | 1,343) | ||||||||
| Accounts payable | 875) | 1,194) | 1,068) | 753) | 785) | 1,073) | 1,006) | 620) | 635) | 818) | 836) | 686) | 785) | 905) | 1,111) | 780) | 847) | 853) | 995) | 745) | 751) | 785) | 794) | 584) | 681) | 735) | ||||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Payables turnover1 | 7.53 | 5.58 | 6.28 | 9.01 | 8.59 | 6.11 | 6.45 | 10.35 | 10.16 | 8.16 | 8.16 | 10.00 | 8.83 | 7.91 | 6.55 | 9.18 | 8.53 | 8.49 | 7.24 | 9.59 | 9.34 | 8.48 | 8.13 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Payables Turnover, 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
Payables turnover
= (Cost of goods soldQ2 2018
+ Cost of goods soldQ1 2018
+ Cost of goods soldQ4 2017
+ Cost of goods soldQ3 2017)
÷ Accounts payable
= (2,053 + 1,346 + 1,346 + 1,844)
÷ 875 = 7.53
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Payables turnover | An activity ratio calculated as cost of goods sold divided by payables. | Monsanto Co. payables turnover ratio decreased from Q4 2017 to Q1 2018 but then increased from Q1 2018 to Q2 2018 exceeding Q4 2017 level. |
Working Capital Turnover
Monsanto Co., working capital turnover calculation (quarterly data)
| 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) | ||||||||
| Less: 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) | ||||||||
| Working capital | 2,907) | 2,302) | 2,253) | 3,060) | 2,593) | 2,152) | 1,428) | 2,875) | 2,544) | 1,966) | 5,448) | 6,492) | 5,227) | 4,399) | 4,563) | 7,306) | 6,499) | 5,798) | 5,741) | 7,327) | 6,825) | 5,899) | 5,437) | 5,501) | 4,831) | 3,881) | ||||||||
| Net sales | 5,019) | 2,658) | 2,686) | 4,230) | 5,074) | 2,650) | 2,562) | 4,189) | 4,532) | 2,219) | 2,355) | 4,579) | 5,197) | 2,870) | 2,630) | 4,250) | 5,832) | 3,143) | 2,202) | 4,248) | 5,472) | 2,939) | 2,098) | 4,219) | 4,748) | 2,439) | ||||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Working capital turnover1 | 5.02 | 6.36 | 6.50 | 4.74 | 5.58 | 6.47 | 9.46 | 4.62 | 5.38 | 7.30 | 2.75 | 2.35 | 2.86 | 3.54 | 3.47 | 2.11 | 2.37 | 2.60 | 2.59 | 2.01 | 2.16 | 2.37 | 2.48 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Working Capital Turnover, 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
Working capital turnover
= (Net salesQ2 2018
+ Net salesQ1 2018
+ Net salesQ4 2017
+ Net salesQ3 2017)
÷ Working capital
= (5,019 + 2,658 + 2,686 + 4,230)
÷ 2,907 = 5.02
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Working capital turnover | An activity ratio calculated as revenue divided by working capital. | Monsanto Co. working capital turnover ratio deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
Average Inventory Processing Period
Monsanto Co., average inventory processing period calculation (quarterly data)
| 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 | ||||||||||||||||||||||||||||||||||
| Inventory turnover | 1.64 | 1.65 | 2.01 | 2.13 | 1.86 | 1.71 | 2.00 | 1.91 | 1.74 | 1.72 | 1.95 | 1.89 | 1.74 | 1.67 | 2.02 | 2.02 | 1.96 | 1.87 | 2.45 | 2.48 | 2.27 | 1.86 | 2.28 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||||||
| Average inventory processing period1 | 222 | 221 | 182 | 172 | 196 | 214 | 182 | 192 | 209 | 212 | 187 | 193 | 209 | 219 | 180 | 181 | 186 | 195 | 149 | 147 | 161 | 196 | 160 | — | — | — | ||||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||||||||
| Average Inventory Processing Period, 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
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 1.64 = 222
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average inventory processing period | An activity ratio equal to the number of days in the period divided by inventory turnover over the period. | Monsanto Co. number of days of inventory outstanding deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
Average Receivable Collection Period
Monsanto Co., average receivable collection period calculation (quarterly data)
| 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 | ||||||||||||||||||||||||||||||||||
| Receivables turnover | 5.79 | 6.93 | 6.77 | 3.71 | 5.56 | 6.34 | 7.01 | 4.20 | 7.49 | 6.81 | 9.17 | 3.82 | 6.34 | 6.93 | 7.87 | 3.65 | 6.13 | 6.60 | 8.67 | 4.09 | 6.64 | 6.46 | 7.12 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||||||
| Average receivable collection period1 | 63 | 53 | 54 | 98 | 66 | 58 | 52 | 87 | 49 | 54 | 40 | 96 | 58 | 53 | 46 | 100 | 60 | 55 | 42 | 89 | 55 | 57 | 51 | — | — | — | ||||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||||||||
| Average Receivable Collection Period, 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
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 5.79 = 63
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average receivable collection period | An activity ratio equal to the number of days in the period divided by receivables turnover. | Monsanto Co. number of days of receivables outstanding improved from Q4 2017 to Q1 2018 but then deteriorated significantly from Q1 2018 to Q2 2018. |
Operating Cycle
Monsanto Co., operating cycle calculation (quarterly data)
No. days
| 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 | ||||||||||||||||||||||||||||||||||
| Average inventory processing period | 222 | 221 | 182 | 172 | 196 | 214 | 182 | 192 | 209 | 212 | 187 | 193 | 209 | 219 | 180 | 181 | 186 | 195 | 149 | 147 | 161 | 196 | 160 | — | — | — | ||||||||
| Average receivable collection period | 63 | 53 | 54 | 98 | 66 | 58 | 52 | 87 | 49 | 54 | 40 | 96 | 58 | 53 | 46 | 100 | 60 | 55 | 42 | 89 | 55 | 57 | 51 | — | — | — | ||||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Operating cycle1 | 285 | 274 | 236 | 270 | 262 | 272 | 234 | 279 | 258 | 266 | 227 | 289 | 267 | 272 | 226 | 281 | 246 | 250 | 191 | 236 | 216 | 253 | 211 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Operating Cycle, 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
Operating cycle = Average inventory processing period + Average receivable collection period
= 222 + 63 = 285
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Operating cycle | Equal to average inventory processing period plus average receivables collection period. | Monsanto Co. operating cycle deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |
Average Payables Payment Period
Monsanto Co., average payables payment period calculation (quarterly data)
| 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 | ||||||||||||||||||||||||||||||||||
| Payables turnover | 7.53 | 5.58 | 6.28 | 9.01 | 8.59 | 6.11 | 6.45 | 10.35 | 10.16 | 8.16 | 8.16 | 10.00 | 8.83 | 7.91 | 6.55 | 9.18 | 8.53 | 8.49 | 7.24 | 9.59 | 9.34 | 8.48 | 8.13 | — | — | — | ||||||||
| Short-term Activity Ratio (no. days) | ||||||||||||||||||||||||||||||||||
| Average payables payment period1 | 48 | 65 | 58 | 41 | 42 | 60 | 57 | 35 | 36 | 45 | 45 | 37 | 41 | 46 | 56 | 40 | 43 | 43 | 50 | 38 | 39 | 43 | 45 | — | — | — | ||||||||
| Benchmarks (no. days) | ||||||||||||||||||||||||||||||||||
| Average Payables Payment Period, 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
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 7.53 = 48
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Average payables payment period | An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. | Monsanto Co. number of days of payables outstanding increased from Q4 2017 to Q1 2018 but then decreased significantly from Q1 2018 to Q2 2018. |
Cash Conversion Cycle
Monsanto Co., cash conversion cycle calculation (quarterly data)
No. days
| 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 | ||||||||||||||||||||||||||||||||||
| Average inventory processing period | 222 | 221 | 182 | 172 | 196 | 214 | 182 | 192 | 209 | 212 | 187 | 193 | 209 | 219 | 180 | 181 | 186 | 195 | 149 | 147 | 161 | 196 | 160 | — | — | — | ||||||||
| Average receivable collection period | 63 | 53 | 54 | 98 | 66 | 58 | 52 | 87 | 49 | 54 | 40 | 96 | 58 | 53 | 46 | 100 | 60 | 55 | 42 | 89 | 55 | 57 | 51 | — | — | — | ||||||||
| Average payables payment period | 48 | 65 | 58 | 41 | 42 | 60 | 57 | 35 | 36 | 45 | 45 | 37 | 41 | 46 | 56 | 40 | 43 | 43 | 50 | 38 | 39 | 43 | 45 | — | — | — | ||||||||
| Short-term Activity Ratio | ||||||||||||||||||||||||||||||||||
| Cash conversion cycle1 | 237 | 209 | 178 | 229 | 220 | 212 | 177 | 244 | 222 | 221 | 182 | 252 | 226 | 226 | 170 | 241 | 203 | 207 | 141 | 198 | 177 | 210 | 166 | — | — | — | ||||||||
| Benchmarks | ||||||||||||||||||||||||||||||||||
| Cash Conversion Cycle, 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 conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 222 + 63 – 48 = 237
2 Click competitor name to see calculations.
| Short-term activity ratio | Description | The company |
|---|---|---|
| Cash conversion cycle | A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. | Monsanto Co. cash conversion cycle deteriorated from Q4 2017 to Q1 2018 and from Q1 2018 to Q2 2018. |