Intermediate
Customer concentration and churn diligence: risk memo
Analyzes customer concentration, churn, and contract terms to produce a risk memo. Useful for buyers assessing sustainability of revenue and margins.
Prepare a customer concentration and churn diligence memo for {target_name}.
Inputs:
- Revenue by customer over time: {revenue_by_customer}
- Contract terms / renewal dates: {contract_terms}
- Churn and retention metrics: {churn_metrics}
- Customer disputes/credits: {disputes}
- Sales pipeline context: {pipeline_context}
Output:
1) Concentration metrics (top 10 %, HHI) and trend.
2) Renewal and churn risk calendar (next 12โ24 months).
3) Key contract risks (termination, pricing, SLAs) and evidence needed.
4) Implications for valuation and working capital.
5) Questions for management.
Use tables and concise risk bullets.Related Prompts
Advisory & Consulting
AdvancedMaster Service Agreement (MSA) for Consulting
A long-term legal framework for ongoing advisory relationships.
GPT-4oClaude 3.5 Sonnet
0
0
144
Advisory & Consulting
IntermediateReal Estate: Fair Value of Investment Properties (IAS 40)
Values commercial real estate holdings based on capitalization rates and net operating income.
GPT-4oClaude 3.5 Sonnet
0
0
135
Advisory & Consulting
AdvancedRestructuring & Turnaround: 13-Week Cash Flow
A critical tool for distressed companies to manage daily liquidity and prioritize payments.
Claude 3.5 SonnetGPT-4o
0
0
171