Omnicom Group logo
Omnicom Group Financial Model

Media Company Financials Example (Free Excel Download)

Omnicom Group is a leading global marketing and corporate communications company that provides advertising, strategic media planning, precision marketing, and public relations services to a vast portfolio of blue-chip clients.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model evaluates the equity valuation and post-merger integration trajectory of Omnicom Group, enabling an analyst to assess whether the transformational acquisition of Interpublic Group (IPG) will yield the projected margin recovery and revenue synergies required to justify the capital outlay.

  • Omnicom Group is a leading global marketing and corporate communications company that provides advertising, strategic media planning, precision marketing, and public relations services to a vast portfolio of blue-chip clients.
  • Business Segments: Media & Advertising (~54% of revenue), Precision Marketing (~10%), Public Relations (~9%), Healthcare (~8%), Experiential (~6%), Branding & Retail Commerce (~5%), and Execution & Support (~8%).
  • Key Geographies: North America (~50%+), Europe (~25%), Asia-Pacific (~11%), Latin America, and the Middle East & Africa.
  • Business Model Type: Asset-light, human-capital intensive, and highly diversified client base (the largest client represents less than 3% of total revenue).
  • Competitive Position: A "Big Four" global advertising holding company, competing directly with WPP, Publicis Groupe, and Dentsu.
  • Recent Major Events: Omnicom completed a transformational merger with Interpublic Group (IPG) on November 26, 2025, making IPG a wholly-owned subsidiary. In January 2024, the company also acquired Flywheel Digital for $845 million to bolster its Precision Marketing segment.

The downloadable Omnicom Group financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.

A turnkey financial model

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

Historicals & AssumptionsOmnicom Group financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$14.29B$14.29B$14.69B$15.69B$17.27B
Gross profit$2.79B$2.68B$2.71B$2.92B$1.47B
Operating income$2.20B$2.08B$2.10B$2.27B$444.7M
Net income$1.41B$1.32B$1.39B$1.48B-$54.5M

Forecast assumptions

Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.

Revenue growth
-0.4%
COGS % of revenue
81.7%
R&D % of revenue
0.0%
SG&A % of revenue
2.7%
D&A % of revenue
1.5%
Effective tax rate
27.7%
See 8 more
Capex % of revenue
1.4%
Net working capital % of revenue
-0.5%
Other assets % of revenue
167.4%
Other liabilities % of revenue
109.8%
Annual debt paydown
5.0%
Interest rate on debt
3.6%
Dividend payout ratio
45.7%
Buybacks % of net income
38.8%

How to build a detailed financial model for Omnicom Group

A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.

Revenue Deep Dive

For EACH revenue segment (Media & Advertising, Precision Marketing, Public Relations, Healthcare, Branding & Retail Commerce, Experiential, Execution & Support):

  • Segment Name: As reported in the 10-K (e.g., "Media & Advertising").
  • Revenue Driver Formula: Prior Year Segment Revenue x (1 + Organic Growth %) + Acquisition Revenue - Disposition Revenue +/- Foreign Exchange Impact.
  • Historical Growth Rate: 3-7% organic growth historically, though reported revenue jumped 10.1% in 2025 due to the IPG merger.
  • Key Growth Levers and Headwinds: Shift of client budgets to digital/retail media networks (lever), integration disruption from the IPG merger (headwind), and macroeconomic ad-spend cyclicality (headwind).
  • Pricing Dynamics: Primarily fee-based contracts (retainers) and project-based billing, with some media commission structures. Highly competitive pricing environment.
  • Revenue Recognition Notes: Recognised over time as services are transferred to the client. Media pass-through costs are generally netted out, but principal vs. agent accounting requires careful tracking.
  • Seasonality: Q4 is historically the strongest quarter due to holiday retail campaigns, year-end client budget flushes, and cyclical political advertising.

Cost Structure

Variable Costs / COGS

  • Line-by-line breakdown: Omnicom does not report a traditional "COGS" line. Instead, its primary direct cost is "Salary and service costs" (freelancers, direct production costs, and third-party vendor costs).
  • Gross margin range: Not applicable in standard terms; analysts look at "Salary and service costs" as a percentage of revenue, which typically runs at 70-74%.
  • Key input costs: Human capital (wages, bonuses, freelance fees) and media production inputs.
  • How COGS scales: Step-function. Headcount must be added to service large new account wins, but existing teams can absorb marginal scope increases.

Operating Expenses

  • R&D: Not material/disclosed separately; embedded in IT and platform development (e.g., Omni platform).
  • SG&A: Reported as "Occupancy and other costs" (rent, utilities, software) and "Selling, general and administrative expenses" (professional fees, marketing, corporate overhead).
  • Depreciation & Amortisation: Significant amortisation of acquired intangible assets due to serial M&A.
  • Stock-Based Compensation: Embedded in salary costs, typically 1-2% of revenue.
  • Restructuring / one-time charges: Massive in 2025. Operating income dropped 80.4% in 2025 primarily due to severance, real estate repositioning, and contract cancellations related to the IPG merger.

