Rearranging for the number of periods. Most simple personal loans will work. Calculate your total interest by using this formula.
Both r and n will not be annual amounts if payment is made more than once per year.
The The formula in F5 is. For instance to calculate the monthly payment in the example above you. Calculate your total interest by using this formula. Most banks and financial institutions use a mathematical formula to calculate personal loan EMI.