DCF Tool

IPG

Interpublic Group Of Cos., Inc. – Advertising Agencies
interpublic is one of the world’s premier advertising and marketing services companies. our agency brands deliver custom marketing solutions to many of the world’s largest advertisers. we cover the spectrum of marketing disciplines and specialties, from public relations and consumer advertising, to mobile and search engine marketing. our client solutions vary from project-based activity involving one agency and its client to long-term, fully-integrated campaigns created by a group of our companies working together on behalf of a client. with offices in over 100 countries, we can operate in a single region or align work globally across all major world markets. interpublic employs approximately 48,700 marketing professionals. based in new york city, interpublic sets company-wide financial objectives and corporate strategy, directs collaborative inter-agency programs, establishes financial management and operational controls, guides personnel policy, conducts investor relations and in
Analysis Results
Intrinsic Value $171.37
Latest Price $30.45
Relative Value 82% undervalued
Thoughts on this result? Let us know.
Ad
Cash Flow (Billions)
Analysis Parameters
%
%
%
New Ticker
Ad
Analysis Details
Growth Rate Projection

An exponential growth model was fit to the past cash flow data, giving more weight to more recent years. This model determined a growth rate estimate of 15.9%.

Weighted Average Cost of Capital (WACC)

The calculated WACC is 7.1%. This value is used as the default discount rate.

Value of Future Flows

Assuming a growth rate of 15.9%, the cash flows for the next 5 years are projected.

The present value of each year's flow is adjusted to present value using the discount rate.

Year Future flow (billion) Present value (billion)
2024 2.23 2.08
2025 2.58 2.25
2026 2.99 2.43
2027 3.46 2.63
2028 4.01 2.84
Terminal Value

Assuming a growth rate after the projection years of 2.0%, the terminal value of the company would be 79.7 billion. This corresponds to a present value of 52.7 billion.

Intrinsic Value Per Share

The total present value of the projected cash flows is 12.2 billion. Adding in the terminal value gives a total present value of 64.9 billion.

There are presently 379.0 million outstanding shares, so the intrinsic value per share is 171.37.

Financial Statements

The following data was to determine the past cash flows.