Margin Profile

  • EBITA Margin: Historically stable at 15.5% - 16.7%.
  • Operating Margin: Historically 14.5% - 15.9%, but collapsed to ~2.5% in 2025 due to IPG merger integration costs.
  • Margin trend: Currently severely compressed due to 2025 merger costs, with a steep recovery modeled for 2026-2028 as synergies are realised and severance costs fall away.

Balance Sheet Structure

  • Total assets: Substantial, heavily weighted towards intangibles.
  • Key asset categories: Cash, Accounts Receivable, Unbilled Revenue, Goodwill, and Identifiable Intangible Assets.
  • Goodwill & intangibles: Represents the vast majority of total assets due to decades of bolt-on acquisitions and the massive 2025 IPG merger.
  • Working capital profile:
  • Days Sales Outstanding (DSO): 60-75 days.
  • Days Inventory Outstanding (DIO): N/A.
  • Days Payable Outstanding (DPO): 90-110 days.
  • Net working capital as % of revenue: Structurally negative.
  • Is working capital positive or negative? Negative. Omnicom collects from clients before paying media vendors, providing a structural cash flow advantage when revenue is growing.
  • PP&E: Minimal (mostly leasehold improvements and IT equipment).
  • Right-of-use assets: Material due to a massive global footprint of leased office space, though currently undergoing consolidation post-IPG merger.

Capital Expenditure & Investment

  • Capex as % of revenue: 1.0% - 2.0% (highly asset-light).
  • Maintenance capex vs. growth capex: Almost entirely maintenance (IT infrastructure, office renovations).
  • Major capex programmes: Real estate consolidation post-IPG merger will require near-term leasehold improvement capex.
  • Capitalised software: Material investments in the "Omni" data platform.
  • M&A pattern: Historically a serial bolt-on acquirer (e.g., Flywheel Digital), but the 2025 IPG merger was a rare, transformational mega-deal.

Debt & Capital Structure

  • Total debt: Increased significantly in 2025. Omnicom exchanged $2.76 billion of IPG's senior notes for new Omnicom notes.
  • Debt/EBITDA ratio: Temporarily elevated due to the IPG acquisition and depressed 2025 EBITDA; target is typically 1.5x - 2.0x.
  • Key debt instruments: Senior Notes (e.g., €600M 3.70% due 2032, $600M 5.30% due 2034) and a $3.5 billion unsecured multi-currency revolving credit facility.
  • Interest rate profile: Predominantly fixed-rate senior notes.
  • Share repurchase programme: Highly active. Authorized a $5.0 billion program in 2025, with plans to execute a $2.5 billion Accelerated Share Repurchase (ASR).
  • Dividend policy: Consistent payer. Paid ~$550 million in 2024 and 2025.

Cash Flow Characteristics

  • Operating cash flow conversion: Typically >100% of Net Income due to high non-cash amortisation and negative working capital dynamics.
  • Free cash flow margin: Historically 10-12% of revenue.
  • Major non-cash items: Amortisation of acquired intangibles, depreciation, stock-based compensation, and massive 2025 restructuring impairments.
  • Working capital cash flow impact: A source of cash during periods of revenue growth; a use of cash if media billings contract.
  • Capex intensity: Very low, reinforcing strong free cash flow generation.

Sheet Structure

  1. Assumptions: Hardcoded drivers for organic growth, M&A contributions, margins, and IPG synergy targets.
  2. Revenue Build: Segment-level build (Media & Advertising, Precision Marketing, etc.) tracking organic vs. acquired growth and FX impacts.
  3. Income Statement: Consolidated view mirroring the 10-K (Revenue, Salary & Service Costs, Occupancy Costs, SG&A, Depreciation, Amortisation, Restructuring).
  4. M&A & Restructuring Schedule: Dedicated sheet tracking the IPG merger integration, severance cash outflows, real estate repositioning, and synergy realisation.
  5. Balance Sheet: Standard GAAP presentation, highlighting the massive Goodwill/Intangibles and negative working capital position.
  6. Cash Flow Statement: Indirect method, explicitly linking working capital changes and IPG integration cash costs.
  7. Debt Schedule: Tranche-by-tranche tracking of legacy OMC notes, newly exchanged IPG notes, and the $3.5B revolver.
  8. Working Capital Schedule: DSO, DPO, and Unbilled Revenue tracking.
  9. DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value.

