ING Groep N.V. (ING) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
ING Groep N.V. (ING) Bundle
Whether you’re an investor or an analyst, this ING DCF Calculator is your go-to resource for accurate valuation. Preloaded with ING Groep N.V. real data, you can adjust forecasts and observe the effects in real-time.
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 | 19,083.7 | 18,575.0 | 19,060.8 | 30.2 | 23,355.6 | 23,361.9 | 23,368.2 | 23,374.5 | 23,380.8 | 23,387.2 |
Revenue Growth, % | 0 | -2.67 | 2.62 | -99.84 | 77158.62 | 0.02703474 | 0.02703474 | 0.02703474 | 0.02703474 | 0.02703474 |
EBITDA | 7,895.3 | 4,766.0 | 7,792.1 | 6,380.7 | .0 | 9,714.4 | 9,717.0 | 9,719.6 | 9,722.3 | 9,724.9 |
EBITDA, % | 41.37 | 25.66 | 40.88 | 21106.9 | 0 | 41.58 | 41.58 | 41.58 | 41.58 | 41.58 |
Depreciation | 821.4 | 864.2 | 869.4 | 741.2 | 702.6 | 5,444.5 | 5,446.0 | 5,447.5 | 5,449.0 | 5,450.4 |
Depreciation, % | 4.3 | 4.65 | 4.56 | 2451.72 | 3.01 | 23.31 | 23.31 | 23.31 | 23.31 | 23.31 |
EBIT | 7,073.9 | 3,901.8 | 6,922.8 | 5,639.5 | -702.6 | 8,942.2 | 8,944.6 | 8,947.0 | 8,949.5 | 8,951.9 |
EBIT, % | 37.07 | 21.01 | 36.32 | 18655.17 | -3.01 | 38.28 | 38.28 | 38.28 | 38.28 | 38.28 |
Total Cash | 89,639.3 | 153,308.7 | 143,650.6 | 123,627.6 | 51,791.9 | 23,361.9 | 23,368.2 | 23,374.5 | 23,380.8 | 23,387.2 |
Total Cash, percent | .0 | .0 | .0 | .4 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,102.9 | 1,232.1 | 1,409.4 | 1,319.7 | 869.4 | 5,771.7 | 5,773.3 | 5,774.9 | 5,776.4 | 5,778.0 |
Account Receivables, % | 5.78 | 6.63 | 7.39 | 4365.52 | 3.72 | 24.71 | 24.71 | 24.71 | 24.71 | 24.71 |
Inventories | -148,623.0 | -170,660.9 | -166,058.6 | -151,969.1 | .0 | -18,689.5 | -18,694.6 | -18,699.6 | -18,704.7 | -18,709.7 |
Inventories, % | -778.79 | -918.77 | -871.21 | -502703.45 | 0 | -80 | -80 | -80 | -80 | -80 |
Accounts Payable | .0 | 5,083.9 | 5,297.6 | .0 | .0 | 2,577.4 | 2,578.1 | 2,578.8 | 2,579.5 | 2,580.2 |
Accounts Payable, % | 0 | 27.37 | 27.79 | 0 | 0 | 11.03 | 11.03 | 11.03 | 11.03 | 11.03 |
Capital Expenditure | -370.1 | -299.2 | -191.8 | -240.8 | -256.4 | -4,936.6 | -4,937.9 | -4,939.2 | -4,940.6 | -4,941.9 |
Capital Expenditure, % | -1.94 | -1.61 | -1.01 | -796.55 | -1.1 | -21.13 | -21.13 | -21.13 | -21.13 | -21.13 |
Tax Rate, % | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 | 30.55 |
EBITAT | 4,948.8 | 2,544.9 | 4,875.1 | 3,765.8 | -488.0 | 6,113.5 | 6,115.1 | 6,116.8 | 6,118.4 | 6,120.1 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 152,920.3 | 30,102.5 | 986.9 | -15,031.2 | -151,560.6 | 22,986.0 | 6,627.4 | 6,629.2 | 6,631.0 | 6,632.8 |
WACC, % | 15.58 | 14.73 | 15.66 | 15.01 | 15.49 | 15.29 | 15.29 | 15.29 | 15.29 | 15.29 |
PV UFCF | ||||||||||
SUM PV UFCF | 36,257.6 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 6,765 | |||||||||
Terminal Value | 50,896 | |||||||||
Present Terminal Value | 24,984 | |||||||||
Enterprise Value | 61,242 | |||||||||
Net Debt | 62,658 | |||||||||
Equity Value | -1,416 | |||||||||
Diluted Shares Outstanding, MM | 3,565 | |||||||||
Equity Value Per Share | -0.40 |
What You Will Get
- Editable Forecast Inputs: Easily modify key assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: ING Groep N.V.’s financial data pre-filled to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for examining projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Offers in-depth unlevered and levered DCF valuation models tailored for ING Groep N.V. (ING).
- WACC Calculator: Features a pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for flexibility.
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for ING Groep N.V. (ING).
- Interactive Dashboard and Charts: Visual representations of key valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template with ING Groep N.V. (ING) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including ING Groep N.V. (ING)'s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose the ING Groep N.V. (ING) Calculator?
- All-in-One Solution: Combines DCF, WACC, and financial ratio analyses seamlessly.
- Flexible Inputs: Modify the yellow-highlighted fields to explore different scenarios.
- In-Depth Analysis: Automatically computes ING’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points.
- High-Quality Standards: Perfect for financial analysts, investors, and business advisors.
Who Should Use This Product?
- Investors: Accurately assess ING Groep N.V.'s (ING) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to ING (ING).
- Consultants: Efficiently modify the template for valuation reports tailored for ING (ING) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading financial institutions like ING (ING).
- Educators: Implement it as an educational resource to illustrate valuation techniques relevant to ING (ING).
What the Template Contains
- Preloaded ING 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.