Description
The Excel YIELDDISC function calculates the annual yield of a discounted security.
The syntax of the function is :
YIELDDISC( settlement, maturity, pr, redemption, [basis] )
Where the arguments are as follows:
Excel Yielddisc Function Example
In the following spreadsheet, the Excel Yielddisc function is used to calculate the annual yield for a discounted security that has the settlement date 01-Jan-2011 and the maturity date 30-Jun-2011. The price per $100 face value is $97 and the redemption value is $100. The US (NASD) 30/360 day count basis is used:
Yielddisc Function Errors
If you get an error from the Yielddisc function, this is likely to be one of the following:
Common Errors
No comments:
Post a Comment