How do I use the "Calculate Monthly Recurring Revenue (MRR)" prompt?

Copy the prompt template, fill in the variables (BUSINESS_TYPE, SUBSCRIPTION_DATA, TIME_PERIOD, CURRENCY), and paste it into ChatGPT, Claude, or Gemini.

What AI tools work with this data prompt?

This prompt works with chatgpt, claude, gemini. Simply copy and paste the template into any of these AI assistants.

Tips for getting the best results?

Always exclude one-time payments, setup fees, and annual subscriptions (convert annual to monthly) Track MRR movements in categories (New, Expansion, Contraction, Churn) for better insights Use the same calculation date each month (e.g., last day of month) for consistency Include only active, paying subscribers in your MRR calculations Regularly audit your MRR calculations against actual revenue to catch discrepancies

data beginner

Calculate Monthly Recurring Revenue (MRR)

AI prompt to calculate monthly recurring revenue from subscription data. Perfect for SaaS businesses and subscription tracking.

Works with: chatgptclaudegemini

Prompt Template

I need help calculating Monthly Recurring Revenue (MRR) for my subscription business. Please create a comprehensive MRR calculation framework and provide step-by-step instructions. My business details: - Business type: [BUSINESS_TYPE] - Subscription data: [SUBSCRIPTION_DATA] - Time period for analysis: [TIME_PERIOD] - Currency: [CURRENCY] Please provide: 1. A clear definition of MRR and why it's important 2. Step-by-step calculation methodology 3. A spreadsheet structure/template with column headers 4. Formulas for calculating: - New MRR (from new customers) - Expansion MRR (from upgrades/add-ons) - Contraction MRR (from downgrades) - Churned MRR (from cancellations) - Net New MRR 5. Sample calculations using my data 6. Key metrics to track alongside MRR (like churn rate, ARPU) 7. Best practices for maintaining accurate MRR tracking 8. Common mistakes to avoid when calculating MRR Format the response with clear headings, and provide any Excel/Google Sheets formulas using proper syntax. If my data is incomplete, suggest what additional information I should collect.

Variables to Customize

[BUSINESS_TYPE]

Type of subscription business

Example: SaaS project management tool

[SUBSCRIPTION_DATA]

Current subscription information

Example: 50 customers at $29/month, 25 customers at $99/month, 10 customers at $199/month

[TIME_PERIOD]

Period you want to analyze

Example: Last 6 months (January to June 2024)

[CURRENCY]

Currency for calculations

Example: USD

Example Output

# Monthly Recurring Revenue (MRR) Calculation Guide ## What is MRR? MRR represents the predictable revenue your subscription business generates each month. It's crucial for forecasting, investor reporting, and business health assessment. ## Your Current MRR Breakdown: - Basic Plan (50 × $29): $1,450 - Professional Plan (25 × $99): $2,475 - Enterprise Plan (10 × $199): $1,990 - **Total Current MRR: $5,915** ## Spreadsheet Template Structure: | Customer ID | Plan Type | Monthly Fee | Start Date | End Date | Status | MRR Contribution | ## Key Formulas: - New MRR: `=SUMIF(Status,"New",MRR_Contribution)` - Churned MRR: `=SUMIF(Status,"Churned",MRR_Contribution)*-1` - Net New MRR: `=New_MRR + Expansion_MRR - Contraction_MRR - Churned_MRR` ## Additional Metrics to Track: - Customer Acquisition Cost (CAC) - Average Revenue Per User (ARPU): $68.41 - Monthly Churn Rate - Customer Lifetime Value (CLV) ## Best Practices: 1. Update MRR calculations monthly 2. Track MRR movements by category 3. Exclude one-time fees and setup costs 4. Use consistent date conventions

Pro Tips for Best Results

Always exclude one-time payments, setup fees, and annual subscriptions (convert annual to monthly)
Track MRR movements in categories (New, Expansion, Contraction, Churn) for better insights
Use the same calculation date each month (e.g., last day of month) for consistency
Include only active, paying subscribers in your MRR calculations
Regularly audit your MRR calculations against actual revenue to catch discrepancies