Fish Meal and Fish Oil Plant Financial Model

Description

The model recreates a full-cycle industrial processing plant that converts pelagic fish, offal and trimmings into high-protein fish meal and crude fish oil. It captures the entire chain from raw material intake, through cooking, pressing, drying and oil separation, to evaporation of stickwater, final drying and meal cooling. Revenue is generated from two co-products — fish meal (protein-rich powder) and fish oil — each with its own pricing, yield and quality grade.

At the core of the model is a detailed mass-and-energy balance tied to the raw fish composition (water, fat, protein, ash) and freshness. This drives variable yields, steam and electricity consumption per metric ton, and gives a realistic picture of how catch quality directly affects plant economics. Seasonality of fishing campaigns is mirrored through adjustable monthly capacity utilization, inventory build-up and maintenance shutdowns, so you see working capital swings and the true cash profile of a campaign-based operation.

The financial model includes CAPEX phasing for processing lines, steam boiler, evaporators, oil polishing and auxiliary infrastructure. Operating expenses are broken down into raw material (fish, chemicals, packaging), energy (fuel for steam, electricity), labour, ongoing maintenance, and quality control. Debt financing is structured with flexible drawdowns, grace periods and repayment profiles. This is not a generic ‘manufacturing’ template: it is purpose-built for the fish meal/oil sector, where the interdependence of material flow, energy and seasonality makes standard models fail.

Modeling specifics

• Mass balance driven by proximate composition of raw material — fat, protein, water and ash content determine meal and oil output per ton, not a fixed yield assumption.
• Dynamic steam and electricity consumption linked to throughput, solids concentration in stickwater and number of evaporator effects, so energy costs scale non-linearly with plant load.
• Fish oil polishing circuit (centrifuge, washing, vacuum drying) integrated as a separate cost and quality node, with the ability to switch between crude and polished oil pricing.
• Stickwater evaporation with closed-loop condensate return reduces fresh water intake and wastewater volume, reflected in both opex and environmental compliance costs.
• Campaign-driven operational calendar: monthly capacity utilization factors, seasonal raw material availability, forced shutdowns for overhaul and maintenance, inventory accumulation for year-round sales of meal.
• Fish meal drying and cooling with recirculation of exhaust air for heat recovery — model captures the trade-off between capital investment and energy saving.
• Multiple revenue grades (standard meal, high-protein meal, oil) with independent pricing curves and the possibility of long-term offtake contracts vs. spot sales.

What's included in the base version

• Assumptions dashboard with all technical and market inputs (catch composition, plant capacity, prices, tariffs)
• Mass and energy balance block calculating yields, steam, electricity and water flows per month
• Revenue module for fish meal and fish oil with quality-dependent pricing and offtake mix
• Variable cost module (raw fish, chemicals, packaging materials, energy carriers)
• Fixed cost module (labour by shift, maintenance including annual turnaround, QC, admin, insurance)
• CAPEX schedule with construction phasing, equipment lists, spares and initial fill of consumables
• Debt financing with senior loan, balloon/amortizing, moratorium and multiple tranches
• Integrated financial statements (income statement, cash flow, balance sheet) on monthly basis
• Financial ratios (DSCR, LLCR, project IRR, equity IRR, payback, NPV)
• Scenario manager and sensitivity tables (raw material price, meal/oil prices, capacity utilization, energy cost)

Common modeling mistakes

• Ignoring the drop in meal yield and increase in energy demand when raw fish is stored too long — payback period overstated by 1.5–2 years.
• Using a flat monthly throughput without campaign-driven capacity utilization — working capital requirement understated by 20–35% due to missing inventory build-up.
• Treating steam and electricity as independent variables rather than coupling them through stickwater concentration — energy cost understated by 15–25%.
• Overlooking the effect of raw material fat content on oil separation efficiency and meal residual fat — oil revenue inflated by 10–18%, meal premium qualification lost.
• Omitting the water balance and assuming unlimited freshwater supply — water discharge costs and compliance capex underestimated, significantly inflating net cash flow in later years.