Know Your Loan Amount Outstanding As On Date - XLS Download

Hi all
This calculator helps to know the principal outstanding and the intrest compenent.Just change tenure, intrest and loan amount in the attached excel

Hi,
Actually Aim Looking the Loan secdules for 300 employees.
In our company there is no intrest paid by the employee only perquiste value was about 15.50%.
Pls help...

Hi,
Actually Calculation is this I need in excel sheet 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 for every end of the month.

IS this what you asked for?

Hi,
Find the xl.sheet attached pls see in 2nd sheet this what aim doing currently.
But I need differently wht you have done as like (Loan as on date.xls.)

Hi Jaya,
Sorry find the attached XL Sheet.
Find the xl.sheet attached pls see in 2nd sheet this what aim doing currently.
But I need differently wht you have done as like (Loan as on date.xls.)