Willis Towers Watson logo
Willis Towers Watson Financial Model

Insurance Company Financials Example (Free Excel Download)

Willis Towers Watson is a leading global advisory, broking, and solutions company that provides data-driven, insight-led solutions in the areas of people, risk, and capital.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This financial model evaluates Willis Towers Watson's equity valuation and free cash flow generation capacity, focusing on the margin expansion and organic growth trajectory following the strategic divestiture of the TRANZACT business and the integration of the Newfront acquisition.

Willis Towers Watson is a leading global advisory, broking, and solutions company that provides data-driven, insight-led solutions in the areas of people, risk, and capital. The business operates through two primary segments: Health, Wealth & Career (HWC), which contributes approximately 60% of revenue, and Risk & Broking (R&B), which contributes the remaining 40%. The company operates globally, with North America and Europe representing its largest and most mature markets. The business model is asset-light and human-capital intensive, generating recurring revenue through insurance brokerage commissions, consulting retainers, and proprietary software sales. WTW holds a strong competitive position as one of the "Big Three" global insurance brokers alongside Marsh McLennan and Aon. Recent major corporate events include the sale of the direct-to-consumer TRANZACT business in late 2024 for $632 million (which resulted in a $1.04 billion impairment charge), the completion of a multi-year transformation programme to drive margin expansion, and the strategic acquisition of Newfront in 2025 to bolster its United States middle-market presence.

The downloadable Willis Towers Watson 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 & AssumptionsWillis Towers Watson financial model

Source: SEC EDGAR · values in USD

Line itemFY2021FY2022FY2023FY2024FY2025
Revenue$8.83B$8.73B$9.30B$9.74B$9.52B
Other operating expenses$1.67B$1.78B$1.81B$1.83B$1.41B
Operating income$2.20B$1.18B$1.36B$627.0M$2.23B
Net income$4.22B$1.01B$1.05B-$98.0M$1.60B

How to build a detailed financial model for Willis Towers Watson

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

Revenue Deep Dive

Health, Wealth & Career (HWC)

  • Segment name: Health, Wealth & Career
  • Revenue driver formula: "Consulting Hours x Average Bill Rate" + "Assets Under Management x Fee Rate" + "Brokerage Commissions"
  • Historical growth rate: 4-6% organic CAGR.
  • Key growth levers and headwinds: Growth is driven by healthcare inflation, regulatory changes requiring advisory work, retirement plan mandates, and the expansion of the LifeSight master trust. Headwinds include corporate headcount reductions which lower benefit enrolments.
  • Pricing dynamics: A mix of contractual retainers, project-based hourly fees, and commission-based pricing tied to benefit premiums.
  • Revenue recognition: Recognised over time as advisory services are delivered, or at a point in time for certain software licences and placement commissions.
  • Seasonality: The first and fourth quarters are typically strongest due to the timing of annual benefit enrolments and calendar-year consulting budgets.

Risk & Broking (R&B)

  • Segment name: Risk & Broking
  • Revenue driver formula: "Insurance Premiums Placed x Commission Rate" + "Software Sales (ICT)"
  • Historical growth rate: 5-8% organic CAGR.
  • Key growth levers and headwinds: Highly dependent on the commercial property and casualty (P&C) insurance pricing cycle. Hard markets (rising premiums) act as a major tailwind, while soft markets restrict growth. Client retention and new business generation are critical operational levers.
  • Pricing dynamics: Commissions are directly correlated to underlying insurance premium rates, meaning WTW benefits from inflation in asset values and litigation costs.
  • Revenue recognition: Primarily recognised at the effective date of the associated insurance policy when the placement is complete.
  • Seasonality: The first and fourth quarters are the strongest due to January 1 and December 31 commercial insurance renewal dates.

Cost Structure

Variable Costs / COGS

  • Line-by-line breakdown: WTW does not report a traditional Cost of Goods Sold line. Direct costs of providing services are primarily human capital and are captured in operating expenses.
  • Gross margin range: Not applicable as a reported metric; the firm focuses on operating margin.
  • Key input costs: Professional labour and proprietary data acquisition.
  • How COGS scales with revenue: Costs scale in a step-function manner based on headcount additions, though software and platform revenues offer high operating leverage.

Operating Expenses

  • Salaries and benefits: The largest expense, typically 54-56% of revenue. This includes base salaries, variable performance compensation, and pension costs.
  • Other operating expenses: 18-20% of revenue. This covers IT infrastructure, office occupancy, professional fees, and travel.
  • Depreciation & Amortisation: 4-5% of revenue, split between tangible assets (IT, leaseholds) and intangible assets generated from historical M&A activity.
  • Stock-Based Compensation: Typically 1.5-2.5% of revenue, used to retain key broking and consulting talent.
  • Restructuring / one-time charges: Historically elevated due to the "Grow, Simplify and Transform" programme and the $1.04 billion TRANZACT impairment in 2024, but normalising from 2025 onwards.

