The Wendy's Company (WEN) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
The Wendy's Company (WEN) Bundle
Looking to assess The Wendy's Company's intrinsic value? Our (WEN) DCF Calculator integrates real-world data with comprehensive customization features, enabling you to refine your projections and enhance your investment choices.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 1,709.0 | 1,733.8 | 1,897.0 | 2,095.5 | 2,181.6 | 2,320.3 | 2,467.8 | 2,624.8 | 2,791.7 | 2,969.2 |
Revenue Growth, % | 0 | 1.45 | 9.41 | 10.46 | 4.11 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 |
EBITDA | 408.3 | 416.9 | 458.6 | 535.5 | 552.0 | 570.7 | 606.9 | 645.5 | 686.6 | 730.2 |
EBITDA, % | 23.89 | 24.05 | 24.17 | 25.56 | 25.3 | 24.59 | 24.59 | 24.59 | 24.59 | 24.59 |
Depreciation | 131.7 | 161.7 | 166.1 | 169.7 | 148.6 | 188.9 | 200.9 | 213.7 | 227.2 | 241.7 |
Depreciation, % | 7.71 | 9.33 | 8.76 | 8.1 | 6.81 | 8.14 | 8.14 | 8.14 | 8.14 | 8.14 |
EBIT | 276.6 | 255.2 | 292.4 | 365.8 | 403.5 | 381.8 | 406.1 | 431.9 | 459.3 | 488.5 |
EBIT, % | 16.18 | 14.72 | 15.41 | 17.46 | 18.49 | 16.45 | 16.45 | 16.45 | 16.45 | 16.45 |
Total Cash | 300.2 | 307.0 | 249.4 | 745.9 | 516.0 | 499.7 | 531.4 | 565.2 | 601.2 | 639.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 117.5 | 109.9 | 119.5 | 186.8 | 121.7 | 157.8 | 167.8 | 178.5 | 189.9 | 201.9 |
Account Receivables, % | 6.87 | 6.34 | 6.3 | 8.92 | 5.58 | 6.8 | 6.8 | 6.8 | 6.8 | 6.8 |
Inventories | 3.9 | 4.7 | 5.9 | 7.1 | 6.7 | 6.8 | 7.2 | 7.7 | 8.2 | 8.7 |
Inventories, % | 0.22768 | 0.27292 | 0.31281 | 0.3402 | 0.30666 | 0.29205 | 0.29205 | 0.29205 | 0.29205 | 0.29205 |
Accounts Payable | 22.7 | 31.1 | 41.2 | 44.0 | 27.4 | 40.1 | 42.7 | 45.4 | 48.3 | 51.3 |
Accounts Payable, % | 1.33 | 1.79 | 2.17 | 2.1 | 1.25 | 1.73 | 1.73 | 1.73 | 1.73 | 1.73 |
Capital Expenditure | -74.5 | -69.0 | -78.0 | -85.5 | -85.0 | -94.8 | -100.8 | -107.2 | -114.0 | -121.3 |
Capital Expenditure, % | -4.36 | -3.98 | -4.11 | -4.08 | -3.9 | -4.08 | -4.08 | -4.08 | -4.08 | -4.08 |
Tax Rate, % | 26.83 | 26.83 | 26.83 | 26.83 | 26.83 | 26.83 | 26.83 | 26.83 | 26.83 | 26.83 |
EBITAT | 220.9 | 196.8 | 243.6 | 266.5 | 295.2 | 294.9 | 313.7 | 333.7 | 354.9 | 377.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 179.5 | 304.6 | 331.0 | 285.0 | 407.7 | 365.6 | 405.9 | 431.7 | 459.1 | 488.3 |
WACC, % | 5.65 | 5.59 | 5.74 | 5.48 | 5.49 | 5.59 | 5.59 | 5.59 | 5.59 | 5.59 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,818.2 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 503 | |||||||||
Terminal Value | 19,408 | |||||||||
Present Terminal Value | 14,786 | |||||||||
Enterprise Value | 16,604 | |||||||||
Net Debt | 3,624 | |||||||||
Equity Value | 12,980 | |||||||||
Diluted Shares Outstanding, MM | 212 | |||||||||
Equity Value Per Share | 61.36 |
What You Will Get
- Pre-Filled Financial Model: Wendy’s actual data provides accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential metrics.
- Instant Calculations: Automatic updates allow you to view results in real-time as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for comprehensive forecasts.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as sales growth, profit margins, and operational costs.
- Instant DCF Valuation: Quickly determines intrinsic value, NPV, and other key metrics.
- High-Precision Accuracy: Incorporates The Wendy's Company's actual financial data for reliable valuation results.
- Simplified Scenario Analysis: Effortlessly evaluate various assumptions and assess different results.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template featuring The Wendy's Company (WEN) data.
- Step 2: Navigate through 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 view updated results, including The Wendy's Company (WEN) intrinsic value.
- Step 5: Make informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for The Wendy's Company (WEN)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for The Wendy's Company (WEN).
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes The Wendy's Company (WEN)'s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide a solid foundation for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business consultants focusing on The Wendy's Company (WEN).
Who Should Use This Product?
- Investors: Make informed decisions with a comprehensive analysis tool tailored for The Wendy's Company (WEN).
- Financial Analysts: Streamline your workflow with a customizable financial model specific to The Wendy's Company (WEN).
- Consultants: Effortlessly modify the template for client reports or presentations focused on The Wendy's Company (WEN).
- Fast Food Enthusiasts: Enhance your knowledge of the fast-food industry and valuation methods through practical examples from The Wendy's Company (WEN).
- Educators and Students: Utilize this resource as a hands-on learning tool in courses related to finance and business analysis, specifically for The Wendy's Company (WEN).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled historical data and forecasts for The Wendy's Company (WEN), including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), featuring parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models that present intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for The Wendy's Company (WEN).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions for easy analysis of results.