Loan Repayment Insights: How to Easily Track Your Outstanding Balance and Interest

Hi all,

This calculator helps to determine the principal outstanding and the interest component. Just update the tenure, interest rate, and loan amount in the attached Excel sheet.

Hi,

Actually, I am looking for the loan schedules for 300 employees. In our company, there is no interest paid by the employee; only a perquisite value is about 15.50%.

Please help...

Hi,

Actually, the calculation I need in an Excel sheet is for 300 employees.

Calculation:
Emergency Loan granted = Rs. 50,000
Perquisite value = 13% of Rs. 50,000 = Rs. 6,500
Tax to be paid = 30% of perquisite value = Rs. 1,950 per annum

The monthly deduction is shown for 300 employees at the end of every month.

Hi,

Please find the Excel sheet attached. Kindly review the second sheet, which illustrates my current work. However, I require a different approach similar to what you have accomplished in "Loan as on date.xls."

Thank you.

Hi Jaya,

Sorry, please find the attached Excel Sheet. Kindly review the second sheet, which outlines my current work. However, I require the information presented differently, similar to the format used in "Loan as on date.xls."

Thank you.