The interest portion of a loan payment can be calculated manually by multiplying the periods interest rate by the remaining balance. Calculate simple interest in Excel. Simple interest means that interest payments are not compounded the interest is applied to the principal only.
Calculation using Excels FV Formula.
Interest principal rate term So using cell references we have. Doing so opens a new spreadsheet for your interest calculator. C5 C7 C6 1000 10 005 500. Scroll down the list that displays and click on COUNTA.