PIR/PUR Sandwich Panel Plant Financial Model

Description

A comprehensive financial model for a continuous PIR/PUR sandwich panel production facility, covering wall, roof, and cold-storage panels. The logic is built around the double-belt press line — the core of capex and opex — simulating output in square meters under varying thickness, density, and facing combinations. The model moves from a detailed shift-based production program to raw material consumption per SKU, capturing the chemical and physical relationships that define material costs: isocyanate/polyol ratios, pentane/blowing agent dosage, and metal coil yield.

Every hour of the line's operation is parameterized through Overall Equipment Effectiveness, scheduled maintenance shutdowns, and changeover losses when switching panel thickness, type, or steel color. This directly influences realistic achievable capacity, not just nameplate speed. The model also accounts for foam overfill, start-up waste, facing off-cuts, and scrap recovery — revenue from metal scrap is automatically calculated, showing the net material cost per square meter.

On the cost side, energy consumption is tied to line speed, press temperature profiles, and foaming exotherm, with separate models for electricity, thermal oil heating, and cooling water. Direct and indirect staffing follows a shift roster matching the production schedule, with automatic calculation of social charges and overtime. The model builds a complete procurement budget for bulk chemicals (delivered in isotanks or drums), steel coils, and packaging, incorporating inventory norms and supplier payment terms.

The financial backbone includes phased capital expenditure with equipment installation schedules, construction, and initial working capital injection. Revenue is constructed from multi-year sales contracts with seasonal price indices, volume discounts, and export vs. domestic mix. A dynamic working capital model, tax shield on depreciation of high-value line equipment, and debt sculpting with principal grace periods ensure the investment case is evaluated with the full cash-flow waterfall.

Modeling specifics

• Foam density-driven raw-material calculator — consumption of MDI, polyol, and blowing agent is computed per m² based on exact density and panel thickness, not flat norms
• Line speed and OEE model with thickness-dependent throughput — takes into account that thicker panels slow down the line, and changeovers between SKUs consume productive time
• Metal facing yield including coil width utilization, splice loss, and off-cut recovery — scrap revenue is netted against material cost
• Energy intensity tied to process parameters — electricity for drives and mixing head, thermal oil for press platens, cooling for shaping; usage changes with speed and foam formulation
• Shift calendar and dynamic crew sizing — indirect labour (maintenance, QC, warehouse) scales with output, not just fixed-headcount assumptions
• Inventory build-up for construction seasonality — the model allows pre-production of panels during low-demand periods to meet summer peaks, with warehousing costs and working capital impact
• Detailed fixed-asset register with tax and book depreciation — separate treatment of line equipment (accelerated), building, and auxiliary assets, including investment incentives if applicable
• Currencies and hedging logic for imported raw materials — MDI and polyol often priced in EUR/USD, with the model reflecting FX pass-through into COGS

What's included in the base version

• Annual and monthly production plan with panel types, thicknesses, densities, and facings
• Raw-material consumption calculator (PUR/PIR chemicals, steel/aluminum coils, packaging)
• Procurement budget with inventory norms and payment terms for isotank/coil deliveries
• Direct and indirect staffing model by shift, including wages, social taxes, and overtime
• Operational cost blocks: energy (electricity, thermal oil, cooling), maintenance, quality control, logistics
• Capital expenditure schedule: production line, auxiliary equipment, civil works, installation, startup expenses
• Financing structure: equity, senior debt with grace period, leasing instruments if applicable
• Revenue model with sales contracts, price indexation, volume tiers, and seasonal profiles
• Profit & Loss, Cash Flow Statement, Balance Sheet, and Investment KPIs (NPV, IRR, payback period)
• Sensitivity tables for key drivers: capacity utilization, MDI price, selling price, FX rate

Common modeling mistakes

• Applying a single raw-material cost per m² ignoring foam density and thickness — margin error of 8–15% on high-density cold-store panels
• Assuming nameplate line speed without OEE and changeover downtime — annual capacity overstated by up to 25% in multi-thickness production
• Treating metal facing yield as 100% — scrap and off-cut losses underestimate coil costs by 10–20%, missing scrap revenue entirely
• Ignoring chemical blow-out and foam start-up waste — raw material consumption understated by 5–10%, especially after line stops
• Fixed indirect labour regardless of output — over‑ or underestimation of staffing costs that does not capture real elasticity
• Building annual revenue without seasonal construction cycles — working capital and storage costs miscalculated, leading to over-optimistic payback periods