I once had an investor call in twenty minutes and no idea what my actual MRR was. I had a Stripe dashboard open in one tab, a spreadsheet from three weeks ago in another, and a mental note that "a couple people churned recently." I was reconstructing my own business's numbers live, on a call, from memory.
Most solo SaaS founders do exactly this. Revenue lives in Stripe, expenses live in a bank statement or a different spreadsheet, and churn lives in your memory of who emailed to cancel. None of it is linked, so every investor update or founder check-in turns into twenty minutes of manual math before you can even talk about the number.
So I built a workbook that does the math for you. It's a 7-tab Google Sheets / Excel file — Subscribers, Churn Log, Expenses, Plans & Pricing, Settings, Start Here, and a Dashboard — where the only tabs you ever touch are Subscribers, Churn Log, and Expenses. Everything else — MRR, ARR, churn rate, ARPU, CAC, estimated LTV, LTV:CAC ratio, and cash runway in months — calculates itself from formulas the moment you add a row.
It also watches itself. Two built-in alerts flag it automatically if your churn rate climbs above 5% or your LTV:CAC ratio drops below your own target, so you're not relying on noticing a bad trend by eye. A 7-page walkthrough guide explains exactly how each metric is calculated, so the numbers aren't a black box either.
The full workbook plus the guide is $47 on Gumroad, $27 on Etsy, and $39 on Payhip. Set it up once, in under ten minutes, and you'll never do investor-call math from memory again.
Originally published on Medium.
Top comments (0)