Revenue and Calc
Enter monthly block-start capacity, pounds per block, annual utilization, mushroom shares and prices. Monthly calculations allocate one harvest pool across five varieties.

This Mushroom Farming Financial Model is an Excel template for 2026–2030 monthly indoor farm projections. It converts purchased fruiting blocks, harvest yield, variety mix, prices, staffing and operating costs into financial reports.
The illustrative business is a 2,000-square-foot leased Northeast U.S. facility with four climate rooms, selling fresh culinary mushrooms from purchased blocks. Its financial projections are assumptions, not historical farm results.
Operating drivers feed connected cost schedules and financial reports, so changes to production assumptions can be reviewed across the workbook.
Enter monthly block-start capacity, pounds per block, annual utilization, mushroom shares and prices. Monthly calculations allocate one harvest pool across five varieties.
Model purchased blocks, selling charges, facility overhead and staffing separately. Edit annual-average FTE and role salaries without counting base payroll twice.
Plan room improvements, equipment spending and owner equity through CAPEX and CapTable; Dashboard debt controls and Debt schedules support optional borrowing cases.
Dashboard and Scenarios compare Low, Base and High results. Returns evaluates break-even, project payback and annual ROIC, while Checks helps review model consistency.
A shared capacity pool of fruiting-block starts converts to saleable pounds, which are distributed across five mushroom varieties and priced once.
At full use, 2,600 purchased ready-to-fruit blocks can start each month. Each started block yields one saleable pound, with planned utilization growing from 50% in 2026 to 85% in 2030; unused capacity is not purchased.
The harvested-pound pool is allocated to oyster (35%), shiitake (20%), lion’s mane (20%), chestnut (15%) and king oyster (10%). Their respective prices are $14, $16, $18, $17 and $17 per pound, resulting in a $15.95 blended selling price.
The Revenue Forecast connects block-start capacity, utilization, saleable pounds, variety shares and selling prices to monthly sales. Its shared harvest pool prevents the same pound from being counted in more than one revenue stream.
2,600 blocks/month × 12 months × 50% utilization × 1 pound/block × $15.95/pound = $248,820 revenue.
The case assumes 60% local wholesale invoices and 40% direct sales, but the illustrated revenue calculation uses variety prices rather than separate prices by channel. There is no additional demand limiter or monthly seasonal adjustment.
The January 31, 2026 launch uses a full sales month with a crop prepared beforehand; earlier months are zero.
COGS, variable selling expenses, fixed facility costs and base salaries are modeled as separate, nonoverlapping expense categories.
Purchased fruiting blocks and inbound freight consume 38% of revenue, packaging and labels 3%, and growing consumables 1%. Combined direct costs are 42% of sales, or $104,504 in the illustrated 2026 forecast.
Variable expenses include local delivery fuel and mileage at 2.5%, sales channel fees at 2%, and card processing at 1.34% of revenue. These total 5.84%, so both direct and variable costs scale with modeled sales.
The COGS and Operating Expenses forecast distinguishes direct crop expenses, sales-linked charges and fixed climate-room overhead. It separates production economics from recurring site costs.
Fixed expenses total $61,200 annually in this case, including facility rent and occupancy of $3,000 per month. Other fixed costs include climate control, insurance, repairs, administration, food safety and waste removal.
The manager remains at 1.0 FTE, the grower rises from 1.0 to 1.5 FTE, and packing support from 0.25 to 0.5 FTE. Annual base salaries per FTE are $55,000, $38,000 and $36,000 respectively.
The Payroll Forecast calculates monthly personnel expenses using role-level FTE and salaries. Base payroll grows from $102,000 in 2026 to $130,000 in 2030 without double-counting other costs.
Startup equipment, distinct preopening cash expenses and working capital are planned separately from recurring operating EBITDA.
Four specified initial asset inputs total $62,000: room improvements ($22,000), HVAC and humidity equipment ($18,000), production racks ($12,000), and refrigeration ($10,000). Other asset lines include a used vehicle, packing equipment and environmental monitoring, with amounts unspecified.
The Capital Expenditure Plan schedules room improvements, refrigeration and other equipment purchases while distinguishing depreciable spending. CAPEX affects investing cash flows, not operating EBITDA.
Separate opening cash items include a refundable deposit, permits, preopening payroll, marketing, training, and preopening rent and utilities. Working-capital inputs assume eight receivable days, zero payable days and 21 inventory days, which can shift cash timing independently of EBITDA.
Sources and Uses of Funds connects owner equity and other funding inputs to operating, investing and financing uses. Estimated owner funding of $188,798 is not committed outside capital or a tested minimum.
Revenue rises with utilization, while higher staffing and recurring site costs determine whether annual EBITDA is positive or negative.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $248,820 | $282,235 | -$33,415 |
| 2027 | $323,466 | $332,846 | -$9,380 |
| 2028 | $373,230 | $369,753 | $3,477 |
| 2029 | $398,112 | $381,657 | $16,455 |
| 2030 | $422,994 | $393,560 | $29,434 |
Planning projections rounded to whole dollars; small differences can arise from presentation rounding.
The illustrative base case produces negative EBITDA in 2026 and 2027 before turning positive in 2028. The 2030 projected EBITDA of $29,434 is operating earnings before interest, taxes, depreciation and amortization, not net profit or free cash flow.
The Income Statement can be used to examine operating and accounting margins, while the Balance Sheet tracks receivables, inventory, equipment and financing balances. No specific net profit, balance-sheet total or cash balance is established by the supplied case outputs.
The Cash Flow Forecast tracks operating receipts and payments, capital purchases, financing movements and opening-to-closing cash reconciliation. It helps examine whether wholesale receivables, inventory and setup spending create liquidity needs that cannot be inferred from EBITDA alone.
Sales break-even, cash break-even, investment payback and annual ROIC answer different questions about operating coverage and capital recovery.
Sales break-even compares the required revenue with operating cost coverage. Cash break-even uses project cash flows, while investment payback tracks when cumulative project cash flows recover invested capital; ROIC relates operating returns to capital employed.
The Dashboard’s Low, Base and High scenario multipliers allow changes to revenue, COGS, variable expenses, fixed expenses and payroll. These are user-adjustable tests, not a prediction of demand, valuation or financing approval.
The Returns report distinguishes operating sales break-even, cash break-even, investment payback and annual ROIC. This case supplies no payback date, ROIC or IRR figure.
These answers describe the scope and calculation methods of the Excel model and its illustrated indoor farm.
Yes. Revenue inputs let you change block starts, saleable pounds per block, utilization, variety shares and prices to recalculate the forecast.
No. The documented farm buys ready-to-fruit blocks and forecasts indoor fruiting; in-house substrate or spawn production is outside this case.
Yes. The planning case assumes 60% wholesale invoices and 40% direct sales, but calculates illustrated revenue from variety-level volume and price.
The documented operating illustration excludes employer taxes and benefits. The standard Payroll sheet includes payroll-tax controls for alternate modeling assumptions.
Estimated owner funding of $188,798 covers planned assets, separate startup cash items, physical working capital and a reserve; it does not prove cash sufficiency.
Yes. The workbook includes Income Statement, Cash Flow and Balance Sheet reports, though the case figures provided here stop at operating EBITDA.
Yes. Dashboard scenarios modify revenue and expense assumptions, while optional debt controls support financing schedules without implying that a loan is available.
No. The 2026–2030 amounts are illustrative model assumptions and projected outcomes, not measured industry averages or guarantees.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
This template kept one broken cell from throwing off the whole model, which saved me from hours of cleanup. I could trust the outputs and move on to planning instead of chasing spreadsheet errors.
Starting from a blank workbook felt huge, but this gave me a clear place to begin. I had a working mushroom farm forecast in under an hour instead of spending a day guessing at structure.
The break-even and margin tabs made it much easier to see what really drives profit in mushroom farming. I booked a lender call with cleaner assumptions and a clearer view of the numbers.