{"product_id":"after-school-program-financial-model","title":"After-School Program 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\u003eAfter-School Program Financial Model\u003c\/strong\u003e is an Excel financial planning template for an independent, school-based program. It converts available places, school days, enrollment utilization, program mix, daily prices, staffing, and operating costs into monthly calculations and a five-year forecast.\u003c\/p\u003e\n\u003cp\u003eThe illustrated case covers an 80-place program for children ages 6–12 in San Antonio, Texas, from 2026 through 2030. It assumes a daytime school-partner access agreement, prepaid monthly family invoices, and no transportation, summer camp, or grant revenue.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdl class=\"product-facts\" aria-label=\"Financial model facts\"\u003e\n\u003cdiv\u003e\n\u003cdt\u003ePlaces\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e80\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eschool-age capacity\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eDaily packages\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003emutually exclusive\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eSchool days\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e180\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eannual planning basis\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\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\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\"\u003eEXCEL TEMPLATE\u003c\/span\u003e\u003ch2\u003eWhat Is Included in the Model\u003c\/h2\u003e\n\u003cp\u003eThe workbook connects enrollment assumptions and operating schedules with financial statements, financing controls, and decision-oriented 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\u003eDefine the 80-place capacity, monthly school calendar, daily package prices, enrollment utilization, and program shares. The Calc schedule applies these drivers to the monthly revenue forecast.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCOGS \u0026amp; OPEX and Payroll\u003c\/h3\u003e\n\u003cp\u003eSeparate supplies and processing expenses from premises overhead and role-based compensation. Payroll tracks counselor, program director, and enrollment administrator staffing without adding those salaries again to operating expenses.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCAPEX, CapTable \u0026amp; Debt\u003c\/h3\u003e\n\u003cp\u003eSchedule startup purchases, equity contributions, and any financing facilities entered in the workbook. Debt controls on the Dashboard feed repayment schedules; the illustrated operating case does not assume confirmed outside borrowing.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eStatements \u0026amp; Summary\u003c\/h3\u003e\n\u003cp\u003eReview the projected Income Statement, Cash Flow Statement, and Balance Sheet, plus a combined reporting summary. The published example below documents revenue, total operating expenses, and EBITDA, not unseen statement balances.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eReturns \u0026amp; Funding Reports\u003c\/h3\u003e\n\u003cp\u003eUse Returns for break-even, payback, and return on invested capital; Sources \u0026amp; Uses for cash allocation; and Valuation for discounted cash flow sensitivity when the necessary inputs are supplied.\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\u003eRevenue Comes From One Shared Child-Day Pool\u003c\/h2\u003e\n\u003cp\u003eThe model calculates sales from places, operating days, utilization, seasonal enrollment patterns, mutually exclusive package shares, and daily prices.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eEvery booked child-day is assigned to one of five packages, rather than counted five times: Standard Care, Homework Club, STEM Studio, Arts Workshop, or Sports and Games. Their estimated daily prices are $20, $24, $28, $26, and $24, respectively.\u003c\/p\u003e\n\u003cp\u003eThe package shares are 40%, 20%, 15%, 15%, and 10%, producing a \u003cstrong\u003e$23.30 weighted daily price\u003c\/strong\u003e. Annual-average utilization rises from 55% in 2026 to 75% in 2030, with capacity constrained to 80 places.\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 organizes available places, child-day demand, package mix, and pricing assumptions. Its monthly calculation schedule applies the school calendar and enrollment utilization to develop projected sales by package and total program revenue.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic2]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"formula-text\"\u003e\n\u003cspan class=\"formula-label\"\u003eIllustrative 2026 annual revenue basis\u003c\/span\u003e\u003cp\u003e80 places × 180 annual school days × 55% utilization × $23.30 weighted child-day price = $184,536 revenue.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eThe normalized calendar models no child-day sales in June or July, with adjusted activity across other months. Parent invoices are prepaid each month; the case excludes additional registration fees, transportation, camps, and grants.\u003c\/p\u003e\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-costs\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eOPERATING COSTS\u003c\/span\u003e\u003ch2\u003eCosts Separate Supplies, Overhead, and Payroll\u003c\/h2\u003e\n\u003cp\u003eThe after-school program separates revenue-linked direct costs, variable expenses, monthly fixed expenses, and role-based salaries.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eEstimated direct costs are 5% of revenue for snacks and beverages plus 3% for activity consumables. Variable expenses add 3% for payment processing and 2% for enrollment outreach. Each percentage uses business revenue as its base.\u003c\/p\u003e\n\u003cp\u003eFixed overhead includes school premises access, utilities allocation, insurance, software, cleaning, repairs, professional services, background checks, communications, and compliance. Premises access is modeled at $1,800 per month for 12 paid months.\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 groups direct, variable, and fixed items and schedules when they apply. It helps show how increased enrollment raises revenue-linked spending while recurring premises and administration costs continue through months without child-day sales.\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 2026 operating expenses, USD\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eExpense category\u003c\/th\u003e\n\u003cth scope=\"col\"\u003e2026 cost\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eMain driver\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eDirect costs\u003c\/th\u003e\n\u003ctd data-label=\"2026 cost\"\u003e$14,763\u003c\/td\u003e\n\u003ctd data-label=\"Main driver\"\u003e8% of revenue\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eVariable expenses\u003c\/th\u003e\n\u003ctd data-label=\"2026 cost\"\u003e$9,227\u003c\/td\u003e\n\u003ctd data-label=\"Main driver\"\u003e5% of revenue\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eFixed overhead\u003c\/th\u003e\n\u003ctd data-label=\"2026 cost\"\u003e$42,720\u003c\/td\u003e\n\u003ctd data-label=\"Main driver\"\u003eMonthly obligations\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003ePayroll\u003c\/th\u003e\n\u003ctd data-label=\"2026 cost\"\u003e$129,230\u003c\/td\u003e\n\u003ctd data-label=\"Main driver\"\u003eRole-based salaries\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003ctfoot\u003e\u003ctr\u003e\n\u003cth scope=\"row\"\u003eTotal\u003c\/th\u003e\n\u003ctd data-label=\"2026 cost\"\u003e$195,940\u003c\/td\u003e\n\u003ctd data-label=\"Main driver\"\u003eOperating expenses\u003c\/td\u003e\n\u003c\/tr\u003e\u003c\/tfoot\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eSource figures are planning projections; rounded category amounts sum to the displayed total.\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 plans counselors, a program director, and an enrollment administrator with annual-average FTE assumptions and fixed base compensation. The case uses 2.34 counselor FTE, 0.65 director FTE, and 0.15 administrator FTE; payroll is not duplicated in other expense categories.\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\u003eStaffing scope\u003c\/strong\u003e\u003cp\u003eThe illustrated staffing budget includes fixed gross base salaries and excludes employer taxes, benefits, and personal taxes under the stated case scope. Workbook payroll controls can support other assumptions.\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\"\u003eSTARTUP FUNDING\u003c\/span\u003e\u003ch2\u003eStartup Investment Is Separate From EBITDA\u003c\/h2\u003e\n\u003cp\u003eOpening assets, preopening payments, working capital, and owner contributions require funding analysis outside the annual operating expense forecast.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eThe selected opening asset plan includes $10,000 for furniture and storage, $5,000 for computers and check-in equipment, $6,000 for durable STEM and recreation kits, and $2,000 for safety equipment, plus minor qualifying improvements.\u003c\/p\u003e\n\u003cp\u003eOther opening cash needs cover a refundable premises deposit, permits and setup, launch marketing, training and setup pay, software configuration, and initial branding. These items are kept separate from recurring operating expenses.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"capex\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCapital Expenditure Plan\u003c\/h3\u003e\n\u003cp\u003eThe Capital Expenditure Plan schedules equipment and other capital purchases, distinguishing depreciable and non-depreciable items. It links planned outlays with depreciation and asset records without treating the original cash purchase as an additional recurring payroll or operating expense.\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\u003eInitial owner funding is estimated at \u003cstrong\u003e$91,351\u003c\/strong\u003e, based on assets, distinct preopening cash items, opening inventory, and three months of recurring cash expenses. The stated scenario includes no confirmed non-owner funding.\u003c\/p\u003e\n\u003cp\u003eWorking-capital controls use zero accounts-receivable days, zero accounts-payable days, and 14 inventory days. These are assumptions for cash planning, not proof that the opening funding amount will cover every actual cash requirement.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"funding\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eSources and Uses of Funds\u003c\/h3\u003e\n\u003cp\u003eThe Sources and Uses of Funds report organizes equity, any entered debt, operating receipts, expenses, investment outlays, and retained cash over a selected forecast window. It helps distinguish sources of startup financing from how cash is deployed as the program operates.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic3]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section soft-section\" id=\"fml-forecast\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eFIVE-YEAR OUTLOOK\u003c\/span\u003e\u003ch2\u003eIllustrative Revenue and EBITDA Through 2030\u003c\/h2\u003e\n\u003cp\u003eThe selected base operating case shows a first-year EBITDA loss followed by positive projected EBITDA as enrollment utilization increases.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative after-school program 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$184,536\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$195,940\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e−$11,404\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$208,022\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$198,993\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$9,029\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$228,154\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$201,610\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$26,544\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2029\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$241,574\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$203,355\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$38,220\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2030\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$251,640\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$204,663\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$46,977\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eIllustrative planning projections, rounded to whole dollars; displayed totals may differ slightly because of rounding.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eIn this base case, enrollment growth changes annual EBITDA from an initial loss to a projected $46,977 surplus by 2030.\u003c\/p\u003e\n\u003cp\u003eThese figures describe performance \u003cstrong\u003ethrough EBITDA only\u003c\/strong\u003e. They are not net profit, free cash flow, observed results, or proof of cash sufficiency; interest, taxes, depreciation, capital spending, and financing can materially change those outcomes.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"cashflow\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCash Flow Forecast\u003c\/h3\u003e\n\u003cp\u003eThe Cash Flow Forecast tracks expected operating, investing, and financing cash movements and reconciles opening to closing cash. Use it to assess the timing of prepaid family receipts, summer cash obligations, startup spending, and owner contributions beyond the EBITDA projection.\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\u003eSchool-year timing matters\u003c\/strong\u003e\u003cp\u003eJune and July generate no modeled child-day sales, while fixed overhead and annual-average payroll remain full-year obligations. Cash planning should therefore be reviewed separately from annual earnings.\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\"\u003eSCENARIOS AND RETURNS\u003c\/span\u003e\u003ch2\u003eEvaluate Break-Even, Payback, and Sensitivity\u003c\/h2\u003e\n\u003cp\u003eReturn and scenario reports help test the sustainability of enrollment assumptions without claiming a specific investment return for this example.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eThe Returns report distinguishes operating sales break-even from cash break-even, investment payback, and annual return on invested capital. Sales needed to cover operating costs are not the same as accumulated cash recovery of startup investment.\u003c\/p\u003e\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"returns\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eBreak-Even, Payback and ROIC\u003c\/h3\u003e\n\u003cp\u003eThe Returns report compares sales against break-even requirements and evaluates project cash-flow recovery, investment payback, and annual ROIC. It helps an operator ask whether projected enrollment, ongoing costs, and required initial investment produce an acceptable financial outcome.\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 let a buyer compare Low, Base, and High multipliers for revenue, direct costs, variable expenses, fixed expenses, and payroll. For a school-year operation, this can test slower enrollment, staffing pressure, or stronger package demand.\u003c\/p\u003e\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"scenarios\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eFinancial Scenario Analysis\u003c\/h3\u003e\n\u003cp\u003eThe Financial Scenario Analysis compares Low, Base, and High outcomes for revenue, gross margin, contribution margin, and EBITDA. It makes the effect of selected operating multipliers easier to inspect before choosing staffing levels, enrollment targets, or a funding strategy.\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-faq\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eFREQUENTLY ASKED QUESTIONS\u003c\/span\u003e\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\u003cp\u003eThese answers explain the model scope and the difference between its inputs, financial projections, and reporting capabilities.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eCan I change enrollment and package prices?\u003c\/h3\u003e\n\u003cp\u003eYes. Adjust places, utilization, school-day assumptions, package prices, and mutually exclusive package shares in the revenue inputs.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the forecast include summer camp revenue?\u003c\/h3\u003e\n\u003cp\u003eNo. The illustrated operating case has no June or July child-day sales and excludes summer camps, transportation, grants, and registration fees.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eHow does the model handle counselor salaries?\u003c\/h3\u003e\n\u003cp\u003eCounselors and other roles are planned on Payroll using annual-average FTE and salary assumptions, with salaries excluded from direct, variable, and fixed expense categories.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre the projected EBITDA figures net profit?\u003c\/h3\u003e\n\u003cp\u003eNo. The documented illustrative results stop at EBITDA; net profit, depreciation, financing cash flows, and tax outcomes should not be inferred from those figures.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the workbook include cash flow and a balance sheet?\u003c\/h3\u003e\n\u003cp\u003eYes. Cash Flow and Balance Sheet are declared workbook reports, but the published example does not provide their calculated balances.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I evaluate break-even and investment payback?\u003c\/h3\u003e\n\u003cp\u003eYes. The Returns report supports break-even, investment payback, and annual ROIC analysis; this example does not establish specific payback or ROIC values.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eIs the $91,351 owner funding amount guaranteed to be enough?\u003c\/h3\u003e\n\u003cp\u003eNo. It is an estimated opening funding assumption; review startup spending, collections, seasonal cash needs, and financing with the full model.\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":48218331906291,"sku":"after-school-program-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/after-school-program-financial-model-headimage-financialmodelslab_399c9966-c293-48ba-8fa7-e019b1088260.webp?v=1765304746","url":"https:\/\/finmodelslab.myshopify.com\/products\/after-school-program-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}