View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Azzurra Azzurra is offline
external usenet poster
 
Posts: 1
Default calculate implied ytm

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