Hello! I am desperate for help here. I am semi-proficient with VBA, but I can barely read the math formula I have attached below. The formula is called the Bootstrapping Method. If you have a known series of par yields on a standard bond, you should be able to use this formula to calculate what the equivalent zero coupon bond yield would be.
r = the zero coupon yield at a given point n, in its maturity
y = the provided par yield at the same given point in maturity
How would I code this formula into VBA? Any help would be appreciated!
Edit: One thing I forgot to add. I would like my columns headings in my spreadsheet to be "Period"( 1 through n), the second column being "Par Yield" (this would be inputed by user), and the third column to be "Zero Coupon Yield" (the values in this column would be the output of the macro).
THANK YOU SO FREAKING MUCH IN ADVANCE!
Last edited by gtg689a; Jul 20th, 2007 at 03:39 PM.
Reply With Quote