Thomson Reuters Corporation (TRI) DCF Valuation
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Thomson Reuters Corporation (TRI) Bundle
Looking to evaluate the intrinsic value of Thomson Reuters Corporation? Our TRI DCF Calculator incorporates real-world data along with extensive customization features, enabling you to refine forecasts and make more informed investment choices.
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 | 5,906.0 | 5,984.0 | 6,348.0 | 6,627.0 | 6,794.0 | 7,037.2 | 7,289.1 | 7,550.0 | 7,820.3 | 8,100.2 |
Revenue Growth, % | 0 | 1.32 | 6.08 | 4.4 | 2.52 | 3.58 | 3.58 | 3.58 | 3.58 | 3.58 |
EBITDA | 1,913.5 | 2,757.0 | 1,994.3 | 3,010.0 | 2,950.0 | 2,797.0 | 2,897.1 | 3,000.8 | 3,108.2 | 3,219.5 |
EBITDA, % | 32.4 | 46.07 | 31.42 | 45.42 | 43.42 | 39.75 | 39.75 | 39.75 | 39.75 | 39.75 |
Depreciation | 733.7 | 833.8 | 763.2 | 695.3 | 725.0 | 838.0 | 868.0 | 899.1 | 931.3 | 964.6 |
Depreciation, % | 12.42 | 13.93 | 12.02 | 10.49 | 10.67 | 11.91 | 11.91 | 11.91 | 11.91 | 11.91 |
EBIT | 1,179.8 | 1,923.2 | 1,231.1 | 2,314.7 | 2,225.0 | 1,959.0 | 2,029.1 | 2,101.7 | 2,176.9 | 2,254.9 |
EBIT, % | 19.98 | 32.14 | 19.39 | 34.93 | 32.75 | 27.84 | 27.84 | 27.84 | 27.84 | 27.84 |
Total Cash | 1,358.0 | 2,399.0 | 886.0 | 1,273.0 | 1,264.0 | 1,616.5 | 1,674.4 | 1,734.3 | 1,796.4 | 1,860.7 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 1,120.0 | 1,216.0 | 1,125.0 | 1,137.0 | 1,194.0 | 1,291.2 | 1,337.4 | 1,385.3 | 1,434.8 | 1,486.2 |
Account Receivables, % | 18.96 | 20.32 | 17.72 | 17.16 | 17.57 | 18.35 | 18.35 | 18.35 | 18.35 | 18.35 |
Inventories | 23.0 | 26.0 | 28.0 | 29.0 | 20.0 | 28.1 | 29.1 | 30.2 | 31.2 | 32.4 |
Inventories, % | 0.38943 | 0.43449 | 0.44108 | 0.4376 | 0.29438 | 0.3994 | 0.3994 | 0.3994 | 0.3994 | 0.3994 |
Accounts Payable | 265.0 | 217.0 | 227.0 | 237.0 | 181.0 | 252.3 | 261.4 | 270.7 | 280.4 | 290.5 |
Accounts Payable, % | 4.49 | 3.63 | 3.58 | 3.58 | 2.66 | 3.59 | 3.59 | 3.59 | 3.59 | 3.59 |
Capital Expenditure | -505.0 | -504.0 | -487.0 | -595.0 | -544.0 | -585.9 | -606.9 | -628.6 | -651.1 | -674.4 |
Capital Expenditure, % | -8.55 | -8.42 | -7.67 | -8.98 | -8.01 | -8.33 | -8.33 | -8.33 | -8.33 | -8.33 |
Tax Rate, % | 12.01 | 12.01 | 12.01 | 12.01 | 12.01 | 12.01 | 12.01 | 12.01 | 12.01 | 12.01 |
EBITAT | 2,635.4 | 1,845.8 | -645.9 | 2,097.9 | 1,957.7 | 1,467.6 | 1,520.2 | 1,574.6 | 1,630.9 | 1,689.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 1,986.1 | 2,028.6 | -270.7 | 2,195.2 | 2,034.7 | 1,685.8 | 1,743.1 | 1,805.5 | 1,870.1 | 1,937.1 |
WACC, % | 6.33 | 6.31 | 6.03 | 6.3 | 6.29 | 6.25 | 6.25 | 6.25 | 6.25 | 6.25 |
PV UFCF | ||||||||||
SUM PV UFCF | 7,533.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 1,976 | |||||||||
Terminal Value | 46,476 | |||||||||
Present Terminal Value | 34,320 | |||||||||
Enterprise Value | 41,854 | |||||||||
Net Debt | 2,344 | |||||||||
Equity Value | 39,510 | |||||||||
Diluted Shares Outstanding, MM | 464 | |||||||||
Equity Value Per Share | 85.16 |
What You Will Get
- Editable Forecast Inputs: Effortlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Thomson Reuters Corporation’s (TRI) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model tailored to meet your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to reliable pre-loaded historical data and future forecasts for Thomson Reuters Corporation (TRI).
- Adjustable Forecast Parameters: Modify highlighted cells, including WACC, growth rates, and profit margins, to suit your analysis.
- Real-Time Calculations: Experience automatic updates to DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: Utilize user-friendly charts and summaries to effectively visualize your valuation insights.
- Designed for All Users: A straightforward, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Thomson Reuters Corporation's (TRI) pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the results and leverage the insights for your investment decisions.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by financial analysts, investment managers, and corporate strategists.
- Accurate Financial Data: Thomson Reuters Corporation’s (TRI) historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth calculation process.
Who Should Use This Product?
- Investors: Accurately assess Thomson Reuters Corporation’s (TRI) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for comprehensive financial reporting and analysis.
- Consultants: Efficiently customize the template for valuation reports tailored to clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading corporations.
- Educators: Implement it as a teaching resource to illustrate various valuation methodologies.
What the Template Contains
- Pre-Filled Data: Includes Thomson Reuters Corporation’s (TRI) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations tailored for (TRI).
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs relevant to (TRI).
- Key Financial Ratios: Analyze Thomson Reuters’ (TRI) profitability, efficiency, and leverage metrics.
- Customizable Inputs: Easily edit revenue growth, margins, and tax rates specific to (TRI).
- Clear Dashboard: Visualizations and tables summarizing key valuation results for (TRI).