=PMT

E

earl glass

How can I enter "=PMT(8%/12,30*12,60000) into a standard
calculator to get the answer?

what keys order to I press?
 
B

Bernard Liengme

Why do you think a standard calculator can use Excel functions?
I expect you can buy a business calculator that can do Present Values
computations but do not expect it to necessarily have its arguments in the
same order as Excel.

best wishes and happy thanksgiving (in Canada)
 
C

CarlosAntenna

Earl,

If I understand your question correctly, you want to know the formula used
in the PMT function so you can do it on a calculator. The equivalent
formula in excel would be something like:
=B1*(B2/(1-(1+B2)^(-1*B3)))
Where B1 is the principal (60000)
B2 is the monthly interest (.08/12)
and B3 is the number of months (30*12)

If you can understand the formula, you should be able to punch it into your
calculator. Of course your calculator will have to have the functions
necessary to do the calculation. A TI-30 or better should do it.

Carlos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top