# Board Reporting Pack

A 24-month KPI dashboard pack with month-on-month and year-on-year deltas, YTD totals, and a one-page board-ready summary with traffic-light status against your growth thresholds.

- Canonical: https://finamodel.com/templates/board-reporting
- Excel download: https://finamodel.com/templates/board-reporting.xlsx
- Category: Corporate Finance
- Model type: Operating model
- Difficulty: Beginner
- Audiences: CFOs & FP&A, Founders & operators, CFOs, FP&A teams, CEOs, Founders
- Tags: kpi, dashboard, mom, yoy, board

## Overview

A board reporting pack condenses an operating business into ten board-level KPIs tracked across a 24-month horizon, then surfaces month-on-month change, year-on-year change, and a one-page dashboard with traffic-light status. The workbook is built around an Assumptions sheet that holds every driver as a named range, a KPIs sheet that owns the 24-month matrix, an MoM sheet that owns the per-period delta math, a YoY sheet that compares the current 12 months against the prior year, and a Dashboard sheet that rolls the workbook into a single board-ready table.

The KPIs sheet covers four buckets: financial (revenue, gross profit, EBITDA, operating cash flow), customers (active customers, new customers, churned customers), unit economics (ARPU, CAC), and people (headcount). Each row is formula-driven from a single base value and a monthly growth rate that compounds across the 24-period horizon, so the worksheet works out of the box and converts to a drop-in template the moment recorded numbers replace the formulas. The MoM sheet computes Actual minus prior month and a divide-by-zero-guarded percent change per cell for every KPI; the YoY sheet repeats the exercise across the current 12 months against the prior-year same month.

The Dashboard sheet pulls the latest month, the latest MoM%, the latest YoY%, the YTD current and YTD prior totals, the YTD growth percent, and a traffic-light status string onto one grid per KPI. The status logic compares YTD growth against user-set green and amber thresholds so every KPI carries an On track / Watch / Off track label without manual tagging. CFOs, FP&A teams, CEOs, and founders use the template for monthly board packs, weekly operating cadence reviews, and investor updates - anywhere the conversation needs to start from a one-page picture rather than a wall of detail.

## What's included

- 24-month KPI matrix across ten board-level metrics
- Month-on-month dollar and percent change per KPI across the full window
- Year-on-year dollar and percent change across the current 12 months
- YTD current and YTD prior totals with YTD growth percent per KPI
- Traffic-light status (On track / Watch / Off track) on user-set thresholds
- Named-range assumptions for every driver and threshold
- 24-month KPI matrix across ten board-level metrics driven by named-range assumptions
- Month-on-month dollar and percent change for every KPI across the full window
- One-page dashboard: latest month, MoM%, YoY%, YTD current, YTD prior, YTD growth %
- Traffic-light status (On track / Watch / Off track) against user-set growth thresholds
- Drop-in actuals - replace formula-driven KPI cells with recorded data and deltas recompute

## Board Reporting Pack: How the KPI Model Connects Drivers to Board-Ready Status

This board reporting pack turns fourteen operating KPIs into a 24-month view with budget variance, movement analysis, and a traffic-light dashboard. The underlying model links revenue, customers, unit economics, and people so a finance team can replace formula-driven cells with recorded data and see the full pack recalculate.

This explanation covers the documented operating drivers, calculation flow, outputs, and practical use.

### Documented Operating Drivers and Assumptions

Every KPI starts from an assumption rather than a hard-coded series.

- The Assumptions sheet holds month-one bases for revenue, customers, and headcount, plus monthly growth and margin rates, churn and new-customer rates, a marketing-spend ratio, a net dollar retention default, hire growth, CapEx percentage, cash position, traffic-light thresholds, and an annual target for each KPI.

- Changing a base or rate recasts everything downstream, which makes the template a planning tool as much as a reporting one.

- Defaults are calibrated to mid-stage SaaS but the design notes how SMB, enterprise, and services users might re-scale the same drivers.

### How the KPIs Are Calculated

