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
From India, Madras
Acknowledge(0)
Amend(0)
3From India, Madras
Acknowledge(0)Amend(0)
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...
From United States, Palo Alto
Acknowledge(0)Amend(0)
From United States, Palo Alto
Acknowledge(0)Amend(0)
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.
From United States, Palo Alto
Acknowledge(0)Amend(0)
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.
From United States, Palo Alto
Acknowledge(0)Amend(0)
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.)
From United States, Palo Alto
Acknowledge(0)Amend(0)
From United States, Palo Alto
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee excel sheet.xls