Calculate Dynamic Monthly Growth $'s based on Annual Goal

[tomdjoneshnston]

Looking for a formula or formulas that will help me figure out how much more each month that I need to sell to make up for the previous months down (or up) sales based on a stated 20% annual growth goal.

I want the rolling future sales goal to adapt to the previous monthly sales that I input as the year progresses. I.E. I know the size of the pie I want, and I know that I have 12 slices and as I go through the year some of those slices are small and some are large, but what I don't know is how big the future slices need to be to complete the full pie.

Hopefully this makes sense. This is my first post on the forum!

[tomdjoneshnston]

Adding a screencap of my worksheet for reference

Capture.PNG

[JeteMc]

If I understand the query correctly this formula will produce the amount of sales needed for each of the subsequent months in order to reach the annual sales goal:

Please Login or Register  to view this content.

I mocked up a sample file using simple numbers to demonstrate how the formula is applied. If this solution doesn't match expectations, please either manually alter the file or provide a sample of the file* from which the screenshot was made with the expected outcome manually included.

*To attach a sample workbook: Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Let me know if you have any questions.