In what type of financial situation is the ACCRINT function most useful? |
Calculating sales tax Tracking inventory Calculating interest on periodic-pay securities Summing values across columns |
Calculating interest on periodic-pay securities |
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). |