Step 1

The year’s number, filled into twelve months

The values change from row to row. The shares do not.

JanFebMarAprMayJunJulAugSepOctNovDecYear
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 year0.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 year0.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 year8.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.