|
Valoración de DCF de MOGO Inc. (MOGO)
CA | Technology | Software - Infrastructure | 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
Mogo Inc. (MOGO) Bundle
¡Simplifique la valoración de Mogo Inc. (MOGO) con esta calculadora DCF personalizable! Con el Real Mogo Inc. (MOGO) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de MOGO Inc. (MOGO) en minutos.
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 | 41.5 | 30.7 | 39.9 | 47.9 | 45.0 | 47.0 | 49.1 | 51.3 | 53.6 | 56.0 |
Revenue Growth, % | 0 | -26.02 | 30 | 19.87 | -5.97 | 4.47 | 4.47 | 4.47 | 4.47 | 4.47 |
EBITDA | 11.8 | 1.5 | -3.1 | -30.2 | -1.5 | -3.9 | -4.0 | -4.2 | -4.4 | -4.6 |
EBITDA, % | 28.44 | 4.81 | -7.76 | -63.13 | -3.39 | -8.21 | -8.21 | -8.21 | -8.21 | -8.21 |
Depreciation | 58.1 | 30.4 | 54.8 | 72.3 | 6.3 | 38.8 | 40.6 | 42.4 | 44.3 | 46.3 |
Depreciation, % | 139.98 | 98.8 | 137.24 | 150.97 | 13.98 | 82.56 | 82.56 | 82.56 | 82.56 | 82.56 |
EBIT | -46.3 | -28.9 | -57.9 | -102.5 | -7.8 | -38.7 | -40.4 | -42.2 | -44.1 | -46.1 |
EBIT, % | -111.54 | -93.99 | -145 | -214.1 | -17.37 | -82.27 | -82.27 | -82.27 | -82.27 | -82.27 |
Total Cash | 3.7 | 8.4 | 48.1 | 20.3 | 11.2 | 19.2 | 20.0 | 20.9 | 21.8 | 22.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | 32.8 | 3.7 | 5.0 | .0 | 11.3 | 11.8 | 12.3 | 12.8 | 13.4 |
Account Receivables, % | 0 | 106.74 | 9.37 | 10.37 | 0 | 23.95 | 23.95 | 23.95 | 23.95 | 23.95 |
Inventories | 13.0 | 10.5 | 55.2 | 28.1 | .0 | 21.1 | 22.0 | 23.0 | 24.0 | 25.1 |
Inventories, % | 31.29 | 34.16 | 138.23 | 58.73 | 0 | 44.84 | 44.84 | 44.84 | 44.84 | 44.84 |
Accounts Payable | 4.9 | 2.3 | 3.4 | 3.9 | 4.5 | 4.3 | 4.5 | 4.7 | 5.0 | 5.2 |
Accounts Payable, % | 11.92 | 7.44 | 8.62 | 8.25 | 9.95 | 9.23 | 9.23 | 9.23 | 9.23 | 9.23 |
Capital Expenditure | -6.3 | -3.3 | -5.5 | -5.5 | -2.4 | -5.3 | -5.6 | -5.8 | -6.1 | -6.4 |
Capital Expenditure, % | -15.19 | -10.89 | -13.85 | -11.51 | -5.27 | -11.34 | -11.34 | -11.34 | -11.34 | -11.34 |
Tax Rate, % | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 | 2.19 |
EBITAT | -93.8 | -57.9 | -57.5 | -102.3 | -7.7 | -38.5 | -40.2 | -42.0 | -43.8 | -45.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -50.0 | -63.9 | -22.7 | -9.2 | 29.9 | -37.4 | -6.4 | -6.7 | -7.0 | -7.3 |
WACC, % | 12.06 | 12.06 | 12.02 | 12.05 | 11.94 | 12.02 | 12.02 | 12.02 | 12.02 | 12.02 |
PV UFCF | ||||||||||
SUM PV UFCF | -52.0 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -7 | |||||||||
Terminal Value | -75 | |||||||||
Present Terminal Value | -42 | |||||||||
Enterprise Value | -94 | |||||||||
Net Debt | 51 | |||||||||
Equity Value | -145 | |||||||||
Diluted Shares Outstanding, MM | 25 | |||||||||
Equity Value Per Share | -5.83 |
What You Will Get
- Real MOGO Financial Data: Pre-filled with Mogo Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Mogo Inc.’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as revenue projections, profit margins, and investment levels.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value, and various financial metrics.
- High-Precision Results: Leverages Mogo Inc.'s (MOGO) actual financial data for accurate valuation insights.
- Effortless Scenario Testing: Easily evaluate different financial scenarios and analyze results side by side.
- Efficiency Booster: Streamline the valuation process without the hassle of creating complex models from the ground up.
How It Works
- 1. Access the Template: Download and open the Excel file featuring Mogo Inc.'s (MOGO) preloaded data.
- 2. Adjust Parameters: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results in Real-Time: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Assurance: Deliver professional valuation insights to reinforce your decision-making.
Why Choose This Calculator for Mogo Inc. (MOGO)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Easily adjust parameters to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to Mogo Inc.’s valuation as you modify inputs.
- Preloaded Data: Comes equipped with Mogo Inc.’s actual financial metrics for swift evaluations.
- Endorsed by Experts: Utilized by investors and analysts for making well-informed choices.
Who Should Use Mogo Inc. (MOGO)?
- Investors: Gain insights and make informed decisions with Mogo's innovative financial solutions.
- Financial Analysts: Enhance your analysis with Mogo's user-friendly tools designed for efficiency.
- Consultants: Easily tailor Mogo's resources for impactful client presentations and reports.
- Finance Enthusiasts: Expand your knowledge of personal finance and investment strategies with Mogo's educational content.
- Educators and Students: Utilize Mogo's platform as a valuable resource in finance and investment studies.
What the Template Contains
- Pre-Filled DCF Model: Mogo Inc.’s financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Mogo Inc.’s 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.