Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: YIELDMAT function

YIELDMAT function: Description, Usage, Syntax, Examples and Explanation

What is YIELDMAT function in Excel? YIELDMAT function is one of the Financial functions in Microsoft Excel that returns the annual yield of a security that pays interest at maturity. Syntax of YIELDMAT function YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) The YIELDMAT function syntax has the following arguments: Settlement: The security’s settlement date. The security settlement date is the date after the…