ACCO Brands Corporation (ACCO) DCF Valuation

ACCO Brands Corporation (ACCO) 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

ACCO Brands Corporation (ACCO) 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:

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
Account Receivables, % 23.2 21.51 20.55 19.72 23.5
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.

No products were found matching.