SHW · NYSE · Financial statements
SHERWIN WILLIAMS CO: cash-flow calculator
A discounted cash flow model turns assumptions about future free cash flow into a single amount today. Here the assumptions are yours: the page shows what they add up to, and, the other way round, what yearly growth a share price takes for granted.
- Free cash flow
- $2.7B
- FY 2025
- 5-year average
- $2.1B
- FY 2021–2025
- Net debt
- $10.7B
- FY 2025
- Diluted shares
- 250.4M
- FY 2025
Your assumptions
money in USDGrowth usually slows as a company gets bigger.
For ever, so it is usually kept at or below long-run growth of the economy, often 0–3%.
The yearly return you require: a risk-free rate plus a premium for risk. Higher means later cash counts for less.
From the FY 2025 balance sheet. Negative means more cash than debt.
Weighted average, diluted, FY 2025.
EdgeScore has no licensed price feed for US shares yet. Type the current share price yourself.
Present value per share, with your assumptions
138.59 USD
Starting from 2.65B USD of free cash flow, growing 5.0% a year for five years, 3.0% for the next five and 2.0% after that, all discounted at 9.0%.
- Years 1–10, discounted
- 21.20B
- After year 10, discounted
- 24.17B
- Minus net debt
- -10.66B
- For shareholders
- 34.70B
- Divided by shares
- 250.4M
What the price implies
Enter a share price to see the growth it implies.
- Your assumption, years 1–55.0%
- Free cash flow, FY 2020–2025-3.1%
- Free cash flow, FY 2022–202527.7%
- Revenue, FY 2020–20255.1%
- Revenue, FY 2022–20252.1%
Sensitivity: value per share
Rows: terminal growth. Columns: discount rate. Other assumptions as entered, values in USD.
| g \ r | 7% | 8% | 9% | 10% | 11% |
|---|---|---|---|---|---|
| 1.0% | 184.78 | 150.98 | 125.69 | 106.08 | 90.44 |
| 1.5% | 197.70 | 159.60 | 131.71 | 110.43 | 93.67 |
| 2.0% | 213.21 | 169.66 | 138.59 | 115.32 | 97.25 |
| 2.5% | 232.17 | 181.54 | 146.52 | 120.86 | 101.26 |
| 3.0% | 255.86 | 195.80 | 155.78 | 127.20 | 105.77 |
“—”: terminal growth at or above the discount rate has no finite answer.
Year by year
| Year | Growth | Free cash flow | Discount factor | Discounted |
|---|---|---|---|---|
| 1 | 5.0% | 2.79B | 0.917 | 2.56B |
| 2 | 5.0% | 2.93B | 0.842 | 2.46B |
| 3 | 5.0% | 3.07B | 0.772 | 2.37B |
| 4 | 5.0% | 3.23B | 0.708 | 2.29B |
| 5 | 5.0% | 3.39B | 0.650 | 2.20B |
| 6 | 3.0% | 3.49B | 0.596 | 2.08B |
| 7 | 3.0% | 3.59B | 0.547 | 1.97B |
| 8 | 3.0% | 3.70B | 0.502 | 1.86B |
| 9 | 3.0% | 3.81B | 0.460 | 1.76B |
| 10 | 3.0% | 3.93B | 0.422 | 1.66B |
| After 10 | 2.0% | 57.22B | 0.422 | 24.17B |
Terminal value = free cash flow in year 10 × (1 + terminal growth) ÷ (discount rate − terminal growth). Amounts in millions of USD.
Where the starting figures come from
Operating cash flow and free cash flow
| FY | Revenue | Op. cash flow | Capex | Free cash flow |
|---|---|---|---|---|
| 2025 | $23.6B | $3.5B | $798M | $2.7B |
| 2024 | $23.1B | $3.2B | $1.1B | $2.1B |
| 2023 | $23.1B | $3.5B | $888M | $2.6B |
| 2022 | $22.1B | $1.9B | $645M | $1.3B |
| 2021 | $19.9B | $2.2B | $372M | $1.9B |
| 2020 | $18.4B | $3.4B | $304M | $3.1B |
| 2019 | $17.9B | $2.3B | $329M | $2.0B |
| 2018 | $17.5B | $1.9B | $251M | $1.7B |
| 2017 | $15.0B | $1.9B | $223M | $1.7B |
| 2016 | $11.9B | $1.3B | $239M | $1.1B |
Free cash flow = operating cash flow − capital expenditure. Source: SEC EDGAR, annual reports.
How it works: free cash flow (operating cash flow minus capital expenditure) grows at your stage 1 rate for years 1–5 and your stage 2 rate for years 6–10; after that, a terminal value assumes your terminal growth for ever. Each year is discounted at your rate, net debt (financial debt minus cash, latest balance sheet) is subtracted and the total is divided by diluted shares. The reverse calculation finds, by bisection, the stage 1 growth at which this equals the share price. Operating cash flow is after interest, so subtracting net debt as well is a simplification you can switch off.
The output is arithmetic on your inputs. It is not an EdgeScore estimate of what the shares are worth and not a price target. Figures: SEC EDGAR, annual reports, with the fiscal year shown next to each one.
For information and education only, not investment advice. Data may contain errors.