ACCO Brands Corporation (ACCO) 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
ACCO Brands Corporation (ACCO) Bundle
Explore ACCO Brands Corporation's (ACCO) financial potential with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate ACCO's intrinsic value and refine your investment approach.
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 | 1,955.7 | 1,655.2 | 2,025.3 | 1,947.6 | 1,832.8 | 1,820.3 | 1,807.8 | 1,795.4 | 1,783.2 | 1,771.0 |
Revenue Growth, % | 0 | -15.37 | 22.36 | -3.84 | -5.89 | -0.6841 | -0.6841 | -0.6841 | -0.6841 | -0.6841 |
EBITDA | 277.0 | 188.1 | 243.4 | 139.9 | 121.6 | 187.0 | 185.7 | 184.4 | 183.2 | 181.9 |
EBITDA, % | 14.16 | 11.36 | 12.02 | 7.18 | 6.63 | 10.27 | 10.27 | 10.27 | 10.27 | 10.27 |
Depreciation | 70.3 | 70.7 | 85.7 | 79.4 | 76.1 | 74.0 | 73.5 | 73.0 | 72.5 | 72.0 |
Depreciation, % | 3.59 | 4.27 | 4.23 | 4.08 | 4.15 | 4.07 | 4.07 | 4.07 | 4.07 | 4.07 |
EBIT | 206.7 | 117.4 | 157.7 | 60.5 | 45.5 | 113.0 | 112.2 | 111.5 | 110.7 | 109.9 |
EBIT, % | 10.57 | 7.09 | 7.79 | 3.11 | 2.48 | 6.21 | 6.21 | 6.21 | 6.21 | 6.21 |
Total Cash | 27.8 | 36.6 | 41.2 | 62.2 | 66.4 | 45.4 | 45.1 | 44.8 | 44.5 | 44.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 453.7 | 356.0 | 416.1 | 384.1 | 430.7 | 394.9 | 392.2 | 389.5 | 386.9 | 384.2 |
Account Receivables, % | 23.2 | 21.51 | 20.55 | 19.72 | 23.5 | 21.69 | 21.69 | 21.69 | 21.69 | 21.69 |
Inventories | 283.3 | 305.1 | 428.0 | 395.2 | 327.5 | 335.7 | 333.4 | 331.1 | 328.9 | 326.6 |
Inventories, % | 14.49 | 18.43 | 21.13 | 20.29 | 17.87 | 18.44 | 18.44 | 18.44 | 18.44 | 18.44 |
Accounts Payable | 245.7 | 180.2 | 308.2 | 239.5 | 183.7 | 222.0 | 220.5 | 219.0 | 217.5 | 216.0 |
Accounts Payable, % | 12.56 | 10.89 | 15.22 | 12.3 | 10.02 | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 |
Capital Expenditure | -32.8 | -15.3 | -21.2 | -16.5 | -13.8 | -19.1 | -19.0 | -18.8 | -18.7 | -18.6 |
Capital Expenditure, % | -1.68 | -0.92436 | -1.05 | -0.8472 | -0.75295 | -1.05 | -1.05 | -1.05 | -1.05 | -1.05 |
Tax Rate, % | -66.41 | -66.41 | -66.41 | -66.41 | -66.41 | -66.41 | -66.41 | -66.41 | -66.41 | -66.41 |
EBITAT | 135.0 | 92.6 | 144.3 | -53.6 | 75.7 | 75.9 | 75.3 | 74.8 | 74.3 | 73.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -318.8 | 158.4 | 153.8 | 5.4 | 103.3 | 196.7 | 133.3 | 132.4 | 131.5 | 130.6 |
WACC, % | 6.51 | 7.03 | 7.52 | 3.98 | 7.85 | 6.58 | 6.58 | 6.58 | 6.58 | 6.58 |
PV UFCF | ||||||||||
SUM PV UFCF | 608.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 133 | |||||||||
Terminal Value | 2,911 | |||||||||
Present Terminal Value | 2,117 | |||||||||
Enterprise Value | 2,725 | |||||||||
Net Debt | 950 | |||||||||
Equity Value | 1,775 | |||||||||
Diluted Shares Outstanding, MM | 95 | |||||||||
Equity Value Per Share | 18.63 |
What You Will Get
- Real ACCO Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Explore various scenarios to assess ACCO's future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Accurate ACCO Financials: Gain access to reliable pre-loaded historical data and forward-looking projections.
- Customizable Forecast Inputs: Modify highlighted cells for WACC, growth rates, and profit margins.
- Real-time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Intuitive Visual Dashboard: User-friendly charts and summaries to help visualize your valuation outcomes.
- Designed for All Users: A straightforward, user-friendly layout tailored for investors, CFOs, and consultants.
How It Works
- 1. Access the Template: Download and open the Excel file containing ACCO Brands Corporation’s (ACCO) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures to fit your analysis.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV based on your inputs.
- 4. Explore Scenarios: Evaluate various forecasts to examine different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to bolster your decision-making process.
Why Choose This Calculator for ACCO Brands Corporation (ACCO)?
- Accuracy: Utilizes real ACCO financials to ensure precise data.
- Flexibility: Allows users to easily test and modify inputs as needed.
- Time-Saving: Eliminates the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use ACCO Brands Corporation (ACCO)?
- Investors: Make informed decisions with a reliable valuation tool tailored for ACCO.
- Financial Analysts: Streamline your workflow with a customizable DCF model specifically for ACCO.
- Consultants: Effortlessly modify the template for client presentations or reports related to ACCO.
- Finance Enthusiasts: Enhance your knowledge of valuation methods through real-world insights on ACCO.
- Educators and Students: Utilize it as a practical resource in finance courses focused on ACCO and its market.
What the Template Contains
- Pre-Filled Data: Includes ACCO Brands Corporation’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 ACCO’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.