Assume the beginning salary is in A1 and the ending salalry is in A2

=(A2/A1)^.2-1

will give you the compounded annual rate of increase.


"Stacey" wrote:

I am trying to create a formula in excel showing the salary for a client for
a 5 period. The beginning and end salary will be provided. The formula will
need to calculate the annual raise and % of raise that the client received
from point a (beginning salary) to point b (ending salary). I thought I
might have luck calculating a compound annual growth rate (CAGR) utilizing
the XIRR but I am having no luck. If anyone can help with this it would be
very much appreciated.