Thread: PPMT & IPMT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Budget Budget is offline
external usenet poster
 
Posts: 2
Default PPMT & IPMT

Please review the following formula's and let me know if they are
correct:

I'm trying to calculate the principal payment for $19,855,000 @ 6.25%
interest rate over 15.5 years with 1 principal payment per year.

=-PPMT(6.25%,1,15.5,19,855,000)

I'm trying to calculate the interest payment for $19,855,000 @ 6.25%
interest rate over 15.5 years with 2 interest payments per year

=-IPMT(6.25,1,15.5,$19,855,000)

I think something's missing.
Please advise.
Thanks