Saturday 6 May 2017

Excel - Microsoft Excel Yieldmat Function

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