How to find Interest & Principal payments on a Loan in Excel

Excel Courses: https://www.teachexcel.com/premium-co... More help: https://www.teachexcel.com Excel Forum: https://www.teachexcel.com/talk/micro... 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