SaaS & Startup

Unit Economics
Dashboard

CAC by channel, LTV by segment, payback period, gross margin, and magic number — all auto-calculated. The dashboard that tells you whether your growth is sustainable.

CAC by ChannelLTV by SegmentPayback PeriodMagic Number4 Sheets

UNIT_ECONOMICS_DASHBOARD.xlsx

CAC Input

LTV Model

Payback Analysis

Dashboard

Category	Item	Status	Value	Notes
Unit Economics Dashboard — Sample Data
Section A	Item 1	Complete	100%	Verified
Section A	Item 2	In Progress	67%	Due next week
Section B	Item 3	Action Required	0%	Overdue
Section B	Item 4	Complete	100%	On track
SUMMARY			67%	2 actions needed

^$39

One-time · Instant download

★★★★★4.9 / 5.0

4-sheet Excel workbook, fully unlocked
CAC by Channel
LTV by Segment
Payback Period
Magic Number
Works in Excel 2016+ and Google Sheets

Purchase Now — $39

30-Day Money-Back GuaranteeFull refund, no questions asked.

Contents

All 4 sheets,
explained.

Sheet 01

CAC by Channel

Sales and marketing spend and new customers by acquisition channel — CAC auto-calculated

Sheet 02

LTV Model

Average contract value, gross margin, and churn rate by segment — LTV auto-calculated

Sheet 03

Payback Analysis

Months to recover CAC by segment and channel

Sheet 04

Dashboard

LTV:CAC ratio, magic number, best and worst channels, and 12-month trend

Reviews

Professionals who use it daily.

★★★★★

The magic number chart changed how we allocate budget. This was done in an afternoon with data I already had.

Sam O.

VP Marketing · Growth Stage SaaS

★★★★★

Investors ask for LTV:CAC at every board meeting. This is what I pull up.

Rachel T.

CFO · VC-Backed Software

FAQ

Common questions.

What is a good LTV:CAC ratio?+

3:1 or higher is generally considered healthy — for every dollar spent acquiring a customer, you generate $3 in lifetime value.

How do I handle multi-channel customers?+

The CAC input sheet has a row for every acquisition channel. Allocate spend proportionally or use the blended CAC line.

Unit Economics
Dashboard