United States Lime & Minerals, Inc. (USLM) 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
United States Lime & Minerals, Inc. (USLM) Bundle
Designed for accuracy, our (USLM) DCF Calculator empowers you to evaluate the valuation of United States Lime & Minerals, Inc. using actual financial data and offers 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 | 158.3 | 160.7 | 189.3 | 236.2 | 281.3 | 325.8 | 377.3 | 436.9 | 505.9 | 585.9 |
| Revenue Growth, % | 0 | 1.53 | 17.77 | 24.78 | 19.13 | 15.8 | 15.8 | 15.8 | 15.8 | 15.8 |
| EBITDA | 48.5 | 53.7 | 67.8 | 77.0 | 109.2 | 111.6 | 129.3 | 149.7 | 173.3 | 200.7 |
| EBITDA, % | 30.67 | 33.41 | 35.8 | 32.6 | 38.83 | 34.26 | 34.26 | 34.26 | 34.26 | 34.26 |
| Depreciation | 17.7 | 19.7 | 21.0 | 22.2 | 23.8 | 34.1 | 39.5 | 45.8 | 53.0 | 61.4 |
| Depreciation, % | 11.18 | 12.26 | 11.09 | 9.4 | 8.47 | 10.48 | 10.48 | 10.48 | 10.48 | 10.48 |
| EBIT | 30.8 | 34.0 | 46.8 | 54.8 | 85.4 | 77.5 | 89.7 | 103.9 | 120.3 | 139.3 |
| EBIT, % | 19.48 | 21.16 | 24.71 | 23.2 | 30.36 | 23.78 | 23.78 | 23.78 | 23.78 | 23.78 |
| Total Cash | 54.3 | 83.6 | 105.4 | 133.4 | 188.0 | 172.8 | 200.1 | 231.8 | 268.4 | 310.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 22.9 | 23.0 | 26.7 | 33.6 | 38.1 | 46.0 | 53.3 | 61.7 | 71.5 | 82.8 |
| Account Receivables, % | 14.5 | 14.3 | 14.12 | 14.22 | 13.53 | 14.13 | 14.13 | 14.13 | 14.13 | 14.13 |
| Inventories | 13.4 | 15.2 | 15.1 | 19.6 | 24.3 | 27.9 | 32.3 | 37.4 | 43.4 | 50.2 |
| Inventories, % | 8.46 | 9.46 | 7.99 | 8.29 | 8.64 | 8.57 | 8.57 | 8.57 | 8.57 | 8.57 |
| Accounts Payable | 4.4 | 4.6 | 5.4 | 7.7 | 7.4 | 9.4 | 10.9 | 12.6 | 14.6 | 16.9 |
| Accounts Payable, % | 2.8 | 2.86 | 2.87 | 3.27 | 2.63 | 2.89 | 2.89 | 2.89 | 2.89 | 2.89 |
| Capital Expenditure | -27.1 | -17.1 | -29.9 | -26.8 | -34.3 | -43.7 | -50.6 | -58.6 | -67.9 | -78.6 |
| Capital Expenditure, % | -17.12 | -10.66 | -15.81 | -11.36 | -12.17 | -13.42 | -13.42 | -13.42 | -13.42 | -13.42 |
| Tax Rate, % | 20.15 | 20.15 | 20.15 | 20.15 | 20.15 | 20.15 | 20.15 | 20.15 | 20.15 | 20.15 |
| EBITAT | 26.0 | 28.2 | 37.2 | 44.0 | 68.2 | 63.1 | 73.0 | 84.6 | 97.9 | 113.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -15.3 | 29.0 | 25.5 | 30.3 | 48.3 | 43.9 | 51.7 | 59.9 | 69.4 | 80.3 |
| WACC, % | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 | 8.3 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 236.1 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 81 | |||||||||
| Terminal Value | 1,034 | |||||||||
| Present Terminal Value | 694 | |||||||||
| Enterprise Value | 930 | |||||||||
| Net Debt | -182 | |||||||||
| Equity Value | 1,113 | |||||||||
| Diluted Shares Outstanding, MM | 29 | |||||||||
| Equity Value Per Share | 39.00 |
What You Will Get
- Real USLM Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for United States Lime & Minerals, Inc. (USLM).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to USLM.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on United States Lime & Minerals, Inc.'s (USLM) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for USLM.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for United States Lime & Minerals, Inc. (USLM).
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for United States Lime & Minerals, Inc. (USLM).
- WACC Calculator: Comes with a pre-configured Weighted Average Cost of Capital sheet that allows for customizable inputs.
- Adjustable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to United States Lime & Minerals, Inc. (USLM).
- 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 United States Lime & Minerals, Inc. (USLM) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for United States Lime & Minerals, Inc. (USLM)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for United States Lime & Minerals, Inc. (USLM)?
- Accuracy: Utilizes real USLM financial data to ensure precise calculations.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the meticulousness and functionality expected at the CFO level.
- User-Friendly: Designed for simplicity, making it accessible for users without extensive financial modeling skills.
Who Should Use United States Lime & Minerals, Inc. (USLM)?
- Investors: Gain insights and make informed decisions with a reliable resource for lime and minerals valuation.
- Financial Analysts: Utilize comprehensive data and analysis tools tailored for the lime and minerals industry.
- Consultants: Easily customize reports and presentations to meet client needs in the construction and industrial sectors.
- Industry Enthusiasts: Expand your knowledge of lime and minerals applications through detailed case studies.
- Educators and Students: Incorporate real-world examples in coursework related to geology, materials science, and environmental studies.
What the Template Contains
- Preloaded USLM Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- 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, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.