Every driver behind the Series A forecast — paying GCs, ARPA, gross margin and operating expense. Edit any cell and Revenue, Gross Profit and EBITDA recompute live on the Statements page.
| Driver | Y1 | Y2 | Y3 | Y4 | Y5 |
|---|---|---|---|---|---|
| Paying GCs | |||||
| ARPA ($/yr) |
| Driver | Y1 | Y2 | Y3 | Y4 | Y5 |
|---|---|---|---|---|---|
| Gross Margin % | |||||
| Operating Expense ($) |
These four rows are the deck's own published metrics (NRR, LTV:CAC, CAC payback, TAM/SAM/SOM). No cohort-level CAC/LTV breakdown exists in the source material to re-derive them from within this model, so they're shown read-only rather than invented.
| Metric | Y1 | Y2 | Y3 | Y4 | Y5 |
|---|---|---|---|---|---|
| Net Revenue Retention % | |||||
| LTV:CAC (x) | |||||
| CAC Payback (months) |
| TAM (global preconstruction) | ||||
| SAM (US commercial GC) | ||||
The calc chain: Revenue (Paying GCs × ARPA) → COGS → Gross Profit → less Operating Expense → EBITDA. Every cell here is a live formula reading off the Assumptions page.
| Line | Y1 | Y2 | Y3 | Y4 | Y5 |
|---|
Revenue reconciles to the deck's own published Y1-Y5 figures ($2.8M / $6.4M / $13.5M / $27.0M / $48.0M) to within 0.22% — the small residual is rounding noise from whole-number GC-count × whole-dollar-ARPA inputs, not a modeling gap. EBITDA matches the published figures exactly in every year.
Headline KPIs and the live valuation build. The Series A ask ($15M at $45.0M pre / $60.0M post / 25.0% dilution) reconciles from the 6-method blend below — edit any method's output or weight and the pre-money, post-money and dilution figures recompute instantly.
Weighted pre-money = SUMPRODUCT(method output, weight). Matches PLUMBLINE_CONTENT.md's published $45.0M pre-money to the cent at the deck's own weights: Berkus 10% / Risk Factor Summation 15% / Scorecard 15% / VC Method 25% / DCF 15% / First Chicago 20%.