|
Columbia Banking System, Inc. (COLB) 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
Columbia Banking System, Inc. (COLB) Bundle
Designed for accuracy, our (COLB) DCF Calculator enables you to evaluate Columbia Banking System, Inc. valuation using real-world financial data while 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,256.6 | 1,294.5 | 1,276.0 | 547.6 | 1,783.9 | 1,982.4 | 2,202.9 | 2,447.9 | 2,720.3 | 3,022.9 |
| Revenue Growth, % | 0 | 3.02 | -1.43 | -57.09 | 225.79 | 11.12 | 11.12 | 11.12 | 11.12 | 11.12 |
| EBITDA | 284.9 | .0 | .0 | 478.9 | .0 | 436.6 | 485.2 | 539.2 | 599.2 | 665.8 |
| EBITDA, % | 22.67 | 0 | 0 | 87.46 | 0 | 22.03 | 22.03 | 22.03 | 22.03 | 22.03 |
| Depreciation | 20.8 | 19.4 | 19.0 | 27.0 | .0 | 38.0 | 42.2 | 46.9 | 52.1 | 57.9 |
| Depreciation, % | 1.65 | 1.5 | 1.49 | 4.93 | 0 | 1.91 | 1.91 | 1.91 | 1.91 | 1.91 |
| EBIT | 264.1 | -19.4 | -19.0 | 451.9 | .0 | 398.7 | 443.0 | 492.3 | 547.1 | 607.9 |
| EBIT, % | 21.02 | -1.5 | -1.49 | 82.53 | 0 | 20.11 | 20.11 | 20.11 | 20.11 | 20.11 |
| Total Cash | 4,177.4 | 5,505.7 | 6,632.1 | 4,880.8 | 2,157.4 | 1,982.4 | 2,202.9 | 2,447.9 | 2,720.3 | 3,022.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 1,465.5 | 1,456.6 | 1,467.7 | 64.9 | .0 | 1,236.4 | 1,374.0 | 1,526.8 | 1,696.7 | 1,885.4 |
| Account Receivables, % | 116.62 | 112.52 | 115.02 | 11.85 | 0 | 62.37 | 62.37 | 62.37 | 62.37 | 62.37 |
| Inventories | -295.1 | -709.2 | -881.1 | -1,997.9 | .0 | -980.5 | -1,089.6 | -1,210.8 | -1,345.5 | -1,495.2 |
| Inventories, % | -23.48 | -54.78 | -69.05 | -364.87 | 0 | -49.46 | -49.46 | -49.46 | -49.46 | -49.46 |
| 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 | -12.7 | -12.0 | -15.5 | -27.1 | .0 | -32.1 | -35.7 | -39.6 | -44.0 | -48.9 |
| Capital Expenditure, % | -1.01 | -0.9259 | -1.21 | -4.95 | 0 | -1.62 | -1.62 | -1.62 | -1.62 | -1.62 |
| Tax Rate, % | 25.99 | 25.99 | 25.99 | 25.99 | 25.99 | 25.99 | 25.99 | 25.99 | 25.99 | 25.99 |
| EBITAT | 199.5 | -20.3 | -14.3 | 337.7 | .0 | 318.6 | 354.0 | 393.4 | 437.2 | 485.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -962.9 | 410.1 | 150.1 | 2,857.2 | -1,933.0 | 68.6 | 332.1 | 369.0 | 410.1 | 455.7 |
| WACC, % | 10.32 | 12.18 | 10.3 | 10.26 | 10.2 | 10.65 | 10.65 | 10.65 | 10.65 | 10.65 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 1,153.9 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 465 | |||||||||
| Terminal Value | 5,374 | |||||||||
| Present Terminal Value | 3,240 | |||||||||
| Enterprise Value | 4,394 | |||||||||
| Net Debt | 2,342 | |||||||||
| Equity Value | 2,052 | |||||||||
| Diluted Shares Outstanding, MM | 196 | |||||||||
| Equity Value Per Share | 10.47 |
What You Will Get
- Real Columbia Banking Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Columbia Banking System, Inc. (COLB).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Columbia Banking’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and comprehensive projections for Columbia Banking System, Inc. (COLB).
- Time-Saving and Accurate: Avoid the hassle of building models from scratch while ensuring precision and flexibility in your financial assessments.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as loan growth, net interest margin, and operating expenses.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Results: Leverages Columbia Banking System’s (COLB) actual financial data for dependable valuation insights.
- Effortless Scenario Analysis: Explore various assumptions and evaluate results with ease.
- Efficiency Booster: Streamline the valuation process without the hassle of constructing intricate models from the ground up.
How It Works
- Download: Obtain the pre-formatted Excel file containing Columbia Banking System, Inc.'s (COLB) financial data.
- Customize: Modify projections, including loan growth, net interest margin, and cost of equity.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly analyze the results.
- Make Decisions: Utilize the valuation insights to inform your investment approach.
Why Choose This Calculator for Columbia Banking System, Inc. (COLB)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for banking.
- Adjustable Parameters: Modify the highlighted fields to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Columbia Banking's intrinsic value and Net Present Value.
- Loaded with Data: Offers historical and projected data for reliable analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and banking consultants.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Columbia Banking System, Inc. (COLB) stock.
- Financial Analysts: Simplify valuation processes with ready-to-use financial models for Columbia Banking System, Inc. (COLB).
- Consultants: Provide professional valuation insights for Columbia Banking System, Inc. (COLB) to clients swiftly and accurately.
- Business Owners: Gain insights into how banking institutions like Columbia Banking System, Inc. (COLB) are valued to inform your own business strategy.
- Finance Students: Master valuation techniques using real-world data and scenarios related to Columbia Banking System, Inc. (COLB).
What the Template Contains
- Pre-Filled DCF Model: Columbia Banking System, Inc.'s (COLB) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Columbia Banking System, Inc.'s (COLB) 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.