Skip to main content

Command menu

Jump to a page or search the catalog

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.

$4.49

What you get: 1 file · 1.4 MB · ZIP

See purchase options

Product 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

Included in Getly Pro

Download this and 7,600+ other products with one subscription, from $9.99 a month.

Join Getly Pro
LicenseCommercial use allowed
Views21
PublishedNov 16, 2026
File size1.4 MB
File formatZIP
Versionv1.0

Tags

saas metricsmrr dashboardchurn cac ltvexcel modelgoogle sheetsstartup financeunit economicsnrr cohortsrunwayinvestor metrics
S
Severin

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