Month 1 is treated as the first paid month (trial month ignored; trial dropoff baked in). Members are rounded each month.
Rep commission % is determined by follower-count tiers.
Rep commission based on follower tier:
Tier: —Rep %: —
Inputs
Enter as a percent (e.g., 0.5 for 0.5%).
Tier: —
Rep rate: —
Upload this single file to Netlify (drag & drop) and connect rep.growcalico.com.
Trial signups
—
—
Paid members (M1)
—
—
MRR per affiliate (M1)
—
—
Rep commission per affiliate (M1)
—
—
Rep Stacking Projection
Correct cohort stacking (each month adds a new cohort)
Month
Active Affiliates
Total Members
Total MRR
Rep Commission
This should grow fast, then slow, then plateau (unless churn is very high or onboarding is very low).
Single Affiliate Projection (rep only)
Month
Paid Members
MRR
Rep Commission
Members are rounded each month after attrition (matches your Google Sheet).