View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gary Brown Gary Brown is offline
external usenet poster
 
Posts: 178
Default calculate implied ytm

write more clearly and don't abreviate. YOU may know what you're talking
about but NOBODY else does
--
HTH,
Gary Brown



"Azzurra" wrote:

i'm trying to calculate the implied ytm for a bond 4,5year six month payment
given nper=9
price of a Fv1000=1277,61
coupon rate p.a 11,5%
coupon frequency semiannual
using rate function the xl worksheet come up with an error which i'm trying
to figuredit out but couldn't. +rate function ask me for a guess, but i was
wxpecting a switch.. does anyone know how to do this?.