Beekeeping Cash-Flow & NPV Lab (2D)

Business Plan

Starting hives 10

Annual hive growth 15%

Honey price $7.0/kg

Projection horizon 7y

Discount rate (for NPV) 8%

Year-3 scenario

Live Readout

Total revenue

—

Total cost

—

Net profit

—

Break-even year

—

NPV @ discount rate

—

Hives (final year)

—

How it works

Hive count grows compound-style from the starting count at the chosen annual rate. A newly-added hive needs a season to build comb and colony strength, so it yields far less honey than a mature one in its first year:

hives(i)   = round(hives0 · (1+g)^(i-1))
new(i)     = hives(i) − hives(i-1)
yieldKg(i) = mature(i)·22 + new(i)·9      [kg]
revenue(i) = yieldKg(i) · price
cost(i)    = 1400 + hives(i)·45 + new(i)·130
profit(i)  = revenue(i) − cost(i)
NPV        = Σ profit(i) / (1+r)^i

The discount-rate slider prices in the time-value of money: a dollar of profit five years out is worth less today than a dollar this year, so the NPV panel below the bar chart discounts every year's profit and plots the running total — a plan can show a positive undiscounted profit yet a negative NPV if most of the payoff sits far in the future.

Bar chart — revenue (gold), cost (red) and profit (green/red) per year, scaled to the largest bar on screen.
Cash-flow line — cumulative (undiscounted) profit; crosses zero at the break-even year.
NPV panel — each year's profit discounted back to today at the chosen rate, plus the running discounted total.

Revenue Cost Profit Cumulative cash flow