PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

EXCEL FUNCTIONS-ACCRINT

ACCRINT function is given in EXCEL for financial purpose. ACCRUED INTEREST means the interest which is accrued with time.It calculates the interest of those securities which give periodic returns.

PURPOSE OF ACCRINT IN EXCEL

ACCRINT FUNCTION CALCULATES THE ACCRUED INTEREST OF THE SECURITIES WHICH PAYS PERIODIC INTERESTS.

It means a bond kind of security paying out interest to us periodically say once a year, twice a year or four times a year i.e. quaterly.

PREREQUISITES TO LEARN ACCRINT

THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.

  •  Basic understanding of how to use a formula or function.
  •  Basic understanding of rows and columns in Excel.
  •  Of course, Excel software.
Helpful links for the prerequisites mentioned above

SYNTAX: ACCRINT

The syntax ( the way how formula is phrased for excel) of ACCRINT is

=ACCRINT(ISSUING DATE, FIRST INTEREST DATE ,SETTLEMENT DATE, COUPON RATE , PAR VALUE ,FREQUENCY OF PAYOUT, BASIS ,CALCULATION METHOD)

ISSUING DATE   is the security’s issue date.

FIRST INTEREST DATE is the security’s first interest
date.

SETTLEMENT DATE   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.

 

ALL THREE DATES MUST BE ENTERED THROUGH THE DATE FUNCTION.

=DATE(YYYY,MM,DD) OTHERWISE ERROR WILL EMERGE.

COUPON RATE  is the security’s annual coupon rate. Its just like INTEREST RATE.

PAR VALUE   is the security’s par value. If we don’t use Par value,ACCRINT uses 1,000.

FREQUENCY OF PAYOUT  is the number of coupon payments per year.
For annual payments, frequency = 1; for semiannual, frequency = 2; for quarterly, frequency = 4.

Basis   is the type of day count basis to use.

BasisDay count basis
0 or omittedUS (NASD) 30/360
1Actual/actual
2Actual/360
3Actual/365
4European
30/360

BASIS VALUE CAN BE BETWEEN 0 TO 4 AS PER THE TABLE OTHERWISE ERROR WILL BE SHOWN.

CALCULATION METHOD It is a logical value that specifies the way to calculate the total accrued interest when the date of settlement is later than the date of first interest. A value of TRUE (1) returns the total accrued interest from issue to settlement. A value of FALSE (0) returns the accrued interest from first interest to settlement. Default value is TRUE.

example:ACCRINT in excel

DATA SAMPLE

A Security is issued on date 1.1.2020.
The first interest date is  31.3.2020
The settlement date is 31.5.2020
Coupon rate is 10%.
Par value is 1000 (any currency)
BASIS is 0
Calculation method is True. (interest from issue date to settlement date)
Frequency of payout say 2.(Twice a year)
Let us find out using ACCRINT FUNCTION.
 
 

 

EXCEL:ACCRINT:EXAMPLE

STEPS TO USE ACCRINT

THE DATA SAMPLE IS ALREADY GIVEN.

The data is put as per the picture from cell F7 TO F14

We put in the cell G15 the formula to get interest

=ACCRINT(G7,G8,G9,G11,G10,G12,G13,G14)

We can put direct dates also and G14 can be put as TRUE OR FALSE as per need.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, ACCRINT FUNCTION IN EXCEL,  HOW TO USE ACCRINT, ACCRUED INTEREST FUNCTION IN EXCEL.

YOU MAY LIKE

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]