TELUS International (Cda) Inc. (TIXT) DCF Valuation

TELUS International (Cda) Inc. (TIXT) 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

TELUS International (Cda) Inc. (TIXT) 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:

Gain insight into your TELUS International (Cda) Inc. (TIXT) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with real (TIXT) data, enabling you to adjust forecasts and assumptions to accurately determine the intrinsic value of TELUS International (Cda) Inc.


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 1,019.6 1,581.6 2,194.0 2,468.0 2,708.0 3,493.7 4,507.3 5,815.0 7,502.2 9,678.8
Revenue Growth, % 0 55.12 38.72 12.49 9.72 29.01 29.01 29.01 29.01 29.01
EBITDA 220.1 396.9 439.1 527.2 523.4 750.4 968.1 1,248.9 1,611.3 2,078.8
EBITDA, % 21.59 25.1 20.01 21.36 19.33 21.48 21.48 21.48 21.48 21.48
Depreciation 94.3 191.6 254.7 247.8 329.9 385.7 497.6 642.0 828.3 1,068.6
Depreciation, % 9.25 12.12 11.61 10.04 12.18 11.04 11.04 11.04 11.04 11.04
EBIT 125.8 205.3 184.4 279.5 193.5 364.6 470.4 606.9 783.0 1,010.2
EBIT, % 12.33 12.98 8.4 11.32 7.14 10.44 10.44 10.44 10.44 10.44
Total Cash 79.5 152.5 115.0 125.0 131.0 227.7 293.7 378.9 488.9 630.7
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 217.7 363.0 473.0 516.0 512.0
Account Receivables, % 21.35 22.95 21.56 20.91 18.91
Inventories 3.3 1.8 3.0 19.0 .0 9.4 12.1 15.6 20.2 26.0
Inventories, % 0.32366 0.11381 0.13674 0.76985 0 0.26881 0.26881 0.26881 0.26881 0.26881
Accounts Payable 20.3 56.0 79.0 39.0 215.0 130.3 168.1 216.9 279.9 361.1
Accounts Payable, % 1.99 3.54 3.6 1.58 7.94 3.73 3.73 3.73 3.73 3.73
Capital Expenditure -52.7 -59.2 -99.0 -105.0 -89.0 -146.5 -189.0 -243.8 -314.6 -405.8
Capital Expenditure, % -5.17 -3.74 -4.51 -4.25 -3.29 -4.19 -4.19 -4.19 -4.19 -4.19
Tax Rate, % 8.47 8.47 8.47 8.47 8.47 8.47 8.47 8.47 8.47 8.47
EBITAT 91.3 140.5 101.3 204.6 177.1 263.1 339.4 437.9 564.9 728.8
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -67.7 164.8 168.8 248.3 617.0 181.8 468.9 604.9 780.4 1,006.9
WACC, % 6.64 6.43 5.75 6.67 7.59 6.61 6.61 6.61 6.61 6.61
PV UFCF
SUM PV UFCF 2,417.2
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 1,027
Terminal Value 22,255
Present Terminal Value 16,156
Enterprise Value 18,574
Net Debt 1,623
Equity Value 16,951
Diluted Shares Outstanding, MM 286
Equity Value Per Share 59.27

What You Will Get

  • Pre-Filled Financial Model: TELUS International's actual data enables precise DCF valuation.
  • Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
  • Instant Calculations: Automatic updates ensure you see results as you make changes.
  • Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
  • Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.

Key Features

  • Customizable Forecast Inputs: Adjust essential metrics such as revenue growth, EBITDA %, and capital investments.
  • Instant DCF Valuation: Quickly computes intrinsic value, NPV, and other key financial outputs.
  • High-Precision Accuracy: Leverages TELUS International’s actual financial data for credible valuation results.
  • Effortless Scenario Analysis: Easily evaluate various assumptions and compare results side by side.
  • Efficiency Enhancer: Remove the hassle of constructing intricate valuation models from the ground up.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review TELUS International's 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 assumptions.
  5. Step 5: Analyze the outputs and utilize the results for informed investment decisions.

Why Choose This Calculator for TELUS International (Cda) Inc. (TIXT)?

  • User-Friendly Interface: Tailored for both novices and seasoned professionals.
  • Customizable Inputs: Adjust variables easily to suit your financial analysis.
  • Real-Time Feedback: Observe immediate changes in TELUS International's valuation as you tweak inputs.
  • Preloaded Data: Comes equipped with TELUS International's latest financial information for swift evaluations.
  • Preferred by Experts: Utilized by analysts and investors for making well-informed choices.

Who Should Use This Product?

  • Investors: Accurately assess TELUS International (Cda) Inc.'s fair value before making investment choices.
  • CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to TIXT.
  • Consultants: Swiftly customize the template for valuation reports tailored to clients’ needs.
  • Entrepreneurs: Acquire insights into the financial modeling practices of leading companies like TELUS International.
  • Educators: Employ it as a teaching resource to illustrate valuation techniques and methodologies.

What the Template Contains

  • Historical Data: Includes TELUS International’s past financials and baseline forecasts.
  • DCF and Levered DCF Models: Detailed templates to calculate TELUS International’s intrinsic value.
  • WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
  • Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
  • Quarterly and Annual Statements: A complete breakdown of TELUS International’s financials.
  • Interactive Dashboard: Visualize valuation results and projections dynamically.

No products were found matching.