Unit Economics Model Example

The model begins with an Assumptions sheet that captures granular inputs down to segments or tranches, enabling detailed unit-level analysis. These assumptions feed downstream logic without dead cells, ensuring every input drives the calculations.

• The structure supports flexibility, allowing you to adjust drivers such as acquisition costs or retention rates. Because the assumptions are segmented, you can analyse different customer groups or product lines separately, gaining a more precise understanding of unit economics.
• This granularity helps identify which segments contribute most to profitability and where improvements are needed, all within a consistent framework.

From the assumptions, data flows into Schedules that compute intermediate time-series data. These schedules track how unit-level metrics evolve over time, capturing patterns like cohort behaviour or cost accumulation.

• Calculations then derive key drivers, such as payback period or lifetime value, using relationships that enforce corresponding logic constraints similar to double-entry principles. This ensures internal consistency and reduces errors.
• Cross-sheet dependencies are designed so that Assumptions feed all downstream logic, Schedules compute intermediate data, and Outputs aggregate correctly without ignoring any sections. The result is a reliable, auditable pathway from raw inputs to final metrics.

The Outputs & Analysis sheet presents key metrics, summary tables, and validation checks. These outputs aggregate data from the calculations, providing a clear picture of unit economics.

• Validation checks evaluate to zero for balance checks and confirm that all drivers calculate non-error outputs, helping you trust the results. The model uses a consistent sign convention: inputs are positive, with cash inflows positive and outflows negative.
• This makes it easy to interpret cash movements and profitability. The outputs are designed to highlight operating drivers and business relationships rather than just raw numbers, supporting informed decision-making.

This template is useful for evaluating unit-level performance, such as assessing payback periods or comparing segments. By adjusting assumptions, you can explore how changes in acquisition costs or retention affect overall economics.

• The structured flow from assumptions to outputs allows you to trace how each driver influences results. While the public download is a values-only preview and does not include live formulas, it illustrates the model's logic.
• You can use it as a reference to understand the relationships between acquisition cost, lifetime value, and payback, then apply similar structures in your own analysis. The model is designed for institutional-grade analysis with proper granularity and flexibility.