In what type of financial situation is the ACCRINT function most useful?
Answer & explanation
Correct answer: option 3
The correct answer is option 3- Calculating interest on periodic-pay securities.
ACCRINT function returns the accrued interest for a security that pays periodic interest. The syntax of this is as follows: ACCRINT (issue, first_interest, settlement, rate, par, frequency, basis, calc_method).