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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel PRICE function: How does it compute Issue Date of the Security 5
Bond premium amortization using the constant yield method 1
Function to establish mortgage bond size. 2
Reverse PRICE function 32
Building bonds amortization repayment plan in Access 0
Function to establish the mortgage bond based on a monthly payment 0
Current Yield vs. Yield to Maturity at low prices 1
Bond duration for monthly coupon 0

Top