Description
The Excel YIELDMAT function calculates the annual yield of a security that pays interest at maturity.
The syntax of the function is :
YIELDMAT( settlement, maturity, issue, rate, pr, [basis] )
Where the arguments are as follows:
The date arguments must satisfy the following:
issue < settlement < maturity
Note also, that the settlement, maturity and issue date arguments should be supplied to the function as either:
Excel Yieldmat Function Example
In the following spreadsheet, the Excel Yieldmat function is used to calculate the annual yield for a security purchased on 01-Jan-2011, with issue date 01-Jul-2008 and maturity date 30-Jun-2012. The interest rate at date of issue is 5.5% and the security has a price of $101 per $100 face value. The US (NASD) 30/360 day count basis is used:
Yieldmat Function Errors
If you get an error from the Yieldmat function, this is likely to be one of the following:
Common Errors
No comments:
Post a Comment