Xerox Holdings Corporation (XRX) DCF Valuation

Xerox Holdings Corporation (XRX) DCF Valuation
  • Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
  • Design Profissional: Modelos Confiáveis ​​E Padrão Da Indústria
  • Pré-Construídos Para Uso Rápido E Eficiente
  • Não É Necessária Experiência; Fácil De Seguir

Xerox Holdings Corporation (XRX) 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:

Designed for accuracy, our (XRX) DCF Calculator enables you to evaluate Xerox Holdings Corporation's valuation using up-to-date financial data, allowing complete flexibility to modify all key parameters for improved projections.


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 9,066.0 7,022.0 7,038.0 7,107.0 6,886.0 6,465.1 6,070.0 5,699.0 5,350.7 5,023.7
Revenue Growth, % 0 -22.55 0.22786 0.98039 -3.11 -6.11 -6.11 -6.11 -6.11 -6.11
EBITDA 1,366.0 718.0 -46.0 47.0 291.0 381.8 358.4 336.5 316.0 296.7
EBITDA, % 15.07 10.23 -0.65359 0.66132 4.23 5.91 5.91 5.91 5.91 5.91
Depreciation 435.0 372.0 333.0 280.0 251.0 289.8 272.1 255.5 239.8 225.2
Depreciation, % 4.8 5.3 4.73 3.94 3.65 4.48 4.48 4.48 4.48 4.48
EBIT 931.0 346.0 -379.0 -233.0 40.0 92.0 86.4 81.1 76.1 71.5
EBIT, % 10.27 4.93 -5.39 -3.28 0.58089 1.42 1.42 1.42 1.42 1.42
Total Cash 2,740.0 2,625.0 1,840.0 1,045.0 519.0 1,499.8 1,408.1 1,322.1 1,241.3 1,165.4
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 2,532.0 2,093.0 1,965.0 2,038.0 1,776.0
Account Receivables, % 27.93 29.81 27.92 28.68 25.79
Inventories 694.0 843.0 696.0 797.0 661.0 651.2 611.4 574.0 539.0 506.0
Inventories, % 7.65 12.01 9.89 11.21 9.6 10.07 10.07 10.07 10.07 10.07
Accounts Payable 1,053.0 983.0 1,069.0 1,331.0 1,044.0 965.8 906.8 851.3 799.3 750.5
Accounts Payable, % 11.61 14 15.19 18.73 15.16 14.94 14.94 14.94 14.94 14.94
Capital Expenditure -65.0 -74.0 -68.0 -57.0 -37.0 -52.7 -49.5 -46.5 -43.6 -41.0
Capital Expenditure, % -0.71696 -1.05 -0.96618 -0.80203 -0.53732 -0.81527 -0.81527 -0.81527 -0.81527 -0.81527
Tax Rate, % 103.57 103.57 103.57 103.57 103.57 103.57 103.57 103.57 103.57 103.57
EBITAT 728.3 263.6 -365.4 -230.9 -1.4 64.4 60.4 56.7 53.3 50.0
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -1,074.7 781.6 260.6 80.1 323.6 197.2 374.5 351.7 330.2 310.0
WACC, % 5.9 5.84 6.48 6.57 3.4 5.64 5.64 5.64 5.64 5.64
PV UFCF
SUM PV UFCF 1,321.4
Long Term Growth Rate, % 2.00
Free cash flow (T + 1) 316
Terminal Value 8,692
Present Terminal Value 6,607
Enterprise Value 7,928
Net Debt 2,940
Equity Value 4,988
Diluted Shares Outstanding, MM 149
Equity Value Per Share 33.45

What You Will Get

  • Real XRX Financial Data: Pre-filled with Xerox’s historical and projected data for precise analysis.
  • Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
  • Automatic Calculations: See Xerox’s intrinsic value update instantly based on your changes.
  • Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
  • User-Friendly Design: Simple structure and clear instructions for all experience levels.

Key Features

  • Real-Life XRX Data: Pre-filled with Xerox’s historical financials and future projections.
  • Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
  • Dynamic Valuation Model: Automatic updates to Net Present Value (NPV) and intrinsic value based on your inputs.
  • Scenario Testing: Develop multiple forecasting scenarios to evaluate different valuation outcomes.
  • User-Friendly Design: Intuitive, structured, and crafted for both professionals and novices.

How It Works

  1. Step 1: Download the Excel file.
  2. Step 2: Review Xerox'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 leverage the results for investment decisions.

Why Choose This Calculator for Xerox Holdings Corporation (XRX)?

  • User-Friendly Interface: Perfect for both novices and seasoned professionals.
  • Customizable Inputs: Adjust assumptions effortlessly to suit your financial analysis.
  • Real-Time Adjustments: Witness immediate updates to Xerox’s valuation as you change inputs.
  • Preloaded Data: Comes equipped with Xerox’s actual financial metrics for swift evaluations.
  • Relied Upon by Experts: Utilized by investors and analysts for making well-informed choices.

Who Should Use This Product?

  • Finance Students: Understand financial modeling and apply your knowledge with real-world data from Xerox Holdings Corporation (XRX).
  • Academics: Enhance your curriculum by integrating industry-standard valuation models into your research on Xerox Holdings Corporation (XRX).
  • Investors: Validate your investment strategies and evaluate valuation metrics for Xerox Holdings Corporation (XRX).
  • Analysts: Optimize your analysis process with a customizable DCF model tailored for Xerox Holdings Corporation (XRX).
  • Small Business Owners: Learn from the valuation practices of major companies like Xerox Holdings Corporation (XRX) to inform your own business decisions.

What the Template Contains

  • Pre-Filled Data: Contains Xerox's historical financials and projections.
  • Discounted Cash Flow Model: Editable DCF valuation model with real-time calculations.
  • Weighted Average Cost of Capital (WACC): A dedicated sheet for WACC calculations based on user-defined inputs.
  • Key Financial Ratios: Evaluate Xerox's profitability, efficiency, and leverage metrics.
  • Customizable Inputs: Easily modify revenue growth, profit margins, and tax rates.
  • Clear Dashboard: Visual representations including charts and tables that summarize key valuation outcomes.