Finance & FundraisingSpreadsheet

Unit Economics Workbook

Calculate CAC, LTV, payback period, and contribution margin per unit so you know whether your business model actually works before you scale it. Includes guide explaining each metric and spreadsheet that runs the math.

Format
Spreadsheet
Read time
90 minutes
Downloads
0
Published
May 12, 2026
Best for
Founders preparing for a fundraise, product teams pricing a new offer
Jump to file
African EntrepreneursEarly-stage StartupsFinancial PlanningUnit EconomicsWorkbookGuide

What are unit economics?

Unit economics is the financial picture of a single transaction or customer relationship in your business. It tells you whether a single sale is profitable, how much it costs to acquire that sale, and how long it takes to recoup that cost. Strong unit economics is the foundation that lets a business scale without burning capital.

Who this is for and when to use it

African founders preparing for a fundraise, operators trying to understand why growth is not improving profitability, and product teams pricing a new offering. Use the workbook before scaling marketing spend, before raising a round (investors will ask), when comparing customer segments, after a pricing change, and as a quarterly health check.

What is inside

A written guide that explains each metric with formulas and examples, the difference between gross and contribution margin, and the most common mistakes founders make, plus an editable spreadsheet that calculates CAC, LTV, payback period, the LTV/CAC ratio, and contribution margin from your inputs. Pair with The Unit Economics Guide for the full narrative explanation.

Key concepts you will learn

Customer Acquisition Cost (CAC) and how to calculate it correctly, Lifetime Value (LTV) and the difference between gross-margin LTV and revenue LTV, the LTV to CAC ratio (3x is the rough target), payback period (12 to 18 months is healthy for most businesses), contribution margin per unit, the link between churn and LTV, and cohort analysis.

Frequently asked questions

What is a healthy LTV to CAC ratio?
Most investors look for an LTV to CAC ratio of 3 or higher. Below 1, you are losing money on every customer. Between 1 and 3, the business works but is not yet investable at scale.
How do I calculate LTV if I do not have years of data?
Use a cohort-based estimate. The workbook walks through how to project LTV from your first 6 to 12 months of customer behavior.
Should I use gross margin or revenue when calculating LTV?
Gross margin. Using revenue inflates LTV and hides the true cost of serving customers.
My unit economics are not great. Should I still raise?
Maybe. Investors will fund pre-product-market-fit businesses with bad unit economics if there is a credible path to fixing them. The workbook helps you articulate that path.

Take the full guide with you

Free for African founders. Download the complete file with examples and templates.

SPRE

MsingiLab_Unit_Economics_Workbook.xlsx

78 KB

Continue building

Related resources

MsingiLab Librarian

What are you looking for today?

Powered by CopilotKit