Loan

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 2

Tenuar in Days Loan Amount Int Deduction Sequriety Deposit Total Recovery Daily Collection

90 10000 700 300 9000 100


90 20000 1400 600 18000 200
90 30000 2100 900 27000 300
90 40000 2800 1200 36000 400
90 50000 3500 1500 45000 500
90 60000 4200 1800 54000 600
90 70000 4900 2100 63000 700
90 80000 5600 2400 72000 800
90 90000 6300 2700 81000 900
90 100000 7000 3000 90000 1000

Tenuar in Days Loan Amount Int Deduction Sequriety Deposit Total Recovery Daily Collection
180 10000 1400 300 8300 46.11
180 20000 2800 600 16600 92.22
180 30000 4200 900 24900 138.33
180 40000 5600 1200 33200 184.44
180 50000 7000 1500 41500 230.56
180 60000 8400 1800 49800 276.67
180 70000 9800 2100 58100 322.78
180 80000 11200 2400 66400 368.89
180 90000 12600 2700 74700 415.00
180 100000 14000 3000 83000 461.11
Monthly Total Collection Agent Comition % Comition Penal ti 2% Daily Daily Exptra Rs
9000 3 270 2 2
18000 3 540 2 4
27000 3 810 2 6
36000 3 1080 2 8
45000 3 1350 2 10
54000 3 1620 2 12
63000 3 1890 2 14
72000 3 2160 2 16
81000 3 2430 2 18
90000 3 2700 2 20

Monthly Total Collection Agent Comition % Total Comition Penal ti 2% Daily


8300 3 249 2 0.92
16600 3 498 2 1.84
24900 3 747 2 2.77
33200 3 996 2 3.69
41500 3 1245 2 4.61
49800 3 1494 2 5.53
58100 3 1743 2 6.46
66400 3 1992 2 7.38
74700 3 2241 2 8.30
83000 3 2490 2 9.22

You might also like