View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default Annual vs Quarterly Rates

When using the PMT function in Excel you typically divide the annual rate by
12 to get monthly compounding. This is OK when the payments are also monthly,
however, how do you calculate quarterly payments with monthly compounding???