Current Assets 10,950,400,000
Current Cash 2,386,100,000
Current Liabilities 10,330,900,000
Current Debt 284,300,000
Non-Cash Working Capital (NCWC) -1,482,300,000
Change in NCWC 676,100,000
EBIT 1,484,000,000
Tax Provision 291,200,000
Depreciation and Amortization 264,300,000
Capital Expenditure -179,300,000
Unlevered Free Cash Flow 1,938,464,932
Current Assets 10,325,200,000
Current Cash 2,545,300,000
Current Liabilities 9,983,200,000
Current Debt 44,900,000
Non-Cash Working Capital (NCWC) -2,158,400,000
Change in NCWC 721,600,000
EBIT 1,489,200,000
Tax Provision 318,400,000
Depreciation and Amortization 274,000,000
Capital Expenditure -178,100,000
Unlevered Free Cash Flow 1,934,662,903
Current Assets 11,231,800,000
Current Cash 3,270,000,000
Current Liabilities 10,890,000,000
Current Debt 48,200,000
Non-Cash Working Capital (NCWC) -2,880,000,000
Change in NCWC -708,600,000
EBIT 1,449,300,000
Tax Provision 251,800,000
Depreciation and Amortization 283,800,000
Capital Expenditure -195,300,000
Unlevered Free Cash Flow 531,197,599
Current Assets 9,367,600,000
Current Cash 2,509,000,000
Current Liabilities 9,580,500,000
Current Debt 550,500,000
Non-Cash Working Capital (NCWC) -2,171,400,000
Change in NCWC -883,900,000
EBIT 1,003,100,000
Tax Provision 8,000,000
Depreciation and Amortization 290,600,000
Capital Expenditure -167,500,000
Unlevered Free Cash Flow 220,144,284
Current Assets 8,770,700,000
Current Cash 1,192,200,000
Current Liabilities 9,420,400,000
Current Debt 554,400,000
Non-Cash Working Capital (NCWC) -1,287,500,000
Change in NCWC -746,900,000
EBIT 1,120,300,000
Tax Provision 204,800,000
Depreciation and Amortization 278,500,000
Capital Expenditure -198,500,000
Unlevered Free Cash Flow 192,289,905
Current Assets 8,182,900,000
Current Cash 673,400,000
Current Liabilities 8,123,900,000
Current Debt 73,800,000
Non-Cash Working Capital (NCWC) -540,600,000
Change in NCWC 377,500,000
EBIT 1,007,700,000
Tax Provision 199,200,000
Depreciation and Amortization 202,900,000
Capital Expenditure -177,100,000
Unlevered Free Cash Flow 1,171,145,967
Current Assets 7,464,100,000
Current Cash 790,900,000
Current Liabilities 7,678,200,000
Current Debt 86,900,000
Non-Cash Working Capital (NCWC) -918,100,000
Change in NCWC 40,900,000
EBIT 974,500,000
Tax Provision 281,900,000
Depreciation and Amortization 157,100,000
Capital Expenditure -155,900,000
Unlevered Free Cash Flow 703,324,198
Current Assets 7,438,000,000
Current Cash 1,100,600,000
Current Liabilities 7,706,000,000
Current Debt 409,600,000
Non-Cash Working Capital (NCWC) -959,000,000
Change in NCWC 289,900,000
EBIT 938,300,000
Tax Provision 198,000,000
Depreciation and Amortization 160,200,000
Capital Expenditure -200,700,000
Unlevered Free Cash Flow 963,999,337
Current Assets 7,693,100,000
Current Cash 1,509,700,000
Current Liabilities 7,584,300,000
Current Debt 152,000,000
Non-Cash Working Capital (NCWC) -1,248,900,000
Change in NCWC -37,900,000
EBIT 872,200,000
Tax Provision 282,800,000
Depreciation and Amortization 157,000,000
Capital Expenditure -161,100,000
Unlevered Free Cash Flow 507,052,928
Current Assets 7,810,200,000
Current Cash 1,667,200,000
Current Liabilities 7,463,300,000
Current Debt 109,300,000
Non-Cash Working Capital (NCWC) -1,211,000,000
Change in NCWC -20,300,000
EBIT 789,800,000
Tax Provision 216,500,000
Depreciation and Amortization 163,000,000
Capital Expenditure -148,700,000
Unlevered Free Cash Flow 546,936,584
Current Assets 8,084,000,000
Current Cash 1,642,100,000
Current Liabilities 8,165,300,000
Current Debt 532,700,000
Non-Cash Working Capital (NCWC) -1,190,700,000
Change in NCWC -25,200,000
EBIT 661,000,000
Tax Provision 181,200,000
Depreciation and Amortization 157,400,000
Capital Expenditure -173,000,000
Unlevered Free Cash Flow 365,417,613
Current Assets 8,738,300,000
Current Cash 2,590,800,000
Current Liabilities 7,701,700,000
Current Debt 388,700,000
Non-Cash Working Capital (NCWC) -1,165,500,000
Change in NCWC 337,600,000
EBIT 681,400,000
Tax Provision 213,300,000
Depreciation and Amortization 147,700,000
Capital Expenditure -169,200,000
Unlevered Free Cash Flow 783,098,731

This analysis is provided for informational purposes only and does not constitute financial or investing advice. For more information on the advantages and limitations of DCF analysis see background. This information is provided on an "as is" basis. No warranty, expressed or implied, is made regarding accuracy, adequacy, completeness, legality, reliability or usefulness of any information. By using this site you agree that under no circumstances shall Valuation Tools LLC be held liable for any loss or damage caused by information obtained from this website including any articles, data, videos, its social media accounts, or any other materials.