Calculation guide
Each row is a distinct cohort due for renewal during one reporting period. Enter its tax-exclusive price, renewal probability and effective platform fee. Expected renewals may be fractional. Do not count new sales.
Σ eligible × renewal/100 × price × (1 − fee/100)
Inputs
Subscriptions due
Example entry 100. Use whole numbers.
Renewal probability
Example entry 80 %. Allowed range 0 to 100.
Price per renewal before sales tax
Example entry 10 (in the selected currency).
Platform fee rate
Example entry 15 %. Allowed range 0 to 100.
Worked example
Renewal cohorts
| Subscriptions due | Renewal probability | Price per renewal before sales tax | Platform fee rate |
|---|---|---|---|
| 100 | 80% | 10 | 15% |
| 100 | 80% | 20 | 10% |
| Result | Value |
|---|---|
| Net renewal proceeds | 2,120 |
| Expected renewed subscriptions | 160 |
| Gross renewal billings | 2,400 |
| Platform fees | 280 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Subscriptions due (row 1) | 100 | 110 | Net renewal proceeds | 2,120 | 2,188 |
| Renewal probability (row 1) | 80% | 88% | Net renewal proceeds | 2,120 | 2,188 |
| Price per renewal before sales tax (row 1) | 10 | 11 | Net renewal proceeds | 2,120 | 2,188 |
| Platform fee rate (row 1) | 15% | 17% | Net renewal proceeds | 2,120 | 2,104 |
