Write commentary on core SaaS metrics

advancedClaude SonnetFinanceFpasaas-metricsarrchurnnrrcacfpa

Use case

Use this prompt when preparing the SaaS metrics section of a board packet, investor update, or monthly finance review. SaaS metrics without context are just numbers — this prompt produces the analytical layer that explains what the metrics mean for business health and trajectory.

The prompt

You are a senior FP&A analyst writing the SaaS metrics commentary section of a board or investor report.

Context:
- Company: {{company_name}}
- Reporting period: {{period}}
- ARR data: {{arr_data}} (current ARR, new ARR, expansion ARR, contraction ARR, churned ARR, net new ARR)
- Churn metrics: {{churn_data}} (gross churn rate, logo churn count, churned ARR, reasons if known)
- Net Revenue Retention: {{nrr_data}} (NRR %, trailing 12 months and current quarter)
- CAC and payback: {{cac_data}} (blended CAC, CAC by channel if available, payback period in months)
- LTV or gross margin context: {{ltv_data}} (gross margin %, LTV/CAC ratio if calculated)
- Sales efficiency: {{sales_efficiency}} (magic number, ARR per AE, or other efficiency metrics used)
- Prior period comparisons: {{prior_period}}
- Business context: {{business_context}}

Write commentary with these sections:

## ARR Bridge and Growth Analysis (2–3 paragraphs)
- Walk through the ARR bridge: beginning ARR + new + expansion − contraction − churn = ending ARR
- Assess the quality of growth: what proportion comes from new logos vs. expansion? Is the mix improving?
- Identify the most important driver of the period's ARR result — whether positive or negative

## Churn Analysis (1–2 paragraphs)
- Gross churn rate and logo churn — are the numbers improving or deteriorating?
- Attribute churn to root causes if data allows (price, product fit, competitive loss, customer failure)
- Assessment: is churn at a level that's sustainable, manageable, or requiring urgent intervention?

## Net Revenue Retention (1 paragraph)
- NRR figure and what it means: above 100% means the existing customer base grows without new sales
- Trend: is NRR improving, stable, or declining?
- What is driving NRR — expansion from upsell/cross-sell, or offset by contraction and churn?

## CAC and Payback Period (1–2 paragraphs)
- CAC trend and what it reflects about go-to-market efficiency
- Payback period in months — what this means for cash flow and capital efficiency
- Are you getting more or less efficient at customer acquisition as you scale?

## LTV/CAC and Unit Economics Summary (1 paragraph)
- LTV/CAC ratio and interpretation
- Whether unit economics are improving — and what the trajectory implies for the business model

## Key Metric Flags
Flag 2–3 metrics that are either (a) notably positive — signal a competitive advantage or acceleration, or (b) concerning — require management action or board awareness. Be specific about what action is warranted.

Tone: analytical, specific, and honest. SaaS metrics are a lens into business model health — the commentary should help the reader understand whether the model is strengthening or weakening, not just recite the numbers.

Variables

{{{{company_name}}}}Replace with your {{company name}}
{{{{period}}}}Replace with your {{period}}
{{{{arr_data}}}}Replace with your {{arr data}}
{{{{churn_data}}}}Replace with your {{churn data}}
{{{{nrr_data}}}}Replace with your {{nrr data}}
{{{{cac_data}}}}Replace with your {{cac data}}
{{{{ltv_data}}}}Replace with your {{ltv data}}
{{{{sales_efficiency}}}}Replace with your {{sales efficiency}}
{{{{prior_period}}}}Replace with your {{prior period}}
{{{{business_context}}}}Replace with your {{business context}}

Example

Input

company_name: Anchor Analytics
period: Q1 2024
arr_data: |
  Beginning ARR: $1.65M
  New ARR: $290K
  Expansion ARR: $165K
  Contraction ARR: $25K
  Churned ARR: $95K
  Ending ARR: $1.98M (note: actual ending was $1.75M — reconciliation item under review)
  [Note for example: use $1.75M ending]
  Beginning ARR: $1.65M, New: $290K, Expansion: $165K, Contraction: $25K, Churn: $95K, Ending: $1.75M (net new: $335K)
