## The Accrued Interest

The accrued interest is the interest that has accrued on a liability (such as a loan) or other financial obligation but is yet to be paid.

The Accrued Interest can be:

â‡’ Simple Interest

â‡’ Compound Interest

This is the sample dataset. It showcases Fixed Deposit (P), Annual Rate (r), Interest accrued per Year (n) and Years elapsed (t).

To calculate the accrued interest on a fixed deposit using the **ACCRINT **function the following dataset will be used.

### Method 1 – How to Calculate the Accrued Interest on a Fixed Deposit Manually

#### 1.1. Simple Interest

The formula to calculate the simple interest is:

`I = P*t*r`

**P** = Amount of Fixed Deposit

**t **= Years Elapsed

**r** = Annual Interest Rate.

To calculate the simple interest in the dataset below:

- Select
**C5**. Enter the formula.

`=C2*C3*C4`

Press **ENTER **to seeÂ the simple interest.

The Fixed Deposit (P), Annual Rate (r) and Years elapsed (t) were multiplied to calculate the Interest Amount: $1400.00.

#### 1.2. Compound Interest

To calculate the accrued interest on a fixed deposit, use the compound interest formula:

`I=P(1+r/n)^(n*t)-P`

**P**= The deposit amount

**r**= Annual interest rate

**n**= number of times interest accrued per time period.

â†’ If interest is accrued annually, n=1

â‡’ If interest is accrued semiannually, n=2

â‡’ If interest is accrued monthly, n=12

â†’ If interest is accrued daily, n=365

**t**= number of time periods elapsed

The dataset showcases * the time period as one year* and

*. So, n=2.*

__interest being accrued semiannually__To calculate the interest amount:

- Select
**Â C6**. Enter the following formula.

`=C2*(1+C3/C4)^(C4*C5)-C2`

Press **ENTER**Â to see the compound interest.

The Fixed Deposit (P), Annual Rate (r), Interest accrued per year (n) and Years elapsed (t) were entered in the compound interest formula and the output is $1,584.05.

**Note:** Notice that the __compound interest is greater than the simple interest__.

**Read More:** How to Calculate Accrued Interest on a Loan in Excel

### Method 2 – Calculating the Accrued Interest on a Fixed Deposit using the ACCRINT Function

To use the ACCRINT function:

Select** C11**. Enter the formula.

`=ACCRINT(C2,C3,C4,C5,C6,C7,C8,C9)`

**Date of Deposition**: refers to the date of the deposit. Here, 1st January 2022 inÂ **C2**.

**First Interest Date**: indicates the date the first interest will be accrued. Here, 1st January 2023 inÂ **C3**.

**Settlement Date**:Â is the date of the deposit withdrawal. Here, 1st January 2024 in **C4**.

**Annual Interest Rate**: is the interest rate on an annual basis: 7%.

**Par Value**: the deposited amount. Here, $5000 in **C6**.

**Frequency/Payment Mode**: the number of times interest is accrued per year. Here, 1 in**Â C7**.

**Basis Days**: (optional argument) the day count used to calculate interest. If we omit the argument, the base is set to 0. Here, 0.

0- US (NASD 30/360)

1- Actual/Actual

2- Actual/360

3- Actual/365

4- European 30/360

**Calculation Method:** (optional argument) the date of settlement is later than the date of the first interest. This logical value indicates how to calculate the total accrued interest.Here, 0 in**Â C9 **to calculate* the accrued interest from the first interest to settlement*.

Press **ENTER**. Excel will calculate the interest amount: $700.00.

**Read More:** How to Calculate Accrued Interest on a Bond in Excel

### Method 3 – Calculating the Accrued Interest on a Fixed Deposit using the ACCRINT Function and the DATE Function

Use **the DATE function.**

* You do not have the dates in the dataset*.

Select

**C8**. Enter the following formula:

`=ACCRINT(DATE(2022,1,1),DATE(2023,1,1),DATE(2024,1,1),C3,C2,1,0,1)`

Press **ENTER**. Excel will return the accrued interest for the period between 1st January 2022 and 1st January 2024.

The *Accrued Interest i*s $700.00 for a Par Value of $5000.00. The Frequency/Payment Mode is 1:* interest will be accrued annually*.

## Practice Workbook

Practice here.

Practice the ACCRINT function.

**Download Practice Workbook**

## Related Articles

- How to Calculate Interest in Excel with Payments
- How to Calculate Principal and Interest on a Loan in Excel
- How to Calculate Home Loan Interest in Excel
- How to Calculate Interest on a Loan in Excel
- How to Calculate Gold Loan Interest in Excel
- How to Calculate Credit Card Interest in Excel

**<< Go Back to Calculate Interest In Excel | ****Excel for Finance**** | ****Learn Excel**

sir, i have deposit 21,00,00,000 on 04-04-2022 with rate of interest 6.30%,interest mode is quarterly,i had received 3 quarterly interest amount(last interest date 04-01-2023),i want to sum accrued interest for 31-03-2023 how to arrive in excel sir ,(ans is 3810483.87112)please help me sir ([email protected])