Customers Bancorp, Inc. (CUBI) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Customers Bancorp, Inc. (CUBI) Bundle
Gain insight into your Customers Bancorp, Inc. (CUBI) valuation analysis with our sophisticated DCF Calculator! Featuring up-to-date data for (CUBI), this Excel template enables you to adjust forecasts and parameters for an accurate calculation of Customers Bancorp, Inc.'s intrinsic value.
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 | 356.6 | 502.3 | 748.5 | 632.4 | 683.4 | 824.3 | 994.2 | 1,199.1 | 1,446.2 | 1,744.3 |
Revenue Growth, % | 0 | 40.87 | 49.03 | -15.52 | 8.07 | 20.61 | 20.61 | 20.61 | 20.61 | 20.61 |
EBITDA | 115.7 | 208.3 | 462.9 | 318.5 | 360.6 | 393.8 | 475.0 | 572.9 | 691.0 | 833.4 |
EBITDA, % | 32.46 | 41.47 | 61.84 | 50.36 | 52.77 | 47.78 | 47.78 | 47.78 | 47.78 | 47.78 |
Depreciation | 22.9 | 18.5 | 21.7 | 23.0 | 31.8 | 35.1 | 42.3 | 51.0 | 61.6 | 74.3 |
Depreciation, % | 6.42 | 3.69 | 2.89 | 3.63 | 4.66 | 4.26 | 4.26 | 4.26 | 4.26 | 4.26 |
EBIT | 92.8 | 189.8 | 441.2 | 295.5 | 328.8 | 358.7 | 432.7 | 521.8 | 629.4 | 759.1 |
EBIT, % | 26.04 | 37.78 | 58.94 | 46.72 | 48.12 | 43.52 | 43.52 | 43.52 | 43.52 | 43.52 |
Total Cash | 808.4 | 1,903.6 | 4,335.2 | 3,443.3 | 3,846.3 | 824.3 | 994.2 | 1,199.1 | 1,446.2 | 1,744.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | 15,458.8 | .0 | 164.9 | 198.8 | 239.8 | 289.2 | 348.9 |
Account Receivables, % | 0 | 0 | 0 | 2444.55 | 0 | 20 | 20 | 20 | 20 | 20 |
Inventories | -250.8 | -774.4 | -610.4 | .0 | .0 | -415.2 | -500.8 | -604.0 | -728.5 | -878.7 |
Inventories, % | -70.32 | -154.18 | -81.55 | 0 | 0 | -50.37 | -50.37 | -50.37 | -50.37 | -50.37 |
Accounts Payable | 126.2 | 152.1 | 251.1 | 230.7 | .0 | 223.7 | 269.8 | 325.4 | 392.5 | 473.4 |
Accounts Payable, % | 35.41 | 30.28 | 33.55 | 36.48 | 0 | 27.14 | 27.14 | 27.14 | 27.14 | 27.14 |
Capital Expenditure | -50.3 | -28.9 | -33.0 | -113.3 | -41.3 | -79.5 | -95.9 | -115.6 | -139.5 | -168.2 |
Capital Expenditure, % | -14.09 | -5.75 | -4.4 | -17.92 | -6.05 | -9.64 | -9.64 | -9.64 | -9.64 | -9.64 |
Tax Rate, % | 24.37 | 24.37 | 24.37 | 24.37 | 24.37 | 24.37 | 24.37 | 24.37 | 24.37 | 24.37 |
EBITAT | 72.1 | 143.0 | 314.6 | 231.3 | 248.7 | 271.4 | 327.3 | 394.8 | 476.1 | 574.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 421.7 | 682.1 | 238.4 | -15,948.7 | 15,467.3 | 701.1 | 371.5 | 448.0 | 540.4 | 651.8 |
WACC, % | 23.23 | 22.72 | 21.83 | 23.36 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 | 22.78 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,530.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 665 | |||||||||
Terminal Value | 3,199 | |||||||||
Present Terminal Value | 1,146 | |||||||||
Enterprise Value | 2,677 | |||||||||
Net Debt | -2,337 | |||||||||
Equity Value | 5,014 | |||||||||
Diluted Shares Outstanding, MM | 32 | |||||||||
Equity Value Per Share | 155.92 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real CUBI financials.
- Real-World Data: Historical data and forward-looking estimates (as indicated in the yellow cells).
- Forecast Flexibility: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the impact of your inputs on Customers Bancorp’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Customers Bancorp, Inc. (CUBI).
- WACC Calculation Tool: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to CUBI.
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to fit your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Customers Bancorp, Inc. (CUBI).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Customers Bancorp, Inc. (CUBI) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Customers Bancorp, Inc. (CUBI)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Customers Bancorp, Inc. (CUBI)?
- All-in-One Solution: Offers DCF, WACC, and financial ratio analyses tailored for CUBI.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Customers Bancorp’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- High-Quality Standards: Perfect for financial analysts, investors, and business consultants focusing on CUBI.
Who Should Use This Product?
- Investors: Assess Customers Bancorp’s valuation before making stock transactions.
- CFOs and Financial Analysts: Optimize valuation workflows and evaluate financial forecasts.
- Startup Founders: Discover how established financial institutions like Customers Bancorp are appraised.
- Consultants: Provide comprehensive valuation analyses for clients.
- Students and Educators: Utilize real-time data to learn and instruct on valuation methodologies.
What the Template Contains
- Pre-Filled DCF Model: Customers Bancorp, Inc.'s (CUBI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Customers Bancorp, Inc.'s (CUBI) 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.