HDTutorial
EN
How To Calculate Loan Payments Using The PMT Function In Excel

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

How To Calculate Loan Payments Using The PMT Function In Excel

525,691 views October 25, 2018 10:47

Watch on YouTube
ChannelThe Organic Chemistry Tutor

Description from the creator

This video tutorial explains how to calculate loan payments using the PMT function in excel. It explains how to calculate the monthly payment given the principal and annual interest rate. It also determines the total cost of the loan with the total interest paid over the lifetime of the loan.

Excel Tutorial For Beginners:
youtube.com/watch?v=nK-uNYuvcag

Top 30 Excel Tips & Shortcuts:
youtube.com/watch?v=UMad9_-4rOU

Final Exam and Test Prep Videos:
bit.ly/41WNmI9

_________________________________________
How To Calculate The Total Hours Worked:
youtube.com/watch?v=VC2d3QtPBSE

How To Make a Time-Sheet In Excel:
youtube.com/watch?v=eSYKj5gWrGE

How To Calculate Loan Payments In Excel:
youtube.com/watch?v=ifbNN2SoKlk

How To Create an Amortization Table:
youtube.com/watch?v=QZfMW203v4U

Excel - Business Account Ledger:
youtube.com/watch?v=9oifIFRywGo

________________________________________
How To Look Up Customer Data In Excel:
youtube.com/watch?v=HDda6ny40ZM

Excel Vlookup Function:
youtube.com/watch?v=zV0ah1DPNJ8

How To Create a Data Entry Form In Excel:
youtube.com/watch?v=_tZLGBgQCYo

Multiple Dependent Drop Down Lists:
youtube.com/watch?v=NhtsVTeGywc

How To Show & Hide Formulas:
youtube.com/watch?v=U2P2jgbseK8

______________________________________
YouTube Channel Growth Accelerator:
patreon.com/YouTubeChannelGrowthAccelerator

Algebra For Beginners:
video-tutor.net/algebra-for-beginners-basic-int…

Final Exams and Video Playlists:
video-tutor.net/

Full-Length Math & Science Videos:
patreon.com/mathsciencetutor/collections

About this tutorial

The Organic Chemistry Tutor published this 10:47 video tutorial on October 25, 2018. It has been watched 525,691 times on YouTube.

Category
Education
Duration
10:47
Published
October 25, 2018
Views
525,691
Likes
4,112

Tags

Share

Further reading

  • How to use the Excel PMT function | Exceljet exceljet.net

    The PMT function can be used to figure out the future payments for a loan, assuming constant payments and a constant interest rate. For example, if you are borrowing $10,000 on a 24 month loan with an annual interest ra…

  • Using Excel PMT function to Calculate Loan Payment Amount trumpexcel.com

    Excel PMT function is one of the many financial functions available in Excel. It helps you calculate the payment you need to make for a loan when you know the total loan amount, interest rate, and the number of constant…

  • How to use PMT function in Excel with formula examples ablebits.com

    The tutorial shows how to use PMT function in Excel to calculate payments for a loan or investment based on the interest rate, number of payments, and the total loan amount. Before you borrow money it's good to know how…

This tutorial in other languages