Dashboard & Scenario Simulator

Model parameters

Editable project launch, initial investment, capital expenditure and full-capacity overheads. Monthly costs equal full-capacity overheads multiplied by Overheads%. Channel ramp timing, revenue ceilings and gross margins are in Sales Channels. Changes recalculate every statement and chart.

Project launch

Initial investment in business $CAPEX $Overheads $

Sales Channels

Launch and full capacity are month numbers in the 36-month model. Full capacity, $ is each channel’s monthly revenue ceiling. GM, % sets its gross margin rate. Subcontracted direct sales cover demand while own direct sales ramp up: their share equals their own ramp minus the direct-sales ramp, so they fade out as direct sales reach full capacity.

Channel	Full capacity, $	GM, %
DirectSalesSubcontr	DirectSalesSubcontr Full capacity, $	%
DirectSales	DirectSales Full capacity, $	%
BrandSales	BrandSales Full capacity, $	%
OtherSales	OtherSales Full capacity, $	%

CAPEX split by month

Share of total CAPEX spent in each of the first 12 months. Month 12 adjusts automatically so the total is always 100%. CF Investment each month equals CAPEX multiplied by that month’s share.

M1%180'000M2%60'000M3%120'000M4%30'000M5%0M6%0M7%0M8%0M9%0M10%0M11%60'000M12 (auto)%150'000

Overheads%

Monthly overheads equal the Overheads $ full-capacity amount multiplied by the monthly percentage. Months 1–12 use the source schedule and are editable. From month 13, the source rule is 50% when DirectSales capacity is below 30%, otherwise 100%.

M1%68'248M2%68'248M3%68'248M4%74'086M5%81'176M6%82'276M7%88'267M8%88'267M9%110'000M10%110'000M11%110'000M12%110'000

Peak Monthly Revenue

The sum of maximum monthly Direct, Brand and Other revenue, reached when all channels are at full capacity. Subcontracted direct sales are zero by then, because own direct sales have replaced them.

$680'768

Sum of channel ceilings

Peak Monthly Net Profit

Maximum revenue for each channel multiplied by its editable gross-margin rate, then summed with full-capacity monthly overheads.

$86'604

GM $196'604 + Overheads

3-Year Total Revenue

The sum of total monthly revenue from all four sales channels across all 36 modeled months.

$20'237'302

3-Year Total Net Profit

The sum of monthly profit over 36 months. Each month’s profit is gross margin plus negative overheads.

$1'987'938

Minimum Cash Cushion

The lowest monthly closing cash balance in the 36-month forecast. Closing balance equals opening balance plus operating, investment and financial cash flow.

$179'240

Lowest at month 7

Operational Breakeven

The first modeled month in which monthly profit (gross margin plus overheads) is zero or positive.

Month 8

Month 8 · Aug 27

Project Payback (CAPEX + Cash Burn)

Month 20

Recovers $600'000 CAPEX + $220'760 ramp-up losses

Methodology & comparison →

Equity Payback ($1'000k)

Month 25

$1'987'938 profit earned in 36 months

Methodology & comparison →

Monthly revenue by channel

Each channel’s maximum monthly revenue multiplied by its ramp factor. Before launch the factor is zero, then it rises linearly to one at full capacity. Areas are stacked to show total revenue.

Revenue, gross margin, overheads & profit

Revenue is the sum of channel sales. Gross margin is each channel’s revenue multiplied by its source margin rate. Profit is gross margin plus negative monthly overheads.

Net cash flow & closing cash balance

Net cash flow equals CF Operations (profit) + CF Investment (CAPEX spread over months 1–12) + CF Financial activity (financing in month 1). Closing cash equals opening cash plus net cash flow.

Investment payback coverage

The initial investment amount is read from CF Financial activity in month 1. The bars show cumulative CF Operations plus CF Investment, including CAPEX and ramp-up losses. The first month these project cash flows equal or exceed financing is marked. This is distinct from Project Payback (CAPEX + Cash Burn) above; it does not model any financing repayment schedule.

CF Financial activity funding: $1'000'000 · Funding covered: Month 32