PER function

J

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top