Thomson Reuters Corporation (TRI) DCF Valuation

Thomson Reuters Corporation (TRI) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Thomson Reuters Corporation (TRI) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 18.96 20.32 17.72 17.16 17.57
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

  1. Step 1: Download the Excel file.
  2. Step 2: Review Thomson Reuters Corporation's (TRI) pre-filled financial data and forecasts.
  3. Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
  4. Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
  5. 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).

No products were found matching.