Non-ferrous Metal Foundry Financial Model

Description

This financial model is built specifically for non-ferrous foundries casting aluminum, copper, zinc, or magnesium alloys. It maps the full production chain from raw material intake—differentiating between primary ingots, master alloys, and inbound scrap—through melting, degassing, die/sand/permanent mold casting, fettling, heat treatment, and CNC machining. The revenue engine supports multiple customer product specifications, allowing you to model complex tolling contracts alongside own-product sales.

Unlike generic manufacturing templates, the model captures the metallurgy-specific cost drivers: metal melt losses (dross, slag, oxidation), alloy-specific energy consumption per ton, and refractory and crucible wear. An integrated scrap loop automatically credits internally generated returns and purchased scrap at market-adjusted prices, reflecting real-world operational savings that can make or break margins.

The CapEx schedule covers melting and holding furnaces, casting machines, spectrometers, pollution control systems (baghouses, scrubbers), and ancillary equipment, with forced maintenance reserves for relining cycles. Operational expenditure includes a shift-based staffing model that respects foundry shift patterns, environmental levies, and quality lab costs, giving you a complete picture of cash outflows.

Finally, the model accounts for fluctuating LME metal prices and alloy surcharges by incorporating a price feed mechanism and sensitivity tables. It is designed to stress-test scenarios like energy price spikes, changes in scrap availability, and new customer ramp-ups, ensuring you understand the full volatility of the non-ferrous foundry business.

Modeling specifics

• Alloy-specific material balance with dross and oxidation loss rates per metal grade, distinguishing between borax-treated and untreated melts.
• Furnace energy engine that models electricity and natural gas consumption by holding time, melt rate, and batch size, including cold-start penalties.
• Scrap utilization logic with quality tiers: clean in-house returns, process scrap with contamination, and market-purchased scrap, each priced against LME.
• Multi-stage production routing: melting → degassing (rotary or tablet) → casting method selection (gravity die, HPDC, sand) → fettling/finishing → heat treatment (T6/T7) → machining.
• Tolling vs. own-product revenue split with automatic calculation of customer-supplied metal credit and conversion fee.
• Integrated maintenance reserve scheduler coupling furnace relining, crucible replacement, and pump rebuild to both calendar time and melt cycles.
• Shift-based workforce costing that captures grade multipliers for night shifts, and semi-automated casting lines operator requirements.
• Environmental compliance cost block that accumulates baghouse media replacement, slag disposal fees, and potential carbon emission surcharges by production volume.

What's included in the base version

• Multi-product revenue model with price book per alloy and casting process
• Raw material cost module with LME-linked metal prices and scrap discount curve
• Alloy recipe builder with material loss coefficients
• Energy and utility consumption calculator tied to production schedule
• Detailed fixed asset register with CapEx phasing and depreciation
• Staffing plan with role-based salaries, shift premiums, and headcount drivers
• Operational cost blocks: consumables, quality lab, maintenance, environmental fees
• Monthly 3-statement model (P&L, balance sheet, cash flow) over 10 years
• Debt and equity financing waterfall with principal and interest schedules
• NPV, IRR, payback, and breakeven computations
• One-way and two-way sensitivity tables on key input variables
• Executive dashboard with charts and KPI summary

Common modeling mistakes

• Assuming a constant melt yield regardless of scrap quality — actual dross rates can add 3–8% to material cost per batch, severely underestimating total metal input.
• Applying a flat energy rate per ton across all alloys — high-silicon aluminum or copper alloys require 20–30% more energy, inflating utility costs.
• Ignoring furnace relining downtime and the associated production dip — can overstate annual output by 5–10% and understate CapEx reserves.
• Treating all laborers as a single cost per shift — foundry premium for night shifts and hazardous work increases hourly costs by 25–40%, shrinking EBITDA margins.
• Modeling scrap credit at LME spot without a quality discount — internal foundry returns often trade at 10–15% below LME, so revenue is overstated.
• Forgetting maintenance reserve buildup for pollution control equipment — sudden baghouse failure can wipe out 2–3 months of free cash flow.