Interest Calculator

Name of Employee P.F.No: Advance Type Loan Taken on (Date) Amount (Rs.) Monthly Installment(Rs.) Commencing date of Recovery

Aditya Narayan Singh 12345678 Desig: Accounts Assistant Scooter Advance 25-Mar-05 30000 600 or No.of Installment 0 Apr-05 Rate of Interest 8% Interest Calculation Sheet for Scooter Advance

Name of Employee: P.F.No: Loan Taken on: Monthly Installment(Rs.) Recovery commenced from Sr. No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

aditya

Date Mar-05 Apr-05 May-05 Jun-05 Jul-05 Aug-05 Sep-05 Oct-05 Nov-05 Dec-05 Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07 Feb-07 Mar-07 Apr-07 May-07 Jun-07 Jul-07 Aug-07 Sep-07

Aditya Narayan Singh 12345678 Desig.: Accounts Assistant 25-Mar-05 Amount (Rs.) : 30000 600 No.of Installment 50 Apr-05 Rate of Interest 8%

Amount Balance Recovered 0 30000 600 29400 600 28800 600 28200 600 27600 600 27000 600 26400 600 25800 600 25200 600 24600 600 24000 600 23400 600 22800 600 22200 600 21600 600 21000 600 20400 600 19800 600 19200 600 18600 600 18000 600 17400 600 16800 600 16200 600 15600 600 15000 600 14400 600 13800 600 13200 600 12600 600 12000

Sr. No 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51

Date Nov-07 Dec-07 Jan-08 Feb-08 Mar-08 Apr-08 May-08 Jun-08 Jul-08 Aug-08 Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Mar-09 Apr-09 May-09

Amount Recovered 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600 600

Balance 10800 10200 9600 9000 8400 7800 7200 6600 6000 5400 4800 4200 3600 3000 2400 1800 1200 600 0

32

Oct-07

600

11400 TOTAL

Interest=

aditya

765000x8 12x100

30000

765000 5100

= Rs.5100/- (Rs.Five thousand One hundred only)

Print OK

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50

aditya

51 54 55 56 57 59 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99

aditya

One Two Three Four Five Six Seven Eight Nine Ten Eleven Twelve Thirteen Fourteen Fifteen Sixteen Seventeen Nineteen Twenty Twenty-One Twenty-Two Twenty-three Twenty-four Twenty-five Twenty-six Twenty-seven Twenty-eight Twenty-nine Thirty Thirty-one Thirty-two Thirty-three Thirty-four Thirty-five Thirty-six Thirty-seven Thirty-eight Thirty-nine Forty Forty-one Forty-two Forty-three Forty-four Forty-five Forty-six Forty-seven Forty-eight Forty-nine Fifty

aditya

lcs 5100

ths 0

hn

5 Five Five thousand One hundred only

ten 1 One

0

Fifty-one Fifty-four Fifty-five Fifty-six Fifty-seven Fifty-nine Sixty-one Sixty-two Sixty-three Sixty-four Sixty-five Sixty-six Sixty-seven Sixty-eight Sixty-nine Seventy Seventy-one Seventy-two Seventy-three Seventy-four Seventy-five Seventy-six Seventy-seven Seventy-eight Seventy-nine Eighty Eighty-one Eighty-two Eighty-three Eighty-four Eighty-five Eighty-six Eighty-seven Eighty-eight Eighty-nine Ninety Ninety-one Ninety-two Ninety-three Ninety-four Ninety-five Ninety-six Ninety-seven Ninety-eight Ninety-nine

aditya