Zapof

Monthly Recurring Revenue (MRR) Tracker

Business Type: Membership / Subscription Services

The Pricing Rules:

  1. Tier 1 (Basic): $29/mo
  2. Tier 2 (Standard): $59/mo
  3. Tier 3 (Pro): $99/mo
  4. Tier 4 (Enterprise): $299/mo


  • Annual Discount: 15% off (Multiply by 0.85) if the "Annual" plan is selected.
 

Monthly Recurring Revenue (MRR) Table

Member Name

Tier Index

Plan Type

Base Rate

(CHOOSE)

Final Monthly Revenue

Login Inactivity (Days)

Activity Status

A
B
C
D
E
F
G
1
Fitness First
2
Monthly
$59.00
$59.00
7
✅ Active
2
Urban Yoga
1
Annual
$29.00
$24.65
28
✅ Active
3
Global Tech
4
Annual
$299.00
$254.15
40
⚠️ AT RISK
4
Sarah Jenkins
1
Monthly
$29.00
$29.00
100
❌ CHURNED
5
Cloud Systems
3
Monthly
$99.00
$99.00
15
✅ Active
6
Peak Perform
3
Annual
$99.00
$84.15
22
✅ Active
7
Small Biz Inc
2
Annual
$59.00
$50.15
35
⚠️ AT RISK

Membership Data with Annual Projections

Member Name

Tier Index

Plan Type

Final Monthly Revenue

Proj. Annual Revenue

Login Inactivity (Days)

Activity Status

A
B
C
D
E
F
G
1
Fitness First
2
Monthly
$59.00
$708.00
7
✅ Active
2
Urban Yoga
1
Annual
$24.65
$295.80
28
✅ Active
3
Global Tech
4
Annual
$254.15
$3,049.80
40
⚠️ AT RISK
4
Sarah Jenkins
1
Monthly
$29.00
$348.00
100
❌ CHURNED
5
Cloud Systems
3
Monthly
$99.00
$1,188.00
15
✅ Active
6
Peak Perform
3
Annual
$84.15
$1,009.80
22
✅ Active
7
Small Biz Inc
2
Annual
$50.15
$601.80
35
⚠️ AT RISK
8
TOTALS
 
 
$600.10
$7,201.20
 
 

Form Template Insights

Please remove this form template insight sections before publishing.

How the Formulas Work Together

1. The Base Rate (The Switch)

The "Base Rate" column uses the CHOOSE function. It looks at the "Tier Index" and pulls the correct price from the list.

  • Formula: =CHOOSE(B3, 29, 59, 99, 299)
  • Example (Global Tech): The index is 4. The formula looks at the 4th number in the list and returns $299.00.
 

2. The Final Monthly Revenue (The Logic)

This column calculates the actual money hitting the bank account after checking for discounts.

  • Formula:=IF(C2="Annual", D2 * 0.85, D2)
  • Example (Urban Yoga): Since the plan is "Annual," the $29.00 base rate is multiplied by 0.85, resulting in $24.65.
 

3. The Activity Status (The Alert)

This uses Conditional Formatting based on "Days Since Last Login."

  • Logic:
    • 0-30 Days: ✅ Active (Green)
    • 31-60 Days: ⚠️ AT RISK (Yellow)
    • 60+ Days: ❌ CHURNED (Red)

1. Projected Annual Revenue (Column E)

Since all calculations in the "Monthly Rev" column already account for discounts, we simply multiply that figure by 12 months.

  • Formula: =D1 * 12
  • The Logic: This shows the Annual Run Rate (ARR). For Global Tech, while they pay monthly, their commitment is worth over $3,000 a year. This helps the business owner realize that losing this one "At Risk" client is much more damaging than losing ten "Basic" clients.
 

2. Portfolio Total (The SUM)

  • Formula: =SUM(E2:E8)
  • The Insight: This gives the business owner their Annual Revenue Projection. If no one cancels and no one joins, the business is on track to earn $7,201.20 this year.
 

Professional Form Insight

Why this data structure is superior:

  • Tier Indexing: By using numbers (1, 2, 3, 4) instead of text names for tiers, the form becomes much faster to process and less likely to break due to a typo (e.g., someone typing "Entrepise" instead of "Enterprise").
  • The "At Risk" Trigger: For a subscription business, the Activity Status is a lead-generation tool. It tells the sales team exactly which "Enterprise" or "Pro" accounts are about to cancel so they can reach out with a personal check-in before the revenue is lost.
  • Portfolio Health: If you SUM the "Final Monthly Rev" column, the business owner gets their MRR (Monthly Recurring Revenue), which is the most important metric for valuing a subscription company.

To configure an element, select it on the form.

To add a new question or element, click the Question & Element button in the vertical toolbar on the left.