Export to Excel Export to OpenOffice.org Print version

Monsanto Co. (MON) | Analysis of Inventory

Inventory Accounting Policy

Inventory Valuation and Obsolescence

Inventories are stated at the lower of cost or market, and an inventory reserve would permanently reduce the cost basis of inventory. Inventories are valued as follows:

  • Seeds and Genomics: Actual cost is used to value raw materials such as treatment chemicals and packaging, as well as goods in process. Costs for substantially all finished goods, which include the cost of carryover crops from the previous year, are valued at weighted-average actual cost. Weighted-average actual cost includes field growing and harvesting costs, plant conditioning and packaging costs, and manufacturing overhead costs.
  • Agricultural Productivity: Actual cost is used to value raw materials and supplies. Standard cost, which approximates actual cost, is used to value finished goods and goods in process. Variances, exclusive of abnormally low volume and operating performance, are capitalized into inventory. Standard cost includes direct labor and raw materials, and manufacturing overhead based on normal capacity. The cost of the Agricultural Productivity segment inventories in the United States (approximately 10 percent as of Aug. 31, 2011 and 14 percent as of Aug. 31, 2010) is determined by using the last-in, first-out (LIFO) method, which generally reflects the effects of inflation or deflation on cost of goods sold sooner than other inventory cost methods. The cost of inventories outside of the United States, as well as supplies inventories in the United States, is determined by using the first-in, first-out (FIFO) method; FIFO is used outside of the United States because the requirements in the countries where Monsanto maintains inventories generally do not allow the use of the LIFO method. Inventories at FIFO approximate current cost.

In accordance with the Inventory topic of the ASC, Monsanto records abnormal amounts of idle facility expense, freight, handling costs and wasted material (spoilage) as current period charges and allocates fixed production overhead to the costs of conversion based on the normal capacity of the production facilities.

Monsanto establishes allowances for obsolescence of inventory equal to the difference between the higher of cost of inventory and the estimated market value, based on assumptions about future demand and market conditions. Monsanto regularly evaluates the adequacy of inventory obsolescence reserves. If economic and market conditions are different from those anticipated, inventory obsolescence could be materially different from the amounts provided for in Monsanto's consolidated financial statements. If inventory obsolescence is higher than expected, cost of goods sold will be increased, and inventory, net income, and shareowners' equity will be reduced.

Source: Monsanto Co., Annual Report

Inventory Disclosure

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Monsanto Co., Statement of Financial Position, Inventory

USD $ in millions

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
chart Finished goods
chart Goods in process
chart Raw materials and supplies
chart Inventory at FIFO cost
chart Excess of FIFO over LIFO cost
chart Inventory, net

Source: Based on data from Monsanto Co. Annual Reports

Item Description The company
Finished goods Carrying amount as of the balance sheet date of merchandise or goods held by the company that are readily available for sale. Monsanto Co.'s finished goods declined from 2009 to 2010 and from 2010 to 2011.
Goods in process Carrying amount as of the balance sheet date of merchandise or goods which are partially completed, are generally comprised of raw materials, labor and factory overhead costs, and which require further materials, labor and overhead to be converted into finished goods, and which generally require the use of estimates to determine percentage complete and pricing. Monsanto Co.'s goods in process declined from 2009 to 2010 but then increased from 2010 to 2011 exceeding 2009 level.
Raw materials and supplies Aggregated amount of unprocessed materials to be used in manufacturing or production process and supplies that will be consumed. Monsanto Co.'s raw materials and supplies declined from 2009 to 2010 but then increased from 2010 to 2011 not reaching 2009 level.
Inventory, net Carrying amount (lower of cost or market) as of the balance sheet date of inventories less all valuation and other allowances. Excludes noncurrent inventory balances (expected to remain on hand past one year or one operating cycle, if longer). Monsanto Co.'s inventory, net declined from 2009 to 2010 and from 2010 to 2011.

Adjustment to Inventory: from LIFO to FIFO

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Adjusting LIFO Inventory to FIFO (Current) Cost

USD $ in millions

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  Adjustment to Inventory, Net
chart Inventory, net at LIFO (as reported)
chart Add: LIFO reserve, ending balance
chart Inventory, net at FIFO (adjusted)
  Adjustment to Current Assets
chart Current assets (as reported)
chart Add: LIFO reserve, ending balance
chart Current assets (adjusted)
  Adjustment to Total Assets
