Otis Worldwide Corporation (OTIS) DCF Valuation

Otis Worldwide Corporation (OTIS) 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

Otis Worldwide Corporation (OTIS) 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:

Discover the true potential of Otis Worldwide Corporation (OTIS) with our advanced DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how different changes affect Otis Worldwide Corporation (OTIS) valuation – all within a single Excel template.


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 13,118.0 12,756.0 14,298.0 13,685.0 14,209.0 14,524.1 14,846.2 15,175.4 15,512.0 15,856.0
Revenue Growth, % 0 -2.76 12.09 -4.29 3.83 2.22 2.22 2.22 2.22 2.22
EBITDA 2,080.0 1,830.0 2,311.0 2,224.0 2,374.0 2,304.2 2,355.3 2,407.6 2,461.0 2,515.5
EBITDA, % 15.86 14.35 16.16 16.25 16.71 15.86 15.86 15.86 15.86 15.86
Depreciation 180.0 191.0 203.0 191.0 193.0 204.6 209.1 213.8 218.5 223.4
Depreciation, % 1.37 1.5 1.42 1.4 1.36 1.41 1.41 1.41 1.41 1.41
EBIT 1,900.0 1,639.0 2,108.0 2,033.0 2,181.0 2,099.6 2,146.2 2,193.8 2,242.4 2,292.2
EBIT, % 14.48 12.85 14.74 14.86 15.35 14.46 14.46 14.46 14.46 14.46
Total Cash 1,446.0 1,782.0 1,565.0 1,189.0 1,274.0 1,556.8 1,591.3 1,626.6 1,662.7 1,699.5
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 3,390.0 3,606.0 3,782.0 4,021.0 4,255.0
Account Receivables, % 25.84 28.27 26.45 29.38 29.95
Inventories 571.0 659.0 622.0 617.0 612.0 659.0 673.6 688.5 703.8 719.4
Inventories, % 4.35 5.17 4.35 4.51 4.31 4.54 4.54 4.54 4.54 4.54
Accounts Payable 1,331.0 1,453.0 1,556.0 1,717.0 1,878.0 1,690.1 1,727.6 1,765.9 1,805.1 1,845.1
Accounts Payable, % 10.15 11.39 10.88 12.55 13.22 11.64 11.64 11.64 11.64 11.64
Capital Expenditure -145.0 -183.0 -156.0 -115.0 -138.0 -158.1 -161.6 -165.2 -168.9 -172.6
Capital Expenditure, % -1.11 -1.43 -1.09 -0.84034 -0.97122 -1.09 -1.09 -1.09 -1.09 -1.09
Tax Rate, % 30.77 30.77 30.77 30.77 30.77 30.77 30.77 30.77 30.77 30.77
EBITAT 1,139.4 982.7 1,339.4 1,349.2 1,509.8 1,339.8 1,369.5 1,399.9 1,431.0 1,462.7
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -1,455.6 808.7 1,350.4 1,352.2 1,496.8 1,342.9 1,349.8 1,379.8 1,410.3 1,441.6
WACC, % 7.91 7.91 7.93 7.95 7.97 7.94 7.94 7.94 7.94 7.94
PV UFCF
SUM PV UFCF 5,523.2
Long Term Growth Rate, % 4.00
Free cash flow (T + 1) 1,499
Terminal Value 38,093
Present Terminal Value 26,003
Enterprise Value 31,526
Net Debt 6,033
Equity Value 25,493
Diluted Shares Outstanding, MM 415
Equity Value Per Share 61.49

What You Will Receive

  • Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real OTIS financials.
  • Accurate Data: Historical figures and forward-looking projections (as indicated in the highlighted cells).
  • Flexible Forecasting: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Quickly observe how your inputs influence Otis’s valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • Intuitive Layout: Organized for clarity and simplicity, complete with step-by-step guidance.

Key Features

  • Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Otis Worldwide Corporation (OTIS).
  • WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Otis.
  • Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as needed.
  • Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Otis Worldwide Corporation (OTIS).
  • Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.

How It Works

  • Step 1: Download the prebuilt Excel template featuring Otis Worldwide Corporation’s (OTIS) data.
  • Step 2: Navigate through the pre-filled sheets to familiarize yourself with the key performance indicators.
  • Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
  • Step 4: Immediately see the recalculated results, including Otis Worldwide Corporation’s (OTIS) intrinsic value.
  • Step 5: Utilize the outputs to make informed investment decisions or create detailed reports.

Why Choose This Calculator for Otis Worldwide Corporation (OTIS)?

  • Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient package.
  • Customizable Inputs: Modify yellow-highlighted cells to explore different financial scenarios.
  • Detailed Insights: Automatically computes Otis Worldwide's intrinsic value and Net Present Value.
  • Preloaded Data: Historical and projected data provide reliable starting points for analysis.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focused on Otis Worldwide Corporation.

Who Should Use This Product?

  • Real Estate Investors: Develop comprehensive valuation models for assessing property investments.
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
  • Consultants and Advisors: Deliver precise valuation insights for Otis Worldwide Corporation (OTIS) to clients.
  • Students and Educators: Utilize actual data to practice and instruct on financial modeling techniques.
  • Industry Analysts: Gain insights into how companies like Otis Worldwide Corporation (OTIS) are valued in the elevator and escalator market.

What the Template Contains

  • Pre-Filled DCF Model: Otis Worldwide Corporation’s (OTIS) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate Otis’s profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.