How To Calculate Loan Payments Using The PMT Function In Excel

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:
   • Excel Tutorial For Beginners - Basic ...  

Top 30 Excel Tips & Shortcuts:
   • Top 30 Excel 2016 Tips, Tricks, Short...  

_________________________________________
How To Calculate The Total Hours Worked:
   • How To Calculate The Total Hours Work...  

How To Make a Time-Sheet In Excel:
   • How To Make a Simple Time Sheet In Excel  

How To Calculate Loan Payments In Excel:
   • How To Calculate Loan Payments Using ...  

How To Create an Amortization Table:
   • How To Create an Amortization Table I...  

Excel - Business Account Ledger:
   • Business Account Ledger - Debit and C...  

________________________________________
How To Look Up Customer Data In Excel:
   • VLookUp - How To Extract Data From an...  

Excel Vlookup Function:
   • How To Use The VlookUp Function | Exc...  

How To Create a Data Entry Form In Excel:
   • How To Create a Data Entry Form In Mi...  

Multiple Dependent Drop Down Lists:
   • How To Create Multiple Dependent Drop...  

How To Show & Hide Formulas:
   • How To Show and Hide Formulas In Exce...  

______________________________________
YouTube Channel Growth Accelerator:
  / youtubechannelgrowthaccelerator  

Algebra For Beginners:
https://www.video-tutor.net/algebra-f...

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

Full-Length Math & Science Videos:
  / collections