Arko Corp. (ARKO) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Arko Corp. (ARKO) Bundle
Gain insight into your Arko Corp. (ARKO) valuation analysis with our state-of-the-art DCF Calculator! This Excel template comes preloaded with real ARKO data, enabling you to adjust forecasts and assumptions to accurately determine Arko Corp.'s intrinsic value.
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 | 4,128.7 | 3,910.7 | 7,417.4 | 9,142.8 | 9,412.7 | 12,015.4 | 15,337.8 | 19,578.8 | 24,992.5 | 31,903.1 |
Revenue Growth, % | 0 | -5.28 | 89.67 | 23.26 | 2.95 | 27.65 | 27.65 | 27.65 | 27.65 | 27.65 |
EBITDA | 65.2 | 155.7 | 235.7 | 269.5 | 260.4 | 347.3 | 443.3 | 565.9 | 722.3 | 922.1 |
EBITDA, % | 1.58 | 3.98 | 3.18 | 2.95 | 2.77 | 2.89 | 2.89 | 2.89 | 2.89 | 2.89 |
Depreciation | 62.4 | 74.4 | 97.2 | 101.8 | 127.6 | 172.8 | 220.6 | 281.6 | 359.5 | 458.9 |
Depreciation, % | 1.51 | 1.9 | 1.31 | 1.11 | 1.36 | 1.44 | 1.44 | 1.44 | 1.44 | 1.44 |
EBIT | 2.8 | 81.3 | 138.5 | 167.8 | 132.8 | 174.4 | 222.7 | 284.2 | 362.8 | 463.1 |
EBIT, % | 0.0672126 | 2.08 | 1.87 | 1.83 | 1.41 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 |
Total Cash | 32.1 | 293.7 | 310.9 | 300.9 | 222.0 | 435.7 | 556.1 | 709.9 | 906.2 | 1,156.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 59.8 | 46.9 | 62.3 | 118.1 | 200.3 | 166.1 | 212.0 | 270.6 | 345.4 | 440.9 |
Account Receivables, % | 1.45 | 1.2 | 0.84048 | 1.29 | 2.13 | 1.38 | 1.38 | 1.38 | 1.38 | 1.38 |
Inventories | 157.8 | 163.7 | 197.8 | 222.0 | 250.6 | 378.8 | 483.6 | 617.3 | 787.9 | 1,005.8 |
Inventories, % | 3.82 | 4.19 | 2.67 | 2.43 | 2.66 | 3.15 | 3.15 | 3.15 | 3.15 | 3.15 |
Accounts Payable | 128.8 | 155.7 | 172.9 | 217.4 | 213.7 | 338.4 | 431.9 | 551.4 | 703.8 | 898.4 |
Accounts Payable, % | 3.12 | 3.98 | 2.33 | 2.38 | 2.27 | 2.82 | 2.82 | 2.82 | 2.82 | 2.82 |
Capital Expenditure | -58.3 | -44.7 | -226.5 | -98.8 | -111.2 | -189.1 | -241.4 | -308.1 | -393.3 | -502.0 |
Capital Expenditure, % | -1.41 | -1.14 | -3.05 | -1.08 | -1.18 | -1.57 | -1.57 | -1.57 | -1.57 | -1.57 |
Tax Rate, % | 26.52 | 26.52 | 26.52 | 26.52 | 26.52 | 26.52 | 26.52 | 26.52 | 26.52 | 26.52 |
EBITAT | 3.2 | 85.4 | 115.7 | 111.9 | 97.6 | 147.8 | 188.7 | 240.8 | 307.4 | 392.5 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -81.4 | 148.9 | -45.9 | 79.4 | -.5 | 162.3 | 110.9 | 141.5 | 180.6 | 230.6 |
WACC, % | 4.97 | 4.97 | 4.41 | 3.83 | 4.06 | 4.45 | 4.45 | 4.45 | 4.45 | 4.45 |
PV UFCF | ||||||||||
SUM PV UFCF | 718.5 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 235 | |||||||||
Terminal Value | 9,613 | |||||||||
Present Terminal Value | 7,734 | |||||||||
Enterprise Value | 8,452 | |||||||||
Net Debt | 2,312 | |||||||||
Equity Value | 6,141 | |||||||||
Diluted Shares Outstanding, MM | 120 | |||||||||
Equity Value Per Share | 51.34 |
What You Will Get
- Real ARKO Financial Data: Pre-filled with Arko Corp.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Arko Corp.’s 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
- Comprehensive DCF Calculator: Offers both unlevered and levered DCF valuation models tailored for Arko Corp. (ARKO).
- WACC Estimator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Inputs: Adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Arko Corp. (ARKO).
- Visual Dashboard and Charts: Graphical representations that succinctly highlight essential valuation metrics for straightforward analysis.
How It Works
- 1. Access the Template: Download and open the Excel file containing Arko Corp.’s (ARKO) financial data.
- 2. Modify Assumptions: Adjust key variables such as growth projections, WACC, and capital investments.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to understand different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation analyses to back your strategic decisions.
Why Choose Arko Corp. (ARKO) Calculator?
- All-in-One Solution: Features DCF, WACC, and financial ratio assessments in a single interface.
- Flexible Inputs: Modify yellow-highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Arko Corp.’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide a solid foundation for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use Arko Corp. (ARKO)?
- Finance Students: Explore financial modeling techniques and apply them to real-world scenarios.
- Academics: Utilize industry-standard models for research and teaching purposes.
- Investors: Validate your investment strategies and evaluate the performance of Arko Corp. (ARKO).
- Analysts: Enhance your analysis with a flexible, pre-designed DCF model tailored for Arko Corp. (ARKO).
- Small Business Owners: Understand the analytical frameworks used to assess larger companies like Arko Corp. (ARKO).
What the Template Contains
- Preloaded ARKO Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.