| DISCOUNTED CASH FLOW VALUATION MODEL | ||||||
| Manufacturing / Industrial Template | ||||||
| Model Information | ||||||
| Company Name | [Enter Company Name] | |||||
| Ticker / Identifier | [Enter Ticker] | |||||
| Industry | Manufacturing / Industrial | |||||
| Valuation Date | 2/12/2026 | |||||
| Currency | USD ($mm) | |||||
| Analyst | [Enter Analyst Name] | |||||
| Key Valuation Output | ||||||
| Low | Base | High | ||||
| Enterprise Value ($mm) | 2,503 | 3,348 | 5,186 | |||
| (-) Net Debt ($mm) | -380 | -380 | -380 | |||
| Equity Value ($mm) | 2,123 | 2,968 | 4,806 | |||
| Shares Outstanding (mm) | 100.0 | 100.0 | 100.0 | |||
| Implied Share Price ($) | $21.23 | $29.68 | $48.06 | |||
| Key Assumptions Summary | ||||||
| WACC | 10.6% | |||||
| Terminal Growth Rate | 2.5% | |||||
| Exit EV/EBITDA Multiple | 8.0x | |||||
| Revenue CAGR (5-Year) | 5.0% | |||||
| Terminal Year EBITDA Margin | 20.0% | |||||
| Sheet Navigation | ||||||
| Assumptions | All model inputs and key assumptions | |||||
| Historical Financials | 3-year historical financial data | |||||
| Income Statement | 5-year projected income statement | |||||
| Balance Sheet | 5-year projected balance sheet | |||||
| Cash Flow Statement | 5-year projected cash flow statement | |||||
| Working Capital | Net working capital schedule | |||||
| Depreciation & Capex | PP&E roll-forward and capex schedule | |||||
| WACC | Weighted average cost of capital | |||||
| DCF Valuation | DCF valuation and equity bridge | |||||
| Sensitivity Analysis | WACC and growth rate sensitivity tables | |||||
| Football Field | Valuation range visualization | |||||
| Error Check | Model integrity and balance checks | |||||
| Note: All values are sample/placeholder data for template purposes. Replace with actual company data before use. | ||||||
| Model Date: February 12, 2026 | ||||||