Formula for calculating monthly annualized data

[bobwalex]

Help Please!

I am such a newbie here.. Its my first time post.
I want to calculate for annualized monthly data across 12 months on excel.

Column A (Monnths), B(monthly values to be annualized) and C should be annualized returns. I need an excel formula that will calculate this ... Thank you..

 

[Michael M]

Have a look at this thread

https://www.mrexcel.com/forum/excel...nvestment-returns-monthly-return-numbers.html

 

[bobwalex]

Thanks Micheal.. Will check it through