tickdelta
Sign in

Tickdelta is free for now. Sign up and get Pro free

← Filings of MOS

Tables in the 10-Q of MOSAIC CO

32 tables with numbers, filed Nov 3, 2020. Each one downloads as a CSV for Excel or Google Sheets, 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 ↗

Table 1 after “shares of Common Stock as of November 1, 2020.”

Download CSV
Table of Contents
PART I.FINANCIAL INFORMATION
Item 1.Financial Statements1
Condensed Consolidated Statements of Earnings (Loss)1
Condensed Consolidated Statements of Comprehensive Income (Loss)2
Condensed Consolidated Balance Sheets3
Condensed Consolidated Statements of Cash Flows4
Condensed Consolidated Statements of Equity6

First 8 of 19 rows. The CSV has all of them.

Table 2 after “(Unaudited)”

Download CSV
Three months endedNine months ended
September 30, 2020September 30, 2019September 30, 2020September 30, 2019
Net sales$2,381.5$2,753.4$6,224.3$6,830.0
Cost of goods sold2,026.42,473.55,570.86,013.4
Gross margin355.1279.9653.5816.6
Selling, general and administrative expenses97.678.2260.6249.8
Impairment, restructuring and other expenses (benefit)—(15.6)—353.8
Other operating expense159.077.8274.8113.3

First 8 of 23 rows. The CSV has all of them.

Table 3 after “(Unaudited)”

Download CSV
Three months endedNine months ended
September 30, 2020September 30, 2019September 30, 2020September 30, 2019
Net earnings (loss) including noncontrolling interest$(4.6)$(40.0)$(162.7)$(140.4)
Other comprehensive income (loss), net of tax
Foreign currency translation gain (loss)59.7(186.6)(488.4)(27.6)
Net actuarial gain (loss) and prior service cost0.92.58.70.2
Realized gain on interest rate swap0.40.51.21.6
Net gain (loss) on marketable securities held in trust fund(2.3)(6.4)13.615.3

First 8 of 12 rows. The CSV has all of them.

Table 4 after “(Unaudited)”

Download CSV
September 30, 2020December 31, 2019
Assets
Current assets:
Cash and cash equivalents$923.0$519.1
Receivables, net, including affiliate receivables of $137.1 and $51.2, respectively794.6803.9
Inventories1,681.32,076.4
Other current assets349.9318.8
Total current assets3,748.83,718.2

First 8 of 35 rows. The CSV has all of them.

Table 5 after “(Unaudited)”

Download CSV
Nine months ended
September 30, 2020September 30, 2019
Cash Flows from Operating Activities:
Net (loss) earnings including noncontrolling interests$(162.7)$(140.4)
Adjustments to reconcile net (loss) earnings including noncontrolling interests to net cash provided by operating activities:
Depreciation, depletion and amortization639.1649.6
Deferred and other income taxes(150.6)(2.9)
Equity in net loss of nonconsolidated companies, net of dividends82.239.4

First 8 of 47 rows. The CSV has all of them.

Table 6 after “(Unaudited)”

Download CSV
Nine months ended
September 30, 2020September 30, 2019
Reconciliation of cash, cash equivalents and restricted cash reported within the unaudited condensed consolidated balance sheets to the unaudited condensed consolidated statements of cash flows:
Cash and cash equivalents$923.0$641.1
Restricted cash in other current assets8.28.6
Restricted cash in other assets13.98.8
Total cash, cash equivalents and restricted cash shown in the unaudited condensed consolidated statement of cash flows$945.1$658.5
Supplemental Disclosure of Cash Flow Information:

First 8 of 11 rows. The CSV has all of them.

Table 7 after “(Unaudited)”

Download CSV
Mosaic Shareholders
SharesDollars
Common StockCommon StockCapital in Excess of Par ValueRetained EarningsAccumulated Other Comprehensive (Loss)Noncontrolling InterestsTotal Equity
Balance as of June 30, 2019385.9$3.8$1,002.9$10,944.2$(1,477.9)$209.3$10,682.3
Total comprehensive income (loss)———(44.1)(187.5)1.6(230.0)
Stock based compensation——2.9———2.9
Share Repurchase(5.8)—(124.5)———(124.5)
Dividends ($0.05 per share)———(19.4)——(19.4)

First 8 of 32 rows. The CSV has all of them.

Table 8 after “tional information concerning selected balance sheet accounts:”