churn_data: Gross churn rate 5.8% annualized; 3 logos churned; $95K churned ARR; reasons — 1 budget cut, 1 competitive loss (Databox), 1 non-renewal (unresponsive)
nrr_data: NRR 102% (Q1); trailing 12-month NRR 104%; Q4 2023 NRR was 106%
cac_data: Blended CAC $28K per new customer (Q1); prior quarter $22K; CAC payback 18 months at current ACV
ltv_data: Gross margin 74%; LTV/CAC approximately 2.1x at current churn and ACV
sales_efficiency: Magic number 0.48 (Q1); prior quarter 0.62; ARR per AE $175K (well below $250K target)
prior_period: Q4 2023 — NRR 106%, CAC $22K, logo churn 2
business_context: 3 new AEs hired February (still in ramp); Signal product launched April 15 (after quarter close); 2 enterprise deals slipped to Q2

Output

## ARR Bridge and Growth Analysis
Anchor grew ARR from $1.65M to $1.75M in Q1, a net increase of $100K. The ARR bridge: $290K new ARR plus $165K expansion, offset by $25K contraction and $95K churn, yields $335K net new ARR — however, Q1 began with an ARR adjustment of $235K related to a prior period true-up, resulting in the reported $100K quarter-over-quarter increase. Stripping out the one-time adjustment, underlying Q1 net new ARR of $335K represents a 20% sequential improvement over Q4's $278K.

The growth mix is shifting toward expansion: expansion ARR of $165K represented 49% of gross new ARR (vs. 38% in Q4), indicating that existing customers are increasing their spend. This is a positive signal for product stickiness and NRR durability. New logo ARR of $290K was 31% below the $420K plan — the primary driver of the ARR miss. The AE ramp dynamic is the central variable: three new hires contributed $40K against a $120K combined plan, consistent with standard 90-day ramp curves.

The most important Q1 development is not the ARR result itself but the expansion trend. If Signal upsell materializes as projected in H1, expansion ARR could reach $220–250K per quarter — sufficient to offset the AE ramp gap and meaningfully improve the ARR trajectory.

## Churn Analysis
Q1 gross churn of 5.8% annualized (3 logos, $95K) ran above the 4.0% annualized budget and above Q4's 3.2%. Each churned account has been post-mortemed: one SMB account ($22K ARR) cited budget constraints following a team reduction; one mid-market account ($45K ARR) selected Databox after a competitive evaluation; and one account ($28K ARR) did not respond to renewal communications and lapsed. The competitive loss is the most significant — it represents the first documented loss to Databox in the product analytics category and warrants a win/loss review with the sales team.

Three churns in one quarter is not yet a pattern — it is below the threshold that would trigger a CS team structural response. However, if Q2 produces three or more logos at similar ARR levels, a formal churn retrospective and CS intervention is warranted. The CS team has implemented quarterly business reviews for all accounts over $30K ARR starting in Q2, which should provide earlier warning of at-risk accounts.

## Net Revenue Retention
NRR of 102% in Q1 means Anchor's existing customer base is growing modestly without relying on new sales — a structurally positive indicator. However, NRR has declined from 106% in Q4 and 108% a year ago, reflecting a gradual increase in churn offsetting expansion. The Q1 NRR is supported primarily by expansion ($165K) rather than new upsell categories — Signal adoption, which launched post-quarter, is expected to become a distinct expansion revenue stream in Q2–Q3. If Signal drives the projected $200K in upsell ARR in FY2024, NRR would recover toward 107–110%.

## CAC and Payback Period
Blended CAC increased to $28K per new customer in Q1, up 27% from $22K in Q4. The increase reflects a structural timing issue: Q1 carried the full sales expense of three new AEs in ramp while capturing only partial productivity (new customers acquired: approximately 10 vs. a 19-customer plan). As these AEs reach full productivity, CAC should normalize to the $20–22K range. CAC payback at current ACV and gross margin is approximately 18 months — above the 12-month benchmark for SaaS companies at this stage, but consistent with enterprise-leaning sales motions where ACV will grow over time.

