Which FTSE 100 companies combine dependable dividend growth with calmer share-price behaviour?
This project screens 15 FTSE 100 companies across five sectors using dividend history and monthly price data from 2014 to 2024. It translates SQL analysis into an investor-style dashboard that compares payout consistency, recent dividend growth, yield, and price volatility.
Headline Finding
RELX stood out strongest overall
RELX ranked first on the combined model because it paired strong dividend momentum with the lowest observed monthly volatility in the sample. National Grid and London Stock Exchange Group followed, but for different reasons: one defensive, one growth-led.
Companies Paying Dividends Every Year
12 / 15
Most firms in the sample maintained annual payouts from 2014 to 2024.
Companies Growing Dividends Every Year
4
Halma, Legal & General, RELX, and United Utilities passed the strict growth test.
Strongest Combined Profile
RELX
Best blend of dividend consistency, 5-year growth, and lower volatility.
Interactive Analysis
Charts designed to answer the project question directly.
5-Year Dividend CAGR
Recent dividend growth from 2019 to 2024.
Monthly Price Volatility
Standard deviation of monthly returns across the sample period.
Dividend Growth vs Price Stability
This view connects the project metrics in one chart. Companies further left are more stable, while companies higher up achieved stronger recent dividend growth. Bubble size reflects how many year-on-year dividend increases each company delivered.
Business Takeaways
How to explain the results to a stakeholder.
RELX
Best all-round profile thanks to strong dividend growth and the lowest volatility in the sample.
National Grid
Delivered a defensive blend of good consistency, solid 5-year growth, and stable pricing.
London Stock Exchange Group
Led the sample on recent dividend growth, although with weaker price stability than the top defensive names.
Dividend Coverage
The companies paying dividends every year from 2014 to 2024 were AstraZeneca, Diageo, GSK, Halma, Legal & General, London Stock Exchange Group, and National Grid, RELX, SSE, Unilever, United Utilities, WPP.
Top Combined Ranking
Lower average score indicates a stronger all-round profile.
| Rank | Company | Growth Years | 5Y CAGR | Volatility | Avg Score |
|---|---|---|---|---|---|
| 1 | RELX | 10 | 6.74% | 4.69% | 1.67 |
| 2 | National Grid | 9 | 4.57% | 5.04% | 3.67 |
| 3 | LSEG | 9 | 13.7% | 6.22% | 4.33 |
| 4 | Diageo | 8 | 2.95% | 4.77% | 4.67 |
| 5 | Halma | 10 | 6.58% | 6.11% | 4.67 |
| 6 | United Utilities | 10 | 3.88% | 5.4% | 4.67 |
| 7 | Unilever | 7 | 0.72% | 4.72% | 5.33 |
| 8 | Legal & General | 10 | 4.25% | 7.32% | 6.67 |
| 9 | Tesco | 5 | 7.89% | 6.9% | 6.67 |
| 10 | SSE | 8 | -9.25% | 5.31% | 7 |
Highest 2024 Yields
M&G
10.01% dividend yield
Legal & General
8.98% dividend yield
National Grid
5.79% dividend yield
United Utilities
4.8% dividend yield
WPP
4.76% dividend yield
SQL Evidence
Representative queries from beginner to advanced level.
Dividend Coverage
Identify which firms managed to pay dividends in every year across the 2014 to 2024 period.
SELECT
ticker,
company_name,
COUNT(DISTINCT strftime('%Y', ex_date)) AS dividend_years
FROM dividends
WHERE ex_date BETWEEN '2014-01-01' AND '2024-12-31'
GROUP BY ticker, company_name
HAVING COUNT(DISTINCT strftime('%Y', ex_date)) = 11
ORDER BY company_name;| Ticker | Company | Dividend Years |
|---|---|---|
| AZN.L | AstraZeneca | 11 |
| DGE.L | Diageo | 11 |
| GSK.L | GSK | 11 |
| HLMA.L | Halma | 11 |
| LGEN.L | Legal & General | 11 |
| LSEG.L | London Stock Exchange Group | 11 |
| NG.L | National Grid | 11 |
| REL.L | RELX | 11 |
| SSE.L | SSE | 11 |
| ULVR.L | Unilever | 11 |
| UU.L | United Utilities | 11 |
| WPP.L | WPP | 11 |