{"product_id":"makeup-line-financial-model","title":"Makeup Line Financial Projections Template in Excel","description":"\u003cstyle data-fml-style=\"10-safe-dom\"\u003e\/* 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\u003cdiv class=\"description-intro\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"intro-copy\"\u003e\n\u003cp\u003eThis Makeup Line Financial Model is an Excel template for a Dallas-based own-label color cosmetics brand using outsourced US stock-formula manufacturing, supplier-filled retail packs, third-party fulfillment, and national DTC and wholesale sales. It converts purchasing-account demand, units per account, seasonality, channel mix, realized prices, costs, staffing, startup inputs, and working capital into financial projections.\u003c\/p\u003e\n\u003cp\u003eThe illustrated case covers 2026 through 2030 and ends its operating forecast at EBITDA. Startup funding, CAPEX, working-capital assumptions, debt controls, cash flow, financial statements, break-even, payback, ROIC, scenarios, valuation, and other workbook reports remain separate analytical layers rather than being inferred from EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdl class=\"product-facts\"\u003e\n\u003cdiv\u003e\n\u003cdt\u003eForecast\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cspan class=\"fact-value\"\u003e5\u003c\/span\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\u003cspan class=\"fact-value\"\u003e6\u003c\/span\u003e\u003cspan class=\"fact-detail\"\u003eproduct channels\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\u003cspan class=\"fact-value\"\u003e3\u003c\/span\u003e\u003cspan class=\"fact-detail\"\u003eplanned roles\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003c\/dl\u003e\n\u003c\/div\u003e\u003c\/div\u003e\n\u003csection id=\"fml-included\" class=\"section soft-section\"\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 Makeup Line Model\u003c\/h2\u003e\n\u003cp\u003eThe workbook links industry-specific operating assumptions to monthly calculations, statements, funding schedules, scenario analysis, and management reports.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"included-list\"\u003e\n\u003carticle\u003e\u003ch3\u003eRevenue \u0026amp; Monthly Calc\u003c\/h3\u003e\n\u003cp\u003eRevenue and Calc turn purchasing accounts, units per purchasing account, a repeating monthly demand profile, six exclusive product\/channel shares, and net realized prices into monthly and annual sales without duplicating the unit pool.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCosts \u0026amp; Staffing\u003c\/h3\u003e\n\u003cp\u003eCOGS \u0026amp; OPEX separates finished cosmetics, freight, fulfillment, marketing, processing, returns, stock losses, credit losses, and fixed overhead, while Payroll models the owner and operating staff by role, FTE, salary, and timing.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eFunding \u0026amp; Assets\u003c\/h3\u003e\n\u003cp\u003eCAPEX records equipment and depreciation inputs, CapTable records owner equity, Dashboard Debt Controls feed financing schedules, and Sources \u0026amp; Uses explains how operating receipts, equity, debt, investment, and cash retention interact.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eStatements \u0026amp; Analysis\u003c\/h3\u003e\n\u003cp\u003eIS, CF, BS, Summary, Scenarios, Returns, Valuation, Ratios, DuPont, Charts, Benchmarks, Top_Revenue, and Top_Expenses provide profitability, liquidity, financial position, scenario, return, valuation, and driver analysis using the model outputs.\u003c\/p\u003e\u003c\/article\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection id=\"fml-revenue\" class=\"section\"\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 Makeup Revenue\u003c\/h2\u003e\n\u003cp\u003eSales are demand-driven: monthly purchasing accounts are multiplied by units per account and seasonality, then allocated once across six exclusive product and channel streams.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe base case uses 900 monthly purchasing accounts in 2026, rising to 2,400 in 2030, with 2.5 units per purchasing account. A single January-through-December demand profile adjusts monthly finished units before product\/channel allocation.\u003c\/p\u003e\n\u003cp\u003eFour DTC streams and two wholesale streams then receive exclusive shares totaling 100%. Revenue equals allocated finished units multiplied by each stream’s net realized unit price, including $18 DTC lip color, $26 DTC complexion, and $12 wholesale color makeup.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eRevenue Forecast\u003c\/h3\u003e\n\u003cp\u003eThe Revenue Forecast shows the purchasing-account driver, units per account, monthly seasonality, six exclusive channel shares, and realized prices that build monthly and annual sales. This makes volume, mix, and pricing assumptions editable without counting the same finished units twice.\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 annual demand logic\u003c\/span\u003e\u003cp\u003e900 monthly purchasing accounts × 2.5 units per account × monthly seasonality × 100% allocated mix = finished units sold by stream.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection id=\"fml-costs\" class=\"section soft-section\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eCOSTS AND PAYROLL\u003c\/span\u003e\u003ch2\u003eHow Operating Costs and Staffing Affect EBITDA\u003c\/h2\u003e\n\u003cp\u003eThe model separates direct COGS, revenue-linked operating costs, monthly fixed expenses, and fixed-salary payroll so each payment component is counted once.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCOGS \u0026amp; Operating Expense Forecast\u003c\/h3\u003e\n\u003cp\u003eThe COGS \u0026amp; Operating Expense Forecast separates finished cosmetics and retail packs, inbound freight, fulfillment and shipping, variable selling costs, and monthly fixed overhead. These assumptions feed gross margin, contribution margin, and EBITDA without mixing payroll into COGS or fixed operating expense categories.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic10]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eCOGS assumptions are 32% for finished cosmetics and retail packs, 1% for inbound freight, and 8% for third-party fulfillment and shipping. Variable operating costs include 14% performance marketing and affiliates, 2.8% payment processing, 1.2% return handling, 1% damaged or obsolete stock, and 0.3% wholesale credit losses.\u003c\/p\u003e\n\u003cp\u003eFixed coverage includes the serviced office, commerce software, insurance, safety and regulatory review, creative development, professional administration, 3PL base storage and receiving, communications, office equipment maintenance, and wholesale travel. The serviced brand office example is $1,000 per month for 12 paid months.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003ePayroll Forecast\u003c\/h3\u003e\n\u003cp\u003eThe Payroll Forecast shows planned FTE and fixed base salary by role, including the working brand owner, customer and stockist operations, and the brand marketing coordinator. It lets staffing scale separately from revenue-linked expenses while keeping payroll out of COGS and other expense buckets.\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=\"callout\"\u003e\n\u003cstrong\u003eNo double counting\u003c\/strong\u003e\u003cp\u003eThe listed salaries are modeled through Payroll and are excluded from COGS, Variable, and Fixed operating expense inputs.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection id=\"fml-startup\" class=\"section startup-section\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eSTARTUP AND FUNDING\u003c\/span\u003e\u003ch2\u003eHow Startup Assets and Opening Funding Are Modeled\u003c\/h2\u003e\n\u003cp\u003eStartup equipment, prelaunch cash items, working-capital days, and owner funding are tracked separately from recurring operating expenses and EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" 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 records startup equipment such as computers and monitors, photography and lighting equipment, and reusable sample display equipment. Depreciable asset schedules remain distinct from recurring operating expenses and from separate preopening cash items.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic9]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe case includes $6,000 for computers and monitors, $3,500 for photography and lighting equipment, and $1,500 for reusable sample display equipment. Separate opening cash items cover the office deposit, label and brand setup, prelaunch screening, launch campaign, legal review, preopening payroll, office services, and setup fees.\u003c\/p\u003e\n\u003cp\u003eWorking-capital controls use 5 accounts-receivable days, 0 accounts-payable days, and 72 inventory days. Initial owner funding is $219,615 and is designed around startup assets, distinct prelaunch cash, opening net working capital, and three months of recurring cash outflows; it is not operating revenue.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" 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 operating receipts, equity, debt, operating payments, investment, financing payments, and cash retained in the business. It helps distinguish opening owner funding and asset purchases from the EBITDA generated by ongoing makeup sales.\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 id=\"fml-forecast\" class=\"section\"\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 Operating Forecast Shows\u003c\/h2\u003e\n\u003cp\u003eThe documented base case grows revenue from $519,210 in 2026 to $1,384,560 in 2030 while EBITDA rises from $24,526 to $231,870.\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$519,210\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$494,684\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$24,526\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$692,280\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$638,845\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$53,435\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$923,040\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$806,393\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$116,647\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,153,800\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$971,341\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$182,459\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,384,560\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$1,152,690\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$231,870\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eIllustrative model outputs rounded to whole dollars; source calculations retain original precision.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eThe forecast reflects higher purchasing accounts, the same 2.5 units per account, the repeating monthly demand profile, product\/channel mix, realized prices, and the defined cost structure. EBITDA is an operating result and should not be treated as net profit or as proof of cash sufficiency.\u003c\/p\u003e\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" 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 tracks operating, investing, and financing cash movements and reconciles opening to closing cash. It is the appropriate report for testing liquidity and funding needs because EBITDA does not include working-capital movements, capital spending, debt flows, or equity funding.\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\u003c\/div\u003e\u003c\/section\u003e\u003csection id=\"fml-returns\" class=\"section soft-section\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eBREAK-EVEN AND RETURNS\u003c\/span\u003e\u003ch2\u003eWhat Break-Even, Payback, and ROIC Can Evaluate\u003c\/h2\u003e\n\u003cp\u003eThe Returns report separates operating break-even, cash break-even timing, investment payback, and annual ROIC rather than treating them as one return measure.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eReturn on Invested Capital Analysis\u003c\/h3\u003e\n\u003cp\u003eThe Return on Invested Capital Analysis combines sales break-even, cash break-even timing, project and cumulative free cash flow, investment payback, invested capital, and annual ROIC. It supports return analysis without assuming a payback month or ROIC value that is not documented in the supplied case.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic4]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eSales break-even asks how much revenue is needed to cover the modeled cost structure. Cash break-even considers actual cash generation and timing, while payback measures when cumulative project cash flow recovers invested funds and ROIC compares operating returns with invested capital.\u003c\/p\u003e\n\u003cp\u003eDashboard Scenario Controls can apply Low, Base, and High multipliers to revenue, COGS, variable expenses, fixed expenses, and payroll. Valuation can then use discounted unlevered free cash flow and terminal assumptions, but no valuation result is claimed here because the supplied case does not provide one.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" 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 cases for revenue, gross margin, contribution margin, and EBITDA. It helps test how changes in sales and cost assumptions affect operating profitability before a user relies on the base-case forecast.\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 id=\"fml-fit\" class=\"section\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eMODEL FIT\u003c\/span\u003e\u003ch2\u003eWhere This Makeup Line Model Fits\u003c\/h2\u003e\n\u003cp\u003eThe structure fits an outsourced US color-cosmetics brand with DTC and wholesale demand, third-party fulfillment, a small office team, and no owned manufacturing or retail store.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"use-cases\"\u003e\n\u003carticle class=\"use-case\"\u003e\u003ch3\u003eHow much product demand is needed?\u003c\/h3\u003e\n\u003cp\u003eEdit purchasing accounts, units per account, seasonality, mix, and realized prices; review monthly and annual revenue, margins, EBITDA, cash flow, and break-even outputs.\u003c\/p\u003e\u003c\/article\u003e\u003carticle class=\"use-case\"\u003e\u003ch3\u003eHow should staffing scale?\u003c\/h3\u003e\n\u003cp\u003eChange FTE and salaries by role; review payroll expense and operating profitability without embedding staff pay inside COGS or other operating cost assumptions.\u003c\/p\u003e\u003c\/article\u003e\u003carticle class=\"use-case\"\u003e\u003ch3\u003eHow much opening funding is required?\u003c\/h3\u003e\n\u003cp\u003eAdjust startup assets, preopening cash, working-capital days, equity, or debt; then review Sources \u0026amp; Uses, financing schedules, cash flow, balance sheet, and liquidity checks.\u003c\/p\u003e\u003c\/article\u003e\u003carticle class=\"use-case\"\u003e\u003ch3\u003eWhat is outside this case?\u003c\/h3\u003e\n\u003cp\u003eThe supplied operating case excludes an owned factory, retail store, skincare, drug claims, importing, and marketplace sales. Those activities would require different operating drivers and cost assumptions.\u003c\/p\u003e\u003c\/article\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection id=\"fml-faq\" class=\"section soft-section\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eFAQ\u003c\/span\u003e\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\u003cp\u003eThese answers summarize the model scope, editable assumptions, forecast logic, and supported analysis.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eWhat drives revenue in this makeup line financial model?\u003c\/h3\u003e\n\u003cp\u003eMonthly purchasing accounts, units per account, seasonality, six exclusive product\/channel shares, and each stream’s net realized unit price drive the revenue forecast.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I change the DTC and wholesale sales mix?\u003c\/h3\u003e\n\u003cp\u003eYes. The six channel shares are editable and allocate one finished-unit pool across four DTC and two wholesale streams, so the total mix should remain 100%.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the model include manufacturing payroll?\u003c\/h3\u003e\n\u003cp\u003eNo. The case assumes outsourced US stock-formula manufacturing; payroll covers the working owner, customer and stockist operations, and a brand marketing coordinator.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eHow are fulfillment and marketing costs modeled?\u003c\/h3\u003e\n\u003cp\u003eThird-party fulfillment and shipping are modeled in COGS, while performance marketing, processing, returns, stock losses, and wholesale credit losses are separate revenue-linked operating costs.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes EBITDA equal cash flow or net profit?\u003c\/h3\u003e\n\u003cp\u003eNo. EBITDA is an operating earnings measure; cash flow also reflects working capital, CAPEX, debt, equity, and financing movements, while net profit includes additional accounting items.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eWhat startup funding is included in the example case?\u003c\/h3\u003e\n\u003cp\u003eThe case uses $219,615 of initial owner funding for startup assets, separate prelaunch cash, opening working capital, and three months of recurring cash outflows.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan the workbook test different scenarios?\u003c\/h3\u003e\n\u003cp\u003eYes. Dashboard Scenario Controls apply Low, Base, and High multipliers to revenue, COGS, variable expenses, fixed expenses, and payroll for side-by-side profitability analysis.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the template calculate break-even and investment returns?\u003c\/h3\u003e\n\u003cp\u003eYes. Returns covers sales break-even, cash break-even timing, investment payback, and annual ROIC, while Valuation provides DCF and sensitivity analysis using workbook 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":48217937117427,"sku":"makeup-line-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/makeup-line-financial-model-headimage-financialmodelslab_3a615747-b003-45e9-bb45-2d96142e081c.webp?v=1765295519","url":"https:\/\/finmodelslab.myshopify.com\/products\/makeup-line-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}