Vineyard & Winery Model

Operating Businesses Financial Model (Free Excel Download)

Model vineyard operations through planted acreage, yield, grape pricing, wine production, aging inventory, tasting-room sales, labor, capex, and seasonal cash flow.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

A vineyard and winery has to balance land, harvests, inventory, brand positioning, and hospitality. This model brings those pieces together, from the number of cases produced to wholesale sales, tasting-room income, and wine-club revenue.

Use it to plan expansion, test changes in pricing and product mix, or value a winery business. It is designed to make the link between production choices and financial performance easy to follow.

What every model includes

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

What's inside the Vineyard & Winery Model

  • Estate inputs: Year-1 estates, new estates per year, cases per estate, winemakers per estate, average case price
  • Utilisation: Year-1 yield utilisation with an annual ramp and a practical ceiling
  • Price indices and gross margins: per-tier price index off the average case price and a gross margin (the production spread)
  • Tasting room and wine club: tastings per estate, average tasting spend, wine club income per case, price escalation
  • Cost structure: winemaker comp, cellar crew per estate and wage, benefits, wage growth; winery facilities, marketing and trade, technology, and corporate SG&A as % of gross profit; depreciation (% of revenue); tax
  • Capital and working capital: maintenance capex %, acquisition cost per estate, NWC % of revenue growth, base-year revenue
  • Valuation: WACC, terminal growth, net debt, shares outstanding
  • Estate roll-forward (opening + new acquisitions = closing) with per-estate winemaker and cellar headcount

Vineyard Financial Model: Wine Estate Operating Model and Valuation

This vineyard financial model template offers a detailed 7-year operating and unlevered DCF for a multi-estate vineyard and winery group. It integrates estate roll-forwards, vintage-aware yield utilisation, tier-based wine revenue, DTC channels, and a winery P&L with a DCF valuation, helping users evaluate production, pricing, and expansion strategies in plain English.

Operating Drivers: Estate Growth and Vintage Utilisation

The model begins with a simple estate roll-forward: opening estates plus new acquisitions equals closing estates. Each estate's productive capacity is built from acres per estate multiplied by yield per acre, giving cases per estate at full maturity.

  • The key twist is that utilisation is cohort-specific. The founding Y1 estate base follows a steady ramp from an initial utilisation rate to a practical ceiling, while each year's newly acquired estates enter at a lower utilisation and ramp up over a defined number of vintage years.
  • This vintage-aware approach recognises that a newly acquired estate needs time for integration, replanting, or adoption of group practices. Total wine cases are the sum of founding-estate cases and new-estate cases, with the latter derived by summing the age-utilisation curve across all cohorts present in a given year.

Revenue Build: Tier Mix, Tasting Room, and Wine Club

Revenue is constructed in tiers: reserve and icon, premium, value and table, and sparkling and rose. For each tier, wine cases are multiplied by tier share, average case price, a price index, and an escalation factor.

  • Because the same harvest can be bottled into different tiers, the blended revenue per case shifts with the mix; a higher share of value tier compresses average revenue even if production volumes are stable. Additional revenue comes from cellar-door tasting rooms (closing estates times tastings per estate times average tasting spend) and a direct-to-consumer wine club (wine cases times club income per case).
  • Both are high-margin channels that bypass distributor margins, contributing to a high blended gross margin.

Cost Structure and Profitability Flow

Grape and production cost is derived as tier revenue times one minus the tier gross margin, reflecting the real product cost for fruit, oak, glass, and dry goods.

  • Winemaking and cellar/vineyard labour are headcount-driven: full-time equivalents per estate times wage, loaded for benefits and escalated by wage growth.
  • Overhead items—winery facilities and barrels, marketing and trade, technology, and corporate SG&A—are set as a percentage of gross profit, not revenue, because wine is a high-gross-margin business and gross profit better reflects operating scale.
  • This structure allows EBITDA margin to expand modestly as utilisation and price escalation lift gross profit while per-estate labour grows only with headcount and wage inflation.

Cash Flow and DCF Valuation with Terminal Base

Unlevered free cash flow is NOPAT plus depreciation, less maintenance capex and estate acquisition capex, less the change in working capital. Working capital is a genuine cash call because wine ages in barrel and bottle for one to three years.

  • For terminal value, the model uses a separate steady-state FCF base rather than Y7's explicit UFCF, because Y7 still includes acquisition capex from the roll-up. The terminal base adds back depreciation, subtracts only maintenance capex, and sizes the change in NWC off terminal growth.
  • The DCF sums the present value of explicit UFCF and a Gordon-growth terminal value to enterprise value, then subtracts net debt for equity value and value per share. The model also outputs an implied EV/EBITDA multiple.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Formatted to IB standards

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Frequently asked

