omni_mrr_expansion_contraction
Calculate net new MRR, ending MRR, net revenue retention, and monthly growth from new, expansion, contraction, and churn inputs.
Instructions
Monthly Recurring Revenue (MRR) Net Expansion & Contraction Calculator. Calculate Net New MRR, Net Revenue Retention (NRR), and MRR growth velocity across new acquisitions, account upgrades, downgrades, and churn. Discipline: ECOMMERCE. Governing mathematical model / formula: Net New MRR = New MRR + Expansion MRR - Contraction MRR - Churned MRR | NRR % = [(Ending MRR from Existing) / Starting MRR] × 100.
USAGE GUIDELINES:
WHEN TO USE: Invoke for deterministic calculation of net_new_mrr_growth (Net New Monthly MRR Added), ending_month_mrr (End of Month Total MRR), net_revenue_retention_nrr (Net Revenue Retention (NRR)), monthly_growth_rate_pct (Monthly MRR Growth Velocity) using beginning_monthly_mrr (Beginning of Month MRR in $), new_customer_mrr (New Customer MRR Acquired in $), expansion_upsell_mrr (Expansion MRR (Upgrades / Add-ons) in $), contraction_downgrade_mrr (Contraction MRR (Downgrades) in $), churned_customer_mrr (Churned MRR (Cancellations) in $). Guarantees exact machine floating-point precision, eliminating LLM arithmetic mistakes and formula hallucinations.
WHEN NOT TO USE: Do not use for qualitative evaluations or unquantified reasoning. All input parameters must be valid numerical values.
DISAMBIGUATION & BOUNDARIES:
Use this dedicated specialist tool for 'Monthly Recurring Revenue (MRR) Net Expansion & Contraction Calculator' rather than generic dispatchers like omni_universal_query.
For multi-calculation chained jobs, use 'omni_batch_calculate'.
To inspect schema fields, see 'omni_describe_solver'.
BEHAVIOR & SAFETY:
Pure deterministic computation with machine floating-point precision.
Read-only, idempotent, and stateless. Zero side effects or persistent state mutations.
Input validation: All arguments are validated against physical and domain bounds. Out-of-bounds inputs return a safe diagnostic error status without throwing runtime exceptions.
RETURNS:
Structured JSON object containing:
status (string): "success" on valid execution or "error" if validation fails
calculator (string): "mrr-expansion-contraction"
category (string): "ecommerce"
name (string): "Monthly Recurring Revenue (MRR) Net Expansion & Contraction Calculator"
formula (string): Governing mathematical formula string
inputs (object): Echoed input parameter dictionary with applied defaults
metrics (object): Dictionary of computed outputs:
metrics.net_new_mrr_growth (Net New Monthly MRR Added): Formatted display string (e.g. '+$13,500 / mo')
metrics.ending_month_mrr (End of Month Total MRR): Formatted display string (e.g. '$133,500')
metrics.net_revenue_retention_nrr (Net Revenue Retention (NRR)): Formatted display string (e.g. '99.6%')
metrics.monthly_growth_rate_pct (Monthly MRR Growth Velocity): Formatted display string (e.g. '+11.25%')
execution_time_ms (number): Latency in milliseconds.
Tool call template
This tool declares no required parameters. Add optional parameters from the input schema as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {},
"name": "omni_mrr_expansion_contraction"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| new_customer_mrr | No | New Customer MRR Acquired ($). MRR from brand new subscribers in month. Default: 14000. Min: 0. Max: 1000000. | |
| churned_customer_mrr | No | Churned MRR (Cancellations) ($). Revenue lost from full subscriber cancellations. Default: 4800. Min: 0. Max: 500000. | |
| expansion_upsell_mrr | No | Expansion MRR (Upgrades / Add-ons) ($). Existing customers upgrading tiers or adding seats. Default: 6500. Min: 0. Max: 500000. | |
| beginning_monthly_mrr | No | Beginning of Month MRR ($). Active recurring revenue at the start of the month. Default: 120000. Min: 1000. Max: 10000000. | |
| contraction_downgrade_mrr | No | Contraction MRR (Downgrades) ($). Existing customers downgrading to cheaper plans. Default: 2200. Min: 0. Max: 200000. |