{"product_id":"greenhouse-farming-financial-model","title":"Greenhouse Farming Financial Model and Projections Template","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 Greenhouse Farming Financial Model is an Excel template for planning a heated deep water culture greenhouse in Missouri. It connects growing capacity, saleable lettuce output, wholesale prices, operating costs, and staffing to financial projections.\u003c\/p\u003e\n\u003cp\u003eThe illustrative case uses a 20,000-square-foot greenhouse on leased land, selling five whole-head lettuce varieties to local grocers and foodservice buyers. The forecast covers 2026–2030 from a January 31, 2026 launch, in nominal US dollars excluding sales tax.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdl class=\"product-facts\" aria-label=\"Financial model facts\"\u003e\n\u003cdiv\u003e\n\u003cdt\u003eForecast\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eyears\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eLettuce varieties\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e5\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eone capacity pool\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eUsable crop area\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e85%\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eof gross footprint\u003c\/span\u003e\n\u003c\/dd\u003e\n\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdt\u003eStaffing\u003c\/dt\u003e\n\u003cdd\u003e\n\u003cstrong class=\"fact-value\"\u003e4.75\u003c\/strong\u003e\u003cspan class=\"fact-detail\"\u003eannual-average 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\"\u003eWORKBOOK CONTENTS\u003c\/span\u003e\u003ch2\u003eEdit Operating Inputs and Review Financial Reports\u003c\/h2\u003e\n\u003cp\u003eThe workbook connects editable greenhouse assumptions to monthly calculations, scenario comparisons, and financial 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\u003eChange footprint, usable area, head output, utilization, variety shares, and prices; monthly calculations translate those inputs into sold heads and revenue.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eCOGS \u0026amp; OPEX and Payroll\u003c\/h3\u003e\n\u003cp\u003eAdjust revenue-linked costs, monthly overhead, annual-average FTE, and salaries to evaluate the expense structure supporting greenhouse production and delivery.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDashboard \u0026amp; Scenarios\u003c\/h3\u003e\n\u003cp\u003eCompare Low, Base, and High multipliers for revenue, COGS, variable expenses, fixed expenses, and payroll; the selected scenario feeds management reporting.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eIS, CF, BS \u0026amp; Summary\u003c\/h3\u003e\n\u003cp\u003eReview income, cash movement, assets, liabilities, and equity through the financial statements and combined summary after completing the relevant assumptions.\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 Lettuce Capacity\u003c\/h2\u003e\n\u003cp\u003eThe revenue forecast allocates saleable heads across five mutually exclusive varieties, then multiplies each allocation by its wholesale price.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eGross area multiplied by the 85% usable share provides 17,000 square feet of crop area. At 2.5 theoretical heads per net square foot monthly, capacity is 42,500 heads before applying saleable utilization.\u003c\/p\u003e\n\u003cp\u003eUtilization rises from 55% in 2026 to 88% in 2030 and already incorporates crop losses and unsold output. Continuous staggered production has no seasonal output multiplier.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative variety mix and wholesale prices, USD per head\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eVariety\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eShare\u003c\/th\u003e\n\u003cth scope=\"col\"\u003e2026 price\u003c\/th\u003e\n\u003cth scope=\"col\"\u003e2030 price\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eButterhead\u003c\/th\u003e\n\u003ctd data-label=\"Share\"\u003e30%\u003c\/td\u003e\n\u003ctd data-label=\"2026 price\"\u003e$1.85\u003c\/td\u003e\n\u003ctd data-label=\"2030 price\"\u003e$2.04\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eRomaine\u003c\/th\u003e\n\u003ctd data-label=\"Share\"\u003e25%\u003c\/td\u003e\n\u003ctd data-label=\"2026 price\"\u003e$1.75\u003c\/td\u003e\n\u003ctd data-label=\"2030 price\"\u003e$1.93\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eGreen oakleaf\u003c\/th\u003e\n\u003ctd data-label=\"Share\"\u003e15%\u003c\/td\u003e\n\u003ctd data-label=\"2026 price\"\u003e$1.80\u003c\/td\u003e\n\u003ctd data-label=\"2030 price\"\u003e$1.99\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eRed oakleaf\u003c\/th\u003e\n\u003ctd data-label=\"Share\"\u003e15%\u003c\/td\u003e\n\u003ctd data-label=\"2026 price\"\u003e$1.90\u003c\/td\u003e\n\u003ctd data-label=\"2030 price\"\u003e$2.10\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eGreen leaf\u003c\/th\u003e\n\u003ctd data-label=\"Share\"\u003e15%\u003c\/td\u003e\n\u003ctd data-label=\"2026 price\"\u003e$1.70\u003c\/td\u003e\n\u003ctd data-label=\"2030 price\"\u003e$1.88\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eGreen leaf receives the residual share after the four selected shares; each sold head is allocated once.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"revenue\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eRevenue Forecast\u003c\/h3\u003e\n\u003cp\u003eThe Revenue Forecast connects operating drivers, sold volume, prices, and sales by variety. Use it to examine whether higher utilization or a different variety mix supports the revenue plan.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic2]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"formula-text\"\u003e\n\u003cspan class=\"formula-label\"\u003e2026 annual revenue illustration\u003c\/span\u003e\u003cp\u003e23,375 sold heads\/month × $1.8025 weighted price\/head × 12 months ≈ $505,601 annual revenue.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eThe launch rule activates months whose period-end date falls on or after January 31, 2026, so January is included. Annual input selections determine each forecast year’s utilization and prices.\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\u003eSeparate Crop Costs, Overhead, and Base Payroll\u003c\/h2\u003e\n\u003cp\u003eOperating expenses combine revenue-linked COGS and variable costs with fixed monthly overhead and separately calculated payroll.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eEstimated COGS total 19% of revenue: seeds and plugs 4%, nutrients 3%, boxes and liners 10%, crop health inputs 1%, and sanitation supplies 1%. Variable expenses total 5%: freight and fuel 3%, collection losses and payment fees 0.5%, and selling commissions 1.5%.\u003c\/p\u003e\n\u003cp\u003eFixed overhead covers premises, heating, cooling, electricity, water, maintenance, insurance, administration, testing, marketing, software, and supplies. The 2026 land lease input is $1,000 monthly for 12 paid months; total fixed expenses are $222,600 that year.\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 organizes direct, variable, and fixed costs by assumption and timing. It helps assess how additional sales contribute toward covering the greenhouse’s fixed overhead.\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 staffing and annual base salaries, USD\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eRole\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eAverage FTE\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eAnnual base\/FTE\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eGreenhouse manager\u003c\/th\u003e\n\u003ctd data-label=\"Average FTE\"\u003e1\u003c\/td\u003e\n\u003ctd data-label=\"Annual base\/FTE\"\u003e$65,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eCrop technicians\u003c\/th\u003e\n\u003ctd data-label=\"Average FTE\"\u003e3\u003c\/td\u003e\n\u003ctd data-label=\"Annual base\/FTE\"\u003e$38,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003ePacking and delivery\u003c\/th\u003e\n\u003ctd data-label=\"Average FTE\"\u003e0.75\u003c\/td\u003e\n\u003ctd data-label=\"Annual base\/FTE\"\u003e$40,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eFTE measures staffing capacity, not necessarily the number of individual employees.\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 calculates personnel costs from role-level staffing and compensation. The selected 4.75 FTE produce $209,000 of annual base payroll throughout this case, counted separately from COGS and other operating expenses.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic8]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eEmployer taxes, benefits, and personal taxes are excluded from the supplied case. Review these exclusions before adapting the staffing plan to your operation.\u003c\/p\u003e\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section startup-section\" id=\"fml-startup\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eSTARTUP AND FUNDING\u003c\/span\u003e\u003ch2\u003ePlan Startup Investment Separately From Operating Earnings\u003c\/h2\u003e\n\u003cp\u003eEstimated initial owner funding is $1,052,667, covering assets, other preforecast cash, opening working capital, and a three-month reserve.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"capex\" data-fml-side=\"left\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eCapital Expenditure Plan\u003c\/h3\u003e\n\u003cp\u003eThe Capital Expenditure Plan schedules asset spending and depreciation. The $870,000 startup asset budget includes the greenhouse structure, environmental controls, DWC beds, nursery equipment, cold storage, handling equipment, backup power, a vehicle, and site infrastructure.\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=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative opening funding allocation, USD\u003c\/caption\u003e\n\u003cthead\u003e\u003ctr\u003e\n\u003cth scope=\"col\"\u003eFunding use\u003c\/th\u003e\n\u003cth scope=\"col\"\u003eAmount\u003c\/th\u003e\n\u003c\/tr\u003e\u003c\/thead\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eStartup assets\u003c\/th\u003e\n\u003ctd data-label=\"Amount\"\u003e$870,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eOther preforecast cash\u003c\/th\u003e\n\u003ctd data-label=\"Amount\"\u003e$29,000\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eOpening net working capital\u003c\/th\u003e\n\u003ctd data-label=\"Amount\"\u003e$15,431\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003eThree-month reserve\u003c\/th\u003e\n\u003ctd data-label=\"Amount\"\u003e$138,236\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003ctfoot\u003e\u003ctr\u003e\n\u003cth scope=\"row\"\u003eInitial owner funding\u003c\/th\u003e\n\u003ctd data-label=\"Amount\"\u003e$1,052,667\u003c\/td\u003e\n\u003c\/tr\u003e\u003c\/tfoot\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eWhole-dollar presentation; component rounding may cause small differences.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"media-explainer\" data-fml-topic=\"funding\" data-fml-side=\"right\"\u003e\n\u003cdiv class=\"section-copy\"\u003e\n\u003ch3\u003eSources and Uses of Funds\u003c\/h3\u003e\n\u003cp\u003eSources and Uses of Funds reconciles funding sources with cash allocation over a selected period. Use it to review the planned owner contribution alongside investment and operating payments; this case has no committed external funding.\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\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eWorking-capital controls assume 10 receivable days, 15 payable days, and 21 inventory days. These timing inputs affect liquidity planning; the opening working-capital allocation and reserve do not establish tested cash sufficiency.\u003c\/p\u003e\n\u003cp\u003eOther preforecast cash includes refundable deposits, training and testing, launch samples and marketing, and paid crop commissioning labor. These opening items are separate from annual operating expenses.\u003c\/p\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\u003eReview Five Years of Revenue and EBITDA\u003c\/h2\u003e\n\u003cp\u003eThe supplied operating forecast ends at EBITDA and illustrates how increasing saleable utilization and prices affect operating earnings.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"table-shell\"\u003e\n\u003ctable class=\"data-table\"\u003e\n\u003ccaption\u003eIllustrative annual 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$505,601\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$552,944\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e-$47,343\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2027\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$612,281\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$585,225\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$27,055\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2028\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$724,455\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$619,025\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$105,430\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2029\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$811,308\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$646,955\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$164,353\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003cth scope=\"row\"\u003e2030\u003c\/th\u003e\n\u003ctd data-label=\"Revenue\"\u003e$893,112\u003c\/td\u003e\n\u003ctd data-label=\"Operating Expenses\"\u003e$673,885\u003c\/td\u003e\n\u003ctd data-label=\"EBITDA\"\u003e$219,227\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp class=\"table-note\"\u003eSource results are independently rounded to whole dollars; displayed revenue less expenses can differ slightly from displayed EBITDA.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eAnnual EBITDA becomes positive in 2027 and reaches $219,227 in 2030. This is an illustrative operating result, not evidence of net profit, investment recovery, or cash break-even.\u003c\/p\u003e\n\u003cp\u003eThe case uses estimated planning inputs, not observed greenhouse performance or verified industry averages. Supporting references do not independently validate the selected assumptions.\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 operating, investing, and financing cash movements with an opening-to-closing cash reconciliation. Review collection timing, inventory, supplier payments, asset purchases, and financing before drawing conclusions about liquidity.\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 RETURNS\u003c\/span\u003e\u003ch2\u003eEvaluate Cost Coverage, Cash Recovery, and Returns\u003c\/h2\u003e\n\u003cp\u003eThe Returns report separates sales break-even, cash break-even timing, investment payback, and annual return on invested capital.\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 revenue with break-even requirements and tracks project cash flow, cumulative free cash flow, invested capital, and ROIC. Use these measures to evaluate operating coverage and investment recovery separately.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"workbook-media\"\u003e\n[dynamic_pic4]\n\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\n\u003cp\u003eSales break-even concerns revenue needed to cover operating costs; cash break-even concerns cash flow timing. Investment payback tracks recovery of invested cash, while annual ROIC assesses the return generated on invested capital.\u003c\/p\u003e\n\u003cp\u003eDashboard Debt Controls feed financing schedules for facility amounts, dates, interest rates, and repayment structures. Enter an actual financing proposal to evaluate debt payments; the supplied EBITDA figures establish no borrowing terms or payback date.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\u003c\/section\u003e\u003csection class=\"section\" id=\"fml-fit\"\u003e\u003cdiv class=\"container\"\u003e\n\u003cdiv class=\"section-heading\"\u003e\n\u003cspan class=\"eyebrow\"\u003eMODEL FIT\u003c\/span\u003e\u003ch2\u003eBuilt for Wholesale Whole-Head Lettuce Planning\u003c\/h2\u003e\n\u003cp\u003eThis template fits an owner-operated DWC greenhouse selling whole heads through a shared production area.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"text-copy\"\u003e\u003cp\u003eUse it to test utilization targets, wholesale prices, variety allocation, staffing, and overhead before committing capital. Operations with different crops, production cycles, or sales units should review the revenue mechanics before reusing this structure.\u003c\/p\u003e\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\u003eQuestions About the Greenhouse Farming Financial Model\u003c\/h2\u003e\n\u003cp\u003eThese answers clarify the case assumptions, editable drivers, and limits of the illustrated results.\u003c\/p\u003e\n\u003c\/div\u003e\n\u003cdiv class=\"faq-grid\"\u003e\n\u003carticle\u003e\u003ch3\u003eCan I change the greenhouse size and production assumptions?\u003c\/h3\u003e\n\u003cp\u003eYes, edit gross footprint, usable share, monthly heads per net square foot, saleable utilization, variety shares, and wholesale prices to build a different operating case.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes each lettuce variety have its own production capacity?\u003c\/h3\u003e\n\u003cp\u003eNo, all five varieties share the same crop area, with four selected shares and one residual share allocating each saleable head once.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eShould I deduct crop losses again?\u003c\/h3\u003e\n\u003cp\u003eNo, the saleable utilization assumption already includes crop losses and unsold output, so another deduction would count those losses twice.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eDoes positive EBITDA prove the greenhouse has enough cash?\u003c\/h3\u003e\n\u003cp\u003eNo, EBITDA excludes depreciation, interest, and taxes and does not capture working-capital timing, asset purchases, or financing flows; review the cash flow statement separately.\u003c\/p\u003e\u003c\/article\u003e\u003carticle\u003e\u003ch3\u003eAre the example results verified industry benchmarks?\u003c\/h3\u003e\n\u003cp\u003eNo, the forecast uses estimated case assumptions and illustrates model calculations; it does not establish industry averages, guaranteed earnings, or a tested investment payback.\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":48218062815475,"sku":"greenhouse-farming-financial-model","price":109.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0522\/6191\/2762\/files\/greenhouse-farming-financial-model-headimage-financialmodelslab_60f269a3-7b49-4441-bec4-d7d55621451d.webp?v=1765298611","url":"https:\/\/finmodelslab.myshopify.com\/products\/greenhouse-farming-financial-model","provider":"Financial Models Lab Templates","version":"1.0","type":"link"}