Aside
Each tab is one of the plans, filled into the months the same way.
Plan 1: 10% more revenue, nothing else changed. Budget against this year: +10%.
| 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 |
| Net new revenue | $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 |
| Share of the year | 0.6% | 1.6% | 3.1% | 4.8% | 6.6% | 8.1% | 9.7% | 11.2% | 11.9% | 13.5% | 13.4% | 15.4% | 100% |
Plan 2: 10% more revenue, CVR 10% better. Budget against this year: flat.
| 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 |
| Net new revenue | $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 |
| Share of the year | 0.6% | 1.6% | 3.1% | 4.8% | 6.6% | 8.1% | 9.7% | 11.2% | 11.9% | 13.5% | 13.4% | 15.4% | 100% |
Plan 3: 10% more revenue, cost per lead 10% lower. Budget against this year: −1%.
| 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 |
| Net new revenue | $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 |
| Share of the year | 0.6% | 1.6% | 3.1% | 4.8% | 6.6% | 8.1% | 9.7% | 11.2% | 11.9% | 13.5% | 13.4% | 15.4% | 100% |
Plan 4: the same revenue, cost per lead 10% lower. Budget against this year: −10%.
| 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 |
| Net new revenue | $21.8K | $60.4K | $117.7K | $181.2K | $249.2K | $306.7K | $364.4K | $423.2K | $448.1K | $507.9K | $504.7K | $578.0K | $3,763.4K |
| Share of the year | 0.6% | 1.6% | 3.1% | 4.8% | 6.6% | 8.1% | 9.7% | 11.2% | 11.9% | 13.5% | 13.4% | 15.4% | 100% |
Net new revenue follows this year’s shares. New accounts follow last year’s months, the last full year of approvals. Leads = accounts ÷ CVR. Investment = leads × cost per lead.
The input that plan changes The budget it asks for The same shares on every tab
Sample data: an invented payments portfolio, no client data.