Step 1
The values change from row to row. The shares do not.
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Last year (PY) | $27.1K | $77.3K | $157.9K | $230.2K | $298.3K | $356.2K | $387.4K | $435.3K | $472.0K | $521.0K | $557.8K | $638.8K | $4,159.3K |
| This year (IY) | $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% |
| Plan, same shares | $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, spread evenly | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $345.0K | $4,139.7K |
| Share of the year | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 8.3% | 100% |
Share = the month ÷ the year. Same shares = the share × next year’s target, which is this year × 1.10. Spread evenly = the target ÷ 12.
This year’s closed months November and December, forecast from how PY finished The two share rows match, month for month
Sample data: an invented payments portfolio, no client data.