lucix · funding & burn model

Scenarios

Compare scenarios

tick two or more scenarios to compare

Overlaid cash curves

What changed (pick two)

Diff →

Starting point

where you are today

Cash on hand today ($) Model horizon

Founder-invested to date (deck: $300K+ — context only, not counted as cash)

ⓘFounder-invested is shown for context. It is not added to runway cash unless you also put it in “Cash on hand.”

Client tiers

sized by employee count · ARR editable

Tier	Employee band	ARR / client ($)

ⓘARR recognized monthly (ARR÷12), annual recurring, no churn assumed. Contracts persist once live. Schedule new adds below.

Funding — investment tranches

Investment plan

stack tranches over time · 1m yr1 → 3m yr2, etc.

Tranche label	Month in	Amount ($)	Pre-money ($)	% sold
Total	—	—		—

Founders & existing holders

Holder	Starting %
Total	—

Resulting cap table

after all tranches

Founders retain

—

Investors hold

—

Total raised

—

Revenue — client acquisition (bottoms-up)

Acquisition schedule

new clients added per half-year · live day 1 of the half · cumulative shown for context

Enter new adds per tier per half-year (H1 = months 1–6, H2 = 7–12, …). Cumulative rows below each tier show the running active count. ARR builds monthly from the start of each half and never drops (no churn). Adjust tier ARR in card 02.

Spend — payroll

Hiring plan

role · base salary · start month · count

Loaded-cost multiplier

Role	Base salary ($)	Start month	Count	Loaded / yr
Total at full ramp			—	—

Loaded cost = base × multiplier (employer taxes, benefits, equipment). Founders at $0 salary per deck — add rows only for hires. Multiplier is an assumption; verify against real burden for your state/benefits.

Business & hard costs

recurring monthly + one-time line items

Item	Type	Amount ($)	Month / step (see type)	Per N clients
Recurring / mo (at horizon end)		—	one-time total →	—

Three types: monthly (flat recurring) · one-time (hits cash in the month set) · stepped (base amount + one increment of “Amount” for every N active clients crossed — models support/infra scaling with the book). SOC 2, legal, infra seeded as placeholders — overwrite with real quotes.

Result — runway & burn

Cash over time

Total cash in

—

start + tranches

Peak monthly burn

—

net, worst month

Runway to zero

—

from today

Cash at horizon end

—

ARR run-rate (end)

—

— clients

— cash balance - - - zero line hover a point for the month

Annual summary

Year	Raised	Revenue	Payroll	Other costs	Net burn	End cash

Internal scratchpad · lucix · Nick + Ryan · all figures are editable assumptions, none validated · nothing saved server-side

ⓘ This tab reads your tranches, founder split, and raise from the Funding tab and models what everyone walks away with at a sale. Preference terms below are your assumptions — real term sheets vary, and stacking/seniority edge cases aren't modeled. Not legal or financial advice; confirm any real term with counsel.

Exit value

the headline sale price

Sale price ($)

Employee option pool (% of fully-diluted — dilutes everyone)

The pool is carved out of the fully-diluted cap table before the waterfall, so founders and investors both shrink proportionally to make room for it. Unallocated pool shares fold back into common at exit (simplification).

Preference terms per round

what each investor negotiated

Round	Invested ($)	Ownership %	Pref multiple	Participating?

Pref multiple: how many times their money an investor takes off the top before common (1× standard). Participating: ON = takes preference and their ownership share of the rest (“double dip”, founder-unfriendly); OFF = takes the greater of preference or converting to common (1× non-participating, the standard founder-friendly case). SAFEs modeled as converting at cap, then 1× non-participating.

Who gets what

Founders walk away with

—

— of exit

Founder	Ownership	Take-home

Founder take-home across exit values

the shape is the insight — where investors flip from preference to converting

Highlighted cells mark where a round flips between taking its preference and converting to common. Below the flip, preferences eat a bigger share; above it, investors convert and founders keep their full ownership slice.

Exit modeling · simplified waterfall (option pool → participating prefs → non-participating convert-or-pref → common) · edge cases and tax not modeled