HI
I need to work out the projected future profit margin based on the trend of the previous period of days in the month.
For instance
Day 1 - 25.60%
Day 2 - 24.50%
Day 3 - 26.90%
Day 4 - 23.20%
Day 5 - 21.00%
What would be the trend for the rest of the month based on the above. Please advise the best function/formule to calculate this.
Thanks
VC
Bookmarks