ITT Inc. (ITT) DCF Valuation

ITT Inc. (ITT) 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

ITT Inc. (ITT) 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 mastery over your ITT Inc. (ITT) valuation analysis using our sophisticated DCF Calculator! This Excel template comes preloaded with actual ITT data, enabling you to adjust forecasts and assumptions to determine the intrinsic value of ITT Inc. (ITT) with accuracy.


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 2,846.4 2,477.8 2,765.0 2,987.7 3,283.0 3,419.1 3,560.8 3,708.4 3,862.1 4,022.2
Revenue Growth, % 0 -12.95 11.59 8.05 9.88 4.14 4.14 4.14 4.14 4.14
EBITDA 513.9 455.0 545.6 554.5 639.1 644.0 670.7 698.5 727.4 757.6
EBITDA, % 18.05 18.36 19.73 18.56 19.47 18.84 18.84 18.84 18.84 18.84
Depreciation 113.4 112.2 113.1 107.4 109.2 133.5 139.0 144.8 150.8 157.1
Depreciation, % 3.98 4.53 4.09 3.59 3.33 3.9 3.9 3.9 3.9 3.9
EBIT 400.5 342.8 432.5 447.1 529.9 510.5 531.6 553.7 576.6 600.5
EBIT, % 14.07 13.83 15.64 14.96 16.14 14.93 14.93 14.93 14.93 14.93
Total Cash 612.1 859.8 647.5 561.2 489.2 774.8 806.9 840.4 875.2 911.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 596.4 526.6 575.7 655.1 701.0
Account Receivables, % 20.95 21.25 20.82 21.93 21.35
Inventories 392.9 360.5 430.9 533.9 575.4 542.5 565.0 588.4 612.8 638.2
Inventories, % 13.8 14.55 15.58 17.87 17.53 15.87 15.87 15.87 15.87 15.87
Accounts Payable 332.4 306.8 373.4 401.1 437.0 439.7 457.9 476.9 496.7 517.3
Accounts Payable, % 11.68 12.38 13.5 13.43 13.31 12.86 12.86 12.86 12.86 12.86
Capital Expenditure -91.4 -63.7 -88.4 -103.9 -107.6 -107.6 -112.1 -116.7 -121.5 -126.6
Capital Expenditure, % -3.21 -2.57 -3.2 -3.48 -3.28 -3.15 -3.15 -3.15 -3.15 -3.15
Tax Rate, % 20.98 20.98 20.98 20.98 20.98 20.98 20.98 20.98 20.98 20.98
EBITAT 314.2 291.7 268.7 355.3 418.7 392.2 408.5 425.4 443.0 461.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -320.7 416.8 240.5 204.1 368.8 427.8 401.1 417.7 435.0 453.0
WACC, % 10.94 10.95 10.92 10.94 10.94 10.94 10.94 10.94 10.94 10.94
PV UFCF
SUM PV UFCF 1,574.2
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 467
Terminal Value 5,878
Present Terminal Value 3,498
Enterprise Value 5,072
Net Debt -204
Equity Value 5,276
Diluted Shares Outstanding, MM 83
Equity Value Per Share 63.80

What You Will Receive

  • Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled real ITT financials.
  • Actual Data Insights: Access to historical data and forward-looking estimates (highlighted in the yellow cells).
  • Forecast Customization: Modify forecast parameters such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Quickly observe how your inputs influence ITT’s valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • Intuitive Layout: Organized for clarity and user-friendliness, complete with step-by-step guidance.

Key Features

  • Comprehensive DCF Calculator: Features both unlevered and levered DCF valuation models tailored for ITT Inc. (ITT).
  • WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable inputs specific to ITT Inc. (ITT).
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as per ITT Inc. (ITT) needs.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to ITT Inc. (ITT).
  • Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis of ITT Inc. (ITT).

How It Functions

  1. Download the Template: Gain immediate access to the Excel-based ITT DCF Calculator.
  2. Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional variables.
  3. Instant Calculations: The model automatically refreshes ITT’s intrinsic value.
  4. Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
  5. Analyze and Decide: Leverage the outcomes to inform your investment or financial analysis.

Why Choose This Calculator for ITT Inc. (ITT)?

  • Designed for Experts: A sophisticated tool tailored for analysts, CFOs, and industry consultants.
  • Accurate Financial Data: ITT's historical and projected financials are preloaded for precision.
  • Versatile Scenario Analysis: Effortlessly simulate various forecasts and assumptions.
  • Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
  • User-Friendly: Step-by-step guidance makes the process straightforward.

Who Should Use This Product?

  • Finance Students: Master valuation techniques and apply them using real-world data related to ITT Inc. (ITT).
  • Academics: Integrate professional valuation models into your coursework or research focused on ITT Inc. (ITT).
  • Investors: Challenge your own assumptions and evaluate valuation outcomes for ITT Inc. (ITT) stock.
  • Analysts: Enhance your efficiency with a ready-made, customizable DCF model tailored for ITT Inc. (ITT).
  • Small Business Owners: Discover how large public companies like ITT Inc. (ITT) are analyzed and valued.

What the Template Contains

  • Comprehensive DCF Model: Editable template featuring detailed valuation calculations specific to ITT Inc. (ITT).
  • Real-World Data: ITT’s historical and projected financials preloaded for thorough analysis.
  • Customizable Parameters: Modify WACC, growth rates, and tax assumptions to evaluate different scenarios.
  • Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
  • Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
  • Dashboard with Visual Outputs: Visual representations such as charts and tables for clear, actionable insights.

No products were found matching.