Discounted Cash Flow

Lloyds Banking Group Plc. ADR

LYG · Based on 10 years of SEC filings

Average annual growth rates

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Average annual growth is the mean year-over-year change across each period.

Endpoint CAGR (better for long term trend)

Metric 10-Year 5-Year 3-Year
Sales
Free Cash Flow
Average (FCF & NI)
Net Income

Endpoint CAGR is the compound annual rate from the first to last year in each period.

Projections use average year-over-year growth. Change this in Settings.

Projected growth rate

Free cash flow growth
10-year: — 5-year: — 3-year: —
Averaged growth (FCF & NI)
10-year: — 5-year: — 3-year: —
Net income growth
10-year: — 5-year: — 3-year: —
Sales growth (not added to calculations)
10-year: — 5-year: — 3-year: —

Click a greyed-out slider to switch metrics. Slide between the 10-year, 5-year, and 3-year historic growth rates for FCF, net income, or their average.

%
%

Historical inputs (10 fiscal years)

YEAR Sales Net Income Free Cash Flow Net Margin EPS (diluted)
2016 $39.6b $2.1b $-822.0m 5.2% $0.02
2017 $34.2b (-13.6%) $3.8b (84.5%) $-3.2b (-288.7%) 11.1% (113.5%) $0.05 (104.2%)
2018 $22.1b (-35.5%) $4.3b (13.0%) $-11.1b (-247.6%) 19.5% (75.1%) $0.06 (12.2%)
2019 $42.4b (91.7%) $2.9b (-32.0%) $11.3b (201.6%) 6.9% (-64.5%) $0.04 (-36.4%)
2020 $29.2b (-31.1%) $1.3b (-54.9%) $1.3b (-88.3%) 4.5% (-34.6%) $0.01 (-65.7%)
2021 $37.4b (28.4%) $5.8b (338.8%) $6.6b (402.4%) 15.4% (241.8%) $0.07 (525.0%)
2022 $5.8b (-84.5%) $5.5b (-5.6%) $18.2b (174.2%) 94.0% (508.5%) $0.07 (-2.7%)
2023 $35.4b (509.6%) $5.5b (0.0%) $1.4b (-92.5%) 15.4% (-83.6%) $0.08 (4.1%)
2024 $34.3b (-3.2%) $4.4b (-19.0%) $-10.0b (-839.2%) 12.9% (-16.4%) $0.06 (-17.1%)
2025 $19.4b (-43.3%) $4.7b (5.4%) $-622.0m (93.8%) 24.0% (86.0%) $0.07 (11.1%)

Base FCF: (latest fiscal year)

Discount rate: %

Terminal growth:

Projection period: years

Alt A decline yrs:

Alt B total yrs:

Values abbreviated: b = billions, m = millions, k = thousands.

Projected cash flows

Year Projected cash flow Discount Factor Present Value

PV of projected FCF:

Terminal FCF:

Terminal value:

PV of terminal value:

Enterprise value (DCF):

DCF price per share:

Current price:

Alternative DCF Models

Model Fair Value Upside PV(FCFs) PV(Terminal) Total Years
Standard (10yr→TV) 10 + TV
Alt A (Gradual Decline)
Alt B (30yr Hard Stop) N/A

This is a simplified DCF model for illustration. It uses reported free cash flow, a single growth assumption, fixed WACC, and a Gordon Growth terminal value. It is not investment advice.

+ 10YR Financials Balance Sheet (10YR) Cash Flow (10YR) DCF Model