What is a vineyard model?+

A vineyard model captures the seven-year operating economics and intrinsic value of a multi-estate vineyard and winery group (planted estates plus cellar-door hospitality and a direct-to-consumer wine club). It rolls an estate count forward, seasons newly acquired estates with a yield-utilisation ramp, splits wine cases across a reserve-and-icon, premium, value-and-table, and sparkling-and-rose mix priced off a blended average case price and a per-tier price index, layers tasting-room and wine club income, nets grape and production cost into gross profit, runs the cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.

Why does the tier mix matter so much?+

Because the same harvest can be bottled as a higher-ticket reserve wine or a far lower-ticket value bottling, and as the value tier gains share secularly the average revenue per case falls even when production volumes hold. The blended revenue per case is therefore the key yield metric, and the model carries per-tier price indices and gross margins as explicit inputs so an analyst can stress the luxury-to-value balance and watch revenue, gross profit, and the EBITDA margin move.

How is vineyard revenue built?+

Revenue starts with volume: total wine cases equal closing estates times cases per estate, where cases per estate equal mature yield times a utilisation factor that ramps over time. Wholesale wine revenue is then the sum across tiers of wine cases times each tier share times the average case price times its price index, escalated at a step-up rate. Cellar-door tasting-room and hospitality and per-case direct-to-consumer wine club income layer on top to total revenue.

Why an unlevered DCF for a winery?+

Wine is branded and land-backed but discretionary, and the bulk of estate growth is bought rather than built while the cellar ties up cash, so acquisition capex and the change in working capital are the dominant calls on cash and EBITDA overstates free cash flow in expansion years. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less maintenance and acquisition capex, less the change in working capital, and discounts it at a WACC with a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input.

Can I model a single estate or a DTC-only winery?+

Yes. For a single estate, set the group to one estate and size the cases per estate, tier mix, and headcount to that property; for a direct-to-consumer-led winery, lift the tastings per estate, average tasting spend, and wine club income per case and let the wholesale tier lines run light. The net-debt line already bridges enterprise value to equity value, so a financing layer slots in cleanly.

What is the utilisation ramp and why does it matter?+

Each estate produces a mature number of wine cases set by its planted acreage and yield, but newly acquired estates and freshly planted blocks take three to four years to reach full bearing. The model captures this through a utilisation factor that starts at the Y1 input, rises by a fixed number of percentage points per year, and is capped at a practical ceiling. Total wine cases produced is the single most important volume driver in the model, so the pace of the utilisation ramp determines how quickly acquired estates convert into sellable wine.

How does the four-tier revenue build work?+

Wine revenue is computed tier by tier: total wine cases multiplied by each tier share, then by the average case price, then by that tier price index, escalated at the annual price step-up. A reserve or icon bottling carries a price index well above one; a value table wine sits far below it. The blended revenue per case falls out of the arithmetic, which means it compresses when the value tier share rises even if production volumes are flat.

Why is overhead set as a percent of gross profit rather than revenue?+

Wine is a high-gross-margin business where the true operating scale is gross profit. A percent-of-revenue overhead would understate the cost of running cellars, barrel programmes, and a trade-marketing and distribution effort. Using gross profit as the base keeps overhead ratios stable as the tier mix and utilisation ramp shift the gross margin line, and it reflects how wine businesses actually budget their overhead programmes.

How is working capital treated in the FCF bridge?+

Working capital is modelled as NWC percent of revenue growth rather than a static plug. Wine is held in barrel for twelve to thirty-six months and in bottle for additional time before sale, so a growing book ties up inventory cash at a meaningful fraction of incremental revenue. The FCF bridge deducts the change in working capital so the unlevered free cash flow reflects the genuine cash conversion profile of a winery group in growth mode, not an idealised one.

What is the difference between maintenance capex and acquisition capex?+

Maintenance capex covers routine capital spending on existing winery plant, cellar equipment, and vineyard infrastructure and is set as a percent of revenue. Acquisition capex is the deal value of the year new estates (new estates multiplied by the per-estate acquisition cost) and reflects the cash outflow funding the estate pipeline. Both are deducted in the FCF bridge, so the DCF enterprise value represents the value of the group inclusive of the growth capital required to reach the terminal-year scale.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview