Present Analytical Process and Recommendations for Credit-Card Profitability.

Below is a pragmatic, manager‑friendly way to communicate credit‑card profitability and partnership options, optimized for a short meeting. It balances storytelling with enough analytical depth to inspire confidence. --- Approach overview - Objective: Enable a decision (e.g., launch/modify card, select partner A vs. B) with a clear, defensible recommendation. - Delivery: 1‑page executive summary + 8–12 slide deck + appendix + shareable assumption log/model snapshot. - Storyline: Pyramid principle — lead with recommendation, support with 3–4 key drivers, then evidence. 1) Start by aligning on the decision and time - Opening (30–60 seconds): "Today, I’ll recommend Partner A over B for the new co‑brand. I’ll cover expected profitability, what drives it, risks, and the 3 next steps to de‑risk. Does that match your expectations and time (15 mins)?" - Why: Reduces surprises and tailors depth. 2) Executive summary (1 page, 2 minutes) - Recommendation headline: "Choose Partner A; expected 3‑year portfolio NPV +$24M vs. +$15M for Partner B, 70% confidence." - 3 drivers: 1) Higher interchange/SPend uplift offsets slightly higher rewards cost. 2) Lower CAC via partner channels shortens payback from 18 to 12 months. 3) Comparable credit losses after tightened underwriting. - Risks and mitigations: "Loss‑rate uncertainty ±120 bps; run targeted A/B pre‑launch and tighten cutoffs." - Decision ask and next steps: "Approve Partner A contingent on pilot; greenlight data‑sharing terms; finalize pricing." 3) Clarify business objective, scope, and definitions - Objective: Maximize risk‑adjusted CLV/NPV while meeting brand and compliance criteria. - Scope: Consumer revolving card; 3‑year horizon; discount rate 10%. - Key definitions: CLV, CAC, ECL (PD×LGD×EAD), interchange, rewards rate, payback (months to recover CAC). 4) Assumptions and data (transparent, source‑linked) - Assumption log (kept simple on slide; full table in appendix): - Approval rate: 45% (back‑tested on last 12 months applicants). - Average annual spend: $6,000; interchange 2.0%. - Revolve rate: 35%; APR 20%; average revolving balance $500. - Rewards cost: 1.5% of spend (base), 1.9% for airline co‑brand. - Credit losses: PD 6%, LGD 85%, EAD $1,200 (base segment). ECL ≈ $61/account/year. - Funding cost: 4% on revolving balances. - Servicing cost: $25/account/year. - CAC: $200 (base), $140 with Partner A channels. - Data quality: outline sources (internal portfolios, bureau data, partner LOIs), and note any gaps. 5) Calculations: unit economics and CLV/NPV - Per‑account annual unit economics (illustrative numbers): - Revenue: interest $120 (20% APR on $600 avg revolve), interchange $120 (2% × $6,000 spend), fees $15 ⇒ $255. - Costs: rewards $90 (1.5% × $6,000), credit losses $61, funding $24 (4% × $600), servicing $25 ⇒ $200. - Contribution before CAC: $255 − $200 = $55. - With CAC amortized over 2 years: $55 − $100 = −$45 in year 1, +$55 in year 2. - CLV (3‑year, retention r, discount d): - CLV = Σ_t (Contribution_t × r^t)/(1+d)^t − CAC. - Example: retention 80%/year, d=10% ⇒ Year1: −$45, Year2: $55×0.8/1.1 ≈ $40, Year3: $55×0.8^2/1.1^2 ≈ $32 ⇒ CLV ≈ $27. - Portfolio NPV scales with expected active accounts. - Visuals: 1) Waterfall of per‑account economics; 2) Payback curve; 3) Cohort CLV chart. 6) Partnership options: compare A vs. B with economics + non‑financials - Framework: Weighted scorecard (Economics 50%, Strategic fit 20%, Risk 15%, Operational complexity 15%). - Economics impact (illustrative deltas vs. base): - Partner A: +0.3% spend uplift, +0.1% interchange, rewards +0.2%, CAC −$60, similar losses. - Partner B: +0.1% spend, +0.05% interchange, rewards +0.1%, CAC −$30, slightly higher losses (+40 bps). - 3‑year portfolio NPV example (100k approvals): - A: CLV/account $36 ⇒ NPV ≈ $3.6M; with channel scale and retention lift ⇒ $24M after scale effects. - B: CLV/account $23 ⇒ ≈ $15M. - Non‑financials: data‑sharing, brand lift, operational readiness, regulatory posture. Show a simple 2×2 or score table. 7) Sensitivity and scenarios (show robustness) - One‑way sensitivities (tornado chart): rewards rate (±50 bps), PD (±150 bps), CAC (±$50), spend (±10%), revolve (±5 pp). - Scenario table: - Base: A NPV +$24M; B +$15M. - Downside (losses +150 bps, spend −10%): A +$8M; B +$2M. - Upside (CAC −$80 with A’s channel, spend +10%): A +$35M; B +$20M. - Break‑even levers: "Reduce rewards by 30 bps or tighten cutoff to cut PD by 80 bps to hit 12‑month payback." 8) Validation and guardrails - Back‑testing: Compare model to last 3 portfolio vintages; report MAPE for loss and spend forecasts. - Reasonableness checks: benchmark interchange, rewards, and losses vs. market reports. - Reconciliation: ensure totals tie to GL/finance where appropriate. - Compliance/ethics: fair‑lending checks on underwriting changes; clear disclosures on rewards adjustments; data privacy in partnerships. 9) Recommendation and decision asks - Decision: "Approve Partner A contingent on a 3‑month pilot with 20k apps." - Conditions: "Proceed if 12‑month payback ≤ 14 months and loss rate ≤ 7%." - Next steps (owners, timeline): - Negotiate data‑sharing and marketing commitments (Legal/BD, 2 weeks). - Launch controlled pilot and A/B offers (Marketing/DS, 6–8 weeks). - Implement monitoring: weekly funnel metrics, vintage loss tracking, rewards cost dashboard (Analytics, ongoing). 10) Artifacts to bring and how to use them - 1‑page memo: headline, impact, risks, asks. - Slide deck (8–12): storyline, key charts (waterfall, tornado, scenario table, scorecard), minimal text. - Appendix: full assumption log; methodology; back‑tests; partner score details. - Model snapshot: read‑only sheet with key inputs/outputs; versioned in Git; parameter toggle for live what‑if. Delivery tips (HR‑screen friendly) - Lead with the answer; don’t bury the lede. - Quantify impact and confidence; separate facts from assumptions. - Show the 1–2 charts that change the decision; park details in appendix. - Invite challenge: "If rewards must stay at 1.9%, here’s the sensitivity — payback extends to 16 months." - Close with a clear ask and the minimal set of next steps to act immediately. Common pitfalls to avoid - Overloading with methodology before stating the recommendation. - Hiding assumption uncertainty; always show sensitivities. - Mixing metrics (per‑account vs. portfolio) without clear labels. - Not aligning on decision criteria up front (e.g., required payback, risk appetite). This structure makes the decision easy, keeps the analysis auditable, and demonstrates leadership in how you communicate, not just what you compute.