Apr 16 2018 02:13 PM
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.
Oct 28 2020 12:03 AM
@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.