{"product_id":"liquor-store-financial-model","title":"Liquor Store Startup Financial Model Template","description":"\u003cstyle data-fml-style=\"10-safe-dom\"\u003e\n\/* FML Financial Model Product Description v10 — scoped Shopify fragment CSS.\n   Theme owns typography, checkout, product image rendering and Preview. *\/\n.fml-description{\n  --primary:#6067F2;--primary-dark:#2228B0;--soft:#F2F2FF;--xlight:#ECEDFF;\n  --yellow:#FCBD01;--ink:#0F1017;--text:#4C4F62;--muted:#686B80;\n  --line:#E0E1ED;--paper:#FAFAFA;--white:#FFFFFF;\n  box-sizing:border-box;container-type:inline-size;container-name:fml;\n  width:100%;min-width:0;max-width:100%;margin:0;padding:0;\n  font-family:inherit;font-size:17px;line-height:1.7;color:var(--text);background:var(--white)\n}\n.fml-description :where(*):not(.workbook-media,.workbook-media *){box-sizing:border-box}\n.fml-description :where(h2,h3,p,dl,dd,figure):not(.workbook-media *){margin:0;padding:0}\n.fml-description :where(h2,h3):not(.workbook-media *){\n  color:var(--ink);font-weight:650;letter-spacing:-.02em;\n  line-height:1.32;white-space:normal;word-break:normal;overflow-wrap:break-word;hyphens:none\n}\n.fml-description h2{font-size:clamp(26px,3vw,36px)}\n.fml-description h3{font-size:21px}\n.fml-description p{font-size:17px;line-height:1.7;overflow-wrap:break-word;word-break:normal}\n.fml-description strong{font-weight:650}\n.fml-description .container{box-sizing:border-box;width:100%;max-width:1180px;min-width:0;margin-inline:auto;padding-inline:clamp(16px,3%,32px)}\n.fml-description section{box-sizing:border-box;display:block;width:100%;min-width:0;max-width:100%;position:static}\n.fml-description .section{padding-block:58px}\n.fml-description .section.soft-section{background:var(--soft)}\n.fml-description .section.startup-section{background:var(--paper)}\n.fml-description .description-intro{padding-block:34px 16px}\n.fml-description .intro-copy{width:100%;max-width:1050px}\n.fml-description .intro-copy p+p{margin-top:13px}\n.fml-description .section-heading{display:block!important;width:100%;min-width:0;margin:0 0 28px;padding:0}\n.fml-description .section-heading h2{display:block;width:100%;min-width:0;max-width:none;margin:0 0 12px}\n.fml-description .section-heading\u003ep{display:block;width:100%;max-width:910px;margin:0;color:var(--text)}\n.fml-description .eyebrow{display:block;font-size:16px;line-height:1.4;font-weight:650;text-transform:uppercase;letter-spacing:.055em;color:var(--primary-dark);margin-bottom:11px}\n.fml-description .section-copy{display:block;min-width:0;width:100%}\n.fml-description .section-copy p+p{margin-top:12px}\n.fml-description .section-copy h3{margin-bottom:10px}\n.fml-description .section-note{font-size:16px;line-height:1.65;color:var(--muted);margin-top:18px}\n\n\/* Compact numeric facts: independent vertical tracks, never side-by-side value and copy. *\/\n.fml-description .product-facts{\n  display:grid;grid-template-columns:repeat(4,minmax(0,1fr));\n  width:100%;min-width:0;gap:0;border-block:1px solid var(--line);\n  padding-block:23px;margin-top:28px\n}\n.fml-description .product-facts\u003ediv{display:flex;flex-direction:column;align-items:flex-start;min-width:0;padding:0 20px;gap:5px}\n.fml-description .product-facts\u003ediv:first-child{padding-left:0}\n.fml-description .product-facts\u003ediv+div{border-left:1px solid var(--line)}\n.fml-description .product-facts dt{font-size:16px;line-height:1.35;color:var(--muted);white-space:normal}\n.fml-description .product-facts dd{display:flex;flex-direction:column;align-items:flex-start;gap:4px;width:100%;min-width:0;margin:0}\n.fml-description .fact-value{display:block;font-size:clamp(32px,3.5vw,40px);line-height:1.2;font-weight:650;letter-spacing:-.03em;color:var(--primary);white-space:nowrap;font-variant-numeric:tabular-nums}\n.fml-description .fact-detail{display:block;min-width:0;font-size:16px;line-height:1.45;color:var(--text);white-space:normal;word-break:normal}\n\n\/* Flat cards grow with their text; no min-width or fixed height that squeezes headings. *\/\n.fml-description .included-list,.fml-description .use-cases,.fml-description .report-grid{\n  display:grid;grid-template-columns:repeat(3,minmax(0,1fr));gap:20px;width:100%;min-width:0\n}\n.fml-description .included-list article,.fml-description .use-case,.fml-description .report-grid article{\n  min-width:0;max-width:100%;padding:22px 20px;border:1px solid var(--line);\n  background:var(--white);border-radius:10px;box-shadow:none;overflow:visible\n}\n.fml-description .included-list h3,.fml-description .use-case h3,.fml-description .report-grid h3{\n  display:block;width:100%;font-size:20px;margin:0 0 10px;line-height:1.35\n}\n.fml-description .included-list p,.fml-description .use-case p,.fml-description .report-grid p{font-size:16px;line-height:1.65}\n.fml-description .use-case{border-top:3px solid var(--primary)}\n\n\/* The text and its exact worksheet shortcode must share ONE component. *\/\n.fml-description .media-explainer{\n  display:grid;grid-template-columns:minmax(0,1fr) minmax(0,min(39%,420px));\n  width:100%;min-width:0;max-width:100%;gap:clamp(22px,3.5%,48px);\n  align-items:center;margin:34px 0 42px;padding:0;clear:both\n}\n.fml-description .media-explainer[data-fml-side=\"left\"]{grid-template-columns:minmax(0,min(39%,420px)) minmax(0,1fr)}\n.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.section-copy{grid-column:2;grid-row:1}\n.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.workbook-media{grid-column:1;grid-row:1;justify-self:start}\n.fml-description .media-explainer\u003e.section-copy{min-width:0;width:100%;padding:18px clamp(12px,2%,25px)}\n.fml-description .media-explainer\u003e.section-copy h3{font-size:21px;margin-bottom:12px}\n.fml-description .media-explainer\u003e.section-copy p{font-size:17px;line-height:1.7}\n.fml-description .media-explainer\u003e.workbook-media{\n  display:block;min-width:0;width:100%;max-width:420px;margin:0;\n  padding:12px 0 16px;justify-self:end;align-self:center\n}\n.fml-description .workbook-media :where(img,picture){max-width:100%;height:auto}\n\/* Never change the theme's shortcode Preview\/button\/modal descendants. *\/\n\n.fml-description .text-copy{display:block;max-width:1050px;margin:20px 0 26px;min-width:0}\n.fml-description .text-copy p+p{margin-top:13px}\n.fml-description .formula-text{margin:26px 0 32px;padding:18px 20px;border:1px solid var(--line);border-left:4px solid var(--primary);background:var(--white);border-radius:8px}\n.fml-description .formula-text .formula-label{display:block;color:var(--primary-dark);font-size:16px;font-weight:650;margin-bottom:5px}\n.fml-description .formula-text p{color:var(--ink);font-size:17px;line-height:1.65}\n.fml-description .callout{margin:24px 0 30px;padding:18px 22px;border-left:4px solid var(--yellow);background:var(--soft);border-radius:6px}\n.fml-description .callout strong{display:block;font-size:18px;color:var(--primary-dark);margin-bottom:5px}\n.fml-description .callout p{font-size:16px}\n\n\/* Tables are full width and have no hard min-widths. Wide year matrices use years as rows. *\/\n.fml-description .table-shell{display:block;width:100%;min-width:0;max-width:100%;margin:25px 0 32px;overflow:visible;border:1px solid var(--line);border-radius:9px;background:var(--white)}\n.fml-description .data-table{width:100%;min-width:0;max-width:100%;border:0;border-collapse:collapse;table-layout:fixed;font-size:16px;line-height:1.5;font-variant-numeric:tabular-nums}\n.fml-description .data-table caption{caption-side:top;text-align:left;padding:18px 18px 14px;color:var(--ink);font-size:19px;line-height:1.4;font-weight:650}\n.fml-description .data-table :where(th,td){padding:13px 11px;border-bottom:1px solid var(--line);vertical-align:middle;white-space:normal;overflow-wrap:break-word;word-break:normal}\n.fml-description .data-table th:first-child,.fml-description .data-table td:first-child{text-align:left;width:32%}\n.fml-description .data-table :where(td,th:not(:first-child)){text-align:right}\n.fml-description .data-table thead th{font-size:16px;font-weight:650;background:var(--soft);color:var(--primary-dark);line-height:1.4}\n.fml-description .data-table tbody th{font-size:16px;font-weight:600;color:var(--ink)}\n.fml-description .data-table tbody tr:last-child :where(th,td){border-bottom:0}\n.fml-description .data-table tfoot :where(th,td){font-weight:700;color:var(--primary-dark);background:var(--xlight);border-top:2px solid var(--primary);border-bottom:0}\n.fml-description .table-note{margin:0;padding:0 18px 16px;font-size:16px;color:var(--muted);line-height:1.6}\n\n.fml-description .faq-grid{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:28px 34px;min-width:0}\n.fml-description .faq-grid article{min-width:0;padding-top:18px;border-top:1px solid var(--line)}\n.fml-description .faq-grid h3{font-size:19px;margin-bottom:8px}\n.fml-description .faq-grid p{font-size:16px;line-height:1.65}\n\n\/* Container queries use the ACTUAL Shopify description width, not only viewport width. *\/\n@container fml (max-width:1040px){\n  .fml-description .product-facts{grid-template-columns:repeat(2,minmax(0,1fr));row-gap:22px}\n  .fml-description .product-facts\u003ediv:nth-child(odd){padding-left:0;border-left:0}\n  .fml-description .product-facts\u003ediv:nth-child(even){border-left:1px solid var(--line)}\n  .fml-description .product-facts\u003ediv:nth-child(n+3){padding-top:15px;border-top:1px solid var(--line)}\n  .fml-description .included-list,.fml-description .use-cases,.fml-description .report-grid{grid-template-columns:repeat(2,minmax(0,1fr))}\n}\n@container fml (max-width:790px){\n  .fml-description .media-explainer,.fml-description .media-explainer[data-fml-side=\"left\"]{grid-template-columns:minmax(0,1fr);gap:15px;margin:28px 0 38px}\n  .fml-description .media-explainer\u003e.section-copy,.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.section-copy{grid-column:1;grid-row:1;padding:12px 3px 0}\n  .fml-description .media-explainer\u003e.workbook-media,.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.workbook-media{grid-column:1;grid-row:2;justify-self:center;max-width:min(100%,420px);padding:6px 0 20px}\n  .fml-description .section{padding-block:43px}\n  .fml-description .section-heading{margin-bottom:24px}\n}\n@container fml (max-width:620px){\n  .fml-description .included-list,.fml-description .use-cases,.fml-description .report-grid,.fml-description .faq-grid{grid-template-columns:minmax(0,1fr)}\n  .fml-description .product-facts{grid-template-columns:repeat(2,minmax(0,1fr));gap:16px}\n  .fml-description .product-facts\u003ediv{padding:0!important;border:0!important}\n  .fml-description .product-facts\u003ediv:nth-child(n+3){padding-top:16px!important;border-top:1px solid var(--line)!important}\n  .fml-description .product-facts\u003ediv:nth-child(even){padding-left:13px!important;border-left:1px solid var(--line)!important}\n  .fml-description h2{font-size:27px}\n  .fml-description h3{font-size:20px}\n  .fml-description .table-shell{border:0;background:transparent}\n  .fml-description .data-table{display:block;width:100%}\n  .fml-description .data-table caption{display:block;padding:12px 0;font-size:18px}\n  .fml-description .data-table thead{display:none}\n  .fml-description .data-table tbody,.fml-description .data-table tfoot{display:block;width:100%}\n  .fml-description .data-table tbody tr,.fml-description .data-table tfoot tr{display:block;border:1px solid var(--line);background:var(--white);margin-bottom:12px;padding:4px 13px}\n  .fml-description .data-table tbody :where(th,td),.fml-description .data-table tfoot :where(th,td){box-sizing:border-box;display:flex;width:100%;justify-content:space-between;align-items:baseline;gap:16px;text-align:right;padding:9px 0;border:0}\n  .fml-description .data-table tbody th:first-child,.fml-description .data-table tfoot th:first-child{display:block;text-align:left;font-size:17px;border-bottom:1px solid var(--line);width:100%;padding:10px 0}\n  .fml-description .data-table tbody td:before,.fml-description .data-table tfoot td:before{content:attr(data-label);text-align:left;font-weight:550;color:var(--muted);min-width:0;white-space:normal}\n  .fml-description .table-note{padding:4px 0 15px}\n}\n@container fml (max-width:400px){\n  .fml-description .product-facts{grid-template-columns:minmax(0,1fr)}\n  .fml-description .product-facts\u003ediv,.fml-description .product-facts\u003ediv:nth-child(even){border:0!important;padding:0!important}\n  .fml-description .product-facts\u003ediv+div{padding-top:15px!important;border-top:1px solid var(--line)!important}\n  .fml-description .fact-value{font-size:36px}\n  .fml-description .container{padding-inline:14px}\n}\n@media (prefers-reduced-motion:reduce){.fml-description *{transition:none!important;animation:none!important}}\n\n.fml-description .text-link-row{margin:22px 0}.fml-description .text-link{display:inline-block;color:var(--primary-dark);font-weight:650;text-decoration:underline;text-underline-offset:4px;font-size:17px}\n\u003c\/style\u003e\n\u003cdiv class=\"fml-description\" id=\"fml-description\" data-fml-version=\"10-safe-dom\"\u003e\n\u003csection class=\"description-intro\" id=\"fml-description-intro\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"intro-copy\"\u003e\n\u003cp\u003eThis Liquor Store Financial Model is an Excel template for an independent off-premise neighborhood store. It converts purchasing visits, items per visit, category mix, selling prices, operating costs, staffing, startup investment, and working-capital assumptions into monthly and annual financial projections.\u003c\/p\u003e\n\u003cp\u003eThe illustrated case represents an estimated 2,000 sq ft suburban Illinois store with consumer checkout only, no wholesale or delivery, and a January 31, 2026 launch date. The operating forecast runs through EBITDA; the example results are planning projections rather than observed industry performance.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdl class=\"product-facts\" aria-label=\"Financial model facts\"\u003e\n\u003cdiv\u003e\n\u003cdt\u003eForecast\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eyears\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eSales categories\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e6\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eexclusive categories\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eStaffing\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e3.5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eaverage paid FTE\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eInventory\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e59\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003edays assumption\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003c\/dl\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-included\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eMODEL CONTENTS\u003c\/span\u003e\u003ch2\u003eWhat Is Included in the Liquor Store Model\u003c\/h2\u003e\n\u003cp\u003eThe workbook links operating assumptions to monthly calculations, financial statements, funding schedules, management reports, and model checks.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"included-list\"\u003e\n\u003carticle\u003e\u003ch3\u003eRevenue \u0026amp; Calculations\u003c\/h3\u003e\n\u003cp\u003eRevenue and Calc organize the demand inputs, launch timing, monthly purchasing visits, units per visit, category allocation, realized prices, seasonality, and resulting sales by product category.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCosts \u0026amp; Staffing\u003c\/h3\u003e\n\u003cp\u003eCOGS \u0026amp; OPEX separates merchandise and stock-related direct costs from variable and fixed operating expenses, while Payroll models the Store Manager, Sales Associates, and Stock Associate separately.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eInvestment \u0026amp; Funding\u003c\/h3\u003e\n\u003cp\u003eCAPEX, CapTable, Debt, Sources \u0026amp; Uses, and Cash Flow connect startup assets, equity contributions, optional financing, investment spending, and liquidity without treating startup funding as operating profit.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eStatements \u0026amp; Analysis\u003c\/h3\u003e\n\u003cp\u003eIncome Statement, Balance Sheet, Cash Flow, Summary, Scenarios, Returns, Valuation, Ratios, DuPont, Charts, Top_Revenue, Top_Expenses, Benchmarks, and Checks support financial review and model reconciliation.\u003c\/p\u003e\u003c\/article\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section soft-section\" id=\"fml-revenue\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eREVENUE FORECAST\u003c\/span\u003e\u003ch2\u003eHow the Model Calculates Liquor Store Revenue\u003c\/h2\u003e\n\u003cp\u003eRevenue is demand-based: purchasing visits generate sale units, then one shared unit pool is allocated across six mutually exclusive bottle or pack categories.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eFor each month, the model multiplies purchasing visits per open day by 30 open days and 1.35 sale units per visit, then applies the repeating monthly demand factor. The resulting units are distributed across Whiskey and Bourbon, Vodka Gin and Rum, Tequila and Agave, Still Wine, Sparkling Wine, and Beer and Cider.\u003c\/p\u003e\n\u003cp\u003eEach category then applies its own annual net selling price. The base mix totals 100%: 22%, 20%, 12%, 25%, 6%, and 15%, so the same sold unit is never counted in more than one revenue stream.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"revenue\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eRevenue Forecast\u003c\/h3\u003e\n\u003cp\u003eThe Revenue Forecast shows the operating drivers, monthly unit volume, category allocation, selling prices, and resulting sales. It lets a user trace changes in store traffic or basket size through to projected revenue by stream.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic2]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"formula-text\"\u003e\n\u003cspan class=\"formula-label\"\u003e2026 core unit calculation before monthly seasonality\u003c\/span\u003e\u003cp\u003e100 purchasing visits\/day × 30 open days\/month × 1.35 units\/visit = 4,050 sale units\/month before the repeating monthly factor.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003caside class=\"callout\"\u003e\u003cstrong\u003eDemand model\u003c\/strong\u003e\u003cp\u003eThe forecast uses one shared customer demand pool. Category percentages allocate units within that pool rather than creating separate, additive traffic assumptions.\u003c\/p\u003e\u003c\/aside\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-costs\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eCOSTS \u0026amp; PAYROLL\u003c\/span\u003e\u003ch2\u003eHow Operating Costs and Staffing Flow to EBITDA\u003c\/h2\u003e\n\u003cp\u003eThe model separates merchandise COGS, variable operating expenses, fixed overhead, and payroll so each cost is counted once.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"costs\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCOGS and Operating Expenses\u003c\/h3\u003e\n\u003cp\u003eThe COGS \u0026amp; Operating Expense Forecast separates merchandise purchases, stock breakage and obsolescence, inbound freight, card processing, checkout supplies, and fixed store overhead. These assumptions feed monthly expenses and operating margins without including salaried staff twice.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic10]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eDirect COGS uses 72% of revenue for alcohol merchandise purchases, 0.8% for stock breakage, theft and obsolescence, and 0.7% for inbound freight and receiving. Variable expenses include card processing plus 0.4% of revenue for checkout bags and receipt supplies.\u003c\/p\u003e\n\u003cp\u003eFixed operating coverage includes rent and occupancy, utilities and internet, insurance, recurring licenses and compliance, POS and inventory software, accounting, local marketing, security, cleaning, waste, repairs, and equipment maintenance. Rent begins at $3,500 per month in 2026.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"payroll\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003ePayroll Forecast by Staff Role\u003c\/h3\u003e\n\u003cp\u003eThe Payroll Forecast shows staffing FTE and fixed base pay by role. The illustrated plan uses one Store Manager, two Sales Associates, and 0.5 Stock Associate FTE, producing $149,000 of annual base payroll in each forecast year.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic8]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003caside class=\"callout\"\u003e\u003cstrong\u003ePayroll scope\u003c\/strong\u003e\u003cp\u003eEmployer taxes, benefits, and personal taxes are excluded from the documented staffing scope, and listed base salaries are not included again in COGS or operating expense rates.\u003c\/p\u003e\u003c\/aside\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section startup-section\" id=\"fml-startup\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eSTARTUP \u0026amp; FUNDING\u003c\/span\u003e\u003ch2\u003eHow Startup Investment Differs From Operating Earnings\u003c\/h2\u003e\n\u003cp\u003eStartup assets, opening cash needs, inventory, and owner funding are modeled separately from annual operating expenses and EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"capex\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCapital Expenditure Plan\u003c\/h3\u003e\n\u003cp\u003eThe Capital Expenditure Plan records durable startup assets and their timing, including leasehold fit-out, shelving and displays, refrigeration, POS and ID-check hardware, security equipment, safe, and exterior signage. Depreciable purchases can then flow into the asset schedule.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic9]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe documented startup assets include $25,000 of leasehold fit-out, $16,000 of retail shelving and displays, $12,000 of installed refrigeration, and $4,500 of POS and ID-check hardware. Other opening cash items include deposits, permits, prelaunch marketing, preopening payroll and training, and preopening utilities.\u003c\/p\u003e\n\u003cp\u003eInitial owner funding is estimated at $538,878. That amount includes durable assets, one-time prelaunch cash, opening stock, and a three-month reserve of gross cash operating outflows; it is a planning funding input, not a demonstrated peak cash requirement.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"funding\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eSources and Uses of Funds\u003c\/h3\u003e\n\u003cp\u003eThe Sources and Uses of Funds report reconciles planned funding sources with operating, investing, and financing uses of cash. It helps distinguish owner equity or debt funding from revenue receipts and from the cash retained in the business.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic3]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003caside class=\"callout\"\u003e\u003cstrong\u003eWorking capital\u003c\/strong\u003e\u003cp\u003eThe base assumptions use 0 accounts-receivable days, 0 accounts-payable days, and 59 inventory days, reflecting consumer checkout sales with a material stockholding requirement.\u003c\/p\u003e\u003c\/aside\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section soft-section\" id=\"fml-forecast\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eILLUSTRATIVE FORECAST\u003c\/span\u003e\u003ch2\u003eWhat the Five-Year Example Forecast Shows\u003c\/h2\u003e\n\u003cp\u003eThe illustrated base case grows revenue and EBITDA from 2026 through 2030 while keeping the example focused on operating performance rather than promising realized results.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative annual forecast, USD\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eYear\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eRevenue\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eOperating Expenses\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eEBITDA\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2026\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$1,249,992\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,187,159\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$62,833\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$1,376,991\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,286,651\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$90,340\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$1,508,570\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,389,703\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$118,867\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2029\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$1,644,861\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,496,418\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$148,444\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2030\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$1,758,942\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,586,214\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$172,727\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eIllustrative model outputs rounded to whole dollars; totals may differ slightly from displayed arithmetic because the workbook retains underlying precision.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eIn the example case, purchasing visits per open day rise from 100 in 2026 to 130 in 2030 while category selling prices also increase. The model then carries those revenue changes through COGS, variable expenses, fixed costs, and payroll to calculate EBITDA.\u003c\/p\u003e\n\u003cp\u003eEBITDA is an operating measure and does not establish net profit or cash sufficiency. The full workbook also includes depreciation, financing, tax, working-capital, balance-sheet, and cash-flow schedules for broader financial analysis.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"cashflow\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCash Flow Forecast\u003c\/h3\u003e\n\u003cp\u003eThe Cash Flow Forecast shows monthly operating, investing, and financing cash movements together with opening and closing cash reconciliation. It is the report to review when evaluating liquidity, funding timing, investment spending, and debt or equity cash flows.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic12]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003caside class=\"callout\"\u003e\u003cstrong\u003eIllustrative case\u003c\/strong\u003e\u003cp\u003eThe forecast is a model scenario based on selected planning assumptions, not a historical store result, industry average, or guarantee of future performance.\u003c\/p\u003e\u003c\/aside\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-returns\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eBREAK-EVEN \u0026amp; RETURNS\u003c\/span\u003e\u003ch2\u003eHow the Model Evaluates Break-Even and Investment Returns\u003c\/h2\u003e\n\u003cp\u003eThe Returns report keeps operating break-even, cash break-even, investment payback, and annual ROIC as separate measures instead of treating them as interchangeable.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"returns\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eBreak-Even, Payback and ROIC\u003c\/h3\u003e\n\u003cp\u003eThe Return on Invested Capital Analysis combines sales break-even, cash break-even timing, investment payback, project cash flows, invested capital, and annual ROIC. It helps compare operating coverage with the separate question of when invested funds may be recovered.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic4]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eSales break-even compares revenue with the level needed to cover operating costs, while cash break-even considers cash movement and timing. Investment payback tracks cumulative project cash flow, and ROIC relates operating returns to invested capital.\u003c\/p\u003e\n\u003cp\u003eNo payback month, ROIC percentage, IRR, or valuation amount is inferred here because those values are not supplied in the documented example outputs. Users can instead adjust operating and financing assumptions and review the calculated reports in the workbook.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"scenarios\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eFinancial Scenario Analysis\u003c\/h3\u003e\n\u003cp\u003eThe Financial Scenario Analysis compares Low, Base, and High cases for revenue, gross margin, contribution margin, and EBITDA. Dashboard multipliers can change revenue, COGS, variable expenses, fixed expenses, and payroll to test operating sensitivity.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic13]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-faq\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eFAQ\u003c\/span\u003e\u003ch2\u003eLiquor Store Financial Model FAQ\u003c\/h2\u003e\n\u003cp\u003eThese answers summarize the model scope, editable assumptions, calculations, and reports.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eHow does the model forecast liquor store sales?\u003c\/h3\u003e\n\u003cp\u003eIt multiplies purchasing visits, open days, units per visit, monthly seasonality, category mix, and category selling prices to calculate monthly and annual revenue.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I change the product mix and prices?\u003c\/h3\u003e\n\u003cp\u003eYes. The six category shares and annual net selling prices are operating inputs, so you can replace the illustrated assumptions with your own planned mix and pricing.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the model include payroll separately from operating costs?\u003c\/h3\u003e\n\u003cp\u003eYes. Store Manager, Sales Associates, and Stock Associate staffing are modeled in Payroll and excluded from the listed COGS, variable, and fixed expense inputs.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes it include startup costs and opening inventory?\u003c\/h3\u003e\n\u003cp\u003eYes. Startup assets, preopening cash items, opening stock, working-capital assumptions, and owner funding are modeled separately from recurring operating expenses.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eWhat financial statements are included?\u003c\/h3\u003e\n\u003cp\u003eThe workbook includes projected Income Statement, Cash Flow Statement, Balance Sheet, Summary, and supporting schedules, plus management and analysis reports.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes EBITDA equal cash flow or net profit?\u003c\/h3\u003e\n\u003cp\u003eNo. EBITDA measures operating earnings before depreciation, interest, and tax; liquidity and financing effects are evaluated in the Cash Flow and other financial statements.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I test downside and upside scenarios?\u003c\/h3\u003e\n\u003cp\u003eYes. Dashboard Scenario Controls provide Low, Base, and High multipliers for revenue, COGS, variable expenses, fixed expenses, and payroll.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the model guarantee profitability or funding sufficiency?\u003c\/h3\u003e\n\u003cp\u003eNo. The outputs are illustrative projections based on user inputs, and the documented owner funding amount is not presented as a tested peak cash requirement.\u003c\/p\u003e\u003c\/article\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\n\u003c\/div\u003e","brand":"FinancialModelsLab","offers":[{"title":"Default Title","offer_id":48218039779571,"sku":"liquor-store-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/liquor-store-financial-model-headimage-financialmodelslab_7ea1b28e-b3ce-405a-b5a3-2f02481a887b.webp?v=1765297459","url":"https:\/\/finmodelslab.myshopify.com\/products\/liquor-store-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}