"joeu2004" wrote in message
...
"W" wrote:
YIELDMAT(settlement,maturity,issue,rate,pr,basis)
A follow on question is why doesn't Yield to Maturity
function let you specify whether the bond is paid quarterly,
semi-annually, annually, etc?

Read the Help page for YIELDMAT. It says: "Returns the annual yield of a
security that pays interest __at_maturity__".

For bonds that pay interest quarterly etc, use the YIELD function.

Pretty awful that they chose a name for that function that sounds similar to
"Yield to Maturity" which is a standardized financial concept.

In any case, you are right I need to use YIELD

--
W