Liberty Energy Inc. (LBRT) 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
Liberty Energy Inc. (LBRT) Bundle
Evaluate Liberty Energy Inc.'s financial outlook like an expert! This (LBRT) DCF Calculator provides pre-filled financial data along with total 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 | 1,990.3 | 965.8 | 2,470.8 | 4,149.2 | 4,747.9 | 6,301.5 | 8,363.4 | 11,100.0 | 14,732.1 | 19,552.6 |
| Revenue Growth, % | 0 | -51.48 | 155.83 | 67.93 | 14.43 | 32.72 | 32.72 | 32.72 | 32.72 | 32.72 |
| EBITDA | 275.0 | 3.3 | 100.6 | 749.0 | 1,185.9 | 772.0 | 1,024.7 | 1,359.9 | 1,804.9 | 2,395.5 |
| EBITDA, % | 13.82 | 0.34386 | 4.07 | 18.05 | 24.98 | 12.25 | 12.25 | 12.25 | 12.25 | 12.25 |
| Depreciation | 168.6 | 183.8 | 266.6 | 326.8 | 421.5 | 693.6 | 920.6 | 1,221.8 | 1,621.6 | 2,152.3 |
| Depreciation, % | 8.47 | 19.03 | 10.79 | 7.88 | 8.88 | 11.01 | 11.01 | 11.01 | 11.01 | 11.01 |
| EBIT | 106.4 | -180.4 | -166.0 | 422.2 | 764.4 | 78.4 | 104.0 | 138.1 | 183.3 | 243.2 |
| EBIT, % | 5.35 | -18.68 | -6.72 | 10.18 | 16.1 | 1.24 | 1.24 | 1.24 | 1.24 | 1.24 |
| Total Cash | 112.7 | 69.0 | 20.0 | 43.7 | 36.8 | 194.6 | 258.3 | 342.8 | 454.9 | 603.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 252.9 | 313.9 | 407.5 | 586.0 | 587.5 | 1,111.6 | 1,475.3 | 1,958.1 | 2,598.8 | 3,449.1 |
| Account Receivables, % | 12.71 | 32.51 | 16.49 | 14.12 | 12.37 | 17.64 | 17.64 | 17.64 | 17.64 | 17.64 |
| Inventories | 88.5 | 118.6 | 134.6 | 214.5 | 205.9 | 399.2 | 529.9 | 703.2 | 933.4 | 1,238.8 |
| Inventories, % | 4.45 | 12.28 | 5.45 | 5.17 | 4.34 | 6.34 | 6.34 | 6.34 | 6.34 | 6.34 |
| Accounts Payable | 117.6 | 193.3 | 288.8 | 326.8 | 293.7 | 651.3 | 864.4 | 1,147.3 | 1,522.7 | 2,020.9 |
| Accounts Payable, % | 5.91 | 20.02 | 11.69 | 7.88 | 6.19 | 10.34 | 10.34 | 10.34 | 10.34 | 10.34 |
| Capital Expenditure | -195.2 | -103.6 | -198.8 | -459.3 | -603.3 | -659.9 | -875.8 | -1,162.4 | -1,542.7 | -2,047.5 |
| Capital Expenditure, % | -9.81 | -10.73 | -8.05 | -11.07 | -12.71 | -10.47 | -10.47 | -10.47 | -10.47 | -10.47 |
| Tax Rate, % | 24.3 | 24.3 | 24.3 | 24.3 | 24.3 | 24.3 | 24.3 | 24.3 | 24.3 | 24.3 |
| EBITAT | 89.6 | -151.4 | -174.6 | 422.3 | 578.6 | 69.6 | 92.3 | 122.6 | 162.7 | 215.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -160.9 | -86.6 | -120.9 | 69.4 | 370.9 | -256.6 | -144.1 | -191.2 | -253.8 | -336.9 |
| WACC, % | 11.85 | 11.84 | 11.97 | 11.97 | 11.78 | 11.88 | 11.88 | 11.88 | 11.88 | 11.88 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -835.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -344 | |||||||||
| Terminal Value | -3,477 | |||||||||
| Present Terminal Value | -1,983 | |||||||||
| Enterprise Value | -2,818 | |||||||||
| Net Debt | 369 | |||||||||
| Equity Value | -3,187 | |||||||||
| Diluted Shares Outstanding, MM | 176 | |||||||||
| Equity Value Per Share | -18.07 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to create various scenarios.
- Real-World Data: Liberty Energy Inc.'s (LBRT) financial data pre-filled to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation needs.
- Built for Analysts and Investors: Perfect for testing projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital expenditures.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial outputs.
- High Precision Accuracy: Leverages Liberty Energy Inc.'s (LBRT) actual financial data for credible valuation results.
- Simplified Scenario Analysis: Effortlessly evaluate various assumptions and analyze results side by side.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Step 1: Download the Excel file for Liberty Energy Inc. (LBRT).
- Step 2: Review Liberty Energy's pre-filled financial data and forecasts.
- Step 3: Adjust key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you modify assumptions.
- Step 5: Evaluate the outputs and leverage the results for your investment strategies.
Why Choose Liberty Energy Inc. (LBRT) Calculator?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Feedback: Watch Liberty Energy’s valuation update instantly as you change inputs.
- Pre-Configured Data: Comes with Liberty Energy’s latest financial metrics for immediate evaluation.
- Relied Upon by Experts: A go-to tool for investors and analysts aiming for data-driven insights.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for energy sector analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for Liberty Energy Inc. (LBRT) to clients.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how energy companies like Liberty Energy Inc. (LBRT) are valued in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Liberty Energy Inc. (LBRT) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Liberty Energy Inc. (LBRT).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.