|
First Citizens BancShares, Inc. (FCNCA) DCF Valuation
US | Financial Services | Banks - Regional | NASDAQ
|
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
First Citizens BancShares, Inc. (FCNCA) Bundle
Designed for accuracy, our (FCNCA) DCF Calculator allows you to evaluate First Citizens BancShares, Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | 329.8 | 473.3 | 679.2 | 974.7 | 1,398.8 |
| Account Receivables, % | 0 | 7.81 | 7.3 | 0 | 0 | 3.02 | 3.02 | 3.02 | 3.02 | 3.02 |
| 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.