Willis Towers Watson Public Limited Company (WTW) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Willis Towers Watson Public Limited Company (WTW) Bundle
Evaluate the financial outlook of Willis Towers Watson Public Limited Company (WTW) like an expert! This (WTW) DCF Calculator provides pre-filled financial data and offers full flexibility to modify revenue growth, WACC, margins, and other essential 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 | 9,039.0 | 9,352.0 | 8,998.0 | 8,866.0 | 9,483.0 | 9,605.6 | 9,729.7 | 9,855.5 | 9,982.8 | 10,111.8 |
Revenue Growth, % | 0 | 3.46 | -3.79 | -1.47 | 6.96 | 1.29 | 1.29 | 1.29 | 1.29 | 1.29 |
EBITDA | 2,030.0 | 2,376.0 | 2,399.0 | 1,878.0 | 2,019.0 | 2,247.7 | 2,276.7 | 2,306.2 | 2,336.0 | 2,366.1 |
EBITDA, % | 22.46 | 25.41 | 26.66 | 21.18 | 21.29 | 23.4 | 23.4 | 23.4 | 23.4 | 23.4 |
Depreciation | 7,675.0 | 7,622.0 | 7,582.0 | 7,551.0 | 505.0 | 6,554.2 | 6,638.9 | 6,724.7 | 6,811.6 | 6,899.7 |
Depreciation, % | 84.91 | 81.5 | 84.26 | 85.17 | 5.33 | 68.23 | 68.23 | 68.23 | 68.23 | 68.23 |
EBIT | -5,645.0 | -5,246.0 | -5,183.0 | -5,673.0 | 1,514.0 | -4,306.5 | -4,362.2 | -4,418.6 | -4,475.7 | -4,533.5 |
EBIT, % | -62.45 | -56.09 | -57.6 | -63.99 | 15.97 | -44.83 | -44.83 | -44.83 | -44.83 | -44.83 |
Total Cash | 887.0 | 2,089.0 | 4,686.0 | 1,262.0 | 1,424.0 | 2,180.1 | 2,208.2 | 2,236.8 | 2,265.7 | 2,295.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,621.0 | 2,408.0 | 2,370.0 | 2,387.0 | 2,572.0 | 2,596.0 | 2,629.5 | 2,663.5 | 2,697.9 | 2,732.8 |
Account Receivables, % | 29 | 25.75 | 26.34 | 26.92 | 27.12 | 27.03 | 27.03 | 27.03 | 27.03 | 27.03 |
Inventories | 13,089.0 | 15,160.0 | 11,020.0 | .0 | .0 | 5,763.3 | 5,837.8 | 5,913.3 | 5,989.7 | 6,067.1 |
Inventories, % | 144.81 | 162.1 | 122.47 | 0 | 0 | 60 | 60 | 60 | 60 | 60 |
Accounts Payable | 318.0 | 857.0 | 322.0 | 329.0 | 396.0 | 463.9 | 469.9 | 476.0 | 482.1 | 488.3 |
Accounts Payable, % | 3.52 | 9.16 | 3.58 | 3.71 | 4.18 | 4.83 | 4.83 | 4.83 | 4.83 | 4.83 |
Capital Expenditure | -305.0 | -286.0 | -201.0 | -204.0 | -242.0 | -259.7 | -263.1 | -266.5 | -269.9 | -273.4 |
Capital Expenditure, % | -3.37 | -3.06 | -2.23 | -2.3 | -2.55 | -2.7 | -2.7 | -2.7 | -2.7 | -2.7 |
Tax Rate, % | 17.51 | 17.51 | 17.51 | 17.51 | 17.51 | 17.51 | 17.51 | 17.51 | 17.51 | 17.51 |
EBITAT | -4,457.9 | -3,905.1 | -4,151.0 | -4,550.1 | 1,248.8 | -3,412.4 | -3,456.5 | -3,501.2 | -3,546.5 | -3,592.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -12,479.9 | 2,111.9 | 6,873.0 | 13,806.9 | 1,393.8 | -2,837.4 | 2,817.3 | 2,853.7 | 2,890.6 | 2,927.9 |
WACC, % | 7.28 | 7.25 | 7.29 | 7.29 | 7.31 | 7.29 | 7.29 | 7.29 | 7.29 | 7.29 |
PV UFCF | ||||||||||
SUM PV UFCF | 6,355.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 2,986 | |||||||||
Terminal Value | 56,498 | |||||||||
Present Terminal Value | 39,748 | |||||||||
Enterprise Value | 46,103 | |||||||||
Net Debt | 4,517 | |||||||||
Equity Value | 41,586 | |||||||||
Diluted Shares Outstanding, MM | 106 | |||||||||
Equity Value Per Share | 392.32 |
What You Will Get
- Genuine WTW Data: Preloaded financials – encompassing revenue to EBIT – derived from actual and projected figures.
- Comprehensive Customization: Modify all essential parameters (yellow cells) such as WACC, growth %, and tax rates.
- Immediate Valuation Updates: Automatic recalculations to assess the effects of changes on WTW’s fair value.
- Flexible Excel Template: Designed for quick adjustments, scenario analysis, and in-depth projections.
- Efficient and Precise: Eliminate the need to build models from scratch while ensuring accuracy and adaptability.
Key Features
- 🔍 Real-Life WTW Financials: Pre-filled historical and projected data for Willis Towers Watson Public Limited Company (WTW).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate WTW’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize WTW’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing Willis Towers Watson's (WTW) preloaded data.
- 2. Modify Assumptions: Adjust key parameters such as growth rates, WACC, and capital expenditures.
- 3. Analyze Results Instantly: The DCF model automatically computes intrinsic value and NPV.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation outcomes.
- 5. Present with Confidence: Deliver professional valuation insights to enhance your decision-making.
Why Choose This Calculator for Willis Towers Watson (WTW)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your financial analysis.
- Real-Time Insights: Monitor immediate changes to WTW’s valuation as you tweak inputs.
- Preconfigured Data: Comes with WTW’s actual financial metrics for swift evaluations.
- Relied Upon by Experts: Favored by investors and analysts for making strategic decisions.
Who Should Use This Product?
- Investors: Assess the fair value of Willis Towers Watson (WTW) to make informed investment choices.
- CFOs: Utilize a sophisticated DCF model for accurate financial reporting and analysis.
- Consultants: Easily modify the template for client valuation reports related to WTW.
- Entrepreneurs: Discover financial modeling techniques employed by leading firms like WTW.
- Educators: Employ it as a resource to illustrate valuation methods in the classroom.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Willis Towers Watson 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 Willis Towers Watson.
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.