I am having trouble using the PMT function. When I calculate my formula out to the end of the loan period (where it will be paid off by) I still have principal remaining. Here is the image of how I have it set up with the formula bar visible. The payment and rate are fixed over a 60month period. In cell C1, I have "=B41-B45" with all the following cells in the row set up in the same fashion. By month 60, there is still 3150.87 leftover on the principal.

Capture.PNG

I tried it using PPMT instead of PMT, and the problem still remains with 4286.42 leftover. Below is that image, C1 is still the same.

Capture2.PNG