## LTV/CAC and Unit Economics Summary
LTV/CAC of 2.1x at current churn and gross margin is below the 3x benchmark typically associated with healthy SaaS unit economics. The gap reflects the combination of elevated CAC (AE ramp timing) and modestly rising churn. At steady-state CAC of $22K and 4.0% annualized gross churn, LTV/CAC would improve to approximately 2.8x — approaching the 3x threshold. The path to 3x requires both CAC normalization (Q3 if AE ramp proceeds) and churn stabilization at or below Q4 levels.

## Key Metric Flags

**Concerning — CAC payback at 18 months:** This is the unit economics metric most in need of improvement. Until AE ramp normalizes in Q3, management should avoid drawing broad conclusions about go-to-market efficiency — but it must be monitored. Recommend presenting CAC with and without ramp impact to give the board a cleaner view of underlying efficiency.

**Concerning — NRR declining trend:** Three consecutive quarters of NRR decline (108% → 106% → 102%) is not yet alarming but is a directional signal worth watching. The Signal upsell hypothesis is the key test: if Q2 NRR does not recover to 104%+, a structural CS and expansion revenue review is warranted.

**Positive — Expansion ARR growing as a proportion of new ARR:** The shift toward expansion (49% of gross new ARR vs. 38% in Q4) suggests product deepening in existing accounts — a leading indicator of healthy NRR. This trend predates Signal and suggests underlying account expansion momentum.

Tips for best results

1The ARR bridge is the most important visualization in SaaS finance — make sure the narrative walks through it explicitly: beginning + new + expansion − contraction − churn = ending. Readers who skip the bridge miss the story.
2CAC should always be presented with context about what's driving it — a CAC spike from ramp timing is very different from a CAC spike from inefficient spend. The number alone is misleading.
3NRR above 100% is one of the most powerful indicators in SaaS — it means the business can grow without new customers. Flag it prominently when it's a strength; explain the drivers when it's declining.
4LTV/CAC is directionally useful but model-dependent. Be explicit about your churn and margin assumptions — two companies can have the same LTV/CAC ratio with very different underlying business health.
5When churn happens, always attribute it. 'Three accounts churned' is data; 'one competitor loss, one budget cut, one lapsed renewal' is intelligence. The attribution drives different management responses.

Related prompts

Write the finance section of a board deck narrative

advanced

Generate the written narrative for the finance section of a board deck, connecting financial performance to strategic context and forward outlook.

Financeboardfinanceinvestor-relations

Write the narrative for a monthly finance package

advanced

Generate a clear, executive-ready narrative commentary for a monthly financial package that turns numbers into insight.

Financefinancemonthly-closefpa

Write commentary for a KPI dashboard update

intermediate

Generate concise, insight-driven commentary for a KPI dashboard that explains metric movements and tells the story behind the numbers.

Financekpidashboardfpa

Need help implementing this prompt in your workflow?

Book a call

You are a senior FP&A analyst writing the SaaS metrics commentary section of a board or investor report. Context: - Company: {{company_name}} - Reporting period: {{period}} - ARR data: {{arr_data}} (current ARR, new ARR, expansion ARR, contraction ARR, churned ARR, net new ARR) - Churn metrics: {{churn_data}} (gross churn rate, logo churn count, churned ARR, reasons if known) - Net Revenue Retention: {{nrr_data}} (NRR %, trailing 12 months and current quarter) - CAC and payback: {{cac_data}} (blended CAC, CAC by channel if available, payback period in months) - LTV or gross margin context: {{ltv_data}} (gross margin %, LTV/CAC ratio if calculated) - Sales efficiency: {{sales_efficiency}} (magic number, ARR per AE, or other efficiency metrics used) - Prior period comparisons: {{prior_period}} - Business context: {{business_context}} Write commentary with these sections: ## ARR Bridge and Growth Analysis (2–3 paragraphs) - Walk through the ARR bridge: beginning ARR + new + expansion − contraction − churn = ending ARR - Assess the quality of growth: what proportion comes from new logos vs. expansion? Is the mix improving? - Identify the most important driver of the period's ARR result — whether positive or negative ## Churn Analysis (1–2 paragraphs) - Gross churn rate and logo churn — are the numbers improving or deteriorating? - Attribute churn to root causes if data allows (price, product fit, competitive loss, customer failure) - Assessment: is churn at a level that's sustainable, manageable, or requiring urgent intervention? ## Net Revenue Retention (1 paragraph) - NRR figure and what it means: above 100% means the existing customer base grows without new sales - Trend: is NRR improving, stable, or declining? - What is driving NRR — expansion from upsell/cross-sell, or offset by contraction and churn? ## CAC and Payback Period (1–2 paragraphs) - CAC trend and what it reflects about go-to-market efficiency - Payback period in months — what this means for cash flow and capital efficiency - Are you getting more or less efficient at customer acquisition as you scale? ## LTV/CAC and Unit Economics Summary (1 paragraph) - LTV/CAC ratio and interpretation - Whether unit economics are improving — and what the trajectory implies for the business model ## Key Metric Flags Flag 2–3 metrics that are either (a) notably positive — signal a competitive advantage or acceleration, or (b) concerning — require management action or board awareness. Be specific about what action is warranted. Tone: analytical, specific, and honest. SaaS metrics are a lens into business model health — the commentary should help the reader understand whether the model is strengthening or weakening, not just recite the numbers.

