Dont know Excel Function

[Guest]

Dear All,

I have a table as follows:

Jul-04 1.0000
Aug-04 1.0025
Sep-04 1.0038
Oct-04 1.0046
Nov-04 1.0048
Dec-04 1.0110
Jan-05 1.0182
Feb-05 1.0261
Mar-05 1.0298
Apr-05 1.0336
May-05 1.0369
Jun-05 1.0403
Jul-05 1.0424
Aug-05 1.0450
Sep-05 1.0466
Oct-05 1.0480
Nov-05 1.0490
Dec-05 1.0525
Jan-06 1.0567
Feb-06 1.0621
Mar-06 1.0666
Apr-06 1.0699
May-06 1.0726
Jun-06 1.0747
Jul-06 1.0771
Aug-06 1.0814
Sep-06 1.0845
Oct-06 1.0861
Nov-06 1.0858

Jul-04 as Base Month.

What function to calculate that monthly escallation based on 3 or 3.5%
yearly (I am not which one of the rate)?

Thank you for your help.

Brgds,andri

 

[bplumhoff]

Hello,

An example for 3% p.a.:

monthly rate =RATE(12,0,-1,1+3%)

which is equal to

=(1+3%)^(1/12)-1

HTH,
Bernd