Diageo PLC
LSE:DGE

Watchlist Manager
Diageo PLC Logo
Diageo PLC
LSE:DGE
Watchlist
Price: 2 398.5 GBX 2.06% Market Closed
Market Cap: 53.3B GBX
Have any thoughts about
Diageo PLC?
Write Note

DCF Value

This DCF valuation model was created by Alpha Spread and was last updated on Nov 24, 2024.

Estimated DCF Value of one DGE stock is 2 336.56 GBX. Compared to the current market price of 2 398.5 GBX, the stock is Overvalued by 3%.

DGE DCF Value
Base Case
2 336.56 GBX
Overvaluation 3%
DCF Value
Price
Worst Case
Base Case
Best Case
2 336.56
DCF Value
Worst Case
Base Case
Best Case
Hide
DCF Value: 2 336.56 GBX

Present Value Calculation

This block is the starting point of the DCF valuation process. It calculates the present value of a company's forecasted cash flows based on selected operating model. Adjust key parameters like discount rate and terminal growth, and alter inputs such as revenue growth and margins to see their impact on valuation.

DCF Model
Base Case Scenario

The present value of cash flows over the next 5 years amounts to 18.5B GBP. The present value of the terminal value is 47.6B GBP. The total present value equals 66.1B GBP.
Forecast Period
Years
Discount Rate
%
Show All DCF Settings
Terminal Growth
%
Hide DCF Settings
Save

DCF Value Calculation

This stage translates the present value into DCF value per share. For firm valuation models, it adjusts present value for debt and assets to derive equity value (skipped if using equity valuation model). Finally, this equity value is divided by the number of shares to determine the DCF value per share.

Present Value to DCF Value
Capital Structure

Present Value 66.1B GBP
+ Cash & Equivalents 1.1B GBP
+ Investments 5.9B GBP
Firm Value 73.1B GBP
- Debt 19.1B GBP
- Minority Interest 2B GBP
Equity Value 51.9B GBP
/ Shares Outstanding 2.2B
Value per Share 23.37 GBP
GBP / GBX Exchange Rate 100
DGE DCF Value 2 336.56 GBX
Overvalued by 3%

Valuation Analysis

Sensitivity Analysis
DCF Value Sensitivity Analysis

Sensitivity Analysis assesses how changes in key factors like revenue growth, margin, and discount rate affect a stock's DCF value. By visualizing various scenarios, from significant downturns to optimistic growth, this tool helps you understand potential valuation shifts, aiding in risk assessment and strategic decision-making.

DCF Financials
Financials used in DCF Calculation

Revenue
21B 25.3B
Operating Income
5.9B 7.2B
FCFF
4.2B 5B

See Also

Discover More

What is the DCF value of one DGE stock?

Estimated DCF Value of one DGE stock is 2 336.56 GBX. Compared to the current market price of 2 398.5 GBX, the stock is Overvalued by 3%.

The true DCF Value lies somewhere between the worst-case and best-case scenario values. This is because the future is not predetermined, and the stock's DCF Value is based almost entirely on the future of the company. Knowing the full range of possible stock DCF values gives a complete picture of the investment risks and opportunities.

How was the DCF Value calculated?

1. Present Value Calculation. Utilizing the DCF operating model, Diageo PLC's future cash flows are projected and then discounted using a chosen discount rate to determine its Present Value, which is calculated at 66.1B GBP.

2. DCF Value Calculation. The company's capital structure is employed to derive the total Equity Value from the previously calculated Present Value of the cash flow. This Equity Value, when divided by the total number of outstanding shares, yields the DCF Value of 2 336.56 GBX per share.

Back to Top
//