00:00This is how we create a simple loan payment calculator. We have a loan amount which is the
00:04principal amount of the loan in dollars. The interest rate is the annual interest rate on the
00:10loan in percentage and the years is the term of the loan in years. We'll be using the PMT function
00:16with first argument being the interest rate divided by 12 which converts the annual interest
00:21rate into monthly interest rate. And the second argument is to calculate the total number of
00:26monthly payments over the life of the loan. And the third argument is the loan amount or the
00:32principal. And after that, if you hit enter, you'll return the monthly payment required to pay off
00:37the loan including both principal and interest over the 30 years. If you do not like a negative
00:43number on your monthly payment, just place a minus right before the PMT function and you'll get a
00:48positive number.