Aug 03 2020 01:22 AM
Assumptions:
Based on the above assumptions:
Question:
Aug 03 2020 04:17 AM
Perhaps that's http://westclintech.com/Blog/tabid/132/EntryId/74/Calculate-the-PRICE-of-a-bond-with-a-monthly-coupo... the reason. Jul31 and Sep30 are within one quarter, if take Jun30 result is more reliable
Aug 03 2020 08:09 AM
Thank you for the reply.
It makes sense. On YIELD function - Office Support, the following remarks are posted:
I've just calculated the above equation with the following numbers:
The YIELD function must return 0.0100000000000147891680, which is almost 1%.
I've also checked the calculation using Wolfram Alpha.
It seems that the YIELD function does not calculate as defined and the function is not reliable.