How to calculate EMi?

[Rathin]

I like to calculate EMI (Equated monthly installment) for loan terms
depending on tenure, rate of interest (fixed) and principal amount. The
amount for every month should be the same including principal and interest
but the amount of principal portion in the pay out will increase with
advancement of the loan and interest component will be less. Please give me
the function. Please give me any link if possible to calculate in web.

 

[FSt1]

hi,
in excel help, look up the CUMPRINC and CUMIPMT worksheet functions.
you can use these to create an amotazation table.

regards
FSt1

 

[joeu2004]

I like to calculate EMI (Equated monthly installment) for loan terms
depending on tenure, rate of interest (fixed) and principal amount. The
amount for every month should be the same including principal and interest
but the amount of principal portion in the pay out will increase with
advancement of the loan and interest component will be less. Please give me
the function. Please give me any link if possible to calculate in web.

Google "equated monthly installments" (without quotes) to find
calculators on the web. In Excel, use the PMT() function. For
example, given a loan of 100,000 at 5% interest for 15 years, the
monthly payment would be:

=pmt(5%/12, 15*12, -100000)