I am trying to calculate interest income for a group of securities for a
period of multiple months. The interest rate is fluctuating between months
and I was wondering if it's possible to create a formula which takes into
consideration the number of months each security is outstandind in a specific
month and the interest rate to calculate the total interest income.
Any help will be appreciated.

Thank you,

Dimitar