Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: DURATION function

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

What is DURATION function in Excel? DURATION function is one of the Financial functions in Microsoft Excel that returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price’s response to changes in yield. Syntax of┬áDURATION…