Life Time Group Holdings, Inc. (LTH) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Life Time Group Holdings, Inc. (LTH) Bundle
Streamline your analysis and improve precision with our [Symbol] DCF Calculator! Utilizing real data from Life Time Group Holdings, Inc. and customizable assumptions, this tool empowers you to forecast, assess, and value [Company] 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 | 1,900.4 | 948.4 | 1,318.1 | 1,822.6 | 2,216.6 | 2,486.9 | 2,790.2 | 3,130.5 | 3,512.2 | 3,940.6 |
Revenue Growth, % | 0 | -50.1 | 38.98 | 38.28 | 21.62 | 12.2 | 12.2 | 12.2 | 12.2 | 12.2 |
EBITDA | 397.1 | -111.6 | -260.1 | 339.5 | 470.0 | 145.3 | 163.1 | 183.0 | 205.3 | 230.3 |
EBITDA, % | 20.9 | -11.77 | -19.73 | 18.63 | 21.2 | 5.84 | 5.84 | 5.84 | 5.84 | 5.84 |
Depreciation | 220.5 | 247.7 | 235.1 | 267.4 | 244.4 | 404.2 | 453.4 | 508.7 | 570.8 | 640.4 |
Depreciation, % | 11.6 | 26.12 | 17.84 | 14.67 | 11.03 | 16.25 | 16.25 | 16.25 | 16.25 | 16.25 |
EBIT | 176.6 | -359.3 | -495.2 | 72.1 | 225.6 | -258.8 | -290.4 | -325.8 | -365.5 | -410.1 |
EBIT, % | 9.29 | -37.89 | -37.57 | 3.96 | 10.18 | -10.41 | -10.41 | -10.41 | -10.41 | -10.41 |
Total Cash | 48.0 | 33.2 | 31.6 | 25.5 | 30.0 | 55.6 | 62.4 | 70.0 | 78.5 | 88.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 58.4 | 21.4 | 24.9 | 23.0 | 59.3 | 55.5 | 62.3 | 69.8 | 78.4 | 87.9 |
Account Receivables, % | 3.07 | 2.26 | 1.89 | 1.26 | 2.67 | 2.23 | 2.23 | 2.23 | 2.23 | 2.23 |
Inventories | 44.3 | 36.3 | 41.0 | 45.7 | 52.8 | 70.4 | 79.0 | 88.6 | 99.4 | 111.6 |
Inventories, % | 2.33 | 3.83 | 3.11 | 2.5 | 2.38 | 2.83 | 2.83 | 2.83 | 2.83 | 2.83 |
Accounts Payable | 54.0 | 54.1 | 71.3 | 74.0 | 81.3 | 107.8 | 121.0 | 135.7 | 152.3 | 170.8 |
Accounts Payable, % | 2.84 | 5.7 | 5.41 | 4.06 | 3.67 | 4.34 | 4.34 | 4.34 | 4.34 | 4.34 |
Capital Expenditure | -624.0 | -265.6 | -328.9 | -591.2 | -693.9 | -743.8 | -834.5 | -936.3 | -1,050.4 | -1,178.5 |
Capital Expenditure, % | -32.84 | -28.01 | -24.95 | -32.44 | -31.3 | -29.91 | -29.91 | -29.91 | -29.91 | -29.91 |
Tax Rate, % | 19.76 | 19.76 | 19.76 | 19.76 | 19.76 | 19.76 | 19.76 | 19.76 | 19.76 | 19.76 |
EBITAT | 132.2 | -265.4 | -398.6 | 49.4 | 181.0 | -195.6 | -219.5 | -246.2 | -276.3 | -309.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -320.1 | -238.2 | -483.5 | -274.4 | -304.6 | -522.5 | -602.7 | -676.2 | -758.7 | -851.2 |
WACC, % | 8.47 | 8.45 | 8.6 | 8.34 | 8.59 | 8.49 | 8.49 | 8.49 | 8.49 | 8.49 |
PV UFCF | ||||||||||
SUM PV UFCF | -2,637.2 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | -885 | |||||||||
Terminal Value | -19,714 | |||||||||
Present Terminal Value | -13,116 | |||||||||
Enterprise Value | -15,753 | |||||||||
Net Debt | 4,231 | |||||||||
Equity Value | -19,984 | |||||||||
Diluted Shares Outstanding, MM | 204 | |||||||||
Equity Value Per Share | -97.96 |
What You Will Get
- Editable Forecast Inputs: Effortlessly adjust key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Life Time Group Holdings, Inc. (LTH) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to precise historical performance and future forecasts for Life Time Group Holdings, Inc. (LTH).
- Adjustable Forecast Parameters: Modify highlighted fields such as WACC, growth rates, and profit margins to suit your analysis.
- Automated Calculations: Real-time updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to effectively visualize your valuation outcomes.
- Designed for All Skill Levels: A clear, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- 1. Access the Template: Download and open the Excel file containing Life Time Group Holdings, Inc. (LTH) preloaded data.
- 2. Adjust Key Inputs: Modify critical assumptions such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Different Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to reinforce your strategic decisions.
Why Choose This Calculator for Life Time Group Holdings, Inc. (LTH)?
- Accuracy: Utilizes authentic Life Time financials to ensure precise data.
- Flexibility: Built for users to easily experiment and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected by CFOs.
- User-Friendly: Intuitive design makes it accessible for users with varying levels of financial modeling experience.
Who Should Use This Product?
- Investors: Accurately assess Life Time Group Holdings, Inc.'s (LTH) fair value prior to making investment choices.
- CFOs: Utilize a high-quality DCF model for comprehensive financial reporting and analysis.
- Consultants: Easily modify the template for client valuation reports.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading companies.
- Educators: Implement it as a teaching resource to illustrate valuation techniques.
What the Template Contains
- Pre-Filled Data: Includes Life Time Group Holdings, Inc.'s (LTH) historical financials and projections.
- Discounted Cash Flow Model: Editable DCF valuation model featuring automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on user-defined inputs.
- Key Financial Ratios: Assess Life Time Group Holdings, Inc.'s (LTH) profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
- Clear Dashboard: Visualizations and tables summarizing essential valuation outcomes.