How to calculate loan amount using annual rate, number of months and EMI

Loan amount is calculated as follows

Loan amount =PV(rate,nper,pmt,[fv],[type])

The fv and type arguments are optional arguments in the function (indicated by the square brackets). The fv argument is the future value or cash balance that you want to have after making your last payment. If you omit the fv argument, Excel assumes a future value of zero (0).
The type argument indicates whether the payment is made at the beginning or end of the period: Enter 0 (or omit the type argument) when the payment is made at the end of the period, and use 1 when it is made at the beginning of the period.


rate has to be monthly rate. So if annual rate is 12% then give 12%/12 as rate

nper is number of monthly payments

pmt is the amount to be paid per month. It should be entered with minus sign to get positive value of loan amount.