Saturday, 6 May 2017

Excel - Microsoft Excel Yielddisc Function

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