jayasaravanan
3

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
Attached Files (Download Requires Membership)
File Type: xls Loan as on date.xls (182.5 KB, 1698 views)

anthonypaul
16

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
anthonypaul
16

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.

From United States, Palo Alto
jayasaravanan
3

IS this what you asked for?
From India, Madras
Attached Files (Download Requires Membership)
File Type: xls Format Paul.xls (49.5 KB, 841 views)

anthonypaul
16

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
anthonypaul
16

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.)
From United States, Palo Alto
Attached Files (Download Requires Membership)
File Type: xls Format%20jayal(1).xls (58.5 KB, 308 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.