Sheet1
basic 52720 da %age 19.83%
da 14499.83 73120.7
hra 6039.3 58920
ta 850 0.1025
special allow 13350.7
special new pay 6200
93659.83 33727.898
71191.83
deal amount 5445000
registry value 270000
dealer commission 54450
@60% 56195.898
satu ded 22468 total cost 5769450
od inst 5500 1000000
27968
left emi 28227.898 token 11000
cash 300000
in ac aks 245000
max loan eligibility 6774695.52 in ac meena 379000
od 450000
loan applied 6775000 lfc2 54000
plot purchase 3387500 gold loan 600000
registry 3764000 111 loan amt plot 3500000
registry charges@6 225840 angoori bua 300000
emi 28229.1666666667
total paid 33729.1666666667
net 37462.6633333333
Page 1
Sheet1
pf 5892 11000 token
it 5001 4838
car loan 4300 100000 mummy done
200 620000 cash done
7075 115000 mutual fund done
54000 lfc done
22468 54000 Lfc 2
40000 ppf
600000 gold loan
300000 chachi
450000 od
2344000
Registry @4500000 4500000
6.00%
token 11000
cash 300000
5769450 in ac aks 121000
done 5758450 in ac meena 379000
done 5458450 in ac aks afte 124000
done 5213450 od 450000
done 4834450 lfc2 54000
4384450 gold loan 600000
4330450 loan amt plot 3500000
3730450 angoori bua 300000
230450
-69550
Page 2
Sheet2
DA %AGE 19.83%
Basic 52720 PF 5892
DA 14499.83 I.Tax 5001
Car Loan 4300
200
HRA 6039.3 7075
TA 850
SPECIAL ALLOW 13350.7
SPECIAL NEW PAY 6200
Total gross 93659.83 22468
Take home pay 71191.83
Page 3
Sheet2
Basic for da calc 73120.7
basic+spl new pay 58920
HRA %age 0.1025
Page 4
