Restaurant Brands International Inc. (QSR) DCF Valuation

Restaurant Brands International Inc. (QSR) DCF Valuation
  • ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
  • ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
  • ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
  • ✓ No Se Necesita Experiencia; Fáciles De Seguir

Restaurant Brands International Inc. (QSR) 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:

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
Account Receivables, % 9.41 10.79 9.53 9.44 10.67
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.

No products were found matching.