YIELDMAT(settlement,maturity,issue,rate,pr[,basis])
YIELDMAT calculates the annual yield of a security for which the interest is paid at maturity date.
settlement is the settlement date of the security. maturity is the maturity date of the security. issue is the issue date of the security. rate is the interest rate set to the security. pr is the price per $100 face value of the security. basis is the type of day counting system you want to use:
0 US 30/360
1 actual days/actual days
2 actual days/360
3 actual days/365
4 European 30/360