Key Financial Relationships

  1. `Segment Revenue = Prior Year Segment Revenue * (1 + Organic Growth % + FX Impact % + Net M&A Impact %)`
  2. `Total Revenue = Sum of all 7 Segment Revenues`
  3. `Salary and Service Costs = Total Revenue * Salary & Service Margin % (historically ~72%)`
  4. `Occupancy and Other Costs = Base Occupancy Costs * (1 + Inflation) - Real Estate Consolidation Synergies`
  5. `EBITA = Operating Income + Amortisation of Acquired Intangible Assets + Internally Developed Strategic Platform Assets`
  6. `Adjusted Operating Income = Operating Income + Merger/Restructuring Costs + Acquisition Transaction Costs`
  7. `Net Working Capital = (Accounts Receivable + Unbilled Revenue + Prepaid Expenses) - (Accounts Payable + Advance Billings + Accrued Expenses)`
  8. `Change in NWC = Current Period NWC - Prior Period NWC (Negative NWC means growth generates cash)`
  9. `Interest Expense = Sum of (Average Balance of each Debt Tranche * Respective Interest Rate)`
  10. `Shares Outstanding = Prior Period Shares - (Share Repurchase $ / Average Share Price) + Stock-Based Comp Issuances`

Cross-Sheet Dependencies

  • The M&A & Restructuring Schedule is the critical node. It feeds acquired revenue into the Revenue Build, synergy cost reductions into the Income Statement, and integration cash outflows into the Cash Flow Statement.
  • Working Capital Schedule feeds the Cash Flow Statement, which determines cash available for the $2.5B ASR in the Assumptions sheet, which in turn reduces the share count on the Income Statement for EPS calculations.
  • Circularity risk exists between the Debt Schedule (revolver drawdowns), Cash Flow Statement (interest paid), and Income Statement (interest expense). A circuit breaker toggle must be included.

Sign Convention

  • Income Statement: Revenue is positive. All expenses (Salary, SG&A, Interest, Taxes) are negative. Net Income is positive if profitable, negative if a loss.
  • Balance Sheet: Assets are positive. Liabilities and Equity are positive.
  • Cash Flow Statement: Cash inflows (Net Income, D&A, increase in payables) are positive. Cash outflows (Capex, dividends, share repurchases, increase in receivables) are negative.

Things Most Likely to Go Wrong

  1. IPG Merger Distortion: The 2025 reported financials include massive one-time merger costs (operating income down 80.4%). Extrapolating 2025 margins will break the model; the builder must use "Adjusted EBITA" margins (~15.5%) for the steady-state run rate.
  2. Working Capital Reversals: Because OMC operates with negative working capital, a sudden drop in revenue causes a massive cash outflow as payables come due without offsetting receivable inflows.
  3. FX Translation: Omnicom generates over 40% of its revenue outside the US. The model must explicitly separate organic growth from FX impacts, as FX can swing reported revenue by 2-3% annually.
  4. Amortisation Add-Backs: The company heavily promotes "EBITA" and "Adjusted EPS" which exclude the amortisation of acquired intangibles. The model must clearly bridge GAAP Operating Income to EBITA.
  5. Principal vs. Agent Accounting: Media pass-through costs are generally excluded from revenue, but changes in contract structures can artificially inflate both revenue and salary/service costs without impacting gross profit dollars.
  6. Share Count Volatility: The planned $2.5B Accelerated Share Repurchase (ASR) will drastically reduce the share count in 2026. The builder must accurately model the timing of this retirement.
  7. Segment Reorganisation: Omnicom frequently reclassifies its disciplines. Historical segment data must be aligned with the latest 7-segment reporting structure.
  8. Real Estate Synergies: The model must account for the cash cost of breaking leases (severance/repositioning costs) before the P&L benefit of lower occupancy costs is realised.

Validation Checks

  1. "Adjusted EBITA margin should recover to the 15.0% - 16.5% range by 2027; flag if it remains depressed."
  2. "Total Revenue in 2026 must reflect the full-year consolidation of IPG (a massive step-up from 2024's $15.7B)."
  3. "Working capital should remain a net liability (negative NWC); flag if NWC turns positive."
  4. "Free Cash Flow conversion (FCF / Adjusted Net Income) should exceed 100%."
  5. "Capex as a % of revenue should not exceed 2.5%."
  6. "Balance sheet must balance: Total Assets = Total Liabilities + Equity in every period."
  7. "Effective tax rate should remain between 25.5% and 27.0%."
  8. "Dividend payout ratio should be checked against the historical ~$550M annual payout, adjusted for the new IPG share base."

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
Media & Advertising Organic Growth4.0%Blended expectation of digital growth offsetting traditional media declines.
Precision Marketing Organic Growth6.0%High-growth segment, bolstered by Flywheel Digital integration.
Healthcare Organic Growth3.0%Stable pharma marketing spend, recovering from 2024 client losses.
Salary & Service Costs (% of Rev)72.5%Historical average, adjusted for post-merger headcount synergies.
Occupancy & Other Costs (% of Rev)7.5%Expected to decline slightly as IPG real estate footprint is consolidated.
Adjusted EBITA Margin Target15.5%Management's historical target and steady-state goal post-IPG integration.
Effective Tax Rate26.4%Actual reported Q4 2024 effective tax rate.
Capex (% of Revenue)1.5%Asset-light business model maintenance requirement.
Days Sales Outstanding (DSO)65DaysBased on historical AR collection cycles.
Days Payable Outstanding (DPO)100DaysReflects structural advantage of paying media vendors after client collection.
Share Repurchase (2026)2,500$MAnnounced Accelerated Share Repurchase program.
Annual Dividend2.80$ / ShareBased on recent historical payout levels.
WACC8.5%Standard agency holding company discount rate.
Terminal Growth Rate2.0%Aligned with long-term global GDP and inflation expectations.

