{"product_id":"donut-shop-financial-model","title":"Donut Shop 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\u003eThe \u003cstrong\u003eDonut Shop Financial Model\u003c\/strong\u003e is an Excel financial model for planning an independent retail donut bakery. It turns daily paid orders, five basket prices, operating costs, staffing, and startup investment assumptions into a monthly forecast and connected financial reports.\u003c\/p\u003e\n\u003cp\u003eThe illustrated case represents a 1,200-square-foot suburban U.S. bakery with counter service and prepaid pickup, trading 26 days per month. The forecast covers 2026 through 2030; its assumptions and outcomes are estimates, not actual store performance or industry averages.\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\"\u003eannual forecast years\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eBasket types\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eexclusive sales categories\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eTrading days\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e26\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eper modeled month\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eStaff roles\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e4\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eseparate payroll plans\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\"\u003eWHAT IS INCLUDED\u003c\/span\u003e\u003ch2\u003eAn Integrated Donut Shop Planning Workbook\u003c\/h2\u003e\n\u003cp\u003eThe template links bakery-specific operating inputs to monthly calculations, financial statements, and decision-oriented reporting.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"included-list\"\u003e\n\u003carticle\u003e\u003ch3\u003eRevenue and Calc\u003c\/h3\u003e\n\u003cp\u003eSet orders, trading days, basket shares, and selling prices. Calc builds monthly sales by basket.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCOGS \u0026amp; OPEX and Payroll\u003c\/h3\u003e\n\u003cp\u003ePlan ingredients, packaging, processing, marketing, overhead, and staffing separately.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCAPEX, CapTable and Debt\u003c\/h3\u003e\n\u003cp\u003eSchedule bakery assets, equity contributions, and optional debt facilities, including repayments and interest.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eIS, CF and BS\u003c\/h3\u003e\n\u003cp\u003eReview projected income, cash flow, and balance sheet reports; supplied case results stop at EBITDA.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eScenarios and Management Reports\u003c\/h3\u003e\n\u003cp\u003eCompare scenarios with Dashboard, Returns, Sources \u0026amp; Uses, Valuation, Charts, and Checks.\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 BUILD\u003c\/span\u003e\u003ch2\u003eHow Daily Donut Orders Become Sales\u003c\/h2\u003e\n\u003cp\u003eRevenue is driven by one paid-order pool, allocated among five complete basket types rather than independently forecast product quantities.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eEdit orders, trading days, basket allocations, and annual prices. Categories are Single Classic Donut, Donuts and Coffee Combo, Classic Half Dozen, Classic Dozen, and Premium Dozen.\u003c\/p\u003e\n\u003cp\u003eShares are 20%, 30%, 20%, 20%, and 10%, with the fifth calculated as a residual. The combo includes coffee once.\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 translates one pool of daily paid orders into basket quantities and revenue using trading days, mix percentages, and complete ticket prices. Adjust demand or realized price to see how each sales stream changes.\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\"\u003eIllustrative 2026 monthly revenue\u003c\/span\u003e\u003cp\u003e110 paid orders per day × 26 trading days × $10.50 weighted basket price = $30,030 per modeled month.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eDaily orders rise from 110 to 160 by 2030, with 26 trading days monthly. The 2026 weighted ticket is $10.50.\u003c\/p\u003e\n\u003cp\u003eOrders are zero before the January 31, 2026 launch; that month is modeled in full. There is no separate capacity constraint, wholesale, or marketplace delivery.\u003c\/p\u003e\n\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\u003eDirect Costs, Overhead and Staff Pay\u003c\/h2\u003e\n\u003cp\u003eThe expense forecast separates sales-linked ingredient and selling costs, monthly overhead, and base salaries so each component is counted once.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eIngredients cost 26% of revenue; packaging costs 3%. Card processing declines from 3.8% to 3.6%, and local marketing remains 2%.\u003c\/p\u003e\n\u003cp\u003eFixed costs cover rent, utilities, insurance, cleaning, repairs, bookkeeping, software, communications, and licenses. Monthly rent rises from $3,000 to $3,375.\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 direct food and packaging costs from variable payment and marketing charges and recurring fixed shop expenses. It helps test the EBITDA effect of changes in sales and cost assumptions.\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\u003caside class=\"callout\"\u003e\u003cstrong\u003eIllustrative 2026 cost structure\u003c\/strong\u003e\u003cp\u003eThe case has $104,504 COGS, $20,901 variable expenses, $63,900 fixed expenses, and $140,400 payroll, without duplicate wages.\u003c\/p\u003e\u003c\/aside\u003e\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 organizes FTE, annual salaries, and staffing schedules for the shop manager, lead baker, assistant baker, and counter associates. Salary planning is separate from ingredient and overhead assumptions to avoid counting the same wages twice.\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\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe manager earns $48,000 and lead baker $40,000 annually. By 2030 assistant bakers rise from 0.6 to 1.0 FTE; counter associates rise from 1.0 to 1.4 FTE, at $34,000 and $32,000 per FTE.\u003c\/p\u003e\n\u003cp\u003eThe illustrative expense scope excludes employer payroll taxes, benefits, and personal taxes; tailor these to your location.\u003c\/p\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\"\u003eSTARTUP INVESTMENT\u003c\/span\u003e\u003ch2\u003eEquipment, Opening Cash and Funding\u003c\/h2\u003e\n\u003cp\u003eOpening investment is planned independently of ongoing shop expenses and EBITDA, including equipment, preopening payments, working capital, and reserves.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eStartup assets include $24,000 for fryer\/mixer\/proofing equipment, $20,000 for ventilation\/fire suppression, $9,500 for refrigeration, and $6,500 for display fixtures, plus other bakery equipment.\u003c\/p\u003e\n\u003cp\u003eOther opening payments cover permits, refundable deposits, preopening training and payroll, and launch marketing; they are outside annual operating expenses.\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 schedules bakery equipment and other eligible capital purchases, alongside depreciation and net book value. It distinguishes asset spending from the operating cost assumptions used to calculate EBITDA.\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\u003cp\u003eWorking-capital controls are zero receivable days, seven payable days, and 14 inventory days. Estimated owner funding of $235,431 includes opening assets, cash uses, working capital, and a three-month outflow reserve.\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, debt, cash receipts, operating payments, and investment spending over a selected period. Use it to connect the opening bakery budget with the planned funding mix and cash allocation.\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\u003eOpening funding is not profit\u003c\/strong\u003e\u003cp\u003eOwner funding is neither revenue nor EBITDA, and the reserve does not prove cash sufficiency.\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\"\u003eFIVE-YEAR FORECAST\u003c\/span\u003e\u003ch2\u003eIllustrative Annual Revenue and EBITDA\u003c\/h2\u003e\n\u003cp\u003eThe example shows how changes in paid-order volume, basket pricing, shop expenses, and staffing flow into projected operating EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative donut shop 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$360,360\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$329,705\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$30,655\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$421,785\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$359,335\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$62,450\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$486,508\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$390,578\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$95,930\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2029\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$536,843\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$416,352\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$120,491\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2030\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$589,855\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$443,610\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$146,245\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eForecast estimates rounded to whole dollars; totals may differ slightly due to displayed rounding.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eRevenue rises from $360,360 to $589,855, and expenses from $329,705 to $443,610. EBITDA rises from $30,655 to $146,245 between 2026 and 2030.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eEBITDA is not net profit or free cash flow.\u003c\/strong\u003e Depreciation, interest, tax, investment purchases, working-capital movements, and financing activity require their own schedules before assessing accounting earnings or liquidity.\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 tracks operating, investing, and financing cash movements and reconciles opening to closing cash. Review it separately from EBITDA to assess the timing of equipment outlays, debt service, owner contributions, and potential liquidity shortfalls.\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\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eMonthly Income Statement, Balance Sheet, and Summary reports are included, but the source supplies no net profit, closing cash, or debt balance values.\u003c\/p\u003e\u003c\/div\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\"\u003eDECISIONS AND RETURNS\u003c\/span\u003e\u003ch2\u003eBreak-Even, Payback and Scenario Testing\u003c\/h2\u003e\n\u003cp\u003eUse the model reports to evaluate required sales, operating profitability, cash recovery, and sensitivity without treating those measures as interchangeable.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eReturns separates sales break-even, cash break-even, investment payback, and annual ROIC. Sales break-even tests operating cost coverage; the other measures depend on cash timing or invested capital.\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 brings together break-even requirements, project cash flows, investment payback, and ROIC. It supports questions about operating cost coverage and invested-capital efficiency without equating an EBITDA margin with a cash payback period.\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\u003cp\u003eLow, Base, and High controls vary revenue, cost rates, overhead, and payroll. Compare staffing and pricing choices; the annual table is not a tested downside result.\u003c\/p\u003e\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 revenue, gross margin, contribution margin, and EBITDA projections. It helps identify which changes to ticket demand, pricing, expense rates, or staffing assumptions most affect modeled operating performance.\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\u003caside class=\"callout\"\u003e\u003cstrong\u003eNo invented return figures\u003c\/strong\u003e\u003cp\u003eNo payback month, IRR, ROIC rate, funding approval, or tested cash adequacy is established.\u003c\/p\u003e\u003c\/aside\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\"\u003ePLANNING APPLICATIONS\u003c\/span\u003e\u003ch2\u003eWhen This Donut Bakery Model Fits\u003c\/h2\u003e\n\u003cp\u003eThe template is suited to evaluating an independent counter-service donut shop with one physical retail location and a tightly defined paid-basket mix.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003ePrepare budgets, test order volumes and staff coverage, model cost pressures, and review reports with advisers or financing partners.\u003c\/p\u003e\n\u003cp\u003eThe example excludes franchises, wholesale, and marketplace delivery. Shops using these channels must adapt revenue, fees, payment timing, and staffing.\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\"\u003eFREQUENT QUESTIONS\u003c\/span\u003e\u003ch2\u003eQuestions About the Donut Shop Model\u003c\/h2\u003e\n\u003cp\u003eThese answers clarify the operating assumptions, workbook functions, and limits of the illustrated financial projections.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eCan I edit the daily order forecast?\u003c\/h3\u003e\n\u003cp\u003eYes. Edit daily paid orders, monthly trading days, basket mix, and annual prices.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eHow does the model avoid counting coffee twice?\u003c\/h3\u003e\n\u003cp\u003eEach order belongs to one basket, and coffee is included once in the combo price.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the model include bakery employees?\u003c\/h3\u003e\n\u003cp\u003eYes. Payroll separately plans four roles using salaries and FTE.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre bakery equipment costs included in EBITDA?\u003c\/h3\u003e\n\u003cp\u003eNo. CAPEX and opening cash are separate; asset purchases and depreciation have their own schedules.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre cash flow and balance sheet reports included?\u003c\/h3\u003e\n\u003cp\u003eYes. Cash Flow and Balance Sheet reports are included, while illustrated case outputs stop at EBITDA.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I compare downside and upside cases?\u003c\/h3\u003e\n\u003cp\u003eYes. Scenario controls compare Low, Base, and High operating assumptions and profitability.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the forecast guarantee profit or financing?\u003c\/h3\u003e\n\u003cp\u003eNo. Estimates do not establish net profit, lending eligibility, payback timing, or cash sufficiency.\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":48217945669875,"sku":"donut-shop-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/donut-shop-financial-model-headimage-financialmodelslab_72e4f712-797e-4168-bd6b-d92cba0e98e5.webp?v=1765295930","url":"https:\/\/finmodelslab.myshopify.com\/products\/donut-shop-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}