loan EMI interest

This query is : Resolved

AMIT (Querist)
Follow

12 June 2010
Rs. 100000 @ 8% P.A for 2 yrs

EMi comes to Rs.4523

how can i calulate the amount of interest and amount of pricipal from it by manual method only , ??

SAMBASIVARAO

SAMBASIVARAO (Expert)
Follow

12 June 2010 Here is the bifirication of Intrest, principle and EMI

Instalment Amount Principle Interest Balance Principle
4,523 4,107 416 95,893
4,523 3,892 631 92,001
4,523 3,898 625 88,103
4,523 3,924 599 84,179
4,523 3,969 554 80,210
4,523 3,978 545 76,232
4,523 4,022 501 72,210
4,523 4,032 491 68,178
4,523 4,060 463 64,118
4,523 4,130 393 59,988
4,523 4,115 408 55,873
4,523 4,156 367 51,717
4,523 4,172 351 47,545
4,523 4,210 313 43,335
4,523 4,229 294 39,106
4,523 4,257 266 34,849
4,523 4,294 229 30,555
4,523 4,315 208 26,240
4,523 4,350 173 21,890
4,523 4,374 149 17,516
4,523 4,404 119 13,112
4,523 4,443 80 8,669
4,523 4,464 59 4,205
4,233 4,205 28 -
- - - -

AMIT

AMIT (Querist)
Follow

12 June 2010 how can i calulate the pricipal and emi like this ?

CA. BIJENDER KR. BANSAL

CA. BIJENDER KR. BANSAL (Expert)
Follow

12 June 2010 Please send the email id , i will sent you excel sheet in which you put loan amount and rate of interest, automatically you get all detail, prnciapl, interest portion etc.

SAMBASIVARAO

SAMBASIVARAO (Expert)
Follow

12 June 2010 Please send the email id , i will sent you excel sheet in which you put loan amount and rate of interest, automatically you get all detail, prnciapl, interest portion etc.