yield on bond priced over 100

J

John

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

Fred Smith

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

John

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