Figuring out the Principal Remaining on a Loan

[loganc123]

Hello, Whenever I try to fill the PPMT function, it is increasing by a small margin. Its not letting me attach a file so I will post a picture.

http://prntscr.com/alpixw

I froze all cells except for the cell asking which period it is currently in.

Any help would be greatly appreciated.

[Kaper]

But PPMT will show you only what part of loan principal have been paid during given period
and of course it is increasing every period, as your remaining priincipal decreases, every next period you pay less interest and more principal.

If your aim is to see remaining principal and you want to use PPMT, then leave formula in B4 as is
But in B5 (and copy down) write a bit different one:

Please Login or Register  to view this content.

PS. I'm by no means expert in financial functions (nor in terminology, especially in English), but probably "most appropriate" function here would be CUMPRINC - like (B4 and copy down):

Please Login or Register  to view this content.