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