Trusted by 25,000+ startup founders, investors and CPAs
Clear Reports, No Spreadsheets Hunt
Megan Carter, NY
The dashboard pulled my statements and charts into one place, so I stopped bouncing between files. It saved me about 6 hours a week during investor prep.
A Faster Way To Start
Tyler Brooks, OR
I was stuck staring at a blank sheet, but this template gave me a clean place to begin. I had a full first draft of the distillery plan in one afternoon.
Easy To Use And Edit
Lauren Mitchell, CO
I’m not strong with advanced Excel, so the built-in formulas and clear tabs were a relief. I finished the model without outside help and booked a lender call the same week.
Model review
What does the financial model of a product called Craft Distillery include?
The editable Excel workbook models five years of product-level distillery revenue, monthly and annual forecast, scenarios and integrated financial statements.
Use the model to plan how the amount of alcohol, unit prices, seasonality, production costs, operating expenses, employment, capital expenditure and financing affect your business forecast.
The editable operational assumptions are driven by monthly calculation engine, which compiles results for annual reviews, financial statements, scenario comparisons and management reports.
Built to plan the product lineIncome inflows are organized in spirit, with units produced and sales per unit driving each product line.
Craft distillery revenue engine
How does the shipyard calculate Revenue?
Revenue shall be calculated on the basis of product lines from recognised units and matching unit prices, calculated once a month by seasonality and in combination with the eligible revenue auxiliaries.
01
Product line set
Identification of each alcoholic beverage produced and, where appropriate, date of release.
02
Introduction of units
The units of revenue produced by product and period; the units listed in the table are revenue.
03
Unit pricing
An appropriate sales price per unit of each product line should be assigned.
04
Use seasonality
Annual revenue from products should be allocated on a monthly seasonal basis.
05
Calculation of revenue
A list of all revenue from the product line and any additional revenue that may be used separately.
Basic formularevenue = units produced × sales price per unit + additional revenue
01 / Revenue
Which shipments increase the revenue from commercial distilleries?
Worksheet revenue combines product names, launch dates, annual units produced, unit sales price, seasonality and forecast revenue at product level.
Revenue
Check product level units, prices, monthly assumptions for seasonality and annual revenue calculations.
02 / OPEX
How are operating expenses organised?
Worksheet OPEX separates Variable and Fixed operating expenses, with drivers based on revenue, time control, expenditure assumptions and monthly projections.
OPEX
Check for variable costs, fixed costs, time control, expenditure assumptions and monthly forecast.
03 / Scenarios
What can be compared in different scenarios?
The scenario compares Low, Base, and High cases with respect to five-year revenue, gross margin, contribution margin and EBITDA results.
Scenarios
Check the comparison of Low, Base, and High revenue levels and key margin measures.
04 / Dashboard
What Does the Dashboard Bring Together?
You can use dashboard to view global configurations, screen scenarios, basic financial results, a mix of revenue, profitability, cash flow and return on investment charts.
Is the financial model of a commercial distillery right for you?
The finished model is suitable for production line distilleries using units and prices; structurally different revenue, operations or reporting may require custom modelling.
Model ready
It fits perfectly
You sell a lot of the spirits you make using assumptions about product size and unit prices.
The five-year monthly and annual financial forecast may be used in the planning process.
You want editable COGS, operational, salaries, capital and financial assumptions related to the reports.
You want to compare the Low, Base, and High scenarios with the financial statements and the management results.
Order structure
Think about the model
Your revenue depends on a much different mechanics than the unit of the product multiplied by the unit price.
Your operations require specialized programs of production, inventory, capability, or recognition beyond that structure.
Your report requires substantially different statements, management opinions or decision analysis results.
Your model needs to be rebuilt around unique financing, ownership, or operational relationships.
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?
The Financial Model Laboratory may build or adapt the model where the revenue logic, operational schedules or reporting requirements differ from the final template.
When you make the money, you get a fully editable financial model Excel with five-year monthly and annual forecasts, scenarios and financial statements.
01
Editable workbook
Download a fully editable Excel model and replace your pre-built assumptions with your plan.
02
Five-year forecast
Work with detailed monthly forecasts and annual visions under the five-year forecast.
03
Analysis of scenarios
Compare Low, Base, and High cases by looking at the model scenario analysis.
04
Financial statements
An overview of the integrated management accounting statements of income statement, cash flow, balance sheet and results.
Before purchase
Craft distilleries Financial models FAQ
The basic answers are visible in their entirety, without the need to click on the accordion.
01
How does the financial model Craft Distillery calculate its revenue?
It calculates revenue product lines from recognised units multiplied by the corresponding unit selling price and then adds the additional revenue allowable. Annual revenue are allocated on a seasonal basis once a month.
02
Which assumptions can I change?
You can edit product names, launch dates, units produced, sales prices, monthly seasonality, additional revenue and related operational assumptions. The workbook also presents costs, remuneration, capital and financial resources.
03
What can I compare between Low, Base, and High scenarios?
A comparison can be made of how the three cases change revenue, gross margin, contribution margin and EBITDA over the five-year period of forecast.
04
What financial results are taken into account?
The product shall present the integrated income statement, the cash flow report and the balance sheet results as well as the dashboard, the summary, the profitability threshold, the ROIC, the valuation, charts, KPIs and related reports.
05
Can the Financial Models Lab adapt the model to individual requirements?
Yes. the Financial Models Lab offers individual financial modelling when you need a different revenue logic, operational schedule or reporting structure.
06
Is this workbook a prediction or a guarantee?
This is a planning forecast based on edited assumptions, not a guarantee of business results, financing, return or profitability.
What Does the Craft Distillery Financial Model Contain?
This package includes a comprehensive micro distillery financial projections template compatible with both Excel and Google Sheets.
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
OPEX
Scenarios
Dashboard
