Hi all and thanks for the help in advance.
I want to write a formula in excel. I tried to write it first in paper but I had some difficulties. Here the problem:
I need a formula to monthly growth % based on the annual growth and total yearly sales.
Total yearly sales is a known number. For example: Sales in January 2024 (starting point) = 5€ Total sales 2024 = 100€ Total sales 2025 = 800€
The formula I look for would take the initial sales of 5 in January multiplied by (1+ growth rate) leading to february sales. After doing it for every month of the year I would get a summatory of 100€ in 2024.
Then, taking as starting point the sales of December 2024 of 13€ and the growth rate of 2025 I would get to a total of 800€ in 2025.
I include an screenshot to illustrate. The question would be, what would be the formula to get the growth rate in red:
