Revenue and Monthly Calc
Edit guest visits, service days, items per guest, sales mix, and net prices. Calc projects monthly revenue across five streams.
Editable Wine Tasting Room Financial Model in Excel
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
Wine Tasting Room Financial Model is an Excel planning template for an independent tasting room selling guided wine flights, individual glasses, take-home bottles, and charcuterie. It converts guest traffic, prices, costs, and staffing into financial projections.
The illustrative case covers a leased 1,800-square-foot venue in Charlottesville, Virginia, with a January 2026 launch and forecasts through 2030. Wine is purchased rather than produced; customers pay at service, and the case excludes memberships, shipping, sales tax, and voluntary tips.
- Forecast
- 5years, 2026 to 2030
- Revenue categories
- 5distinct menu items
- Service days
- 26per month
- Opening reserve
- 3months of cash outflows
WORKBOOK STRUCTURE
An Integrated Operating and Financial Workbook
The workbook links tasting-room assumptions to planning reports.
COGS & OPEX and Payroll
Keep purchase costs, variable costs, overhead, and payroll separate. Staffing includes the owner-manager, hosts, and part-time food support.
Dashboard and Scenarios
Review KPIs and apply Low, Base, or High revenue and expense multipliers. Debt controls are included, although this case assumes no external financing.
Financial Statements and Checks
IS, CF, BS, and Summary provide linked reports; Checks flags reconciliation issues. Supplied figures establish results only through EBITDA.
CAPEX, Funding, and Returns
CAPEX schedules startup assets; Sources & Uses reviews funding allocations. Returns evaluates break-even, payback, and ROIC separately.
REVENUE PLANNING
How Guest Visits Become Wine Tasting Sales
Revenue is driven by service-day guest visits multiplied by paid items per guest, allocated across five menu categories.
For 2026, the case uses 40 guest visits per service day, 26 service days each month, and 1.5 purchased menu positions per guest. Traffic increases to 62 visits per day by 2030, while the 26-day calendar and purchase frequency remain unchanged.
Each purchased item is assigned once: 30% classic flights, 15% reserve flights, 20% wine by the glass, 20% take-home bottles, and 15% charcuterie. The weighted price is $26 per menu position, equivalent to $39 in modeled sales per guest.
Revenue Forecast
The Revenue Forecast converts guest visits, items per guest, menu shares, and prices into monthly and annual sales for flights, glasses, bottles, and charcuterie.
Illustrative 2026 revenue calculation
40 guests/day × 26 days/month × 1.5 items/guest × $26/item × 12 months = $486,720 in 2026 revenue.
| Category | Menu share | Net price | 2026 revenue |
|---|---|---|---|
| Classic wine flights | 30% | $25 | $140,400 |
| Reserve wine flights | 15% | $40 | $112,320 |
| Wine by the glass | 20% | $14 | $52,416 |
| Take-home wine bottles | 20% | $32 | $119,808 |
| Charcuterie boards | 15% | $22 | $61,776 |
Shares apply to individual purchased items, not to separate guest pools. These five rows total $486,720.
Change the traffic, menu shares, purchase frequency, or selling prices to test a different trading plan. The source scenario assumes no material monthly seasonality and activates the full selected January launch month.
COST STRUCTURE
How Wine Costs and Staffing Affect EBITDA
Direct costs, sales-linked costs, overhead, and payroll are calculated separately.
Direct costs total 29% of revenue: purchased wine and shrinkage at 23%, charcuterie ingredients at 5%, and service consumables at 1%. Payment processing adds 3% of sales, while sales-linked promotions add 1.5% as variable operating expenses.
COGS and Operating Expenses
The COGS and Operating Expenses forecast separates wine and food costs from processing fees, promotions, and fixed bills to show their impact on margins.
Annual fixed costs of $96,000 include a $4,000 monthly lease plus utilities, insurance, software, administration, cleaning, maintenance, compliance, and marketing. They remain flat in the case.
Payroll Forecast by Staff Role
The Payroll Forecast calculates base pay by staffing FTE: one $65,000 owner-manager, two $38,000 hosts, and a half-time assistant at a $36,000 full-time rate.
OPENING BUDGET
Separate Opening Investment From Operating Earnings
Startup assets, preopening spending, inventory, and the initial cash reserve are funded separately from annual EBITDA.
The $101,000 startup asset budget covers improvements, wine preservation, furnishings, food equipment, and POS/security hardware. These purchases are separate from operating EBITDA.
Capital Expenditure Plan
The Capital Expenditure Plan schedules fit-out and equipment purchases and tracks depreciation, distinct from recurring inventory and operating expenses.
Opening funding also covers $35,000 in preopening spending, $11,601 in stock, and a $104,513 three-month operating reserve. Total initial owner funding is $252,114.
Sources and Uses of Funds
The Sources and Uses of Funds report matches funding to spending and cash retention, distinguishing opening contributions from subsequent operating cash movements.
PROJECTED PERFORMANCE
Five-Year Revenue, Expenses, and EBITDA Forecast
The Base case increases annual guest traffic while retaining flat nominal prices, operating cost ratios, overhead, and base salaries.
| Year | Revenue | Operating expenses | EBITDA |
|---|---|---|---|
| 2026 | $486,720 | $418,051 | $68,669 |
| 2027 | $584,064 | $450,661 | $133,403 |
| 2028 | $657,072 | $475,119 | $181,953 |
| 2029 | $705,744 | $491,424 | $214,320 |
| 2030 | $754,416 | $507,729 | $246,687 |
Forecast figures are illustrative, not historical results; figures are rounded to whole dollars.
In 2026, $486,720 of revenue covers $141,149 in COGS, $21,902 in variable costs, $96,000 in overhead, and $159,000 in payroll, leaving $68,669 EBITDA.
By 2030, assumed traffic growth produces $754,416 in revenue and $246,687 in EBITDA. These figures are forecasts, not observed performance.
Projected Income Statement
The Projected Income Statement covers revenue, expenses, EBITDA, depreciation, interest, tax, and net profit. This example documents figures only through EBITDA.
EBITDA is not accounting net income and does not represent cash left in the bank. Depreciation, financing, taxation, investment spending, and movements in working capital require separate review.
Cash Flow Forecast
The Cash Flow Forecast separates operations, investment, financing, and closing cash. Use it with the Balance Sheet to evaluate liquidity.
INVESTMENT DECISIONS
Evaluate Break-Even, Payback, and Scenario Risk
Returns and sensitivity reports help evaluate viability without confusing operating earnings with capital recovery.
Sales break-even identifies revenue needed to cover operating costs. Cash break-even considers cash coverage, while investment payback measures the recovery of invested funds.
Break-Even, Payback and ROIC
The Returns analysis distinguishes break-even, project cash flow, investment payback, and annual ROIC. The example does not establish a payback date or ROIC value.
Use Dashboard Low, Base, and High multipliers to examine how a slower visit ramp, higher wine purchasing costs, or changes in fixed expenses and payroll affect the operating forecast. Scenario settings are adjustable controls, not evidence of tested cash sufficiency.
Financial Scenario Analysis
The Financial Scenario Analysis compares revenue, margins, and EBITDA under Low, Base, and High assumptions; alternative-case figures are not supplied.
PRACTICAL APPLICATION
Who This Tasting Room Model Fits
The workbook is suited to planning a purchased-wine hospitality venue with several point-of-sale product categories.
Edit rent, staffing, purchase ratios, flight pricing, bottle mix, and guest visits to test business plans. Inputs are estimates, not verified Charlottesville benchmarks.
Vineyards, wine production, subscriptions, and shipping require different drivers. This example assumes no committed loan and provides no financing approval.
FREQUENTLY ASKED QUESTIONS
Questions About the Wine Tasting Room Model
These answers explain the specific scope, calculation method, and reporting boundaries of the example.
Can I change wine prices and product mix?
Yes. The Revenue inputs use editable prices and purchased-item shares for classic flights, reserve flights, glasses, take-home bottles, and charcuterie.
How are guest visits translated into sales?
Monthly sales combine daily guest visits, service days, paid menu positions per guest, and the category mix multiplied by each item’s net price.
Is the owner-manager salary included?
Yes. The illustrated annual Payroll amount includes the paid owner-manager, two tasting hosts, and a half-time food prep and stock assistant.
Does the example include winery production?
No. This is a leased tasting-room business that purchases finished wine; it does not model growing grapes, wine production, memberships, or shipping.
Does EBITDA equal net profit or free cash flow?
No. EBITDA excludes depreciation, interest, taxes, and certain cash movements; review the Income Statement and Cash Flow reports for those separate measures.
Is the initial owner funding sufficient in every scenario?
Not necessarily. The $252,114 estimate includes a three-month operating reserve, but it has not been established as the maximum cash requirement.
Does the model calculate payback and break-even?
The Returns report supports break-even, project cash flow, investment payback, and annual ROIC analysis; the supplied illustrative case does not establish those resulting figures.
What Does the Wine Tasting Room Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Investor Clarity In One Place
The template laid out exactly what investors expect, so I stopped guessing at the structure. I had a clean model ready for my deck in a few hours.
Easy For Non-Excel Users
I’m not strong in advanced Excel, but this file kept the inputs simple and the formulas hidden where they should be. I finished my first draft without hiring help.
Scenario Planning Got Simple
Switching between low, base, and high cases used to eat up my time, but this template made it quick. I cut scenario updates from half a day to under an hour.