This question evaluates competency in analytics and experiment-driven financial modeling, covering unit economics, cannibalization versus true lift, break-even and sensitivity analysis, and interpretation of segment-level impacts on partnership profitability.

(a) For each segment (and in total), compute:
(b) Provide at least three insights about customer behavior and economics (e.g., cannibalization vs. true lift, concentration of losses, segment prioritization).
(c) What important factors have we not considered that could change the decision? List at least three, including acquisition of a new customer segment.
(d) New customer segment (acquisition from the merchant’s audience): Segment 4 consists of new-to-C1 customers who sign up because of the partnership. For each such new cardholder, average monthly Total Spend = 800 and Merchant Spend at the partner = 20 (all incremental). What minimum Segment 4 population is required over the 12 months to exactly break even on the total profit/loss from part (a)? Show both the formula and the numeric answer.
(e) Sensitivity: If the merchant funds 50% of the 20% discount (C1 pays the other half), recompute the annual total profit/loss in (a) and the break-even population in (d).
(f) Decision: Based on your results and insights, would you recommend partnering with this merchant? If not, name the top three traits of a better-fit merchant that would flip the economics.
Login required