Concrete Pumping Holdings, Inc. (BBCP) 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
Concrete Pumping Holdings, Inc. (BBCP) Bundle
Gain insight into your Concrete Pumping Holdings, Inc. (BBCP) valuation analysis using our sophisticated DCF Calculator! With real (BBCP) data already included, this Excel template enables you to adjust forecasts and assumptions, allowing for precise calculations of Concrete Pumping Holdings, 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 | 283.0 | 304.3 | 315.8 | 401.3 | 442.2 | 496.0 | 556.2 | 623.8 | 699.6 | 784.6 |
Revenue Growth, % | 0 | 7.54 | 3.78 | 27.07 | 10.2 | 12.15 | 12.15 | 12.15 | 12.15 | 12.15 |
EBITDA | 84.1 | 29.8 | 94.3 | 121.4 | 132.9 | 128.6 | 144.3 | 161.8 | 181.5 | 203.5 |
EBITDA, % | 29.73 | 9.8 | 29.85 | 30.26 | 30.04 | 25.94 | 25.94 | 25.94 | 25.94 | 25.94 |
Depreciation | 55.4 | 61.7 | 55.9 | 61.4 | 64.2 | 86.6 | 97.2 | 109.0 | 122.2 | 137.0 |
Depreciation, % | 19.57 | 20.26 | 17.7 | 15.29 | 14.51 | 17.47 | 17.47 | 17.47 | 17.47 | 17.47 |
EBIT | 28.8 | -31.8 | 38.4 | 60.1 | 68.7 | 42.0 | 47.1 | 52.8 | 59.3 | 66.5 |
EBIT, % | 10.16 | -10.46 | 12.15 | 14.97 | 15.53 | 8.47 | 8.47 | 8.47 | 8.47 | 8.47 |
Total Cash | 7.5 | 6.7 | 9.3 | 7.5 | 15.9 | 13.1 | 14.7 | 16.5 | 18.5 | 20.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 46.7 | 45.9 | 49.3 | 63.4 | 63.0 | 76.6 | 85.9 | 96.4 | 108.1 | 121.2 |
Account Receivables, % | 16.49 | 15.1 | 15.61 | 15.79 | 14.24 | 15.45 | 15.45 | 15.45 | 15.45 | 15.45 |
Inventories | 5.3 | 4.6 | 4.9 | 5.5 | 6.7 | 7.8 | 8.7 | 9.8 | 11.0 | 12.3 |
Inventories, % | 1.86 | 1.52 | 1.55 | 1.38 | 1.52 | 1.57 | 1.57 | 1.57 | 1.57 | 1.57 |
Accounts Payable | 7.4 | 6.6 | 10.7 | 8.4 | 8.9 | 12.2 | 13.7 | 15.3 | 17.2 | 19.3 |
Accounts Payable, % | 2.62 | 2.16 | 3.39 | 2.08 | 2.01 | 2.45 | 2.45 | 2.45 | 2.45 | 2.45 |
Capital Expenditure | -36.2 | -39.3 | -63.5 | -103.4 | -55.3 | -83.4 | -93.6 | -105.0 | -117.7 | -132.0 |
Capital Expenditure, % | -12.81 | -12.93 | -20.12 | -25.76 | -12.51 | -16.82 | -16.82 | -16.82 | -16.82 | -16.82 |
Tax Rate, % | 21.63 | 21.63 | 21.63 | 21.63 | 21.63 | 21.63 | 21.63 | 21.63 | 21.63 | 21.63 |
EBITAT | 23.4 | -29.4 | 46.5 | 50.4 | 53.8 | 36.6 | 41.1 | 46.1 | 51.7 | 58.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -2.0 | -6.6 | 39.4 | -8.7 | 62.4 | 28.4 | 35.9 | 40.2 | 45.1 | 50.6 |
WACC, % | 7.45 | 7.86 | 8.13 | 7.54 | 7.34 | 7.66 | 7.66 | 7.66 | 7.66 | 7.66 |
PV UFCF | ||||||||||
SUM PV UFCF | 158.2 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 52 | |||||||||
Terminal Value | 1,118 | |||||||||
Present Terminal Value | 773 | |||||||||
Enterprise Value | 931 | |||||||||
Net Debt | 400 | |||||||||
Equity Value | 531 | |||||||||
Diluted Shares Outstanding, MM | 54 | |||||||||
Equity Value Per Share | 9.80 |
What You Will Get
- Real BBCP Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Concrete Pumping Holdings, Inc.
- 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 BBCP’s fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and detailed projections specific to the concrete pumping industry.
- Time-Saving and Accurate: Avoid building models from scratch while ensuring precision and flexibility in your financial assessments.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenditures for Concrete Pumping Holdings, Inc. (BBCP).
- Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial metrics for quick insights.
- High-Precision Accuracy: Leverages Concrete Pumping Holdings, Inc. (BBCP)'s actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze different outcomes side by side.
- Efficiency Booster: Save time by avoiding the complexities of constructing detailed valuation models from the ground up.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Concrete Pumping Holdings, Inc. (BBCP) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Concrete Pumping Holdings, Inc. (BBCP)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Concrete Pumping Holdings, Inc. (BBCP)?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses tailored for BBCP.
- Adjustable Parameters: Modify the highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically computes Concrete Pumping Holdings’ intrinsic value and Net Present Value.
- Integrated Data: Historical and projected data provide reliable benchmarks for analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and industry consultants focusing on BBCP.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Concrete Pumping Holdings, Inc. (BBCP) stock.
- Financial Analysts: Enhance valuation processes with comprehensive financial models specific to the construction industry.
- Consultants: Provide accurate valuation insights for clients in the construction and engineering sectors.
- Business Owners: Gain insights into how companies like Concrete Pumping Holdings, Inc. (BBCP) are valued to inform your business strategies.
- Finance Students: Study valuation techniques using industry-specific data and real-world applications.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations for Concrete Pumping Holdings, Inc. (BBCP).
- Real-World Data: Historical and projected financials for Concrete Pumping Holdings, Inc. (BBCP) preloaded for thorough analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into the company’s performance.
- Key Ratios: Integrated analysis focusing on profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Visual representations including charts and tables for clear, actionable results.