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.
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.
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
Four sheets. Blue type is an input; black type is a formula.
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.