Aside
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 1: 10% more revenue, nothing else changed. This plan changes no rate, so there is nothing to schedule and both settings give the same months. The year: $4,139.7K, +10.0% on this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Investment | $138.8K | $163.1K | $169.2K | $149.9K | $147.1K | $140.5K | $156.5K | $152.1K | $142.1K | $143.2K | $141.0K | $153.7K | $1,797.4K |
| Cost per lead | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 |
| Leads | 6,941 | 8,157 | 8,462 | 7,494 | 7,356 | 7,024 | 7,826 | 7,604 | 7,107 | 7,162 | 7,051 | 7,687 | 89,870 |
| CVR | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% |
| New accounts | 278 | 326 | 338 | 300 | 294 | 281 | 313 | 304 | 284 | 286 | 282 | 307 | 3,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 |
Plan 1: 10% more revenue, nothing else changed. This plan changes no rate, so there is nothing to schedule and both settings give the same months. The year: $4,139.7K, +10.0% on this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Investment | $138.8K | $163.1K | $169.2K | $149.9K | $147.1K | $140.5K | $156.5K | $152.1K | $142.1K | $143.2K | $141.0K | $153.7K | $1,797.4K |
| Cost per lead | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | $20 |
| Leads | 6,941 | 8,157 | 8,462 | 7,494 | 7,356 | 7,024 | 7,826 | 7,604 | 7,107 | 7,162 | 7,051 | 7,687 | 89,870 |
| CVR | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% |
| New accounts | 278 | 326 | 338 | 300 | 294 | 281 | 313 | 304 | 284 | 286 | 282 | 307 | 3,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 |
Plan 2, evenly: every month converts at 4.4%. The year: $4,139.7K, +10.0% on this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| Leads | 6,310 | 7,416 | 7,692 | 6,813 | 6,687 | 6,385 | 7,114 | 6,913 | 6,461 | 6,511 | 6,410 | 6,988 | 81,700 |
| CVR | 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.4% |
| New accounts | 278 | 326 | 338 | 300 | 294 | 281 | 313 | 304 | 284 | 286 | 282 | 307 | 3,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 |
Plan 2, weighted: CVR starts 10% under 4.4% in January and ends 10% over it in December. Almost the same count, 3,591 accounts against 3,595. The year: $3,985.5K, +5.9% on this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| Leads | 6,310 | 7,416 | 7,692 | 6,813 | 6,687 | 6,385 | 7,114 | 6,913 | 6,461 | 6,511 | 6,410 | 6,988 | 81,700 |
| CVR | 3.96 | 4.04 | 4.12 | 4.20 | 4.28 | 4.36 | 4.44 | 4.52 | 4.60 | 4.68 | 4.76 | 4.84 | 4.40 avg |
| New accounts | 250 | 300 | 317 | 286 | 286 | 278 | 316 | 312 | 297 | 305 | 305 | 338 | 3,591 |
| 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 | $547.7K | $619.3K | $557.8K | $499.6K | $386.8K | $304.9K | $315.0K | $298.4K | $213.0K | $113.3K | $94.6K | $35.0K | $3,985.5K |
Plan 3, evenly: every lead costs $18 from January. The year’s budget: $1,617.7K, $817.8K of it in the first half. The year: $4,139.7K, +10.0% on this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Investment | $124.9K | $146.8K | $152.3K | $134.9K | $132.4K | $126.4K | $140.9K | $136.9K | $127.9K | $128.9K | $126.9K | $138.4K | $1,617.7K |
| Cost per lead | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 |
| Leads | 6,941 | 8,157 | 8,462 | 7,494 | 7,356 | 7,024 | 7,826 | 7,604 | 7,107 | 7,162 | 7,051 | 7,687 | 89,870 |
| CVR | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% |
| New accounts | 278 | 326 | 338 | 300 | 294 | 281 | 313 | 304 | 284 | 286 | 282 | 307 | 3,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 |
Plan 3, weighted: cost per lead starts 10% over $18 in January and ends 10% under it in December. The same leads and the same accounts. The year’s budget: $1,619.5K, $862.9K of it in the first half. The year: $4,139.7K, +10.0% on this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Investment | $137.4K | $158.8K | $162.0K | $141.0K | $136.0K | $127.6K | $139.6K | $133.1K | $122.1K | $120.7K | $116.5K | $124.5K | $1,619.5K |
| Cost per lead | $19.80 | $19.47 | $19.15 | $18.82 | $18.49 | $18.16 | $17.84 | $17.51 | $17.18 | $16.85 | $16.53 | $16.20 | $18.02 avg |
| Leads | 6,941 | 8,157 | 8,462 | 7,494 | 7,356 | 7,024 | 7,826 | 7,604 | 7,107 | 7,162 | 7,051 | 7,687 | 89,870 |
| CVR | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% |
| New accounts | 278 | 326 | 338 | 300 | 294 | 281 | 313 | 304 | 284 | 286 | 282 | 307 | 3,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 |
Plan 4, evenly: every lead costs $18 from January. The year’s budget: $1,470.6K, $743.4K of it in the first half. The year: $3,763.4K, level with this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Investment | $113.6K | $133.5K | $138.5K | $122.6K | $120.4K | $114.9K | $128.1K | $124.4K | $116.3K | $117.2K | $115.4K | $125.8K | $1,470.6K |
| Cost per lead | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 | $18 |
| Leads | 6,310 | 7,416 | 7,692 | 6,813 | 6,687 | 6,385 | 7,114 | 6,913 | 6,461 | 6,511 | 6,410 | 6,988 | 81,700 |
| CVR | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% |
| New accounts | 252 | 297 | 308 | 273 | 267 | 255 | 285 | 277 | 258 | 260 | 256 | 280 | 3,268 |
| 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 | $553.2K | $613.2K | $541.6K | $475.8K | $361.5K | $279.7K | $283.8K | $264.1K | $185.2K | $96.8K | $79.5K | $28.9K | $3,763.4K |
Plan 4, weighted: cost per lead starts 10% over $18 in January and ends 10% under it in December. The same leads and the same accounts. The year’s budget: $1,472.3K, $784.4K of it in the first half. The year: $3,763.4K, level with this year.
| Approval month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Investment | $124.9K | $144.4K | $147.3K | $128.2K | $123.6K | $116.0K | $126.9K | $121.0K | $111.0K | $109.7K | $105.9K | $113.2K | $1,472.3K |
| Cost per lead | $19.80 | $19.47 | $19.15 | $18.82 | $18.49 | $18.16 | $17.84 | $17.51 | $17.18 | $16.85 | $16.53 | $16.20 | $18.02 avg |
| Leads | 6,310 | 7,416 | 7,692 | 6,813 | 6,687 | 6,385 | 7,114 | 6,913 | 6,461 | 6,511 | 6,410 | 6,988 | 81,700 |
| CVR | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% | 4.0% |
| New accounts | 252 | 297 | 308 | 273 | 267 | 255 | 285 | 277 | 258 | 260 | 256 | 280 | 3,268 |
| 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 | $553.2K | $613.2K | $541.6K | $475.8K | $361.5K | $279.7K | $283.8K | $264.1K | $185.2K | $96.8K | $79.5K | $28.9K | $3,763.4K |
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.