Split coupon bond valuation

%3CLINGO-SUB%20id%3D%22lingo-sub-183391%22%20slang%3D%22en-US%22%3ESplit%20coupon%20bond%20valuation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183391%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20some%20help%20in%20learning%20how%20to%20calculate%20the%20present%20value%20(PV)%20of%20a%20SPLIT-COUPON%20bond%20that%20has%20different%20payments%20over%20the%20life%20of%20the%20bond%2C%20say%20ten%20years.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-183391%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1826211%22%20slang%3D%22en-US%22%3ERe%3A%20Split%20coupon%20bond%20valuation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1826211%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F138446%22%20target%3D%22_blank%22%3E%40Sanford%20Kaplan%3C%2FA%3E%2C%20it%20appears%20not%20to%20be%20possible%20with%20the%20current%20Excel%20formula.%20I%20would%20recommend%20splitting%20each%20section%20into%20its%20own%20bond%2C%20calculating%20each%20piece%20respectively%2C%20and%20then%20adding%20them%20together.%20Apologies%2C%20as%20this%20is%20not%20my%20forte.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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. 

1 Reply

@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.