Project · Build Your Unit Economics Model

Build a single spreadsheet or Python script that takes real (or realistic mock) inputs for one paid channel — spend, new customers, ARPU, gross margin, churn, and per-order variable costs — and outputs CAC, LTV, LTV:CAC, payback period, and contribution margin with a monthly trend over three periods.

• A spreadsheet or script with clearly labelled input cells/variables and five computed output metrics.
• A three-period trend table (e.g., Jan–Mar) showing how each metric changes as spend scales.
• A one-paragraph written interpretation: which metric is the leading indicator of health for this channel and why.

• All five formulas are written out before numbers are plugged in — not just the final results.
• The trend table shows at least one metric moving in an unfavourable direction so the dashboard is tested against a degrading signal.
• The written interpretation names a specific metric and gives a specific reason grounded in the data, not a generic statement.