seasonality & growth question

[choubix]

Hi guys,

I am scratching my head with a "basic" math problem (I think I need to use the log here)

Say that a business ended the year with $100 in sales in FY20 and that I am anticipating 10% growth in FY21.
Now, I know that -on average- January accounts for 7% of sales, February for 10% etc...

What formula shall I use to account for the seasonality of the business and still end with $110 in sales at the end of FY21?

Thanks!

 

[Dermot]

Assuming the percentages add up to 100% for the whole year, simply multiply the % for each month by the forecast total for 2021

So in your example, if January is 7%, then January's figure is 7% x $110