Running numbers is easy with an Excel loan calculator.Microsoft Excel provides functions for the calculations of many different financial transactions.
Type in cell:
=1000 x 5%
You could substitute the numbers for other cells where you input the numbers:
=A1 * A2 where A1 contains principal and A2 contains interest rate.
You could even label A1 as 'Principal' and A2 as 'Interest'
how can i calculate bank interest on excel ?