The Interpublic Group of Companies, Inc. (IPG) 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
The Interpublic Group of Companies, Inc. (IPG) Bundle
Evaluate The Interpublic Group of Companies, Inc. (IPG) financial outlook like an expert! This (IPG) DCF Calculator provides pre-filled financial data and offers total flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your 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 | 10,221.3 | 9,061.0 | 10,240.7 | 10,927.8 | 10,889.3 | 11,107.8 | 11,330.6 | 11,557.9 | 11,789.8 | 12,026.3 |
Revenue Growth, % | 0 | -11.35 | 13.02 | 6.71 | -0.35231 | 2.01 | 2.01 | 2.01 | 2.01 | 2.01 |
EBITDA | 1,397.2 | 1,297.8 | 1,746.7 | 1,765.5 | 1,900.5 | 1,747.4 | 1,782.5 | 1,818.2 | 1,854.7 | 1,891.9 |
EBITDA, % | 13.67 | 14.32 | 17.06 | 16.16 | 17.45 | 15.73 | 15.73 | 15.73 | 15.73 | 15.73 |
Depreciation | 278.5 | 290.6 | 283.8 | 274.0 | 264.3 | 303.0 | 309.0 | 315.2 | 321.6 | 328.0 |
Depreciation, % | 2.72 | 3.21 | 2.77 | 2.51 | 2.43 | 2.73 | 2.73 | 2.73 | 2.73 | 2.73 |
EBIT | 1,118.7 | 1,007.2 | 1,462.9 | 1,491.5 | 1,636.2 | 1,444.5 | 1,473.4 | 1,503.0 | 1,533.2 | 1,563.9 |
EBIT, % | 10.94 | 11.12 | 14.29 | 13.65 | 15.03 | 13 | 13 | 13 | 13 | 13 |
Total Cash | 1,192.2 | 2,509.0 | 3,270.0 | 2,545.3 | 2,386.1 | 2,587.9 | 2,639.8 | 2,692.8 | 2,746.8 | 2,801.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7,143.3 | 6,467.1 | 7,524.9 | 7,339.0 | 7,998.0 | 7,894.2 | 8,052.6 | 8,214.2 | 8,378.9 | 8,547.0 |
Account Receivables, % | 69.89 | 71.37 | 73.48 | 67.16 | 73.45 | 71.07 | 71.07 | 71.07 | 71.07 | 71.07 |
Inventories | 22.8 | .8 | 8.2 | 5.9 | .0 | 8.1 | 8.3 | 8.5 | 8.6 | 8.8 |
Inventories, % | 0.22306 | 0.00882905 | 0.08007265 | 0.05399074 | 0 | 0.07319121 | 0.07319121 | 0.07319121 | 0.07319121 | 0.07319121 |
Accounts Payable | 7,205.4 | 7,269.7 | 8,960.0 | 8,235.3 | 8,355.0 | 8,670.9 | 8,844.8 | 9,022.3 | 9,203.3 | 9,387.9 |
Accounts Payable, % | 70.49 | 80.23 | 87.49 | 75.36 | 76.73 | 78.06 | 78.06 | 78.06 | 78.06 | 78.06 |
Capital Expenditure | -198.5 | -167.5 | -195.3 | -178.1 | -179.3 | -199.4 | -203.4 | -207.4 | -211.6 | -215.9 |
Capital Expenditure, % | -1.94 | -1.85 | -1.91 | -1.63 | -1.65 | -1.79 | -1.79 | -1.79 | -1.79 | -1.79 |
Tax Rate, % | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 | 21.99 |
EBITAT | 835.6 | 978.8 | 1,140.5 | 1,102.6 | 1,276.4 | 1,160.7 | 1,183.9 | 1,207.7 | 1,231.9 | 1,256.6 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 954.9 | 1,864.4 | 1,854.1 | 662.0 | 828.0 | 1,675.8 | 1,305.0 | 1,331.2 | 1,357.9 | 1,385.2 |
WACC, % | 7.79 | 8.12 | 7.84 | 7.78 | 7.84 | 7.87 | 7.87 | 7.87 | 7.87 | 7.87 |
PV UFCF | ||||||||||
SUM PV UFCF | 5,686.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,413 | |||||||||
Terminal Value | 24,050 | |||||||||
Present Terminal Value | 16,463 | |||||||||
Enterprise Value | 22,149 | |||||||||
Net Debt | 2,285 | |||||||||
Equity Value | 19,864 | |||||||||
Diluted Shares Outstanding, MM | 386 | |||||||||
Equity Value Per Share | 51.48 |
What You Will Receive
- Customizable Excel Template: A fully editable Excel-based DCF Calculator featuring pre-filled real IPG financials.
- Actual Financial Data: Historical performance metrics and forward-looking projections (highlighted in the yellow cells).
- Flexible Forecasting: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC at your convenience.
- Instant Calculations: Quickly observe how your inputs affect the valuation of Interpublic Group (IPG).
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts alike.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Customizable Financial Inputs: Adjust essential metrics such as revenue growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, net present value (NPV), and other financial metrics.
- High-Precision Accuracy: Leverages The Interpublic Group of Companies, Inc.'s (IPG) actual financial data for credible valuation results.
- Effortless Scenario Analysis: Easily evaluate varying assumptions and assess different outcomes.
- Efficiency Booster: Avoid the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download the Template: Gain immediate access to the Excel-based IPG DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional parameters.
- Instant Calculations: The model automatically recalculates the intrinsic value of Interpublic Group of Companies, Inc. (IPG).
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the outcomes to inform your investment or financial analysis.
Why Choose This Calculator for The Interpublic Group of Companies, Inc. (IPG)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for IPG.
- Flexible Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
- In-Depth Analysis: Automatically determines IPG’s intrinsic value and Net Present Value.
- Preloaded Information: Access to historical and projected data for reliable analysis.
- Expert-Level Tool: Perfect for financial analysts, investors, and business advisors focusing on IPG.
Who Should Use This Product?
- Investors: Accurately assess the fair value of The Interpublic Group of Companies, Inc. (IPG) before making investment decisions.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently modify the template for creating valuation reports tailored for clients.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by top-tier companies.
- Educators: Implement it as a teaching resource to illustrate valuation methodologies.
What the Template Contains
- Preloaded IPG 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.