Calculate subscription profitability with churn analysis, LTV projections, and payback periods
0/50 characters
Total: 100%
| Month | Active | Total | Paid | New | Churn | Retention% | Revenue | Profit | ROI% |
|---|---|---|---|---|---|---|---|---|---|
| 1 | 29 | 600 | 30 | 15 | 1 | 95.0% | $1993 | $993 | 99.3% |
| 2 | 42 | 900 | 45 | 15 | 2 | 95.0% | $2887 | $1887 | 188.7% |
| 3 | 54 | 1,200 | 60 | 15 | 3 | 95.0% | $3712 | $2712 | 271.2% |
| 4 | 66 | 1,500 | 75 | 15 | 3 | 95.0% | $4537 | $3537 | 353.7% |
| 5 | 77 | 1,800 | 90 | 15 | 4 | 95.0% | $5293 | $4293 | 429.3% |
| 6 | 87 | 2,100 | 105 | 15 | 5 | 95.0% | $5980 | $4980 | 498.0% |
| 7 | 97 | 2,400 | 120 | 15 | 5 | 95.0% | $6668 | $5668 | 566.8% |
| 8 | 106 | 2,700 | 135 | 15 | 6 | 95.0% | $7286 | $6286 | 628.6% |
| 9 | 115 | 3,000 | 150 | 15 | 6 | 95.0% | $7905 | $6905 | 690.5% |
| 10 | 124 | 3,300 | 165 | 15 | 6 | 95.0% | $8524 | $7524 | 752.4% |
| 11 | 132 | 3,600 | 180 | 15 | 7 | 95.0% | $9074 | $8074 | 807.4% |
| 12 | 140 | 3,900 | 195 | 15 | 7 | 95.0% | $9624 | $8624 | 862.4% |
| Total | - | 3,900 | 195 | - | - | - | $73483 | $61483 | 512.4% |