DCF Model for Food & Beverage

I need a fully-linked Discounted Cash Flow valuation built from scratch for a consumer-goods company in the Food & Beverage segment, using mid-sized regional peers as the main benchmark. The workbook has to stand up to an investment-committee review, so every assumption must be clearly documented and every calculation auditable.

The model should open with a dedicated Assumptions tab where revenue drivers, cost lines, working-capital turns and capex intensity are laid out transparently. From there, flow through to:

• A revenue build-up that captures unit growth, pricing, and mix
• Operating expense projections translating into margin profiles
• Unlevered free cash-flow schedules (EBIT → NOPAT → FCF)
• A WACC build showing cost of equity, cost of debt and target capital structure
• Two terminal value approaches (perpetuity growth and exit multiple)
• Sensitivity tables contrasting WACC versus terminal growth or other key drivers
• Scenario sheets for base, bull and bear outlooks that cascade through the model

Excel or Google Sheets is fine, but formulas must remain live—no hard-coded end numbers. Keep naming conventions consistent, avoid circular references, and flag any iterative settings required.

Deliverables
1. The complete spreadsheet, cleanly formatted, with colour-coded input cells and cell-traceable logic
2. A one-page summary tab that rolls up valuation outputs (range and implied multiples)
3. A brief memo (PDF or Word) outlining major assumptions, peer benchmarks and methodology choices

Acceptance criteria: if I can change a single top-line growth input and the entire model updates without errors, the task is successful.

Your background in corporate finance, equity research or investment banking, and prior DCF work, will be key to meeting these standards. Feel free to share a redacted sample when you reply so I can gauge formatting and depth.