Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesBusiness & StrategyStartup PlanningSaaS Unit Economics Calculator

SpreadsheetStartup PlanningFree

SaaS Unit Economics Calculator

CAC, LTV, payback and LTV:CAC by plan from price, churn, margin and acquisition spend.

Shown with sample data

Colour

SaaS Unit Economics Calculator

CAC, LTV, payback and LTV:CAC by plan from price, churn, margin and acquisition spend.

Blended CAC
$677
Healthy plans
4
Best LTV to CAC
11.7
Longest payback (months)
11.9
LTV to CAC by plan
  • Enterprise11.7
  • Team9.9
  • Business9.7
  • Starter7
  • Legacy basic1.1

How to use it

  1. 1Add each plan or segment as a row.
  2. 2Enter monthly price, gross margin and monthly churn from your data.
  3. 3Enter sales and marketing spend and new customers for the same period.
  4. 4Aim for LTV:CAC above 3 and payback under 12 months.

In this workbook

  • About
  • What’s included
  • How to use
  • Related resources

About this template

Know whether each new customer makes or loses money. For each plan enter price, gross margin, monthly churn and what you spend to win a customer; the calculator returns lifetime value, payback period and the LTV:CAC ratio, and tells you which plans are healthy.

Who it’s for

  • Board and investor metrics
  • Pricing and packaging decisions
  • Setting marketing budgets

What’s included

  • Plans sheet: One row per plan.
  • Summary by Segment sheet: Acquisition spend and the number of entries for each segment, calculated from the Plans sheet.

How to use it

  1. 1Add each plan or segment as a row.
  2. 2Enter monthly price, gross margin and monthly churn from your data.
  3. 3Enter sales and marketing spend and new customers for the same period.
  4. 4Aim for LTV:CAC above 3 and payback under 12 months.
Related searchesunit economicsltv cacsaas metricscustomer lifetime valuecac payback

Details

Format
Spreadsheet
Category
Startup Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStartup PlanningFree

SaaS Unit Economics Calculator

CAC, LTV, payback and LTV:CAC by plan from price, churn, margin and acquisition spend.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Startup Planning
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More startup planning templates

View all
Startup Financial Model2 sheets

MRR in month 12

$27,234

Average monthly burn

$61,419

Cash at month 12

$162,967

ABCD
1MonthCustomersRevenueCost of revenue
2M1120$10,680$1,922
3M2139$12,371$2,227
4M3158$14,062$2,531
5M4176$15,664$2,820
Model
SpreadsheetStartup Planning

Startup Financial Model

Monthly revenue, costs, burn and runway for the next 12 months.

45 min setupPreview

Company Name: Investor Update, Month Year

TL;DR: One sentence on the month.

Key metrics

MetricThis monthLast month
Revenue (MRR)$42,500$38,900
Customers318291

Highlights

  • •Win 1
  • •Win 2

Lowlights

  • •Challenge and what we're doing about it
DocumentStartup Planning

Investor Update

A monthly founder update: highlights, metrics, lowlights, asks and runway.

30 min setupPreview
Business Startup Costs Calculator2 sheets

One-time costs

$53,300

Monthly costs

$13,090

Total funding needed

$151,616

ABCD
1TypeCategoryItemEstimated cost
2One-timePremisesLease deposit (2 months)$6,400
3One-timeEquipmentEspresso machine + grinders$14,500
4One-timePremisesFit-out and furniture$22,000
5One-timeLegal & licencesCompany setup, permits$2,100
Costs
SpreadsheetStartup Planning

Business Startup Costs Calculator

Estimate one-time and monthly costs to launch and how much funding you need.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