Using the NPER function to Calculate Payments Left to Finish a Loan in Microsoft Excel

Lets learn how to calculate how many payments would be left to finish a loan with the NPER function, or Number of Periods Function! Not only can we use this to learn how many payments are left, we can determine how many payments would be left if we changed the payment amount.

Have any questions about Microsoft Excel? Let us know your question, and it might be in our next video!