PER function

[jpanknin]

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

 

[Ron Rosenfeld]

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