HireQuest, Inc. (HQI) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
HireQuest, Inc. (HQI) Bundle
Gain insights into your HireQuest, Inc. (HQI) valuation analysis using our sophisticated DCF Calculator! This Excel template is preloaded with real (HQI) data, enabling you to adjust forecasts and assumptions to accurately determine HireQuest's intrinsic value.
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 | 15.9 | 13.8 | 22.8 | 31.0 | 37.9 | 48.3 | 61.6 | 78.6 | 100.3 | 127.9 |
Revenue Growth, % | 0 | -13.02 | 64.82 | 35.99 | 22.39 | 27.54 | 27.54 | 27.54 | 27.54 | 27.54 |
EBITDA | 8.3 | 6.7 | 9.2 | 16.3 | 11.6 | 21.7 | 27.7 | 35.3 | 45.0 | 57.4 |
EBITDA, % | 52.19 | 48.57 | 40.43 | 52.59 | 30.75 | 44.91 | 44.91 | 44.91 | 44.91 | 44.91 |
Depreciation | .4 | .1 | 1.6 | 2.0 | 2.8 | 2.3 | 3.0 | 3.8 | 4.9 | 6.2 |
Depreciation, % | 2.52 | 0.93548 | 6.81 | 6.59 | 7.37 | 4.85 | 4.85 | 4.85 | 4.85 | 4.85 |
EBIT | 7.9 | 6.6 | 7.7 | 14.2 | 8.9 | 19.4 | 24.7 | 31.5 | 40.2 | 51.2 |
EBIT, % | 49.66 | 47.64 | 33.61 | 46 | 23.38 | 40.06 | 40.06 | 40.06 | 40.06 | 40.06 |
Total Cash | 4.2 | 13.7 | 1.3 | 3.0 | 1.3 | 13.9 | 17.8 | 22.7 | 28.9 | 36.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 31.6 | 23.5 | 38.2 | 46.5 | 46.2 | 48.3 | 61.6 | 78.6 | 100.3 | 127.9 |
Account Receivables, % | 199.17 | 170.34 | 168.01 | 150.38 | 121.91 | 100 | 100 | 100 | 100 | 100 |
Inventories | 1.0 | 1.4 | .4 | .9 | .0 | 2.1 | 2.6 | 3.4 | 4.3 | 5.5 |
Inventories, % | 6.37 | 10.39 | 1.62 | 2.96 | 0 | 4.27 | 4.27 | 4.27 | 4.27 | 4.27 |
Accounts Payable | .3 | .5 | 1.1 | .4 | .1 | 1.1 | 1.4 | 1.8 | 2.3 | 3.0 |
Accounts Payable, % | 1.6 | 3.31 | 4.95 | 1.45 | 0.36165 | 2.33 | 2.33 | 2.33 | 2.33 | 2.33 |
Capital Expenditure | -.5 | -1.8 | -2.0 | -1.5 | -.1 | -2.9 | -3.7 | -4.7 | -6.0 | -7.6 |
Capital Expenditure, % | -3.2 | -12.78 | -8.68 | -4.77 | -0.2587 | -5.94 | -5.94 | -5.94 | -5.94 | -5.94 |
Tax Rate, % | 21.14 | 21.14 | 21.14 | 21.14 | 21.14 | 21.14 | 21.14 | 21.14 | 21.14 | 21.14 |
EBITAT | -.8 | 5.8 | 7.3 | 12.8 | 7.0 | 13.6 | 17.4 | 22.1 | 28.2 | 36.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -33.3 | 12.0 | -6.1 | 3.8 | 10.6 | 9.9 | 3.1 | 4.0 | 5.1 | 6.5 |
WACC, % | 8.58 | 9.18 | 9.23 | 9.19 | 9.12 | 9.06 | 9.06 | 9.06 | 9.06 | 9.06 |
PV UFCF | ||||||||||
SUM PV UFCF | 22.5 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 7 | |||||||||
Terminal Value | 133 | |||||||||
Present Terminal Value | 86 | |||||||||
Enterprise Value | 109 | |||||||||
Net Debt | 13 | |||||||||
Equity Value | 95 | |||||||||
Diluted Shares Outstanding, MM | 14 | |||||||||
Equity Value Per Share | 6.89 |
What You Will Get
- Real HireQuest Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for HireQuest, Inc. (HQI).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to suit your analysis of HireQuest, Inc. (HQI).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on HireQuest, Inc.'s (HQI) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections specifically for HireQuest, Inc. (HQI).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility for HireQuest, Inc. (HQI).
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for HireQuest, Inc. (HQI).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable parameters for customization.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specific to HireQuest, Inc. (HQI).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring HireQuest, Inc.'s (HQI) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the updated results, including HireQuest, Inc.'s (HQI) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for HireQuest, Inc. (HQI)?
- Designed for Industry Experts: A specialized tool utilized by HR professionals, recruiters, and business strategists.
- Comprehensive Data: HireQuest's historical and projected performance metrics are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various hiring strategies and market conditions.
- Insightful Results: Automatically calculates key performance indicators, ROI, and other essential metrics.
- User-Friendly Interface: Clear, step-by-step guidance ensures a seamless experience.
Who Should Use HireQuest, Inc. (HQI)?
- Job Seekers: Explore diverse employment opportunities across various industries.
- Employers: Streamline your hiring process with our efficient staffing solutions.
- Recruitment Agencies: Enhance your service offerings with our comprehensive tools and resources.
- HR Professionals: Gain insights into workforce trends to make informed hiring decisions.
- Career Coaches: Utilize our platform to guide clients in their job search and career development.
What the Template Contains
- Pre-Filled DCF Model: HireQuest, Inc.'s (HQI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate HireQuest, Inc.'s (HQI) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.