Arcos Dorados Holdings Inc. (ARCO) 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
Arcos Dorados Holdings Inc. (ARCO) Bundle
Streamline your analysis and improve precision with our (ARCO) DCF Calculator! Equipped with up-to-date Arcos Dorados data and customizable assumptions, this tool empowers you to forecast, assess, and value Arcos Dorados Holdings Inc. like a seasoned investor.
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 | 2,959.1 | 1,984.2 | 2,659.9 | 3,618.9 | 4,331.9 | 4,947.7 | 5,651.1 | 6,454.4 | 7,371.9 | 8,419.9 |
| Revenue Growth, % | 0 | -32.94 | 34.05 | 36.05 | 19.7 | 14.22 | 14.22 | 14.22 | 14.22 | 14.22 |
| EBITDA | 284.0 | 51.5 | 244.7 | 386.2 | 459.7 | 422.3 | 482.3 | 550.9 | 629.2 | 718.7 |
| EBITDA, % | 9.6 | 2.6 | 9.2 | 10.67 | 10.61 | 8.54 | 8.54 | 8.54 | 8.54 | 8.54 |
| Depreciation | 123.2 | 126.9 | 120.4 | 119.8 | 149.3 | 216.1 | 246.8 | 281.9 | 322.0 | 367.8 |
| Depreciation, % | 4.16 | 6.39 | 4.53 | 3.31 | 3.45 | 4.37 | 4.37 | 4.37 | 4.37 | 4.37 |
| EBIT | 160.8 | -75.3 | 124.3 | 266.5 | 310.4 | 206.2 | 235.5 | 269.0 | 307.2 | 350.9 |
| EBIT, % | 5.43 | -3.8 | 4.67 | 7.36 | 7.17 | 4.17 | 4.17 | 4.17 | 4.17 | 4.17 |
| Total Cash | 121.9 | 166.0 | 278.8 | 304.4 | 246.8 | 366.9 | 419.0 | 478.6 | 546.6 | 624.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 128.0 | 114.2 | 104.2 | 151.1 | 186.7 | 222.5 | 254.1 | 290.2 | 331.5 | 378.6 |
| Account Receivables, % | 4.33 | 5.76 | 3.92 | 4.17 | 4.31 | 4.5 | 4.5 | 4.5 | 4.5 | 4.5 |
| Inventories | 37.8 | 33.6 | 37.8 | 50.1 | 52.8 | 69.2 | 79.1 | 90.3 | 103.1 | 117.8 |
| Inventories, % | 1.28 | 1.69 | 1.42 | 1.38 | 1.22 | 1.4 | 1.4 | 1.4 | 1.4 | 1.4 |
| Accounts Payable | 259.6 | 209.5 | 269.2 | 353.5 | 375.0 | 473.8 | 541.1 | 618.0 | 705.9 | 806.2 |
| Accounts Payable, % | 8.77 | 10.56 | 10.12 | 9.77 | 8.66 | 9.58 | 9.58 | 9.58 | 9.58 | 9.58 |
| Capital Expenditure | -265.2 | -86.3 | -115.0 | -217.1 | -360.1 | -316.1 | -361.1 | -412.4 | -471.1 | -538.0 |
| Capital Expenditure, % | -8.96 | -4.35 | -4.32 | -6 | -8.31 | -6.39 | -6.39 | -6.39 | -6.39 | -6.39 |
| Tax Rate, % | 34.82 | 34.82 | 34.82 | 34.82 | 34.82 | 34.82 | 34.82 | 34.82 | 34.82 | 34.82 |
| EBITAT | 108.0 | -85.4 | 72.7 | 165.2 | 202.3 | 145.5 | 166.2 | 189.8 | 216.8 | 247.6 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 59.7 | -76.8 | 143.5 | 93.0 | -25.4 | 92.0 | 77.8 | 88.9 | 101.5 | 115.9 |
| WACC, % | 6.28 | 7.05 | 6.08 | 6.16 | 6.23 | 6.36 | 6.36 | 6.36 | 6.36 | 6.36 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 393.6 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 119 | |||||||||
| Terminal Value | 3,553 | |||||||||
| Present Terminal Value | 2,611 | |||||||||
| Enterprise Value | 3,004 | |||||||||
| Net Debt | 1,494 | |||||||||
| Equity Value | 1,510 | |||||||||
| Diluted Shares Outstanding, MM | 211 | |||||||||
| Equity Value Per Share | 7.17 |
What You Will Get
- Real ARCO Financial Data: Pre-filled with Arcos Dorados’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Arcos Dorados’ intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- 🔍 Real-Life ARCO Financials: Pre-filled historical and projected data for Arcos Dorados Holdings Inc. (ARCO).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Arcos Dorados' intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Arcos Dorados' valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Access the ready-to-use Excel file containing Arcos Dorados Holdings Inc.'s (ARCO) financial data.
- Customize: Modify forecasts such as revenue growth, EBITDA %, and WACC to suit your analysis.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly compare the outcomes.
- Make Decisions: Leverage the valuation results to inform your investment strategy.
Why Choose This Calculator for Arcos Dorados Holdings Inc. (ARCO)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for Arcos Dorados.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Arcos Dorados’ intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable benchmarks.
- Expert-Level Tool: Perfect for financial analysts, investors, and business consultants focused on Arcos Dorados.
Who Should Use This Product?
- Investors: Accurately estimate Arcos Dorados Holdings Inc.'s (ARCO) fair value before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis related to Arcos Dorados Holdings Inc. (ARCO).
- Consultants: Quickly customize the template for valuation reports for clients focusing on Arcos Dorados Holdings Inc. (ARCO).
- Entrepreneurs: Gain insights into financial modeling practices used by leading companies like Arcos Dorados Holdings Inc. (ARCO).
- Educators: Employ it as a teaching tool to demonstrate valuation methodologies relevant to Arcos Dorados Holdings Inc. (ARCO).
What the Template Contains
- Pre-Filled Data: Includes Arcos Dorados Holdings Inc.’s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Arcos Dorados Holdings Inc.’s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.