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

33 tables with numbers, filed Aug 7, 2024. 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 August 2, 2024.”

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

Table 2 after “(Unaudited)”

Three months endedSix months ended
June 30, 2024June 30, 2023June 30, 2024June 30, 2023
Net sales$2,816.6$3,394.0$5,496.0$6,998.3
Cost of goods sold2,422.62,822.94,702.85,756.8
Gross margin394.0571.1793.21,241.5
Selling, general and administrative expenses128.4129.9235.2257.6
Other operating expense32.372.0151.870.1
Operating earnings233.3369.2406.2913.8

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

Table 3 after “(Unaudited)”

Three months endedSix months ended
June 30, 2024June 30, 2023June 30, 2024June 30, 2023
Net (loss) earnings including noncontrolling interest$(150.9)$379.1$(94.4)$838.1
Other comprehensive income (loss), net of tax
Foreign currency translation (loss) gain(136.5)146.0(266.2)175.4
Net actuarial gain and prior service cost0.60.31.40.7
Realized gain on interest rate swap—0.4—0.9
Net (loss) gain on marketable securities held in trust fund(2.6)(10.6)(12.9)6.0

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

Table 4 after “(Unaudited)”

June 30, 2024December 31, 2023
Assets
Current assets:
Cash and cash equivalents$322.0$348.8
Receivables, net, including affiliate receivables of $120.2 and $240.1, respectively1,285.51,269.2
Inventories2,554.02,523.2
Other current assets597.6603.8
Total current assets4,759.14,745.0

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

Table 5 after “(Unaudited)”

Six months ended
June 30, 2024June 30, 2023
Cash Flows from Operating Activities:
Net earnings (loss) including noncontrolling interests$(94.4)$838.1
Adjustments to reconcile net earnings including noncontrolling interests to net cash provided by operating activities:
Depreciation, depletion and amortization505.5464.2
Deferred and other income taxes39.83.7
Equity in net (earnings) of nonconsolidated companies, net of dividends(44.7)(19.2)

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

Table 6 after “(Unaudited)”

Six months ended
June 30, 2024June 30, 2023
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$322.0$626.1
Restricted cash in other current assets16.59.5
Restricted cash in other assets11.85.2
Total cash, cash equivalents and restricted cash shown in the unaudited condensed consolidated statement of cash flows$350.3$640.8
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, 2023332.1$3.3$—$13,996.5$(2,106.0)$162.7$12,056.5
Total comprehensive income———369.0134.811.4515.2
Vesting of restricted stock units0.1—(0.5)———(0.5)
Stock based compensation——8.6———8.6
Dividends ($0.20 per share)———(0.7)——(0.7)

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

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

June 30, 2024December 31, 2023
Other current assets
Income and other taxes receivable$325.7$269.3
Prepaid expenses243.4284.3
Other28.550.2
$597.6$603.8
Other assets
Restricted cash$11.8$3.4

First 8 of 32 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,
2024202320242023
Net (loss) income attributable to Mosaic$(161.5)$369.0$(116.3)$803.8
Basic weighted average number of shares outstanding321.2332.2321.7333.8
Dilutive impact of share-based awards—1.5—2.4
Diluted weighted average number of shares outstanding321.2333.7321.7336.2
Basic net (loss) income per share attributable to Mosaic$(0.50)$1.11$(0.36)$2.41
Diluted net (loss) income per share attributable to Mosaic$(0.50)$1.11$(0.36)$2.39

Table 10 after “Inventories consist of the following:”

June 30, 2024December 31, 2023
Raw materials$114.6$135.8
Work in process951.5964.8
Finished goods1,267.21,178.0
Final price deferred(a)59.361.5
Operating materials and supplies161.4183.1
$2,554.0$2,523.2

Table 11 after “10”

PotashMosaic FertilizantesCorporate, Eliminations and OtherTotal
Balance as of December 31, 2023$1,026.9$99.6$12.1$1,138.6
Foreign currency translation(29.1)(3.6)—(32.7)
Balance as of June 30, 2024$997.8$96.0$12.1$1,105.9

Table 12 after “11”

June 30, 2024
Amortized CostGross Unrealized GainsGross Unrealized LossesFair Value
Level 1
Cash and cash equivalents$2.3$—$—$2.3
Level 2
Corporate debt securities199.20.6(8.3)191.5
Municipal bonds208.50.8(4.4)204.9
U.S. government bonds285.40.1(3.0)282.5

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

