← Filings of MOS

Tables in the 10-Q of MOSAIC CO

26 tables with numbers, filed Jul 31, 2014. 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 ↗

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
		Notes to Condensed Consolidated Financial Statements	6

	Three months ended June 30,		Six months ended June 30,
	2014		2013		2014	2013
Net sales	$2,440.2		$2,618.7		$4,426.5	$4,931.2
Cost of goods sold		1,919.1		1,953.4		3,493.7	3,624.2
Gross margin		521.1		665.3		932.8	1,307.0
Selling, general and administrative expenses		87.5		116.1		207.4	207.9
Other operating expense		30.4		23.5		55.6	82.3
Operating earnings		403.2		525.7		669.8	1,016.8

	June 30, 2014		December 31, 2013
Assets
Current assets:
Cash and cash equivalents	$2,367.0		$5,293.1
Receivables, net		604.2		543.1
Inventories		1,579.6		1,432.9
Deferred income taxes		161.0		129.9
Other current assets		476.6		706.8

	Six months ended
	June 30, 2014		June 30, 2013
Cash Flows from Operating Activities:
Net earnings including noncontrolling interests	$465.9		$809.9
Adjustments to reconcile net earnings including noncontrolling interests to net cash provided by operating activities:
Depreciation, depletion and amortization		368.7		322.7
Deferred income taxes		(92.0)		205.3
Equity in net loss of nonconsolidated companies, net of dividends		7.0		29.3

			Mosaic Shareholders
	Shares		Dollars
	Common Stock		Common Stock			Capital in Excess of Par Value		Retained Earnings		Accumulated Other Comprehensive Income		Noncontrolling Interests			Total Equity
Balance as of May 31, 2013		425.8		$4.3			$1,491.3		$11,603.4		$326.4		$17.5			$13,442.9
Total comprehensive income (loss)		—			—			—			340.0			(212.1)			1.2	129.1
Stock option exercises		0.1			—			1.1			—			—			—	1.1
Amortization of stock based compensation		—			—			23.3			—			—			—	23.3
Forward contract to repurchase Class A Common Stock		—			—			(1,511.3)			(547.8)			—			—	(2,059.1)

(in millions)	June 30, 2014		December 31, 2013
Other current assets
Final price deferred(a)	$51.4		$154.3
Income and other taxes receivable		144.8		272.6
Prepaid expenses		118.6		115.8
Assets held for sale(b)		91.3		111.9
Other		70.5		52.2
	$476.6		$706.8

	June 30, 2014		December 31, 2013
Raw materials	$42.1		$34.0
Work in process		536.3		433.6
Finished goods		921.6		891.6
Operating materials and supplies		79.6		73.7
	$1,579.6		$1,432.9

	Phosphates		Potash		Total
Balance as of December 31, 2013	$535.8		$1,258.6		$1,794.4
Foreign currency translation		—		(1.8)		(1.8)
Reallocation of goodwill to assets held for sale		5.1		(4.8)		0.3
Balance as of June 30, 2014	$540.9		$1,252.0		$1,792.9

(in millions of Units) Derivative Instrument	Derivative Category	Unit of Measure	June 30, 2014		December 31, 2013
Foreign currency derivatives	Foreign currency	US Dollars		1,237.2		940.2
Natural gas derivatives	Commodity	MMbtu		3.1		8.2
Ocean freight contracts	Freight	Tonnes		0.2		0.3

	June 30, 2014		December 31, 2013
	Carrying Amount		Fair Value		Carrying Amount	Fair Value
Cash and cash equivalents	$2,367.0		$2,367.0		$5,293.1	$5,293.1
Receivables, net		604.2		604.2		543.1	543.1
Accounts payable		750.2		750.2		570.2	570.2
Short-term debt		12.7		12.7		22.6	22.6
Long-term debt, including current portion		3,013.5		3,284.3		3,009.3	3,059.6

	Three months ended June 30,		Six months ended June 30,
	2014		2013		2014	2013
Net earnings attributed to Mosaic	$248.4		$429.8		$466.0	$809.6
Undistributed earnings attributable to participating securities		(6.3)		—		(19.5)	—
Numerator for basic and diluted earnings available to common stockholders	$242.1		$429.8		$446.5	$809.6
Basic weighted average number of shares outstanding		384.0		425.8		392.5	425.8
Shares subject to forward contract		(9.8)		—		(16.4)	—
Basic weighted average number of shares outstanding attributable to common stockholders		374.2		425.8		376.1	425.8

(in millions)
Inventory	$144.1
Other current assets		0.5
Mineral properties and rights		499.7
Property, plant and equipment		627.1
Funds for asset retirement obligations(1)		203.7
Other assets		56.8
Current liabilities		(1.5)

	Three months ended June 30,		2014-2013		Six months ended June 30,	2014-2013
