Xerox Holdings Corporation (XRX) 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
Xerox Holdings Corporation (XRX) Bundle
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 | 1,811.8 | 1,701.1 | 1,597.1 | 1,499.5 | 1,407.9 |
Account Receivables, % | 27.93 | 29.81 | 27.92 | 28.68 | 25.79 | 28.02 | 28.02 | 28.02 | 28.02 | 28.02 |
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
- Step 1: Download the Excel file.
- Step 2: Review Xerox's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- 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.