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

Page Navigation

Main Profile

At A Glance

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

http://www.TeachMsOffice.com 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. To follow along with this spreadsheet as well as to get more free excel stuff such as macros, tutorials, articles, etc. go to: http://www.TeachMsOffice.com

Length:
05:11

Contact

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

Want more info about How to find Interest & Principal payments on a Loan in Excel?
Get free advice from education experts and Noodle community members.