I'm new to VBA but not to programming. I need a function or method to calculate a next payment date for a bond based off the settlement date, maturity date, frequency, and basis. These are the same arguments for the COUPNCD function, but this function does not handle monthly payments.
Could someone please help!
Is this what you are looking for?
[VBA]=COUPNCD(DATE(2008,1,25),DATE(2008,11,15),2,1)[/VBA]
will return 39583 (May 15, 2008). This is the first coupon date after the settlement date of January 25, 2008, where the maturity date is November 15, 2008, the coupon payments are semiannual and the actual number of days in the months and years are used in making the calculations.
Peace of mind is found in some of the strangest places.
No, i need to be able to handle monthly payments. i think i'll end up using an conditional saying if frequency = 12, roll the month forward 1.
Posting Permissions
Reply With Quote
