{"product_id":"car-dealership-financial-model","title":"Car Dealership 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\u003eCar Dealership Financial Model\u003c\/strong\u003e is an Excel template for a single-site US new-and-used vehicle retailer. It converts customer inquiries, sales conversion, six vehicle-category shares, and realized prices into monthly and annual revenue.\u003c\/p\u003e\n\u003cp\u003eThe illustrative dealership leases its showroom and lot, outsources preparation and warranty repairs, and earns no aftersales or finance-and-insurance income. The 2026–2030 example is a planning case, not an industry benchmark.\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\u003eVehicle categories\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e6\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003enew and used segments\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eSales conversion\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e12%\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eillustrative inquiry rate\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eInventory days\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e59\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eworking capital assumption\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003c\/dl\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-included\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eWORKBOOK CONTENTS\u003c\/span\u003e\u003ch2\u003eAn Integrated Dealership Planning Workbook\u003c\/h2\u003e\n\u003cp\u003eThe template connects dealership-specific operating inputs with a wider set of financial statements, scenario controls, and management reports.\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\u003eAdjust inquiry volume, conversion, vehicle mix, prices, and launch timing. Monthly calculations produce units and revenue by segment.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCOGS \u0026amp; OPEX and Payroll\u003c\/h3\u003e\n\u003cp\u003ePlan inventory, preparation, warranty work, advertising, facilities, and staff separately without double-counting payments.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCAPEX, CapTable and Debt\u003c\/h3\u003e\n\u003cp\u003eSet opening assets, capital spending, equity contributions, and optional debt terms, with linked financing schedules.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eFinancial Statements\u003c\/h3\u003e\n\u003cp\u003eReview modeled earnings, cash, assets, liabilities, and funding in the Income Statement, Cash Flow, Balance Sheet, and Summary.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDashboard and Model Checks\u003c\/h3\u003e\n\u003cp\u003eSelect Low, Base, or High scenarios and use Checks to flag reconciliation or input problems.\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\"\u003eVEHICLE SALES FORECAST\u003c\/span\u003e\u003ch2\u003eRevenue Starts With Inquiries and Conversion\u003c\/h2\u003e\n\u003cp\u003eMonthly vehicle sales equal qualified inquiries multiplied by the inquiry-to-sale conversion rate, then allocated once across six product categories.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe Base example begins with 400 qualified inquiries per month in 2026 and increases to 700 by 2030. A constant 12% conversion produces 48 to 84 vehicles sold monthly, or 576 to 1,008 vehicles annually.\u003c\/p\u003e\n\u003cp\u003eThe sales mix is 10% new sedans, 25% new SUVs, 15% new pickups, 15% used sedans, 25% used SUVs, and 10% used pickups. All shares use one vehicle-sales pool.\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 connects qualified inquiries and sales conversion with category shares and realized vehicle prices. Its monthly calculations build each category’s revenue and reconcile the six offerings to total dealership 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 Base-case sales calculation\u003c\/span\u003e\u003cp\u003e400 inquiries per month × 12% conversion = 48 vehicles per month; 48 × $37,925 weighted vehicle price × 12 months = $21,844,800 annual revenue.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative realized prices and vehicle mix\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eVehicle segment\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eSales mix\u003c\/th\u003e\n\u003cth scope=\"col\"\u003ePrice per vehicle\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eNew sedans\u003c\/th\u003e\n\u003ctd data-label=\"Sales mix\"\u003e10%\u003c\/td\u003e\n\u003ctd data-label=\"Price per vehicle\"\u003e$34,500\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eNew SUVs\u003c\/th\u003e\n\u003ctd data-label=\"Sales mix\"\u003e25%\u003c\/td\u003e\n\u003ctd data-label=\"Price per vehicle\"\u003e$47,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eNew pickups\u003c\/th\u003e\n\u003ctd data-label=\"Sales mix\"\u003e15%\u003c\/td\u003e\n\u003ctd data-label=\"Price per vehicle\"\u003e$56,500\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eUsed sedans\u003c\/th\u003e\n\u003ctd data-label=\"Sales mix\"\u003e15%\u003c\/td\u003e\n\u003ctd data-label=\"Price per vehicle\"\u003e$21,500\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eUsed SUVs\u003c\/th\u003e\n\u003ctd data-label=\"Sales mix\"\u003e25%\u003c\/td\u003e\n\u003ctd data-label=\"Price per vehicle\"\u003e$29,500\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eUsed pickups\u003c\/th\u003e\n\u003ctd data-label=\"Sales mix\"\u003e10%\u003c\/td\u003e\n\u003ctd data-label=\"Price per vehicle\"\u003e$36,500\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003ePrices and mix are selected planning assumptions, not observed market averages.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eChanging the number of inquiries tests traffic generation; changing conversion tests the retail sales process. Adjusting category shares or prices changes revenue per sold vehicle without double-counting transactions.\u003c\/p\u003e\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-costs\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eCOST AND STAFFING PLAN\u003c\/span\u003e\u003ch2\u003eTrace Vehicle Margin Through Operating EBITDA\u003c\/h2\u003e\n\u003cp\u003eThe dealership’s operating forecast separates vehicle-related direct costs, other variable spending, recurring overhead, and payroll.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eDirect costs total 94.5% of revenue: vehicle purchases at 93%, freight at 0.45%, outsourced preparation at 0.85%, and warranty claims at 0.2%. This leaves a narrow gross margin.\u003c\/p\u003e\n\u003cp\u003eVariable operating costs total another 0.75% of revenue for listings and advertising, title and transaction processing, and credit losses. Fixed costs cover the leased lot, utilities, insurance, software, security, cleaning, professional services, and recurring licensing.\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 distinguishes vehicle acquisition and preparation from variable selling costs and fixed overhead. Monthly expense schedules flow into the projected margins and operating expense totals.\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\u003cp\u003ePayroll covers a general manager, vehicle sales associates, an inventory purchasing manager, lot and delivery staff, a title administrator, and bookkeeping support. Annual-average sales associate staffing rises from 4 to 6 FTE over the illustrative forecast.\u003c\/p\u003e\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 role-level staffing and pay assumptions, including FTE plans and salary costs. In the selected case, annual payroll rises from $439,000 in 2026 to $551,000 in 2030.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic8]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003caside class=\"callout\"\u003e\u003cstrong\u003eExpense boundary\u003c\/strong\u003e\u003cp\u003eThe case excludes employer taxes, benefits, and personal taxes. Outsourced preparation and warranty costs do not also appear in payroll.\u003c\/p\u003e\u003c\/aside\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section startup-section\" id=\"fml-startup\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eOPENING CAPITAL AND FUNDING\u003c\/span\u003e\u003ch2\u003eSeparate Opening Investment From Operating Earnings\u003c\/h2\u003e\n\u003cp\u003eStartup assets, preopening cash spending, working-capital assumptions, and owner funding are tracked separately from the annual EBITDA forecast.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eInitial asset assumptions include $225,000 in showroom and lot improvements, $35,000 in furniture and fixtures, $18,000 in computers, and $16,000 in security equipment, plus delivery and lot equipment. Other opening cash needs include deposits, permits, launch marketing, preopening pay, and prepaid insurance.\u003c\/p\u003e\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 dealership asset spending and depreciation where applicable. It helps separate investment in showroom facilities and equipment from recurring 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\u003eEstimated opening owner funding is $9,496,339, reflecting startup spending, launch working capital, and three months of operating cash outflows, with no confirmed external funding. Working-capital assumptions are 5 receivable, 0 payable, and 59 inventory days.\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 groups modeled incoming equity or debt with operating, investing, and financing cash needs. Use it to examine planned funding allocation rather than treating opening owner contributions as sales or profit.\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 FINANCIAL PROJECTIONS\u003c\/span\u003e\u003ch2\u003eFive Years of Dealership Revenue and EBITDA\u003c\/h2\u003e\n\u003cp\u003eThe 2026–2030 case projects increasing sales and positive EBITDA after operating expenses.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative Base-case operating forecast, nominal 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$21,844,800\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$21,614,572\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$230,228\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$25,940,700\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$25,562,127\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$378,573\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$30,036,600\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$29,491,912\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$544,688\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2029\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$34,132,500\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$33,439,933\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$692,567\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2030\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$38,228,400\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$37,370,196\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$858,204\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eOperating expenses include direct costs, variable expenses, fixed overhead, and payroll; displayed values are rounded to whole dollars.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eIn 2026, the case generates $21,844,800 of sales and $230,228 of EBITDA, compared with $38,228,400 of sales and $858,204 of EBITDA by 2030. These are illustrative outputs from the selected inputs, not measured dealership results.\u003c\/p\u003e\n\u003cp\u003eEBITDA measures operating performance before depreciation, interest, taxes, and amortization. It is not net profit, cash generated, or evidence that the modeled opening investment will be recovered.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eCash timing also matters because vehicle inventory can tie up substantial funds even when an income statement reports a positive operating margin. Receivable, payable, inventory, capital spending, and financing assumptions affect modeled liquidity.\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 separates operating receipts and payments from investment and financing activity. Review monthly cash balances and the opening-to-closing reconciliation before assessing the dealership’s possible funding needs.\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 class=\"section\" id=\"fml-returns\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eBREAK-EVEN AND SENSITIVITY\u003c\/span\u003e\u003ch2\u003eEvaluate Break-Even, Payback, and Downside Cases\u003c\/h2\u003e\n\u003cp\u003eReturns and scenario reporting support distinct questions about operating coverage, investment recovery, capital efficiency, and assumption risk.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eSales break-even examines how much revenue is needed to cover the modeled cost structure. Cash break-even asks when cash inflows cover relevant cash outflows; investment payback follows cumulative project cash flows; annual ROIC compares operating returns with invested capital.\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 Break-Even, Payback and ROIC report brings together sales coverage, cash break-even timing, cumulative investment cash flows, and annual return on invested capital. No particular break-even date, payback period, or ROIC value is established by this example.\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\u003eUse the Dashboard’s Low, Base, and High scenario multipliers to test changes in revenue and the four operating cost categories. Vehicle conversion, realized selling prices, and purchase costs deserve special attention because they materially influence a dealership’s operating margin.\u003c\/p\u003e\u003c\/div\u003e\n\u003caside class=\"callout\"\u003e\u003cstrong\u003eLicensing and supply\u003c\/strong\u003e\u003cp\u003eThe example assumes the dealership can secure the agreements and licenses required for new-vehicle distribution. It does not model acquisition goodwill or a franchised service department.\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\"\u003ePRACTICAL PLANNING USES\u003c\/span\u003e\u003ch2\u003eUse the Model to Test Dealership Decisions\u003c\/h2\u003e\n\u003cp\u003eUse this template to plan vehicle-only retail operations and explain forecast assumptions.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eLinked inputs help owners and advisors test conversion, vehicle mix, supplier cost, staffing, rent, and inventory funding. Monthly schedules reveal timing issues hidden in annual EBITDA.\u003c\/p\u003e\n\u003cp\u003eValuation, ratios, benchmarks, and charts support additional analysis, but the source case establishes no valuation, lender approval, tested liquidity sufficiency, or investor returns.\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\"\u003ePRODUCT QUESTIONS\u003c\/span\u003e\u003ch2\u003eCar Dealership Financial Model FAQs\u003c\/h2\u003e\n\u003cp\u003eThese answers clarify what the spreadsheet models, which assumptions are editable, and how to interpret the reports.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eDoes this model include both new and used vehicles?\u003c\/h3\u003e\n\u003cp\u003eYes. It allocates one vehicle-sales pool across new sedans, SUVs, pickups, and the same three used-vehicle categories.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eHow are vehicle sales calculated?\u003c\/h3\u003e\n\u003cp\u003eMonthly units equal qualified vehicle inquiries multiplied by the inquiry-to-sale conversion rate; category shares then allocate units to realized selling prices.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes it include service or financing product revenue?\u003c\/h3\u003e\n\u003cp\u003eNo. The illustrated operation excludes paid aftersales and finance-and-insurance product income, and it outsources preparation and warranty repairs.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I change staffing and operating costs?\u003c\/h3\u003e\n\u003cp\u003eYes. The Payroll and COGS \u0026amp; OPEX worksheets contain role-level staffing and separate direct, variable, and fixed expense assumptions.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eIs the $9,496,339 funding amount required?\u003c\/h3\u003e\n\u003cp\u003eNo. It is a case-specific owner funding estimate derived from selected startup, working-capital, and cash-reserve assumptions, not a universal dealership funding requirement.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes positive EBITDA mean the dealership is cash-positive?\u003c\/h3\u003e\n\u003cp\u003eNo. EBITDA excludes important cash effects from inventory, capital spending, financing, and other timing differences; consult Cash Flow and the Balance Sheet.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the model calculate break-even and investment returns?\u003c\/h3\u003e\n\u003cp\u003eThe Returns worksheet supports sales break-even, cash break-even, payback, and annual ROIC analysis, but the supplied case establishes no specific results for those measures.\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":48218035323123,"sku":"car-dealership-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/car-dealership-financial-model-headimage-financialmodelslab_f462caa3-da22-44b3-90b9-ac333ff5ee16.webp?v=1765297423","url":"https:\/\/finmodelslab.myshopify.com\/products\/car-dealership-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}