View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Loan Calculations

Why don't you acrude on a daily basis. divide the interest rate by 360.
Then use
PMT for the number of days. 30 days per month, 360 days per year.


"Nolechik" wrote:

When I use the pmt formula for calculating loan payments I think the formula
is set up using the 365 accrual method, I need to know if there is a way to
calculate it using the 360 accrual method. I am new to this so excuse the
basic questions.....any help is GREATLY appreciated!