> ## Documentation Index
> Fetch the complete documentation index at: https://quikirr.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Unit Economics

> Model LTV, CAC, payback, and the Magic Number—tweak gross-margin & S&M assumptions on the fly.

## Preview in Dashboard

<img src="https://mintcdn.com/quikirr/xIRaGjBuBRBt9dNh/images/unit-economics/UnitEconomicsChart.png?fit=max&auto=format&n=xIRaGjBuBRBt9dNh&q=85&s=103a71cdbaae6960f04968894d97e3ab" alt="Unit Economics dashboard with sliders and chart" className="rounded-xl border border-gray-200 shadow-sm" width="1063" height="469" data-path="images/unit-economics/UnitEconomicsChart.png" />

The **Unit Economics** view visualises how efficiency evolves, with two live controls:

| Slider               | Range     | Applies To                      |
| -------------------- | --------- | ------------------------------- |
| **Gross Margin %**   | 0 – 100 % | Gross contribution & LTV math   |
| **S\&M as % of ARR** | 0 – 100 % | CAC & Magic Number calculations |

Drag either slider and the line chart + table update instantly.

### Filter & Period Controls

* **Filter Combo** – isolate a segment using any saved filter (e.g. *Enterprise × North America*).
* **Periodicity** – generate **Annual · Quarterly · Monthly** (pick multiples if desired).

Filters use the same engine as Cohorts & Waterfalls—learn more in the [Filtering](/features/segmentation) guide (only for Excel outputs currently. Dashboard previews coming soon.)

***

## Add in Workbook Designer

<Image src="/images/unit-economics/WorkbookDesignerUnitEcon.png" alt="Workbook Designer – Unit Economics settings" />

1. Open **Workbook Designer › Excel Output Selection**.
2. Expand **Unit Economics**.
3. Choose period(s) (Annual, Quarterly, Monthly) and an optional **Filter Combo**.
4. Set default **Gross Margin %** and **S\&M %** (sliders auto-populate but you can hard-type).
5. Click **Add to Workbook** and proceed to generation.

> Each selected period creates its own sheet so annual, quarterly, and monthly calculations stay independent.

***

## Excel Output

<Image src="/images/unit-economics/ExcelUnitEcon.png" alt="Excel – Unit Economics sheet" />

**Key Features**

* **Yellow cells** for **Gross Margin %** & **S\&M % of ARR**—type hardcodes or link to another sheet.
* Trend chart (LTV/CAC ratio & Magic Number) updates as assumptions change.
* Metrics table per period, including:

  | Category              | Metrics Shown                                        |
  | --------------------- | ---------------------------------------------------- |
  | **Scale**             | Ending ARR, Ending Customer Count                    |
  | **Yield**             | Avg ARR per Customer                                 |
  | **Contribution**      | Gross Contribution per Customer                      |
  | **Retention Input**   | Gross Dollar Retention %                             |
  | **Lifetime & LTV**    | Implied Lifetime (yrs), Lifetime Value               |
  | **CAC Block**         | LTM S\&M Spend, New Logos, CAC, CAC Payback (months) |
  | **Efficiency Ratios** | LTV / CAC, Magic Number                              |

***

## Workflow Recap

<AccordionGroup>
  <Accordion title="1 · Explore in Dashboard">
    Adjust GM & S\&M sliders; apply segment filters; vet the efficiency story.
  </Accordion>

  <Accordion title="2 · Configure in Workbook Designer">
    Pick periods, default assumptions, and any filter combo.
  </Accordion>

  <Accordion title="3 · Generate Excel">
    Edit yellow cells or link formulas to drive instant scenario analysis.
  </Accordion>
</AccordionGroup>