G Guest Dec 12, 2003 #1 Is there a way to calculate the price of a bond making monthly coupon payments? The PRICE function is limited to annual, semiannual or quarterly payments. Thanks.
Is there a way to calculate the price of a bond making monthly coupon payments? The PRICE function is limited to annual, semiannual or quarterly payments. Thanks.
F Fred Smith Dec 12, 2003 #2 No. For some reason Excel does not support monthly payments on bonds. But you can get to the same place using the regular financial functions (PV in this case) -- Regards, Fred Please reply to newsgroup, not e-mail Kevin J. said: Is there a way to calculate the price of a bond making monthly coupon Click to expand... payments? The PRICE function is limited to annual, semiannual or quarterly payments. Thanks.
No. For some reason Excel does not support monthly payments on bonds. But you can get to the same place using the regular financial functions (PV in this case) -- Regards, Fred Please reply to newsgroup, not e-mail Kevin J. said: Is there a way to calculate the price of a bond making monthly coupon Click to expand... payments? The PRICE function is limited to annual, semiannual or quarterly payments. Thanks.
