ExcelBanter - template for monthly interest expense for invested monies

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - template for monthly interest expense for invested monies (https://www.excelbanter.com/new-users-excel/113028-template-monthly-interest-expense-invested-monies.html)

kbergsma

template for monthly interest expense for invested monies

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

Wendy K.

template for monthly interest expense for invested monies

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.

All times are GMT +1. The time now is 09:50 PM.