Hi,

I have 100 bonds in a portfolio and I have their maturity dates, next coupon date and the frequency of the coupons.

I need to create a formula (or VBA?) that can be applied to different bonds so it maps the coupons from the next one up until maturity.

So far I have been using EDATE(Previous Coupon Date, 12/Frequency) but this is proving quite manual as I have to do it one by one.

I have attached an example of 2 bonds I am looking at.Coupon Schedule.xlsx

Thanks