First Merchants Corporation (FRME) 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
First Merchants Corporation (FRME) Bundle
Evaluate the financial prospects of First Merchants Corporation (FRME) with expertise! This (FRME) DCF Calculator provides pre-filled financials along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your 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 | 443.3 | 492.1 | 520.0 | 628.1 | 654.3 | 722.4 | 797.6 | 880.6 | 972.2 | 1,073.4 |
| Revenue Growth, % | 0 | 10.99 | 5.68 | 20.8 | 4.17 | 10.41 | 10.41 | 10.41 | 10.41 | 10.41 |
| EBITDA | 203.2 | 181.0 | 251.5 | 267.5 | 270.9 | 310.6 | 342.9 | 378.6 | 418.0 | 461.5 |
| EBITDA, % | 45.83 | 36.78 | 48.36 | 42.58 | 41.41 | 42.99 | 42.99 | 42.99 | 42.99 | 42.99 |
| Depreciation | 9.4 | 11.0 | 10.7 | 11.8 | 11.7 | 14.6 | 16.1 | 17.8 | 19.6 | 21.6 |
| Depreciation, % | 2.12 | 2.24 | 2.06 | 1.88 | 1.79 | 2.02 | 2.02 | 2.02 | 2.02 | 2.02 |
| EBIT | 193.8 | 170.0 | 240.8 | 255.7 | 259.2 | 296.0 | 326.8 | 360.8 | 398.4 | 439.8 |
| EBIT, % | 43.71 | 34.54 | 46.31 | 40.7 | 39.62 | 40.98 | 40.98 | 40.98 | 40.98 | 40.98 |
| Total Cash | 2,085.5 | 2,504.3 | 2,985.9 | 248.7 | 1,739.8 | 635.1 | 701.2 | 774.2 | 854.8 | 943.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 48.9 | 53.9 | 57.2 | 85.1 | 97.7 | 88.8 | 98.0 | 108.2 | 119.5 | 131.9 |
| Account Receivables, % | 11.03 | 10.96 | 11 | 13.54 | 14.93 | 12.29 | 12.29 | 12.29 | 12.29 | 12.29 |
| Inventories | -364.1 | -652.4 | -734.7 | -451.4 | .0 | -511.4 | -564.7 | -623.4 | -688.3 | -759.9 |
| Inventories, % | -82.12 | -132.59 | -141.28 | -71.86 | 0 | -70.79 | -70.79 | -70.79 | -70.79 | -70.79 |
| Accounts Payable | 6.8 | 3.3 | 2.8 | 7.5 | 18.9 | 9.8 | 10.9 | 12.0 | 13.2 | 14.6 |
| Accounts Payable, % | 1.52 | 0.66802 | 0.53115 | 1.2 | 2.89 | 1.36 | 1.36 | 1.36 | 1.36 | 1.36 |
| Capital Expenditure | -312.4 | .0 | -64.3 | .0 | .0 | -119.7 | -132.1 | -145.9 | -161.1 | -177.8 |
| Capital Expenditure, % | -70.47 | 0 | -12.36 | 0 | 0 | -16.57 | -16.57 | -16.57 | -16.57 | -16.57 |
| Tax Rate, % | 13.67 | 13.67 | 13.67 | 13.67 | 13.67 | 13.67 | 13.67 | 13.67 | 13.67 | 13.67 |
| EBITAT | 164.5 | 148.6 | 205.5 | 222.1 | 223.8 | 255.1 | 281.6 | 310.9 | 343.3 | 379.0 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 183.3 | 439.5 | 230.5 | -72.5 | -217.1 | 661.2 | 210.6 | 232.5 | 256.7 | 283.4 |
| WACC, % | 15.86 | 16.13 | 15.91 | 16.07 | 16.01 | 16 | 16 | 16 | 16 | 16 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,152.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 289 | |||||||||
| Terminal Value | 2,065 | |||||||||
| Present Terminal Value | 983 | |||||||||
| Enterprise Value | 2,136 | |||||||||
| Net Debt | 323 | |||||||||
| Equity Value | 1,813 | |||||||||
| Diluted Shares Outstanding, MM | 59 | |||||||||
| Equity Value Per Share | 30.47 |
What You Will Get
- Editable Forecast Inputs: Seamlessly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: First Merchants Corporation’s (FRME) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that can be tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for First Merchants Corporation (FRME).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to help you visualize your valuation outcomes.
- Designed for All Users: A straightforward, accessible layout suitable for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Get instant access to the Excel-based FRME DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates First Merchants Corporation’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator for First Merchants Corporation (FRME)?
- Designed for Financial Experts: A sophisticated tool utilized by analysts, CFOs, and financial consultants.
- Accurate Financial Data: First Merchants Corporation’s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling First Merchants Corporation (FRME) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for First Merchants Corporation (FRME).
- Consultants: Deliver professional valuation insights on First Merchants Corporation (FRME) to clients quickly and accurately.
- Business Owners: Understand how financial institutions like First Merchants Corporation (FRME) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to First Merchants Corporation (FRME).
What the Template Contains
- Preloaded FRME Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.