Diageo plc (DEO) DCF Valuation

Diageo plc (DEO) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Diageo plc (DEO) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Enhance your investment choices with the (DEO) DCF Calculator! Explore genuine Diageo financial data, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of (DEO).


Discounted Cash Flow (DCF) - (USD MM)

Year AY1
2020		 AY2
2021		 AY3
2022		 AY4
2023		 AY5
2024		 FY1
2025		 FY2
2026		 FY3
2027		 FY4
2028		 FY5
2029
Revenue 14,713.4 15,941.6 19,345.7 21,425.3 20,158.6 21,899.2 23,790.1 25,844.3 28,075.9 30,500.2
Revenue Growth, % 0 8.35 21.35 10.75 -5.91 8.63 8.63 8.63 8.63 8.63
EBITDA 5,603.9 5,255.8 6,178.6 7,048.7 6,769.9 7,422.8 8,063.7 8,760.0 9,516.4 10,338.1
EBITDA, % 38.09 32.97 31.94 32.9 33.58 33.9 33.9 33.9 33.9 33.9
Depreciation 601.0 559.6 612.2 621.0 673.3 744.5 808.8 878.6 954.5 1,036.9
Depreciation, % 4.08 3.51 3.16 2.9 3.34 3.4 3.4 3.4 3.4 3.4
EBIT 5,002.9 4,696.2 5,566.3 6,427.7 6,096.6 6,678.3 7,255.0 7,881.4 8,561.9 9,301.2
EBIT, % 34 29.46 28.77 30 30.24 30.5 30.5 30.5 30.5 30.5
Total Cash 4,254.3 3,593.2 3,175.0 2,236.0 1,391.5 3,731.9 4,054.1 4,404.2 4,784.5 5,197.6
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 1,875.5 2,274.9 3,495.5 2,498.2 2,648.4
Account Receivables, % 12.75 14.27 18.07 11.66 13.14
Inventories 7,226.5 7,568.3 8,881.6 9,591.5 9,626.9 10,293.6 11,182.4 12,148.0 13,197.0 14,336.5
Inventories, % 49.12 47.48 45.91 44.77 47.76 47 47 47 47 47
Accounts Payable 1,668.9 2,521.5 1,107.0 3,329.0 7,955.1 3,849.1 4,181.5 4,542.5 4,934.8 5,360.9
Accounts Payable, % 11.34 15.82 5.72 15.54 39.46 17.58 17.58 17.58 17.58 17.58
Capital Expenditure -876.4 -783.7 -1,373.4 -1,477.3 -1,495.5 -1,414.1 -1,536.2 -1,668.8 -1,812.9 -1,969.5
Capital Expenditure, % -5.96 -4.92 -7.1 -6.9 -7.42 -6.46 -6.46 -6.46 -6.46 -6.46
Tax Rate, % 3.45 3.45 3.45 3.45 3.45 3.45 3.45 3.45 3.45 3.45
EBITAT 4,247.1 3,370.7 5,000.0 6,032.8 5,886.1 5,835.4 6,339.3 6,886.7 7,481.3 8,127.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -3,461.4 3,258.0 290.3 7,686.0 9,504.3 -19.3 4,791.1 5,204.8 5,654.3 6,142.5
WACC, % 6.21 6.15 6.23 6.25 6.26 6.22 6.22 6.22 6.22 6.22
PV UFCF
SUM PV UFCF 17,554.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 6,265
Terminal Value 148,405
Present Terminal Value 109,744
Enterprise Value 127,298
Net Debt 21,892
Equity Value 105,406
Diluted Shares Outstanding, MM 2,239
Equity Value Per Share 47.08

What You Will Get

  • Real DEO Financials: Access to historical and projected data for precise valuation.
  • Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
  • Automated Calculations: Intrinsic value and NPV are computed in real-time.
  • Scenario Analysis: Explore various scenarios to assess Diageo’s future performance.
  • User-Friendly Design: Designed for professionals while remaining easy for newcomers.

Key Features

  • Real-Life DEO Data: Pre-filled with Diageo’s historical financial metrics and future growth expectations.
  • Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax percentages, and capital expenditures.
  • Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
  • Scenario Testing: Develop various forecast scenarios to evaluate different valuation results.
  • User-Friendly Design: Intuitive, organized, and suitable for both professionals and novices.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Diageo plc's pre-filled financial data and forecasts.
  3. Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Watch the DCF model update instantly as you tweak assumptions.
  5. Step 5: Analyze the outputs and use the results for investment decisions.

Why Choose This Calculator for Diageo plc (DEO)?

  • Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and financial consultants.
  • Accurate Financial Data: Diageo’s historical and projected financials are preloaded for precise calculations.
  • Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
  • User-Friendly Interface: Step-by-step guidance makes navigation simple and straightforward.

Who Should Use Diageo plc (DEO)?

  • Investors: Make informed decisions with insights from a leading global beverage company.
  • Market Analysts: Access detailed reports and data on Diageo's performance and market trends.
  • Consultants: Utilize Diageo’s brand portfolio for strategic recommendations and presentations.
  • Beverage Enthusiasts: Explore the diverse range of products and learn about their heritage and production.
  • Students and Educators: Incorporate real-world case studies from Diageo into business and finance curricula.

What the Template Contains

  • Preloaded DEO Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
  • DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
  • Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
  • Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
  • Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
  • Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.

No products were found matching.