Tables
Tables in the 10-Q of MOSAIC CO
26 tables with numbers, filed Aug 4, 2015. Each one downloads as an Excel file or a CSV (numbers are stored as numbers), with the filing's address in the last row. Only the layout is tidied (a "$" or ")" in a cell of its own is joined to its number); no value is changed. Open the filing on sec.gov ↗
← Filings of MOS
Table 1 after “Table of Contents”
| Table of Contents | |||
| PART I. | FINANCIAL INFORMATION | ||
| Item 1. | Financial Statements | 1 | |
| Condensed Consolidated Statements of Earnings | 1 | ||
| Condensed Consolidated Statements of Comprehensive Income | 2 | ||
| Condensed Consolidated Balance Sheets | 3 | ||
| Condensed Consolidated Statements of Cash Flows | 4 | ||
| Condensed Consolidated Statements of Equity | 5 |
First 8 of 19 rows. The download has all of them.
Table 2 after “(Unaudited)”
| Three months ended | Six months ended | |||||
| June 30, | June 30, | |||||
| 2015 | 2014 | 2015 | 2014 | |||
| Net sales | $2,487.5 | $2,440.2 | $4,626.6 | $4,426.5 | ||
| Cost of goods sold | 1,879.6 | 1,919.1 | 3,599.5 | 3,493.7 | ||
| Gross margin | 607.9 | 521.1 | 1,027.1 | 932.8 | ||
| Selling, general and administrative expenses | 89.3 | 87.5 | 189.8 | 207.4 | ||
| Other operating expense | 8.6 | 30.4 | 8.8 | 55.6 |
First 8 of 24 rows. The download has all of them.
Table 3 after “(Unaudited)”
| Three months ended | Six months ended | |||||
| June 30, | June 30, | |||||
| 2015 | 2014 | 2015 | 2014 | |||
| Net earnings including noncontrolling interest | $391.0 | $248.2 | $685.6 | $465.9 | ||
| Other comprehensive income (loss), net of tax | ||||||
| Foreign currency translation, net of tax | 139.7 | 251.6 | (476.4) | 13.0 | ||
| Net actuarial gain and prior service cost, net of tax | 1.9 | (0.5) | 5.2 | 2.9 | ||
| Amortization of loss on interest rate swap, net of tax | 0.6 | 0.7 | 1.3 | 1.4 |
First 8 of 12 rows. The download has all of them.
Table 4 after “(Unaudited)”
| June 30, 2015 | December 31, 2014 | ||
| Assets | |||
| Current assets: | |||
| Cash and cash equivalents | $2,209.9 | $2,374.6 | |
| Receivables, net | 626.6 | 754.4 | |
| Inventories | 1,612.2 | 1,718.3 | |
| Deferred income taxes | 148.2 | 148.7 | |
| Other current assets | 503.2 | 368.2 |
First 8 of 39 rows. The download has all of them.
Table 5 after “(Unaudited)”
| Six months ended | |||
| June 30, 2015 | June 30, 2014 | ||
| Cash Flows from Operating Activities: | |||
| Net earnings including noncontrolling interests | $685.6 | $465.9 | |
| Adjustments to reconcile net earnings including noncontrolling interests to net cash provided by operating activities: | |||
| Depreciation, depletion and amortization | 373.9 | 368.7 | |
| Deferred income taxes | 0.5 | (92.0) | |
| Equity in net earnings of nonconsolidated companies, net of dividends | 24.0 | 7.0 |
First 8 of 47 rows. The download has all of them.
Table 6 after “(Unaudited)”
| Mosaic Shareholders | ||||||||||||
| Shares | Dollars | |||||||||||
| Capital in Excess of Par Value | Accumulated Other Comprehensive Income | |||||||||||
| Common Stock | Common Stock | Retained Earnings | Noncontrolling Interests | Total Equity | ||||||||
| Balance as of December 31, 2013 | 425.9 | $4.3 | $1.6 | $11,182.1 | $114.3 | $18.3 | $11,320.6 | |||||
| Total comprehensive income (loss) | — | — | — | 1,028.6 | (588.0) | (0.2) | 440.4 | |||||
| Stock option exercises | 0.7 | — | 6.7 | — | — | — | 6.7 | |||||
| Amortization of stock based compensation | — | — | 54.3 | — | — | — | 54.3 |
First 8 of 21 rows. The download has all of them.
Table 7 after “tional information concerning selected balance sheet accounts:”
| (in millions) | June 30, 2015 | December 31, 2014 | |
| Other current assets | |||
| Final price deferred(a) | $134.3 | $49.9 | |
| Income and other taxes receivable | 207.5 | 201.9 | |
| Prepaid expenses | 86.7 | 63.8 | |
| Other | 74.7 | 52.6 | |
| $503.2 | $368.2 | ||
| Accrued liabilities |
First 8 of 21 rows. The download has all of them.
Table 8 after “The following is a reconciliation of the numerator and denominator for the basic and diluted EPS computations:”
| Three months ended | Six months ended | ||||||
| June 30, | June 30, | ||||||
| 2015 | 2014 | 2015 | 2014 | ||||
| Net earnings attributable to Mosaic | $390.6 | $248.4 | $685.4 | $466.0 | |||
| Undistributed earnings attributable to participating securities | — | (6.3) | — | (19.5) | |||
| Numerator for basic and diluted earnings available to common stockholders | $390.6 | $242.1 | $685.4 | $446.5 | |||
| Basic weighted average number of shares outstanding | 361.3 | 384.0 | 363.6 | 392.5 | |||
| Shares subject to forward contract | — | (9.8) | — | (16.4) |
First 8 of 13 rows. The download has all of them.
Table 9 after “Inventories consist of the following:”
| June 30, 2015 | December 31, 2014 | ||
| Raw materials | $55.7 | $114.6 | |
| Work in process | 443.1 | 505.1 | |
| Finished goods | 1,039.9 | 1,025.5 | |
| Operating materials and supplies | 73.5 | 73.1 | |
| $1,612.2 | $1,718.3 |
Table 10 after “The changes in the carrying amount of goodwill, by reporting unit, are as follows:”
| Phosphates | Potash | International Distribution | Total | |||
| Balance as of December 31, 2014 | $648.4 | $1,158.1 | $— | $1,806.5 | ||
| Foreign currency translation | — | (67.8) | (7.2) | (75.0) | ||
| Allocation of goodwill due to Realignment | (156.0) | — | 156.0 | — | ||
| Adjustment to goodwill acquired in ADM acquisition | — | — | (21.9) | (21.9) | ||
| Balance as of June 30, 2015 | $492.4 | $1,090.3 | $126.9 | $1,709.6 |
Table 11 after “, the following is the total absolute notional volume associated with our outstanding derivative instruments:”
| (in millions of Units) | June 30, 2015 | December 31, 2014 | ||||
| Derivative Instrument | Derivative Category | Unit of Measure | ||||
| Foreign currency derivatives | Foreign currency | US Dollars | 1,166.0 | 1,132.3 | ||
| Natural gas derivatives | Commodity | MMbtu | 30.2 | 24.4 |
Table 12 after “The carrying amounts and estimated fair values of our financial instruments are as follows:”
| June 30, 2015 | December 31, 2014 | ||||||
| Carrying Amount | Fair Value | Carrying Amount | Fair Value | ||||
| Cash and cash equivalents | $2,209.9 | $2,209.9 | $2,374.6 | $2,374.6 | |||
| Receivables, net | 626.6 | 626.6 | 754.4 | 754.4 | |||
| Accounts payable | 858.2 | 858.2 | 797.3 | 797.3 | |||
| Short-term debt | 27.0 | 27.0 | 13.5 | 13.5 | |||
| Long-term debt, including current portion | 3,818.9 | 3,983.5 | 3,819.0 | 4,101.2 |
Table 13 after “The Condensed Consolidated Statements of Earnings included the following transactions with our non-consolidated companies:”
| Three months ended | Six months ended | ||||||
| June 30, | June 30, | ||||||
| 2015 | 2014 | 2015 | 2014 | ||||
| Transactions with non-consolidated companies included in net sales | $358.2 | $307.7 | $622.1 | $512.7 | |||
| Transactions with non-consolidated companies included in cost of goods sold | 368.2 | 191.3 | 480.9 | 288.7 |
Table 14 after “was as follows:”
| Phosphates | Potash | International Distribution | Corporate, Eliminations and Other | Total | ||||
| Three months ended June 30, 2015 | ||||||||
| Net sales to external customers | $1,111.1 | $727.4 | $637.0 | $12.0 | $2,487.5 | |||
| Intersegment net sales(a) | 273.9 | 2.8 | 0.4 | (277.1) | — | |||
| Net sales | 1,385.0 | 730.2 | 637.4 | (265.1) | 2,487.5 | |||
| Gross margin(a) | 295.9 | 295.0 | 28.5 | (11.5) | 607.9 | |||
| Operating earnings | 259.4 | 258.8 | 7.7 | (15.9) | 510.0 | |||
| Capital expenditures | 117.6 | 88.0 | 16.5 | 5.3 | 227.4 |
First 8 of 35 rows. The download has all of them.
Table 15 after “The following table summarizes the amounts of the assets acquired and liabilities assumed as recognized with the acquisition.”
| (in millions) | |
| Inventory | $117.0 |
| Other current assets | 9.4 |
| Property, plant and equipment | 95.9 |
| Goodwill | 83.8 |
| Intangible assets | 19.1 |
| Other assets | 16.8 |
| Other current liabilities | (23.5) |
First 8 of 10 rows. The download has all of them.
Table 16 after “:”
| Three months ended | Six months ended | |||||||||||||
| June 30, | 2015-2014 | June 30, | 2015-2014 | |||||||||||
| (in millions, except per share data) | 2015 | 2014 | Change | Percent | 2015 | 2014 | Change | Percent | ||||||
| Net sales | $2,487.5 | $2,440.2 | $47.3 | 2% | $4,626.6 | $4,426.5 | $200.1 | 5% | ||||||
| Cost of goods sold | 1,879.6 | 1,919.1 | (39.5) | (2)% | 3,599.5 | 3,493.7 | 105.8 | 3% | ||||||
| Gross margin | 607.9 | 521.1 | 86.8 | 17% | 1,027.1 | 932.8 | 94.3 | 10% | ||||||
| Gross margin percentage | 24% | 21% | 22% | 21% | ||||||||||
| Selling, general and administrative expenses | 89.3 | 87.5 | 1.8 | 2% | 189.8 | 207.4 | (17.6) | (8)% |
First 8 of 23 rows. The download has all of them.
Table 17 after “The following table summarizes the Phosphates segment’s net sales, gross margin, sales volume, selling prices and raw material prices:”
| Three months ended | Six months ended | |||||||||||||
| June 30, | 2015-2014 | June 30, | 2015-2014 | |||||||||||
| (in millions, except price per tonne or unit) | 2015 | 2014 | Change | Percent | 2015 | 2014 | Change | Percent | ||||||
| Net sales: | ||||||||||||||
| North America | $704.5 | $724.4 | $(19.9) | (3)% | $1,387.6 | $1,282.9 | $104.7 | 8% | ||||||
| International | 680.5 | 608.7 | 71.8 | 12% | 1,169.7 | 1,009.1 | 160.6 | 16% | ||||||
| Total | 1,385.0 | 1,333.1 | 51.9 | 4% | 2,557.3 | 2,292.0 | 265.3 | 12% | ||||||
| Cost of goods sold | 1,089.1 | 1,062.6 | 26.5 | 2% | 2,039.7 | 1,822.0 | 217.7 | 12% |
First 8 of 24 rows. The download has all of them.
Table 18 after “The following table summarizes the Potash segment’s net sales, gross margin, sales volume and selling price:”
| Three months ended | Six months ended | |||||||||||||
| June 30, | 2015-2014 | June 30, | 2015-2014 | |||||||||||
| (in millions, except price per tonne or unit) | 2015 | 2014 | Change | Percent | 2015 | 2014 | Change | Percent | ||||||
| Net sales: | ||||||||||||||
| North America | $372.3 | $434.8 | $(62.5) | (14)% | $753.4 | $941.2 | $(187.8) | (20)% | ||||||
| International | 357.9 | 327.5 | 30.4 | 9% | 629.6 | 554.3 | 75.3 | 14% | ||||||
| Total | 730.2 | 762.3 | (32.1) | (4)% | 1,383.0 | 1,495.5 | (112.5) | (8)% | ||||||
| Cost of goods sold | 435.2 | 536.0 | (100.8) | (19)% | 846.1 | 1,053.2 | (207.1) | (20)% |
First 8 of 22 rows. The download has all of them.
Table 19 after “The following table summarizes the International Distribution segment’s net sales, gross margin, sales volume and selling price:”
| Three months ended | Six months ended | |||||||||||||
| June 30, | 2015-2014 | June 30, | 2015-2014 | |||||||||||
| (in millions, except price per tonne or unit) | 2015 | 2014 | Change | Percent | 2015 | 2014 | Change | Percent | ||||||
| Net Sales | $637.4 | $542.1 | 95.3 | 18% | $1,076.3 | $934.9 | 141.4 | 15% | ||||||
| Cost of goods sold | 608.9 | 508.2 | 100.7 | 20% | 1,027.3 | 879.3 | 148.0 | 17% | ||||||
| Gross margin | $28.5 | $33.9 | $(5.4) | (16)% | $49.0 | $55.6 | $(6.6) | (12)% | ||||||
| Gross margin as a percent of net sales | 4% | 6% | 5% | 6% | ||||||||||
| Gross margin per sales tonne | $19 | $29 | $20 | $27 |
First 8 of 16 rows. The download has all of them.
Table 20 after “Other Income Statement Items”
| Three months ended | Six months ended | ||||||||||||
| June 30, | 2015-2014 | June 30, | 2015-2014 | ||||||||||
| (in millions) | 2015 | 2014 | Change | Percent | 2015 | 2014 | Change | Percent | |||||
| Selling, general and administrative expenses | $89.3 | $87.5 | $1.8 | 2% | $189.8 | $207.4 | $(17.6) | (8)% | |||||
| Other operating expense | 8.6 | 30.4 | (21.8) | (72)% | 8.8 | 55.6 | (46.8) | (84)% | |||||
| Loss in value of share repurchase agreement | — | (5.5) | 5.5 | NM | — | (65.5) | 65.5 | NM | |||||
| Interest (expense) | (31.8) | (30.6) | (1.2) | 4% | (66.6) | (61.7) | (4.9) | 8% | |||||
| Interest income | 8.3 | 6.0 | 2.3 | 38% | 11.8 | 10.4 | 1.4 | 13% |
First 8 of 12 rows. The download has all of them.
Table 21 after “Provision for (Benefit from) Income Taxes”
| Three months ended | Effective Tax Rate | Provision for Income Taxes | |
| June 30, 2015 | 15.7% | $72.6 | |
| June 30, 2014 | 24.8% | 82.7 | |
| Six months ended | Effective Tax Rate | Provision for Income Taxes | |
| June 30, 2015 | 13.1% | $103.3 | |
| June 30, 2014 | 14.5% | 80.1 |
Table 22 after “:”
| (in millions) | Six months ended | ||||||
| June 30, | 2015-2014 | ||||||
| Cash Flow | 2015 | 2014 | Change | Percent | |||
| Net cash provided by operating activities | $1,238.6 | $1,423.3 | $(184.7) | (13)% | |||
| Net cash used in investing activities | (526.3) | (1,994.6) | 1,468.3 | (74)% | |||
| Net cash used in financing activities | (804.2) | (2,344.8) | 1,540.6 | (66)% |
Table 23 after “, respectively. The table below provides information about Mosaic’s significant foreign exchange derivatives.”
| (in millions US$) | As of June 30, 2015 | As of December 31, 2014 | ||||||
| Expected Maturity Date | Fair Value | Expected Maturity Date | Fair Value | |||||
| Years ending December 31, | Year ending December 31, | |||||||
| 2015 | 2016 | 2015 | 2016 | |||||
| Foreign Currency Exchange Forwards | ||||||||
| Canadian Dollar | $(39.1) | $(36.6) | ||||||
| Notional (million US$) - long Canadian Dollars | $469.1 | $230.8 | $732.9 | $66.5 | ||||
| Weighted Average Rate - Canadian dollar to U.S. dollar | 1.1660 | 1.2132 | 1.1120 | 1.1286 |
First 8 of 18 rows. The download has all of them.
Table 24 after “The table below provides information about our natural gas derivatives which are used to manage the risk related to significant price change”
| (in millions) | As of June 30, 2015 | As of December 31, 2014 | ||||||||||
| Expected Maturity Date | Expected Maturity Date | |||||||||||
| Years ending December 31, | Years ending December 31, | |||||||||||
| 2015 | 2016 | 2017 | Fair Value | 2015 | 2016 | Fair Value | ||||||
| Natural Gas Swaps | $(11.7) | $(12.6) | ||||||||||
| Notional (million MMBtu) - long | 10.5 | 16.5 | 3.2 | 14.1 | 10.3 | |||||||
| Weighted Average Rate (US$/MMBtu) | $3.01 | $3.21 | $3.50 | $3.35 | $3.33 | |||||||
| Total Fair Value | $(11.7) | $(12.6) |
Table 25 after “(a)”
| Period | Total number of shares purchased | Average price paid per share | Total number of shares purchased as part of a publicly announced program | Maximum approximate dollar value that may be yet purchased under the program(a)(b) |
| Common Stock | ||||
| April 1, 2015 - April 30, 2015................... | — | — | — | — |
| May 1, 2015 - May 31, 2015................. | 8,333,333 | (a) | 8,333,333 | $1,000,000,000 |
| June 1, 2015 - June 30, 2015..................... | — | — | — | $1,000,000,000 |
| Total...................................... | 8,333,333 | (a) | 8,333,333 | $1,000,000,000 |
Table 26 after “Table of Contents”
| Exhibit Index | |||
| Exhibit No | Description | Incorporated Herein by Reference to | Filed with Electronic Submission |
| 31.1 | Certification Required by Rule 13a-14(a). | X | |
| 31.2 | Certification Required by Rule 13a-14(a). | X | |
| 32.1 | Certification Required by Rule 13a-14(b) and Section 1350 of Chapter 63 of Title 18 of the United States Code. | X | |
| 32.2 | Certification Required by Rule 13a-14(b) and Section 1350 of Chapter 63 of Title 18 of the United States Code. | X | |
| 95 | Mine Safety Disclosures | X | |
| 101 | Interactive Data Files | X |