{"product_id":"mexican-restaurant-financial-model","title":"Mexican Restaurant Financial Model Template in Excel","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 Mexican Restaurant Financial Model is an Excel planning template for an independent 80-seat restaurant serving lunch, dinner, direct pickup, and a small bar. It links guest demand, menu mix, prices, staffing, operating costs, startup spending, working capital, and funding to monthly and annual projections.\u003c\/p\u003e\n\u003cp\u003eThe illustrated case is demand-driven. One shared pool of paid guest visits becomes menu items that are allocated once across six food and drink categories; sales tax and customer gratuities are excluded from revenue.\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\u003eRevenue streams\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e6\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003emenu categories\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eGuest items\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e2.3\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eitems per guest\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eSeat count\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e80\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003erestaurant seats\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\u003eWhat the Restaurant Model Covers\u003c\/h2\u003e\n\u003cp\u003eThe workbook connects operating assumptions to detailed calculations, financial statements, scenario analysis, funding schedules, and management 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\u003eRevenue inputs define launch timing, guest visits, items per guest, seasonality, category mix, and menu prices. Calc converts them into monthly item volumes and sales.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCosts \u0026amp; Payroll\u003c\/h3\u003e\n\u003cp\u003eCOGS \u0026amp; OPEX separates direct, variable, and fixed costs. Payroll plans annual-average FTE and fixed base salaries by restaurant role.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eInvestment \u0026amp; Funding\u003c\/h3\u003e\n\u003cp\u003eCAPEX schedules opening assets. CapTable, debt controls, Debt, and Sources \u0026amp; Uses support equity, financing, and cash-allocation planning.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eReports \u0026amp; Analysis\u003c\/h3\u003e\n\u003cp\u003eIS, CF, BS, Summary, Scenarios, Returns, Valuation, Ratios, Charts, Top_Revenue, Top_Expenses, and Checks provide linked financial analysis and reconciliations.\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 Restaurant Revenue\u003c\/h2\u003e\n\u003cp\u003eRevenue starts with paid guest visits, multiplies them by 2.3 items per guest, applies seasonality, and allocates the item pool across six menu categories at annual net prices.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003ePaid guest visits rise from 2,600 per month in 2026 to 3,400 in 2030 before seasonality. The monthly pattern ranges from 0.90 in January and February to 1.10 in May and June.\u003c\/p\u003e\n\u003cp\u003eFive editable category shares plus residual nonalcoholic drinks total 100%. Category revenue equals allocated items multiplied by annual net price, so the shared demand pool is counted 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 shows guest visits, items per guest, menu mix, seasonality, annual prices, and revenue by stream. These inputs feed monthly Calc and annual sales.\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 average monthly demand\u003c\/span\u003e\u003cp\u003e2,600 paid guest visits × 2.3 items per guest = 5,980 menu items before monthly seasonality.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003caside class=\"callout\"\u003e\u003cstrong\u003eDemand-based model\u003c\/strong\u003e\u003cp\u003eNo separate seating-capacity limiter is applied; users control demand directly through paid guest visits and seasonality.\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\"\u003eCOST STRUCTURE\u003c\/span\u003e\u003ch2\u003eHow Costs and Staffing Flow to EBITDA\u003c\/h2\u003e\n\u003cp\u003eThe model separates restaurant COGS, sales-linked variable expenses, fixed overhead, and Payroll so each payment component is counted once.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eCOGS uses 25.5% for food ingredients and waste, 4.5% for beverage ingredients and shrink, and 1.2% for serving consumables. Variable expenses add 2.8% merchant processing and 1.2% sales-linked promotions.\u003c\/p\u003e\n\u003cp\u003eFixed costs include rent, utilities, insurance, cleaning, maintenance, software, licenses, professional services, linen, and smallwares. Rent starts at $6,500 per month in 2026.\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 organizes direct, variable, and fixed restaurant costs by category and timing. It shows how operating assumptions affect contribution and EBITDA.\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\u003eIllustrative restaurant operating expenses, USD\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eCategory\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\"\u003eCOGS\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$305,164\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$449,178\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eVariable\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$39,124\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$57,587\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eFixed\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$149,400\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$168,151\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003ePayroll\u003c\/th\u003e\n\u003ctd data-label=\"2026\"\u003e$337,000\u003c\/td\u003e\n\u003ctd data-label=\"2030\"\u003e$390,400\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eIllustrative forecast amounts rounded to whole dollars.\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 FTE and salary assumptions for the general manager, cooks, bartenders, servers, and dish\/preparation staff. Payroll remains separate from COGS and operating expenses.\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\"\u003eSTARTUP \u0026amp; FUNDING\u003c\/span\u003e\u003ch2\u003eHow Startup Spending Differs From EBITDA\u003c\/h2\u003e\n\u003cp\u003eOpening investment is modeled separately from annual operating expenses, distinguishing CAPEX, preopening cash, working capital, and owner funding from EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe case includes $85,000 of leasehold improvements, $65,000 of kitchen and refrigeration equipment, $18,000 of bar equipment, and $22,000 of ventilation and fire suppression, plus other opening assets.\u003c\/p\u003e\n\u003cp\u003ePreopening cash covers deposits, permits, licensing, setup labor, launch marketing, professional setup, and cleaning. Working-capital controls use 0 receivable days, 7 payable days, and 7 inventory days.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"capex\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCapital Expenditure Plan\u003c\/h3\u003e\n\u003cp\u003eThe Capital Expenditure Plan schedules restaurant assets, purchase dates, depreciable status, and depreciation. It keeps durable investment separate from operating expenses.\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\u003eInitial owner funding is $482,985 in the illustrated case. It covers durable assets, distinct preopening payments, opening working capital, and three months of first-year operating outflows; no committed outside financing is assumed.\u003c\/p\u003e\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"funding\" data-fml-side=\"right\"\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 funding sources with restaurant cash uses, including operations, investment, debt, equity, and retained cash. It supports funding review without treating EBITDA as cash.\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\"\u003eILLUSTRATIVE FORECAST\u003c\/span\u003e\u003ch2\u003eWhat the Five-Year Forecast Shows\u003c\/h2\u003e\n\u003cp\u003eThe illustrated base case grows revenue from $978,089 in 2026 to $1,439,675 in 2030 while EBITDA rises from $147,402 to $374,358.\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$978,089\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$830,687\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$147,402\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,084,888\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$872,762\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$212,125\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,197,313\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$943,652\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$253,660\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,315,350\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,003,306\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$312,043\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,439,675\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,065,317\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$374,358\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eIllustrative projections rounded to whole dollars.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eRevenue growth reflects higher guest demand and annual menu pricing, while expenses rise through ingredients, sales-linked spending, rent, and staffing. EBITDA is an operating measure, not net profit or available cash.\u003c\/p\u003e\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"cashflow\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCash Flow Forecast\u003c\/h3\u003e\n\u003cp\u003eThe Cash Flow Forecast shows operating, investing, and financing cash movements with an opening-to-closing cash reconciliation. Use it for liquidity review because EBITDA excludes asset purchases and financing 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\u003eProjection boundary\u003c\/strong\u003e\u003cp\u003eThe documented operating case ends at EBITDA; the displayed EBITDA is not net income, free cash flow, or tested cash sufficiency.\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; DECISIONS\u003c\/span\u003e\u003ch2\u003eWhat Break-Even and Returns Help Evaluate\u003c\/h2\u003e\n\u003cp\u003eReturns and scenario tools help test cost coverage, liquidity timing, recovery of invested capital, and operating resilience when assumptions change.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eReturns separates sales break-even, cash break-even timing, investment payback, and annual ROIC. No payback month, ROIC result, IRR, or valuation amount is stated because the supplied restaurant case does not document those outputs.\u003c\/p\u003e\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"returns\" data-fml-side=\"right\"\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 break-even, free cash flow, payback, invested capital, and annual ROIC. It evaluates investment returns without substituting EBITDA for cash-based measures.\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\u003eDashboard Scenario Controls apply Low, Base, and High multipliers to revenue, COGS, variable expenses, fixed expenses, and payroll for comparative profitability analysis.\u003c\/p\u003e\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"scenarios\" data-fml-side=\"left\"\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. It shows how changes in demand and costs alter restaurant profitability.\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\"\u003eMODEL FIT\u003c\/span\u003e\u003ch2\u003eWhere This Restaurant Model Fits\u003c\/h2\u003e\n\u003cp\u003eThe template is designed for an independent U.S. Mexican restaurant with one guest-demand pool, six menu categories, table service, direct pickup, and a small bar.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe illustrated format assumes an 80-seat, 2,800-square-foot leased second-generation location and excludes franchise fees, delivery marketplaces, catering, and ticket income. Buyers with different channels can update the operating assumptions.\u003c\/p\u003e\n\u003cp\u003eGuest demand, menu prices, mix, staffing, costs, startup investment, working-capital days, equity, debt, and scenario multipliers are editable for a specific plan.\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\"\u003eFAQ\u003c\/span\u003e\u003ch2\u003eMexican Restaurant Financial Model FAQ\u003c\/h2\u003e\n\u003cp\u003eThese answers summarize the main mechanics and boundaries of the restaurant template.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eHow does the model calculate restaurant revenue?\u003c\/h3\u003e\n\u003cp\u003eIt multiplies paid guest visits by 2.3 items per guest, applies seasonality, allocates items across six categories, and multiplies each category by its annual net price.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I change the menu mix and prices?\u003c\/h3\u003e\n\u003cp\u003eYes. Category shares and annual prices are editable, with the final category share calculated as the residual needed to reach 100%.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the model include payroll?\u003c\/h3\u003e\n\u003cp\u003eYes. Payroll is planned separately by role using annual-average FTE, active months, and fixed annual base salary per FTE.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre startup costs included in EBITDA?\u003c\/h3\u003e\n\u003cp\u003eNo. Startup assets, preopening cash, working capital, and funding are modeled separately from annual operating expenses and EBITDA.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes it include cash flow and balance sheet reports?\u003c\/h3\u003e\n\u003cp\u003eYes. The workbook includes projected Cash Flow and Balance Sheet reports, but this description does not invent statement values absent from the documented case.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I test different scenarios?\u003c\/h3\u003e\n\u003cp\u003eYes. Low, Base, and High controls can adjust revenue, COGS, variable expenses, fixed expenses, and payroll.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the model calculate break-even and payback?\u003c\/h3\u003e\n\u003cp\u003eReturns includes sales break-even, cash break-even timing, investment payback, and annual ROIC, without claiming a specific result until the workbook is completed.\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":48217946947827,"sku":"mexican-restaurant-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/mexican-restaurant-financial-model-headimage-financialmodelslab_c2538b28-a1ee-4682-a938-a5b3a0e6c73d.webp?v=1765295983","url":"https:\/\/finmodelslab.myshopify.com\/products\/mexican-restaurant-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}