Alcoa Corporation (AA) DCF Valuation

Alcoa Corporation (AA) DCF Valuation
  • ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • ✓ Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • ✓ Pré-Construídos Para Uso Rápido E Eficiente
  • ✓ Não É Necessária Experiência; Fácil De Seguir

Alcoa Corporation (AA) 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:

Enhance your investment strategies with the Alcoa Corporation (AA) DCF Calculator! Examine authentic Alcoa financials, adjust growth predictions and expenses, and instantly observe how these modifications affect the intrinsic value of Alcoa Corporation (AA).


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 10,495.0 9,372.0 12,437.0 12,762.0 10,551.0 10,743.3 10,939.2 11,138.6 11,341.6 11,548.4
Revenue Growth, % 0 -10.7 32.7 2.61 -17.32 1.82 1.82 1.82 1.82 1.82
EBITDA 396.0 1,024.0 2,745.0 2,030.0 155.0 1,163.4 1,184.6 1,206.2 1,228.2 1,250.6
EBITDA, % 3.77 10.93 22.07 15.91 1.47 10.83 10.83 10.83 10.83 10.83
Depreciation 713.0 653.0 664.0 617.0 632.0 643.0 654.7 666.6 678.8 691.2
Depreciation, % 6.79 6.97 5.34 4.83 5.99 5.98 5.98 5.98 5.98 5.98
EBIT -317.0 371.0 2,081.0 1,413.0 -477.0 520.4 529.9 539.6 549.4 559.4
EBIT, % -3.02 3.96 16.73 11.07 -4.52 4.84 4.84 4.84 4.84 4.84
Total Cash 879.0 1,607.0 1,814.0 1,363.0 944.0 1,283.5 1,306.9 1,330.7 1,355.0 1,379.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 660.0 556.0 884.0 909.0 808.0
Account Receivables, % 6.29 5.93 7.11 7.12 7.66
Inventories 1,644.0 1,398.0 1,956.0 2,427.0 2,158.0 1,843.1 1,876.7 1,910.9 1,945.8 1,981.2
Inventories, % 15.66 14.92 15.73 19.02 20.45 17.16 17.16 17.16 17.16 17.16
Accounts Payable 1,484.0 1,403.0 1,674.0 1,757.0 1,714.0 1,559.6 1,588.0 1,616.9 1,646.4 1,676.4
Accounts Payable, % 14.14 14.97 13.46 13.77 16.24 14.52 14.52 14.52 14.52 14.52
Capital Expenditure -379.0 -353.0 -390.0 -480.0 -531.0 -414.9 -422.4 -430.1 -438.0 -445.9
Capital Expenditure, % -3.61 -3.77 -3.14 -3.76 -5.03 -3.86 -3.86 -3.86 -3.86 -3.86
Tax Rate, % -11.47 -11.47 -11.47 -11.47 -11.47 -11.47 -11.47 -11.47 -11.47 -11.47
EBITAT -617.4 -30.0 744.6 115.3 -531.7 253.9 258.5 263.3 268.1 272.9
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -1,103.4 539.0 403.6 -160.7 -103.7 717.6 472.3 480.9 489.7 498.6
WACC, % 13.58 12.34 12.79 12.44 13.58 12.95 12.95 12.95 12.95 12.95
PV UFCF
SUM PV UFCF 1,911.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 509
Terminal Value 4,645
Present Terminal Value 2,527
Enterprise Value 4,438
Net Debt 971
Equity Value 3,467
Diluted Shares Outstanding, MM 178
Equity Value Per Share 19.48

What You Will Receive

  • Authentic AA Financial Data: Pre-populated with Alcoa’s historical and projected figures for thorough analysis.
  • Completely Customizable Template: Easily adjust key inputs such as revenue growth, WACC, and EBITDA %.
  • Instant Calculations: Watch Alcoa’s intrinsic value change in real-time based on your modifications.
  • Expert Valuation Tool: Tailored for investors, analysts, and consultants aiming for precise DCF outcomes.
  • Intuitive Design: Clear layout and straightforward instructions suitable for all skill levels.

Key Features

  • Pre-Loaded Data: Alcoa Corporation’s historical financial statements and pre-filled forecasts.
  • Fully Adjustable Inputs: Edit WACC, tax rates, revenue growth, and EBITDA margins.
  • Instant Results: See Alcoa Corporation’s intrinsic value recalculate in real time.
  • Clear Visual Outputs: Dashboard charts display valuation results and key metrics.
  • Built for Accuracy: A professional tool for analysts, investors, and finance experts.

How It Works

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

Why Choose the Alcoa Corporation (AA) Calculator?

  • Precision: Utilizes real Alcoa financial data to ensure accuracy.
  • Adaptability: Built for users to easily adjust and experiment with inputs.
  • Efficiency: Eliminate the need to create a DCF model from the ground up.
  • Expert-Level: Crafted with the precision and functionality expected from CFOs.
  • Intuitive: Simple to navigate, even for those without extensive financial modeling skills.

Who Should Use This Product?

  • Investors: Assess Alcoa Corporation’s (AA) valuation prior to making investment decisions.
  • CFOs and Financial Analysts: Enhance valuation methods and evaluate financial forecasts.
  • Startup Founders: Discover the valuation strategies of established companies like Alcoa Corporation.
  • Consultants: Provide detailed valuation analyses for your clients regarding Alcoa Corporation.
  • Students and Educators: Utilize current data to learn and teach valuation principles through Alcoa Corporation.

What the Template Contains

  • Pre-Filled Data: Contains Alcoa Corporation's historical financials and projections.
  • Discounted Cash Flow Model: An editable DCF valuation model featuring automatic calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC using custom inputs.
  • Key Financial Ratios: Evaluate Alcoa’s profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily modify revenue growth, margins, and tax rates.
  • Clear Dashboard: Visual representations including charts and tables summarizing key valuation outcomes.

No products were found matching.