Northwest Pipe Company (NWPX) DCF Valuation

Northwest Pipe Company (NWPX) DCF Valuation
  • ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • ✓ Professional Design: Trusted, Industry-Standard Templates
  • ✓ Pre-Built For Quick And Efficient Use
  • ✓ No Expertise Is Needed; Easy To Follow

Northwest Pipe Company (NWPX) 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 Northwest Pipe Company (NWPX) valuation analysis using our sophisticated DCF Calculator! Equipped with real (NWPX) data, this Excel template enables you to adjust forecasts and assumptions for an accurate calculation of Northwest Pipe Company's intrinsic value.


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 279.3 285.9 333.3 457.7 444.4 503.6 570.8 646.9 733.1 830.9
Revenue Growth, % 0 2.36 16.58 37.31 -2.91 13.33 13.33 13.33 13.33 13.33
EBITDA 43.6 41.6 30.0 62.2 49.7 64.4 72.9 82.7 93.7 106.2
EBITDA, % 15.6 14.54 9 13.58 11.18 12.78 12.78 12.78 12.78 12.78
Depreciation 12.7 14.6 13.6 17.1 15.8 21.2 24.0 27.2 30.8 34.9
Depreciation, % 4.55 5.09 4.09 3.74 3.56 4.2 4.2 4.2 4.2 4.2
EBIT 30.9 27.0 16.4 45.0 33.9 43.2 48.9 55.5 62.9 71.2
EBIT, % 11.05 9.45 4.91 9.84 7.62 8.57 8.57 8.57 8.57 8.57
Total Cash 31.0 37.9 3.0 3.7 4.1 27.2 30.8 34.9 39.6 44.8
Total Cash, percent .0 .0 .0 .0 .0 .0 .0 .0 .0 .0
Account Receivables 129.2 119.7 159.8 193.3 168.2
Account Receivables, % 46.26 41.85 47.95 42.25 37.84
Inventories 30.7 29.2 59.7 71.0 91.2 75.7 85.8 97.2 110.2 124.8
Inventories, % 10.97 10.21 17.9 15.52 20.53 15.03 15.03 15.03 15.03 15.03
Accounts Payable 15.5 13.0 32.3 27.0 31.1 32.9 37.3 42.3 47.9 54.3
Accounts Payable, % 5.55 4.54 9.68 5.89 7.01 6.53 6.53 6.53 6.53 6.53
Capital Expenditure -8.6 -14.3 -13.3 -23.2 -18.3 -21.4 -24.3 -27.5 -31.2 -35.3
Capital Expenditure, % -3.07 -5.02 -3.98 -5.06 -4.12 -4.25 -4.25 -4.25 -4.25 -4.25
Tax Rate, % 28.03 28.03 28.03 28.03 28.03 28.03 28.03 28.03 28.03 28.03
EBITAT 26.4 20.1 12.4 33.9 24.4 33.1 37.5 42.5 48.2 54.6
Depreciation
Changes in Account Receivables
Changes in Inventories
Changes in Accounts Payable
Capital Expenditure
UFCF -113.9 28.8 -38.6 -22.3 31.0 .6 2.5 2.8 3.2 3.7
WACC, % 7.76 7.64 7.66 7.65 7.61 7.66 7.66 7.66 7.66 7.66
PV UFCF
SUM PV UFCF 10.0
Long Term Growth Rate, % 3.00
Free cash flow (T + 1) 4
Terminal Value 81
Present Terminal Value 56
Enterprise Value 66
Net Debt 159
Equity Value -93
Diluted Shares Outstanding, MM 10
Equity Value Per Share -9.23

What You Will Get

  • Editable Forecast Inputs: Effortlessly modify key assumptions (growth %, margins, WACC) to generate various scenarios.
  • Real-World Data: Northwest Pipe Company’s (NWPX) financial data pre-loaded to facilitate your analysis.
  • Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
  • Customizable and Professional: A sleek Excel model designed to meet your valuation requirements.
  • Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.

Key Features

  • Customizable Financial Inputs: Adjust essential parameters such as revenue growth, EBITDA %, and capital investments.
  • Instant DCF Valuation: Automatically computes intrinsic value, NPV, and other financial metrics with ease.
  • High Precision Results: Leverages Northwest Pipe Company's (NWPX) actual financial data for accurate valuation results.
  • Effortless Scenario Testing: Easily explore various assumptions and analyze different outcomes.
  • Efficiency Booster: Streamlines the valuation process, removing the need to create intricate models from the ground up.

How It Works

  • 1. Access the Template: Download and open the Excel file containing Northwest Pipe Company's (NWPX) preloaded data.
  • 2. Modify Assumptions: Adjust crucial inputs such as growth projections, WACC, and capital expenditures.
  • 3. Analyze Results Immediately: The DCF model automatically computes intrinsic value and NPV in real-time.
  • 4. Explore Scenarios: Evaluate various forecasts to assess different valuation results.
  • 5. Present with Assurance: Share professional valuation analyses to back your strategic decisions.

Why Choose This Calculator for Northwest Pipe Company (NWPX)?

  • Accurate Data: Utilize real Northwest Pipe Company financials for dependable valuation outcomes.
  • Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
  • Time-Saving: Pre-configured calculations save you the effort of starting from the ground up.
  • Professional-Grade Tool: Tailored for investors, analysts, and consultants in the industry.
  • User-Friendly: An intuitive design and clear instructions make it accessible for all users.

Who Should Use This Product?

  • Professional Investors: Develop comprehensive and accurate valuation models for portfolio management related to Northwest Pipe Company (NWPX).
  • Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
  • Consultants and Advisors: Deliver precise valuation insights to clients considering investments in Northwest Pipe Company (NWPX).
  • Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling related to the industry.
  • Industry Analysts: Gain insights into how companies like Northwest Pipe Company (NWPX) are assessed in the market.

What the Template Contains

  • Operating and Balance Sheet Data: Pre-filled Northwest Pipe Company (NWPX) 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 Northwest Pipe Company (NWPX).
  • Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.

No products were found matching.