SheetFX
≡
<< Go back to all functions

ACCRINT

The ACCRINT function in Google Sheets is used to calculate the accrued interest of a security that has periodic payments. This function is especially useful for financial analysis and investment tracking. Dive into our comprehensive guide to learn how to use the ACCRINT function effectively.

Function Syntax and Parameters

Syntax: ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention])

Parameters:

  • issue: The date when the security is issued.
  • first_payment: The date of the security's first payment.
  • settlement: The settlement date of the security.
  • rate: The annual interest rate of the security.
  • redemption: The redemption value or face value of the security.
  • frequency: The number of coupon payments per year.
  • day_count_convention: [Optional] The day count convention used in the calculation.

Step-by-Step Tutorial

  1. Calculating accrued interest using ACCRINT:
    • Example: =ACCRINT("1/1/2022", "3/1/2022", "4/15/2022", 0.06, 1000, 2, 0)
    • Result: Accrued interest value

Use Cases and Scenarios

  1. Bond Analysis: Calculate the accrued interest of a bond between certain dates.
  2. Investment Tracking: Track the interest earned on a fixed deposit or other fixed-income securities.
  3. Financial Reporting: Determine the interest expense for accounting purposes.

Related Functions

  • ACCRINTM: Calculates the accrued interest of a security that pays interest at maturity.
  • DAYS360: Calculates the number of days between two dates using the 360-day year method.

Related Articles