Home OS Windows How to calculate Simple Interest in Excel

How to calculate Simple Interest in Excel

Calculating Simple Interest is a superb approach to consider your monetary financial savings upfront. However, calculating it for quite a lot of pursuits and principal sums could very effectively be difficult. This is the place Excel comes to help. If you need to calculate Simple Interest in Microsoft Excel, please study by means of this textual content.


How to calculate Simple Interest in Excel

In case of Simple Interest, the tactic is:

Simple Interest = Principal * Rate of Interest (annual) * Time Period (annual)

Thus, the tactic for finding Simple Interest in Excel turns into:

=<cell with principal value>*<cell with value of curiosity>*<cell with time interval>


  • <cell with principal value> is the cell number of the cell containing the principal amount.
  • <cell with value of curiosity> is the cell number of the cell with the pace of curiosity.
  • <cell with time interval> is the time interval of the deposit in years.

It wants to be well-known that the pace of curiosity is in share. You need in order to add the share picture after mentioning the pace. Not doing so will create a decide the place the Simple Interest attained could possibly be 100 situations the right value.

Also, the foreign exchange of the principal value could very effectively be added from the Home tab.

Eg. Let us assume that the principal values are in column A from cell A3 to A11, value of curiosity values are in column B from cell B3 to B11, and the values of time interval are in column C from cell C3 to C11. The values of simple curiosity are wished in column D from D3 to D11. The technique for simple curiosity in D3 would flip into:

How to calculate Simple Interest in Excel

Enter this technique in cell D3 after which use the Fill carry out to maintain it till cell D11. To accomplish that, click on on wherever outside cell D3 after which once more on cell D3. Then, you’d uncover a bit bit dot on the right-bottom nook of cell D3.

Hope it helps!

Read subsequent: Calculate Weight to Height ratio and BMI in Excel using this BMI calculation technique.

How to calculate Simple Interest in Excel

Most Popular

AppsFlyer raises funding from Salesforce Ventures at $2 billion valuation

Mobile measurement and marketing company AppsFlyer said it has raised a new round of funding from Salesforce Ventures at a $2 billion valuation. AppsFlyer...

Bitcoin Latinum Launches To be World’s Largest Insured Cryptocurrency with Backing From Titans of Industry

PALO ALTO, Calif.–(BUSINESS WIRE)–November 24, 2020– Bitcoin Latinum, the next-generation Bitcoin fork capable of massive transaction volume, digital asset management, cyber security, and capacity is...

Gigabyte unveils liquid-cooled external enclosure packing an RTX 3080/3090

In brief: Do you have a Thunderbolt 3-enabled laptop that’s underpowered in...

Percepto raises $45 million for robots that inspect critical infrastructure

Autonomous inspection solutions company Percepto today announced a $45 million round. The funds come as Percepto pivots from drone-based products to general robotics-driven inspections...

Recent Comments