Skip to Content
0
A R
Jul 11, 2016 at 01:29 PM

Add spread to interest rate

274 Views

Hi Experts,

I would like to add a spread rate to existing interest rates. I would like to use variable Libor interest rate and maintain interest rates in the table. business would like to add the spread (Additional rate) to the libor.

For example, The Libor interest rate is 2.34 and would like to add 0.06 as spread. The total interest is 2.34 + 0.06 = 2.4. Business would like to use 2.4% for interest calculation.

I have the option to enter the spread one time while creating the investment/borrowing deal, but would like to update every month or as and when spread rate changed.

Please suggest the options available to achieve this requirement.

Thanks