How To Use Duration Financial Function In Excel
What is the Excel Duration formula and syntax? The formula for the Duration function is DURATION(Settlement, maturity, coupon, yld, frequency, [basis]) The Syntax for the Duration function is below: Settlement: The security’s settlement date. It is required.Maturity: The security’s maturity date. It is required.Coupon: the security’s coupon date is required.Yld: The security’s annual yield. It is requiredFrequency: The number of coupon payments per year. It is required.Basis: The type of day count basis to use....