Aluminum Profile Plant Financial Model

Description

The model replicates a full-cycle aluminum profile production facility, from primary melting and billet casting through extrusion, aging, surface finishing, and packing. It captures the physical and financial flows of multiple parallel operations: hot-top or direct chill casting lines, several extrusion presses of different capacities, anodizing tanks, vertical/horizontal powder coating booths, and downstream fabrication steps. Each processing stage consumes utilities, generates process scrap with distinct recovery values, and imposes yield losses that compound across the route. This granularity allows you to test how product mix shifts—profiles with high surface-finishing demand versus simple mill-finish shapes—affect output volumes, material consumption, and plant-wide profitability.

Raw material management is central. The model handles both primary aluminum billets/logs purchased from external suppliers and the re-melting of internal scrap. Scrap streams are tracked by origin (extrusion butt, offcuts, anodizing racking, powder-coating hook scrap, finish-line rejects) and alloy grade, because the scrap buy-back price depends heavily on whether the scrap remains alloy-pure or becomes mixed. A closed-loop mass balance ensures that the scrap generated is either fed back into the casthouse or sold externally. The user sets batching logic, defining how much of each scrap type can be re-introduced into specific alloy recipes without degrading quality. This makes it possible to quantify the hidden cost of cross-contamination and the benefit of keeping high-alloy scrap pure.

Energy and consumable modeling is built around industry-standard consumption rates per metric ton processed, with breakdowns by process step. Natural gas for melting and aging ovens, electricity for extrusion presses, rectifiers, and compressors, water and chemicals for anodizing and caustic etching, and compressed air throughout the plant are all accounted for. Where seasonal tariff structures or peak-load penalties are common, the required building blocks are present but can be deepened via an optional energy module. Maintenance capex and major press revamp cycles are separated from initial capital investment, preventing the common mistake of treating press overhauls as one-off rather than recurring every 5–8 years.

The product-sales interface is built around a catalogue of profiles defined by alloy, hardness, cross-section complexity, length, and surface finish. Each SKU drives consumable uptake and production rate differently. Die changeover times, billet pre-heat temperatures, press speed, and puller settings are parameterized so that a hollow 6082-T6 profile with anodized finish and high precision demands more press time and has lower recovery than a simple solid 6060-T5 mill-finish bar. Pricing can follow LME-linked formulas with conversion margins and alloy surcharges, fixed-price contracts, or a mix. Multi-currency exposure is handled by separate input tabs for LME quotations, local currency exchange rates, and freight-to-customer logic.

The financial output is fully integrated: a three-statement model (P&L, balance sheet, cash flow), project financing with drawdown schedules, tax depreciation as per asset class (presses are long-life, consumable baths short-life), working capital driven by raw material and finished goods days, and dividend/distribution waterfall. All production volumes, scrap balances, and revenue lines feed automatically into the financial sheets, so a change in extrusion push-in speed or anodizing line utilization immediately ripples through to EBITDA and cash generation. The model is designed to let operators and finance teams jointly explore what a new product launch, a scrap management initiative, or a capacity de-bottlenecking really means for returns.

Modeling specifics

• Closed-loop scrap mass balance with alloy tagging, distinguishing extrusion butt scrap, anodizing rack scrap, powder-coating hook scrap, and finishing rejects, each with own buy-back price and re-melt eligibility criteria
• Billet casting block that models direct chill cast unit output by alloy, with cast losses, scalping losses, and cut length trim, linking directly to extrusion press demand
• Multi-press extrusion module where each press has its own speed curves, billet pre-heat temperature, butt thickness, and puller recovery, plus die changeover time and average die life
• Aging and cooling steps with separate energy consumption rates, distinguishing cycles for T5, T6, and T66 tempers, which affect throughput and gas usage
• Finishing-yield stacking: each surface treatment line (caustic etching, anodizing, powder coating) applies its own yield factor, and the model compresses them so that a product requiring multiple steps shows true cumulative recovery
• Energy intensity modelling per metric ton of output, split by electricity (presses, rectifiers, compressors) and natural gas (melting, homogenizing, aging), with optional time-of-use structures
• Chemical and water consumption per square meter of anodized/powder-coated profile, tied to bath replenishment rates and effluent treatment volumes
• LME-linked pricing engine for raw material and ingot surcharges, conversion margin over metal, multi-currency input, and the ability to hedge via contract mix (fixed vs. floating)
• Recurring maintenance capex schedule per press and finishing line, with major overhauls every 5–8 years, distinct from initial CAPEX, preventing long-term cost underestimation
• Product mix impact analysis: any change in surface finish mix or alloy mix recalculates overall plant yield, specific energy consumption, and scrap generation automatically
• Workforce planning by shift and line, linking direct labor costs to extruded tons and finishing square meters, with step-change staffing at volume thresholds
• Working capital driver based on raw material pipeline, WIP at each stage, finished goods days, and payable/receivable terms specific to billet suppliers and customer contracts

What's included in the base version

• Full three-statement financial model (P&L, balance sheet, cash flow) with monthly periods over project life
• Integrated production volume model: billet casting, extrusion, aging, anodizing, powder coating, packaging
• Dynamic scrap mass balance by scrap type and alloy, with internal reuse and external sale
• Extrusion press capacity calculation for up to three presses with press efficiency, shift patterns, die changes
• Finishing line capacity (anodizing tanks, powder coating booths) with racking density, coating thickness, line speed
• Raw material cost model: primary aluminum billets/logs, alloy surcharges, external primary and scrap pricing linked to LME
• Energy and consumable consumption: electricity per ton pressed/anodized, gas per ton melted and aged, chemicals per sqm finished
• Direct and indirect labor headcount driven by production volume with shift schedules
• Capital expenditure schedule with asset classes, tax depreciation, and salvage values
• Project financing module: senior debt/equity drawdowns, repayments, interest, covenants
• Working capital calculations: inventory days (raw material, WIP, finished goods), receivables, payables
• Executive dashboard with key KPIs, sensitivity tables, and scenario manager

Common modeling mistakes

• Treating all process scrap as homogeneous and applying a single buy-back price — underestimates raw material cost by 10–20% because mixed-alloy scrap sells at a discount
• Ignoring progressive yield loss across multiple finishing steps (etch, anodize, coat) — finished product output is overstated by 4–8%, overstating revenue
• Underestimating energy consumption for aging ovens and anodizing rectifiers by not separating temper- and thickness-dependent cycles — utility cost undervalued by 8–12%
• Omitting major maintenance capex and press overhauls from cash flow — overstates free cash flow in years 5–8 and understates by 15–25% in overhaul years
• Using a fixed conversion margin independent of profile complexity — revenue per ton is misestimated by 5–15% when product mix shifts to heavy-surface-finish or hollow shapes
• Failing to account for billet taper, butt thickness, and die-bearing length in extrusion recovery — overestimates saleable output by 2–4% and undercounts scrap generation