Table 13 after “:”

June 30, 2024December 31, 2023
(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$34.3$(0.3)$5.4$(0.1)
Municipal bonds86.5(1.1)42.3(0.2)
U.S. government bonds265.2(3.0)26.4(0.3)
$386.0$(4.4)$74.1$(0.6)
Securities that have been in a continuous loss position for more than 12 months:

First 8 of 11 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, 2024
Due in one year or less$19.7
Due after one year through five years217.2
Due after five years through ten years384.7
Due after ten years57.3
Total debt securities$678.9

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

(in millions)June 30, 2024December 31, 2023
AROs, beginning of period$2,213.4$1,905.6
Liabilities incurred18.522.9
Liabilities settled(111.6)(198.5)
Accretion expense54.196.1
Revisions in estimated cash flows30.0365.1
Foreign currency translation(37.7)22.2
AROs, end of period2,166.72,213.4

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

Table 16 after “The following is the total absolute notional volume associated with our outstanding derivative instruments:”

(in millions of Units)June 30, 2024December 31, 2023
Derivative InstrumentDerivative CategoryUnit of Measure
Foreign currency derivativesForeign currencyUS Dollars1,559.72,418.7
Natural gas derivativesCommodityMMbtu9.617.1

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

June 30, 2024December 31, 2023
Carrying AmountFair ValueCarrying AmountFair Value
Cash and cash equivalents$322.0$322.0$348.8$348.8
Accounts receivable1,285.51,285.51,269.21,269.2
Accounts payable1,054.81,054.81,166.91,166.9
Structured accounts payable arrangements265.8265.8399.9399.9
Short-term debt881.5881.5399.7399.7
Long-term debt, including current portion3,319.03,248.23,361.73,364.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, 2024 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, 2024
Balance at March 31, 2024$(2,059.1)$(32.2)$8.1$(10.1)$(2,093.3)
Other comprehensive income (loss)(135.2)0.8—(3.4)(137.8)
Tax (expense) benefit(1.3)(0.2)—0.8(0.7)
Other comprehensive income (loss), net of tax(136.5)0.6—(2.6)(138.5)
Other comprehensive income (loss) attributable to noncontrolling interest2.4———2.4
Balance as of June 30, 2024$(2,193.2)$(31.6)$8.1$(12.7)$(2,229.4)

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,
2024202320242023
Transactions with related parties included in net sales(a)$234.0$314.6$470.6$760.5
Transactions with related parties included in cost of goods sold(b)301.8483.6562.6880.5

Table 20 after “Segment information for the three and six months ended June 30, 2024 and 2023 was as follows:”

PhosphatePotashMosaic FertilizantesCorporate, Eliminations and Other(a)Total
Three months ended June 30, 2024
Net sales to external customers$989.2$655.1$1,048.9$123.4$2,816.6
Intersegment net sales190.38.0—(198.3)—
Net sales1,179.5663.11,048.9(74.9)2,816.6
Gross margin153.7186.4101.8(47.9)394.0
Canadian resource taxes—66.8——66.8
Gross margin (excluding Canadian resource taxes)153.7253.2101.8(47.9)460.8

First 8 of 44 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)2024202320242023
Net sales(a):
Brazil$1,037.9$1,367.3$1,890.7$2,667.9
Canpotex(b)222.0300.8442.8732.1
Canada147.2134.8289.2215.9
China112.889.4236.8234.8
Paraguay45.051.281.996.8

First 8 of 21 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)2024202320242023
Sales by product type:
Phosphate Crop Nutrients$719.5$828.4$1,390.6$1,724.9
Potash Crop Nutrients831.81,005.01,514.42,020.3
Crop Nutrient Blends307.9423.2660.11,076.6
Performance Products(a)514.7690.4981.51,230.9
Phosphate Rock37.748.278.589.0

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

Table 23 after “26”

Three months endedSix months ended
June 30,2024-2023June 30,2024-2023
(in millions, except per share data)20242023ChangePercent20242023ChangePercent
Net sales$2,816.6$3,394.0$(577.4)(17)%$5,496.0$6,998.3$(1,502.3)(21)%
Cost of goods sold2,422.62,822.9(400.3)(14)%4,702.85,756.8(1,054.0)(18)%
Gross margin394.0571.1(177.1)(31)%793.21,241.5(448.3)(36)%
Gross margin percentage14%17%14%18%
Selling, general and administrative expenses128.4129.9(1.5)(1)%235.2257.6(22.4)(9)%

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

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

