Utility Paraffin Candle Plant Financial Model

Description

The model is built for a utility paraffin candle plant producing everyday household, emergency and church candles. Because paraffin wax is a crude oil derivative, the financial logic embeds feedstock volatility as a core driver, rather than treating it as a fixed assumption. Multi-product, multi-shift manufacturing with shared melting and moulding lines forces explicit capacity allocation across several SKU families, each with its own recipe, yield and labour intensity.

Seasonal demand is captured through a monthly sales build-up and a target months-of-stock policy, which automatically triggers pre‑season production and inventory funding. This prevents the common mistake of assuming level output and reveals the true working capital peak. The plant’s thermodynamics are reflected in an energy model that links gas, electricity and water consumption to the volume of wax processed, ambient temperatures and shift patterns.

The financial structure separates the investment phase (process equipment, cooling tunnels, automatic packing lines, warehouse) from ramped-up operations, with capital expenditure shown in the order of several million dollars – the exact figure is illustrative but the logic of milestone payments, VAT recovery and asset depreciation mirrors real industrial projects. All major tax and local incentive assumptions are parameterised, making the model adapt to different jurisdictions without hard-coding.

Modeling specifics

• Multi-shift production calendar with hourly configuration per shift and automatic capacity utilisation calculation, including changeovers between candle types.
• Raw material cost model linking paraffin, stearin, wick and dye prices to an adjustable crude oil index, with scenario‑based surcharge mark‑ups.
• Monthly seasonal demand curve with safety-stock policy that drives pre‑builds, peak storage costs and the associated working capital swing.
• Recipe‑based costing for each product variant, allowing different wax blends, fragrance loads and wick diameters to change material cost and line speed.
• Energy consumption forecast built from thermal loads (wax melting, hot water, cooling), mechanical drives and building services, not from a simple % of revenue.
• Maintenance and downtime schedule that reduces nominal capacity by planned outages, plus a stochastic allowance for unscheduled line stops.
• Customer and supplier payment terms modelled individually, showing the cash gap between raw material prepayments and trade credit granted to wholesalers.
• Tax shield from accelerated depreciation and investment incentives, with a flag that allows the user to choose between straight‑line and declining‑balance methods.

What's included in the base version

• Production plan by product family and shift (monthly, 10‑year horizon)
• Raw material consumption and procurement schedule with lead times
• Staffing table by department and shift, with semi‑variable wage logic
• Capex schedule by asset class, with timing, VAT and depreciation waterfall
• Revenue forecast linked to price list, volume and customer mix
• Operating expense blocks (fixed, semi‑variable, maintenance, selling costs)
• Monthly P&L, cash flow statement and balance sheet
• Main investment indicators: NPV, IRR, payback, DSCR and break‑even utilisation

Common modeling mistakes

• Using a constant wax price over the projection period — gross margin is overstated by 8‑15% in years when oil prices spike.
• Ignoring the seasonal build‑up of finished goods inventory — working capital requirement is understated by 20‑30%, often causing a cash shortfall in the ramp‑up year.
• Assuming 100% nominal capacity without planned maintenance and changeover losses — annual output is overestimated by 7‑12%, leading to missed revenue forecasts and delayed debt service.
• Treating energy as a fixed cost or a simple % of revenue — operational leverage is distorted and break‑even points shift by 10‑18% of sales volume when utility prices change.
• Applying a single yield across all product variants — margin per SKU is misreported by 5‑10%, hiding loss‑making items that cross‑subsidise the core range.