Forum Discussion
Split coupon bond valuation
I need some help in learning how to calculate the present value (PV) of a SPLIT-COUPON bond that has different payments over the life of the bond, say ten years.
Sanford Kaplan, it appears not to be possible with the current Excel formula. I would recommend splitting each section into its own bond, calculating each piece respectively, and then adding them together. Apologies, as this is not my forte.