Rush Enterprises, Inc. (RUSHB) 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
Rush Enterprises, Inc. (RUSHB) Bundle
Gain a comprehensive understanding of your Rush Enterprises, Inc. (RUSHB) valuation analysis using our state-of-the-art DCF Calculator! Featuring real-time data for (RUSHB), this Excel template lets you adjust forecasts and assumptions to accurately determine the intrinsic value of Rush Enterprises, Inc.
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 | 5,809.8 | 4,735.9 | 5,126.1 | 7,101.7 | 7,925.0 | 8,715.3 | 9,584.4 | 10,540.1 | 11,591.1 | 12,747.0 |
Revenue Growth, % | 0 | -18.48 | 8.24 | 38.54 | 11.59 | 9.97 | 9.97 | 9.97 | 9.97 | 9.97 |
EBITDA | 392.0 | 330.1 | 477.1 | 702.8 | 736.9 | 735.9 | 809.3 | 890.0 | 978.7 | 1,076.3 |
EBITDA, % | 6.75 | 6.97 | 9.31 | 9.9 | 9.3 | 8.44 | 8.44 | 8.44 | 8.44 | 8.44 |
Depreciation | 175.5 | 177.3 | 169.5 | 199.1 | 221.1 | 273.1 | 300.3 | 330.2 | 363.2 | 399.4 |
Depreciation, % | 3.02 | 3.74 | 3.31 | 2.8 | 2.79 | 3.13 | 3.13 | 3.13 | 3.13 | 3.13 |
EBIT | 216.5 | 152.8 | 307.6 | 503.7 | 515.8 | 462.8 | 509.0 | 559.7 | 615.6 | 676.9 |
EBIT, % | 3.73 | 3.23 | 6 | 7.09 | 6.51 | 5.31 | 5.31 | 5.31 | 5.31 | 5.31 |
Total Cash | 181.6 | 312.0 | 148.1 | 201.0 | 183.7 | 309.5 | 340.3 | 374.3 | 411.6 | 452.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 183.7 | 172.5 | 140.2 | 220.7 | 259.4 | 277.5 | 305.1 | 335.6 | 369.0 | 405.8 |
Account Receivables, % | 3.16 | 3.64 | 2.73 | 3.11 | 3.27 | 3.18 | 3.18 | 3.18 | 3.18 | 3.18 |
Inventories | 1,326.1 | 858.3 | 1,020.1 | 1,429.4 | 1,801.4 | 1,807.7 | 1,987.9 | 2,186.2 | 2,404.2 | 2,643.9 |
Inventories, % | 22.82 | 18.12 | 19.9 | 20.13 | 22.73 | 20.74 | 20.74 | 20.74 | 20.74 | 20.74 |
Accounts Payable | 133.7 | 110.7 | 122.3 | 171.7 | 162.1 | 200.3 | 220.2 | 242.2 | 266.3 | 292.9 |
Accounts Payable, % | 2.3 | 2.34 | 2.39 | 2.42 | 2.05 | 2.3 | 2.3 | 2.3 | 2.3 | 2.3 |
Capital Expenditure | -293.5 | -136.2 | -167.2 | -243.1 | -368.9 | -335.8 | -369.3 | -406.1 | -446.6 | -491.2 |
Capital Expenditure, % | -5.05 | -2.88 | -3.26 | -3.42 | -4.65 | -3.85 | -3.85 | -3.85 | -3.85 | -3.85 |
Tax Rate, % | 24.89 | 24.89 | 24.89 | 24.89 | 24.89 | 24.89 | 24.89 | 24.89 | 24.89 | 24.89 |
EBITAT | 161.7 | 115.7 | 236.7 | 387.0 | 387.4 | 351.1 | 386.2 | 424.7 | 467.0 | 513.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,332.4 | 612.9 | 121.1 | -97.2 | -180.7 | 302.2 | 129.2 | 142.1 | 156.2 | 171.8 |
WACC, % | 7.48 | 7.5 | 7.51 | 7.51 | 7.49 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 |
PV UFCF | ||||||||||
SUM PV UFCF | 744.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 175 | |||||||||
Terminal Value | 3,188 | |||||||||
Present Terminal Value | 2,221 | |||||||||
Enterprise Value | 2,965 | |||||||||
Net Debt | 1,626 | |||||||||
Equity Value | 1,339 | |||||||||
Diluted Shares Outstanding, MM | 84 | |||||||||
Equity Value Per Share | 16.00 |
What You Will Get
- Real Rush Enterprises Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Rush Enterprises’ fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Rush Enterprises, Inc. (RUSHB).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Rush Enterprises, Inc. (RUSHB).
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit Rush Enterprises, Inc. (RUSHB) scenarios.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Rush Enterprises, Inc. (RUSHB).
- Visual Dashboard and Charts: Graphical outputs present key valuation metrics for straightforward analysis of Rush Enterprises, Inc. (RUSHB).
How It Works
- 1. Access the Template: Download and open the Excel file featuring Rush Enterprises, Inc.'s preloaded data.
- 2. Modify Assumptions: Adjust critical inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Explore Scenarios: Analyze various forecasts to evaluate different valuation results.
- 5. Present with Confidence: Share professional valuation insights to inform your strategic decisions.
Why Choose Rush Enterprises, Inc. (RUSHB)?
- Streamlined Operations: Benefit from our efficient processes that save you time and resources.
- Enhanced Reliability: Our robust financial metrics ensure accurate assessments and decisions.
- Fully Adaptable: Customize our services to meet your specific business needs and goals.
- User-Friendly Experience: Intuitive interfaces and clear data presentation facilitate easy understanding.
- Preferred by Industry Leaders: Trusted by professionals who prioritize excellence and effectiveness.
Who Should Use This Product?
- Finance Students: Explore industry-specific valuation methods and apply them to real-world data.
- Academics: Integrate advanced financial models into your teaching or research on Rush Enterprises, Inc. (RUSHB).
- Investors: Validate your investment strategies and evaluate valuation metrics for Rush Enterprises, Inc. (RUSHB).
- Analysts: Enhance your analysis process with a ready-to-use, customizable DCF model tailored for Rush Enterprises, Inc. (RUSHB).
- Small Business Owners: Learn how public companies like Rush Enterprises, Inc. (RUSHB) are valued and analyzed.
What the Template Contains
- Pre-Filled Data: Includes Rush Enterprises’ historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Rush Enterprises’ profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.