Margin Profile

  • Operating margin: Adjusted operating margin reached 23.0% in 2025, up from 21.1% in 2023.
  • Margin trend: Expanding steadily due to the completion of the transformation programme, the divestiture of the lower-margin TRANZACT business, and operating leverage in the R&B segment.
  • Segment-level margins: HWC operates at roughly 28-31% operating margin, while R&B operates at roughly 33-35% operating margin before unallocated corporate costs.

Balance Sheet Structure

  • Total assets: Approximately $30-35 billion.
  • Key asset categories: Fiduciary assets (premiums collected from clients but not yet remitted to insurers) are a massive component, alongside accounts receivable and goodwill.
  • Goodwill & intangibles: Represent a high percentage of total assets (often exceeding 30%) due to the historical Willis and Towers Watson merger and continuous bolt-on acquisitions.
  • Working capital profile:
  • Days Sales Outstanding (DSO): Typically 60-70 days.
  • Days Inventory Outstanding (DIO): Not applicable.
  • Days Payable Outstanding (DPO): Typically 30-40 days for operating payables.
  • Net working capital as % of revenue: Often appears heavily skewed due to the matching of fiduciary assets and fiduciary liabilities.
  • Is working capital positive or negative: Operating working capital is generally positive. The company holds client funds temporarily, generating interest income which flows directly to the bottom line.
  • PP&E: Minimal due to the asset-light model. Mostly consists of leasehold improvements and IT equipment.
  • Right-of-use assets: Material due to a vast global office footprint required for local client coverage.

Capital Expenditure & Investment

  • Capex as % of revenue: 2.0-2.5% (approximately $230-250 million annually).
  • Maintenance capex vs. growth capex: Heavily skewed towards growth, specifically capitalised software development for platforms like Radar and LifeSight.
  • Major capex programmes: Continuous investment in data analytics, artificial intelligence tools for risk modelling, and client-facing digital portals.
  • Capitalised software: Highly material and represents the majority of the capital expenditure cash outflow.
  • M&A pattern: Serial bolt-on acquirer targeting niche expertise, regional presence, or technology (such as the Newfront acquisition).
  • Typical acquisition multiple paid: 10-15x EV/EBITDA for high-quality brokerage and advisory assets.

Debt & Capital Structure

  • Total debt: Approximately $4.7 billion in long-term debt.
  • Debt/EBITDA ratio: Target range of 2.0x to 2.5x.
  • Credit rating: Investment grade (typically BBB/Baa2).
  • Key debt instruments: Senior unsecured notes with staggered maturities and a revolving credit facility for liquidity.
  • Maturity profile: Well-laddered with average maturities exceeding 5 years.
  • Interest rate profile: Predominantly fixed-rate bonds, insulating the company from short-term rate spikes.
  • Covenants: Standard interest coverage and leverage ratio covenants, with significant headroom.
  • Share repurchase programme: Highly active. The company repurchased $1.65 billion in shares in 2025 and $901 million in 2024.
  • Dividend policy: Progressive dividend policy yielding approximately 1.2-1.5%, with a payout ratio of roughly 20-25% of adjusted earnings.

Cash Flow Characteristics

  • Operating cash flow conversion: OCF / Net Income is often greater than 1.5x due to high non-cash charges (amortisation, stock-based compensation) and the timing of fiduciary settlements.
  • Free cash flow margin: 15.9% in 2025 (Free Cash Flow of $1.55 billion on $9.7 billion revenue).
  • Major non-cash items: Amortisation of acquisition intangibles, depreciation, and periodic impairment charges (such as the TRANZACT write-down).
  • Working capital cash flow impact: The timing of fiduciary fund settlements can cause significant quarter-to-quarter volatility in operating cash flow.
  • Capex intensity: Very low, resulting in exceptionally strong cash conversion.
  • Cash tax rate vs. GAAP effective tax rate: Cash taxes are generally aligned with the adjusted effective tax rate of 21-22%, though GAAP rates fluctuate wildly during impairment years.

Sheet Structure

  1. Assumptions: Hardcoded drivers for organic growth, margins, tax rate, share repurchases, and foreign exchange impacts.
  2. Scenarios: Base, Bull, and Bear cases for P&C pricing cycles and interest rate environments.
  3. Revenue Build: Segment-level build for HWC and R&B, explicitly stripping out TRANZACT historicals for pro-forma comparability.
  4. Income Statement: Mirroring WTW's reporting structure (Salaries and benefits, Other operating expenses, Depreciation, Amortisation, Restructuring costs, Interest expense).
  5. Fiduciary Funds Schedule: Tracking fiduciary assets, fiduciary liabilities, and the resulting fiduciary investment income based on short-term interest rates.
  6. Balance Sheet: Assets (Cash, Fiduciary assets, Receivables, Goodwill) and Liabilities (Fiduciary liabilities, Payables, Debt).
  7. Cash Flow Statement: Operating, Investing, and Financing cash flows, highlighting share repurchases and capitalised software additions.
  8. Debt Schedule: Tranche-by-tranche bond maturities, revolving credit facility drawdowns, and interest expense calculation.
  9. DCF Valuation: Unlevered free cash flow build, WACC calculation, and terminal value derivation.
  10. Outputs & Charts: Summary dashboard of adjusted EPS, operating margins, and free cash flow conversion.

