Excel Courses: https://www.teachexcel.com/premium-courses/

More help: https://www.teachexcel.com
Excel Forum: https://www.teachexcel.com/talk/microsoft-office?src=yt

How to find the interest and principal payments on a fixed rate loan in excel. This tutorial will walk you through using the PPMT() and IPMT() functions in excel in order to find out how much of a monthly payment on a loan actually goes to pay off the loan amount and how much is just an interest payment.

More free excel stuff such as macros, tutorials, articles, etc. go to: TeachExcel.com

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