PRICE function

K

Kevin J.

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

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