Heartland Express, Inc. (HTLD) 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
Heartland Express, Inc. (HTLD) Bundle
Evaluate Heartland Express, Inc.'s (HTLD) financial outlook like an expert! This (HTLD) DCF Calculator comes with pre-filled financials and offers full 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 | 596.8 | 645.3 | 607.3 | 968.0 | 1,207.5 | 1,468.2 | 1,785.2 | 2,170.6 | 2,639.3 | 3,209.2 |
Revenue Growth, % | 0 | 8.12 | -5.89 | 59.4 | 24.74 | 21.59 | 21.59 | 21.59 | 21.59 | 21.59 |
EBITDA | 198.4 | 204.2 | 210.1 | 224.5 | 243.1 | 419.4 | 509.9 | 620.0 | 753.9 | 916.7 |
EBITDA, % | 33.25 | 31.65 | 34.6 | 23.19 | 20.13 | 28.56 | 28.56 | 28.56 | 28.56 | 28.56 |
Depreciation | 100.2 | 109.9 | 104.1 | 133.0 | 199.0 | 238.4 | 289.9 | 352.5 | 428.6 | 521.1 |
Depreciation, % | 16.79 | 17.04 | 17.14 | 13.74 | 16.48 | 16.24 | 16.24 | 16.24 | 16.24 | 16.24 |
EBIT | 98.2 | 94.3 | 106.0 | 91.5 | 44.0 | 181.0 | 220.0 | 267.5 | 325.3 | 395.5 |
EBIT, % | 16.46 | 14.61 | 17.46 | 9.45 | 3.65 | 12.32 | 12.32 | 12.32 | 12.32 | 12.32 |
Total Cash | 76.7 | 113.9 | 157.7 | 49.5 | 28.1 | 187.7 | 228.2 | 277.4 | 337.3 | 410.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 57.1 | 55.6 | 56.9 | 143.0 | 112.9 | 151.7 | 184.5 | 224.3 | 272.7 | 331.6 |
Account Receivables, % | 9.56 | 8.61 | 9.37 | 14.77 | 9.35 | 10.33 | 10.33 | 10.33 | 10.33 | 10.33 |
Inventories | 9.1 | 8.2 | 9.2 | 11.3 | .0 | 16.1 | 19.6 | 23.8 | 28.9 | 35.2 |
Inventories, % | 1.53 | 1.28 | 1.51 | 1.17 | 0 | 1.1 | 1.1 | 1.1 | 1.1 | 1.1 |
Accounts Payable | 11.1 | 12.8 | 20.5 | 62.7 | 37.8 | 49.4 | 60.0 | 73.0 | 88.8 | 107.9 |
Accounts Payable, % | 1.85 | 1.98 | 3.38 | 6.48 | 3.13 | 3.36 | 3.36 | 3.36 | 3.36 | 3.36 |
Capital Expenditure | -163.8 | -204.3 | -132.6 | -160.6 | -208.6 | -337.1 | -409.9 | -498.4 | -606.1 | -736.9 |
Capital Expenditure, % | -27.44 | -31.67 | -21.84 | -16.59 | -17.28 | -22.96 | -22.96 | -22.96 | -22.96 | -22.96 |
Tax Rate, % | 25.58 | 25.58 | 25.58 | 25.58 | 25.58 | 25.58 | 25.58 | 25.58 | 25.58 | 25.58 |
EBITAT | 73.8 | 70.8 | 79.3 | 67.5 | 32.8 | 135.0 | 164.2 | 199.7 | 242.8 | 295.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -44.9 | -19.5 | 56.3 | -6.1 | 39.6 | -7.0 | 18.6 | 22.6 | 27.5 | 33.4 |
WACC, % | 7.23 | 7.23 | 7.22 | 7.2 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 | 7.22 |
PV UFCF | ||||||||||
SUM PV UFCF | 72.5 | |||||||||
Long Term Growth Rate, % | 1.00 | |||||||||
Free cash flow (T + 1) | 34 | |||||||||
Terminal Value | 543 | |||||||||
Present Terminal Value | 383 | |||||||||
Enterprise Value | 456 | |||||||||
Net Debt | 289 | |||||||||
Equity Value | 166 | |||||||||
Diluted Shares Outstanding, MM | 79 | |||||||||
Equity Value Per Share | 2.10 |
What You Will Get
- Real Heartland Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Heartland Express, Inc. (HTLD).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specifically for Heartland Express, Inc. (HTLD).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Heartland Express, Inc. (HTLD)’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections related to Heartland Express, Inc. (HTLD).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for Heartland Express, Inc. (HTLD).
Key Features
- Pre-Loaded Data: Heartland Express, Inc.'s (HTLD) historical financial statements and pre-filled forecasts.
- Fully Adjustable Inputs: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Instant Results: View Heartland Express, Inc.'s (HTLD) intrinsic value recalculating in real time.
- Clear Visual Outputs: Dashboard charts illustrate valuation results and key metrics effectively.
- Built for Accuracy: A professional tool tailored for analysts, investors, and finance experts.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Heartland Express, Inc. (HTLD) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Heartland Express, Inc. (HTLD)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Heartland Express, Inc. (HTLD)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and transportation consultants.
- Comprehensive Data: Heartland Express’s historical and projected financials preloaded for enhanced precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Experience: Step-by-step guidance to navigate through the calculations seamlessly.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing Heartland Express, Inc. (HTLD) investments.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in Heartland Express, Inc. (HTLD) stock.
- Students and Educators: Utilize real-world data to enhance financial modeling skills and education.
- Logistics and Transportation Enthusiasts: Gain insight into how companies like Heartland Express, Inc. (HTLD) are valued in the logistics sector.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for Heartland Express, Inc. (HTLD).
- Real-World Data: Heartland Express's historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns providing deeper insights into the company's performance.
- Key Ratios: Built-in analysis for assessing profitability, efficiency, and leverage specific to Heartland Express, Inc. (HTLD).
- Dashboard with Visual Outputs: Interactive charts and tables that present clear, actionable results.