Hanmi Financial Corporation (HAFC) DCF Valuation
- ✓ 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
Hanmi Financial Corporation (HAFC) Bundle
Evaluate Hanmi Financial Corporation's (HAFC) financial outlook like an expert! This (HAFC) DCF Calculator provides pre-populated financials along with the flexibility to modify revenue growth, WACC, profit margins, and other critical 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 | 203.4 | 224.0 | 235.5 | 271.8 | 249.2 | 263.1 | 277.8 | 293.3 | 309.7 | 327.0 |
| Revenue Growth, % | 0 | 10.12 | 5.15 | 15.41 | -8.34 | 5.58 | 5.58 | 5.58 | 5.58 | 5.58 |
| EBITDA | 6.3 | 9.6 | 8.1 | 155.8 | .0 | 35.8 | 37.8 | 39.9 | 42.2 | 44.5 |
| EBITDA, % | 3.08 | 4.3 | 3.42 | 57.31 | 0 | 13.62 | 13.62 | 13.62 | 13.62 | 13.62 |
| Depreciation | 3.6 | 11.0 | 4.6 | 15.1 | 9.2 | 9.4 | 9.9 | 10.5 | 11.1 | 11.7 |
| Depreciation, % | 1.77 | 4.89 | 1.96 | 5.54 | 3.71 | 3.57 | 3.57 | 3.57 | 3.57 | 3.57 |
| EBIT | 2.7 | -1.3 | 3.4 | 140.7 | -9.2 | 26.4 | 27.9 | 29.5 | 31.1 | 32.8 |
| EBIT, % | 1.31 | -0.59151 | 1.46 | 51.77 | -3.71 | 10.05 | 10.05 | 10.05 | 10.05 | 10.05 |
| Total Cash | 756.2 | 1,145.6 | 1,519.8 | 1,206.3 | 1,168.1 | 263.1 | 277.8 | 293.3 | 309.7 | 327.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 495.6 | 439.6 | 499.3 | 613.3 | 627.1 | 263.1 | 277.8 | 293.3 | 309.7 | 327.0 |
| Account Receivables, % | 243.64 | 196.26 | 211.96 | 225.61 | 251.68 | 100 | 100 | 100 | 100 | 100 |
| Inventories | -133.5 | -454.6 | -665.7 | -423.3 | .0 | -192.4 | -203.1 | -214.5 | -226.5 | -239.1 |
| Inventories, % | -65.65 | -202.94 | -282.61 | -155.72 | 0 | -73.13 | -73.13 | -73.13 | -73.13 | -73.13 |
| Accounts Payable | 11.2 | 4.6 | 1.2 | 7.8 | 39.3 | 14.0 | 14.8 | 15.7 | 16.5 | 17.4 |
| Accounts Payable, % | 5.51 | 2.04 | 0.4929 | 2.87 | 15.78 | 5.34 | 5.34 | 5.34 | 5.34 | 5.34 |
| Capital Expenditure | -1.6 | -4.4 | -2.7 | -1.9 | -2.4 | -2.9 | -3.1 | -3.3 | -3.5 | -3.6 |
| Capital Expenditure, % | -0.77621 | -1.96 | -1.16 | -0.70849 | -0.97084 | -1.11 | -1.11 | -1.11 | -1.11 | -1.11 |
| Tax Rate, % | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 | 30.14 |
| EBITAT | 1.8 | -.9 | 2.5 | 101.4 | -6.5 | 18.8 | 19.8 | 20.9 | 22.1 | 23.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -347.0 | 376.0 | 152.4 | -235.2 | -405.2 | 556.4 | 23.5 | 24.8 | 26.2 | 27.6 |
| WACC, % | 13.89 | 14.11 | 14.35 | 14.25 | 13.97 | 14.11 | 14.11 | 14.11 | 14.11 | 14.11 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 552.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 28 | |||||||||
| Terminal Value | 233 | |||||||||
| Present Terminal Value | 120 | |||||||||
| Enterprise Value | 672 | |||||||||
| Net Debt | 153 | |||||||||
| Equity Value | 520 | |||||||||
| Diluted Shares Outstanding, MM | 30 | |||||||||
| Equity Value Per Share | 17.13 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Hanmi Financial Corporation’s (HAFC) financial data pre-loaded to facilitate your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model tailored to meet your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Hanmi Financial Corporation (HAFC).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital tool with adjustable parameters.
- Customizable Forecast Assumptions: Alter growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Hanmi Financial Corporation (HAFC).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics facilitate straightforward analysis.
How It Works
- Download: Obtain the pre-prepared Excel file featuring Hanmi Financial Corporation’s (HAFC) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various projections and instantly compare the results.
- Make Decisions: Utilize the valuation outcomes to inform your investment strategy.
Why Choose This Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters to tailor your analysis for Hanmi Financial Corporation (HAFC).
- Real-Time Feedback: Instantly observe changes in valuation as you tweak the inputs.
- Preloaded Data: Comes equipped with Hanmi Financial Corporation’s actual financial information for swift evaluations.
- Relied Upon by Experts: A go-to tool for investors and analysts seeking data-driven insights.
Who Should Use This Product?
- Individual Investors: Gain insights to make educated decisions about trading Hanmi Financial Corporation (HAFC) stock.
- Financial Analysts: Enhance valuation assessments with comprehensive financial models tailored for Hanmi Financial Corporation (HAFC).
- Consultants: Provide clients with precise valuation analyses and insights related to Hanmi Financial Corporation (HAFC).
- Business Owners: Learn about the valuation of financial institutions like Hanmi Financial Corporation (HAFC) to inform your own business strategies.
- Finance Students: Explore valuation methodologies using real-time data and case studies involving Hanmi Financial Corporation (HAFC).
What the Template Contains
- Preloaded HAFC Data: Historical and projected financial data, including revenue, net income, and loan growth.
- 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, expense ratios, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, liquidity, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.