Harte Hanks, Inc. (HHS) 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
Harte Hanks, Inc. (HHS) Bundle
Streamline your analysis and improve precision with our [HHS] DCF Calculator! Utilizing real Harte Hanks data and customizable assumptions, this tool empowers you to forecast, assess, and value Harte Hanks, Inc. like a seasoned investor.
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 | 217.6 | 176.9 | 194.6 | 206.3 | 191.5 | 186.8 | 182.2 | 177.7 | 173.3 | 169.0 |
Revenue Growth, % | 0 | -18.7 | 10 | 6 | -7.17 | -2.46 | -2.46 | -2.46 | -2.46 | -2.46 |
EBITDA | -4.5 | -13.5 | 15.2 | 22.5 | 9.9 | 5.3 | 5.2 | 5.0 | 4.9 | 4.8 |
EBITDA, % | -2.05 | -7.65 | 7.81 | 10.9 | 5.16 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 |
Depreciation | 5.3 | 3.6 | 2.6 | 2.7 | 4.2 | 3.5 | 3.4 | 3.3 | 3.2 | 3.2 |
Depreciation, % | 2.45 | 2.04 | 1.32 | 1.32 | 2.21 | 1.87 | 1.87 | 1.87 | 1.87 | 1.87 |
EBIT | -9.8 | -17.1 | 12.6 | 19.8 | 5.7 | 1.8 | 1.8 | 1.7 | 1.7 | 1.6 |
EBIT, % | -4.51 | -9.69 | 6.49 | 9.57 | 2.95 | 0.96452 | 0.96452 | 0.96452 | 0.96452 | 0.96452 |
Total Cash | 28.1 | 29.4 | 11.9 | 10.4 | 18.4 | 18.8 | 18.3 | 17.9 | 17.4 | 17.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 39.8 | 42.1 | 49.8 | 47.9 | 42.2 | 42.2 | 41.2 | 40.2 | 39.2 | 38.2 |
Account Receivables, % | 18.28 | 23.82 | 25.6 | 23.22 | 22.06 | 22.6 | 22.6 | 22.6 | 22.6 | 22.6 |
Inventories | .4 | .0 | 12.6 | 2.2 | .0 | 2.9 | 2.8 | 2.8 | 2.7 | 2.6 |
Inventories, % | 0.1627 | 0.02600339 | 6.49 | 1.06 | 0 | 1.55 | 1.55 | 1.55 | 1.55 | 1.55 |
Accounts Payable | 16.9 | 16.3 | 16.1 | 22.5 | 23.2 | 18.0 | 17.6 | 17.2 | 16.7 | 16.3 |
Accounts Payable, % | 7.78 | 9.21 | 8.29 | 10.89 | 12.1 | 9.65 | 9.65 | 9.65 | 9.65 | 9.65 |
Capital Expenditure | -2.9 | -2.7 | -3.0 | -5.8 | -2.8 | -3.3 | -3.2 | -3.1 | -3.0 | -2.9 |
Capital Expenditure, % | -1.33 | -1.53 | -1.57 | -2.81 | -1.47 | -1.74 | -1.74 | -1.74 | -1.74 | -1.74 |
Tax Rate, % | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 | 18.19 |
EBITAT | -10.5 | -1.6 | 11.6 | 37.6 | 4.6 | 1.4 | 1.3 | 1.3 | 1.3 | 1.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -31.3 | -3.4 | -9.3 | 53.2 | 14.6 | -6.4 | 2.2 | 2.2 | 2.1 | 2.1 |
WACC, % | 6.19 | 4.5 | 6.05 | 6.19 | 5.85 | 5.76 | 5.76 | 5.76 | 5.76 | 5.76 |
PV UFCF | ||||||||||
SUM PV UFCF | 1.1 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 2 | |||||||||
Terminal Value | 40 | |||||||||
Present Terminal Value | 30 | |||||||||
Enterprise Value | 31 | |||||||||
Net Debt | 10 | |||||||||
Equity Value | 21 | |||||||||
Diluted Shares Outstanding, MM | 7 | |||||||||
Equity Value Per Share | 2.89 |
What You Will Get
- Real Harte Hanks Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Harte Hanks, Inc. (HHS).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates specific to Harte Hanks, Inc. (HHS).
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Harte Hanks, Inc.'s (HHS) fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections for Harte Hanks, Inc. (HHS).
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility with Harte Hanks, Inc. (HHS).
Key Features
- Real-Life HHS Data: Pre-filled with Harte Hanks' historical financials and forward-looking projections.
- Fully Customizable Inputs: Adjust revenue growth, margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Create multiple forecast scenarios to analyze different valuation outcomes.
- User-Friendly Design: Simple, structured, and designed for professionals and beginners alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Harte Hanks data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Harte Hanks, Inc.'s (HHS) intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Harte Hanks, Inc. (HHS)?
- Accurate Data: Utilize real Harte Hanks financials for trustworthy valuation outcomes.
- Customizable: Tailor key variables such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the field.
- User-Friendly: With an intuitive design and clear step-by-step guidance, it's accessible for all users.
Who Should Use Harte Hanks, Inc. (HHS)?
- Marketers: Enhance your campaigns with data-driven insights and analytics.
- Business Analysts: Streamline your workflow with robust tools for customer engagement analysis.
- Consultants: Easily tailor solutions for client needs using our comprehensive marketing resources.
- Brand Managers: Gain a competitive edge by leveraging our innovative marketing strategies.
- Students and Educators: Utilize our materials for a hands-on approach to marketing education.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Harte Hanks historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Harte Hanks, Inc. (HHS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.