chart Total assets (as reported)
chart Add: LIFO reserve, ending balance
chart Total assets (adjusted)
  Adjustment to Monsanto Company Shareowners’ Equity
chart Monsanto Company shareowners’ equity (as reported)
chart Add: LIFO reserve, ending balance
chart Monsanto Company shareowners’ equity (adjusted)
  Adjustment to Net Income Attributable To Monsanto Company
chart Net income attributable to Monsanto Company (as reported)
chart Add: Increase (decrease) in LIFO reserve, ending balance
chart Net income attributable to Monsanto Company (adjusted)

Monsanto Co.'s inventory value on Aug 31, 2011 would be $2,777  (in millions) if the FIFO inventory method was used instead of LIFO. Monsanto Co.'s inventories, valued on a LIFO basis, on Aug 31, 2011 were $2,591 . Monsanto Co.'s inventories would have been $186  higher than reported on Aug 31, 2011 if the FIFO method had been used instead.

Adjusted Ratios: LIFO vs. FIFO (Summary)

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Monsanto Co., adjusted ratios

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  Current Ratio
chart Reported current ratio (LIFO)
chart Adjusted current ratio (FIFO)
  Net Profit Margin
chart Reported net profit margin (LIFO) % % % % % %
chart Adjusted net profit margin (FIFO) % % % % % %
  Total Asset Turnover
chart Reported total asset turnover (LIFO)
chart Adjusted total asset turnover (FIFO)
  Financial Leverage
chart Reported financial leverage (LIFO)
chart Adjusted financial leverage (FIFO)
  Return on Equity (ROE)
chart Reported ROE (LIFO) % % % % % %
chart Adjusted ROE (FIFO) % % % % % %
  Return on Assets (ROA)
chart Reported ROA (LIFO) % % % % % %
chart Adjusted ROA (FIFO) % % % % % %
Ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by current liabilities. Monsanto Co.'s adjusted current ratio deteriorated from 2009 to 2010 and from 2010 to 2011.
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Monsanto Co.'s adjusted net profit margin deteriorated from 2009 to 2010 but then improved from 2010 to 2011 not reaching 2009 level.
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Monsanto Co.'s adjusted total asset turnover deteriorated from 2009 to 2010 but then slightly improved from 2010 to 2011.
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Monsanto Co.'s adjusted financial leverage increased from 2009 to 2010 but then declined significantly from 2010 to 2011.
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted shareholders' equity. Monsanto Co.'s adjusted ROE deteriorated from 2009 to 2010 but then slightly improved from 2010 to 2011.
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Monsanto Co.'s adjusted ROA deteriorated from 2009 to 2010 but then slightly improved from 2010 to 2011.

Adjusted Current Ratio

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  As Reported
chart Current assets (USD $ in millions)
chart Current liabilities (USD $ in millions)
   
chart Current ratio1
  Adjusted: from LIFO to FIFO
chart Adjusted current assets (USD $ in millions)
chart Current liabilities (USD $ in millions)
   
chart Adjusted current ratio2

2011 Calculations

1 Current ratio = Current assets ÷ Current liabilities
= ÷ =

2 Adjusted current ratio = Adjusted current assets ÷ Current liabilities
= ÷ =

Ratio Description The company
Adjusted current ratio A liquidity ratio calculated as adjusted current assets divided by current liabilities. Monsanto Co.'s adjusted current ratio deteriorated from 2009 to 2010 and from 2010 to 2011.

Adjusted Net Profit Margin

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  As Reported
chart Net income attributable to Monsanto Company (USD $ in millions)
chart Net sales (USD $ in millions)
   
chart Net profit margin1 % % % % % %
  Adjusted: from LIFO to FIFO
chart Adjusted net income attributable to Monsanto Company (USD $ in millions)
chart Net sales (USD $ in millions)
   
chart Adjusted net profit margin2 % % % % % %

2011 Calculations

1 Net profit margin = 100 × Net income attributable to Monsanto Company ÷ Net sales
= 100 × ÷ = %

2 Adjusted net profit margin = 100 × Adjusted net income attributable to Monsanto Company ÷ Net sales
= 100 × ÷ = %

Ratio Description The company
Adjusted net profit margin An indicator of profitability, calculated as adjusted net income divided by revenue. Monsanto Co.'s adjusted net profit margin deteriorated from 2009 to 2010 but then improved from 2010 to 2011 not reaching 2009 level.

