PRICE function

G

Guest

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
Yield Function with Monthly Frequency 2
Reverse PRICE function 32
How to calculate a bond price using Excel?? 1
Bond premium amortization using the constant yield method 1
annuity calculation for monthly payments but quarterly compoundin 5
Excel finance function 1
Mortgage with Quarterly Capitalisation & Monthly Payments 7

Top