In this article, we will explain how to calculate daily interest in Excel. Calculating daily interest in Excel is very useful in the banking sector and financial areas. It’s also applicable in different types of business applications. The focus of this article is to give you a brief idea about calculating daily interest in excel. To illustrate this process to you we will go over different types of examples so that you can learn and implement the process properly in your work or education.

## What is Daily Interest?

A daily interest loan accrues interest every day. The interest rate determined by dividing the Annual Interest Rate by 365 is referred to as the Daily Interest Rate.

## What is Daily Simple Interest?

Simple interest is a fast and simple way to figure out how much a loan will cost you in interest. The amount of simple interest is calculated by multiplying the principal amount by interest rate by the number of days between payments to calculate simple interest. To calculate the daily simple interest the value of the period will be 1 day.

Simple interest is calculated using the following formula:

**Simple Interest** =** P*****r*****n**

Where,

P = Principal Amount

R = Rate of interest

n = Time period

So, the formula for daily simple interest will be:

**Daily Simple Interest** = **P*****r*****1**

Where, n = 1 day.

The formula for the total amount gained after applying simple interest cab be calculated by the following formula:

**A **= **P***(**1**+**r*****n**)

## What is Daily Compound Interest?

Compound interest accrued on a savings or loan’s initial principle as well as the accrued interest from previous periods. We can say it is an Interest of Interest. The term “Daily Compounding” refers to when our daily interest/return is compounded.

Daily compound interest formula:

**Final Investment** = **Initial Amount***(**1**+**Rate of Interest**/**365)**^**n*****365**

Where, n = Number of years

So, **Daily Compound Interest **= **Final Investment**–**Initial Amount**

**Daily Compound Interest **= **Initial Amount***(**1**+**Rate of Interest**/**365**)^**n*****365**–**Initial Amount**

## 2 Easy Ways to Calculate Daily Interest in Excel

In this article, we will discuss two types of calculation of daily interest in excel. In the first method, we will calculate daily simple interest, and In the second method, we will calculate daily compound interest.

### 1. Calculate Daily Interest in Excel to Find Simple Interest

Suppose, you have invested $1,000,000 at the annual interest rate of 5%. Let’s see how much simple interest you will receive daily on your principal. In the following dataset, we will calculate the Final Balance after one day of interest as well as the total Interest Earned.

So, let’s see how we can perform the above actions by following some simple steps.

**STEPS:**

- Firstly, select cell
**C8**and insert the following formula:

`=C4*(1+C5*C6)`

- Next, press
**Enter**. This returns the amount of the final balance after one day of interest in cell**C8**.

- Secondly, select cell
**C9**and insert the following formula:

`=C8-C4`

- After that, press
**Enter**. - Finally, the above action returns the amount of simple Interest Earned in one day.

### 2. Daily Interest Calculation for Compound Interest in Excel

We use our money in long-term investments to increase our wealth efficiently. Most of the banks or financial institutions follow the compound interest rule. In this section, we will discuss 3 methods to calculate daily interest for compound interest.

#### 2.1 Use Daily Compound Interest Formula

First and foremost, we will use the daily compound interest formula to calculate daily interest in excel.

Suppose, you have deposited $5000 in a bank at the interest rate of 7%. We will figure out what will be the Final Balance and Interest Earned if the interest is compounded daily.

Let’s take a look at the steps to perform this action.

**STEPS:**

- First, select cell
**C9**and insert the following formula:

`=C4*(1+C5/C7)^(C6*C7)`

- Now, press
**Enter**. This returns the amount of Final Balance in cell**C9**after daily compounding.

- Next, select cell
**C10**and insert the following formula:

`=C9-C4`

- After that, press
**Enter**. - Finally, the above action returns the amount of Interest Earned after daily compounding.

**Read More: **How to Use Cumulative Interest Formula in Excel

#### 2.2 Use of FV Function to Calculate Daily Compound Interest

**The FV function**** **is a financial function that determines an investment’s future value based on a fixed interest rate. We can calculate daily compound interest by using the FV function also. To illustrate this method we will solve the previous problem with the FV function. We can take a look at the following image to see the dataset again.

Let’s see the steps to use the FV function to calculate daily compound interest.

**STEPS:**

- At the beginning select cell
**C9**. Insert the following formula in that cell:

`=FV(C5/C7, C6*C7, ,-C4)`

- Next, press
**Enter**. This action gives the same result for the Final Balance that the compound interest formula did in the previous example.

- Then, select cell
**C10**and insert the following formula:

`=C9-C4`

- After that, press
**Enter**. - Finally, the above command returns the same result for total Interest Earned that the compound interest formula did in the previous example.

#### 2.3 Calculate Daily Compound Interest Using IPMT Function

**The IPMT function **returns the interest amount of mortgage payment in a given period. This function assumes that the interest rate and total amount of the payment remain constant throughout.

Suppose, we have the principal of $5000 and the bank is offering 0.5% interest. We want to calculate daily compound interest using the IPMT function**.** As the amount will be daily compounded so we will consider the number of compounding periods per year 365.

So, let’s look at the steps of how we can use the IPMT function to calculate daily interest earned for the first month.

**STEPS:**

- Firstly, select cell
**C8**. - Secondly, insert the following formula in that cell:

`=IPMT(C5/C6,1,1,-C4)`

- After that, press
**Enter**. - Finally, the above command returns the amount of “Daily Interest Earned for the First Month” in cell
**C8**.

**Download Practice Workbook**

You can download the practice workbook from here.

## Conclusion

At last, this article discusses how to calculate daily interest in Excel. For the best results, download, and practice using our practice workbook, which is attached to this post. If you have any questions, please leave a comment below. We will make every effort to respond as soon as possible.

## Related Articles

- How to Calculate Interest Between Two Dates in Excel
- How to Calculate GPF Interest in Excel
- Calculation of Interest During Construction in Excel
- How to Perform Actual 360 Interest Calculation in Excel
- How to Split Principal and Interest in EMI in Excel
- Perform Carried Interest Calculation in Excel

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