Data Sources & Benchmarks

  • Filings: SEC EDGAR (Omnicom Group Inc., Ticker: OMC). 2024 10-K, 2025 10-K, and Q4 2025 Earnings Release.
  • Investor Relations: investor.omnicomgroup.com (for Investor Presentations and Form 8937 regarding the IPG debt exchange).
  • Key Peers: WPP plc (WPP), Publicis Groupe (PUB.PA), Dentsu Group (4324.T).
  • Industry Data: COMvergence (for media agency billings and retention rankings), Forrester Wave (for marketing services evaluations).
  • Consensus Estimates: FactSet or Bloomberg for post-IPG merger revenue and EPS consensus.

Sources

Frequently asked

What does Omnicom Group do?+

Omnicom Group is a leading global marketing and corporate communications company that provides a wide range of services, including advertising, strategic media planning, precision marketing, and public relations. It serves a vast portfolio of blue-chip clients across various business segments and geographies.

How does Omnicom Group generate its revenue?+

Omnicom Group generates revenue primarily through fee-based contracts, retainers, and project-based billing, with some media commission structures. Revenue is driven by organic growth within its segments, acquisitions like the IPG merger, and is influenced by foreign exchange impacts.

What are the key revenue growth assumptions in Omnicom Group's financial model?+

The financial model for Omnicom Group incorporates historical organic growth rates, which typically range from 3-7%. It also accounts for significant events such as the 2025 Interpublic Group merger, which led to a reported 10.1% jump in revenue.

What is Omnicom Group's capital expenditure strategy?+

Omnicom Group maintains an asset-light business model, with capital expenditures typically ranging from 1.0% to 2.0% of revenue, primarily for maintenance like IT infrastructure. Near-term capex will also be directed towards real estate consolidation following the IPG merger.

How does Omnicom Group's working capital profile affect its cash flow?+

Omnicom Group has a structurally negative net working capital as a percentage of revenue, meaning it often collects payments from clients before paying its media vendors. This provides a structural cash flow advantage, particularly during periods of revenue growth.

Is there a downloadable financial model available for Omnicom Group?+

Yes, a downloadable Excel model is available for Omnicom Group, designed to evaluate its equity valuation and post-merger integration trajectory. This model helps analysts assess whether the transformational acquisition of Interpublic Group justifies the capital outlay.

Have more financial modelling questions? Contact us

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Other Media Company Financial Models

Browse another company in the same sector.

APP.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
AppLovin logo

AppLovin

AppLovin operates a leading software-based platform that provides end-to-end advertising and AI solutions to help businesses reach, monetise, and grow their global audiences.

DIS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Walt Disney logo

Walt Disney

The Walt Disney Company is a diversified global entertainment conglomerate that produces premium content, operates direct-to-consumer streaming services, broadcasts live sports, and operates world-renowned theme parks and cruise lines.

EA.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Electronic Arts logo

Electronic Arts

Electronic Arts (EA) is a global leader in digital interactive entertainment, developing and delivering games, content, and online services for consoles, personal computers, and mobile devices.

FOX.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Fox logo

Fox

Fox Corporation is a leading news, sports, and entertainment broadcasting company in the United States.

GOOGL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Alphabet logo

Alphabet

Alphabet is a global technology holding company known for its core Google internet products including Search, YouTube, Android, and Chrome, generating revenue primarily through digital advertising while scaling cloud computing and AI infrastructure.

HAS.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Hasbro logo

Hasbro

Hasbro is a global play and entertainment company that designs, manufactures, and licenses toys, tabletop games, and digital gaming experiences.

LYV.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Live Nation Entertainment logo

Live Nation Entertainment

Live Nation Entertainment (LYV) is the world's largest live entertainment company, operating a vertically integrated model that spans concert promotion, venue operation, ticketing, and brand sponsorship.

META.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Meta Platforms logo

Meta Platforms

Meta Platforms builds technologies that help people connect, find communities, and grow businesses.

Explore more Tech & Software financial model templates.

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview