Polyurethane System Plant Financial Model

Description

This financial model is built for a polyurethane system house — a facility that designs and batch-produces formulated systems for rigid foam, flexible foam, and CASE (coatings, adhesives, sealants, elastomers) applications. The plant typically houses multiple reactor trains, bulk storage for polyols, isocyanates and additives, a filling and packaging line, and an on-site quality laboratory. The model covers the entire investment phase, from reactor and tank installation through to process commissioning, with full capex phasing and automatic asset depreciation by class.

The core of the model is a recipe-driven cost and operations engine. Each product family carries its own bill of materials, with raw material consumption calculated per batch and dynamically linked to a price-indexed raw material database. Batch cycle times are modeled with heating/cooling curves, reactor occupancy logic, and mandatory cleaning between incompatible grades — eliminating the capacity overestimation common in generic templates. The structure handles both in-house formulated production and third-party toll blending, allocating capacity and resources accordingly.

Revenue streams are built bottom-up from a sales plan across multiple regions and product families, with differentiated credit terms and margin profiles. Working capital is shaped by raw material tank inventory policies, prepayments for critical feedstocks, and customer payment terms. The model also integrates environmental compliance costs, energy and utility consumption by reactor line, and scenario management that stress-tests raw material shocks, volume ramp-up delays, and capacity expansion options. The result is a transparent, operationally faithful model that mirrors the commercial and technical complexity of a real system house.

Modeling specifics

• Multi-grade recipe matrix with auto-calculation of raw material uptake and variable cost per kg — every product code has its own BOM, linked to live raw material price indices.
• Batch production scheduler with reactor occupancy constraints, heating/cooling profiles, and grade-dependent changeover cleaning — avoids systematic overstatement of effective capacity.
• Dual revenue streams for own-system sales and toll blending — toll jobs occupy the same reactor fleet but follow a completely different P&L logic (customer-supplied materials, service fee, yield accountability).
• Raw material indexation engine that links polyol, MDI/TDI, catalyst and additive prices to benchmark indices, with the ability to freeze, lag or cap price changes — integral for margin-at-risk analysis.
• Working capital model driven by bulk tank stock-days, drummed inventory, prepayment requirements on imported feedstocks, and receivable terms broken down by customer segment — reflects the genuine cash cycle of a system house.
• Environmental cost block covering VOC emission abatement, waste treatment, and permitting — capex and opex are sized according to production throughput and local regulation tiers.
• Phased capex module with multiple reactor trains, storage expansions, and supporting infrastructure — each asset is tracked through construction, commissioning, and depreciation start, enabling accurate return calculations.

What's included in the base version

• Demand and sales forecast by product family (Rigid, Flexible, CASE) and region
• Production plan with batch-cycle optimizer and reactor load schedule
• Raw material procurement and tank inventory management linked to recipes
• Direct labor, indirect labor, and shift-based staffing model
• Utilities, energy consumption and process consumables
• Maintenance, quality assurance, and technical service expenses
• General & administrative expense build-up, including regulatory and compliance overheads
• Capex schedule with equipment, civil works, installation and commissioning
• Debt and equity financing structure with flexible drawdowns and repayment
• Integrated financial statements (P&L, cash flow, balance sheet) on monthly basis
• Investment metrics: IRR, NPV, payback, DSCR, and equity return
• Sensitivity and scenario manager with key value drivers
• Interactive dashboard with KPI summary and operational levers

Common modeling mistakes

• Using a single average formula yield instead of grade-specific bills of material — raw material cost can be understated by 10–20% and product margins become distorted across the portfolio.
• Ignoring mandatory changeover and cleaning downtime between incompatible chemistry families — effective capacity is inflated by 15–25%, delaying expected project payback.
• Treating bulk raw materials as instantly available without tank storage constraints — underrepresents working capital needs by up to 30%, leading to cash shortfalls during ramp-up.
• Modelling MDI, polyol and additive prices as constant or with a flat inflation rate — when margins are already thin, an unhedged 5–10% indexation shock can erase profitability of niche grades.