|
Valoración de DCF de Nov Inc. (Nov)
US | Energy | Oil & Gas Equipment & Services | 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
NOV Inc. (NOV) Bundle
¡Agilice su análisis y aumente la precisión con nuestra calculadora DCF (nov)! Equipado con datos de Real Nov Inc. y supuestos personalizables, esta herramienta le permite pronosticar, evaluar y evaluar Nov como un inversor experimentado.
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 | 8,479.0 | 6,090.0 | 5,524.0 | 7,237.0 | 8,583.0 | 8,843.5 | 9,111.9 | 9,388.4 | 9,673.3 | 9,966.9 |
| Revenue Growth, % | 0 | -28.18 | -9.29 | 31.01 | 18.6 | 3.03 | 3.03 | 3.03 | 3.03 | 3.03 |
| EBITDA | -5,829.0 | -2,343.0 | 153.0 | 617.0 | 1,002.0 | -1,490.1 | -1,535.3 | -1,581.9 | -1,630.0 | -1,679.4 |
| EBITDA, % | -68.75 | -38.47 | 2.77 | 8.53 | 11.67 | -16.85 | -16.85 | -16.85 | -16.85 | -16.85 |
| Depreciation | 533.0 | 352.0 | 306.0 | 301.0 | 302.0 | 447.2 | 460.8 | 474.7 | 489.1 | 504.0 |
| Depreciation, % | 6.29 | 5.78 | 5.54 | 4.16 | 3.52 | 5.06 | 5.06 | 5.06 | 5.06 | 5.06 |
| EBIT | -6,362.0 | -2,695.0 | -153.0 | 316.0 | 700.0 | -1,937.3 | -1,996.1 | -2,056.7 | -2,119.1 | -2,183.4 |
| EBIT, % | -75.03 | -44.25 | -2.77 | 4.37 | 8.16 | -21.91 | -21.91 | -21.91 | -21.91 | -21.91 |
| Total Cash | 1,171.0 | 1,692.0 | 1,591.0 | 1,069.0 | 816.0 | 1,674.5 | 1,725.3 | 1,777.7 | 1,831.6 | 1,887.2 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,498.0 | 1,885.0 | 1,782.0 | 2,424.0 | 2,644.0 | 2,776.4 | 2,860.6 | 2,947.4 | 3,036.9 | 3,129.1 |
| Account Receivables, % | 29.46 | 30.95 | 32.26 | 33.49 | 30.81 | 31.39 | 31.39 | 31.39 | 31.39 | 31.39 |
| Inventories | 2,197.0 | 1,408.0 | 1,331.0 | 1,813.0 | 2,151.0 | 2,179.7 | 2,245.9 | 2,314.0 | 2,384.3 | 2,456.6 |
| Inventories, % | 25.91 | 23.12 | 24.09 | 25.05 | 25.06 | 24.65 | 24.65 | 24.65 | 24.65 | 24.65 |
| Accounts Payable | 715.0 | 489.0 | 612.0 | 906.0 | 904.0 | 894.8 | 922.0 | 950.0 | 978.8 | 1,008.5 |
| Accounts Payable, % | 8.43 | 8.03 | 11.08 | 12.52 | 10.53 | 10.12 | 10.12 | 10.12 | 10.12 | 10.12 |
| Capital Expenditure | -233.0 | -226.0 | -201.0 | -214.0 | -283.0 | -289.2 | -298.0 | -307.0 | -316.4 | -326.0 |
| Capital Expenditure, % | -2.75 | -3.71 | -3.64 | -2.96 | -3.3 | -3.27 | -3.27 | -3.27 | -3.27 | -3.27 |
| Tax Rate, % | -62.25 | -62.25 | -62.25 | -62.25 | -62.25 | -62.25 | -62.25 | -62.25 | -62.25 | -62.25 |
| EBITAT | -5,998.7 | -2,460.3 | -163.0 | 205.8 | 1,135.8 | -1,746.3 | -1,799.3 | -1,853.9 | -1,910.2 | -1,968.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -9,678.7 | -1,158.3 | 245.0 | -537.2 | 594.8 | -1,758.6 | -1,759.8 | -1,813.2 | -1,868.2 | -1,924.9 |
| WACC, % | 9.96 | 9.93 | 10.04 | 9.58 | 10.04 | 9.91 | 9.91 | 9.91 | 9.91 | 9.91 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -6,902.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1,963 | |||||||||
| Terminal Value | -24,821 | |||||||||
| Present Terminal Value | -15,475 | |||||||||
| Enterprise Value | -22,378 | |||||||||
| Net Debt | 1,561 | |||||||||
| Equity Value | -23,939 | |||||||||
| Diluted Shares Outstanding, MM | 397 | |||||||||
| Equity Value Per Share | -60.30 |
What You Will Get
- Pre-Filled Financial Model: NOV Inc.'s actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- 🔍 Real-Life NOV Financials: Pre-filled historical and projected data for NOV Inc. (NOV).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate NOV’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize NOV’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Get the pre-configured Excel file containing NOV Inc.'s (NOV) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation findings to inform your investment approach.
Why Choose the NOV Inc. (NOV) Calculator?
- Precision: Utilizes authentic NOV financial data for reliable results.
- Versatility: Crafted for users to easily adjust and experiment with inputs.
- Efficiency: Eliminate the need to construct a DCF model from the ground up.
- Expert-Quality: Built with the accuracy and functionality expected at the CFO level.
- Intuitive: Simple to navigate, even for individuals with limited financial modeling skills.
Who Should Use NOV Inc. (NOV)?
- Investors: Gain insights and make informed decisions with a robust investment analysis tool.
- Financial Analysts: Streamline your workflow with a customizable financial model prepped for your needs.
- Consultants: Effortlessly modify the template for impactful client presentations or reports.
- Finance Enthusiasts: Enhance your knowledge of market dynamics through practical, real-world applications.
- Educators and Students: Utilize it as an effective resource for learning in finance and investment courses.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled NOV Inc. (NOV) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for NOV Inc. (NOV).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.