Trusted by 25,000+ startup founders, investors and CPAs
Formula Confidence, No Guesswork
Megan Carter, CA
This template kept one broken formula from turning into a bigger mess. I found the inputs, checked the outputs, and had a clean model ready for a lender call in under an hour.
Clear Reports in One Place
David Nguyen, TX
I stopped hunting through separate files for the P&L, cash flow, and charts. Everything was in one place, so I could send a clean update to my partner without spending half a day pulling numbers together.
Easy For Non-Finance Users
Lisa Bennett, FL
I’m not strong in Excel, but the layout made the model easy to follow. I filled in the assumptions and had a five-year forecast ready for a planning meeting without calling in outside help.
MODEL OVERVIEW
What Is the Win Club Financial Model?
The Wine Club financial model is an editable five-year workbook for subscription cohorts, monthly and annual forecasting, scenario analysis and integrated financial statements.
Use the workbook to translate into a structural forecast of the option of buying, converting, retaining subscribers, setting the price of the plan and optional use of cash.
The editable assumptions relate to operational calculations which then update revenue, costs, scenarios, financial statements and management reports throughout the model.
Built around the subscription cohortAdjust the acquisition layers, the trial conversion, the churn, the plan mix, the prices and the optional monetization layers to convert the forecast.
ENGINE OF THE REVENUE FROM THE FINANCING CLUBS
How Does the Finance Model Wine Club Calculate Revenue?
Revenue starts with purchased cohorts registration, transforms samples and customers with direct payment into active subscribers of the plan, and then apply prices and allow additional levels of revenue.
01
Buy Subscriptions
New provisions equal marketing expenditure divided by CAC, divided between samples and direct paid off start.
02
Convert Cohorts
After the trial period, the test cohorts shall be converted into paid customers and shall be linked to the activations paid directly.
03
The Rolli Abonents
Paid activations are assigned according to plan, then active roll forward subscribers after monthly churn.
04
Price and Addition
Level prices create a MRR subscription, with the possibility of using, configuration, box and income allowance.
05
Income Recognition
Monthly recognised revenue layers are added to annual revenue; ARR remains run-rate KPI.
FORM OF CORRECTIONRevenue = subscription income + Usage + Configuration fees + Field and additional income
01 / REVENUE RESULTS
Which Entrances do You Get from the Win Club?
The Revenue Assumptions view ties marketing acquisition, trial conversion, plan mix, churn, tier pricing, and optional usage inputs to customer growth.
GROUNDS FOR THE REVENUE
Revenue assumes that they display acquisition, customer funnel, level prices and subscriber metrics.
02 / COGS & OPERATIONAL EXPENDITURE
How Are Planned Costs Organized?
View COGS & Operating expenditure separates assumptions on direct costs, variable costs and fixed operating costs throughout the forecast.
OPERATING EXPENDITURE COGS
COGS & Operating expenditures show direct, variable and fixed cost schedules.
03 / SCENARIO ANALYSIS
What Changes in Low, Basic and High Matters?
The analysis of the scenarios compares the low, base and high results in terms of revenues, gross margin, premium margin and EBITDA in the five-year forecast.
ANALYSIS SCENARIO
The analysis scenarios compare low, baseline and high results over five years of forecasting.
04 / DASHBOARD
What Does the Dashboard Contain?
The data table introduces selected assumptions of scenarios, basic finances, revenue mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
The navigation desk combines scenario control, basic finances, income set, profitability, cash flow and return.
FIT OF PRODUCTS
Is the Win Club Finance Model Suitable for You?
It fits the plans using the economy of cohort subscription and standard financial reporting; structural differences in revenue logic or timetables may justify non-standard modelling.
MODEL BY MADA READY
Good Example
You are acquiring customers through marketing and CAC, with trial and direct paid paths.
You manage multiple subscription levels with editable plans, churns and monthly prices.
You need optional use, configuration, field or layered revenue allowance for subscriptions.
You want five-year monthly and annual forecasts with scenarios and integrated statements.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your revenue depends on significant differences in customers, contracts, production capacity or price logic.
You need operational schedules that do not have a map for the provided subscription structure and co-ordinates.
You require specialized reporting outside the dashboard, scenarios and financial statements.
Your model needs structural changes, not editing available assumptions and schedules.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The financial models of Lab can build or adapt a model when the revenue logic, work schedules or reporting requirements differ from the final structure.
After ordering, you will receive a fully edited Wine Club workbook for Excel or Google Sheets with five-year views of planning.
01
Editable workbook
Open and edit the model in Excel or Google Sheets without plugins.
02
Five-year forecast
Review of five years of forecasting with detailed opinions each month and every year.
03
Analysis of scenarios
Compare low, base and high cases through a built-in scenario analysis.
04
Financial statements
Use an integrated income account, cash flow account and balance sheet.
BEFORE BUYING IMPORTANT INFORMATION
Wine Club Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the financial model of the Wine Club calculate revenue?
Builds paid subscriber cohorts from the purchase of marketing, trial, direct paid start, mix plan and churn, and then applies level prices. Allowed use, setting, boxing and additional layers are added to recognised income.
02
What are the assumptions I can change?
You can edit start time, marketing expenses and seasonality, CAC, sample and conversion settings, plan mix, churn or lifetime, level prices, usage, configuration fees and enabled options or additional inputs.
03
What can I compare in scenario analysis?
The analysis of the scenario compared low, base and high results in terms of revenues, gross margin, premium premium and EBITDA in the whole forecast.
04
What financial results are taken into account?
The workbook contains a statement of income, a statement of cash flow, a balance sheet, a navigation desk, analysis of scenarios, summary, charts, KPIs, valuation and reports Break-Even.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. Financial Models Lab offers custom financial modelling for buyers who need different revenue logic, operating schedules, or reporting.
06
Is the workbook a forecast or a guarantee?
This is a planning forecast based on assumptions for editing, not a guarantee of business results.
What Does the Wine Club Financial Model Contain?
You get a powerful, all-in-one financial forecasting tool designed specifically for the wine subscription business model.
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.
GROUNDS FOR THE REVENUE
OPERATING EXPENDITURE COGS
ANALYSIS SCENARIO
DASHBOARD
