Term loan repayment schedule

Excel 732 views 1 replies

Kindly provide a repayment schedule in MS Excel for a term of 1.5 Crores with 13% per annum repayable within 60 months.As per the sanction letter monthly instalments is of Rs 250000 per month.

Replies (1)
Simply calculate interest on opening balance @ 13/ and reduce 2500000 per month for 60 month


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register