Citigroup Inc. (C) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Citigroup Inc. (C) Bundle
Whether you're an investor or analyst, this (C) DCF Calculator is your go-to resource for accurate valuation. Equipped with real data from Citigroup Inc., you can adjust forecasts and instantly observe the effects.
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 | 75,067.0 | 75,494.0 | 71,887.0 | 75,305.0 | 78,486.0 | 79,421.9 | 80,369.0 | 81,327.3 | 82,297.1 | 83,278.5 |
| Revenue Growth, % | 0 | 0.56883 | -4.78 | 4.75 | 4.22 | 1.19 | 1.19 | 1.19 | 1.19 | 1.19 |
| EBITDA | 27,806.0 | .0 | 31,433.0 | 23,069.0 | .0 | 17,695.4 | 17,906.4 | 18,119.9 | 18,336.0 | 18,554.6 |
| EBITDA, % | 37.04 | 0 | 43.73 | 30.63 | 0 | 22.28 | 22.28 | 22.28 | 22.28 | 22.28 |
| Depreciation | 3,905.0 | 3,937.0 | 3,964.0 | 4,262.0 | 4,560.0 | 4,352.5 | 4,404.4 | 4,456.9 | 4,510.0 | 4,563.8 |
| Depreciation, % | 5.2 | 5.21 | 5.51 | 5.66 | 5.81 | 5.48 | 5.48 | 5.48 | 5.48 | 5.48 |
| EBIT | 23,901.0 | -3,937.0 | 27,469.0 | 18,807.0 | -4,560.0 | 13,342.9 | 13,502.1 | 13,663.1 | 13,826.0 | 13,990.9 |
| EBIT, % | 31.84 | -5.21 | 38.21 | 24.97 | -5.81 | 16.8 | 16.8 | 16.8 | 16.8 | 16.8 |
| Total Cash | 155,168.0 | 282,238.0 | 248,611.0 | 325,049.0 | 241,915.0 | 79,421.9 | 80,369.0 | 81,327.3 | 82,297.1 | 83,278.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Inventories | -801,156.0 | -1,069,799.0 | -1,030,428.0 | -1,167,269.0 | .0 | -63,537.5 | -64,295.2 | -65,061.9 | -65,837.7 | -66,622.8 |
| Inventories, % | -1067.25 | -1417.06 | -1433.4 | -1550.06 | 0 | -80 | -80 | -80 | -80 | -80 |
| Accounts Payable | 48,601.0 | 50,484.0 | 61,430.0 | 69,218.0 | 63,539.0 | 61,939.8 | 62,678.4 | 63,425.8 | 64,182.1 | 64,947.4 |
| Accounts Payable, % | 64.74 | 66.87 | 85.45 | 91.92 | 80.96 | 77.99 | 77.99 | 77.99 | 77.99 | 77.99 |
| Capital Expenditure | -5,336.0 | -3,446.0 | -4,119.0 | -5,632.0 | -6,583.0 | -5,284.6 | -5,347.6 | -5,411.4 | -5,475.9 | -5,541.2 |
| Capital Expenditure, % | -7.11 | -4.56 | -5.73 | -7.48 | -8.39 | -6.65 | -6.65 | -6.65 | -6.65 | -6.65 |
| Tax Rate, % | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 | 28.52 |
| EBITAT | 19,401.0 | -3,190.4 | 21,952.0 | 14,845.0 | -3,259.5 | 10,475.2 | 10,600.1 | 10,726.5 | 10,854.4 | 10,983.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 867,727.0 | 267,826.6 | -6,628.0 | 158,104.0 | -1,178,230.5 | 71,481.4 | 11,153.1 | 11,286.1 | 11,420.7 | 11,556.9 |
| WACC, % | 17.09 | 17.07 | 16.88 | 16.71 | 15.45 | 16.64 | 16.64 | 16.64 | 16.64 | 16.64 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 88,114.4 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 11,788 | |||||||||
| Terminal Value | 80,508 | |||||||||
| Present Terminal Value | 37,287 | |||||||||
| Enterprise Value | 125,402 | |||||||||
| Net Debt | 63,144 | |||||||||
| Equity Value | 62,258 | |||||||||
| Diluted Shares Outstanding, MM | 1,956 | |||||||||
| Equity Value Per Share | 31.83 |
What You Will Get
- Real C 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 automatically.
- Scenario Analysis: Evaluate various scenarios to assess Citigroup's future performance.
- User-Friendly Design: Designed for finance professionals while remaining accessible to newcomers.
Key Features
- 🔍 Real-Life C Financials: Pre-filled historical and projected data for Citigroup Inc.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Citigroup’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Citigroup’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Citigroup Inc. (C) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Citigroup Inc. (C)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Citigroup Inc. (C)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, investment managers, and corporate strategists.
- Comprehensive Data: Citigroup’s historical and projected financials preloaded for precise analysis.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Individual Investors: Gain insights for making informed decisions on buying or selling Citigroup Inc. (C) stock.
- Financial Analysts: Enhance valuation assessments with comprehensive financial models tailored for Citigroup Inc. (C).
- Consultants: Provide clients with accurate valuation insights related to Citigroup Inc. (C) efficiently.
- Business Owners: Learn about the valuation methods of major financial institutions like Citigroup Inc. (C) to inform your own business strategies.
- Finance Students: Explore valuation techniques using real-world data and case studies from Citigroup Inc. (C).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Citigroup Inc. (C) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Citigroup Inc. (C).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.