Thread: PER function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default PER function
On Sat, 02 Jun 2007 16:22:37 -0700, wrote:

I need help with the PER field in the PPMT function. When figuring
the amount of interest and principal paid during a given year, I can't
figure out how to determine these amounts for an entire year. When
payments are made monthly, the principal and interest amounts change
per month, so finding these amounts per year and each year thereafter
escapes me.

Any help on what to enter in the PER field to account for not only an
entire year, but subsequent years would be helpful.

Thanks,

Josh

Seems like what you want might be the CUMPRINC function.
--ron
Reply With QuoteReply With Quote