Acetylene Plant Financial Model

Description

The model covers a typical acetylene production facility using the calcium carbide wet process, generating acetylene gas for cylinder filling and bulk distribution. It captures the entire value chain from carbide receipt and storage through gas generation, purification, compression, and cylinder logistics. The scale can range from a single-reactor plant outputting several hundred cubic meters per hour to a multi-reactor mid-sized operation.

Production modeling accounts for varying carbide quality and moisture content, which directly affects yield and lime by-product quantity. The tool simultaneously tracks three revenue streams: acetylene sold in different cylinder sizes (by grade and pressure), bulk gas deliveries, and sale or disposal cost of slaked lime—a substantial co-product often overlooked. Seasonal demand patterns for welding and cutting gases are reflected in a monthly volume scheduler that drives reactor load and inventory buffers.

On the cost side, the model details fixed and variable utilities (electricity, water, steam), labor shifts tied to running hours, maintenance based on reactor operating hours, and the depreciation of returnable cylinders as a rental fleet asset. A substantial working capital module manages the lead time and safety stock of calcium carbide imports, ensuring cash flow timing correctly accounts for supplier payment terms and cylinder deposit flows.

Modeling specifics

• Calcium carbide-to-acetylene yield curve with a moisture correction factor, reflecting actual carbide quality and atmospheric absorption losses.
• Slaked lime co-product module: revenue from sale or disposal cost, volume automatically linked to reaction stoichiometry and lime purity.
• Multi-grade production: separate lines for dissolved acetylene (DA) and high-purity acetylene with distinct pricing, cylinder fleets, and compression requirements.
• Cylinder rental fleet mechanics: rental income calculated per cylinder per day, with user-defined rotation rates, loss/repair rates, and replacement capex.
• Reactor availability and maintenance: planned shutdowns and unplanned downtime modeled with probability distributions, impacting annual effective capacity.
• Energy consumption linked non-linearly to reactor load: a fixed base-load power draw plus an incremental kWh per m³, capturing part-load efficiency losses.
• Working capital for carbide feedstock: import lead time, safety stock, and payment terms (letter of credit, advance) with accurate cash timing.
• Regulatory safety capex: periodic statutory inspections, safety equipment replacement, and compliance upgrades as separate fixed cost blocks.

What's included in the base version

• Acetylene revenue model by cylinder size, grade, and bulk delivery with monthly volume scheduler
• Calcium carbide, acetone, and water consumption calculations
• Electricity, steam, and other utility cost modelling with load-dependent rates
• Direct and indirect labor schedule linked to shifts and reactor operating hours
• Reactor and auxiliary equipment maintenance cost blocks (routine and major overhauls)
• Cylinder rental revenue and replacement cost budget
• Slaked lime by-product revenue/disposal cost line
• Full financial statements (P&L, cash flow, balance sheet) with debt and equity structuring
• Investment schedule with phased construction, equipment installation, and start-up costs
• Working capital for carbide inventory, cylinder deposits, and payables/receivables
• Taxation module (corporate income tax, VAT/GST where applicable) and terminal value

Common modeling mistakes

• Overlooking lime by-product revenue or disposal cost — understates project free cash flow by 7–15%, since slaked lime mass is stoichiometrically tied to acetylene output.
• Using a constant annual acetylene price without seasonal premiums — overstates revenue in low-demand months and underestimates working capital needs, causing cash shortfalls of up to 20% of monthly turnover.
• Modeling cylinder rental income as a single fixed annual rate regardless of utilization — overstates asset turnover and understates capital tied up in idle cylinders by 15–25%.
• Ignoring reactor downtime for cleaning and mandatory safety inspections — overestimates annual acetylene output by 8–12%, making the investment case appear more attractive than it is.
• Applying constant electricity consumption per m³ across all loads — understates energy cost at part-load by 10–18% due to the high fixed power base of reactors and compressors.