← All Business Templates & Models
$25 one-time, plus applicable tax
Buy now: $25Please note. The file is a standard .xlsx workbook, recalculated and checked for formula errors in LibreOffice Calc (we have not tested it in Excel or Google Sheets). No macros. Educational tool only. Not financial, tax, legal, or investment advice. Consult a qualified professional. These templates were written largely by an AI assistant working under the direction of Quietcog, and checked with automated tests. They are AI-assisted, so errors are still possible; please report them to gb1@mail.grokbot.com.
This is a digital download: after you pay, you are taken to a private download page, with no account needed. Terms · Refunds (14 days).
Preview of the Summary sheet with the built-in example data for a fictional business.
About this workbook
Project a subscription or SaaS business for 36 months. Enter your current customers, monthly price, marketing spend and CAC, early-life and steady churn, expansion revenue and costs. The workbook tracks every monthly cohort of customers, then rolls customers and MRR forward (new, expansion, churned) and computes ARR, lifetime value, LTV:CAC, CAC payback, a retention curve and your cash runway. Built-in checks prove the customer and MRR roll-forwards tie to the cohort grid, so you can trust the totals. Prefilled with a fictional scheduling app. Tune early-life churn separately from steady churn, add expansion revenue and price drift, and see what one point less churn does to lifetime value and cash. Standard .xlsx file, checked in LibreOffice Calc. No macros.
What you get
- Cohort grid: every signing month tracked separately, with higher early-life churn then steady churn
- MRR roll-forward: opening + new + expansion - churned = closing, checked every month
- LTV three ways (lifetime with early churn, simple formula, 36-month cohort), CAC, LTV:CAC, payback
- Paid and organic acquisition, spend growth, price drift and expansion revenue
- Cash runway: lowest cash, first cash-positive month, funding needed
- Retention curve chart plus MRR and MRR-movement charts
- 10 built-in checks; no macros, no add-ins, no external links; standard .xlsx, checked in LibreOffice Calc
What is included in the download
- Quietcog-Subscription-Revenue-Model.xlsx
- README.md (user guide)
- LICENSE.txt (licence)
- Workbook contents: Instructions (6 steps, color key, protection tips); Summary (key numbers, 3-year table, three charts); Inputs (customers, price, acquisition, churn, expansion, costs, cash); Model (36 months: customers, MRR roll-forward, revenue, cash); Cohorts (active and lost customers by signing month); Unit Economics (LTV, CAC, payback, growth, retention curve); Checks (10 automatic tests)
$25
Buy now: $25Related templates
- OKR & Weekly Priorities Tracker: set churn and growth targets and review them weekly.
- Content Calendar Workbook: plan the content that feeds your funnel.
Questions
- Does it model annual plans or free trials? Not directly. Use an average monthly price per account and count a customer when they start paying.
- How is LTV calculated? Three ways are shown: expected lifetime with early-life churn (the main figure), the simple gross profit / churn formula for comparison, and the actual 36-month gross profit of one cohort.
- What kind of file is it, and how was it checked? It is a standard .xlsx file built with ordinary formulas only: no macros, add-ins or external links. We checked it in LibreOffice Calc: every workbook was recalculated and scanned for errors. If anything looks different, please tell us at gb1@mail.grokbot.com.
- Can I use it in another spreadsheet app? We have only checked the file in LibreOffice Calc. If you choose to import it into another spreadsheet app, check the formulas, dropdowns, colours and charts afterwards; layout and charts may differ.
- Is the data in the file real? No. Every number you see at first belongs to a fictional business and is labeled EXAMPLE. Overwrite the yellow cells with your own figures.
- Are the formulas locked? No passwords. The files include optional tips for protecting formula cells while leaving the yellow input cells editable.
- What is the licence? One person or one business may use and modify the files for internal use. You may not resell, share or redistribute the files themselves. The numbers and reports you create are yours. A firm or commercial licence (for example for accountants using it with several clients) is available on request at gb1@mail.grokbot.com. See LICENSE.txt in the download.
- Can I get a refund? One-time digital purchases can be refunded within 14 days; see the refund page for details.
- Is this financial advice? No. It is an educational planning tool. Educational tool only. Not financial, tax, legal, or investment advice. Consult a qualified professional. © 2026 Quietcog.
- Who do I contact for help? Email gb1@mail.grokbot.com and tell us the workbook name, the sheet and the cell.
Educational tool only. Not financial, tax, legal, or investment advice. Consult a qualified professional. The file is a standard .xlsx workbook, recalculated and checked for formula errors in LibreOffice Calc (we have not tested it in Excel or Google Sheets). No macros. These templates were written largely by an AI assistant working under the direction of Quietcog, and checked with automated tests. They are AI-assisted, so errors are still possible; please report them to gb1@mail.grokbot.com. Example data in the files is fictional. Quietcog is not affiliated with or endorsed by Microsoft or Google. Support: gb1@mail.grokbot.com. See also the terms, refund policy and privacy policy.