Question
v
Calculate
HRA 40% of Basic.
v
Calculate
DA 70% of Basic.
v
Calculate
PF 10% of Basic.
v
The
TOTAL salary is to be calculated as BASIC+HRA+DA-PF.
v
For
the month, calculate the LOAN as 30 times the total salary for employees
whose total is above Rs. 4500.
v
Calculate
the loan repayment for per month if the loan is to be paid in 15 years
at an interest rate of five percent.
v
Rename
the sheet1 to as January.
v
Insert
a FBONUS column after the DA column. (Contain Festival Bonus Amount).
v
Festival
Bonus will be given @ 25 percent of BASIC only to those employees whose BASIC
is above Rs. 2700.
v
Calculate
the NET SALARY of every employee as TOTAL+F BONUS-LOAN.
v
Print
the above worksheet after it has been complete in one single sheet.
Solution
1)
HRA: - =D4*40%
2)
DA: - =D4*90%
3)
PF: - =D4*10%
4)
Total: - =D4+E4+F4-G4
5)
Loan Amt: - =If (H4>=4500, H4*30)
6)
Loan Amt
Paid: - =PMT (5%/12, 180, I4)
7)
FBONUS: - =If (D4>=2700, D4*35%)
Net Salary: - =Total+
FBONUS -Loan Amt Paid