Revenue compounds from the month-one base at the monthly growth rate. Gross profit and EBITDA are revenue multiplied by their respective margins, and operating cash is EBITDA times a conversion rate.

- Active customers roll forward as prior active plus new minus churned, with new and churned both derived from prior active multiplied by their rates. From there, ARPU is revenue divided by active customers; marketing spend is revenue times the marketing ratio; CAC is that spend divided by new customers; LTV combines ARPU, gross margin, and churn; and payback is CAC over ARPU times gross margin.

- NDR and headcount are input cells with formula defaults.

### Outputs and Calculation Flow

The KPIs sheet is a 24-month matrix, with the prior twelve months plus the current twelve. Budget mirrors that layout for hand-keyable board-approved plans, and Variance shows actual minus budget in dollars and as a percentage.

- MoM compares each month to the prior month across the full window, while YoY compares current-year months to the same month a year earlier; MoM is blank in the first period and YoY only covers months 13–24.

- The Dashboard condenses everything into one row per KPI with latest value, MoM and YoY percentages, budget variance, FY target progress, a sign-aware status, and a commentary field for the CFO's explanation.

### Practical Use and Sign-Aware Status

The pack is designed so a finance team can replace the formula-driven KPI cells with actual recorded numbers and let the deltas, budget variance, and Dashboard recalculate. Its most distinctive feature is sign-aware status: each KPI has a direction flag, so higher-is-better metrics such as revenue or ARPU are ordered one way, while churn, CAC, and payback are ordered the opposite way.

- A 20% year-on-year CAC rise therefore flags red rather than green. Percent-to-target flips similarly for lower-is-better metrics.

- A small cash and runway section uses an optional burn override or a simple revenue-times-CapEx-minus-EBITDA proxy, and the design notes that a full balance sheet or cash flow statement is out of scope.

## Built for monthly board packs

When a board meeting opens, the page that matters most is a one-line summary per KPI. This template lays the deltas, the YTD growth, and the status string on one grid.

## Designed for FP&A handoff

Every figure ties back to a clear source cell. Drop your actuals into the KPIs sheet and the MoM, YoY, and Dashboard sheets recalculate immediately.

## Audit-friendly mechanics

Every input is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, and dead-assumption scans.

## Built for monthly board packs

When a board meeting opens, the page that matters most is a one-line summary per KPI. This template lays the deltas, the YTD growth, and the status string on one grid.

## Designed for FP&A handoff

Every figure ties back to a clear source cell. Drop your actuals into the KPIs sheet and the MoM, YoY, and Dashboard sheets recalculate immediately.

## Audit-friendly mechanics

Every input is a named range, every formula is one or two operations, and the workbook passes static-value, self-reference, and dead-assumption scans.

## Workbook structure

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: KPI bases, growth rates, margins, customer metrics, thresholds.

- Month-1 base for each KPI
- Monthly growth rate per metric
- Gross, EBITDA, and operating-cash conversion margins
- Customer base, new-customer rate, churn rate, marketing %
- Headcount base and hiring growth
- On-track and watch thresholds in absolute percent

### KPIs

24-month matrix of ten board-level KPIs driven from assumptions.

- Revenue, gross profit, EBITDA, operating cash flow
- Active customers, new customers, churned customers
- ARPU and CAC
- Headcount

### MoM

Month-on-month dollar and percent change per KPI across all 24 months.

- Dollar block: current minus prior month
- Percent block: current / prior month − 1 with divide-by-zero guard
- Same row order as the KPIs sheet

### YoY

Year-on-year dollar and percent change across the current 12 months.

- Dollar block: current month minus same month one year earlier
- Percent block: current / prior year with divide-by-zero guard
- Only the current 12 months are reported - the prior 12 have no comparable

### Dashboard

One row per KPI: latest month, MoM%, YoY%, YTD current, YTD prior, YTD growth %, status.

- Latest month pulled from the KPIs sheet final column
- MoM% pulled from the MoM percent block, final column
- YoY% pulled from the YoY percent block, final column
- YTD current = SUM of months 13–24, YTD prior = SUM of months 1–12
- Status: On track if YTD growth ≥ green threshold, Watch if ≥ amber, Off track otherwise

