View Single Post
  #1   Report Post  
amalecki
 
Posts: n/a
Default I want the PMT function to calculate using 360 days not 365

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.