In this video, I demonstrate how to use 5 different Excel Functions when analyzing Loan Payments. PMT to determine who much you will pay each period (depending on interest rate, repayment periods and the amount that you borrow.)

You can also use the IPMT and PPMT functions to tell you how much Interest is charged and how much your loan principal is reduced for any given loan payment. The other two functions: CUMIPMT and CUMPRINC tell you how much interest or principal you paid between a start period and an end period.

I invite you to visit my online shopping website – http://shop.thecompany rocks.com – to learn more about the many videos and resoures that I offer.

Danny Rocks
The Company Rocks

Please take the opportunity to connect and share this video with your friends and family if you find it useful.