Key Financial Relationships

  1. HWC Revenue = Prior Year HWC Revenue * (1 + HWC Organic Growth + FX Impact + M&A Impact)
  2. R&B Revenue = Prior Year R&B Revenue * (1 + R&B Organic Growth + FX Impact + M&A Impact)
  3. Total Revenue = HWC Revenue + R&B Revenue + Corporate/Unallocated Revenue
  4. Salaries and Benefits = Total Revenue * Salaries and Benefits Margin (historically 54-56%)
  5. Fiduciary Investment Income = Average Fiduciary Assets * Average Short-Term Yield
  6. Adjusted Operating Income = Total Revenue - Salaries and Benefits - Other Operating Expenses - Depreciation - Amortisation (excluding transaction and transformation costs)
  7. Adjusted Operating Margin = Adjusted Operating Income / Total Revenue
  8. Free Cash Flow = Cash Flows from Operating Activities - Additions to Fixed Assets and Capitalised Software
  9. Shares Outstanding = Prior Period Shares - (Share Repurchase Amount / Average Share Price)
  10. Adjusted Diluted EPS = Adjusted Net Income / Diluted Shares Outstanding

Cross-Sheet Dependencies

The Revenue Build feeds the top line of the Income Statement. Fiduciary asset balances on the Balance Sheet feed the Fiduciary Funds Schedule, which calculates interest income that flows back to the Income Statement. Net Income from the Income Statement is the starting point for the Cash Flow Statement. The Cash Flow Statement determines the cash balance and debt paydown or drawdown, which link back to the Balance Sheet. Share repurchases in the Cash Flow Statement reduce the share count in the Assumptions and Income Statement for EPS calculations. Circularity risk exists if share repurchases are modelled as a percentage of net income while interest expense depends on debt used to fund those repurchases.

Sign Convention

Revenue and income items are modelled as positive numbers. Expenses (Salaries, Other operating expenses, Depreciation, Amortisation, Interest expense) are modelled as negative numbers in the Income Statement build to allow for simple summation. In the Cash Flow Statement, cash inflows are positive and cash outflows (capex, share repurchases, dividends) are negative. Balance Sheet assets are positive; liabilities and equity are positive.

Things Most Likely to Go Wrong

  1. Failing to adjust historical 2023 and 2024 revenue for the TRANZACT divestiture will artificially depress 2025 growth rates if not handled on a pro-forma basis.
  2. Misunderstanding fiduciary funds is a common error; these are client monies and must be strictly segregated from operating cash in the balance sheet and cash flow statement.
  3. Double-counting fiduciary investment income can occur if it is included in operating revenue rather than modelled as a separate line item.
  4. Ignoring the impact of foreign exchange is dangerous; WTW generates significant revenue outside the US, making a constant-currency toggle essential.
  5. Overestimating operating margins by failing to add back the normalisation of transformation costs which flattered adjusted metrics in 2024.
  6. Mismodelling seasonality will break quarterly models; the first and fourth quarters are significantly larger for revenue and cash flow than the middle quarters due to insurance renewal cycles.
  7. Underestimating the cash drag of capitalised software will inflate valuation; this is a real cash outflow that must be deducted to reach true Free Cash Flow.
  8. Miscalculating the share count reduction is a major risk; WTW's aggressive buyback programme ($1.65 billion in 2025) has a massive impact on EPS growth and must be modelled dynamically.

Validation Checks

  1. Adjusted Operating Margin should be in the 22-25% range; flag if it drops below 20% or exceeds 26%.
  2. Salaries and benefits must remain between 53% and 57% of total revenue.
  3. Free Cash Flow margin should be greater than 15% based on 2025 performance.
  4. Total Assets must equal Total Liabilities plus Equity in every projected period.
  5. Fiduciary Assets should roughly equal Fiduciary Liabilities (usually within a 5% variance).
  6. Debt/EBITDA should remain between 2.0x and 2.5x; flag if leverage exceeds 3.0x.
  7. Effective tax rate should be modelled at 21-22% for adjusted earnings.
  8. Capex (including capitalised software) should not exceed 3% of revenue.

Key Assumptions (Default Values)

