Hims & Hers Health, Inc. (HIMS) 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
Hims & Hers Health, Inc. (HIMS) Bundle
Discover the true potential of Hims & Hers Health, Inc. (HIMS) with our advanced DCF Calculator! Adjust essential assumptions, explore various scenarios, and evaluate how fluctuations affect Hims & Hers Health, Inc. (HIMS) valuation – all within a user-friendly Excel template.
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 | 82.6 | 148.8 | 271.9 | 526.9 | 872.0 | 1,574.5 | 2,843.0 | 5,133.3 | 9,268.8 | 16,735.9 |
| Revenue Growth, % | 0 | 80.18 | 82.77 | 93.81 | 65.49 | 80.56 | 80.56 | 80.56 | 80.56 | 80.56 |
| EBITDA | -74.2 | -14.1 | -111.0 | -61.2 | -19.9 | -485.0 | -875.7 | -1,581.2 | -2,855.0 | -5,155.0 |
| EBITDA, % | -89.82 | -9.47 | -40.81 | -11.62 | -2.29 | -30.8 | -30.8 | -30.8 | -30.8 | -30.8 |
| Depreciation | .3 | 1.1 | 4.1 | 7.5 | 9.5 | 15.9 | 28.6 | 51.7 | 93.3 | 168.5 |
| Depreciation, % | 0.31493 | 0.71055 | 1.5 | 1.42 | 1.09 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 |
| EBIT | -74.4 | -15.1 | -115.0 | -68.7 | -29.5 | -500.8 | -904.3 | -1,632.9 | -2,948.3 | -5,323.5 |
| EBIT, % | -90.14 | -10.18 | -42.31 | -13.04 | -3.38 | -31.81 | -31.81 | -31.81 | -31.81 | -31.81 |
| Total Cash | 60.4 | 100.2 | 247.3 | 179.6 | 221.0 | 915.9 | 1,653.8 | 2,986.2 | 5,392.0 | 9,735.9 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .9 | .8 | 3.6 | 3.2 | 5.7 | 13.0 | 23.5 | 42.4 | 76.5 | 138.2 |
| Account Receivables, % | 1.04 | 0.50418 | 1.32 | 0.61319 | 0.65424 | 0.82555 | 0.82555 | 0.82555 | 0.82555 | 0.82555 |
| Inventories | 4.2 | 3.5 | 13.6 | 21.6 | 22.5 | 60.3 | 108.9 | 196.6 | 354.9 | 640.8 |
| Inventories, % | 5.11 | 2.38 | 4.99 | 4.09 | 2.58 | 3.83 | 3.83 | 3.83 | 3.83 | 3.83 |
| Accounts Payable | 7.2 | 8.1 | 19.6 | 32.4 | 43.1 | 102.3 | 184.7 | 333.5 | 602.2 | 1,087.4 |
| Accounts Payable, % | 8.76 | 5.42 | 7.22 | 6.14 | 4.94 | 6.5 | 6.5 | 6.5 | 6.5 | 6.5 |
| Capital Expenditure | -1.8 | -4.2 | -5.0 | -7.2 | -26.5 | -35.5 | -64.1 | -115.7 | -208.8 | -377.1 |
| Capital Expenditure, % | -2.16 | -2.85 | -1.84 | -1.38 | -3.04 | -2.25 | -2.25 | -2.25 | -2.25 | -2.25 |
| Tax Rate, % | -9.16 | -9.16 | -9.16 | -9.16 | -9.16 | -9.16 | -9.16 | -9.16 | -9.16 | -9.16 |
| EBITAT | -74.5 | -15.3 | -111.8 | -68.7 | -32.1 | -498.0 | -899.1 | -1,623.5 | -2,931.3 | -5,292.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -73.9 | -16.8 | -114.0 | -63.4 | -41.8 | -503.5 | -911.2 | -1,645.2 | -2,970.6 | -5,363.9 |
| WACC, % | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 | 9.45 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -7,959.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -5,471 | |||||||||
| Terminal Value | -73,402 | |||||||||
| Present Terminal Value | -46,726 | |||||||||
| Enterprise Value | -54,686 | |||||||||
| Net Debt | -87 | |||||||||
| Equity Value | -54,599 | |||||||||
| Diluted Shares Outstanding, MM | 209 | |||||||||
| Equity Value Per Share | -260.81 |
What You Will Get
- Authentic HIMS Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Hims & Hers Health, Inc. (HIMS).
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Immediate Valuation Adjustments: Automatic recalculations to assess the effects of changes on Hims & Hers Health, Inc. (HIMS)'s fair value.
- Flexible Excel Template: Designed for quick modifications, scenario analysis, and in-depth projections.
- Efficient and Precise: Eliminate the need to build models from the ground up while ensuring accuracy and adaptability.
Key Features
- Comprehensive DCF Calculator: Provides detailed unlevered and levered DCF valuation models tailored for Hims & Hers Health, Inc. (HIMS).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to HIMS.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit HIMS's financial outlook.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Hims & Hers Health, Inc. (HIMS).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Download: Obtain the pre-built Excel file containing Hims & Hers Health, Inc. (HIMS) financial data.
- Customize: Modify projections such as revenue growth, EBITDA %, and WACC as needed.
- Update Automatically: Watch as intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator?
- User-Friendly Interface: Perfectly crafted for both novices and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your analytical needs.
- Real-Time Feedback: Instantly observe changes in Hims & Hers Health, Inc.'s (HIMS) valuation as you modify inputs.
- Preloaded Data: Comes equipped with Hims & Hers' actual financial figures for swift assessments.
- Preferred by Experts: A go-to tool for investors and analysts seeking to make well-informed choices.
Who Should Use Hims & Hers Health, Inc. (HIMS)?
- Healthcare Investors: Make informed decisions with a comprehensive analysis of the health and wellness market.
- Market Analysts: Streamline your research with ready-to-use data and insights on telehealth trends.
- Healthcare Consultants: Easily customize presentations or reports tailored to client needs in the health sector.
- Health Enthusiasts: Expand your knowledge of innovative healthcare solutions and their impact on patient care.
- Educators and Students: Utilize it as a hands-on resource in health economics and business courses.
What the Template Contains
- Pre-Filled Data: Includes Hims & Hers Health, Inc.'s 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 Hims & Hers Health, Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.