Calculator Inputs
Example Data Table
| Sample Scenario | Active Clients | Avg Retainer | New Clients | Acquisition Growth | Churn | Upsell Growth | Collection Rate | Add-On Revenue | Months |
|---|---|---|---|---|---|---|---|---|---|
| Freelance design retainers | 8 | $850.00 | 2 | 5% | 6% | 2% | 97% | $150.00 | 12 |
| Marketing consulting retainers | 12 | $1,250.00 | 1.5 | 3% | 4% | 1.5% | 95% | $300.00 | 18 |
| Developer maintenance plans | 20 | $420.00 | 3 | 4% | 7% | 1% | 98% | $500.00 | 12 |
Formula Used
1) New Clients in Month m
New Clients = Month 1 New Clients × (1 + Acquisition Growth Rate)(m - 1)
2) Churned Clients
Churned Clients = Opening Clients × Monthly Churn Rate
3) Ending Clients
Ending Clients = Opening Clients - Churned Clients + New Clients
4) Average Retainer in Month m
Average Retainer = Starting Retainer × (1 + Upsell Growth Rate)(m - 1)
5) Billed Recurring Revenue
Billed Revenue = [(Opening Clients - Churned Clients) + (New Clients × 0.5)] × Average Retainer + Add-On Revenue
6) Collected Recurring Revenue
Collected Revenue = Billed Revenue × Collection Rate
7) Ending MRR and ARR Run Rate
Ending Billed MRR = Ending Clients × Average Retainer + Add-On Revenue
Ending Collected MRR = Ending Billed MRR × Collection Rate
ARR Run Rate = Ending Billed MRR × 12
This model is practical for freelancers with retainers, monthly support plans, care packages, coaching subscriptions, or ongoing advisory agreements.
How to Use This Calculator
- Enter your current number of active recurring clients.
- Add your average monthly retainer value per client.
- Estimate how many new clients you expect in month one.
- Set acquisition growth if your monthly sales pipeline is improving.
- Enter expected churn to reflect cancellations or paused retainers.
- Use upsell growth for price increases, scope expansion, or retainers that deepen over time.
- Set collection rate to reflect invoice realization after delays, disputes, or unpaid balances.
- Add any fixed recurring add-on income, then choose the forecast period.
- Optionally enter a target collected MRR value.
- Press submit to view the forecast summary, chart, and downloadable monthly table.
Frequently Asked Questions
1) What does this calculator forecast?
It forecasts recurring freelance income over future months. It models active clients, churn, new client additions, upsell growth, collections, ending MRR, and annualized run rate.
2) Why does the model use half of new clients for billed revenue?
It assumes new clients start throughout the month rather than all on day one. Using half-month billability gives a practical mid-period estimate for billed revenue.
3) What is collection rate?
Collection rate is the share of billed invoices you actually receive. It helps you forecast cash-like recurring income instead of relying only on invoiced amounts.
4) Can I use this for maintenance plans or coaching subscriptions?
Yes. Any freelance model with repeated monthly billing fits well, including retainers, care plans, support contracts, coaching memberships, and ongoing consulting packages.
5) What does upsell growth represent?
It represents improvement in average retainer value over time. That may come from price increases, added deliverables, premium service tiers, or stronger account expansion.
6) What is the difference between billed MRR and collected MRR?
Billed MRR is the recurring revenue you invoice. Collected MRR adjusts that amount using your collection rate, giving a more conservative planning number.
7) How should I estimate churn?
Use your historical cancellation or pause pattern. Divide the average clients lost per month by opening active clients, then convert that value to a percentage.
8) Why is ARR run rate included?
ARR run rate annualizes the ending billed MRR. It helps you compare recurring freelance revenue against yearly goals, proposals, hiring plans, or business valuation benchmarks.