### Cover

Workbook overview, sheet legend, and tab-colour key for navigation.

- Title and scope framing
- Sheet-by-sheet purpose summary
- Tab-colour legend

### Assumptions

Every driver in one sheet: KPI bases, growth rates, margins, customer metrics, thresholds.

- Month-1 base for each KPI
- Monthly growth rate per metric
- Gross, EBITDA, and operating-cash conversion margins
- Customer base, new-customer rate, churn rate, marketing %
- Headcount base and hiring growth
- On-track and watch thresholds in absolute percent

### KPIs

24-month matrix of ten board-level KPIs driven from assumptions.

- Revenue, gross profit, EBITDA, operating cash flow
- Active customers, new customers, churned customers
- ARPU and CAC
- Headcount

### MoM

Month-on-month dollar and percent change per KPI across all 24 months.

- Dollar block: current minus prior month
- Percent block: current / prior month − 1 with divide-by-zero guard
- Same row order as the KPIs sheet

### YoY

Year-on-year dollar and percent change across the current 12 months.

- Dollar block: current month minus same month one year earlier
- Percent block: current / prior year with divide-by-zero guard
- Only the current 12 months are reported - the prior 12 have no comparable

### Dashboard

One row per KPI: latest month, MoM%, YoY%, YTD current, YTD prior, YTD growth %, status.

- Latest month pulled from the KPIs sheet final column
- MoM% pulled from the MoM percent block, final column
- YoY% pulled from the YoY percent block, final column
- YTD current = SUM of months 13–24, YTD prior = SUM of months 1–12
- Status: On track if YTD growth ≥ green threshold, Watch if ≥ amber, Off track otherwise

## Features

- **MoM and YoY in one workbook:** Both per-period change views live on dedicated sheets in the same row layout as the underlying KPI matrix, so every delta ties cleanly back to a source cell.
- **One-page dashboard:** The Dashboard sheet condenses ten KPIs and seven columns onto a single grid suitable for a board pack or operating review.
- **Traffic-light status:** Each KPI carries an On track / Watch / Off track status computed from YTD growth percent against user-set green and amber thresholds.

## Use cases

- **Monthly board pack:** Drop the latest month's KPI numbers into the KPIs sheet, eyeball the dashboard traffic lights, and walk into the board meeting with the off-track KPIs already isolated.
- **Operating cadence review:** Use the MoM sheet to drive a weekly or monthly leadership cadence - track short-term moves while keeping a one-page YoY view for board-level context.
- **Investor updates:** Pull the dashboard into an investor update: latest KPI value, MoM%, YoY%, YTD growth - the headline metrics every investor expects in a monthly note.

## Frequently asked questions

### What is a board reporting pack?

A board reporting pack is a condensed view of an operating business that surfaces a handful of KPIs against prior-month and prior-year comparables, with YTD totals and a single-line traffic-light status for each metric. It is the one-page picture every board meeting wants on slide one.

### What KPIs does this template track?

Ten board-level KPIs across four buckets: financial (revenue, gross profit, EBITDA, operating cash flow), customers (active customers, new customers, churned customers), unit economics (ARPU, CAC), and people (headcount).

### How do I plug in my own data?

Replace the formulas on the KPIs sheet with the recorded values per period. Keep the row layout and the MoM, YoY, and Dashboard sheets recalculate automatically.

### What threshold should I use for the traffic lights?

Most operating businesses use a 10% YTD growth on-track threshold and a 0% watch threshold (anything declining is off track). Faster-growing companies often push the green threshold to 25% or higher.

### Why a 24-month horizon?

Twelve prior months plus twelve current months gives every KPI a year-ago comparable for the year-on-year view. Trim or extend by adjusting NUM_PERIODS in the builder and re-running.

## Related templates

- [Budget vs Actuals Tracker](https://finamodel.com/templates/budget-vs-actuals)
- [3 Statement Model](https://finamodel.com/templates/3-statement-model)
- [Cohort Retention](https://finamodel.com/templates/cohort-retention)