|
Aramark (ARMK) DCF Valuation
US | Industrials | Specialty Business Services | NYSE
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Aramark (ARMK) Bundle
Discover Aramark’s (ARMK) true value with our expert-level DCF Calculator! Adjust critical assumptions, explore various scenarios, and evaluate how different factors influence Aramark’s (ARMK) valuation – all within a convenient Excel template.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 12,829.6 | 12,096.0 | 16,326.6 | 18,853.9 | 17,400.7 | 19,011.6 | 20,771.5 | 22,694.4 | 24,795.3 | 27,090.7 |
Revenue Growth, % | 0 | -5.72 | 34.98 | 15.48 | -7.71 | 9.26 | 9.26 | 9.26 | 9.26 | 9.26 |
EBITDA | 310.7 | 580.7 | 1,164.0 | 1,526.1 | 1,167.8 | 1,108.7 | 1,211.3 | 1,323.4 | 1,445.9 | 1,579.8 |
EBITDA, % | 2.42 | 4.8 | 7.13 | 8.09 | 6.71 | 5.83 | 5.83 | 5.83 | 5.83 | 5.83 |
Depreciation | 595.2 | 550.7 | 532.3 | 546.4 | 435.5 | 678.8 | 741.7 | 810.3 | 885.4 | 967.3 |
Depreciation, % | 4.64 | 4.55 | 3.26 | 2.9 | 2.5 | 3.57 | 3.57 | 3.57 | 3.57 | 3.57 |
EBIT | -284.5 | 30.0 | 631.7 | 979.7 | 732.2 | 429.8 | 469.6 | 513.1 | 560.6 | 612.5 |
EBIT, % | -2.22 | 0.24838 | 3.87 | 5.2 | 4.21 | 2.26 | 2.26 | 2.26 | 2.26 | 2.26 |
Total Cash | 2,509.2 | 532.6 | 329.5 | 2,073.9 | 714.8 | 1,562.2 | 1,706.9 | 1,864.9 | 2,037.5 | 2,226.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,431.2 | 1,748.6 | 2,148.0 | 2,363.7 | 2,100.8 | 2,409.8 | 2,632.9 | 2,876.6 | 3,142.9 | 3,433.9 |
Account Receivables, % | 11.16 | 14.46 | 13.16 | 12.54 | 12.07 | 12.68 | 12.68 | 12.68 | 12.68 | 12.68 |
Inventories | 436.5 | 412.7 | 552.4 | 578.4 | 387.6 | 589.1 | 643.6 | 703.2 | 768.3 | 839.4 |
Inventories, % | 3.4 | 3.41 | 3.38 | 3.07 | 2.23 | 3.1 | 3.1 | 3.1 | 3.1 | 3.1 |
Accounts Payable | 610.0 | 859.4 | 1,263.8 | 1,406.4 | 1,394.0 | 1,333.5 | 1,456.9 | 1,591.8 | 1,739.2 | 1,900.2 |
Accounts Payable, % | 4.75 | 7.1 | 7.74 | 7.46 | 8.01 | 7.01 | 7.01 | 7.01 | 7.01 | 7.01 |
Capital Expenditure | -364.4 | -375.3 | -364.8 | -461.4 | .0 | -404.0 | -441.4 | -482.3 | -526.9 | -575.7 |
Capital Expenditure, % | -2.84 | -3.1 | -2.23 | -2.45 | 0 | -2.13 | -2.13 | -2.13 | -2.13 | -2.13 |
Tax Rate, % | 28.05 | 28.05 | 28.05 | 28.05 | 28.05 | 28.05 | 28.05 | 28.05 | 28.05 | 28.05 |
EBITAT | -202.7 | 20.9 | 480.6 | 775.9 | 526.8 | 316.2 | 345.5 | 377.5 | 412.5 | 450.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,229.6 | 152.0 | 513.5 | 761.7 | 1,403.8 | 20.0 | 491.6 | 537.2 | 586.9 | 641.2 |
WACC, % | 9.63 | 9.58 | 9.74 | 9.82 | 9.64 | 9.68 | 9.68 | 9.68 | 9.68 | 9.68 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,643.5 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 660 | |||||||||
Terminal Value | 9,883 | |||||||||
Present Terminal Value | 6,226 | |||||||||
Enterprise Value | 7,869 | |||||||||
Net Debt | 4,894 | |||||||||
Equity Value | 2,975 | |||||||||
Diluted Shares Outstanding, MM | 266 | |||||||||
Equity Value Per Share | 11.18 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real Aramark (ARMK) financials.
- Real-World Data: Historical data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on Aramark’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- 🔍 Real-Life ARMK Financials: Pre-filled historical and projected data for Aramark (ARMK).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Aramark’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Aramark’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Get the pre-built Excel file featuring Aramark's (ARMK) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your analysis needs.
- Real-Time Updates: Observe immediate changes in Aramark’s valuation as you modify inputs.
- Preloaded Data: Comes equipped with Aramark’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for informed decision-making.
Who Should Use This Product?
- Investors: Accurately assess Aramark’s (ARMK) fair value before making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Aramark (ARMK).
- Consultants: Easily customize the template for valuation reports tailored to Aramark (ARMK) clients.
- Entrepreneurs: Discover financial modeling techniques employed by leading companies like Aramark (ARMK).
- Educators: Employ it as a teaching resource to illustrate valuation methodologies relevant to Aramark (ARMK).
What the Template Contains
- Pre-Filled DCF Model: Aramark’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Aramark’s profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.