AzharNadeem
New Member
- Joined
- Mar 16, 2014
- Messages
- 9
Hi,
I am figuring out how to prepare a Loan Repayment Schedule in excel when disbursement is done in up to 4 tranches. The repayment schedule we are using is attached as a hyperlink. It is a simple affair when the whole disbursement is done in one go. But in certain cases, disbursement is processed in tranches (installments). Please help me configure the repayment schedule in this case. For example
1. Tranch 1 disbursement date is 01-01-2022 (Amount 100,000)
2. Tranch 2 disbursement date is 01-05-2022 (Amount 100,000). In this case, 3 installments will be calculated on 100,000 while the 4th will be on 200,000. Also, interest payment can be less than 30 days based on the installment due date.
3. Tranche 3 & 4 (Same scenario as explained in Tranche 2)
The installment for tranches 2, 3,4 has to be added in the relevant installment.
Can someone help me configure a formula/helper sheet or a MACRO to achieve the desired?
Regards
Azhar
I am figuring out how to prepare a Loan Repayment Schedule in excel when disbursement is done in up to 4 tranches. The repayment schedule we are using is attached as a hyperlink. It is a simple affair when the whole disbursement is done in one go. But in certain cases, disbursement is processed in tranches (installments). Please help me configure the repayment schedule in this case. For example
1. Tranch 1 disbursement date is 01-01-2022 (Amount 100,000)
2. Tranch 2 disbursement date is 01-05-2022 (Amount 100,000). In this case, 3 installments will be calculated on 100,000 while the 4th will be on 200,000. Also, interest payment can be less than 30 days based on the installment due date.
3. Tranche 3 & 4 (Same scenario as explained in Tranche 2)
The installment for tranches 2, 3,4 has to be added in the relevant installment.
Can someone help me configure a formula/helper sheet or a MACRO to achieve the desired?
Regards
Azhar
