principal x (annual interest rate/12) = monthly interest

use a cell reference for the principal and interest rate and you can copy
the formula. Hope that helps.

-Wendy K.


"kbergsma" wrote:

I need a template or formula suggestions that easily creates the monthly
interest expense for shareholder loans.