Deciding whether to expand an apiary is a capital-budgeting problem: you spend money up front on hives, nucs and equipment, then earn honey revenue each season while paying for feed, treatments and colony replacement. This scene turns that spreadsheet into a 3D yard. A row of hive boxes sits on the ground — faded boxes represent colonies lost to winter or disease. Above the yard, a bar rises or sinks for every year of the model: green bars are years the operation is cash-flow positive, red bars are years it isn't. A glowing line traces the running cumulative cash balance and crosses a break-even plane at the payback year.
In most cost models, colony losses — not honey price swings — are the single biggest driver of apiary profitability, because every lost hive has to be replaced at close to the original capital cost before it can earn anything back.
A live 3D cash-flow model for an apiary business: a yard of hive boxes represents colony count and losses, while a bar chart and cumulative cash-flow line above it show exactly when the operation pays back its start-up investment.
Each year's net cash flow is honey revenue (hive count × yield × price) minus operating costs and the capital cost of replacing colonies lost that winter. The rising or falling bars and the glowing cumulative line make the payback year and long-run ROI immediately visible.
Adjust hive count, honey price, colony loss rate and start-up cost per hive. Watch the bar chart and hive yard update live, and read off the payback period and 8-year ROI in the side panel.
Because every lost colony must be replaced at close to full capital cost before it earns anything back, colony loss rate is often a bigger swing factor in apiary profitability than honey price itself.