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