Intermediate
ARR/MRR rollforward with churn, expansion, and cohort view
Creates an ARR/MRR rollforward and cohort-based retention view using subscription data. Useful for SaaS metrics reporting and investor updates.
Build an ARR/MRR rollforward for {period}.
Inputs:
- Subscription snapshot data: {subscriptions}
- Churn and expansion events: {customer_events}
- Pricing changes and discounts: {pricing_changes}
- Definitions (ARR vs MRR, gross vs net): {definitions}
Output:
1) Rollforward table: Begin, New, Expansion, Contraction, Churn, End.
2) Gross and net retention metrics with formulas.
3) Cohort retention table (by start month/quarter) if data supports.
4) Data quality checks (duplicates, proration, currency).
Be explicit about definitions used.Related Prompts
Industry-Specific
AdvancedChannel rebates and returns accrual model (consumer goods)
Designs an accrual model for rebates, returns, and allowances common in consumer goods, with rollforward schedules. Useful for close and audit support.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
15
Industry-Specific
AdvancedHIPAA Security Rule Risk Analysis
Evaluates the technical safeguards for Protected Health Information (PHI).
Claude 3.5 SonnetGPT-4o
0
0
7
Industry-Specific
AdvancedSaaS revenue waterfall: bookings โ billings โ revenue โ cash
Builds a SaaS revenue waterfall reconciling bookings, billings, deferred revenue, and revenue recognition. Useful for FP&A and accounting alignment and board reporting.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
7