Where a year's money goes
This year's membership income, minus what it costs to service, insure and berth the fleet, and the value the boats lose. Members pay for their own fuel.
Income by membership
Boats per pack
How close to the edge?
Break-even point, and how much room the fleet has before members start fighting over slots.
Which vessels earn their keep
Income shared out by each vessel's share of booked hours, against what that vessel costs to run and how fast it loses value.
The next five years
Members grow, prices rise, costs inflate, engines wear out, boats are sold and replaced, and new boats join when a pack gets crowded. Profit is after depreciation and any loss on selling a boat; cash counts what you actually pay for boats, minus what you get for the old ones.
Fleet renewal plan
How the fleet's value runs down, and when vessels are sold and replaced (at their swap age or when their engine hours run out, whichever comes first) or added under the boats-per-pack rule. Selling a boat brings money back, so the cash you need is the new price minus the sale.
Replacement strategy
Every vessel is sold and replaced at its swap age or when its engine hours run out, whichever comes first. How young should that swap age be? Same members, prices and costs, only the swap policy changes. Click a row to use it.
Replacement timeline
When engines wear out at the projected pace of use, and when boats reach replacement age.
Will the fleet fill up?
Share of all bookable hours (07:00–21:00) taken, as membership grows.
Year by year
Profit and loss
Profit and loss, balance sheet and cash flow, set out the way an accountant presents them, and built from the same assumptions as everything else, so every slider and vessel setting flows through. "This year" is the current twelve months; later columns are the projection. Brackets mean a negative figure.
Balance sheet
What the club owns and owes: today, and at the end of each projected year. Vessels are shown at their book value.
Cash flow statement
Where the cash comes from and goes, year by year.
Your own cost lines
Anything the model doesn't cover yet: accountant, licences, a tender, marina events. Each line is a yearly cost, rises with inflation, and appears in the accounts. You can also just ask Claude to add one.
Basis of preparation
Vessel settings
Every figure here can be changed. Grey figures come from the sliders and the booking data; type over one to fix it for that vessel, and it flows into the overview, projection and renewal plan. Engine hours default to booked hours × the share of each booking under power. The three newest vessels are scaled to a full year by how much of the year's demand falls in the weeks they've been here.
Fleet economics
What each vessel costs and earns a year with the settings above.
When are the boats free?
Share of the 07:00–21:00 day booked, by weekday, over the last 12 months. Pale cells are spare capacity.
Full days: weekends vs weekdays
Spare time this year
Bookable hours left empty per vessel, on a full-year basis.
Members and their packs
Packs are worked out from which vessels each member has booked: anyone who has taken the Virtue Ghost is on Virtue, anyone on the Blue Marlin, Flying Manta or White Pearl is Admiral, Sea Hawk only is Captain, jetskis only is Jet. Correct any member below and every number updates.
On the water
Month by month
Bookings each month, by vessel.