Step 4

Next year: accounts × the curve × the time of year

Net new revenue. The same 3,595 accounts as Straight Line, placed by approval month.

ApprovedAccountsJanFebMarAprMayJunJulAugSepOctNovDecYear
Jan278$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
Feb326$31.7K$60.7K$70.8K$72.5K$70.8K$67.7K$61.8K$54.1K$55.5K$55.9K$64.6K$666.1K
Mar338$36.5K$63.9K$76.1K$76.4K$72.6K$70.2K$61.3K$58.0K$57.2K$61.4K$633.5K
Apr300$32.8K$58.6K$68.4K$66.9K$64.2K$59.5K$56.2K$51.0K$53.7K$511.2K
May294$33.3K$58.4K$66.3K$65.6K$60.4K$60.4K$54.7K$53.0K$452.2K
Jun281$32.3K$55.1K$63.3K$60.0K$59.6K$57.3K$55.4K$382.9K
Jul313$35.6K$61.4K$67.5K$69.1K$65.9K$67.6K$367.1K
Aug304$34.6K$57.1K$67.8K$66.6K$67.9K$294.0K
Sep284$30.9K$55.2K$63.0K$66.0K$215.0K
Oct286$32.2K$55.2K$67.2K$154.6K
Nov282$31.5K$57.6K$89.1K
Dec307$36.4K$36.4K
Cohort build3,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 shares3,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.