Aside

The four plans again, with the improvement added evenly or weighted

The same build-outs, by the month the accounts are approved. The switch under the grid sets how the rate a plan changes arrives.

Plan 2, evenly: every month converts at 4.4%. The year: $4,139.7K, +10.0% on this year.

Approval monthJanFebMarAprMayJunJulAugSepOctNovDecYear
Investment$126.2K$148.3K$153.8K$136.3K$133.7K$127.7K$142.3K$138.3K$129.2K$130.2K$128.2K$139.8K$1,634.0K
Cost per lead$20$20$20$20$20$20$20$20$20$20$20$20$20
Leads6,3107,4167,6926,8136,6876,3857,1146,9136,4616,5116,4106,98881,700
CVR4.4%4.4%4.4%4.4%4.4%4.4%4.4%4.4%4.4%4.4%4.4%4.4%4.4%
New accounts2783263383002942813133042842862823073,595
PY revenue per account$2,436$2,297$1,956$1,941$1,502$1,217$1,108$1,061$797$413$345$115$1,280 avg
Net new revenue$608.6K$674.5K$595.7K$523.4K$397.6K$307.7K$312.2K$290.5K$203.8K$106.5K$87.5K$31.8K$4,139.7K
How the improvement is applied

Columns are approval months. PY revenue per account is what an account approved that month billed inside PY.

Leads are the same either way. Investment = leads × cost per lead. New accounts = leads × CVR. Net new revenue = new accounts × PY revenue per account × (1,152 ÷ 1,280), which sets the average account to this year’s.

The input that plan changes   The year   From last year’s book

Sample data: an invented payments portfolio, no client data.