Excel financial planning template for liquor store. The online worksheet illustrations use a separate website scenario; review the selected product's file specification and delivery terms before buying.
6 online worksheet illustrations, described below
Opening budget, scenario assumptions and dashboard views
Online five-year scenario and monthly operating sensitivity
Excel template sold separately; review the selected file specification
The online preview illustrates 6 planning sections using this website's scenario. These illustrations are separate from the downloadable workbook.
01Traffic, conversion and retail ordersExplains the confirmed retail visitor funnel and distinguishes new-buyer cohorts from completed transactions.Explore layout ↓
02Merchandise units, category mix and pricesConnects shared units per order to spirits, wine and packaged-beer categories and net realized selling prices.Explore layout ↓
03Goods cost and selling contributionSeparates sold merchandise from stock loss, selling supplies and payment costs before fixed operating coverage.Explore layout ↓
04Paid roster, premises and safeguardsFunds owner management, retail shifts and relief alongside the recurring cost of operating the licensed premises.Explore layout ↓
05Opening uses and supplier cash timingShows how installed setup, deposits, merchandise and operating cash serve different funding needs.Explore layout ↓
06Five-year statements and scenario reportsRelates the seller-described monthly and annual statements, scenarios and management views to editable retail assumptions.Explore layout ↓
Explore the online worksheet illustrations
Open each section to read the operating assumptions and illustration. These web views are not screenshots or downloadable Excel files.
Liquor StoreHTML illustration
EBITDA = Revenue − operating costs
Illustrative workbook layout · annual USD
Income statement
Year 1
Year 2
Year 3
Revenue
$1,317,186
$1,621,152
$1,621,152
Sold goods, stock loss and selling costs
$1,040,577
$1,280,710
$1,280,710
Paid owner, retail team and employer costs
$160,000
$160,000
$160,000
Premises and other recurring overhead
$110,000
$110,000
$110,000
EBITDA
$6,609
$70,442
$70,442
EBITDA margin
0.5%
4.3%
4.3%
Online scenario illustration; not a screenshot of the purchased workbook. Costs are shown as positive outflows; EBITDA excludes interest, tax, depreciation and amortization.
01Traffic, conversion and retail ordersOperating assumptions
Traffic, conversion and retail orders
Scenario purpose: Explains the confirmed retail visitor funnel and distinguishes new-buyer cohorts from completed transactions.
Inputs
Visitors by weekday and allowed trading calendar
Visitor-to-buyer conversion
Repeat share, lifetime and order frequency
Launch ramp
Outputs
New and repeat order flow
Completed retail orders by period
Traffic and conversion sensitivities
Scope and limitations
The website uses total completed orders, including repeats, rather than directly copying the native new-buyer cohort input.
The readable seller image includes Sunday traffic; replace it when the local license or chosen schedule prohibits Sunday sales.
Exact cohort timing and native formulas were not audited.
02Merchandise units, category mix and pricesOperating assumptions
Merchandise units, category mix and prices
Scenario purpose: Connects shared units per order to spirits, wine and packaged-beer categories and net realized selling prices.
Inputs
Completed orders and units per order
Mutually exclusive merchandise categories
Category mix and net prices
Discounts and expected sales refunds
Outputs
Category units sold
Net merchandise sales
Weighted net basket
Scope and limitations
The seller example also includes a tasting-event category; this off-premise case excludes it and requires a corresponding mix change.
Independent event capacity or wholesale accounts cannot be represented faithfully by relabeling retail basket units.
Collected sales tax is excluded from revenue.
03Goods cost and selling contributionOperating assumptions
Goods cost and selling contribution
Scenario purpose: Separates sold merchandise from stock loss, selling supplies and payment costs before fixed operating coverage.
Inputs
Authorized supplier invoices and landed costs
Salable returns, unsalable loss and supplier credits
Tender mix and actual processing contract
Category discount and loss allowances
Outputs
Landed goods margin
Variable selling-cost pool
Contribution before paid roster and premises
Scope and limitations
The seller confirms a COGS and OPEX module; a percentage cost input is not a SKU purchasing ledger.
Opening inventory and supplier payments are distinct from goods expense as merchandise sells.
The selected margin is an authored scenario, independent of seller default financial values.
04Paid roster, premises and safeguardsOperating assumptions
Paid roster, premises and safeguards
Scenario purpose: Funds owner management, retail shifts and relief alongside the recurring cost of operating the licensed premises.
Inputs
Owner floor and administrative hours
Lead and associate hours, wages and employer costs
Relief, breaks and peak checkout cover
Lease inclusions, utilities, systems and insurance
Outputs
Paid labor and overhead requirement
Coverage and workload checks
Fixed-cost sensitivity
Scope and limitations
The website's schedule is a planning interpretation, not a native paid-workbook staffing audit.
Local employee age, training, breaks, overtime and leave rules need confirmation.
A clerk roster and limited relief do not replace the owner's purchasing and compliance authority.
05Opening uses and supplier cash timingOperating assumptions
Opening uses and supplier cash timing
Scenario purpose: Shows how installed setup, deposits, merchandise and operating cash serve different funding needs.
Inputs
Installed fit-out and fixture bids
Actual permission and professional costs
Opening stock and supplier due dates
Launch ramp, tax funds and processor receipts
Outputs
Opening uses of funds
Operating-loss reserve test
Extra-stock cash stress
Scope and limitations
No scarce transferable-license purchase price or automatic supplier credit is assumed.
The native workbook's cash and startup reports are seller-described; an invoice-dated stock subledger was not verified.
Earnings, bank liquidity, debt funding and owner withdrawals remain different measures.
06Five-year statements and scenario reportsOperating assumptions
Five-year statements and scenario reports
Scenario purpose: Relates the seller-described monthly and annual statements, scenarios and management views to editable retail assumptions.
Inputs
Retail volume, mix and prices
Goods costs, paid labor and overhead
Startup uses and funding assumptions
Low, base and high inputs
Outputs
Income statement, cash flow and balance sheet
Scenario comparison
Dashboard and break-even interpretation
Scope and limitations
Product description and readable input imagery establish fit, not a current attachment or formula-chain audit.
The website uses its own constant-dollar off-premise case, rather than the seller's boutique sample figures.
Neither a scenario report nor operating break-even establishes investment payback or paid-file fulfillment.
Ways to prepare your files
Template
Current product · Shopify checkout
Edit the financial model with your own assumptions.
Define the revenue drivers, operating modules, outputs and review criteria before agreeing the work.
Project quote · Schedule agreed with you
Assumptions you can change
Use the Excel template to compare your financial assumptions. Review the selected version's input structure and outputs before adapting it. The online inputs and outputs on this page explain this website's price, volume, cost and opening-budget assumptions; they do not edit or verify a workbook. Range endpoints represent modeled scopes or sensitivities, not measured national averages.
Neither template establishes local demand, licensing compliance, financing approval or available owner cash.
Liquor Store input assumptions · USD unless stated
Driver
Base input
Scenario range / treatment
Role in the calculation
Net retail basket
$40.00
$32.00 – $48.00
Revenue per sold unit
Completed transactions per day
130
90 – 140
Daily throughput in the stated operating scope
Operating days per week
6
5 – 6
Trading schedule
Fixed operating costs / month
$22,500
Held constant
Operating break-even threshold
Contribution margin
21.0%
Held constant
Share of sales available for fixed costs
Starting share of mature volume
55.0%
Base ramp input
Opening month revenue
Mature volume added / month
5.0%
Base ramp input
Monthly ramp increment, capped at mature volume
Ramp horizon
24 months
Base ramp input
Period checked for operating break-even
The opening budget and annual expense inputs also need local quotes and staffing estimates. This page shows fixed examples; the free calculator lets you change price, volume and trading days.
Volume-only sensitivity · revenue at mature volume · monthly USD
Scenario
Daily units
Monthly revenue
Break-even revenue
First operating break-even
Lower volume
90
$93,528
$107,143
Not reached
Base volume
130
$135,096
$107,143
Month 6
Higher volume
140
$145,488
$107,143
Month 5
Only completed transactions per day changes. Net retail basket: $40.00; 6 operating days per week. Fixed costs and contribution margin stay constant. “Not reached” means no operating break-even within the 24-month ramp. Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. Slider cases do not change the annual forecast or measure cash payback.
Sample outputs from the current case
These results are calculated from the website’s illustrative assumptions. They illustrate planning calculations; they do not establish the purchased workbook’s formula behavior.
01 / Annual forecast
Revenue across five years
$1.3m
Year 1
$1.6m
Year 2
$1.6m
Year 3
$1.6m
Year 4
$1.6m
Year 5
Annual USD. Full values appear in the Dashboard presentation.
02 / Opening allocation
Where the opening budget goes
Tenant fit-out and electrical work$45,000
Shelving, counters and refrigeration$35,000
POS, stock controls and security$12,000
Deposits, applications and professional setup$20,000
Opening merchandise at landed cost$150,000
Pre-opening paid training and launch$18,000
Installed-work contingency$20,000
Operating and supplier-timing cash$65,000
One-time budget: $365,000. This allocation is not a cumulative cash-flow forecast.
03 / Operating earnings
Year 3 costs and EBITDA
Against annual revenue of $1,621,152.
Sold goods, stock loss and selling costs$1,280,710
Paid owner, retail team and employer costs$160,000
Premises and other recurring overhead$110,000
EBITDA$70,442
EBITDA margin: 4.3%. EBITDA is not cash available to the owner.
04 / Operating threshold
Volume needed to break even
Required whole units per day
104
Break-even revenue / month
$107,143
Base revenue / month at maturity
$135,096
First operating break-even
Month 6
Units mean completed transactions per day. The ramp covers 24 months; operating break-even does not measure recovery of opening capital.
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions. The website does not yet supply a complete funding, debt, tax and working-capital schedule for a cumulative cash-flow or payback chart. Read the full input basis and limitations.
Annual forecast and monthly operating reconciliation
Years 1–3 and the opening calculator ramp use one operating base within whole-dollar rounding. Years 4–5 follow the stated annual assumptions.
Original inputs · annual USD · whole-dollar rounding tolerance $5
Check
Annual forecast
Monthly calculator base
Year 1 revenue
$1,317,186
$1,317,186
Year 1 operating result
$6,609
$6,609
Year 2 revenue
$1,621,152
$1,621,152
Year 2 operating result
$70,442
$70,442
Year 3 revenue
$1,621,152
$1,621,152
Year 3 operating result
$70,442
$70,442
Year 3 / full-volume annual revenue
$1,621,152
$1,621,152
Year 3 / full-volume annual operating result
$70,442
$70,442
Year 1 uses months 1–12, Year 2 months 13–24 and Year 3 months 25–36. Full-volume rows use mature monthly sales and operating result × 12. The calculator holds price, days, contribution and fixed costs constant; an annual price, staffing or cost change can explain a separate path. Sliders do not change this comparison. Neither column measures cash flow, owner distributions or payback. Agreement tests arithmetic, not demand or cash funding. Input basis.
Both products in one cart
Model + Business Plan
Write the strategy and test the assumptions for your liquor store together. Update the narrative when you change the forecast.
The Business Plan uses Word and the Financial Model uses Excel. The online illustrations use this website's scenario data and may differ from the purchased files.
Listed file format
XLSX
Editor
Microsoft Excel
Editing
Adapt forecast assumptions in Excel. Check the selected version's forecast length, worksheets and formula permissions; the online illustrations use a separate scenario.
Other software
Compatibility with alternative editors has not been verified.
Delivery and terms
Review the product description, delivery details, license and final total in Shopify before paying.
Use the purchase button to buy the Liquor Store Financial Model for $109 through Shopify. This is a one-time price in USD before any applicable taxes.
What do the online previews show?
The online preview explains Traffic, conversion and retail orders, Merchandise units, category mix and prices, Goods cost and selling contribution, Paid roster, premises and safeguards, Opening uses and supplier cash timing, Five-year statements and scenario reports using this website's illustrative case. It is separate from the downloadable Excel model.
Are these previews pages from a finished file?
The web previews are rendered from the website's case record. They illustrate planning concepts and calculations; they are not screenshots or a page-by-page inventory of the downloadable product.
What would I need to change for my business?
Review net retail basket, completed transactions per day, the operating schedule, opening budget and costs. These web previews do not edit a workbook. Test the website's price and volume assumptions in the business idea page's calculator.
Is the written business plan included?
The Financial Model is sold separately. The $168 Bundle adds the $59 Business Plan and $109 Financial Model for the same business to one cart, one of each.
Do the figures establish what my business will earn?
No. The figures describe an illustrative U.S. operating case, not measured industry averages or a prediction for your location. EBITDA is not owner cash, and operating break-even does not recover the opening investment. Check local costs, capacity and demand before using the assumptions.
Do the web previews reproduce the purchased files?
The online outlines, tables and worksheet illustrations use this website's scenario. They are not screenshots, a verified page count or a confirmed worksheet inventory of the purchased files. Check the selected product's specification before buying.
How are the files delivered?
Review the selected item's delivery method and license in Shopify before paying. These pages do not document a completed purchase or download test.
