Thesis: Boards don’t need prettier sheets; they need fewer, decision-ready numbers with context, confidence, and clear asks. Your job isn’t to dump metrics—it’s to tell a defensible story that ends in a decision you want approved.
1) What “board‑ready” actually means
- Decision-first: Every table/chart answers So what? and Now what?
- Consistent definitions: One metric dictionary; GAAP-aware and unit‑economics aligned.
- Timeboxed horizons: Last 13 months, Quarter‑to‑date (QTD), and Next 2–4 quarters.
- Confidence shown: P50/P80/P95 forecasts; call out assumptions and risks.
- One level deeper: For each red/yellow, include the driver chart you’ll reference if asked.
Board‑ready test: If you removed the labels, could an operator guess the decision you’re proposing?
2) The Board Packet (8 sections, 12–18 slides/tabs)
- Executive Summary (1 page) — What changed, why, what we’re asking for.
- Scorecard — NSM + guardrails + financial core.
- ARR/Revenue Bridge — Start → New → Expansion → Contraction → Churn → End.
- Unit Economics — CAC, CAC payback, LTV:CAC, Burn multiple, Gross margin.
- Pipeline & Forecast — coverage, win rates, cycle, weighted forecast with confidence bands.
- Cohorts & Retention — NRR by cohort/segment; payback reality check.
- Initiatives & Experiments — what we tried, causal results, next bets.
- Risks & Decisions — top risks with mitigations; clear asks (budget, hiring, pricing, market entry).
3) Scorecard — the 15 numbers that run the business
Growth
- ARR / MRR (level and Δ QoQ/MoM)
- New ARR, Expansion ARR, Gross/Net Churn
- NRR (Net Revenue Retention)
Go‑to‑market
- Pipeline coverage (next quarter)
- Win rate & Sales cycle (days)
- SQL rate (or Activated Teams for PLG)
Unit economics
- CAC, CAC Payback (months)
- LTV:CAC
- Gross margin
- Burn multiple (Net burn / Net new ARR)
- Runway (months)
Guardrails
- Refund/chargeback rate, P95 latency/INP, NPS/CSAT
Decision rule: If NSM ↑ and guardrails stay green, proceed with plan; if guardrail turns red, freeze related experiments.
4) Formulas (paste‑ready)
- NRR =
(Start MRR + Expansion − Contraction − Churn) / Start MRR - GRR =
(Start MRR − Churn − Contraction) / Start MRR - CAC (blended) =
Sales & Marketing Spend in Period / # New Customers - CAC Payback (months) =
CAC / (ARPA × Gross Margin) - LTV (months) =
ARPA × Gross Margin × (1 / Churn_rate_monthly) - Burn Multiple =
Net Burn / Net New ARR - Runway (months) =
Cash / Net Burn - Pipeline Coverage =
Pipeline for next qtr / Bookings target next qtr - Weighted Forecast =
Σ (Deal Amount × Stage Probability)
5) Charts that boards understand (and why)
- ARR Bridge — isolates what moved revenue.
- Cohort heatmap — retention/revenue by signup quarter.
- Payback by channel — bar chart with median and P80 whiskers.
- Pipeline funnel — SQL→Won with stage conversion deltas vs plan.
- Forecast fan chart — P50/P80/P95 around weighted bookings.
- Experiment readouts — point estimate + 95% CI (no vanity screenshots).
Rule: 1 chart = 1 message. Annotation > legends. Add “Decision” box under each chart.
6) Spreadsheet architecture (Google Sheets / Excel)
Tabs (left→right): README • Metric_Dictionary • Scorecard • ARR_Bridge • Pipeline • Cohorts • Unit_Econ • Forecast • Initiatives • Risks • Appendix
Conventions:
- All inputs in blue cells; formulas in black; model assumptions in orange.
- Use named ranges (
ARR_start,GM,CAC_new_logo). - Version & date stamp on Scorecard.
- Trust badge (green/yellow/red) pulled from data SLO sheet (freshness, completeness).
- Lock down dictionary tab; hyperlink each metric to its definition.
ARR bridge sheet skeleton
Columns: Period, Start_MRR, New, Expansion, Contraction, Churn, End_MRR with formula End_MRR = Start + New + Expansion − Contraction − Churn. Bridge chart from stacked cols + cumulative line.
7) Narrative template (exec summary)
What changed (2–3 bullets)
- ARR +$X QoQ on stronger expansion; gross churn improved 0.4 pp.
Why - New packaging A/B lifted ASP +7%; onboarding fixes reduced early churn.
So what - mROAS on YouTube now 1.6 (↑ from 1.2); payback ≤ 10 mo.
Now what (asks) - Approve +$200k to YouTube; Hire 2 AEs; Enter UK pilot (switchback design).
Risks & mitigations - Creative fatigue → 2 new angles in calendar; FX volatility → UK pricing buffer of 8%.
8) Forecast & scenarios (confidence, not certainty)
- Base (P50) from weighted pipeline + run‑rate; P80/P95 via historical forecast error or Bayesian intervals.
- Scenario levers: ASP, win rate, cycle, churn; show tornado chart with sensitivity.
- Decision gates: what changes if we’re tracking P80 vs P50 at mid‑quarter.
9) Experiments & causal evidence (one slide)
- List 2–4 material tests this quarter: design, MDE/power, result, decision.
- Translate lift → mROAS or payback and budget implications.
- Note post‑win holdouts to catch novelty effects.
10) Risks & mitigations (top 5)
Ranked by probability × impact with owners and triggers.
Examples: demand softness, data incident, churn spike, hiring lag, supply constraint.
11) Governance & cadence
- Pre‑read sent 48 hours before; meeting starts with decisions, not a read‑through.
- Time split: 10 min exec summary → 20 min discussion on deltas → 15 min decisions/approvals → 5 min risks.
- Changelog of metric definitions and data quality incidents in appendix.
12) 30‑60‑90 Day Implementation Plan
Days 1–30 — Build dictionary, scorecard, ARR bridge; wire trust badge; draft exec summary template.
Days 31–60 — Add cohort sheet, forecast fan chart, payback by channel; standardize experiment readouts.
Days 61–90 — Scenario planning module; finalize risks/asks format; run a dry‑run with your exec team and iterate.
13) Board Q&A cheat sheet (prep answers)
- Why did ARR move? Bridge + cohort + ASP change, with contribution %.
- Is growth efficient? Burn multiple, CAC payback, and mROAS vs guardrails.
- How confident is the forecast? Historical MAPE, current P80 band, key risks.
- What would you do with +$X / −$X? Ready allocation plan using response curves.
- How does this compare to plan/peers? Variance vs plan; select external benchmarks (footnoted).
Add comment