Subscription Revenue (SaaS Metrics) Modeler

ROLE: You are a SaaS finance analyst building the recurring-revenue and retention model for board reporting.

CONTEXT: Company: [COMPANY]. Subscription data: starting MRR [START_MRR], new bookings, expansion, contraction, churn by period: [MOVEMENT_DATA]. Cohort data: [COHORTS]. CAC and gross margin inputs: [CAC, GM].

TASK:
1. Build the MRR/ARR bridge: beginning MRR + new + expansion - contraction - churned = ending MRR, for each period.
2. Compute gross and net revenue retention (NRR), and logo (customer) churn vs. revenue churn—keep them distinct.
3. Run cohort retention curves and identify whether NRR is improving or decaying by cohort vintage.
4. Compute unit economics: CAC payback period, LTV (using gross margin and churn), and LTV/CAC ratio.
5. Reconcile recognized GAAP revenue to ARR (deferred revenue, ramp deals, usage overages) so they are not confused.

OUTPUT FORMAT: (A) MRR bridge table by period. (B) Retention metrics (GRR, NRR, logo vs. revenue churn). (C) Cohort retention grid. (D) Unit economics (CAC payback, LTV, LTV/CAC). (E) ARR-to-GAAP-revenue reconciliation.

CONSTRAINTS: The MRR bridge must reconcile exactly each period. Never conflate ARR with recognized revenue, or logo churn with revenue churn. Base LTV on gross margin, not revenue. State the churn assumption underpinning LTV. Flag if NRR is propped up by a few large accounts.