Unit Economics Tool

Welcome to the new site. Problems, use store.hemrock.com

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
1.2×
6 min⚡️7 min 45 sec6 min 12 sec5 min 10 sec4 min 8 sec3 min 38 sec3 min 6 sec2 min 28 sec
1.2×
6 min⚡️7 min 45 sec6 min 12 sec5 min 10 sec4 min 8 sec3 min 38 sec3 min 6 sec2 min 28 sec
    • heart
      1
    • yes
      2
    • fire
      3
    • clap
      4
    • yay
      5
    • eyes
      6
  • More reactions
    7

    Frequently Used

    Smileys & Emotion

    People & Body

    Animals & Nature

    Food & Drink

    Activities

    Travel & Places

    Objects

    Symbols

    Flags

    Make frequently used emojis my default
Comment
C
0 Comments
Be the first to comment
HitCto reply to Taylor or leave a comment at the top of this panel.
Pay what you want

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

$USD

Instant Access

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

License and Terms apply on all purchases, services, and courses.

Get help buying. Call, text, WhatsApp 1-646-770-0052.

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 — paste into your AI before any change.
  2. Prompt guide — ready-made prompts for customization.
  3. MCP server — 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. If you're modeling ecommerce specifically, try the Ecommerce Forecasting Tool for cohort-based new-vs-repeat customer logic.

Documentation

Ratings

4.9(36 ratings)
5
97%
4
0%
3
0%
2
0%
1
3%

Reviews

No reviews yet. Used this product? Sign in to leave a review.