Adjusted Total Asset Turnover

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  As Reported
chart Net sales (USD $ in millions)
chart Total assets (USD $ in millions)
   
chart Total asset turnover1
  Adjusted: from LIFO to FIFO
chart Net sales (USD $ in millions)
chart Adjusted total assets (USD $ in millions)
   
chart Adjusted total asset turnover2

2011 Calculations

1 Total asset turnover = Net sales ÷ Total assets
= ÷ =

2 Adjusted total asset turnover = Net sales ÷ Adjusted total assets
= ÷ =

Ratio Description The company
Adjusted total asset turnover An activity ratio calculated as total revenue divided by adjusted total assets. Monsanto Co.'s adjusted total asset turnover deteriorated from 2009 to 2010 but then slightly improved from 2010 to 2011.

Adjusted Financial Leverage

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  As Reported
chart Total assets (USD $ in millions)
chart Monsanto Company shareowners’ equity (USD $ in millions)
   
chart Financial leverage1
  Adjusted: from LIFO to FIFO
chart Adjusted total assets (USD $ in millions)
chart Adjusted monsanto Company shareowners’ equity (USD $ in millions)
   
chart Adjusted financial leverage2

2011 Calculations

1 Financial leverage = Total assets ÷ Monsanto Company shareowners’ equity
= ÷ =

2 Adjusted financial leverage = Adjusted total assets ÷ Adjusted monsanto Company shareowners’ equity
= ÷ =

Ratio Description The company
Adjusted financial leverage A measure of financial leverage calculated as adjusted total assets divided by adjusted total equity.
Financial leverage is the extent to which a company can effect, through the use of debt, a proportional change in the return on common equity that is greater than a given proportional change in operating income.
Monsanto Co.'s adjusted financial leverage increased from 2009 to 2010 but then declined significantly from 2010 to 2011.

Adjusted Return On Equity (ROE)

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  As Reported
chart Net income attributable to Monsanto Company (USD $ in millions)
chart Monsanto Company shareowners’ equity (USD $ in millions)
   
chart ROE1 % % % % % %
  Adjusted: from LIFO to FIFO
chart Adjusted net income attributable to Monsanto Company (USD $ in millions)
chart Adjusted monsanto Company shareowners’ equity (USD $ in millions)
   
chart Adjusted ROE2 % % % % % %

2011 Calculations

1 ROE = 100 × Net income attributable to Monsanto Company ÷ Monsanto Company shareowners’ equity
= 100 × ÷ = %

2 Adjusted ROE = 100 × Adjusted net income attributable to Monsanto Company ÷ Adjusted monsanto Company shareowners’ equity
= 100 × ÷ = %

Ratio Description The company
Adjusted ROE A profitability ratio calculated as adjusted net income divided by adjusted shareholders' equity. Monsanto Co.'s adjusted ROE deteriorated from 2009 to 2010 but then slightly improved from 2010 to 2011.

Adjusted Return On Assets (ROA)

You have visited 10 password protected pages for free. Others contain data covered by .

Sign Up Now to get full access to whole website and cut out all advertisements.

Export to Excel Export to OpenOffice.org
    Aug 31, 2011 Aug 31, 2010 Aug 31, 2009 Aug 31, 2008 Aug 31, 2007 Aug 31, 2006
  As Reported
chart Net income attributable to Monsanto Company (USD $ in millions)
chart Total assets (USD $ in millions)
   
chart ROA1 % % % % % %
  Adjusted: from LIFO to FIFO
chart Adjusted net income attributable to Monsanto Company (USD $ in millions)
chart Adjusted total assets (USD $ in millions)
   
chart Adjusted ROA2 % % % % % %

2011 Calculations

1 ROA = 100 × Net income attributable to Monsanto Company ÷ Total assets
= 100 × ÷ = %

2 Adjusted ROA = 100 × Adjusted net income attributable to Monsanto Company ÷ Adjusted total assets
= 100 × ÷ = %

Ratio Description The company
Adjusted ROA A profitability ratio calculated as adjusted net income divided by adjusted total assets. Monsanto Co.'s adjusted ROA deteriorated from 2009 to 2010 but then slightly improved from 2010 to 2011.

May 23, 2012

Existing users sign in

Forgot your password?