How to calculate simple interest in Excel
You can watch a video tutorial here.
Excel is widely used for calculations due to the several mathematical operators and functions that it has. Many small businesses use Excel to keep track of their daily operations. Calculating simple interest can be easily done in Excel. By using cell references instead of actual values, the calculator can be used for different values. The formula is as follows:
A = P(1+rt)
A = The final amount to be paid, including the interest
P = the principal
r = the annual rate of interest
t = the number of years
Simple interest = A-P
A = The final amount to be paid, including the interest
P = the principal
Step 1 – Compute the final amount
– Select the cell in which the result is to be displayed
– Type the formula using cell references:
= Principal * (1+(Rate of interest *No. of years))
– Press Enter
Step 2 – Compute the simple interest amount
– Select the cell in which the result is to be displayed
– Type the formula using cell references:
= Amount – Principal
– Press Enter
Step 3 – Check the result
– The simple interest amount is displayed