Hi,
Firstly i want to thank you and appreciate. Your website which helped me to gain more knowledge and understanding on Home Loans.
Please let me know how EMI is calculated while the loan is partially disbursement?
Loan Amount Sanctioned 45,58,140.00
Amt Disbursed 13,25,525.00
Loan Re-Payment Made 09,00,000.00
Amount Outstanding 04,25,525.00
Please let me know how the EMI calculates when loan is disposed partially.
Send me the EMI excel worksheet.
Assume i have started my EMI Rs. 52,525.00
01 month loan disbursed 4,25,525.00
04 month loan disbursed 6,00,000.00
07 month loan disbursed 6,00,000.00
10 month loan disbursed 7,00,000.00
13 month loan disbursed 9,00,000.00
16 month loan disbursed 8,00,000.00
19 month loan disbursed 5,32,615.00
MonthsDisbursedOpening InterestPrincipalClosing
1 425525 425525 3989 48536 376989
2 376989 3534 48991 327998
3 327998 3075 49451 278547
4 600000 878547 8236 44289 834258
Thank you and appreciate your response on this.
– Ram