to get the same answer from a normal calculator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am sales executive for a bank in UAE.My product is Personal
Loan. I am normally using the Ms Excel worksheet to calculate the monthly
installment for my clients.
Sometimes,i have to use my calculator to get the installment.
So how can i calculate the following formula with a normal calculator
=PMT(B6/12,C6,-A6)=3,014.78

B6=9.5% (Reducing Interest Rate per annum)
C6=48 months ie,4 year(Period for the Loan)
A6=120000 (Loan Amount)

I want to get the same answer (3,014.78) with a normal calculator.I expect
u will do the necessary and oblige

Yours Faithfully,
Shabeer
Uae
Mob No +971503842668
(e-mail address removed)(u can send the answer to this id)
 
Help for PV gives the equation that Excel employs for its financial functions.

Jerry
 
Help for PV gives the equation that Excel employs for its financial functions.

Jerry
 
You must log in or register to reply here.

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

Similar Threads

how do I calculate a monthly payment based on a variable rate? 1
mortgage ammortization schedule 7
Interest and Payment Calculations 6
How do I create the formula for this calculation? 1
Decimals on a date calculation 5
EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge 3
How do I calculate after making 12 payments of my mortgage 5
I need a Line of Credit Calculator 5

Back
Top