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.
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.
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.
