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. $\displaystyle 26$ 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.