Skip to content
Instant digital downloads · Every file checked before release · Browse free resources

Use the left and right arrow keys to move between preview images.

Spreadsheet · Digital download

Break-Even and Unit Economics Workbook

Break-even units and revenue, margin of safety, product-mix break-even, LTV, CAC by channel and payback, plus scenarios, a sensitivity grid and a 12-month plan.

PDFXLSX4 files485 KB
Price $17.99USD

Included in Studio membership downloads.

  • Instant digital download — nothing is shipped.
  • Secure checkout by Stripe.
  • Version 1.0.0 · updated Nov 9, 2026.

Description

For founders and small product businesses who need straight answers: how many sales cover the costs, how much room there is, and whether each customer is worth what it costs to win.

Enter your price, average discount, expected units and target profit, then up to 12 variable cost lines ($ per unit or % of net price) and 15 monthly fixed costs. Break-Even shows contribution per unit and margin ratio, break-even units (rounded up) and revenue, units for your target profit, margin of safety, operating leverage and the price you'd need to break even, with a cost-volume-profit chart. Product Mix gives a weighted break-even across up to 10 products. Unit Economics turns units per order, orders per year and customer lifespan into average order value and lifetime value, and spend and new customers by channel into CAC, LTV:CAC and payback months. Scenarios compares five what-ifs side by side, Sensitivity shows monthly profit for price changes × volume changes, and the 12-Month Plan adds growth and launch costs to find the payback month.

Included: worked-example and blank workbooks (9 sheets, 397 formulas) and a 4-page quick-start guide (US Letter and A4) with a worked example and every formula explained.

General information, not financial, tax or investment advice.

Who it's for: Makers, DTC and e-commerce brands, food and drink producers, studios and other small product businesses..

Included files

  • break-even-and-unit-economics-workbook-v1.0.0-all-files.zipAll files in one ZIP (includes licence)ZIP
  • Break-Even-Unit-Economics-Example.xlsxWorkbook with a fictional small-batch skincare brand selling online: 9 sheets, 397 formulasXLSX
  • Break-Even-Unit-Economics-Blank.xlsxBlank workbook ready for your numbersXLSX
  • Break-Even-Unit-Economics-Quick-Start-Guide-Letter.pdfQuick-start guide (US Letter, 4 pages): worked example, formulas explained, unit economics, scenarios, 12-month planPDF
  • Break-Even-Unit-Economics-Quick-Start-Guide-A4.pdfQuick-start guide (A4, 4 pages)PDF
  • LICENCE.txtLicence summaryTXT
  • Plus a single ZIP with every file and the licence (361 KB).

How to use

Open the blank .xlsx and read Start Here. Fill in Inputs, then read Break-Even and the Dashboard. Add channels on Unit Economics and try changes on Scenarios and Sensitivity.

Customer reviews

No reviews yet. Reviews can only be written by customers who own this product.

Frequently asked questions

Is this a physical product?

No. This is a digital download. Nothing is shipped — you download the files from your account after purchase.

How do I get my files?

After payment, go to My Downloads in your account. Your purchase stays available there to re-download.

What can I do with it?

Use for yourself, your household or your own business. Print unlimited copies for that use. No reselling or sharing the files.

What's the difference between break-even units and margin of safety?

Break-even units is the volume where profit is zero. Margin of safety is how far your expected volume is above it, as units and as a % of expected sales.

Can I use it for a service business?

Yes: treat a billable hour, session or job as the unit and enter the costs that rise with each one as variable costs.

Is lifetime value discounted?

No. It's contribution per order × orders per year × lifespan, a simple undiscounted estimate.

Which apps has it been tested in?

LibreOffice Calc (recalculated and checked against expected values). Not tested in Excel, Google Sheets or Numbers.