Rush Enterprises, Inc. (RUSHA) 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. (RUSHA) Bundle
Evaluate Rush Enterprises, Inc.'s financial outlook like an expert! This (RUSHA) DCF Calculator provides pre-filled financials and the flexibility to customize revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 Receive
- Pre-Filled Financial Model: Rush Enterprises, Inc.'s (RUSHA) actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Real-Time Calculations: Automatic updates provide immediate results as you make adjustments.
- Professional-Grade Template: An enhanced Excel file crafted for high-quality valuation.
- Flexible and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Rush Enterprises, Inc. (RUSHA).
- WACC Calculation Tool: Pre-configured Weighted Average Cost of Capital sheet with options for customization.
- Customizable Forecast Inputs: Adjust growth projections, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to Rush Enterprises, Inc. (RUSHA).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the ready-to-use Excel file featuring Rush Enterprises, Inc.'s (RUSHA) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop multiple forecasts and evaluate results instantly.
- Make Decisions: Utilize the valuation findings to inform your investment approach.
Why Choose This Calculator for Rush Enterprises, Inc. (RUSHA)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
- Accurate Financial Data: Rush Enterprises’ historical and projected financials preloaded for reliable insights.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance to facilitate your analysis process.
Who Should Use This Product?
- Investors: Assess Rush Enterprises’ valuation prior to making stock transactions.
- CFOs and Financial Analysts: Optimize valuation methodologies and evaluate financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Rush Enterprises.
- Consultants: Create comprehensive valuation reports for your clientele.
- Students and Educators: Utilize real-time data to learn and instruct on valuation practices.
What the Template Contains
- Preloaded RUSHA 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.