G Guest Oct 5, 2006 #1 I need a template or formula suggestions that easily creates the monthly interest expense for shareholder loans.
I need a template or formula suggestions that easily creates the monthly interest expense for shareholder loans.
G Guest Oct 5, 2006 #2 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.
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.