Three months endedSix months ended
June 30,2024-2023June 30,2024-2023
(in millions, except price per tonne or unit)20242023ChangePercent20242023ChangePercent
Net sales:
North America$1,009.8$1,081.1$(71.3)(7)%$2,025.6$2,005.9$19.71%
International169.7204.6(34.9)(17)%322.6661.9(339.3)(51)%
Total1,179.51,285.7(106.2)(8)%2,348.22,667.8(319.6)(12)%
Cost of goods sold1,025.81,069.5(43.7)(4)%2,035.12,192.3(157.2)(7)%

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,2024-2023June 30,2024-2023
(in millions, except price per tonne or unit)20242023ChangePercent20242023ChangePercent
Net sales:
North America$434.3$534.2$(99.9)(19)%$844.2$988.3$(144.1)(15)%
International228.8314.5(85.7)(27)%462.0767.0(305.0)(40)%
Total663.1848.7(185.6)(22)%1,306.21,755.3(449.1)(26)%
Cost of goods sold476.7512.7(36.0)(7)%908.11,006.0(97.9)(10)%

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,2024-2023June 30,2024-2023
(in millions, except price per tonne or unit)20242023ChangePercent20242023ChangePercent
Net Sales$1,048.9$1,418.8$(369.9)(26)%$1,935.3$2,762.1$(826.8)(30)%
Cost of goods sold947.11,406.0(458.9)(33)%1,758.32,750.4(992.1)(36)%
Gross margin$101.8$12.8$89.0NM$177.0$11.7$165.3NM
Gross margin as a percent of net sales10%1%9%—%
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,2024-2023June 30,2024-2023
(in millions)20242023ChangePercent20242023ChangePercent
Selling, general and administrative expenses$128.4$129.9$(1.5)(1)%$235.2$257.6$(22.4)(9)%
Other operating expense32.372.0(39.7)(55)%151.870.181.7117%
Interest expense(61.2)(47.3)(13.9)29%(119.4)(97.5)(21.9)22%
Interest income14.811.33.531%25.020.44.623%
Interest expense, net(46.4)(36.0)(10.4)29%(94.4)(77.1)(17.3)22%

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

Table 28 after “Provision for Income Taxes”

Three months endedEffective Tax RateProvision for Income Taxes
June 30, 2024(132.7)%$98.7
June 30, 202322.8%$108.4
Six months endedEffective Tax RateProvision for Income Taxes
June 30, 2024(213.2)%$104.9
June 30, 202322.2%$226.7

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

(in millions)Six months ended
June 30,2024-2023
Cash Flow20242023ChangePercent
Net cash provided by operating activities$767.0$1,221.7$(454.7)(37)%
Net cash used in investing activities(736.8)(532.9)(203.9)38%
Net cash used in financing activities(30.7)(815.6)784.9(96)%

Table 30 after “As of June 30, 2024 and December 31, 2023, the fair value of our major foreign currency exchange contracts was $(36.6) million and $28.4 mil”

(in millions US$)As of June 30, 2024As of December 31, 2023
Expected Maturity DateFair ValueExpected Maturity DateFair Value
Years ending December 31,Years ending December 31,
20242025202620242025
Foreign Currency Exchange Forwards
Canadian Dollar$(7.9)$15.5
Notional (million US$) - short Canadian dollars$81.7$2.9$—$297.3$—
Weighted Average Rate - Canadian dollar to U.S. dollar1.35931.3584—1.3387—

First 8 of 23 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, 2024As of December 31, 2023
Expected Maturity DateExpected Maturity Date
Years ending December 31,Years ending December 31,
20242025Fair Value20242025Fair Value
Natural Gas Swaps$(5.9)$(10.3)
Notional (million MMBtu) - long6.72.915.12.0
Weighted Average Rate (US$/MMBtu)$2.65$2.95$2.75$3.30
Total Fair Value$(5.9)$(10.3)

Table 32 after “48”

PeriodTotal number of shares purchasedAverage price paid per shareTotal number of shares purchased as part of a publicly announced programMaximum approximate dollar value of shares that may yet be purchased under the program(b)
Common Stock
April 1, 2024- April 30, 2024—$——$1,059,428,230
May 1, 2024- May 31, 2024———1,059,428,230
June 1, 2024- June 30, 20241,835,78828.331,835,7881,007,428,308
Total1,835,788$28.331,835,788$1,007,428,308

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

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