Gravity Co., Ltd. (GRVY) 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
Gravity Co., Ltd. (GRVY) Bundle
Designed for accuracy, our (GRVY) DCF Calculator enables you to evaluate Gravity Co., Ltd. valuation utilizing real-world financial data and offers complete flexibility to modify all key parameters for improved projections.
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 | 245.7 | 276.4 | 281.8 | 315.6 | 493.9 | 596.3 | 719.9 | 869.1 | 1,049.3 | 1,266.8 |
| Revenue Growth, % | 0 | 12.46 | 1.97 | 12 | 56.49 | 20.73 | 20.73 | 20.73 | 20.73 | 20.73 |
| EBITDA | 33.7 | 63.4 | 69.4 | 79.7 | 120.2 | 132.2 | 159.6 | 192.7 | 232.7 | 280.9 |
| EBITDA, % | 13.72 | 22.94 | 24.64 | 25.25 | 24.33 | 22.17 | 22.17 | 22.17 | 22.17 | 22.17 |
| Depreciation | 2.5 | 3.3 | 4.3 | 4.8 | 5.2 | 7.5 | 9.1 | 11.0 | 13.3 | 16.0 |
| Depreciation, % | 1.01 | 1.21 | 1.53 | 1.52 | 1.06 | 1.27 | 1.27 | 1.27 | 1.27 | 1.27 |
| EBIT | 31.2 | 60.0 | 65.1 | 74.9 | 115.0 | 124.7 | 150.5 | 181.7 | 219.4 | 264.9 |
| EBIT, % | 12.7 | 21.73 | 23.11 | 23.73 | 23.27 | 20.91 | 20.91 | 20.91 | 20.91 | 20.91 |
| Total Cash | 81.0 | 124.2 | 168.6 | 231.6 | 317.1 | 328.3 | 396.4 | 478.6 | 577.8 | 697.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 22.0 | 40.7 | 36.6 | 52.7 | 51.0 | 75.9 | 91.7 | 110.6 | 133.6 | 161.3 |
| Account Receivables, % | 8.95 | 14.72 | 12.97 | 16.69 | 10.32 | 12.73 | 12.73 | 12.73 | 12.73 | 12.73 |
| Inventories | 1.3 | 1.5 | 2.2 | 2.3 | .0 | 3.1 | 3.7 | 4.5 | 5.4 | 6.5 |
| Inventories, % | 0.54366 | 0.55122 | 0.76438 | 0.71876 | 0.000064505814 | 0.51562 | 0.51562 | 0.51562 | 0.51562 | 0.51562 |
| Accounts Payable | 25.5 | 35.9 | 28.0 | 50.1 | 42.1 | 68.8 | 83.1 | 100.3 | 121.1 | 146.2 |
| Accounts Payable, % | 10.39 | 12.98 | 9.95 | 15.86 | 8.52 | 11.54 | 11.54 | 11.54 | 11.54 | 11.54 |
| Capital Expenditure | -1.6 | -2.5 | -2.9 | -1.9 | -3.9 | -4.7 | -5.7 | -6.9 | -8.4 | -10.1 |
| Capital Expenditure, % | -0.64905 | -0.91043 | -1.02 | -0.60288 | -0.79916 | -0.79578 | -0.79578 | -0.79578 | -0.79578 | -0.79578 |
| Tax Rate, % | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 | 21.74 |
| EBITAT | 24.3 | 42.8 | 43.3 | 56.7 | 90.0 | 92.1 | 111.2 | 134.3 | 162.1 | 195.7 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 27.4 | 35.1 | 40.4 | 65.4 | 87.2 | 93.6 | 112.5 | 135.8 | 163.9 | 197.9 |
| WACC, % | 10.73 | 10.73 | 10.72 | 10.73 | 10.73 | 10.73 | 10.73 | 10.73 | 10.73 | 10.73 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 504.3 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | 199 | |||||||||
| Terminal Value | 1,945 | |||||||||
| Present Terminal Value | 1,169 | |||||||||
| Enterprise Value | 1,673 | |||||||||
| Net Debt | -125 | |||||||||
| Equity Value | 1,798 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | 258.81 |
What You Will Get
- Real Gravity Co. Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for Gravity Co., Ltd. (GRVY).
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates to fit your analysis needs.
- Instant Valuation Updates: Automatic recalculations to assess the impact of changes on Gravity Co., Ltd.'s (GRVY) fair value.
- Versatile Excel Template: Designed for quick edits, scenario testing, and in-depth projections tailored to Gravity Co., Ltd. (GRVY).
- Time-Saving and Accurate: Eliminate the hassle of building models from scratch while ensuring precision and flexibility in your evaluations.
Key Features
- Comprehensive GRVY Data: Pre-filled with Gravity Co., Ltd.’s historical performance metrics and future projections.
- Customizable Input Parameters: Modify key factors such as game revenue growth, operating margins, discount rates, tax assumptions, and capital investments.
- Interactive Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on your adjustments.
- Multi-Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Designed for ease of use, catering to both industry professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Gravity Co., Ltd.'s pre-filled financial data and forecasts.
- Step 3: Modify critical inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you tweak assumptions.
- Step 5: Analyze the outputs and use the results for investment decisions regarding Gravity Co., Ltd. (GRVY).
Why Choose This Calculator for Gravity Co., Ltd. (GRVY)?
- Accurate Data: Utilize real Gravity Co., Ltd. financials for dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with 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 industry.
- User-Friendly: An intuitive design and step-by-step guidance ensure accessibility for all users.
Who Should Use This Product?
- Investors: Evaluate Gravity Co., Ltd. (GRVY) to make informed decisions on stock transactions.
- CFOs and Financial Analysts: Enhance valuation methodologies and assess financial forecasts.
- Startup Founders: Understand the valuation strategies of established companies like Gravity Co., Ltd. (GRVY).
- Consultants: Provide clients with detailed and professional valuation assessments.
- Students and Educators: Utilize real market data to practice and instruct on valuation principles.
What the Template Contains
- Preloaded GRVY Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.