# Unit Economics Tool

Calculate unit economics for a single customer. LTV, contribution margin, payback period, and breakeven from your pricing, churn, and cost of sales.

**4.9 (36) 6,115 downloads**  
**Unit Economics Tool by Foresight - Google Sheets - 23 September 2022**

## Highlights

Calculate unit economics for a single customer. Forecast LTV, contribution margin, payback period, and breakeven across recurring revenue, transactions, churn, and cost of sales. The starting point for thinking about whether the customer math actually works.

## What you'll do with it

Forecast the lifetime value of one customer. Plug in pricing, churn, contract length, billing cycle, and cost of sales, and the model returns LTV, contribution margin, payback period, and breakeven on acquisition cost.

Built for the question that comes up at every stage: do my unit economics actually work? Pressure-test pricing, decide whether to spend on acquisition, sanity-check a SaaS or transactional business before scaling.

## What's inside

- Recurring and transactional revenue mechanics, side by side
- Churn, customer lifetime, and contract length drivers
- LTV, contribution margin, payback period, breakeven on CAC
- Clean, documented formulas — every cell open

## Edit with AI

Every cell open. Inputs in blue, formulas in black, rows documented. Built to be read and edited by Claude, ChatGPT, and other AI tools.

1. **[Context primer](https://www.hemrock.com/docs/ai?template=standard)** — paste into your AI before any change.
2. **[Prompt guide](https://www.hemrock.com/docs/ai?template=standard)** — ready-made prompts for customization.
3. **[MCP server](https://www.hemrock.com/mcp)** — connect Claude Desktop or Claude.ai for ambient context.
4. **Verify before trusting** — sanity-check prompts catch wrong references and confused metrics.

## When to use this vs. other tools

Focused tool for unit economics only. If you need expenses, hiring, financial statements, and cap table on top, use the **[Standard Financial Model](https://www.hemrock.com/standard-financial-model)**. If you're modeling ecommerce specifically, try the **[Ecommerce Forecasting Tool](https://www.hemrock.com/ecommerce-forecasting-tool)** for cohort-based new-vs-repeat customer logic.

## Documentation

- **[Cohort modeling](https://www.hemrock.com/docs/cohort-modeling)**
- **[Revenue modeling](https://www.hemrock.com/docs/revenues)**

## Ratings

This model: 4.9 (36 ratings)  
5 stars: 97%  
4 stars: 0%  
3 stars: 0%  
2 stars: 0%  
1 star: 3%

## Pay What You Want

$20 suggested, but "0" is ok. All donations appreciated.

Instant Access  
Download to Excel or Copy to Google Sheets  
Easy to customize with your AI  
Free email support

**[Inside the model · 7 sheets · 2 sections→](https://www.hemrock.com/unit-economics-tool/structure)**  
**[License](https://www.hemrock.com/license)** and **[Terms](https://www.hemrock.com/terms)** apply on all purchases, services, and courses.