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
Hi
You mean like this
=SUM(P5:INDEX(P5:P720,MATCH(G26,L5:L720)))
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
Hi RK,
PFA.
Hi PFA,
Is your solution applicable to Business day conventions (ex.interest rate swap, derivative)?
Regards,
Pascal
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.
Sir, This is exactly what i was expecting and woking wonderfully.
Thanks a million for your timely solution.
Regards
R.Ramakrishnan
Hi Ramakrishnan
You are welcome !! :cheers: