Excel - calculate equated monthly installment ?

Asked By D V Bidri on 04-Jun-10 10:13 AM
How do we calculate equated monthly installment value for given int rate and
period for a capital available and reverse of the same. Thanks




Jackpot replied to D V Bidri on 04-Jun-10 10:28 AM
Try

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

=PMT(A2/12,A3,-A1)
trip_to_tokyo replied to D V Bidri on 04-Jun-10 11:04 AM
EXCEL 2007

Please check out:-

http://www.pierrefondes.com/

- item number 6 right at the bottom of the page.

Pull up the Workbook in front of you and then look at the
What_Will_My_Monthly_Payment_Be Worksheet.

Int Rate goes in cell E4.

Period (in months) goes in cell E6.

Principal (capital) goes in cell E8.

Monthly repayment gets shown in cell C11.

There are another 2 Worksheets which are fairly self explanatory.

Just plug your (inputs) details into the blue cells and the answer is shown
in the red ones.

Please hit Yes if my comments have helped.

Thanks.










for given int rate

and

for a capital available

and reverse of the same. Thanks