|
Brinker International, Inc. (EAT) DCF Valuation
US | Consumer Cyclical | Restaurants | NYSE
|
- ✓ 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
Brinker International, Inc. (EAT) Bundle
Designed for accuracy, our (EAT) DCF Calculator enables you to evaluate Brinker International, Inc. valuation using up-to-date financial data and complete flexibility to modify all key parameters for improved forecasts.
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 | 3,078.5 | 3,337.8 | 3,804.1 | 4,133.2 | 4,415.1 | 4,833.0 | 5,290.5 | 5,791.4 | 6,339.6 | 6,939.7 |
| Revenue Growth, % | 0 | 8.42 | 13.97 | 8.65 | 6.82 | 9.47 | 9.47 | 9.47 | 9.47 | 9.47 |
| EBITDA | 226.8 | 351.6 | 325.7 | 314.2 | 400.7 | 417.0 | 456.5 | 499.7 | 547.0 | 598.8 |
| EBITDA, % | 7.37 | 10.53 | 8.56 | 7.6 | 9.08 | 8.63 | 8.63 | 8.63 | 8.63 | 8.63 |
| Depreciation | 162.3 | 150.2 | 164.4 | 168.5 | 170.8 | 213.0 | 233.2 | 255.3 | 279.4 | 305.9 |
| Depreciation, % | 5.27 | 4.5 | 4.32 | 4.08 | 3.87 | 4.41 | 4.41 | 4.41 | 4.41 | 4.41 |
| EBIT | 64.5 | 201.4 | 161.3 | 145.7 | 229.9 | 204.0 | 223.3 | 244.4 | 267.5 | 292.9 |
| EBIT, % | 2.1 | 6.03 | 4.24 | 3.53 | 5.21 | 4.22 | 4.22 | 4.22 | 4.22 | 4.22 |
| Total Cash | 43.9 | 23.9 | 13.5 | -1,125.8 | 64.6 | -225.0 | -246.3 | -269.6 | -295.1 | -323.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 87.7 | 88.2 | 70.9 | 60.9 | 60.6 | 98.6 | 107.9 | 118.2 | 129.3 | 141.6 |
| Account Receivables, % | 2.85 | 2.64 | 1.86 | 1.47 | 1.37 | 2.04 | 2.04 | 2.04 | 2.04 | 2.04 |
| Inventories | 78.9 | 81.5 | 91.1 | 34.5 | 88.3 | 98.9 | 108.3 | 118.5 | 129.8 | 142.0 |
| Inventories, % | 2.56 | 2.44 | 2.39 | 0.8347 | 2 | 2.05 | 2.05 | 2.05 | 2.05 | 2.05 |
| Accounts Payable | 104.9 | 127.7 | 134.3 | 125.7 | 160.6 | 168.6 | 184.6 | 202.0 | 221.2 | 242.1 |
| Accounts Payable, % | 3.41 | 3.83 | 3.53 | 3.04 | 3.64 | 3.49 | 3.49 | 3.49 | 3.49 | 3.49 |
| Capital Expenditure | -104.5 | -94.0 | -150.3 | -184.9 | -198.9 | -185.0 | -202.5 | -221.7 | -242.7 | -265.7 |
| Capital Expenditure, % | -3.39 | -2.82 | -3.95 | -4.47 | -4.5 | -3.83 | -3.83 | -3.83 | -3.83 | -3.83 |
| Tax Rate, % | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 | 5.82 |
| EBITAT | 321.2 | 182.5 | 164.7 | 164.6 | 216.5 | 197.8 | 216.5 | 237.0 | 259.4 | 284.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 317.3 | 258.4 | 193.1 | 206.2 | 169.8 | 185.2 | 244.4 | 267.6 | 292.9 | 320.6 |
| WACC, % | 13.25 | 13.15 | 13.25 | 13.25 | 13.19 | 13.22 | 13.22 | 13.22 | 13.22 | 13.22 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 889.2 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 330 | |||||||||
| Terminal Value | 3,232 | |||||||||
| Present Terminal Value | 1,738 | |||||||||
| Enterprise Value | 2,627 | |||||||||
| Net Debt | 1,934 | |||||||||
| Equity Value | 693 | |||||||||
| Diluted Shares Outstanding, MM | 46 | |||||||||
| Equity Value Per Share | 15.16 |
What You Will Get
- Real Brinker Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Brinker International, Inc. (EAT).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Brinker’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to Brinker International, Inc. (EAT).
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility.
Key Features
- 🔍 Real-Life EAT Financials: Pre-filled historical and projected data for Brinker International, Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Brinker’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Brinker’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based EAT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Brinker International's intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial decisions.
Why Choose This Calculator?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters to suit your financial analysis needs.
- Real-Time Feedback: Witness immediate updates to Brinker International's valuation as you tweak the inputs.
- Pre-Loaded Data: Comes equipped with Brinker International's actual financial figures for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts making strategic decisions.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for evaluating Brinker International, Inc. (EAT) investments.
- Corporate Finance Teams: Examine valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Brinker International, Inc. (EAT).
- Students and Educators: Utilize real-world data to enhance financial modeling skills and education.
- Food Industry Enthusiasts: Gain insights into how restaurant companies like Brinker International, Inc. (EAT) are valued in the market.
What the Template Contains
- Historical Data: Includes Brinker International’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Brinker International’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Brinker International’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.