Truist Financial Corporation (TFC) 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
Truist Financial Corporation (TFC) Bundle
Whether you’re an investor or analyst, this [Symbol] (TFC) DCF Calculator is your go-to resource for accurate valuation. Featuring real data from Truist Financial Corporation, you can easily adjust forecasts and observe the effects in real time.
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 | 11,953.0 | 20,370.0 | 23,109.0 | 22,258.0 | 23,390.0 | 28,376.0 | 34,424.8 | 41,763.1 | 50,665.6 | 61,465.9 |
| Revenue Growth, % | 0 | 70.42 | 13.45 | -3.68 | 5.09 | 21.32 | 21.32 | 21.32 | 21.32 | 21.32 |
| EBITDA | .0 | .0 | 9,377.0 | 9,035.0 | .0 | 4,606.5 | 5,588.5 | 6,779.8 | 8,225.0 | 9,978.3 |
| EBITDA, % | 0 | 0 | 40.58 | 40.59 | 0 | 16.23 | 16.23 | 16.23 | 16.23 | 16.23 |
| Depreciation | 630.0 | 1,608.0 | 1,384.0 | 1,550.0 | 1,215.0 | 1,777.0 | 2,155.8 | 2,615.4 | 3,172.9 | 3,849.2 |
| Depreciation, % | 5.27 | 7.89 | 5.99 | 6.96 | 5.19 | 6.26 | 6.26 | 6.26 | 6.26 | 6.26 |
| EBIT | -630.0 | -1,608.0 | 7,993.0 | 7,485.0 | -1,215.0 | 2,829.5 | 3,432.7 | 4,164.4 | 5,052.1 | 6,129.1 |
| EBIT, % | -5.27 | -7.89 | 34.59 | 33.63 | -5.19 | 9.97 | 9.97 | 9.97 | 9.97 | 9.97 |
| Total Cash | 93,792.0 | 139,656.0 | 173,418.0 | 93,222.0 | 30,644.0 | 28,376.0 | 34,424.8 | 41,763.1 | 50,665.6 | 61,465.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 6,122.0 | 5,240.0 | .0 | .0 | .0 | 4,366.6 | 5,297.4 | 6,426.6 | 7,796.6 | 9,458.5 |
| Account Receivables, % | 51.22 | 25.72 | 0 | 0 | 0 | 15.39 | 15.39 | 15.39 | 15.39 | 15.39 |
| Inventories | -31,817.0 | -34,247.0 | -39,871.0 | -11,772.0 | .0 | -20,027.1 | -24,296.3 | -29,475.4 | -35,758.7 | -43,381.2 |
| Inventories, % | -266.18 | -168.12 | -172.53 | -52.89 | 0 | -70.58 | -70.58 | -70.58 | -70.58 | -70.58 |
| Accounts Payable | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Accounts Payable, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Capital Expenditure | 656.0 | -815.0 | -442.0 | -564.0 | 12,496.0 | -479.4 | -581.6 | -705.6 | -856.0 | -1,038.5 |
| Capital Expenditure, % | 5.49 | -4 | -1.91 | -2.53 | 53.42 | -1.69 | -1.69 | -1.69 | -1.69 | -1.69 |
| Tax Rate, % | -489.73 | -489.73 | -489.73 | -489.73 | -489.73 | -489.73 | -489.73 | -489.73 | -489.73 | -489.73 |
| EBITAT | -505.4 | -1,316.8 | 6,440.0 | 6,109.8 | -7,165.2 | 2,401.2 | 2,913.0 | 3,534.0 | 4,287.3 | 5,201.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 26,475.6 | 2,788.2 | 18,246.0 | -21,003.2 | -5,226.2 | 19,359.3 | 7,825.6 | 9,493.7 | 11,517.5 | 13,972.6 |
| WACC, % | 11.32 | 11.46 | 11.34 | 11.43 | 12.97 | 11.7 | 11.7 | 11.7 | 11.7 | 11.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 45,845.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 14,252 | |||||||||
| Terminal Value | 146,874 | |||||||||
| Present Terminal Value | 84,452 | |||||||||
| Enterprise Value | 130,297 | |||||||||
| Net Debt | 29,050 | |||||||||
| Equity Value | 101,247 | |||||||||
| Diluted Shares Outstanding, MM | 1,332 | |||||||||
| Equity Value Per Share | 76.01 |
What You Will Get
- Real TFC 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 Truist’s future performance.
- User-Friendly Design: Designed for professionals but easy for beginners to navigate.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Truist Financial Corporation (TFC).
- WACC Calculator: Comes with a pre-configured Weighted Average Cost of Capital sheet that allows for customizable inputs.
- Adjustable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Truist Financial Corporation (TFC).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Truist Financial Corporation (TFC).
- Step 2: Review the pre-filled financial data and forecasts for Truist.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and utilize the results for your investment strategies.
Why Choose This Calculator for Truist Financial Corporation (TFC)?
- Accurate Data: Utilize real Truist financials for dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: An intuitive design and guided instructions make it accessible for all users.
Who Should Use This Product?
- Finance Students: Master financial analysis techniques and implement them with real-world data.
- Academics: Integrate industry-standard models into your teaching or research projects.
- Investors: Validate your investment strategies and evaluate valuation scenarios for Truist Financial Corporation (TFC).
- Analysts: Enhance your efficiency with a ready-to-use, customizable DCF model.
- Small Business Owners: Understand how major financial institutions like Truist Financial Corporation (TFC) are assessed.
What the Template Contains
- Pre-Filled Data: Includes Truist Financial Corporation’s (TFC) 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 Truist Financial Corporation’s (TFC) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.