NOV Inc. (NOV) 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
NOV Inc. (NOV) Bundle
Streamline your analysis and increase precision with our (NOV) DCF Calculator! Equipped with real NOV Inc. data and customizable assumptions, this tool empowers you to forecast, evaluate, and appraise NOV like a seasoned investor.
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.