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 Aug 3, 2021. 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 ↗

Table 1 after “shares of Common Stock as of July 30, 2021.”

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 download has all of them.

Table 2 after “(Unaudited)”

Three months endedSix months ended
June 30, 2021June 30, 2020June 30, 2021June 30, 2020
Net sales$2,800.7$2,044.7$5,097.8$3,842.8
Cost of goods sold2,048.41,787.73,910.63,544.4
Gross margin752.3257.01,187.2298.4
Selling, general and administrative expenses107.695.1209.3163.0
Mine closure costs158.1—158.1—
Other operating expense2.676.122.6115.8

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

Table 3 after “(Unaudited)”

Three months endedSix months ended
June 30, 2021June 30, 2020June 30, 2021June 30, 2020
Net earnings (loss) including noncontrolling interest$438.8$45.9$597.0$(158.1)
Other comprehensive income (loss), net of tax
Foreign currency translation gain (loss)297.255.3191.1(548.1)
Net actuarial gain (loss) and prior service cost1.26.05.07.8
Realized gain on interest rate swap0.50.31.00.8
Net gain (loss) on marketable securities held in trust fund3.67.9(14.2)15.9

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

Table 4 after “(Unaudited)”

June 30, 2021December 31, 2020
Assets
Current assets:
Cash and cash equivalents$1,417.6$574.0
Receivables, net, including affiliate receivables of $78.2 and $144.8, respectively930.5881.1
Inventories2,194.41,739.2
Other current assets445.1326.9
Total current assets4,987.63,521.2

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

Table 5 after “(Unaudited)”

Six months ended
June 30, 2021June 30, 2020
Cash Flows from Operating Activities:
Net (loss) earnings including noncontrolling interests$597.0$(158.1)
Adjustments to reconcile net (loss) earnings including noncontrolling interests to net cash provided by operating activities:
Depreciation, depletion and amortization412.6433.2
Deferred and other income taxes38.9(123.8)
Equity in net loss of nonconsolidated companies, net of dividends15.149.8

First 8 of 46 rows. The download has all of them.

Table 6 after “(Unaudited)”

Six months ended
June 30, 2021June 30, 2020
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$1,417.6$1,073.3
Restricted cash in other current assets10.68.5
Restricted cash in other assets9.29.8
Total cash, cash equivalents and restricted cash shown in the unaudited condensed consolidated statement of cash flows$1,437.4$1,091.6
Supplemental Disclosure of Cash Flow Information:

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

Table 7 after “(Unaudited)”

Mosaic Shareholders
SharesDollars
Common StockCommon StockCapital in Excess of Par ValueRetained EarningsAccumulated Other Comprehensive (Loss)Noncontrolling InterestsTotal Equity
Balance as of March 31, 2020379.0$3.8$847.7$9,718.7$(2,184.0)$173.7$8,559.9
Total comprehensive income (loss)———47.470.8(2.8)115.4
Vesting of restricted stock units0.1—(0.3)———(0.3)
Stock based compensation——8.0———8.0
Dividends ($0.05 per share)———(19.1)——(19.1)

First 8 of 33 rows. The download has all of them.

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

June 30, 2021December 31, 2020
Other current assets
Income and other taxes receivable$217.9$181.4
Prepaid expenses107.980.4
Other119.365.1
$445.1$326.9
Other assets
Restricted cash$10.6$12.3

First 8 of 31 rows. The download has all of them.

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

Three Months Ended June 30,Six Months Ended June 30,
2021202020212020
Net income (loss) attributable to Mosaic$437.2$47.4$593.9$(155.6)
Basic weighted average number of shares outstanding379.8379.1379.5378.9
Dilutive impact of share-based awards3.52.23.5—
Diluted weighted average number of shares outstanding383.3381.3383.0378.9
Basic net income (loss) per share attributable to Mosaic$1.15$0.13$1.56$(0.41)
Diluted net income (loss) per share attributable to Mosaic$1.14$0.12$1.55$(0.41)

Table 10 after “Inventories consist of the following:”

June 30, 2021December 31, 2020
Raw materials$193.0$92.1
Work in process698.8634.5
Finished goods1,136.7868.2
Final price deferred(a)23.923.0
Operating materials and supplies142.0121.4
$2,194.4$1,739.2

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

PotashMosaic FertilizantesCorporate, Eliminations and OtherTotal
Balance as of December 31, 2020$1,063.2$97.7$12.1$1,173.0
Foreign currency translation27.31.0—28.3
Balance as of June 30, 2021$1,090.5$98.7$12.1$1,201.3

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

