Universal Logistics Holdings, Inc. (ULH) 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
Universal Logistics Holdings, Inc. (ULH) Bundle
Evaluate Universal Logistics Holdings, Inc.'s (ULH) financial outlook like an expert! This (ULH) DCF Calculator provides you with pre-filled financial data and the freedom to modify revenue growth, WACC, margins, and other critical 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,512.0 | 1,391.1 | 1,751.0 | 2,015.5 | 1,662.1 | 1,726.3 | 1,793.0 | 1,862.3 | 1,934.2 | 2,008.9 |
Revenue Growth, % | 0 | -8 | 25.87 | 15.1 | -17.53 | 3.86 | 3.86 | 3.86 | 3.86 | 3.86 |
EBITDA | 170.0 | 154.5 | 203.8 | 317.1 | 225.5 | 218.5 | 227.0 | 235.7 | 244.8 | 254.3 |
EBITDA, % | 11.25 | 11.11 | 11.64 | 15.73 | 13.57 | 12.66 | 12.66 | 12.66 | 12.66 | 12.66 |
Depreciation | 104.7 | 102.0 | 93.6 | 76.7 | 77.0 | 96.8 | 100.5 | 104.4 | 108.5 | 112.6 |
Depreciation, % | 6.92 | 7.33 | 5.35 | 3.8 | 4.63 | 5.61 | 5.61 | 5.61 | 5.61 | 5.61 |
EBIT | 65.4 | 52.5 | 110.2 | 240.4 | 148.5 | 121.7 | 126.4 | 131.3 | 136.4 | 141.7 |
EBIT, % | 4.32 | 3.78 | 6.29 | 11.93 | 8.93 | 7.05 | 7.05 | 7.05 | 7.05 | 7.05 |
Total Cash | 17.1 | 15.3 | 22.0 | 57.2 | 23.3 | 26.7 | 27.7 | 28.8 | 29.9 | 31.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 213.4 | 259.2 | 341.4 | 350.7 | 289.4 | 300.6 | 312.2 | 324.2 | 336.8 | 349.8 |
Account Receivables, % | 14.11 | 18.63 | 19.5 | 17.4 | 17.41 | 17.41 | 17.41 | 17.41 | 17.41 | 17.41 |
Inventories | 7.2 | 8.3 | 14.1 | 11.4 | 12.4 | 11.0 | 11.4 | 11.9 | 12.3 | 12.8 |
Inventories, % | 0.47374 | 0.59493 | 0.80549 | 0.56369 | 0.74639 | 0.63685 | 0.63685 | 0.63685 | 0.63685 | 0.63685 |
Accounts Payable | 91.9 | 97.9 | 117.8 | 87.1 | 64.1 | 96.8 | 100.5 | 104.4 | 108.4 | 112.6 |
Accounts Payable, % | 6.08 | 7.04 | 6.73 | 4.32 | 3.86 | 5.61 | 5.61 | 5.61 | 5.61 | 5.61 |
Capital Expenditure | -79.8 | -90.7 | -38.8 | -117.1 | -240.6 | -118.4 | -123.0 | -127.7 | -132.7 | -137.8 |
Capital Expenditure, % | -5.27 | -6.52 | -2.22 | -5.81 | -14.47 | -6.86 | -6.86 | -6.86 | -6.86 | -6.86 |
Tax Rate, % | 25.26 | 25.26 | 25.26 | 25.26 | 25.26 | 25.26 | 25.26 | 25.26 | 25.26 | 25.26 |
EBITAT | 49.0 | 39.6 | 82.4 | 179.9 | 111.0 | 91.2 | 94.7 | 98.4 | 102.2 | 106.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -54.8 | 10.0 | 69.0 | 102.1 | -15.3 | 92.5 | 64.0 | 66.4 | 69.0 | 71.7 |
WACC, % | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 | 7.14 |
PV UFCF | ||||||||||
SUM PV UFCF | 299.2 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 72 | |||||||||
Terminal Value | 1,085 | |||||||||
Present Terminal Value | 769 | |||||||||
Enterprise Value | 1,068 | |||||||||
Net Debt | 463 | |||||||||
Equity Value | 605 | |||||||||
Diluted Shares Outstanding, MM | 26 | |||||||||
Equity Value Per Share | 22.99 |
What You Will Get
- Pre-Filled Financial Model: Universal Logistics Holdings, Inc. (ULH)’s actual data provides an accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential metrics.
- Instant Calculations: Real-time updates ensure you see outcomes as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, allowing for repeated application in detailed forecasting.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Universal Logistics Holdings, Inc. (ULH).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Assess profitability, leverage, and efficiency ratios specifically for Universal Logistics Holdings, Inc. (ULH).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-formatted Excel file containing Universal Logistics Holdings, Inc. (ULH) financial data.
- Customize: Tailor your forecasts, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and instantly analyze different outcomes.
- Make Decisions: Leverage the valuation insights to inform your investment choices.
Why Choose This Calculator for Universal Logistics Holdings, Inc. (ULH)?
- Designed for Industry Experts: A sophisticated tool tailored for logistics analysts, CFOs, and consultants.
- Comprehensive Data: Universal Logistics' historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Transparent Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Logistics Students: Explore supply chain management techniques and apply them using real industry data.
- Researchers: Integrate advanced logistics models into academic studies or papers.
- Investors: Validate your investment strategies and analyze the performance metrics for Universal Logistics Holdings, Inc. (ULH).
- Supply Chain Analysts: Enhance your analysis with a ready-to-use, customizable logistics model.
- Business Owners: Understand how large logistics firms like Universal Logistics Holdings, Inc. (ULH) are evaluated in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Universal Logistics Holdings, Inc. (ULH) 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 Universal Logistics Holdings, Inc. (ULH).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.