Financial Models
SaaS Metrics Dashboard: MRR, Churn, CAC & LTV — Excel + Google Sheets
Investor-ready SaaS workbook: MRR bridge, churn, NRR, CAC, LTV, cohorts and runway. Excel + Google Sheets.
What you get: 1 file · 1.4 MB · ZIP
See purchase optionsProduct description
SaaS Metrics Dashboard: MRR, Churn, CAC & LTV — Excel + Google Sheets is an investor-ready monthly model for subscription founders. One .xlsx, no macros, no passwords. Functions are limited to what exists in both Excel 2016+ and Google Sheets (SUMIFS, COUNTIFS, INDEX/MATCH, IFERROR, EDATE, data validation, conditional formatting). There are no XLOOKUP, LET, LAMBDA, FILTER, dynamic arrays, or structured table references inside formulas.
Eleven tabs. Start Here (setup, colour legend, glossary with formulas in words). Settings (company name, currency code as text, model start month, RefMonth instead of TODAY() so the sample stays stable, plan prices, gross margin, KPI targets). Customers (150 fictional accounts, 4 plans, ~25 cancelled; plan dropdown, start month, cancel month (first unbilled month), seats, channel, MRR = price × seats). Monthly Inputs (24 months of marketing by channel, sales spend, expansion MRR, contraction MRR, cash, burn). MRR Bridge, Churn (logo churn, gross MRR churn, monthly NRR, monthly and trailing-3-month), Unit Economics (CAC overall and by channel, ARPA, gross-margin-adjusted LTV, left blank when trailing-3-month gross churn is below 0.8%, LTV:CAC, CAC payback), Cohorts (signup month × months-since-start retention % from Customers via COUNTIFS, heat map), Runway (cash, burn, months of runway, burn multiple), Dashboard (eight KPI tiles including monthly NRR, plus four native Excel charts: MRR movement, ending MRR, churn %, blended LTV vs CAC by channel), ChartData (formula ranges those charts read).
Sample data is filled in: 24 months (2024-01 to 2025-12), 150 customers, 4 plans (Starter, Growth, Pro, Scale), 5 channels. Numbers use plain #,##0 formats with the currency code from Settings in the headers — no currency symbols anywhere in the file. Yellow cells are inputs; blue-grey cells are formulas.
Google Sheets: File → Import → Upload → Replace spreadsheet. Dropdowns and formulas come across. Excel charts may need to be rebuilt in Sheets from the ChartData tab; the values are already there.
File: saas-metrics-dashboard.xlsx plus a US Letter Quick-Start PDF and a contact sheet of every tab
RefMonth replaces TODAY() so screenshots and the sample stay stable until you move it
Customer formulas already run through row 200 so you can add accounts without copying formulas
License (spreadsheet template, not art assets): you may use this template in your own business and for client work, modify it for those purposes, and import it into Microsoft Excel or Google Sheets. You may not resell or redistribute the template itself (unmodified or modified) as a competing template, spreadsheet, or digital download, share the original file publicly, or include it in another pack or marketplace listing.
What you get
1 file · 1.4 MB
- saas-metrics-dashboard.zipZIP · 1.4 MB
Financial Models
SaaS Metrics Dashboard: MRR, Churn, CAC & LTV — Excel + Google Sheets
Investor-ready SaaS workbook: MRR bridge, churn, NRR, CAC, LTV, cohorts and runway. Excel + Google Sheets.
Included in Getly Pro
Download this and 7,600+ other products with one subscription, from $9.99 a month.
Join Getly ProTags
Frequently asked questions
Do I get access instantly?
Yes. This is a digital product - you can download it right after checkout, straight from your library.
Can I use it for commercial projects?
Yes. Commercial use is allowed: use it in your own business and in things you sell. You may not resell or redistribute the file itself.
What's your refund policy?
You can request a refund within 30 days. If something isn't right, request it from your order and the Getly team reviews it.
What file formats and sizes will I get?
You'll download 1 file - ZIP - 1.4 MB in total.
Do I get free updates?
Yes - when the seller ships a new version, you can re-download the latest files from your library at no extra cost. Check the changelog for recent updates.
Price
$4.49