(in millions, except price per tonne or unit)	2014		2013		Change	Percent		2014		2013			Change		Percent
Net sales:
North America	$724.4		$589.1		$135.3		23%		$1,282.9		$1,138.0			$144.9		13%
International		947.1		1,056.6		(109.5)			(10)%			1,642.2			2,008.5		(366.3)	(18)%
Total		1,671.5		1,645.7		25.8			2%			2,925.1			3,146.5		(221.4)	(7)%
Cost of goods sold		1,388.0		1,366.3		21.7			2%			2,434.3			2,614.1		(179.8)	(7)%
Gross margin	$283.5		$279.4		$4.1		1%		$490.8		$532.4			$(41.6)		(8)%

	Three months ended June 30,		2014-2013		Six months ended June 30,	2014-2013
(in millions, except price per tonne or unit)	2014		2013		Change	Percent		2014		2013			Change		Percent
Net sales:
North America	$446.7		$480.5		$(33.8)		(7)%		$961.2		$920.9			$40.3		4%
International		315.6		493.4		(177.8)			(36)%			534.3			877.6		(343.3)	(39)%
Total		762.3		973.9		(211.6)			(22)%			1,495.5			1,798.5		(303.0)	(17)%
Cost of goods sold		511.8		585.0		(73.2)			(13)%			1,032.9			1,012.6		20.3	2%
Gross margin	$250.5		$388.9		$(138.4)		(36)%		$462.6		$785.9			$(323.3)		(41)%

	Phosphates		Potash		Corporate, Eliminations and Other	Total
Three months ended June 30, 2014
Net sales to external customers	$1,671.5		$760.2		$8.5	$2,440.2
Intersegment net sales		—		2.1		(2.1)	—
Net sales		1,671.5		762.3		6.4	2,440.2
Gross margin		283.5		250.5		(12.9)	521.1
Operating earnings		206.2		212.9		(15.9)	403.2
Capital expenditures		115.0		93.8		5.2	214.0

Three months ended	Effective Tax Rate		Provision for Income Taxes
June 30, 2014		24.8%		$82.7
June 30, 2013		22.9%			126.3

(in millions US$)		As of June 30, 2014			As of December 31, 2013
	Expected Maturity Date			Fair Value		Expected Maturity Date		Fair Value
	Years ending December 31,				Year ending December 31,
	2014			2015			2014
Foreign Currency Exchange Forwards
Canadian Dollar
Notional (million US$)—long		$37.4			$—		$13.5		$—	$—
Weighted Average Rate—Canadian dollar to U.S. dollar			1.0697			—					—

Exhibit No	Description	Incorporated Herein by Reference to	Filed with Electronic Submission
3.i.	Certificate of Incorporation of Mosaic, as amended effective May 15, 2014			X
3.ii.	Bylaws of Mosaic, as amended effective May 15, 2014			X
10.i.	Form of Equity Support, Subordination and Retention Agreement dated June 30, 2014 by Mosaic, Saudi Arabian Mining Company, Saudi Basic Industries Corporation, Mizuho Corporate Bank, Ltd., as Intercreditor Agent for certain Finance Parties, and Riyad Bank, London Branch, as Offshore Security Trustee and Agent for certain secured parties			X
10.iii.	Form of retention agreement dated May 29, 2014 from Mosaic to an executive officer			X
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

Tables in the 10-Q of MOSAIC CO

Table 1 after “Table of Contents”

Table 2 after “(Unaudited)”

Table 3 after “(Unaudited)”

Table 4 after “(Unaudited)”

Table 5 after “(Unaudited)”

Table 6 after “(Unaudited)”

Table 7 after “The following provides additional information concerning selected balance sheet accounts:”

Table 8 after “The following is a reconciliation of the numerator and denominator for the basic and diluted EPS computations:”

Table 9 after “Inventories consist of the following:”

Table 10 after “The changes in the carrying amount of goodwill, by reporting unit, are as follows:”

Table 11 after “As of June 30, 2014 and December 31, 2013, the following is the total absolute notional volume associated with our outstanding derivative in”

Table 12 after “The carrying amounts and estimated fair values of our financial instruments are as follows:”

Table 13 after “The Condensed Consolidated Statements of Earnings included the following transactions with our non-consolidated companies:”

Table 14 after “The reportable segments are determined by management based upon factors such as products and services, production processes, technologies, m”

Table 15 after “The following table summarizes the amounts of the assets acquired and liabilities assumed as recognized with the acquisition. The fair value”

Table 16 after “The unaudited pro-forma consolidated results presented below include the effects of the acquisition as if it had been consummated as of Janu”

Table 17 after “The following table shows the results of operations for the three and six months ended June 30, 2014 and 2013:”

Table 18 after “The following table summarizes the Phosphates segment’s net sales, gross margin, sales volume, selling prices and raw material prices:”

Table 19 after “The following table summarizes the Potash segment’s net sales, gross margin, sales volume and selling price:”

Table 20 after “Other Income Statement Items”

Table 21 after “Provision for Income Taxes”

Table 22 after “Provision for Income Taxes”

Table 23 after “The following table represents a comparison of the net cash provided by operating activities, net cash used in investing activities, and net”

Table 24 after “As of June 30, 2014 and December 31, 2013, the fair value of our major foreign currency exchange contracts was $11.9 million and ($17.4) mil”

Table 25 after “The table below provides information about our natural gas derivatives which are used to manage the risk related to significant price change”

Table 26 after “Exhibit Index”