View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default ISMPT compared to Amortization

It will help if you give us an example of where you think Excel is going wrong.

What parameters did you use for ISPMT, what calculations for the amortization
table?

--
Regards,
Fred


"Lenderrs" wrote in message
...
In Excel the ISMPT formula does not return the same results as an
amortization schedule. What is the differnce? The interest calculation for
the first payment on the example giving under Excel help is not the same as
the interest shown in an amortization schedule