Radiant Logistics, Inc. (RLGT) 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
Radiant Logistics, Inc. (RLGT) Bundle
Take charge of your Radiant Logistics, Inc. (RLGT) valuation analysis using our cutting-edge DCF Calculator! Preloaded with real RLGT data, this Excel template enables you to adjust forecasts and assumptions to accurately determine Radiant Logistics' intrinsic value.
Discounted Cash Flow (DCF) - (USD MM)
Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue | 855.2 | 889.1 | 1,459.4 | 1,085.5 | 802.5 | 835.4 | 869.7 | 905.4 | 942.5 | 981.2 |
Revenue Growth, % | 0 | 3.97 | 64.14 | -25.62 | -26.07 | 4.1 | 4.1 | 4.1 | 4.1 | 4.1 |
EBITDA | 36.3 | 47.2 | 78.1 | 50.2 | 28.9 | 38.6 | 40.2 | 41.9 | 43.6 | 45.4 |
EBITDA, % | 4.25 | 5.31 | 5.35 | 4.62 | 3.6 | 4.63 | 4.63 | 4.63 | 4.63 | 4.63 |
Depreciation | 16.6 | 16.6 | 18.7 | 22.7 | 18.1 | 15.8 | 16.4 | 17.1 | 17.8 | 18.5 |
Depreciation, % | 1.94 | 1.87 | 1.28 | 2.09 | 2.25 | 1.89 | 1.89 | 1.89 | 1.89 | 1.89 |
EBIT | 19.8 | 30.6 | 59.4 | 27.5 | 10.8 | 22.9 | 23.8 | 24.8 | 25.8 | 26.9 |
EBIT, % | 2.31 | 3.44 | 4.07 | 2.53 | 1.34 | 2.74 | 2.74 | 2.74 | 2.74 | 2.74 |
Total Cash | 34.8 | 13.7 | 24.4 | 32.5 | 24.9 | 22.4 | 23.3 | 24.2 | 25.2 | 26.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 88.9 | 162.4 | 247.6 | 132.9 | 128.8 | 123.5 | 128.6 | 133.9 | 139.3 | 145.1 |
Account Receivables, % | 10.4 | 18.26 | 16.97 | 12.24 | 16.05 | 14.78 | 14.78 | 14.78 | 14.78 | 14.78 |
Inventories | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Inventories, % | 0.000000117 | 0 | 0 | 0.0000000921 | 0 | 0.0000000418 | 0.0000000418 | 0.0000000418 | 0.0000000418 | 0.0000000418 |
Accounts Payable | 65.0 | 103.7 | 137.9 | 84.6 | 73.6 | 76.3 | 79.4 | 82.7 | 86.1 | 89.6 |
Accounts Payable, % | 7.6 | 11.66 | 9.45 | 7.79 | 9.17 | 9.13 | 9.13 | 9.13 | 9.13 | 9.13 |
Capital Expenditure | -5.2 | -11.4 | -7.5 | -7.6 | -8.6 | -7.0 | -7.3 | -7.6 | -7.9 | -8.2 |
Capital Expenditure, % | -0.60512 | -1.29 | -0.51144 | -0.69692 | -1.07 | -0.83404 | -0.83404 | -0.83404 | -0.83404 | -0.83404 |
Tax Rate, % | 20.94 | 20.94 | 20.94 | 20.94 | 20.94 | 20.94 | 20.94 | 20.94 | 20.94 | 20.94 |
EBITAT | 13.4 | 24.1 | 45.4 | 20.5 | 8.5 | 17.2 | 17.9 | 18.7 | 19.5 | 20.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | .9 | -5.5 | 5.5 | 97.1 | 11.2 | 34.0 | 25.2 | 26.2 | 27.3 | 28.4 |
WACC, % | 7.57 | 7.65 | 7.63 | 7.62 | 7.65 | 7.63 | 7.63 | 7.63 | 7.63 | 7.63 |
PV UFCF | ||||||||||
SUM PV UFCF | 114.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 29 | |||||||||
Terminal Value | 515 | |||||||||
Present Terminal Value | 357 | |||||||||
Enterprise Value | 471 | |||||||||
Net Debt | 33 | |||||||||
Equity Value | 438 | |||||||||
Diluted Shares Outstanding, MM | 49 | |||||||||
Equity Value Per Share | 8.97 |
What You Will Get
- Comprehensive RLGT Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Dynamic Calculations: Intrinsic value and NPV are updated in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Radiant Logistics' future performance.
- User-Friendly Interface: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Data: Radiant Logistics’ historical financial statements and pre-loaded projections.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Results: Monitor Radiant Logistics’ intrinsic value recalculating instantly.
- Visual Analytics: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A professional-grade tool for analysts, investors, and finance professionals.
How It Works
- 1. Access the Template: Download and open the Excel file containing Radiant Logistics, Inc.'s (RLGT) preloaded data.
- 2. Modify Assumptions: Adjust key inputs such as growth rates, WACC, and capital expenditures.
- 3. Instant Results: The DCF model automatically calculates intrinsic value and NPV in real-time.
- 4. Analyze Scenarios: Evaluate various forecasts to explore different valuation results.
- 5. Present with Assurance: Deliver professional valuation insights to back your strategic decisions.
Why Choose This Calculator for Radiant Logistics, Inc. (RLGT)?
- User-Friendly Interface: Crafted for both novices and experienced users.
- Customizable Inputs: Easily adjust parameters to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to Radiant Logistics’ valuation as you modify inputs.
- Preconfigured Data: Comes loaded with Radiant Logistics’ actual financial metrics for swift evaluations.
- Endorsed by Experts: Utilized by investors and financial analysts for informed decision-making.
Who Should Use This Product?
- Logistics Students: Understand supply chain dynamics and apply them using real-world data.
- Academics: Integrate industry models into your teaching or scholarly research.
- Investors: Validate your investment strategies and evaluate performance metrics for Radiant Logistics, Inc. (RLGT).
- Analysts: Enhance your analysis process with a ready-to-use, customizable financial model.
- Small Business Owners: Discover how major logistics firms like Radiant Logistics, Inc. (RLGT) are evaluated.
What the Template Contains
- Preloaded RLGT 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.