Measures for ELYIELDSOLVING
The keys in the next table presents the possible types of risk figures that can be drawn from the ELYIELDSOLVING function.
Note: the letter case has no influence on the functions.
Key | Description |
---|---|
ytc | yield-to-call is the total return on an instrument if it is held until the call date (before maturity) |
ytp | yield-to-put is the total return on an instrument if it is held until the put date (before maturity) |
ytm | yield-to-maturity is the total return on a bond if it is held until maturity |
current-yield | represents the return on a bond if one purchases it and holds it for a year |