|
Valoración de DCF de Atlanticus Holdings Corporation (ATLC)
US | Financial Services | Financial - Credit Services | NASDAQ
|
- ✓ 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
Atlanticus Holdings Corporation (ATLC) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de Atlanticus Holdings Corporation (ATLC)! Utilice datos financieros precisos, ajuste las proyecciones y gastos de crecimiento, y observe instantáneamente cómo estas modificaciones afectan el valor intrínseco de Atlanticus Holdings Corporation (ATLC).
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 | 350.1 | 340.3 | 399.8 | 292.6 | 1,155.2 | 1,409.0 | 1,718.5 | 2,095.9 | 2,556.2 | 3,117.7 |
| Revenue Growth, % | 0 | -2.82 | 17.5 | -26.82 | 294.87 | 21.96 | 21.96 | 21.96 | 21.96 | 21.96 |
| EBITDA | 45.2 | .0 | .0 | .0 | 241.9 | 95.4 | 116.3 | 141.9 | 173.1 | 211.1 |
| EBITDA, % | 12.91 | 0 | 0 | 0 | 20.94 | 6.77 | 6.77 | 6.77 | 6.77 | 6.77 |
| Depreciation | 416.7 | 397.5 | 444.9 | 815.8 | 4.0 | 1,128.2 | 1,376.0 | 1,678.2 | 2,046.8 | 2,496.3 |
| Depreciation, % | 119.01 | 116.81 | 111.29 | 278.84 | 0.34997 | 80.07 | 80.07 | 80.07 | 80.07 | 80.07 |
| EBIT | -371.5 | -397.5 | -444.9 | -815.8 | 237.9 | -1,069.2 | -1,304.0 | -1,590.4 | -1,939.7 | -2,365.7 |
| EBIT, % | -106.1 | -116.81 | -111.29 | -278.84 | 20.59 | -75.88 | -75.88 | -75.88 | -75.88 | -75.88 |
| Total Cash | 135.5 | 178.1 | 409.7 | 385.0 | 383.7 | 913.7 | 1,114.4 | 1,359.2 | 1,657.7 | 2,021.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | 3,721.7 | 2,272.2 | 563.6 | 687.4 | 838.4 | 1,022.5 | 1,247.1 |
| Account Receivables, % | 0 | 0 | 0 | 1272.11 | 196.68 | 40 | 40 | 40 | 40 | 40 |
| Inventories | -1,365.8 | -1,621.0 | -2,343.1 | 433.2 | .0 | -563.6 | -687.4 | -838.4 | -1,022.5 | -1,247.1 |
| Inventories, % | -390.09 | -476.38 | -586.08 | 148.07 | 0 | -40 | -40 | -40 | -40 | -40 |
| Accounts Payable | 41.6 | 41.7 | 42.3 | 44.3 | 61.6 | 155.6 | 189.8 | 231.5 | 282.3 | 344.3 |
| Accounts Payable, % | 11.89 | 12.26 | 10.58 | 15.15 | 5.34 | 11.04 | 11.04 | 11.04 | 11.04 | 11.04 |
| Capital Expenditure | -.3 | -.7 | -7.1 | -4.9 | -4.0 | -11.5 | -14.0 | -17.1 | -20.8 | -25.4 |
| Capital Expenditure, % | -0.07140123 | -0.22012 | -1.77 | -1.66 | -0.34555 | -0.81373 | -0.81373 | -0.81373 | -0.81373 | -0.81373 |
| Tax Rate, % | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 |
| EBITAT | -309.3 | -327.0 | -360.5 | -741.1 | 190.3 | -892.5 | -1,088.5 | -1,327.6 | -1,619.2 | -1,974.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 1,514.6 | 324.9 | 800.1 | -6,426.1 | 2,090.4 | 2,590.3 | 307.6 | 375.2 | 457.6 | 558.1 |
| WACC, % | 7.64 | 7.6 | 7.56 | 7.91 | 7.52 | 7.65 | 7.65 | 7.65 | 7.65 | 7.65 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 3,699.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 569 | |||||||||
| Terminal Value | 10,083 | |||||||||
| Present Terminal Value | 6,976 | |||||||||
| Enterprise Value | 10,675 | |||||||||
| Net Debt | 1,643 | |||||||||
| Equity Value | 9,033 | |||||||||
| Diluted Shares Outstanding, MM | 19 | |||||||||
| Equity Value Per Share | 478.38 |
What You Will Get
- Real ATLC Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Atlanticus Holdings' future performance.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Financial Data: Atlanticus Holdings Corporation’s historical financial statements and detailed forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Valuation: Observe Atlanticus Holdings Corporation’s intrinsic value update instantly.
- Intuitive Visualizations: Dashboard charts provide clear insights into valuation results and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the prebuilt Excel template that includes Atlanticus Holdings Corporation (ATLC) data.
- Step 2: Review 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 recalculated results, including Atlanticus Holdings Corporation (ATLC)'s intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create reports.
Why Choose This Calculator for Atlanticus Holdings Corporation (ATLC)?
- Accuracy: Utilizes authentic Atlanticus financial data for precise calculations.
- Flexibility: Tailored for users to easily adjust and explore various input scenarios.
- Time-Saving: Eliminate the need to construct a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and attention to detail expected at the CFO level.
- User-Friendly: Intuitive interface designed for users of all financial skill levels.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Atlanticus Holdings Corporation (ATLC) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models specific to Atlanticus Holdings Corporation (ATLC).
- Consultants: Deliver professional valuation insights regarding Atlanticus Holdings Corporation (ATLC) to clients quickly and accurately.
- Business Owners: Understand how companies like Atlanticus Holdings Corporation (ATLC) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Atlanticus Holdings Corporation (ATLC).
What the Template Contains
- Pre-Filled Data: Includes Atlanticus Holdings Corporation’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 Atlanticus Holdings Corporation’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.