Regions Financial Corporation (RF) 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
Regions Financial Corporation (RF) Bundle
Explore Regions Financial Corporation's (RF) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to determine Regions Financial Corporation's (RF) intrinsic value and refine your investment approach.
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 | 5,904.0 | 6,275.0 | 6,438.0 | 7,165.0 | 6,897.0 | 7,180.4 | 7,475.3 | 7,782.5 | 8,102.2 | 8,435.1 |
Revenue Growth, % | 0 | 6.28 | 2.6 | 11.29 | -3.74 | 4.11 | 4.11 | 4.11 | 4.11 | 4.11 |
EBITDA | 2,411.0 | 1,735.0 | 3,586.0 | 3,229.0 | 2,843.0 | 3,022.6 | 3,146.7 | 3,276.0 | 3,410.6 | 3,550.7 |
EBITDA, % | 40.84 | 27.65 | 55.7 | 45.07 | 41.22 | 42.09 | 42.09 | 42.09 | 42.09 | 42.09 |
Depreciation | 426.0 | 421.0 | 371.0 | 353.0 | 236.0 | 402.6 | 419.2 | 436.4 | 454.3 | 473.0 |
Depreciation, % | 7.22 | 6.71 | 5.76 | 4.93 | 3.42 | 5.61 | 5.61 | 5.61 | 5.61 | 5.61 |
EBIT | 1,985.0 | 1,314.0 | 3,215.0 | 2,876.0 | 2,607.0 | 2,619.9 | 2,727.6 | 2,839.6 | 2,956.3 | 3,077.8 |
EBIT, % | 33.62 | 20.94 | 49.94 | 40.14 | 37.8 | 36.49 | 36.49 | 36.49 | 36.49 | 36.49 |
Total Cash | 26,720.0 | 45,110.0 | 57,892.0 | 39,160.0 | 2,635.0 | 6,292.9 | 6,551.5 | 6,820.6 | 7,100.8 | 7,392.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 362.0 | .0 | .0 | 511.0 | .0 | 190.5 | 198.3 | 206.4 | 214.9 | 223.8 |
Account Receivables, % | 6.13 | 0 | 0 | 7.13 | 0 | 2.65 | 2.65 | 2.65 | 2.65 | 2.65 |
Inventories | -4,534.0 | -18,327.0 | -29,740.0 | .0 | .0 | -3,975.0 | -4,138.3 | -4,308.3 | -4,485.3 | -4,669.6 |
Inventories, % | -76.8 | -292.06 | -461.94 | 0 | 0 | -55.36 | -55.36 | -55.36 | -55.36 | -55.36 |
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 | -24.0 | -59.0 | -72.0 | -288.0 | .0 | -93.1 | -96.9 | -100.9 | -105.1 | -109.4 |
Capital Expenditure, % | -0.4065 | -0.94024 | -1.12 | -4.02 | 0 | -1.3 | -1.3 | -1.3 | -1.3 | -1.3 |
Tax Rate, % | 20.44 | 20.44 | 20.44 | 20.44 | 20.44 | 20.44 | 20.44 | 20.44 | 20.44 | 20.44 |
EBITAT | 1,582.0 | 1,094.0 | 2,521.0 | 2,245.0 | 2,074.0 | 2,090.6 | 2,176.5 | 2,265.9 | 2,359.0 | 2,455.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 6,156.0 | 15,611.0 | 14,233.0 | -27,941.0 | 2,821.0 | 6,184.6 | 2,654.2 | 2,763.2 | 2,876.8 | 2,995.0 |
WACC, % | 14.19 | 14.42 | 14.11 | 14.08 | 14.18 | 14.19 | 14.19 | 14.19 | 14.19 | 14.19 |
PV UFCF | ||||||||||
SUM PV UFCF | 12,540.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 3,055 | |||||||||
Terminal Value | 25,050 | |||||||||
Present Terminal Value | 12,900 | |||||||||
Enterprise Value | 25,440 | |||||||||
Net Debt | 996 | |||||||||
Equity Value | 24,444 | |||||||||
Diluted Shares Outstanding, MM | 938 | |||||||||
Equity Value Per Share | 26.06 |
What You Will Get
- Real Regions Financial Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Regions Financial’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive DCF Calculator: Features in-depth unlevered and levered DCF valuation models tailored for Regions Financial Corporation (RF).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs for accurate assessments.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Regions Financial Corporation (RF).
- Interactive Dashboard and Charts: Visual representations that highlight essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Regions Financial Corporation (RF) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Regions Financial Corporation’s (RF) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Regions Financial Corporation (RF)?
- Save Time: Access a comprehensive suite of financial services without the hassle of extensive setup.
- Enhance Financial Decisions: Utilize accurate data and expert insights to make informed investment choices.
- Fully Customizable Solutions: Adapt services to meet your unique financial needs and goals.
- User-Friendly Experience: Intuitive platforms and tools simplify your banking and investment processes.
- Trusted by Professionals: Backed by a strong reputation and years of experience in the financial sector.
Who Should Use This Product?
- Investors: Accurately assess Regions Financial Corporation’s (RF) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial analysis and reporting related to Regions Financial Corporation (RF).
- Consultants: Easily customize the template for client valuation reports involving Regions Financial Corporation (RF).
- Entrepreneurs: Discover insights into the financial modeling practices of successful companies like Regions Financial Corporation (RF).
- Educators: Implement it as a teaching resource to illustrate valuation techniques using Regions Financial Corporation (RF) as a case study.
What the Template Contains
- Pre-Filled Data: Contains Regions Financial Corporation's historical financials and forecasts.
- Discounted Cash Flow Model: 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 Regions Financial Corporation's profitability, efficiency, and leverage.
- Customizable Inputs: Easily adjust revenue growth, margins, and tax rates.
- Clear Dashboard: Visuals and tables summarizing essential valuation results.