Trusted by 25,000+ startup founders, investors and CPAs
Clear Assumptions In One Place
Megan Carter, NY
This template pulled pricing, costs, and growth into one clean sheet, so I stopped juggling scattered inputs. It saved me hours of rework and made the forecast much easier to explain.
Investor-Ready From The Start
Daniel Brooks, CA
I could see exactly which outputs mattered for our pitch, and the model gave me the right structure fast. That made our investor deck easier to build and got us a meeting booked sooner.
Easy Enough To Use Fast
Lauren Mitchell, TX
I’m not great with advanced Excel, so this template was a relief. The setup was straightforward, and I finished a five-year plan without needing outside help.
Model review
What does the financial model of a product called Wine Shop include?
The five-year-old workbook combines visitors to the wine shop, conversion, reordering, product mix, price, costs, employment and financing with monthly and annual financial results.
Use the model to plan how shop traffic becomes buyers by repeating orders, selling product categories, operating costs, cash flow and profitability over time.
Changes in operational assumptions and combined calculations shall update the financial statements, scenarios comparisons and management views used to review the forecast.
Built to plan the editedThe influences can be changed in Excel or Google Sheets to reflect your store's own operating plan.
revenue wine shop engine
How does the financial model of the wine shop calculate revenue?
The model transforms visitors to shops into buyers, transfers cohorts of repeat customers, builds monthly orders and units, allocates a mix of products and prices of each category.
01
Change visitors
A new buyer is equal to a visitor to a store multiplied by a visitor's conversion rate to the buyer.
02
Build repeating cohorts
Some new buyers become repeat customers for a certain lifetime.
03
Calculating orders
Moon orders combine the first orders with active customers repeated multiple times by the frequency of repeat orders.
04
allocation of units
Orders become sold units and then the common pool of units is allocated according to the mix of sales products.
05
Calculation of revenue
The allocated units of categories are prices by period and the revenue of the category is aggregated by category and by month.
Basic formulaRevenue = allocated units × category price
01 / Revenue
Which information is building the forecast of wine shops revenue?
The revenue view organizes visitors during the week, conversion, behaviour of recurring customers, order volume, product mix, start time and category prices in one operating schedule.
Revenue
The working sheet together with the operating charts shows the visitor, customer, order, unit, product mix and price data.
02 / COGS & OPEX
How are the costs of wine shops organised?
The view of COGS and OPEX separates assumptions regarding the cost of goods, variable costs and fixed costs, so that operating costs can flow to monthly profitability and cash calculations.
COGS & OPEX
The COGS and OPEX spreadsheet separates direct costs, variable costs and fixed costs that are repeated throughout the forecast.
03 / Scenarios
What can be compared with low things, basic things, and high things?
The scenario view compares alternative cases in terms of revenue, gross margin, coverage margin and EBITDA, so that operational changes can be viewed side by side.
Scenarios
The Scenarios report presents low, underlying and high cases with regard to revenues, margins and EBITDA within five years.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use the navigation desktop to review model configuration, multiple scenarios, basic finance, highest sources of revenue, profitability, cash flow and vision of investment-investment return in one place.
Dashboard
You can use your navigation desktop to review configuration control, scenario results, basic finance, mix of revenue, cash flow, profitability and return charts.
Product adjustment
Is the financial model of the wine shop suitable for you?
The ready model fits into the retail conversion economy of visitors; structurally different revenue logic, operating schedules or reporting requirements may require individual modelling.
Model ready
It fits perfectly
Selling starts with shoppers turning into first-time buyers.
Your plan includes recurring customers with active customer life.
Your orders are transformed into units allocated by the editable mixt of sales of product categories.
You need five-year financial statements, low / underlying / high cases and management reports.
Order structure
Think about the model
Your main revenue logic is not visitors, buyers, repeat orders and individual.
Your operating model requires schedules that go beyond the retail structure of the template.
Reporting requirements differ significantly from those made and management views.
Your company needs formulas or relationships planned based on unique requirements.
The indicator is the starting point for planning, not a guarantee of performance.
Financial modelling service for orders
Do you need a pattern that meets your requirements?
Financial Models Lab can build or customize a model when you need a different revenue logic, operational schedule or financial reporting.
After purchase you receive an immediate, fully editable workbook on the Wine Shop financial model for Excel or Google Sheets with five-year forecasts and reports.
01
Editable workbook
Open and edit the financial model in Excel or Google Sheets.
02
Five-year forecast
Review of five-year financial forecasts in detail monthly and annually.
03
Analysis of scenarios
Compare the Low, Base, and High cases in each key financial instrument.
04
Financial statements
Look at the income statement, the cash flow, the balance sheet, the dashboard and the supplementary reports.
Before purchase
Financial model FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model calculate revenues from business activities called Wine Shop?
Converts visitors in buyers, transfers cohorts of repeat customers, calculates orders and units, allocates a mix of sales, applies category prices and combines revenues.
02
Which wine shops can be changed?
You can edit the start date, visitors within a week, conversion, frequency of repeat order, units on order, mix of products, prices and seasonality.
03
What can I compare between Low, Base, and High scenarios?
In view of the scenarios, alternative cases for revenue, gross margin, contribution margin and EBITDA can be compared.
04
What financial results are taken into account?
The product confirms the profit and loss account, the cash flow report, the balance sheet, the navigation desk, the scenario analysis and additional looks at the financial statements.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers individual financial modelling where different revenue logics, operational schedules or reporting structures are needed.
06
Is the workbook a prediction or a guarantee?
This is forecast based on edited assumptions, not a guarantee of business results or financial results.
What Does the Wine Shop Financial Model Contain?
You get a comprehensive toolkit that includes the financial model, a pitch deck template, and a step-by-step video guide to help you get started.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
Revenue
COGS & OPEX
Scenarios
Dashboard
