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

Playback starts YouTube’s embedded player (privacy-enhanced mode).

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

758,081 views October 25, 2008 5:11

Watch on YouTube
ChannelTeachExcel

Description from the creator

Excel Courses: teachexcel.com/premium-courses/


More help: teachexcel.com
Excel Forum: 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

About this tutorial

TeachExcel published this 5:11 video tutorial on October 25, 2008. It has been watched 758,081 times on YouTube.

Channel
TeachExcel
Category
Education
Duration
5:11
Published
October 25, 2008
Views
758,081
Likes
2,159

Tags

Share

Further reading

  • Calculate Simple Interest Principal, Rate, or Time thoughtco.com

    Calculating simple interest or the amount of principal, the rate, or the time of a loan can seem confusing, but it's really not that hard. Here are examples of how to use the simple interest formula to find one value as…

  • 3 Ways to Calculate Interest - wikiHow wikihow.com

    Calculate the interest. To calculate interest, multiply the principal by the interest rate and the term of the loan. This formula can be expressed algebraically as: = ∗ ∗ Using the above example of the loan to a friend,…

  • How to Calculate Simple Interest: 10 Steps (with Pictures) wikihow.com

    To calculate simple interest, start by multiplying the principal, which is the initial sum borrowed, by the loan’s interest rate written as a decimal. Then, multiply that number by the total number of time periods since…

This tutorial in other languages