Set Calendar
Set opening date, operating days and weeks, and planned closures for each period.
This editable five-year workbook forecasts speakeasy revenue from weekday covers, seasonality, and midweek or weekend checks, then links projections to financial statements and reports.
Use the model to plan customer volume, average spend, revenue mix, costs, staffing, capital needs, cash flow, and financial performance before or after opening.
Editable operating assumptions flow through monthly calculations into the Income Statement, Cash Flow Statement, Balance Sheet, scenarios, and management views.
The model converts weekday cover assumptions into calendar-based volume, applies monthly seasonality and midweek or weekend checks, then allocates and sums category sales.
Set opening date, operating days and weeks, and planned closures for each period.
Enter average covers by weekday and convert the pattern into monthly operating volume.
Adjust monthly covers with the seasonality assumptions used across the opening calendar.
Multiply covers by midweek or weekend checks and allocate sales by revenue mix.
Add monthly category sales and any separately modeled ancillary sales into total revenue.
The Revenue Assumptions view organizes opening timing, weekday covers, seasonality, average checks, and product mix that drive the sales forecast.
REVENUE ASSUMPTIONS
The COGS & OPEX schedule separates direct costs, variable expenses, and fixed operating expenses with editable timing and monthly forecast calculations.
COGS & OPEX
The Scenario Analysis view compares Low, Base, and High outcomes across revenue, gross margin, contribution margin, and EBITDA over the forecast.
SCENARIO ANALYSIS
The Dashboard combines model setup, scenario controls, key financial outputs, revenue mix, profitability, cash flow, and investment payback in one view.
DASHBOARD
The ready-made model fits bars using covers and average checks; structurally different revenue logic, operating schedules, or reporting may call for customization.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your business needs different revenue logic, operating schedules, or reporting requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an editable Excel or Google Sheets financial model with a five-year forecast, scenarios, statements, and management views.
Open and edit the model in Excel or Google Sheets without special plugins.
Project revenue, costs, cash flow, and financial performance across five forecast years.
Compare Low, Base, and High cases through the model’s scenario controls and reports.
Review the Income Statement, Cash Flow Statement, Balance Sheet, and management outputs.
The essential answers are visible in full, with no accordion clicks required.
It forecasts covers by weekday, converts them through the operating calendar, applies monthly seasonality and average checks, then allocates and sums category sales.
You can change the opening date, weekday covers, operating calendar, closures, seasonality, midweek and weekend checks, revenue mix, and ancillary sales assumptions.
The Scenario Analysis view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the forecast.
The product shows an Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Scenario Analysis, Summary, and other management reports.
Yes. Financial Models Lab offers custom modeling for different revenue logic, operating schedules, calculations, or reporting requirements.
It is a planning forecast driven by editable assumptions, not a guarantee of business performance, funding, profitability, or returns.
You get a comprehensive and user-friendly Excel spreadsheet for bar expenses and revenue, complete with detailed instructions and all the necessary financial statements.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
This template made cash-flow gaps easy to spot, so I could see runway and shortfalls without guessing. It saved me a few hours in planning and made my lender update much easier.
I could finally see break-even and margin assumptions in one place instead of digging through formulas. That gave me a cleaner model and saved about half a day of back-and-forth.
Starting from scratch was the part I kept putting off, and this gave me a solid place to begin. I had a working forecast the same afternoon, which was a relief.