First Citizens BancShares, Inc. (FCNCA) DCF Valuation

First Citizens Bancshares, Inc. (FCNCA) Valoración de DCF

US | Financial Services | Banks - Regional | NASDAQ
First Citizens BancShares, Inc. (FCNCA) 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

First Citizens BancShares, Inc. (FCNCA) Bundle

Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Diseñada para la precisión, nuestra calculadora DCF (FCNCA) le permite evaluar la valoración de First Citizens Bancshares, Inc. utilizando datos financieros del mundo real, ofreciendo una flexibilidad completa para modificar todos los parámetros esenciales para mejorar las proyecciones.


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,727.2 1,864.9 1,838.6 4,541.0 7,604.0 10,912.0 15,659.0 22,471.2 32,246.8 46,275.1
Revenue Growth, % 0 7.97 -1.41 146.98 67.45 43.5 43.5 43.5 43.5 43.5
EBITDA 700.8 719.4 814.1 864.0 371.0 3,215.4 4,614.3 6,621.6 9,502.2 13,636.0
EBITDA, % 40.57 38.58 44.28 19.03 4.88 29.47 29.47 29.47 29.47 29.47
Depreciation 127.7 141.4 132.2 533.0 314.0 830.0 1,191.1 1,709.3 2,452.8 3,519.9
Depreciation, % 7.39 7.58 7.19 11.74 4.13 7.61 7.61 7.61 7.61 7.61
EBIT 573.1 578.0 682.0 331.0 57.0 2,385.4 3,423.2 4,912.3 7,049.4 10,116.0
EBIT, % 33.18 30.99 37.09 7.29 0.74961 21.86 21.86 21.86 21.86 21.86
Total Cash 1,484.6 4,709.4 18,655.9 518.0 908.0 6,750.1 9,686.6 13,900.6 19,947.8 28,625.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables .0 145.7 134.2 .0 .0
Account Receivables, % 0 7.81 7.3 0 0
Inventories -1,654.3 -4,906.0 -10,462.3 -9,165.0 .0 -8,637.4 -12,395.0 -17,787.2 -25,525.1 -36,629.4
Inventories, % -95.78 -263.07 -569.04 -201.83 0 -79.16 -79.16 -79.16 -79.16 -79.16
Accounts Payable .0 .0 .0 57.0 137.0 66.7 95.7 137.4 197.2 282.9
Accounts Payable, % 0 0 0 1.26 1.8 0.61138 0.61138 0.61138 0.61138 0.61138
Capital Expenditure -121.1 -133.4 -107.4 -926.0 -1,428.0 -1,291.4 -1,853.2 -2,659.4 -3,816.3 -5,476.5
Capital Expenditure, % -7.01 -7.15 -5.84 -20.39 -18.78 -11.83 -11.83 -11.83 -11.83 -11.83
Tax Rate, % 5.06 5.06 5.06 5.06 5.06 5.06 5.06 5.06 5.06 5.06
EBITAT 442.7 460.2 531.6 266.8 54.1 1,957.9 2,809.7 4,032.0 5,786.0 8,303.1
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF 2,103.7 3,574.3 6,124.3 -1,232.3 -10,144.9 9,733.9 5,790.7 8,309.8 11,924.8 17,112.5
WACC, % 7.88 8 7.92 8.06 8.83 8.14 8.14 8.14 8.14 8.14
PV UFCF
SUM PV UFCF 40,819.7
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 17,455
Terminal Value 284,459
Present Terminal Value 192,383
Enterprise Value 233,202
Net Debt 3,048
Equity Value 230,154
Diluted Shares Outstanding, MM 15
Equity Value Per Share 15,829.47

What You Will Receive

  • Adjustable Forecast Parameters: Effortlessly modify key assumptions (growth %, margins, WACC) to explore various scenarios.
  • Comprehensive Financial Data: First Citizens BancShares, Inc.’s (FCNCA) financial information pre-loaded to facilitate your analysis.
  • Instant DCF Calculations: The template automatically computes Net Present Value (NPV) and intrinsic value for your convenience.
  • Tailored and Professional Design: A sleek Excel model that can be customized to suit your valuation requirements.
  • Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation frameworks.
  • WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to First Citizens BancShares, Inc. (FCNCA).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.

How It Works

  • 1. Access the Template: Download and open the Excel file containing First Citizens BancShares, Inc. (FCNCA) preloaded data.
  • 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
  • 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
  • 5. Present with Assurance: Share professional valuation findings to strengthen your decision-making process.

Why Choose First Citizens BancShares, Inc. (FCNCA)?

  • Time Efficient: Access comprehensive financial insights without the hassle of building models from the ground up.
  • Enhanced Precision: Utilize trustworthy financial data and methodologies to minimize valuation discrepancies.
  • Completely Adaptable: Modify the framework to align with your specific assumptions and forecasts.
  • User-Friendly: Intuitive visualizations and outputs simplify the analysis of results.
  • Endorsed by Professionals: Crafted for experts who prioritize accuracy and ease of use.

Who Should Use This Product?

  • Professional Investors: Construct comprehensive and accurate valuation models for analyzing FCNCA's portfolio.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights to clients regarding First Citizens BancShares, Inc. (FCNCA).
  • Students and Educators: Utilize real-time data for practicing and teaching financial modeling techniques.
  • Banking Enthusiasts: Gain an understanding of how financial institutions like First Citizens BancShares, Inc. (FCNCA) are valued in the market.

What the Template Contains

  • Pre-Filled DCF Model: First Citizens BancShares, Inc.'s (FCNCA) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate First Citizens BancShares, Inc.'s (FCNCA) 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.

No products were found matching.