ACCRINTfunction calculates the accrued interest of a security that pays periodic interest. It is commonly used in financial analysis to determine the amount of interest earned but not yet paid on a security. The function takes into account the issue date, first payment date, settlement date, rate, redemption value, and frequency of interest payments. The result is the accrued interest at the settlement date.
- How to use
- Examples of using
ACCRINTformula not working?
- Similar formulas to
ACCRINT formula with the syntax shown below, it has 6 required parameters and 1 optional parameter:
- issue (required):
The date the security was issued, in the format of a date, datetime or serial number.
- first_payment (required):
The date of the first interest payment, in the format of a date, datetime or serial number.
- settlement (required):
The date of the security's settlement, in the format of a date, datetime or serial number.
- rate (required):
The interest rate of the security.
- redemption (required):
The redemption value of the security.
- frequency (required):
The number of interest payments per year.
- day_count_convention (optional):
An optional parameter that specifies the day count convention to use. If omitted, the US (NASD) 30/360 day count convention is used by default.
ExamplesHere are a few example use cases that explain how to use the
ACCRINTformula in Google Sheets.
Calculating accrued interest
One of the most common uses of
ACCRINT is to calculate accrued interest on a bond or other security. By providing the issue date, first payment date, settlement date, interest rate, redemption value, and frequency of interest payments, the function can accurately calculate the amount of interest earned but not yet paid on the security.
Investors and financial analysts may use
ACCRINT to compare the accrued interest of different securities. By calculating the accrued interest for several securities using the same inputs, analysts can determine which securities are earning the most interest over a given period.
Forecasting interest income
Investors may use
ACCRINT to forecast their future interest income. By specifying a future settlement date and using expected interest rates and redemption values, investors can use the function to estimate how much interest they will earn on a security over a given period.
ACCRINTnot working? Here are some common mistakes people make when using the
ACCRINTGoogle Sheets Formula:
Incorrect input order
One of the most common mistakes when using ACCRINT is inputting the arguments in the wrong order which can cause the formula to return incorrect results. Make sure to follow the correct order of the arguments listed in the syntax.
Incorrect date format
ACCRINT requires that dates be entered in a specific format. Make sure to enter the dates using the DATE function, and ensure that the dates are not formatted as text.
The rate argument in ACCRINT should be entered as a decimal, not a percentage. For example, if the annual rate is 5%, the rate argument should be entered as 0.05.
Wrong day count convention
If you are using a day count convention that is different from the default value, make sure to specify it in the formula. The default value is 0, which means that the actual number of days between the dates will be used.
The frequency argument in ACCRINT should be entered as a number that corresponds to the number of coupon payments per year. For example, if there are semi-annual coupon payments, the frequency argument should be 2.
The following functions are similar to
ACCRINT or are often used with it in a formula:
ACCRINTMfunction calculates the accrued interest for a security that pays interest at maturity. It returns the accrued interest between the issue date and the maturity date of a security. This function is most commonly used in financial analysis for bonds and other debt securities.
COUPDAYBSfunction calculates the number of days from the beginning of the coupon period to the settlement date for a security that pays periodic interest. It is commonly used in financial calculations to determine the accrued interest between the last coupon payment and the settlement date.
COUPDAYSfunction returns the number of days in the coupon period that contains the settlement date. This function is commonly used in financial analysis to calculate the number of days between two dates for interest rate calculations.
COUPDAYSNCfunction calculates the number of days from the settlement date to the next coupon date, based on a specified frequency and day count convention. This function is commonly used in financial analysis to calculate the accrued interest on a bond between the settlement date and the next coupon date.
COUPNCDfunction calculates the next coupon date after the settlement date for a security with periodic interest payments. It is commonly used in finance to determine the next coupon payment date for bonds and other fixed income securities.
You can learn more about the
ACCRINT Google Sheets function on Google Support.