Download CSV
September 30, 2020December 31, 2019
Other current assets
Income and other taxes receivable$145.1$179.5
Prepaid expenses149.0110.7
Other55.828.6
$349.9$318.8
Other assets
Restricted cash$13.9$5.4

First 8 of 30 rows. The CSV has all of them.

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

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Net (loss) attributable to Mosaic$(6.2)$(44.1)$(161.8)$(146.4)
Basic weighted average number of shares outstanding379.1385.0379.0385.5
Dilutive impact of share-based awards————
Diluted weighted average number of shares outstanding379.1385.0379.0385.5
Basic net (loss) per share attributable to Mosaic$(0.02)$(0.11)$(0.43)$(0.38)
Diluted net (loss) per share attributable to Mosaic$(0.02)$(0.11)$(0.43)$(0.38)

Table 10 after “Inventories consist of the following:”

Download CSV
September 30, 2020December 31, 2019
Raw materials$83.0$68.3
Work in process594.9618.4
Finished goods829.51,219.3
Final price deferred(a)56.147.9
Operating materials and supplies117.8122.5
$1,681.3$2,076.4

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

Download CSV
PotashMosaic FertilizantesCorporate, Eliminations and OtherTotal
Balance as of December 31, 2019$1,039.8$105.0$12.1$1,156.9
Foreign currency translation(22.6)(9.3)—(31.9)
Balance as of September 30, 2020$1,017.2$95.7$12.1$1,125.0

Table 12 after “The estimated fair value of the investments in the RCRA Trusts as of September 30, 2020 and December 31, 2019 are as follows:”

Download CSV
September 30, 2020
Amortized CostGross Unrealized GainsGross Unrealized LossesFair Value
Level 1
Cash and cash equivalents$8.6$—$—$8.6
Level 2
Corporate debt securities191.213.1(0.2)204.1
Municipal bonds191.57.9(0.6)198.8
U.S. government bonds299.47.4—306.8

First 8 of 18 rows. The CSV has all of them.

Table 13 after “:”

Download CSV
September 30, 2020December 31, 2019
(in millions)Fair ValueGross Unrealized LossesFair ValueGross Unrealized Losses
Securities that have been in a continuous loss position for less than 12 months:
Corporate debt securities$9.2$(0.2)$17.9$—
Municipal bonds25.6—11.7(0.1)
U.S. government bonds5.2(0.5)195.4(2.5)
$40.0$(0.7)$225.0$(2.6)
Securities that have been in a continuous loss position for more than 12 months:

First 8 of 12 rows. The CSV has all of them.

Table 14 after “The following table summarizes the balance by contractual maturity of the available-for-sale debt securities invested by the RCRA Trusts as ”

Download CSV
September 30, 2020
Due in one year or less$28.8
Due after one year through five years333.5
Due after five years through ten years302.8
Due after ten years44.6
Total debt securities$709.7

Table 15 after “A reconciliation of our AROs is as follows:”

Download CSV
(in millions)September 30, 2020December 31, 2019
AROs, beginning of period$1,315.2$1,160.1
Liabilities incurred8.815.8
Liabilities settled(87.0)(112.8)
Accretion expense50.762.4
Revisions in estimated cash flows141.4191.0
Foreign currency translation(59.9)(1.3)
AROs, end of period1,369.21,315.2

First 8 of 10 rows. The CSV has all of them.

Table 16 after “As of September 30, 2020 and December 31, 2019, the following is the total absolute notional volume associated with our outstanding derivati”

Download CSV
(in millions of Units)September 30, 2020December 31, 2019
Derivative InstrumentDerivative CategoryUnit of Measure
Foreign currency derivativesForeign currencyUS Dollars2,705.71,923.3
Interest rate derivativesInterest rateUS Dollars—585.0
Natural gas derivativesCommodityMMbtu27.844.1

Table 17 after “18”

Download CSV
September 30, 2020December 31, 2019
Carrying AmountFair ValueCarrying AmountFair Value
Cash and cash equivalents$923.0$923.0$519.1$519.1
Accounts receivable794.6794.6803.9803.9
Accounts payable736.7736.7680.4680.4
Structured accounts payable arrangements626.5626.5740.6740.6
Short-term debt215.5215.541.641.6
Long-term debt, including current portion4,577.85,007.94,572.74,920.9

Table 18 after “The following table sets forth the changes in AOCI, net of tax, by component during the three and nine months ended September 30, 2020 and S”

