=PRICE(Settlement Date,Maturity Date,Coupon,YTM,100,4,4)
This is standard excel price function
I know price and all inputs BUT coupon
need to find a way to calculate the coupon based on all other inputs
assume there must be a way to do it - excel does not seem to have a function
for that

"Gary''s Student" wrote:

Post your PRICE formula and we will help with the algebra to invert it.
--
Gary''s Student - gsnu200810


"ingmar" wrote:

OK - but is there a way to use a function to avoid the goal seek?

"Sheeloo" wrote:

Use Tools|Goal Seek

For details on HOW TO visit http://www.homeandlearn.co.uk/ME/mes8p4.html

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