AssumptionDefault ValueUnitRationale
HWC Organic Revenue Growth5.0%In line with 2024 and 2025 historical organic growth rates
R&B Organic Revenue Growth6.0%Reflects strong retention and P&C pricing tailwinds seen in 2025
Salaries and Benefits % of Revenue55.0%Historical average and primary cost driver for the human-capital business
Other Operating Expenses % of Revenue18.5%Reflects post-transformation efficiency gains
Adjusted Effective Tax Rate21.5%Based on WTW's reported adjusted tax rate for 2024 and 2025
Capex & Capitalised Software % of Revenue2.4%Based on $229m capex on $9.7B revenue in 2025
Annual Share Repurchases1,500$ MillionsManagement guidance and historical run-rate for capital return
Dividend Payout Ratio25.0%Consistent with historical progressive dividend policy
Fiduciary Funds Yield4.0%Estimated short-term interest rate applied to average fiduciary balances
WACC8.5%Standard discount rate for a large-cap, investment-grade insurance broker
Terminal Growth Rate2.5%Aligns with long-term global GDP and inflation expectations

Data Sources & Benchmarks

  • SEC EDGAR for WTW 10-K and 10-Q filings.
  • WTW Investor Relations website for quarterly earnings presentations and supplemental segment data.
  • Key peers for benchmarking: Marsh McLennan (MMC), Aon (AON), Arthur J. Gallagher (AJG), and Brown & Brown (BRO).
  • Industry data sources: Council of Insurance Agents & Brokers (CIAB) for commercial P&C pricing indices, and Marsh's Global Insurance Market Index.
  • Consensus estimates: Bloomberg or FactSet for forward-looking EPS and revenue estimates.

Sources

Frequently asked

What does Willis Towers Watson do?+

Willis Towers Watson is a leading global advisory, broking, and solutions company providing data-driven, insight-led solutions in people, risk, and capital. It operates through two primary segments, Health, Wealth & Career and Risk & Broking, serving clients globally with its asset-light, human-capital intensive business model.

How does Willis Towers Watson generate its revenue?+

Willis Towers Watson generates recurring revenue primarily through insurance brokerage commissions, consulting retainers, and proprietary software sales. The company's business model is asset-light and human-capital intensive, leveraging its global presence in mature markets like North America and Europe.

What are Willis Towers Watson's primary capital expenditure priorities?+

Willis Towers Watson's capital expenditure, typically 2.0-2.5% of revenue, is heavily skewed towards growth investments. This primarily includes significant capitalised software development for platforms like Radar and LifeSight, alongside continuous investment in data analytics and AI tools.

What are the main business segments of Willis Towers Watson?+

Willis Towers Watson operates through two primary segments: Health, Wealth & Career (HWC) and Risk & Broking (R&B). HWC contributes approximately 60% of the company's revenue, while R&B accounts for the remaining 40%.

What are the significant components of Willis Towers Watson's balance sheet assets?+

Willis Towers Watson's balance sheet includes massive fiduciary assets, accounts receivable, and goodwill as key components. Goodwill and intangibles represent a high percentage of total assets, often exceeding 30%, largely due to historical mergers and continuous acquisitions.

Is a downloadable financial model available for Willis Towers Watson?+

No, a downloadable Excel financial model for Willis Towers Watson is not available on this platform. This financial model focuses on evaluating the company's equity valuation and free cash flow generation capacity.

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 Insurance Company Financial Models

Browse another company in the same sector.

ACGL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Arch Capital Group logo

Arch Capital Group

Arch Capital Group is a Bermuda-based global provider of specialty property and casualty insurance, reinsurance, and mortgage insurance, dynamically allocating capital across underwriting opportunities.

AFL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Aflac logo

Aflac

Aflac Incorporated is a leading provider of supplemental health and life insurance products, designed to pay cash benefits directly to policyholders for costs not covered by primary health insurance.

AIG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
American International Group logo

American International Group

American International Group (AIG) is a leading global insurance organisation providing property casualty insurance solutions to businesses and individuals in over 200 countries and jurisdictions.

AIZ.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Assurant logo

Assurant

Assurant is a global provider of risk management solutions, protecting consumer purchases such as mobile devices, vehicles, and homes through B2B2C partnerships with brands, telecom providers, and financial institutions.

AJG.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Arthur J. Gallagher & Co. logo

Arthur J. Gallagher & Co.

Arthur J.

ALL.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Allstate logo

Allstate

The Allstate Corporation is one of the largest publicly held personal lines property and casualty insurers in the United States.

AON.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Aon logo

Aon

Aon plc is a leading global professional services firm providing a broad range of risk, retirement, and health solutions.

BRK.B.xlsx
Metric
2026
2027
Revenue
--
--
EBITDA
--
--
Berkshire Hathaway logo

Berkshire Hathaway

Berkshire Hathaway is a multinational conglomerate holding company overseen by Warren Buffett.

Explore more Financial Services 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