Financial Analysis of Northwest Pipe Co (NWPX)

Northwest Pipe Co is currently trading at $40.00 per share with the following key metrics:

Financial Strength

Profitability

Growth & Value Metrics

Performance Overview

YTD Return: 17.36% (vs S&P 500: 3.72%)
1-Year Return: 29.03% (vs S&P 500: 8.39%)
3-Year Return: 60.00% (vs S&P 500: 26.88%)
5-Year Return: 60.00% (vs S&P 500: 145.69%)

Northwest Pipe Co has demonstrated strong financial performance with substantial earnings growth. The company has consistently outperformed the S&P 500 in recent years, except for the 5-year timeframe. The company operates with healthy margins and reasonable valuation multiples.

Intrinsic Value Calculations

P/E Valuation

Inputs: EPS: $3.40 Median historical P/E: 14.93 (average of historical P/E values) Expected growth rate: 8.00% (estimated based on historical growth) Margin of Safety: 25.00% Conservative growth rate: 5.00% (lower estimate for prudence) Discount rate: 9.00% Calculations: Year 1: $3.57 ($3.40 × 1.05) Year 2: $3.75 ($3.57 × 1.05) Year 3: $3.94 ($3.75 × 1.05) Year 4: $4.13 ($3.94 × 1.05) Year 5: $4.34 ($4.13 × 1.05) Value in 5 years: $64.80 ($4.34 × 14.93) Present value: $42.10 ($64.80 ÷ (1.09)^5 × 0.75)

DCF Valuation

Inputs: Cash & Cash Equivalents: Estimated at $40,000,000 (based on Enterprise Value - Market Cap) Total Liabilities: Estimated at $235,000,000 (based on financial data) Free cash flow: $48,000,000 (approximated from operating income) Shares outstanding: 9,916,000 (from the financial data) Expected growth rate: 8.00% (estimated) Margin of Safety: 25.00% Conservative growth rate: 5.00% Growth decline rate: 5.00% Discount rate: 9.00% Year 10 FCF multiplier: 12 Calculations: Year 1: $50,400,000 ($48,000,000 × 1.05) Year 2: $52,920,000 ($50,400,000 × 1.05) Year 3: $55,566,000 ($52,920,000 × 1.05) Year 4: $58,344,300 ($55,566,000 × 1.05) Year 5: $61,261,515 ($58,344,300 × 1.05) Year 6: $64,324,591 ($61,261,515 × 1.05) Year 7: $67,540,820 ($64,324,591 × 1.05) Year 8: $70,917,861 ($67,540,820 × 1.05) Year 9: $74,463,754 ($70,917,861 × 1.05) Year 10: $78,186,942 ($74,463,754 × 1.05) Total NPV FCF: $410,564,824 Year 10 FCF value: $324,542,731 ($78,186,942 × 12 ÷ (1.09)^10) Cash & Equivalents: $40,000,000 Total Liabilities: $235,000,000 Company value: $405,080,666 (($410,564,824 + $324,542,731 + $40,000,000 - $235,000,000) × 0.75) Intrinsic value per share: $40.85 ($405,080,666 ÷ 9,916,000)

Conclusion

Based on these calculations, Northwest Pipe Co appears to be trading at around its intrinsic value. The P/E valuation suggests an intrinsic value of $42.10 per share, while the DCF model indicates a value of $40.85 per share. The current price of $40.00 is very close to these calculated values.

The company has demonstrated strong financial performance with solid revenue and earnings growth. Northwest Pipe has healthy profit margins and has been outperforming the market in recent years. The reasonable valuation multiples (P/E of 12.42, EV/EBITDA of 8.34) suggest that the stock is fairly valued at current levels.

Investors should consider the following:

Given the current trading price is very close to the calculated intrinsic value, the stock represents a fair investment opportunity for long-term investors, but offers limited margin of safety in the near term.