| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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?. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can't get excel to calculate | Excel Worksheet Functions | |||
| Turn off calculate event | Excel Discussion (Misc queries) | |||
| any formula to auto calculate 1st-12th is 12 days pls? | Excel Discussion (Misc queries) | |||
| Calculate appears in status bar | Excel Discussion (Misc queries) | |||
| Spreadsheet Won't Calculate | Excel Discussion (Misc queries) | |||
Threaded Mode