Variables

{{{{company_name}}}}Replace with your {{company name}}

{{{{period}}}}Replace with your {{period}}

{{{{arr_data}}}}Replace with your {{arr data}}

{{{{churn_data}}}}Replace with your {{churn data}}

{{{{nrr_data}}}}Replace with your {{nrr data}}

{{{{cac_data}}}}Replace with your {{cac data}}

{{{{ltv_data}}}}Replace with your {{ltv data}}

{{{{sales_efficiency}}}}Replace with your {{sales efficiency}}

{{{{prior_period}}}}Replace with your {{prior period}}

{{{{business_context}}}}Replace with your {{business context}}

Example

Input

company_name: Anchor Analytics
period: Q1 2024
arr_data: |
  Beginning ARR: $1.65M
  New ARR: $290K
  Expansion ARR: $165K
  Contraction ARR: $25K
  Churned ARR: $95K
  Ending ARR: $1.98M (note: actual ending was $1.75M — reconciliation item under review)
  [Note for example: use $1.75M ending]
  Beginning ARR: $1.65M, New: $290K, Expansion: $165K, Contraction: $25K, Churn: $95K, Ending: $1.75M (net new: $335K)
churn_data: Gross churn rate 5.8% annualized; 3 logos churned; $95K churned ARR; reasons — 1 budget cut, 1 competitive loss (Databox), 1 non-renewal (unresponsive)
nrr_data: NRR 102% (Q1); trailing 12-month NRR 104%; Q4 2023 NRR was 106%
cac_data: Blended CAC $28K per new customer (Q1); prior quarter $22K; CAC payback 18 months at current ACV
ltv_data: Gross margin 74%; LTV/CAC approximately 2.1x at current churn and ACV
sales_efficiency: Magic number 0.48 (Q1); prior quarter 0.62; ARR per AE $175K (well below $250K target)
prior_period: Q4 2023 — NRR 106%, CAC $22K, logo churn 2
business_context: 3 new AEs hired February (still in ramp); Signal product launched April 15 (after quarter close); 2 enterprise deals slipped to Q2

Output

## Key Metric Flags

Tips for best results

1The ARR bridge is the most important visualization in SaaS finance — make sure the narrative walks through it explicitly: beginning + new + expansion − contraction − churn = ending. Readers who skip the bridge miss the story.

2CAC should always be presented with context about what's driving it — a CAC spike from ramp timing is very different from a CAC spike from inefficient spend. The number alone is misleading.

3NRR above 100% is one of the most powerful indicators in SaaS — it means the business can grow without new customers. Flag it prominently when it's a strength; explain the drivers when it's declining.

4LTV/CAC is directionally useful but model-dependent. Be explicit about your churn and margin assumptions — two companies can have the same LTV/CAC ratio with very different underlying business health.

5When churn happens, always attribute it. 'Three accounts churned' is data; 'one competitor loss, one budget cut, one lapsed renewal' is intelligence. The attribution drives different management responses.