Restaurant Brands International Inc. (QSR) 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
Restaurant Brands International Inc. (QSR) Bundle
Evaluate the financial outlook of Restaurant Brands International Inc. (QSR) with expert precision! This (QSR) DCF Calculator provides you with pre-filled financial data and full flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your projections.
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 | 5,603.0 | 4,968.0 | 5,739.0 | 6,505.0 | 7,022.0 | 7,469.3 | 7,945.1 | 8,451.3 | 8,989.6 | 9,562.3 |
| Revenue Growth, % | 0 | -11.33 | 15.52 | 13.35 | 7.95 | 6.37 | 6.37 | 6.37 | 6.37 | 6.37 |
| EBITDA | 2,212.0 | 1,779.0 | 2,125.0 | 2,213.0 | 2,239.0 | 2,662.4 | 2,832.0 | 3,012.4 | 3,204.3 | 3,408.4 |
| EBITDA, % | 39.48 | 35.81 | 37.03 | 34.02 | 31.89 | 35.64 | 35.64 | 35.64 | 35.64 | 35.64 |
| Depreciation | 189.3 | 199.0 | 199.2 | 182.5 | 191.0 | 244.7 | 260.3 | 276.9 | 294.5 | 313.3 |
| Depreciation, % | 3.38 | 4.01 | 3.47 | 2.81 | 2.72 | 3.28 | 3.28 | 3.28 | 3.28 | 3.28 |
| EBIT | 2,022.7 | 1,580.0 | 1,925.8 | 2,030.5 | 2,048.0 | 2,417.7 | 2,571.7 | 2,735.5 | 2,909.8 | 3,095.1 |
| EBIT, % | 36.1 | 31.8 | 33.56 | 31.21 | 29.17 | 32.37 | 32.37 | 32.37 | 32.37 | 32.37 |
| Total Cash | 1,533.0 | 1,560.0 | 1,087.0 | 1,178.0 | 1,139.0 | 1,673.6 | 1,780.2 | 1,893.6 | 2,014.2 | 2,142.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 527.0 | 536.0 | 547.0 | 614.0 | 749.0 | 744.4 | 791.8 | 842.3 | 895.9 | 953.0 |
| Account Receivables, % | 9.41 | 10.79 | 9.53 | 9.44 | 10.67 | 9.97 | 9.97 | 9.97 | 9.97 | 9.97 |
| Inventories | 84.0 | 96.0 | 96.0 | 133.0 | 166.0 | 142.1 | 151.2 | 160.8 | 171.0 | 181.9 |
| Inventories, % | 1.5 | 1.93 | 1.67 | 2.04 | 2.36 | 1.9 | 1.9 | 1.9 | 1.9 | 1.9 |
| Accounts Payable | 644.0 | 464.0 | 614.0 | 758.0 | 790.0 | 813.2 | 865.0 | 920.1 | 978.7 | 1,041.1 |
| Accounts Payable, % | 11.49 | 9.34 | 10.7 | 11.65 | 11.25 | 10.89 | 10.89 | 10.89 | 10.89 | 10.89 |
| Capital Expenditure | -62.0 | -117.0 | -106.0 | -100.0 | -120.0 | -127.8 | -135.9 | -144.6 | -153.8 | -163.6 |
| Capital Expenditure, % | -1.11 | -2.36 | -1.85 | -1.54 | -1.71 | -1.71 | -1.71 | -1.71 | -1.71 | -1.71 |
| Tax Rate, % | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 | 18.1 |
| EBITAT | 1,547.7 | 1,452.2 | 1,770.4 | 2,204.6 | 1,677.3 | 2,138.5 | 2,274.7 | 2,419.6 | 2,573.7 | 2,737.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,708.0 | 1,333.2 | 2,002.6 | 2,327.0 | 1,612.3 | 2,307.0 | 2,394.4 | 2,546.9 | 2,709.1 | 2,881.7 |
| WACC, % | 7.16 | 7.39 | 7.39 | 7.51 | 7.24 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 10,350.2 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 2,968 | |||||||||
| Terminal Value | 68,418 | |||||||||
| Present Terminal Value | 48,017 | |||||||||
| Enterprise Value | 58,368 | |||||||||
| Net Debt | 13,376 | |||||||||
| Equity Value | 44,992 | |||||||||
| Diluted Shares Outstanding, MM | 456 | |||||||||
| Equity Value Per Share | 98.67 |
What You Will Get
- Authentic QSR Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust parameters like WACC, tax rates, revenue growth, and capital expenditures.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Explore various scenarios to assess Restaurant Brands International Inc.'s future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Financial Data: Access reliable historical performance and future forecasts for Restaurant Brands International Inc. (QSR).
- Adjustable Forecast Variables: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Real-Time Calculations: Instant updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively present your valuation findings.
- Designed for All Skill Levels: A straightforward, intuitive layout ideal for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-formulated Excel file containing Restaurant Brands International Inc.'s (QSR) financial data.
- Customize: Modify projections, including sales growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare results.
- Make Decisions: Utilize the valuation insights to inform your investment strategy.
Why Choose Restaurant Brands International Inc. (QSR)?
- Global Presence: Benefit from a strong portfolio of well-known brands across the globe.
- Proven Business Model: Leverage a successful franchise system that drives growth and profitability.
- Commitment to Innovation: Stay ahead with continuous menu development and technology enhancements.
- Focus on Quality: Enjoy high standards in food quality and customer service.
- Backed by Expertise: Rely on a management team with extensive industry experience and knowledge.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Restaurant Brands International Inc. (QSR) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to the fast-food industry.
- Consultants: Provide clients with accurate valuation insights for quick decision-making regarding Restaurant Brands International Inc. (QSR).
- Business Owners: Gain insights into how major companies like Restaurant Brands International Inc. (QSR) are valued to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data and scenarios related to the restaurant sector.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations.
- Real-World Data: Restaurant Brands International Inc.’s (QSR) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for in-depth insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results.