Calculate Profitability and Evaluate Partnership for Credit Card Portfolio
Quick Overview
Evaluates credit-card portfolio profitability and partnership economics. Strong answers build a unit-economics model, compute annual per-user and aggregate profit, evaluate new-user lifetime value net of CAC, calculate break-even CAC, and stress-test credit risk, retention, and spend assumptions.
Calculate Profitability and Evaluate Partnership for Credit Card Portfolio
Company: Capital One
Role: Data Scientist
Category: Analytics & Experimentation
Difficulty: medium
Interview Round: Onsite
##### Scenario
Business case to evaluate profitability of a credit-card product and a potential user-acquisition partnership.
##### Question
Given revenue and cost components, calculate current per-user and aggregate profit of the credit card portfolio. If we partner with an external institution to attract new users at a proposed acquisition cost, determine whether the partnership is financially worthwhile.
##### Hints
Lay out revenue-cost framework, compute incremental profit, and perform sensitivity analysis on key assumptions.
Quick Answer: Evaluates credit-card portfolio profitability and partnership economics. Strong answers build a unit-economics model, compute annual per-user and aggregate profit, evaluate new-user lifetime value net of CAC, calculate break-even CAC, and stress-test credit risk, retention, and spend assumptions.
Calculate Profitability and Evaluate a Partnership for a Credit Card Portfolio
You are analyzing a mature credit-card portfolio to assess current profitability and evaluate a potential acquisition partnership that would bring in new users at a proposed cost per acquired user.
Constraints & Assumptions
Treat past acquisition cost for existing users as sunk.
Include incremental customer acquisition cost when evaluating new users from the partnership.
Separate annual run-rate profit from lifetime value.
State assumptions clearly and show formulas before the numeric example.
Clarifying Questions to Ask Guidance
What is the time horizon for profitability and partnership evaluation?
Are users transactors, revolvers, or a mix?
Do rewards, interchange, charge-offs, funding cost, and servicing cost vary by segment?
Are we evaluating accounting profit, cash flow, LTV, NPV, or risk-adjusted return?
Part 1 - Build the Unit-Economics Framework
Build a clear revenue-cost framework for a credit-card user.
What This Part Should Cover Guidance
Revenue from interest income, interchange, fees, and other income if applicable.
Costs from rewards, credit losses, funding, servicing, fraud, chargebacks, overhead, and incremental acquisition.
Distinction between purchase volume, carried balance, and active users.
Part 2 - Compute Current Profit
Compute current per-user annual profit and aggregate annual profit for the existing portfolio.
What This Part Should Cover Guidance
Formula for per-user annual profit.
Multiplication by active users for aggregate annual profit.
Treatment of fixed overhead and sunk acquisition costs.
A worked numeric example with assumptions.
Part 3 - Evaluate the Partnership
Evaluate a proposed partnership that acquires new users at a cost per acquired user. Determine whether it is financially worthwhile.
What This Part Should Cover Guidance
Lifetime value before acquisition cost, retention or survival curve, discount rate, and net value after CAC.
Break-even CAC and payback period.
Incremental versus average profitability and whether new users match existing portfolio economics.
Part 4 - Sensitivity and Recommendation
Perform sensitivity analysis on key assumptions and provide a recommendation.
Risk-adjusted view for credit losses and adverse selection.
Recommendation with conditions, risks, and next data needed.
What a Strong Answer Covers Guidance
A strong answer builds a transparent unit-economics model, computes per-user and aggregate profit, evaluates partnership LTV net of CAC, and stress-tests the recommendation against credit risk, retention, spend, and funding assumptions.
Follow-up Questions Guidance
How would profitability differ for transactors versus revolvers?
What if the partnership users have higher spend but worse credit losses?
Which assumption would you validate first before signing the partnership?
