View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John
 
Posts: n/a
Default yield on bond priced over 100

Fred, appreciate the response, I got it figured out... had to do with the
number of compounding periods.

"Fred Smith" wrote:

The Yield function works for me with prices over par. Post an example of your
problem so we can help you track it down.

--
Regards,
Fred


"John" wrote in message
...
Why does excel seem to only calculate yield using prices under $100. What if
a security is priced above par? Am I missing something?