Calculate simple interest

Generic formula
interest=principal*rate*term
Summary
To calculate simple interest in Excel (i.e. interest that is not compounded), you can use a formula that multiples principal, rate, and term.
This example assumes that $1000 is invested for 10 years at an annual interest rate of 5%. Simple interest means that interest payments are not compounded – the interest is applied to the principal only.
In the example shown, the formula in C8 is:
=C5*C7*C6
Explanation
The general formula for simple interest is:
interest=principal*rate*term
So, using cell references, we have:
=C5*C7*C6 =1000*10*0.05 =500
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.