{"product_id":"plumbing-hvac-financial-model","title":"Plumbing Hvac Financial Projections Template in Excel","description":"\u003cstyle data-fml-style=\"10-safe-dom\"\u003e\n\/* FML Financial Model Product Description v10 — scoped Shopify fragment CSS.\n   Theme owns typography, checkout, product image rendering and Preview. *\/\n.fml-description{\n  --primary:#6067F2;--primary-dark:#2228B0;--soft:#F2F2FF;--xlight:#ECEDFF;\n  --yellow:#FCBD01;--ink:#0F1017;--text:#4C4F62;--muted:#686B80;\n  --line:#E0E1ED;--paper:#FAFAFA;--white:#FFFFFF;\n  box-sizing:border-box;container-type:inline-size;container-name:fml;\n  width:100%;min-width:0;max-width:100%;margin:0;padding:0;\n  font-family:inherit;font-size:17px;line-height:1.7;color:var(--text);background:var(--white)\n}\n.fml-description :where(*):not(.workbook-media,.workbook-media *){box-sizing:border-box}\n.fml-description :where(h2,h3,p,dl,dd,figure):not(.workbook-media *){margin:0;padding:0}\n.fml-description :where(h2,h3):not(.workbook-media *){\n  color:var(--ink);font-weight:650;letter-spacing:-.02em;\n  line-height:1.32;white-space:normal;word-break:normal;overflow-wrap:break-word;hyphens:none\n}\n.fml-description h2{font-size:clamp(26px,3vw,36px)}\n.fml-description h3{font-size:21px}\n.fml-description p{font-size:17px;line-height:1.7;overflow-wrap:break-word;word-break:normal}\n.fml-description strong{font-weight:650}\n.fml-description .container{box-sizing:border-box;width:100%;max-width:1180px;min-width:0;margin-inline:auto;padding-inline:clamp(16px,3%,32px)}\n.fml-description section{box-sizing:border-box;display:block;width:100%;min-width:0;max-width:100%;position:static}\n.fml-description .section{padding-block:58px}\n.fml-description .section.soft-section{background:var(--soft)}\n.fml-description .section.startup-section{background:var(--paper)}\n.fml-description .description-intro{padding-block:34px 16px}\n.fml-description .intro-copy{width:100%;max-width:1050px}\n.fml-description .intro-copy p+p{margin-top:13px}\n.fml-description .section-heading{display:block!important;width:100%;min-width:0;margin:0 0 28px;padding:0}\n.fml-description .section-heading h2{display:block;width:100%;min-width:0;max-width:none;margin:0 0 12px}\n.fml-description .section-heading\u003ep{display:block;width:100%;max-width:910px;margin:0;color:var(--text)}\n.fml-description .eyebrow{display:block;font-size:16px;line-height:1.4;font-weight:650;text-transform:uppercase;letter-spacing:.055em;color:var(--primary-dark);margin-bottom:11px}\n.fml-description .section-copy{display:block;min-width:0;width:100%}\n.fml-description .section-copy p+p{margin-top:12px}\n.fml-description .section-copy h3{margin-bottom:10px}\n.fml-description .section-note{font-size:16px;line-height:1.65;color:var(--muted);margin-top:18px}\n\n\/* Compact numeric facts: independent vertical tracks, never side-by-side value and copy. *\/\n.fml-description .product-facts{\n  display:grid;grid-template-columns:repeat(4,minmax(0,1fr));\n  width:100%;min-width:0;gap:0;border-block:1px solid var(--line);\n  padding-block:23px;margin-top:28px\n}\n.fml-description .product-facts\u003ediv{display:flex;flex-direction:column;align-items:flex-start;min-width:0;padding:0 20px;gap:5px}\n.fml-description .product-facts\u003ediv:first-child{padding-left:0}\n.fml-description .product-facts\u003ediv+div{border-left:1px solid var(--line)}\n.fml-description .product-facts dt{font-size:16px;line-height:1.35;color:var(--muted);white-space:normal}\n.fml-description .product-facts dd{display:flex;flex-direction:column;align-items:flex-start;gap:4px;width:100%;min-width:0;margin:0}\n.fml-description .fact-value{display:block;font-size:clamp(32px,3.5vw,40px);line-height:1.2;font-weight:650;letter-spacing:-.03em;color:var(--primary);white-space:nowrap;font-variant-numeric:tabular-nums}\n.fml-description .fact-detail{display:block;min-width:0;font-size:16px;line-height:1.45;color:var(--text);white-space:normal;word-break:normal}\n\n\/* Flat cards grow with their text; no min-width or fixed height that squeezes headings. *\/\n.fml-description .included-list,.fml-description .use-cases,.fml-description .report-grid{\n  display:grid;grid-template-columns:repeat(3,minmax(0,1fr));gap:20px;width:100%;min-width:0\n}\n.fml-description .included-list article,.fml-description .use-case,.fml-description .report-grid article{\n  min-width:0;max-width:100%;padding:22px 20px;border:1px solid var(--line);\n  background:var(--white);border-radius:10px;box-shadow:none;overflow:visible\n}\n.fml-description .included-list h3,.fml-description .use-case h3,.fml-description .report-grid h3{\n  display:block;width:100%;font-size:20px;margin:0 0 10px;line-height:1.35\n}\n.fml-description .included-list p,.fml-description .use-case p,.fml-description .report-grid p{font-size:16px;line-height:1.65}\n.fml-description .use-case{border-top:3px solid var(--primary)}\n\n\/* The text and its exact worksheet shortcode must share ONE component. *\/\n.fml-description .media-explainer{\n  display:grid;grid-template-columns:minmax(0,1fr) minmax(0,min(39%,420px));\n  width:100%;min-width:0;max-width:100%;gap:clamp(22px,3.5%,48px);\n  align-items:center;margin:34px 0 42px;padding:0;clear:both\n}\n.fml-description .media-explainer[data-fml-side=\"left\"]{grid-template-columns:minmax(0,min(39%,420px)) minmax(0,1fr)}\n.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.section-copy{grid-column:2;grid-row:1}\n.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.workbook-media{grid-column:1;grid-row:1;justify-self:start}\n.fml-description .media-explainer\u003e.section-copy{min-width:0;width:100%;padding:18px clamp(12px,2%,25px)}\n.fml-description .media-explainer\u003e.section-copy h3{font-size:21px;margin-bottom:12px}\n.fml-description .media-explainer\u003e.section-copy p{font-size:17px;line-height:1.7}\n.fml-description .media-explainer\u003e.workbook-media{\n  display:block;min-width:0;width:100%;max-width:420px;margin:0;\n  padding:12px 0 16px;justify-self:end;align-self:center\n}\n.fml-description .workbook-media :where(img,picture){max-width:100%;height:auto}\n\/* Never change the theme's shortcode Preview\/button\/modal descendants. *\/\n\n.fml-description .text-copy{display:block;max-width:1050px;margin:20px 0 26px;min-width:0}\n.fml-description .text-copy p+p{margin-top:13px}\n.fml-description .formula-text{margin:26px 0 32px;padding:18px 20px;border:1px solid var(--line);border-left:4px solid var(--primary);background:var(--white);border-radius:8px}\n.fml-description .formula-text .formula-label{display:block;color:var(--primary-dark);font-size:16px;font-weight:650;margin-bottom:5px}\n.fml-description .formula-text p{color:var(--ink);font-size:17px;line-height:1.65}\n.fml-description .callout{margin:24px 0 30px;padding:18px 22px;border-left:4px solid var(--yellow);background:var(--soft);border-radius:6px}\n.fml-description .callout strong{display:block;font-size:18px;color:var(--primary-dark);margin-bottom:5px}\n.fml-description .callout p{font-size:16px}\n\n\/* Tables are full width and have no hard min-widths. Wide year matrices use years as rows. *\/\n.fml-description .table-shell{display:block;width:100%;min-width:0;max-width:100%;margin:25px 0 32px;overflow:visible;border:1px solid var(--line);border-radius:9px;background:var(--white)}\n.fml-description .data-table{width:100%;min-width:0;max-width:100%;border:0;border-collapse:collapse;table-layout:fixed;font-size:16px;line-height:1.5;font-variant-numeric:tabular-nums}\n.fml-description .data-table caption{caption-side:top;text-align:left;padding:18px 18px 14px;color:var(--ink);font-size:19px;line-height:1.4;font-weight:650}\n.fml-description .data-table :where(th,td){padding:13px 11px;border-bottom:1px solid var(--line);vertical-align:middle;white-space:normal;overflow-wrap:break-word;word-break:normal}\n.fml-description .data-table th:first-child,.fml-description .data-table td:first-child{text-align:left;width:32%}\n.fml-description .data-table :where(td,th:not(:first-child)){text-align:right}\n.fml-description .data-table thead th{font-size:16px;font-weight:650;background:var(--soft);color:var(--primary-dark);line-height:1.4}\n.fml-description .data-table tbody th{font-size:16px;font-weight:600;color:var(--ink)}\n.fml-description .data-table tbody tr:last-child :where(th,td){border-bottom:0}\n.fml-description .data-table tfoot :where(th,td){font-weight:700;color:var(--primary-dark);background:var(--xlight);border-top:2px solid var(--primary);border-bottom:0}\n.fml-description .table-note{margin:0;padding:0 18px 16px;font-size:16px;color:var(--muted);line-height:1.6}\n\n.fml-description .faq-grid{display:grid;grid-template-columns:repeat(2,minmax(0,1fr));gap:28px 34px;min-width:0}\n.fml-description .faq-grid article{min-width:0;padding-top:18px;border-top:1px solid var(--line)}\n.fml-description .faq-grid h3{font-size:19px;margin-bottom:8px}\n.fml-description .faq-grid p{font-size:16px;line-height:1.65}\n\n\/* Container queries use the ACTUAL Shopify description width, not only viewport width. *\/\n@container fml (max-width:1040px){\n  .fml-description .product-facts{grid-template-columns:repeat(2,minmax(0,1fr));row-gap:22px}\n  .fml-description .product-facts\u003ediv:nth-child(odd){padding-left:0;border-left:0}\n  .fml-description .product-facts\u003ediv:nth-child(even){border-left:1px solid var(--line)}\n  .fml-description .product-facts\u003ediv:nth-child(n+3){padding-top:15px;border-top:1px solid var(--line)}\n  .fml-description .included-list,.fml-description .use-cases,.fml-description .report-grid{grid-template-columns:repeat(2,minmax(0,1fr))}\n}\n@container fml (max-width:790px){\n  .fml-description .media-explainer,.fml-description .media-explainer[data-fml-side=\"left\"]{grid-template-columns:minmax(0,1fr);gap:15px;margin:28px 0 38px}\n  .fml-description .media-explainer\u003e.section-copy,.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.section-copy{grid-column:1;grid-row:1;padding:12px 3px 0}\n  .fml-description .media-explainer\u003e.workbook-media,.fml-description .media-explainer[data-fml-side=\"left\"]\u003e.workbook-media{grid-column:1;grid-row:2;justify-self:center;max-width:min(100%,420px);padding:6px 0 20px}\n  .fml-description .section{padding-block:43px}\n  .fml-description .section-heading{margin-bottom:24px}\n}\n@container fml (max-width:620px){\n  .fml-description .included-list,.fml-description .use-cases,.fml-description .report-grid,.fml-description .faq-grid{grid-template-columns:minmax(0,1fr)}\n  .fml-description .product-facts{grid-template-columns:repeat(2,minmax(0,1fr));gap:16px}\n  .fml-description .product-facts\u003ediv{padding:0!important;border:0!important}\n  .fml-description .product-facts\u003ediv:nth-child(n+3){padding-top:16px!important;border-top:1px solid var(--line)!important}\n  .fml-description .product-facts\u003ediv:nth-child(even){padding-left:13px!important;border-left:1px solid var(--line)!important}\n  .fml-description h2{font-size:27px}\n  .fml-description h3{font-size:20px}\n  .fml-description .table-shell{border:0;background:transparent}\n  .fml-description .data-table{display:block;width:100%}\n  .fml-description .data-table caption{display:block;padding:12px 0;font-size:18px}\n  .fml-description .data-table thead{display:none}\n  .fml-description .data-table tbody,.fml-description .data-table tfoot{display:block;width:100%}\n  .fml-description .data-table tbody tr,.fml-description .data-table tfoot tr{display:block;border:1px solid var(--line);background:var(--white);margin-bottom:12px;padding:4px 13px}\n  .fml-description .data-table tbody :where(th,td),.fml-description .data-table tfoot :where(th,td){box-sizing:border-box;display:flex;width:100%;justify-content:space-between;align-items:baseline;gap:16px;text-align:right;padding:9px 0;border:0}\n  .fml-description .data-table tbody th:first-child,.fml-description .data-table tfoot th:first-child{display:block;text-align:left;font-size:17px;border-bottom:1px solid var(--line);width:100%;padding:10px 0}\n  .fml-description .data-table tbody td:before,.fml-description .data-table tfoot td:before{content:attr(data-label);text-align:left;font-weight:550;color:var(--muted);min-width:0;white-space:normal}\n  .fml-description .table-note{padding:4px 0 15px}\n}\n@container fml (max-width:400px){\n  .fml-description .product-facts{grid-template-columns:minmax(0,1fr)}\n  .fml-description .product-facts\u003ediv,.fml-description .product-facts\u003ediv:nth-child(even){border:0!important;padding:0!important}\n  .fml-description .product-facts\u003ediv+div{padding-top:15px!important;border-top:1px solid var(--line)!important}\n  .fml-description .fact-value{font-size:36px}\n  .fml-description .container{padding-inline:14px}\n}\n@media (prefers-reduced-motion:reduce){.fml-description *{transition:none!important;animation:none!important}}\n\n.fml-description .text-link-row{margin:22px 0}.fml-description .text-link{display:inline-block;color:var(--primary-dark);font-weight:650;text-decoration:underline;text-underline-offset:4px;font-size:17px}\n\u003c\/style\u003e\n\u003cdiv class=\"fml-description\" id=\"fml-description\" data-fml-version=\"10-safe-dom\"\u003e\n\u003csection class=\"description-intro\" id=\"fml-description-intro\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"intro-copy\"\u003e\n\u003cp\u003eThe Plumbing and HVAC Financial Model is an Excel template for a US residential and light-commercial repair and replacement contractor. It turns technician-hour capacity, utilization, seasonality, service mix and realized revenue per field labor-hour into monthly sales projections and linked reports.\u003c\/p\u003e\n\u003cp\u003eThe illustrative contractor expands from four field technicians in 2026 to eight in 2030. It excludes new construction, storefront retail and franchise fees; the figures are editable planning estimates, not historical results.\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\u003eRevenue services\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e6\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eshared labor-hour pool\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eField technicians\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e4\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003einitial annual FTE\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003c\/dl\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-included\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eWHAT IS INCLUDED\u003c\/span\u003e\u003ch2\u003eA Connected Workbook for Service Contractors\u003c\/h2\u003e\n\u003cp\u003eThe template combines editable job economics, expense and hiring plans, capital spending, financing controls, and management reports.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"included-list\"\u003e\n\u003carticle\u003e\u003ch3\u003eRevenue \u0026amp; Calc\u003c\/h3\u003e\n\u003cp\u003eRevenue inputs set capacity, utilization, monthly seasonality, service-hour allocation and realized prices. Calc applies those assumptions month by month, assigning the sold hour pool across six services once rather than multiplying it by six.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCOGS \u0026amp; OPEX \/ Payroll\u003c\/h3\u003e\n\u003cp\u003eCost schedules separate parts, subcontractors, variable charges and monthly overhead from role-based staffing. Payroll plans technician, owner-manager and dispatch FTE and salary costs without adding those salaries again to direct costs.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCAPEX, CapTable \u0026amp; Debt\u003c\/h3\u003e\n\u003cp\u003eCAPEX schedules vehicles, tools and depreciation, while CapTable records owner contributions. Dashboard debt controls feed financing schedules, but the illustrative funding amount does not imply a confirmed external loan.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eStatements \u0026amp; Checks\u003c\/h3\u003e\n\u003cp\u003eIncome Statement, Cash Flow, Balance Sheet and Summary provide connected financial reporting. Checks identifies reconciliation or input issues; the source example supplies operating results through EBITDA, not specific net profit or cash balances.\u003c\/p\u003e\u003c\/article\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section soft-section\" id=\"fml-revenue\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eREVENUE FORECAST\u003c\/span\u003e\u003ch2\u003eHow Shared Technician Hours Generate Sales\u003c\/h2\u003e\n\u003cp\u003eOne pool of billable field labor-hours is allocated among six plumbing and HVAC services, then multiplied by each service’s realized revenue per hour.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eFor 2026, the plan starts with 640 available field labor-hours per month and 55% billable utilization, or 352 sold hours before seasonality. Annual capacity increases to 1,280 monthly available hours and utilization rises to 70% by 2030.\u003c\/p\u003e\n\u003cp\u003eThe seasonal multipliers lift or reduce monthly work, including stronger summer demand and softer spring or fall periods. Service shares sum to 100% of sold hours, so plumbing repairs, installations and HVAC work compete for the same available technician capacity.\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 links the shared technician-hour pool, billable utilization, monthly seasonality, service mix and realized price per hour. Adjusting a repair or replacement mix changes projected revenue without creating extra available field hours.\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=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative 2026 service mix and realized price per sold field labor-hour\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eService\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eHour mix\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eRevenue \/ hour\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003ePlumbing repairs\u003c\/th\u003e\n\u003ctd data-label=\"Hour mix\"\u003e28%\u003c\/td\u003e\n\u003ctd data-label=\"Revenue \/ hour\"\u003e$180\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eDrain services\u003c\/th\u003e\n\u003ctd data-label=\"Hour mix\"\u003e12%\u003c\/td\u003e\n\u003ctd data-label=\"Revenue \/ hour\"\u003e$170\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eWater heater installation\u003c\/th\u003e\n\u003ctd data-label=\"Hour mix\"\u003e10%\u003c\/td\u003e\n\u003ctd data-label=\"Revenue \/ hour\"\u003e$375\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eHVAC repairs\u003c\/th\u003e\n\u003ctd data-label=\"Hour mix\"\u003e22%\u003c\/td\u003e\n\u003ctd data-label=\"Revenue \/ hour\"\u003e$210\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eHVAC maintenance\u003c\/th\u003e\n\u003ctd data-label=\"Hour mix\"\u003e10%\u003c\/td\u003e\n\u003ctd data-label=\"Revenue \/ hour\"\u003e$150\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eHVAC replacement\u003c\/th\u003e\n\u003ctd data-label=\"Hour mix\"\u003e18%\u003c\/td\u003e\n\u003ctd data-label=\"Revenue \/ hour\"\u003e$500\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eThese are estimated realized revenues per field labor-hour, not employee hourly wages or separate technician-hour pools.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"formula-text\"\u003e\n\u003cspan class=\"formula-label\"\u003eReconciled 2026 annual revenue build\u003c\/span\u003e\u003cp\u003e352 base sold hours\/month × $259.50 weighted realized revenue\/hour × 12 total seasonal-factor months = $1,096,128.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-costs\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eCOST AND STAFFING PLAN\u003c\/span\u003e\u003ch2\u003eDirect Costs, Overhead and Technician Payroll\u003c\/h2\u003e\n\u003cp\u003eThe forecast separates parts and subcontracting, revenue-linked job costs, fixed overhead, and salaried staffing to calculate operating EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eCOGS assume parts and equipment at 30% of revenue and specialist subcontracting at 2.5%. Variable expenses include collection charges at 2%, fuel at 1.8%, lead generation at 2.5%, and warranties and callbacks at 1.2%.\u003c\/p\u003e\n\u003cp\u003eFixed monthly expenses cover rent, utilities, insurance, vehicle maintenance, software, communications, professional services, training, marketing and expansion leases. Illustrative rent grows from $2,500 to $2,900 per month by 2030.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"costs\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCOGS and Operating Expenses\u003c\/h3\u003e\n\u003cp\u003eThe COGS and Operating Expenses forecast separates revenue-based parts, subcontracting and variable service charges from recurring fixed overhead. This allows the operator to examine which costs rise with job volume and which need separate monthly budgets.\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\u003eTechnician FTE grow from four to eight at $70,000 annual base pay per FTE. The owner-manager remains one FTE at $80,000; dispatch increases from one to 1.5 FTE at $48,000 per FTE.\u003c\/p\u003e\n\u003cp\u003ePayroll totals $408,000 in 2026 and $712,000 in 2030 without duplicating listed COGS. Employer taxes, benefits and personal taxes are outside this case’s assumptions.\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 organizes technicians, the owner-manager and dispatch personnel by staffing level and annual base salary. Hiring dates, annual FTE plans and available payroll controls connect staff expansion to monthly personnel expenses and operating margins.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic8]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section startup-section\" id=\"fml-startup\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eOPENING INVESTMENT\u003c\/span\u003e\u003ch2\u003eStartup Assets and Owner Funding Stay Separate\u003c\/h2\u003e\n\u003cp\u003eOpening vehicles, tools, prelaunch cash needs and working-capital assumptions are modeled separately from the annual operating expense forecast.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eOpening assets include four used service vans for $140,000, tools for $30,000, drain equipment for $16,000, and shop storage and security for $8,000. Computers and dispatch hardware are also planned without a specified amount.\u003c\/p\u003e\n\u003cp\u003ePrelaunch cash covers permits, shop deposit, marketing, preopening pay, setup and insurance. Working-capital controls assume eight receivable days, 22 payable days and 13 inventory days, feeding funding and liquidity schedules.\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 van purchases, equipment, other assets and applicable depreciation. It helps distinguish investment in service capacity from the recurring payments included in 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 owner funding is $481,227 for assets, opening cash, net working capital and three months of first-year recurring outflows. No confirmed outside funding is deducted; equity is not revenue or EBITDA.\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 examines where cash comes from and how it is allocated to operating needs, assets, debt payments and retained cash. Owner funding and optional debt schedules can be evaluated without treating equity contributions as 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 class=\"section soft-section\" id=\"fml-forecast\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eILLUSTRATIVE RESULTS\u003c\/span\u003e\u003ch2\u003eFive-Year Operating Forecast Through EBITDA\u003c\/h2\u003e\n\u003cp\u003eThis case illustrates how rising field-hour availability, utilization and realized service prices flow through the operating expense plan from 2026 to 2030.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative annual Base planning case, 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$1,096,128\u003c\/td\u003e\n\u003ctd data-label=\"Operating expenses\"\u003e$938,851\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$157,277\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$1,539,562\u003c\/td\u003e\n\u003ctd data-label=\"Operating expenses\"\u003e$1,205,305\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$334,257\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$2,061,466\u003c\/td\u003e\n\u003ctd data-label=\"Operating expenses\"\u003e$1,515,146\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$546,320\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2029\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$2,591,517\u003c\/td\u003e\n\u003ctd data-label=\"Operating expenses\"\u003e$1,828,967\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$762,550\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2030\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$3,140,339\u003c\/td\u003e\n\u003ctd data-label=\"Operating expenses\"\u003e$2,138,296\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$1,002,043\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eIllustrative estimates rounded to whole dollars. EBITDA equals revenue less the documented direct, variable, fixed and payroll operating expenses; displayed rounding can create small differences.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eIllustrative revenue rises from $1,096,128 in 2026 to $3,140,339 in 2030 with more available field hours, utilization and realized revenue per hour. Parts, job costs, payroll and overhead also increase.\u003c\/p\u003e\n\u003cp\u003eEBITDA rises from $157,277 to $1,002,043, but excludes depreciation, interest and taxes. It is neither net profit nor free cash flow and does not establish cash sufficiency.\u003c\/p\u003e\n\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 tracks collections, operating payments, capital investment, equity contributions, borrowing, repayments and opening-to-closing cash. It is the appropriate place to test liquidity separately from the illustrated EBITDA path.\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\u003eIllustration, not a guarantee\u003c\/strong\u003e\u003cp\u003eThe displayed projections are estimates for one editable case. No numeric cash balances, net income results or financing sufficiency findings are supplied with the case brief.\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\"\u003eFINANCING AND RETURNS\u003c\/span\u003e\u003ch2\u003eEvaluate Break-Even, Payback and Capital Returns\u003c\/h2\u003e\n\u003cp\u003eThe workbook includes distinct methods to assess operating break-even, cash recovery, invested capital returns and scenario sensitivity.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eReturns separately evaluates sales break-even, cash break-even, investment payback and annual return on invested capital. None can be calculated directly from the illustrative EBITDA figures alone.\u003c\/p\u003e\n\u003cp\u003eDashboard scenarios adjust revenue, COGS, variable expenses, fixed costs and payroll in Low, Base and High cases. Debt Controls support four facilities and alternative repayment structures; no borrowing approval is assumed.\u003c\/p\u003e\n\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 Returns analysis compares sales break-even, cash break-even, investment payback and annual ROIC using their respective schedules. Review these measures after entering actual funding, capital expenditures and working-capital assumptions rather than treating projected EBITDA as an investment return.\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\u003eValuation supports discounted cash flow sensitivity, and Benchmarks and Ratios compare selected indicators. No project valuation, borrowing eligibility, payback date or return percentage is established here.\u003c\/p\u003e\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-fit\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003ePRACTICAL APPLICATIONS\u003c\/span\u003e\u003ch2\u003eWhere This Service Contractor Model Fits\u003c\/h2\u003e\n\u003cp\u003eThis model fits repair-and-replacement contractors constrained by a shared field technician-hour pool, not new construction.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eTest technician hiring, utilization, service mix, realized revenue per hour and overhead across plumbing repairs, drains, water heaters, HVAC repairs, maintenance and replacements.\u003c\/p\u003e\n\u003cp\u003eThis national, mixed-climate US case is not a city-specific quote. Verify local wages, pricing, insurance, rules and demand before relying on projections.\u003c\/p\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\u003eKey details about editing, calculations and interpretation of the plumbing and HVAC financial model.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eDoes each service have its own technician capacity?\u003c\/h3\u003e\n\u003cp\u003eNo. All six services share billable field hours, allocated by service mix and priced separately.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCan I change technician utilization and seasonality?\u003c\/h3\u003e\n\u003cp\u003eYes. Edit available field hours, utilization and twelve monthly seasonal factors.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre technician salaries already included in parts costs?\u003c\/h3\u003e\n\u003cp\u003eNo. Technicians are in Payroll; direct costs include parts, equipment and specialist subcontracting.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the example include startup vehicle purchases?\u003c\/h3\u003e\n\u003cp\u003eYes. Opening assets include four service vans, tools, drain equipment and storage.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eIs the $481,227 owner funding figure revenue?\u003c\/h3\u003e\n\u003cp\u003eNo. It represents estimated initial owner equity, not sales, operating income or confirmed debt.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes EBITDA show cash available to repay debt?\u003c\/h3\u003e\n\u003cp\u003eNo. Review Cash Flow and Debt for working capital, capital spending and financing effects.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes the workbook calculate investment payback?\u003c\/h3\u003e\n\u003cp\u003eYes. Returns calculates payback and break-even; the example establishes no payback date.\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":48218204078323,"sku":"plumbing-hvac-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/plumbing-hvac-financial-model-headimage-financialmodelslab_6e05b3a2-3398-45bf-8926-c8e4c4e6e1d6.webp?v=1765300990","url":"https:\/\/finmodelslab.myshopify.com\/products\/plumbing-hvac-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}