Try

A1 - Loan amount.
A2 - Per annum interest rate (in %)
A3 - Tenure in months.

=PMT(A2/12,A3,-A1)


"D V Bidri" wrote:

How do we calculate equated monthly installment value for given int rate and
period for a capital available and reverse of the same. Thanks