|
Valoración DCF de WEX Inc. (WEX)
US | Technology | Software - Infrastructure | NYSE
|
- ✓ 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
WEX Inc. (WEX) Bundle
¡Mejore sus estrategias de inversión con la calculadora DCF de WEX Inc. (WEX)! Utilice datos financieros reales de WEX, ajuste las predicciones y gastos de crecimiento, y observe instantáneamente cómo estos cambios afectan el valor intrínseco de WEX Inc. (WEX).
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,723.7 | 1,559.9 | 1,850.5 | 2,350.5 | 2,548.0 | 2,831.8 | 3,147.2 | 3,497.7 | 3,887.2 | 4,320.2 |
Revenue Growth, % | 0 | -9.5 | 18.63 | 27.02 | 8.4 | 11.14 | 11.14 | 11.14 | 11.14 | 11.14 |
EBITDA | 588.3 | 133.8 | 630.7 | 649.9 | 849.2 | 780.2 | 867.1 | 963.7 | 1,071.0 | 1,190.3 |
EBITDA, % | 34.13 | 8.58 | 34.08 | 27.65 | 33.33 | 27.55 | 27.55 | 27.55 | 27.55 | 27.55 |
Depreciation | 237.1 | 261.9 | 272.6 | 263.9 | 276.2 | 381.4 | 423.9 | 471.1 | 523.6 | 581.9 |
Depreciation, % | 13.76 | 16.79 | 14.73 | 11.23 | 10.84 | 13.47 | 13.47 | 13.47 | 13.47 | 13.47 |
EBIT | 351.2 | -128.2 | 358.0 | 386.0 | 573.0 | 398.8 | 443.2 | 492.6 | 547.4 | 608.4 |
EBIT, % | 20.37 | -8.22 | 19.35 | 16.42 | 22.49 | 14.08 | 14.08 | 14.08 | 14.08 | 14.08 |
Total Cash | 810.9 | 852.0 | 1,537.6 | 2,317.3 | 3,997.9 | 2,171.1 | 2,412.9 | 2,681.6 | 2,980.3 | 3,312.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 2,661.1 | 1,993.3 | 2,891.2 | 3,275.7 | 3,569.4 | 2,831.8 | 3,147.2 | 3,497.7 | 3,887.2 | 4,320.2 |
Account Receivables, % | 154.38 | 127.79 | 156.24 | 139.36 | 140.09 | 100 | 100 | 100 | 100 | 100 |
Inventories | 282.6 | 570.9 | 793.1 | 1,081.0 | .0 | 803.3 | 892.8 | 992.2 | 1,102.7 | 1,225.5 |
Inventories, % | 16.4 | 36.6 | 42.86 | 45.99 | 0 | 28.37 | 28.37 | 28.37 | 28.37 | 28.37 |
Accounts Payable | 969.8 | 778.2 | 1,021.9 | 1,225.0 | 1,323.6 | 1,503.3 | 1,670.8 | 1,856.8 | 2,063.6 | 2,293.5 |
Accounts Payable, % | 56.26 | 49.89 | 55.22 | 52.12 | 51.95 | 53.09 | 53.09 | 53.09 | 53.09 | 53.09 |
Capital Expenditure | -102.9 | -80.5 | -86.0 | -116.2 | -143.6 | -149.3 | -165.9 | -184.4 | -204.9 | -227.7 |
Capital Expenditure, % | -5.97 | -5.16 | -4.65 | -4.94 | -5.64 | -5.27 | -5.27 | -5.27 | -5.27 | -5.27 |
Tax Rate, % | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 | 27.71 |
EBITAT | 251.9 | -119.4 | 239.0 | 298.4 | 414.2 | 304.1 | 337.9 | 375.6 | 417.4 | 463.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -1,587.8 | 250.0 | -450.9 | -23.2 | 1,432.6 | 650.3 | 358.5 | 398.5 | 442.8 | 492.1 |
WACC, % | 9.13 | 9.51 | 9.04 | 9.23 | 9.14 | 9.21 | 9.21 | 9.21 | 9.21 | 9.21 |
PV UFCF | ||||||||||
SUM PV UFCF | 1,830.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 502 | |||||||||
Terminal Value | 6,965 | |||||||||
Present Terminal Value | 4,484 | |||||||||
Enterprise Value | 6,314 | |||||||||
Net Debt | 2,893 | |||||||||
Equity Value | 3,421 | |||||||||
Diluted Shares Outstanding, MM | 43 | |||||||||
Equity Value Per Share | 79.01 |
What You Will Get
- Real WEX Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on WEX's fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Real-Life WEX Data: Pre-filled with WEX Inc.'s historical financial information and future projections.
- Fully Customizable Inputs: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic recalculations of Net Present Value (NPV) and intrinsic value based on user inputs.
- Scenario Testing: Develop multiple forecasting scenarios to evaluate various valuation results.
- User-Friendly Design: Intuitive layout, structured for both professionals and newcomers.
How It Works
- Step 1: Download the prebuilt Excel template featuring WEX Inc.'s [WEX] data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Adjust forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including WEX Inc.'s intrinsic value.
- Step 5: Make informed investment decisions or create reports based on the outputs.
Why Choose This Calculator?
- Accurate Data: Real WEX financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to match your projections.
- Time-Saving: Pre-built calculations eliminate the need to start from scratch.
- Professional-Grade Tool: Designed for investors, analysts, and consultants.
- User-Friendly: Intuitive layout and step-by-step instructions make it easy for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling WEX Inc. (WEX) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for WEX Inc. (WEX).
- Consultants: Deliver professional valuation insights for WEX Inc. (WEX) to clients quickly and accurately.
- Business Owners: Understand how companies like WEX Inc. (WEX) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to WEX Inc. (WEX).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for WEX Inc. (WEX).
- Real-World Data: WEX’s historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into WEX's performance.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage specific to WEX.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results related to WEX Inc. (WEX).