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

regards
FSt1

"Rathin" wrote:

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.