Step 4
Net new revenue. The same 3,595 accounts as Straight Line, placed by approval month.
| Approved | Accounts | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Jan | 278 | $27.7K | $46.5K | $59.3K | $59.6K | $59.3K | $58.3K | $52.6K | $48.1K | $45.7K | $47.9K | $51.9K | $57.9K | $614.8K |
| Feb | 326 | $31.7K | $60.7K | $70.8K | $72.5K | $70.8K | $67.7K | $61.8K | $54.1K | $55.5K | $55.9K | $64.6K | $666.1K | |
| Mar | 338 | $36.5K | $63.9K | $76.1K | $76.4K | $72.6K | $70.2K | $61.3K | $58.0K | $57.2K | $61.4K | $633.5K | ||
| Apr | 300 | $32.8K | $58.6K | $68.4K | $66.9K | $64.2K | $59.5K | $56.2K | $51.0K | $53.7K | $511.2K | |||
| May | 294 | $33.3K | $58.4K | $66.3K | $65.6K | $60.4K | $60.4K | $54.7K | $53.0K | $452.2K | ||||
| Jun | 281 | $32.3K | $55.1K | $63.3K | $60.0K | $59.6K | $57.3K | $55.4K | $382.9K | |||||
| Jul | 313 | $35.6K | $61.4K | $67.5K | $69.1K | $65.9K | $67.6K | $367.1K | ||||||
| Aug | 304 | $34.6K | $57.1K | $67.8K | $66.6K | $67.9K | $294.0K | |||||||
| Sep | 284 | $30.9K | $55.2K | $63.0K | $66.0K | $215.0K | ||||||||
| Oct | 286 | $32.2K | $55.2K | $67.2K | $154.6K | |||||||||
| Nov | 282 | $31.5K | $57.6K | $89.1K | ||||||||||
| Dec | 307 | $36.4K | $36.4K | |||||||||||
| Cohort build | 3,595 | $27.7K | $78.2K | $156.4K | $226.9K | $299.9K | $364.6K | $416.8K | $469.0K | $496.6K | $561.9K | $610.2K | $708.6K | $4,417.0K |
| Straight Line, this year’s shares | 3,595 | $24.0K | $66.4K | $129.5K | $199.3K | $274.1K | $337.4K | $400.9K | $465.5K | $492.9K | $558.7K | $555.2K | $635.8K | $4,139.7K |
Each cell = that row’s accounts × the curve at that month on the book × the time-of-year factor for that calendar month.
On this curve a new account is worth $1,229 inside the year, and the $4.14M target takes 3,369 accounts.
Sample data: an invented payments portfolio, no client data.