Derwent London Plc (DLN.L) Two-Stage Excess Return Model - Discounting Cash Flows
Derwent London Plc
DLN.L (LSE)

Estimated Value

GBp

Market Price GBp

* Values are not guaranteed, please do your own
research before making investment decisions.

Two-Stage Excess Return Model

Used to estimate the value of companies based on two stages of growth. An initial period of high growth, represented by [Sum of discounted excess returns in Growth Stage], followed by a period of stable growth, represented by [Discounted excess return in terminal stage]. Excess Return models are better suited to calculate the intrinsic value of a financial company than an enterprise valuation model (such as the Discounted Free Cash Flow Model).

Read more: GitHub Documentation

Interactive Assumptions

Results

Estimated Value -274.7 GBp
Book value of equity invested 3.13 Thou. GBp
Sum of discounted excess returns in Growth Stage -823.5 GBp
Terminal stage EPS 136.5 GBp
Terminal stage Book Value 3.77 Thou. GBp
Terminal stage Equity Cost 382.4 GBp
Discounted excess return in terminal stage -2.58 Thou. GBp
Excess Returns in the Terminal Stage -4.19 Thou. GBp
Terminal Cost of Equity (the discount rate) 10.13%
Terminal year's excess return -245.9 GBp
Average historical Return on Equity 3.62%
Average historical Payout Ratio 18.96%
Payout Ratio in stable stage -17.78%
Yield of the U.S. 10 Year Treasury Bond 4.26%

Historical and Forecasted Data

In GBp

Edit Chart Values 2025 2026 2027 2028 2029

amounts of GBp except for #

2024 LTM 2025 2026 2027 2028 2029
Beginning Book Value 3124 3143 3143 3244 3356 3481 3620
Ending Book Value 3143 3134 3244 3356 3481 3620 3774
EPS 103.0 102.0 113.7 117.3 121.4 125.9 131.0
Return on Equity 3.3% 3.27% 3.62% 3.62% 3.62% 3.62% 3.62%
Dividend per Share 80 66.13 13.21 5.01 -3.74 -13.13 -23.28
Payout Ratio 77.67% 64.83% 11.62% 4.27% -3.08% -10.43% -17.78%
Retained Earnings 23.0 35.87 100.5 112.3 125.1 139.1 154.2
Equity Cost 316.5 318.5 318.5 328.6 340.0 352.7 366.8
Cost of Equity 10.13% 10.13% 10.13% 10.13% 10.13% 10.13% 10.13%
Excess Return -213.5 -216.5 -204.7 -211.3 -218.6 -226.8 -235.8
Discounted Excess Return
-185.9 -174.2 -163.7 -154.2 -145.6

amounts of GBp except for #

Average LTM 2024 2023 2022 2021 2020 2019 2018 2017 2016 2015
Net Income 11,765 11,590 11,590 -47,640 -28,050 25,230 -7,760 28,340 22,230 31,400 5,870 76,620
Total Stockholders Equity 399,774 353,980 353,980 350,880 407,550 444,180 426,320 442,120 420,190 412,830 393,230 392,250
Return on Equity 3.62% 3.27% 3.3% -11.69% -6.31% 5.92% -1.75% 6.74% 5.38% 7.99% 1.5% 25.44%
Dividends Paid to Common Shareholders 7,815 7,469 9,008 8,871 8,701 8,461 8,220 7,564 10,494 7,726 4,971 4,479
Payout Ratio 18.97% 64.83% 77.67% -18.63% -31% 33.53% -106.4% 26.67% 47.29% 24.59% 84.26% 5.84%
Shares Outstanding 111.9 112.9 112.6 112.3 112.3 112.1 111.9 111.7 111.5 111.4 111.3 110.3
Earnings per Share 106.4 102.0 103.0 -424.0 -250.0 225.0 -69.0 254.0 199.0 282.0 53.0 695.0
Dividend per Share 69.82 66.13 80 79.0 77.5 75.45 73.45 67.75 94.1 69.33 44.66 40.6
Dividend Growth Rate 7.38% -17.34% 1.27% 1.93% 2.72% 2.72% 8.41% -28% 35.73% 55.24% 10% 8.56%
Book Value 3574 3134 3143 3124 3630 3960 3809 3959 3767 3704 3532 3555
discounting cash flows home logo

Discounting Cash Flows

Are you finding our services helpful? Review us on trustpilot logo Trustpilot
Have a question? Contact us