June 30, 2021
Amortized CostGross Unrealized GainsGross Unrealized LossesFair Value
Level 1
Cash and cash equivalents$7.9$—$—$7.9
Level 2
Corporate debt securities198.69.2(0.2)207.6
Municipal bonds197.28.1(0.4)204.9
U.S. government bonds302.20.5(4.5)298.2

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

Table 13 after “:”

June 30, 2021December 31, 2020
(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$23.5$(0.2)$1.5$—
Municipal bonds25.0(0.3)16.0(0.2)
U.S. government bonds265.0(4.5)120.3(0.1)
$313.5$(5.0)$137.8$(0.3)
Securities that have been in a continuous loss position for more than 12 months:

First 8 of 12 rows. The download 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 ”

June 30, 2021
Due in one year or less$30.1
Due after one year through five years308.6
Due after five years through ten years331.3
Due after ten years40.7
Total debt securities$710.7

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

(in millions)June 30, 2021December 31, 2020
AROs, beginning of period$1,393.9$1,315.2
Liabilities incurred9.510.8
Liabilities settled(78.7)(125.1)
Accretion expense35.168.0
Revisions in estimated cash flows50.4167.3
Foreign currency translation9.2(42.3)
AROs, end of period1,419.41,393.9

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

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

(in millions of Units)June 30, 2021December 31, 2020
Derivative InstrumentDerivative CategoryUnit of Measure
Foreign currency derivativesForeign currencyUS Dollars3,264.52,912.3
Natural gas derivativesCommodityMMbtu29.127.3

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

June 30, 2021December 31, 2020
Carrying AmountFair ValueCarrying AmountFair Value
Cash and cash equivalents$1,417.6$1,417.6$574.0$574.0
Accounts receivable930.5930.5881.1881.1
Accounts payable924.8924.8769.1769.1
Structured accounts payable arrangements830.7830.7640.0640.0
Short-term debt0.10.10.10.1
Long-term debt, including current portion4,462.85,033.24,578.05,172.1

Table 18 after “The following table sets forth the changes in AOCI, net of tax, by component during the three and six months ended June 30, 2021 and June 30”

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 June 30, 2021
Balance at March 31, 2021$(1,822.9)$(105.9)$4.2$1.1$(1,923.5)
Other comprehensive income (loss)287.91.30.53.6293.3
Tax (expense) benefit9.3(0.1)——9.2
Other comprehensive income (loss), net of tax297.21.20.53.6302.5
Other comprehensive income (loss) attributable to noncontrolling interest(3.3)———(3.3)
Balance as of June 30, 2021$(1,529.0)$(104.7)$4.7$4.7$(1,624.3)

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

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

Three Months Ended June 30,Six Months Ended June 30,
2021202020212020
Transactions with related parties included in net sales$196.4$222.5$353.8$371.1
Transactions with related parties included in cost of goods sold239.6218.4489.4395.5

Table 20 after “25”

PhosphatesPotashMosaic FertilizantesCorporate, Eliminations and Other (a)Total
Three months ended June 30, 2021
Net sales to external customers$910.2$659.1$1,035.7$195.7$2,800.7
Intersegment net sales264.63.9—(268.5)—
Net sales1,174.8663.01,035.7(72.8)2,800.7
Gross margin308.5217.2185.141.5752.3
Canadian resource taxes—54.2——54.2
Gross margin (excluding Canadian resource taxes)308.5271.4185.141.5806.5

First 8 of 46 rows. The download has all of them.

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

Three Months Ended June 30,Six Months Ended June 30,
(in millions)2021202020212020
Net sales(a):
Brazil$1,014.4$757.0$1,782.2$1,469.7
Canada228.4137.4418.8254.7
Canpotex(b)187.3215.8337.5362.2
China116.574.5242.2113.9
Colombia38.625.866.440.0

First 8 of 22 rows. The download has all of them.

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

Three Months Ended June 30,Six Months Ended June 30,
(in millions)2021202020212020
Sales by product type:
Phosphate Crop Nutrients$835.8$559.6$1,502.4$1,106.8
Potash Crop Nutrients804.8658.01,362.31,129.0
Crop Nutrient Blends333.9252.0648.6539.3
Performance Products(a)455.4341.2854.8552.9
Phosphate Rock18.47.535.314.0

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

Table 23 after “The following table shows the results of operations for the three and six months ended June 30, 2021 and June 30, 2020:”

Three months endedSix months ended
June 30,2021-2020June 30,2021-2020
(in millions, except per share data)20212020ChangePercent20212020ChangePercent
Net sales$2,800.7$2,044.7$756.037%$5,097.8$3,842.8$1,255.033%
Cost of goods sold2,048.41,787.7260.715%3,910.63,544.4366.210%
Gross margin752.3257.0495.3193%1,187.2298.4888.8NM
Gross margin percentage27%13%23%8%
Selling, general and administrative expenses107.695.112.513%209.3163.046.328%

First 8 of 23 rows. The download 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:”

Three months endedSix months ended
June 30,2021-2020June 30,2021-2020
(in millions, except price per tonne or unit)20212020ChangePercent20212020ChangePercent
Net sales:
North America$746.5$383.0$363.595%$1,472.2$764.7$707.593%
International428.3379.448.913%703.6617.186.514%
Total1,174.8762.4412.454%2,175.81,381.8794.057%
Cost of goods sold866.3744.7121.616%1,694.71,447.0247.717%

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

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

Three months endedSix months ended
June 30,2021-2020June 30,2021-2020
(in millions, except price per tonne or unit)20212020ChangePercent20212020ChangePercent
Net sales:
North America$456.6$315.2$141.445%$770.4$597.7$172.729%
International206.4240.2(33.8)(14)%370.0399.3(29.3)(7)%
Total663.0555.4107.619%1,140.4997.0143.414%
Cost of goods sold445.8423.822.05%783.0756.326.74%

First 8 of 18 rows. The download 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.”

Three months endedSix months ended
June 30,2021-2020June 30,2021-2020
(in millions, except price per tonne or unit)20212020ChangePercent20212020ChangePercent
Net Sales$1,035.7$787.0$248.832%$1,799.2$1,518.1$281.119%
Cost of goods sold850.7686.3164.424%1,511.01,350.9160.112%
Gross margin$185.1$100.7$84.484%$288.2$167.2$121.072%
Gross margin as a percent of net sales18%13%16%11%
Sales volume (in thousands of metric tonnes)

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

Table 27 after “Other Income Statement Items”

Three months endedSix months ended
June 30,2021-2020June 30,2021-2020
(in millions)20212020ChangePercent20212020ChangePercent
Selling, general and administrative expenses$107.6$95.1$12.513%$209.3$163.0$46.328%
Mine closure costs158.1—158.1NM158.1—158.1NM
Other operating expense2.676.1(73.5)(97)%22.6115.8(93.2)(80)%
Interest expense(43.8)(57.0)13.2(23)%(93.2)(107.8)14.6(14)%
Interest income6.57.7(1.2)(16)%10.917.4(6.5)(37)%

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

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

Three months endedEffective Tax RateProvision for (Benefit from) Income Taxes
June 30, 202120.7%$115.9
June 30, 2020(3.7)%$(2.7)
Six months endedEffective Tax RateProvision for (Benefit from) Income Taxes
June 30, 202122.4%$175.6
June 30, 202055.6%$(135.7)

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

(in millions)Six months ended
June 30, 20212021-2020
Cash Flow20212020ChangePercent
Net cash provided by operating activities$1,333.9$1,003.6$330.333%
Net cash used in investing activities(579.6)(527.6)(52.0)10%
Net cash provided by financing activities39.6167.6(128.0)(76)

Table 30 after “48”

(in millions US$)As of June 30, 2021As of December 31, 2020
Expected Maturity DateFair ValueExpected Maturity DateFair Value
Years ending December 31,Years ending December 31,
2021202220232024202120222023
Foreign Currency Exchange Forwards
Canadian Dollar$31.3$31.9
Notional (million US$) - short Canadian dollars$181.8$111.2$32.8$—$170.0$48.4$6.0
Weighted Average Rate - Canadian dollar to U.S. dollar1.25701.27221.2509—1.30891.32851.3304

First 8 of 25 rows. The download 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”

(in millions)As of June 30, 2021As of December 31, 2020
Expected Maturity DateExpected Maturity Date
Years ending December 31,Years ending December 31,
2021202220232024Fair Value2021202220232024Fair Value
Natural Gas Swaps$20.3$5.3
Notional (million MMBtu) - long7.89.99.42.017.78.51.2—
Weighted Average Rate (US$/MMBtu)$1.92$2.25$2.36$2.44$1.93$2.16$2.88$—
Total Fair Value$20.3$5.3

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

Exhibit Index
Exhibit NoDescriptionIncorporated Herein by Reference toFiled with Electronic Submission
10.iii.aSummary of Board of Director Compensation of MosaicX
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

First 8 of 15 rows. The download has all of them.