Board Reporting Pack
Corporate Finance Financial Model (Free Excel Download)
Turn operating forecasts into a board-ready view of revenue, margins, cash, runway, KPIs, and plan-versus-actual performance with consistent monthly reporting.
professionals from Deloitte
Used by professionals from
About this model
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 every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Board Reporting Pack
- 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
- One-page dashboard: latest month, MoM%, YoY%, YTD current, YTD prior, YTD growth %
- 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.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
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.
Have more financial modelling questions? Contact us
Related templates
Budget vs Actuals Tracker
12-month operating P&L variance tracker with YTD summary.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
Cohort Retention
12-cohort SaaS retention model with logo curve, NRR, and LTV per cohort.
M&A Modeling & Valuation
Comprehensive M&A valuation with DCF, comparable companies, and precedent transactions analysis.
