Stock Analysis on Net

Sherwin-Williams Co. (NYSE:SHW)

$24.99

Price to FCFE (P/FCFE)

Microsoft Excel

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Free Cash Flow to Equity (FCFE)

Sherwin-Williams Co., FCFE calculation

US$ in thousands

Microsoft Excel
12 months ended: Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
Net income
Net noncash charges
Change in working capital accounts
Net operating cash
Capital expenditures
Net increase (decrease) in short-term borrowings
Proceeds from long-term debt
Payments of long-term debt
Payments for credit facility and debt issuance costs
Free cash flow to equity (FCFE)

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).


Net Operating Cash
The net operating cash shows a fluctuating trend over the five-year period. It declined notably from 3,408,600 thousand US$ in 2020 to 2,244,600 thousand US$ in 2021, followed by a further decrease to 1,919,900 thousand US$ in 2022. However, a significant recovery is observed in 2023, with net operating cash rising sharply to 3,521,900 thousand US$, before slightly decreasing to 3,153,200 thousand US$ in 2024. Overall, net operating cash demonstrates volatility but recovers strongly after two years of decline, reaching levels close to the initial 2020 figure by 2024.
Free Cash Flow to Equity (FCFE)
Free cash flow to equity experienced a different pattern compared to net operating cash. It started at 2,684,500 thousand US$ in 2020 and increased to a peak of 3,196,900 thousand US$ in 2021. This was followed by a substantial decline to 2,221,900 thousand US$ in 2022. The downward trend continued into 2023, reaching 1,893,200 thousand US$, the lowest point in the observed period. Nevertheless, a modest recovery occurred in 2024, with FCFE rising to 2,111,900 thousand US$. Despite some recovery, FCFE in 2024 remains below the initial value in 2020 and significantly lower than its peak in 2021.
Overall Analysis
Both net operating cash and FCFE show considerable variability throughout the period analyzed. Net operating cash exhibits a sharp dip in 2021 and 2022 with a strong rebound in 2023, suggesting possible operational challenges during those two years but a substantial improvement subsequently. Conversely, FCFE peaked in 2021 but then steadily declined through 2023, with only a slight rebound in 2024, indicating possible pressures on the cash available to equity holders post-2021. The divergence in the paths of net operating cash and FCFE, especially the more marked recovery in net operating cash, could imply changes in investment or financing activities affecting free cash flow differently than operating cash.

Price to FCFE Ratio, Current

Sherwin-Williams Co., current P/FCFE calculation, comparison to benchmarks

Microsoft Excel
No. shares of common stock outstanding
Selected Financial Data (US$)
Free cash flow to equity (FCFE) (in thousands)
FCFE per share
Current share price (P)
Valuation Ratio
P/FCFE
Benchmarks
P/FCFE, Competitors1
Linde plc
P/FCFE, Sector
Chemicals
P/FCFE, Industry
Materials

Based on: 10-K (reporting date: 2024-12-31).

1 Click competitor name to see calculations.

If the company P/FCFE is lower then the P/FCFE of benchmark then company is relatively undervalued.
Otherwise, if the company P/FCFE is higher then the P/FCFE of benchmark then company is relatively overvalued.


Price to FCFE Ratio, Historical

Sherwin-Williams Co., historical P/FCFE calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2024 Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020
No. shares of common stock outstanding1
Selected Financial Data (US$)
Free cash flow to equity (FCFE) (in thousands)2
FCFE per share3
Share price1, 4
Valuation Ratio
P/FCFE5
Benchmarks
P/FCFE, Competitors6
Linde plc
P/FCFE, Sector
Chemicals
P/FCFE, Industry
Materials

Based on: 10-K (reporting date: 2024-12-31), 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31).

1 Data adjusted for splits and stock dividends.

2 See details »

3 2024 Calculation
FCFE per share = FCFE ÷ No. shares of common stock outstanding
= ÷ =

4 Closing price as at the filing date of Sherwin-Williams Co. Annual Report.

5 2024 Calculation
P/FCFE = Share price ÷ FCFE per share
= ÷ =

6 Click competitor name to see calculations.


Share Price Trend
The share price exhibited a general upward trend over the five-year period. Starting at $238.97 in 2020, it increased moderately to $267.22 in 2021, followed by a decline to $222.63 in 2022. Subsequently, the price rebounded significantly to $311.26 in 2023 and continued to rise to $350.02 by the end of 2024.
Free Cash Flow to Equity (FCFE) per Share
FCFE per share showed variability across the years. It rose from $9.99 in 2020 to a peak of $12.28 in 2021, then decreased notably to $8.60 in 2022. In the following years, FCFE per share further declined to $7.44 in 2023 before showing a slight recovery to $8.40 in 2024.
Price to FCFE Ratio (P/FCFE)
The P/FCFE ratio remained relatively stable during the first two years, starting at 23.93 in 2020 and decreasing slightly to 21.76 in 2021. From 2022 onwards, there was a marked increase, with the ratio rising to 25.90 in 2022 and then sharply to 41.84 in 2023. It held steady at a high level of 41.66 in 2024, indicating significantly higher market valuation relative to free cash flow.
Overall Analysis
The data reveals a contrasting dynamic between market valuation and underlying cash flow generation. While the share price demonstrated strong growth toward the end of the period, FCFE per share declined after 2021 before a modest improvement in 2024. The substantial increase in the P/FCFE ratio since 2022 suggests that the market's valuation of the shares has outpaced the growth or recovery in free cash flow to equity, potentially reflecting elevated investor expectations or changing market sentiment.