Name the financial function which returns accrued interest on a bond with $\displaystyle 5$% coupon rate and where issue and settlement date of investment is also given. Also explain its syntax.

The name of the financial function is ACCRINT. Its syntax is ACCRINT (issue, first_interest, settlement, rate, par, frequency, basis calc_method). Where Issue : is the security’s issue date. First_interest : is the security’s first interest date. Settlement : is the security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. Rate : is the security’s annual coupon rate. Par : is the security’s par value. By default par is 1000. Frequency : is the number of coupon payments per year for annual payments. Basis : is the type of day count basis to use.