{"product_id":"antique-store-financial-model","title":"Antique Store Financial Model","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 Antique Store Financial Model is an Excel planning template for an independent, owned-inventory antique and vintage retailer. It converts showroom traffic, purchase conversion, five merchandise allocations, selling prices, and operating expenses into monthly financial projections and management reports.\u003c\/p\u003e\n\u003cp\u003eThe included example represents one leased, 1,500-square-foot showroom in Columbus, Ohio, launching January 31, 2026. Its 2026–2030 figures are hypothetical planning assumptions, not actual store results, market averages, or a forecast for every buyer.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdl class=\"product-facts\" aria-label=\"Financial model facts\"\u003e\n\u003cdiv\u003e\n\u003cdt\u003eForecast length\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eannual forecast years\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eMerchandise groups\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eallocated basket groups\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eShowroom\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e1500\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003esquare feet in example\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 Workbook\u003c\/h2\u003e\n\u003cp\u003eThe workbook connects store-specific assumptions to operating calculations, financing schedules, financial statements, and decision reports.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"included-list\"\u003e\n\u003carticle\u003e\u003ch3\u003eRevenue \u0026amp; Calc\u003c\/h3\u003e\n\u003cp\u003eEdit showroom visits, basket conversion, category allocation, realized prices, and launch timing; review the resulting monthly and annual sales forecast.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCOGS \u0026amp; OPEX\u003c\/h3\u003e\n\u003cp\u003eSeparate merchandise purchase and handling costs from payment processing, shrinkage, supported delivery, and recurring showroom overhead.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003ePayroll \u0026amp; CAPEX\u003c\/h3\u003e\n\u003cp\u003ePlan the owner-manager and sales assistant by full-time-equivalent staffing, while tracking fitout, display, point-of-sale, and equipment investments.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDashboard \u0026amp; Scenarios\u003c\/h3\u003e\n\u003cp\u003eSet the reporting case, working-capital days, Low\/Base\/High multipliers, and optional debt facility assumptions in one management area.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eStatements \u0026amp; Decisions\u003c\/h3\u003e\n\u003cp\u003eReview Income Statement, Cash Flow, Balance Sheet, Summary, Returns, Valuation, benchmarks, ratios, and reconciliation checks without assuming any unprovided example values.\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 Antique Store Sales Are Calculated\u003c\/h2\u003e\n\u003cp\u003eMonthly sales are driven by qualified visits multiplied by the purchase conversion rate, with each paid basket assigned to exactly one merchandise group.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe illustrative plan uses 650 showroom visits per month in 2026, increasing to 1,150 by 2030, and a constant 28% purchase conversion. This creates one shared pool of purchases rather than five independent customer counts.\u003c\/p\u003e\n\u003cp\u003eThe five allocated groups are antique furniture, vintage jewelry, art and framed works, ceramics and glass, and collectibles and smalls. The model applies a realized selling price to the basket share in each group; the last allocation is residual.\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 links showroom visits, purchase conversion, category shares, and average sale prices to annual merchandise revenue. The Calc worksheet distributes those inputs across forecast months and applies the store launch date.\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=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative merchandise mix and realized prices\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eMerchandise category\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eBasket share\u003c\/th\u003e\n\u003cth scope=\"col\"\u003ePrice per sale\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eAntique furniture\u003c\/th\u003e\n\u003ctd data-label=\"Basket share\"\u003e18%\u003c\/td\u003e\n\u003ctd data-label=\"Price per sale\"\u003e$650\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eVintage jewelry\u003c\/th\u003e\n\u003ctd data-label=\"Basket share\"\u003e20%\u003c\/td\u003e\n\u003ctd data-label=\"Price per sale\"\u003e$180\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eArt and framed works\u003c\/th\u003e\n\u003ctd data-label=\"Basket share\"\u003e15%\u003c\/td\u003e\n\u003ctd data-label=\"Price per sale\"\u003e$260\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eCeramics and glass\u003c\/th\u003e\n\u003ctd data-label=\"Basket share\"\u003e27%\u003c\/td\u003e\n\u003ctd data-label=\"Price per sale\"\u003e$80\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eCollectibles and smalls\u003c\/th\u003e\n\u003ctd data-label=\"Basket share\"\u003e20%\u003c\/td\u003e\n\u003ctd data-label=\"Price per sale\"\u003e$55\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eThe shares total 100% of one paid-basket demand pool; they are not separate visitor populations.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"formula-text\"\u003e\n\u003cspan class=\"formula-label\"\u003eIllustrative 2026 monthly sales build\u003c\/span\u003e\u003cp\u003e650 visits × 28% = 182 paid baskets; 182 × $224.60 weighted realized price ≈ $40,877 in monthly revenue.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eThe monthly example annualizes to approximately $490,526 in 2026 revenue. The chosen assumptions contain no material seasonality profile, and the forecast activates streams in the full launch month rather than using prelaunch sales.\u003c\/p\u003e\u003c\/div\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\"\u003eOPERATING COSTS\u003c\/span\u003e\u003ch2\u003eHow Inventory, Overhead, and Payroll Affect EBITDA\u003c\/h2\u003e\n\u003cp\u003eDirect merchandise costs, sales-linked expenses, fixed monthly overhead, and role-based salaries each enter operating expenses once.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eEstimated direct costs total 59.5% of revenue: acquisition 55%, inbound transport 2%, outside restoration 2%, and protective packing 0.5%. Variable expenses add payment processing 2.4%, damage and shrinkage 1%, and supported delivery 1%.\u003c\/p\u003e\n\u003cp\u003eFixed overhead includes rent, utilities, insurance, security, marketing, accounting, cleaning, and upkeep. The example budgets $64,800 annually in fixed expenses, including $3,000 monthly showroom rent and occupancy.\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 and Operating Expenses forecast separates acquisition and handling costs, sales-linked variable items, and scheduled fixed charges. It helps show how inventory economics and recurring showroom costs change contribution and EBITDA as sales vary.\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=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eExample annual operating cost structure, USD\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eExpense category\u003c\/th\u003e\n\u003cth scope=\"col\"\u003e2026\u003c\/th\u003e\n\u003cth scope=\"col\"\u003e2030\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eDirect costs (COGS)\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$291,863\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$516,373\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eVariable expenses\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$21,583\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$38,186\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eFixed overhead\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$64,800\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$64,800\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003ePayroll\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$79,000\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$88,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eThese are illustrative forecast costs, rounded to whole dollars. Payroll is not counted inside COGS or variable expenses.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003ePayroll includes one full-time owner-buyer and manager at $52,000 annual base pay, plus a sales and catalog assistant at $36,000 per full-time equivalent. Assistant staffing is 0.75 FTE in 2026–2027 and 1.0 FTE from 2028.\u003c\/p\u003e\n\u003cp\u003eThe documented case excludes employer payroll taxes, benefits, and personal taxes. Operating EBITDA therefore reflects the stated scope rather than a claim about fully burdened wages or net income.\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 schedules each position, compensation basis, and full-time-equivalent staffing level into monthly personnel costs. This makes the assistant staffing change visible without treating the owner’s salary or staff salaries as merchandise acquisition costs.\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\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\"\u003eOPENING CAPITAL\u003c\/span\u003e\u003ch2\u003eHow the Opening Investment Is Organized\u003c\/h2\u003e\n\u003cp\u003eStore setup assets, preopening cash expenses, initial merchandise stock, and a planning reserve are distinct from recurring annual operations.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe hypothetical store includes $24,500 in startup assets for fitout, secure displays, point-of-sale and security equipment, and stock-handling tools. Another $17,000 covers separate prelaunch cash items such as deposits, registration, opening promotion, and preparation.\u003c\/p\u003e\n\u003cp\u003eWorking-capital controls use zero accounts-receivable days, zero accounts-payable days, and 168 inventory days. They reflect immediate customer payment, payment for stock before pickup, and a sizeable inventory holding assumption.\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 fixture and equipment purchases, their spending dates, and applicable depreciation schedules. These capital investments are tracked separately from the revenue-based merchandise acquisition expenses and other operating charges.\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=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative opening owner funding allocation, USD\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eFunding use\u003c\/th\u003e\n\u003cth scope=\"col\"\u003ePlanned amount\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eStartup assets\u003c\/th\u003e\n\u003ctd data-label=\"Planned amount\"\u003e$24,500\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eOther preopening cash\u003c\/th\u003e\n\u003ctd data-label=\"Planned amount\"\u003e$17,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eOpening merchandise stock\u003c\/th\u003e\n\u003ctd data-label=\"Planned amount\"\u003e$134,256\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eThree-month recurring reserve\u003c\/th\u003e\n\u003ctd data-label=\"Planned amount\"\u003e$114,312\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eTotal estimated initial owner funding is $290,068 after rounding. Committed external funding in this example is zero.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eThe reserve equals a default three months of recurring expenses; it has not been proven sufficient for peak cash needs. The CapTable records equity contributions, while Dashboard debt inputs and the Debt sheet allow separate analysis of any financing assumptions a buyer enters.\u003c\/p\u003e\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 organizes equity, potential borrowing, and business receipts against operating payments, capital spending, and retained cash. It supports a funding review without treating the illustrated opening reserve as a verified cash runway.\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\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\"\u003eFIVE-YEAR PROJECTIONS\u003c\/span\u003e\u003ch2\u003eIllustrative Annual Revenue and EBITDA Forecast\u003c\/h2\u003e\n\u003cp\u003eThe documented base planning case projects growing showroom sales while showing all direct costs, variable expenses, fixed overhead, and Payroll through EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative antique store operating 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$490,526\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$457,246\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$33,280\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$603,725\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$529,580\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$74,145\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$716,923\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$610,914\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$106,009\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2029\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$792,389\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$659,136\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$133,252\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2030\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$867,854\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$707,359\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$160,495\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eHypothetical 2026–2030 forecast; original calculations use more precision than these whole-dollar display values.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eIn this example, EBITDA rises from $33,280 in 2026 to $160,495 in 2030 as monthly showroom visits increase and the sales mix and selling prices remain at their selected levels. The result is an operating forecast, not historical performance.\u003c\/p\u003e\n\u003cp\u003eThe workbook also includes an Income Statement, Balance Sheet, Cash Flow, Summary, charts, and consistency checks. Their functions are available for planning, but the example brief does not establish net profit, account balances, or a particular cash balance.\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 separates operating, investing, and financing cash movements and reconciles opening to closing cash. It can expose funding needs from inventory, capital purchases, and repayment schedules that EBITDA alone does not show.\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\u003eEBITDA is not cash or net profit\u003c\/strong\u003e\u003cp\u003eThe supplied scenario ends at EBITDA. It does not prove cash sufficiency or establish taxes, net earnings, return on investment, or investment payback.\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\"\u003eRETURNS \u0026amp; SENSITIVITY\u003c\/span\u003e\u003ch2\u003eHow to Examine Break-Even and Investment Returns\u003c\/h2\u003e\n\u003cp\u003eReturns and scenarios help test different business questions beyond the provided operating EBITDA forecast.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eThe Returns worksheet distinguishes sales break-even from cash break-even, tracks project cash flow toward investment payback, and evaluates annual return on invested capital. None of those measures can be read directly from the supplied EBITDA figures.\u003c\/p\u003e\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 Returns analysis displays break-even calculations, cash recovery and investment payback, and return on invested capital based on the relevant workbook schedules. It is designed for testing a store investment without asserting an unsupported payback date or ROIC.\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\u003eThe Dashboard provides Low, Base, and High multipliers for revenue, direct costs, variable expenses, fixed costs, and Payroll. Comparing those cases is useful when visits, selling prices, stock purchase economics, or occupancy costs depart from the example.\u003c\/p\u003e\n\u003cp\u003eValuation and benchmarks are separate workbook analyses. A DCF value depends on entered discount and terminal assumptions, while benchmark comparisons depend on user-selected references; neither establishes a verified market value or industry average.\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 outcomes for revenue, gross margin, contribution margin, and EBITDA. It lets a store owner review sensitivity to changing assumptions without presenting any scenario as a guaranteed business result.\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-fit\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eBEST USE CASES\u003c\/span\u003e\u003ch2\u003eWho This Financial Model Is Built For\u003c\/h2\u003e\n\u003cp\u003eThis workbook suits an owned-stock antique retail concept where one showroom sells merchandise directly to customers.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eUse it to draft a new-store business plan, compare traffic and category pricing assumptions, plan opening inventory and fixtures, or discuss potential financing with an adviser. Replace the sample estimates with your actual lease, supplier terms, marketing plan, staffing, and sales assumptions.\u003c\/p\u003e\n\u003cp\u003eThe reference case does not model consignment commissions, dealer booth rental, or staff-constrained appointment capacity. Businesses with those mechanics should revise the revenue engine rather than reuse this example unchanged.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cp class=\"text-link-row\"\u003e\u003ca class=\"text-link\" href=\"https:\/\/financialmodelslab.com\/products\/custom-financial-modeling-services\"\u003eDiscuss a custom financial model\u003c\/a\u003e\u003c\/p\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\"\u003eFREQUENTLY ASKED QUESTIONS\u003c\/span\u003e\u003ch2\u003eQuestions About the Antique Store Excel Model\u003c\/h2\u003e\n\u003cp\u003eThese answers clarify editable inputs, the example assumptions, and the distinction between operating projections and investment decisions.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eCan I change customer visits and purchase conversion?\u003c\/h3\u003e\n\u003cp\u003eYes. Edit qualified showroom visits and conversion assumptions in Revenue; the model recalculates the paid-basket pool and merchandise sales.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the forecast count a customer in multiple categories?\u003c\/h3\u003e\n\u003cp\u003eNo. Each modeled paid basket is allocated once across the five principal merchandise groups using shares totaling 100%.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I update merchandise prices and acquisition costs?\u003c\/h3\u003e\n\u003cp\u003eYes. Edit category realized prices and the relevant COGS assumptions to test different revenue and gross margin outcomes.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the sample cover consignment or dealer booths?\u003c\/h3\u003e\n\u003cp\u003eNo. The sample represents store-owned inventory bought outright, not consignment sales or rented dealer booths.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre the example 2026–2030 amounts actual store results?\u003c\/h3\u003e\n\u003cp\u003eNo. They are hypothetical U.S.-dollar projections based on estimated inputs for a single Columbus showroom.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre fixed salaries included in merchandise costs?\u003c\/h3\u003e\n\u003cp\u003eNo. Owner and assistant base salaries flow through Payroll separately from COGS, variable expenses, and fixed overhead.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the $290,068 funding estimate guarantee enough cash?\u003c\/h3\u003e\n\u003cp\u003eNo. It\nincludes a default three-month reserve, not a tested maximum cash requirement; use Cash Flow to evaluate liquidity.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan the workbook evaluate payback and alternative cases?\u003c\/h3\u003e\n\u003cp\u003eYes. Returns supports break-even, payback, and ROIC analysis, while Dashboard scenario controls compare Low, Base, and High assumptions.\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":48217972998387,"sku":"antique-store-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/antique-store-financial-model-headimage-financialmodelslab_d50e216a-f68c-4a98-8a19-d9c7f52c792e.webp?v=1765296900","url":"https:\/\/finmodelslab.myshopify.com\/products\/antique-store-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}