Download CSV
Foreign Currency Translation Gain (Loss)Net Actuarial Gain and Prior Service CostAmortization of Gain on Interest Rate SwapNet Gain (Loss) on Marketable Securities Held in TrustTotal
Three Months Ended September 30, 2020
Balance as of June 30, 2020$(2,016.3)$(121.8)$2.9$22.0$(2,113.2)
Other comprehensive income (loss)50.52.70.5(3.1)50.6
Tax (expense) benefit9.2(1.8)(0.1)0.88.1
Other comprehensive income (loss), net of tax59.70.90.4(2.3)58.7
Other comprehensive income (loss) attributable to noncontrolling interest0.7———0.7
Balance as of September 30, 2020$(1,955.9)$(120.9)$3.3$19.7$(2,053.8)

First 8 of 29 rows. The CSV has all of them.

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

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
2020201920202019
Transactions with non-consolidated companies included in net sales$200.4$273.6$571.5$825.4
Transactions with non-consolidated companies included in cost of goods sold224.2396.7619.7947.5

Table 20 after “Segment information for the three and nine months ended September 30, 2020 and 2019 was as follows:”

Download CSV
PhosphatesPotashMosaic FertilizantesCorporate, Eliminations and Other (a)Total
Three months ended September 30, 2020
Net sales to external customers$586.2$452.2$1,140.5$202.6$2,381.5
Intersegment net sales158.311.6—(169.9)—
Net sales744.5463.81,140.532.72,381.5
Gross margin21.8107.6176.948.8355.1
Canadian resource taxes—26.1——26.1
Gross margin (excluding Canadian resource taxes)21.8133.7176.948.8381.2

First 8 of 44 rows. The CSV has all of them.

Table 21 after “Financial information relating to our operations by geographic area is as follows:”

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
(in millions)2020201920202019
Net sales(a):
Brazil$1,109.7$1,347.3$2,579.4$2,831.0
Canpotex(b)192.8272.1555.0811.4
Canada122.2157.0376.9435.3
India104.085.2242.0185.3
China96.848.8210.7172.7

First 8 of 21 rows. The CSV has all of them.

Table 22 after “Net sales by product type are as follows:”

Download CSV
Three Months Ended September 30,Nine Months Ended September 30,
(in millions)2020201920202019
Sales by product type:
Phosphate Crop Nutrients$677.0$736.7$1,783.8$1,904.6
Potash Crop Nutrients727.3891.91,856.32,175.9
Crop Nutrient Blends376.5509.0915.81,089.8
Performance Products(a)361.3356.9914.2895.1
Phosphate Rock14.514.128.533.5

First 8 of 10 rows. The CSV has all of them.

Table 23 after “The following table shows the results of operations for the three and nine months ended September 30, 2020 and September 30, 2019:”

Download CSV
Three months endedNine months ended
September 30,2020-2019September 30,2020-2019
(in millions, except per share data)20202019ChangePercent20202019ChangePercent
Net sales$2,381.5$2,753.4$(371.9)(14)%$6,224.3$6,830.0$(605.7)(9)%
Cost of goods sold2,026.42,473.5(447.1)(18)%5,570.86,013.4(442.6)(7)%
Gross margin355.1279.975.227%653.5816.6(163.1)(20)%
Gross margin percentage15%10%10%12%
Selling, general and administrative expenses97.678.219.425%260.6249.810.84%

First 8 of 23 rows. The CSV has all of them.

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

Download CSV
Three months endedNine months ended
September 30,2020-2019September 30,2020-2019
(in millions, except price per tonne or unit)20202019ChangePercent20202019ChangePercent
Net sales:
North America$439.9$484.1$(44.2)(9)%$1,204.6$1,326.6$(122.0)(9)%
International304.6335.8(31.2)(9)%921.71,216.7(295.0)(24)%
Total744.5819.9(75.4)(9)%2,126.32,543.3(417.0)(16)%
Cost of goods sold722.7839.2(116.5)(14)%2,169.72,519.6(349.9)(14)%

First 8 of 24 rows. The CSV has all of them.

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

Download CSV
Three months endedNine months ended
September 30,2020-2019September 30,2020-2019
(in millions, except price per tonne or unit)20202019ChangePercent20202019ChangePercent
Net sales:
North America$251.7$327.7$(76.0)(23)%$849.4$859.3$(9.9)(1)%
International212.0288.7(76.7)(27)%611.3859.7(248.4)(29)%
Total463.7616.4(152.7)(25)%1,460.71,719.0(258.3)(15)%
Cost of goods sold356.1458.1(102.0)(22)%1,112.41,194.2(81.8)(7)%

