"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.