Abattoir 5-Year Financial Model

I’m preparing an investment deck for a new abattoir and integrated supply-chain venture and I need a polished, investor-ready financial model that can stand up to due diligence. The model has to cover a full 5-year horizon and highlight profit-margin performance above all else, while still flowing logically from throughput assumptions to revenue, costs and cash flow.

You’ll be working with high-level operating data I already have— slaughter capacity, yield percentages, by-product recovery rates and preliminary capex/opex estimates— and turning these into a dynamic Excel or Google Sheets workbook that lets me tweak key drivers and instantly see the impact on margins.

Please make the structure intuitive for non-finance stakeholders: a clean assumptions page feeding automated financial statements, clear ratio analysis and a concise summary tab I can drop straight into PowerPoint. Built-in scenarios (base, optimistic, downside) and sensitivity toggles on volumes and price movements will be essential for the investor discussion.

Deliverables
• Editable 5-year financial model (Excel or Sheets) with linked assumptions
• Integrated P&L, cash-flow and balance-sheet outputs
• Profit-margin analysis dashboard plus scenario and sensitivity toggles
• Brief handover call or screen-walk so I’m comfortable navigating the file

Acceptance criteria
The model must reconcile, update error-free when assumptions change, and clearly surface gross and net margins in each scenario.