Interest calculaton - Multiple Disbursement & Interest changes

[ramakrishnan]

Dear Experts,


Attached is the interest rate changes for a particular loan which was disbursed in 3 installments. The calculation logic is also mentioned in the attachment.

What function/ formula needs to be used to get this interest accrued?

1. Loan is disbursed in various stages
2. Interest rate changes for the period needs to considered.


Thanks in Advance

Regards
R.Ramakrishnan

[Admin]

Hi

You mean like this

=SUM(P5:INDEX(P5:P720,MATCH(G26,L5:L720)))

[ramakrishnan]

No sir. The calculation logic is for understanding the calculation. I need to know how this value can be arrived usring some function/ formula/ vba code.

Regards
R.Ramakrishnan

[Admin]

Hi RK,

PFA.

[bpascal123]

Hi PFA,
Is your solution applicable to Business day conventions (ex.interest rate swap, derivative)?
Regards,
Pascal

[Admin]

Hi Pascal,

PFA = Please find attahced

I'm not familiar with those financial terms. I created the formula based on the logic the OP provided in the workbook.

[ramakrishnan]

Sir, This is exactly what i was expecting and woking wonderfully.

Thanks a million for your timely solution.

Regards
R.Ramakrishnan

[Admin]

Hi Ramakrishnan

You are welcome !!