View Single Post
  #5   Report Post  
amalecki
 
Posts: n/a
Default

Don,
I tried your equations but to no avail; the Bank is using 6% based upon a
360 day year; the loan amount is $213,402.24; the loan will be paid off after
24 monthly payments; the fixed monthly payment the Bank has calculated is
$9,465.67.
Thanks
amalecki

"Don Guillett" wrote:

try

(Principle * i * (1+i)^n) ) / ((1+i)^n -1)
i = period interest rate (annual rate/12)
n = number of periods
====

or From Norman Harker

PMT = =-(PV*(1+RATE)^NPER+FV)/((1+RATE*TYPE)*(((1+RATE)^NPER-1)/RATE))

--
Don Guillett
SalesAid Software

"amalecki" wrote in message
...
I am using Excel 2002 I am trying to calculate a fixed monthly payment on

a
24 month loan. The problem is the bank uses a 360 day basis when they
calculate the fixed monthly payment. Excel's PMT formula has a 365 day

basis.
I have been on the Internet to no avail. I would greatly appreciate
anyone's help in solving this problem.