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

Category:

Education

Tags:

• excel
• tutorial
• how
• to
• ppmt
• ipmt
• payment
• functions
• formulas
• mortgage
• loan
• calculate
• interest
• principal

[a1cswiz1611]

I'm looking all over your website and I can't seem to find this spreadsheet. Can't you send me a link?

[trinitube]

what function did you use to get the numbers to change everytime you change the months

[DenisMaiorov]

helpful

[Elliottsr1]

Gave me answers I was looking for.

[Paintbl99]

I am having issues continuing the function down through the following 359 rows. It is giving me #NUM! when I click and drag the function down.

[TheGiselleBella]

Merci beaucoup

[Raeb222]

Thank you very helpful

[ben75h]

Thank you! Great work for students!!! By the way , what is your name? I really like the way you teach!

[nzmattcoop]

Much appreciated, v useful