Darden Restaurants, Inc. (DRI) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Darden Restaurants, Inc. (DRI) Bundle
Explore the financial future of Darden Restaurants, Inc. (DRI) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and expenses to calculate the intrinsic value of Darden Restaurants, Inc. (DRI) and inform your investment decisions.
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 | 7,806.9 | 7,196.1 | 9,630.0 | 10,487.8 | 11,390.0 | 12,628.9 | 14,002.6 | 15,525.7 | 17,214.4 | 19,086.8 |
| Revenue Growth, % | 0 | -7.82 | 33.82 | 8.91 | 8.6 | 10.88 | 10.88 | 10.88 | 10.88 | 10.88 |
| EBITDA | 257.0 | 993.4 | 1,535.1 | 1,593.4 | 1,775.2 | 1,611.9 | 1,787.2 | 1,981.6 | 2,197.1 | 2,436.1 |
| EBITDA, % | 3.29 | 13.8 | 15.94 | 15.19 | 15.59 | 12.76 | 12.76 | 12.76 | 12.76 | 12.76 |
| Depreciation | 355.9 | 350.9 | 368.4 | 387.8 | 459.9 | 530.3 | 588.0 | 652.0 | 722.9 | 801.5 |
| Depreciation, % | 4.56 | 4.88 | 3.83 | 3.7 | 4.04 | 4.2 | 4.2 | 4.2 | 4.2 | 4.2 |
| EBIT | -98.9 | 642.5 | 1,166.7 | 1,205.6 | 1,315.3 | 1,081.5 | 1,199.2 | 1,329.6 | 1,474.2 | 1,634.6 |
| EBIT, % | -1.27 | 8.93 | 12.12 | 11.5 | 11.55 | 8.56 | 8.56 | 8.56 | 8.56 | 8.56 |
| Total Cash | 763.3 | 1,214.7 | 420.6 | 367.8 | 194.8 | 915.4 | 1,015.0 | 1,125.4 | 1,247.8 | 1,383.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 49.8 | 68.2 | 72.0 | 80.2 | 79.1 | 95.8 | 106.2 | 117.8 | 130.6 | 144.8 |
| Account Receivables, % | 0.6379 | 0.94774 | 0.74766 | 0.7647 | 0.69447 | 0.75849 | 0.75849 | 0.75849 | 0.75849 | 0.75849 |
| Inventories | 206.9 | 190.8 | 270.6 | 287.9 | 290.5 | 338.6 | 375.5 | 416.3 | 461.6 | 511.8 |
| Inventories, % | 2.65 | 2.65 | 2.81 | 2.75 | 2.55 | 2.68 | 2.68 | 2.68 | 2.68 | 2.68 |
| Accounts Payable | 249.4 | 304.5 | 366.9 | 426.2 | 399.5 | 475.0 | 526.7 | 584.0 | 647.5 | 717.9 |
| Accounts Payable, % | 3.19 | 4.23 | 3.81 | 4.06 | 3.51 | 3.76 | 3.76 | 3.76 | 3.76 | 3.76 |
| Capital Expenditure | -494.0 | -269.1 | -399.1 | -593.8 | -628.3 | -641.3 | -711.0 | -788.4 | -874.1 | -969.2 |
| Capital Expenditure, % | -6.33 | -3.74 | -4.14 | -5.66 | -5.52 | -5.08 | -5.08 | -5.08 | -5.08 | -5.08 |
| Tax Rate, % | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 | 12.58 |
| EBITAT | -30.2 | 701.3 | 1,016.6 | 1,056.5 | 1,149.8 | 849.5 | 941.9 | 1,044.4 | 1,158.0 | 1,283.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -175.6 | 835.9 | 964.7 | 884.3 | 953.2 | 749.3 | 823.3 | 912.9 | 1,012.1 | 1,122.2 |
| WACC, % | 8.84 | 9.43 | 9.32 | 9.33 | 9.33 | 9.25 | 9.25 | 9.25 | 9.25 | 9.25 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,507.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,145 | |||||||||
| Terminal Value | 15,789 | |||||||||
| Present Terminal Value | 10,145 | |||||||||
| Enterprise Value | 13,652 | |||||||||
| Net Debt | 5,233 | |||||||||
| Equity Value | 8,419 | |||||||||
| Diluted Shares Outstanding, MM | 121 | |||||||||
| Equity Value Per Share | 69.69 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled financial data for Darden Restaurants, Inc. (DRI).
- Real-World Data: Historical performance metrics and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast parameters such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe how your inputs affect Darden's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step guidance.
Key Features
- Real-Life DRI Data: Pre-filled with Darden Restaurants' historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the prebuilt Excel template containing Darden Restaurants, Inc. (DRI) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see recalculated results, including Darden Restaurants, Inc. (DRI) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Darden Restaurants, Inc. (DRI)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Comprehensive Data: Darden's historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Transparent Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Clear, step-by-step instructions to assist you throughout the process.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Darden Restaurants stock (DRI).
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Darden Restaurants (DRI).
- Consultants: Deliver professional valuation insights to clients quickly and accurately regarding Darden Restaurants (DRI).
- Business Owners: Understand how large companies like Darden Restaurants (DRI) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Darden Restaurants (DRI).
What the Template Contains
- Preloaded DRI 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.