Hi,

I am trying to calculate the Yield on Step up bonds. For example, the bond may have a 0% coupon for 4 years then 6% coupon for years 5-9 and 9% from 10 through to maturity. Does anyone know of a function or of a way to calculate the yield on such a bond using VBA??


The yield function only allows for one coupon rate to be assigned. Im thinking I may have to calculate the yields separately for each coupon rate given the time that rate is outstanding, but even then im still unsure as to make all the separate yields into one afterward.

Any help is greatly appreciated,

thanks,
Tim