Free Excel templates

A free SaaS metrics board model in Excel, with a worked case

Eight quarters of inputs in, one board page out: ARR bridge, net new ARR, quick ratio, CAC payback, magic number, burn multiple, Rule of 40, and the runway counted to the covenant and to zero. No macros.

The file comes prefilled with Quillmere Software, the fictional company of the book, for 2024 and 2025. Its 2025 board page shows ARR of $39,667,000, a quick ratio of 3.39, CAC payback of 26.3 months, a burn multiple of 1.62, a Rule of 40 score of -9.6 percent, and a runway of 14.3 months to a $7,500,000 cash covenant and 22.8 months to zero.

Get the template

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

SaaS_Metrics_Board_Model.xlsx (19 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this model

This file is the board page of The SaaS CFO. The book defines every line before counting it: what ARR includes, why retention is measured on the opening book, how commissions are capitalized, why billings, revenue and cash never match, and why runway is counted to the covenant.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
Eight quarters: opening ARR, new-logo ARR, expansion, contraction, churn, subscription revenue and its cost, sales and marketing cash cost and reported expense, free cash flow, cash, and the minimum cash covenant.
Board Page
Closing ARR, net new ARR, quick ratio, CAC payback, magic number, burn multiple, ARR growth, Rule of 40, and runway to the covenant and to zero, each with its definition written beside it.
Read Me
How to replace the case with your own quarters, and what each definition leaves out.
Checks
The board page compared with the figures printed in the book for the case.

Three things to try

Move the covenant. Change the minimum cash input and watch the first runway line move while the second does not. That gap is the reason a board should see both.

Add a quarter of heavier churn. Raise churn in one quarter: net new ARR and the quick ratio fall at once, the burn multiple rises, and CAC payback does not move, because it only looks at what was bought.

Replace the case. Type your own eight quarters over the blue cells. If a line does not make sense, the definition beside it says what it measures.

Related reading