Coty Inc. (COTY) DCF Valuation

Coty Inc. (COTY) 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

Coty Inc. (COTY) 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:

Looking to assess Coty Inc.'s intrinsic value? Our COTY DCF Calculator integrates real-world data with extensive customization features, enabling you to refine your forecasts and enhance your investment choices.


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 4,717.8 4,629.9 5,304.4 5,554.1 6,118.0 6,539.6 6,990.3 7,472.0 7,986.9 8,537.3
Revenue Growth, % 0 -1.86 14.57 4.71 10.15 6.89 6.89 6.89 6.89 6.89
EBITDA -531.7 603.6 856.3 964.7 849.1 642.9 687.3 734.6 785.2 839.4
EBITDA, % -11.27 13.04 16.14 17.37 13.88 9.83 9.83 9.83 9.83 9.83
Depreciation 716.5 585.3 516.4 426.7 421.1 681.8 728.8 779.0 832.7 890.1
Depreciation, % 15.19 12.64 9.74 7.68 6.88 10.43 10.43 10.43 10.43 10.43
EBIT -1,248.2 18.3 339.9 538.0 428.0 -38.9 -41.5 -44.4 -47.5 -50.7
EBIT, % -26.46 0.39526 6.41 9.69 7 -0.59436 -0.59436 -0.59436 -0.59436 -0.59436
Total Cash 308.3 253.5 233.3 246.9 300.8 337.1 360.3 385.1 411.7 440.0
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 440.1 348.0 434.8 612.5 481.6
Account Receivables, % 9.33 7.52 8.2 11.03 7.87
Inventories 678.2 650.8 661.5 853.4 764.1 899.3 961.3 1,027.5 1,098.3 1,174.0
Inventories, % 14.38 14.06 12.47 15.37 12.49 13.75 13.75 13.75 13.75 13.75
Accounts Payable 1,190.3 1,166.1 1,268.3 1,444.7 1,405.6 1,612.8 1,724.0 1,842.8 1,969.8 2,105.5
Accounts Payable, % 25.23 25.19 23.91 26.01 22.97 24.66 24.66 24.66 24.66 24.66
Capital Expenditure -267.4 -173.9 -174.1 -222.8 -245.2 -271.1 -289.8 -309.7 -331.1 -353.9
Capital Expenditure, % -5.67 -3.76 -3.28 -4.01 -4.01 -4.15 -4.15 -4.15 -4.15 -4.15
Tax Rate, % 56.28 56.28 56.28 56.28 56.28 56.28 56.28 56.28 56.28 56.28
EBITAT -927.0 5.2 206.7 387.9 187.1 -21.7 -23.2 -24.8 -26.5 -28.3
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -405.9 511.9 553.7 398.6 544.1 368.0 425.4 454.7 486.1 519.6
WACC, % 9.77 8.66 9.44 9.71 9.03 9.32 9.32 9.32 9.32 9.32
PV UFCF
SUM PV UFCF 1,713.6
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 530
Terminal Value 7,238
Present Terminal Value 4,635
Enterprise Value 6,349
Net Debt 3,963
Equity Value 2,386
Diluted Shares Outstanding, MM 883
Equity Value Per Share 2.70

What You Will Get

  • Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real COTY financials.
  • Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
  • Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Automatic Calculations: Instantly observe the effects of your inputs on Coty’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

  • Pre-Loaded Data: Coty Inc.'s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
  • Instant Results: View Coty Inc.'s intrinsic value recalculating in real time.
  • Clear Visual Outputs: Dashboard charts illustrate valuation results and key performance metrics.
  • Built for Accuracy: A professional tool designed for analysts, investors, and finance specialists.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered Coty Inc. (COTY) data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for Coty Inc. (COTY)’s intrinsic value.
  5. Step 5: Use the outputs for investment decisions or reporting.

Why Choose This Calculator for Coty Inc. (COTY)?

  • User-Friendly Interface: Tailored for both novice users and seasoned professionals.
  • Customizable Inputs: Easily adjust parameters to suit your financial analysis.
  • Real-Time Feedback: Watch Coty Inc.'s valuation change instantly as you modify inputs.
  • Preloaded Data: Comes with Coty Inc.'s current financial information for swift evaluations.
  • Relied Upon by Experts: Utilized by investors and financial analysts for making strategic decisions.

Who Should Use This Product?

  • Individual Investors: Make informed decisions about buying or selling Coty Inc. (COTY) stock.
  • Financial Analysts: Streamline valuation processes with ready-to-use financial models for Coty Inc. (COTY).
  • Consultants: Deliver professional valuation insights for Coty Inc. (COTY) to clients quickly and accurately.
  • Business Owners: Understand how companies like Coty Inc. (COTY) are valued to guide your own strategy.
  • Finance Students: Learn valuation techniques using real-world data and scenarios from Coty Inc. (COTY).

What the Template Contains

  • Historical Data: Includes Coty Inc.'s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate Coty Inc.'s intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of Coty Inc.'s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.