NOW Inc. (DNOW) DCF Valuation

NOW Inc. (DNOW) 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

NOW Inc. (DNOW) 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:

Gain insights into your NOW Inc. (DNOW) valuation analysis with our state-of-the-art DCF Calculator! Equipped with real (DNOW) data, this Excel template enables you to adjust forecasts and assumptions to accurately determine the intrinsic value of NOW Inc.


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 2,951.0 1,619.0 1,632.0 2,136.0 2,321.0 2,293.2 2,265.7 2,238.6 2,211.8 2,185.3
Revenue Growth, % 0 -45.14 0.80296 30.88 8.66 -1.2 -1.2 -1.2 -1.2 -1.2
EBITDA 86.0 -77.0 40.0 170.0 164.0 71.7 70.8 70.0 69.2 68.3
EBITDA, % 2.91 -4.76 2.45 7.96 7.07 3.13 3.13 3.13 3.13 3.13
Depreciation 41.0 28.0 23.0 19.0 26.0 30.0 29.6 29.3 28.9 28.6
Depreciation, % 1.39 1.73 1.41 0.88951 1.12 1.31 1.31 1.31 1.31 1.31
EBIT 45.0 -105.0 17.0 151.0 138.0 41.7 41.2 40.7 40.2 39.8
EBIT, % 1.52 -6.49 1.04 7.07 5.95 1.82 1.82 1.82 1.82 1.82
Total Cash 183.0 387.0 313.0 212.0 299.0 330.6 326.7 322.8 318.9 315.1
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 370.0 198.0 304.0 398.0 384.0
Account Receivables, % 12.54 12.23 18.63 18.63 16.54
Inventories 465.0 262.0 250.0 381.0 366.0 370.9 366.4 362.0 357.7 353.4
Inventories, % 15.76 16.18 15.32 17.84 15.77 16.17 16.17 16.17 16.17 16.17
Accounts Payable 255.0 172.0 235.0 304.0 288.0 276.6 273.3 270.0 266.8 263.6
Accounts Payable, % 8.64 10.62 14.4 14.23 12.41 12.06 12.06 12.06 12.06 12.06
Capital Expenditure -12.0 -8.0 -5.0 -9.0 -17.0 -10.8 -10.7 -10.6 -10.4 -10.3
Capital Expenditure, % -0.40664 -0.49413 -0.30637 -0.42135 -0.73244 -0.47219 -0.47219 -0.47219 -0.47219 -0.47219
Tax Rate, % -78.99 -78.99 -78.99 -78.99 -78.99 -78.99 -78.99 -78.99 -78.99 -78.99
EBITAT 46.9 -104.3 7.1 139.1 247.0 36.1 35.7 35.3 34.8 34.4
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -504.1 207.7 -5.9 -6.9 269.0 62.6 60.1 59.4 58.6 57.9
WACC, % 11.1 11.1 11.03 11.09 11.1 11.09 11.09 11.09 11.09 11.09
PV UFCF
SUM PV UFCF 221.1
Long Term Growth Rate, % 1.00
Free cash flow (T + 1) 59
Terminal Value 580
Present Terminal Value 343
Enterprise Value 564
Net Debt -258
Equity Value 822
Diluted Shares Outstanding, MM 108
Equity Value Per Share 7.58

What You Will Receive

  • Customizable Excel Template: A fully adaptable Excel-based DCF Calculator featuring pre-filled real DNOW financials.
  • Authentic Data: Historical figures and future estimates (highlighted in the yellow cells).
  • Flexible Forecasting: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
  • Instant Calculations: Immediately observe the effect of your inputs on NOW Inc.'s valuation.
  • Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
  • Intuitive Design: Organized for clarity and simplicity, complete with step-by-step guidance.

Key Features

  • 🔍 Real-Life DNOW Financials: Pre-filled historical and projected data for NOW Inc. (DNOW).
  • ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
  • 📊 Professional DCF Valuation: Integrated formulas calculate NOW's intrinsic value using the Discounted Cash Flow method.
  • ⚡ Instant Results: Visualize NOW's valuation immediately after making adjustments.
  • Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.

How It Works

  1. Step 1: Download the Excel file for NOW Inc. (DNOW).
  2. Step 2: Review NOW Inc.’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 NOW Inc. (DNOW)?

  • Comprehensive Tool: Integrates DCF, WACC, and financial ratio analyses tailored for NOW Inc. (DNOW).
  • Customizable Inputs: Modify the yellow-highlighted cells to explore various financial scenarios.
  • Detailed Insights: Automatically computes NOW Inc.'s (DNOW) intrinsic value and Net Present Value.
  • Preloaded Data: Includes historical and projected data for accurate analysis.
  • Professional Quality: Perfect for financial analysts, investors, and business consultants focusing on NOW Inc. (DNOW).

Who Should Use NOW Inc. (DNOW)?

  • Finance Students: Explore valuation strategies and apply them with actual market data.
  • Academics: Integrate industry-standard models into your teaching or research initiatives.
  • Investors: Validate your investment hypotheses and evaluate valuation results for NOW Inc. (DNOW).
  • Analysts: Enhance your productivity with a ready-to-use, adaptable DCF model.
  • Small Business Owners: Understand the analytical approaches used for evaluating large public firms like NOW Inc. (DNOW).

What the Template Contains

  • Pre-Filled DCF Model: NOW Inc.'s (DNOW) financial data preloaded for immediate use.
  • WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
  • Financial Ratios: Evaluate NOW Inc.'s (DNOW) profitability, leverage, and efficiency.
  • Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
  • Financial Statements: Annual and quarterly reports to support detailed analysis.
  • Interactive Dashboard: Easily visualize key valuation metrics and results.

No products were found matching.