With SIGNIFICANT HELP from Gary's Student, here is your formula. Format the
cell for percentage. This will give you the interest rate if you (not yield),
if you have all the other pertinent data.
A1=Settlement Date
A2=Maturity Date
A4=Percent Yield
A5=Redemption Value
A6=Frequency
A7=Basis
Your formula for is as follows:
=(A$8-PRICE(A$1,A$2,0%,A$4,A$5,A$6,A$7))/(PRICE(A$1,A$2,2%,A$4,A$5,A$6,A$7)-PRICE(A$1,A$2,1%,A$4,A$5,A$6,A$7))/100

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"ingmar" wrote:

Wondering if there is a way to calculate coupon rate of a bond based on YTM,
maturity, settlement date, and bond's price
essentially I am trying to back solve for the coupon rate based on all
inputs of the PRICE formula (i.e. all are known except RATE in the PRICE
formula)