First 8 of 18 rows. The CSV has all of them.

Table 26 after “The following table summarizes the Mosaic Fertilizantes segment’s net sales, gross margin, sales volume and selling price.”

Download CSV
Three months endedNine months ended
September 30,2020-2019September 30,2020-2019
(in millions, except price per tonne or unit)20202019ChangePercent20202019ChangePercent
Net Sales$1,140.5$1,388.3$(247.8)(18)%$2,658.6$2,919.0$(260.4)(9)%
Cost of goods sold963.61,256.2(292.6)(23)%2,314.52,699.3(384.8)(14)%
Gross margin$176.9$132.1$44.834%$344.1$219.7$124.457%
Gross margin as a percent of net sales16%10%13%8%
Sales volume (in thousands of metric tonnes)

First 8 of 24 rows. The CSV has all of them.

Table 27 after “Other Income Statement Items”

Download CSV
Three months endedNine months ended
September 30,2020-2019September 30,2020-2019
(in millions)20202019ChangePercent20202019ChangePercent
Selling, general and administrative expenses$97.6$78.2$19.425%$260.6$249.8$10.84%
Impairment, restructuring and other expenses (benefit)—(15.6)15.6(100)%—353.8(353.8)NM
Other operating expense159.077.881.2104%274.8113.3161.5143%
Interest expense(50.8)(53.1)2.3(4)%(158.6)(161.1)2.5(2)%
Interest income7.89.9(2.1)(21)%25.224.90.31%

First 8 of 13 rows. The CSV has all of them.

Table 28 after “Provision for (Benefit from) Income Taxes”

Download CSV
Three months endedEffective Tax RateProvision for (Benefit from) Income Taxes
September 30, 202057.7%$38.1
September 30, 2019132.6%$69.2
Nine months endedEffective Tax RateProvision for (Benefit from) Income Taxes
September 30, 202054.8%$(97.6)
September 30, 2019(152.6)%$64.1

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

Download CSV
(in millions)Nine months ended
September 30, 20202020-2019
Cash Flow20202019ChangePercent
Net cash provided by operating activities$1,344.2$817.8$526.464%
Net cash used in investing activities(794.7)(1,014.1)219.4(22)%
Net cash used in financing activities(50.9)(16.3)(34.6)NM

Table 30 after “As of September 30, 2020, and December 31, 2019, the fair value of our major foreign currency exchange contracts was ($32.7) million and $(7”

Download CSV
(in millions US$)As of September 30, 2020As of December 31, 2019
Expected Maturity DateFair ValueExpected Maturity DateFair Value
Years ending December 31,Years ending December 31,
2020202120222023202020212022
Foreign Currency Exchange Forwards
Canadian Dollar$(2.0)$7.6
Notional (million US$) - short Canadian dollars$39.9$68.5$48.4$6.0$72.3$—$—
Weighted Average Rate - Canadian dollar to U.S. dollar1.37841.33491.32851.33041.3137——

First 8 of 25 rows. The CSV has all of them.

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

Download CSV
(in millions)As of September 30, 2020As of December 31, 2019
Expected Maturity DateExpected Maturity Date
Years ending December 31,Years ending December 31,
2020202120222023Fair Value2020202120222023Fair Value
Natural Gas Swaps$13.8$(4.0)
Notional (million MMBtu) - long4.318.54.9—20.618.54.9—
Weighted Average Rate (US$/MMBtu)$1.89$1.97$1.80$—$1.92$1.98$1.83$—
Total Fair Value$13.8$(4.0)

Table 32 after “The following Exhibits are being filed herewith.”

Download CSV
Exhibit Index
Exhibit NoDescriptionIncorporated Herein by Reference toFiled with Electronic Submission
31.1Certification Required by Rule 13a-14(a).X
31.2Certification Required by Rule 13a-14(a).X
32.1Certification Required by Rule 13a-14(b) and Section 1350 of Chapter 63 of Title 18 of the United States Code.X
32.2Certification Required by Rule 13a-14(b) and Section 1350 of Chapter 63 of Title 18 of the United States Code.X
95Mine Safety DisclosuresX
101.INSInline XBRL Instance Document (the instance document does not appear in the Interactive Data File because its XBRL tags are embedded within the Inline XBRL document)X

First 8 of 14 rows. The CSV has all of them.