HDTutorial
EN
How to Use Excel PMT Function to Calculate Loan Payments

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

How to Use Excel PMT Function to Calculate Loan Payments

109,908 views November 1, 2018 6:01

Watch on YouTube
ChannelMatt Macarty

Description from the creator

Please SUBSCRIBE:
youtube.com/subscription_center?add_user=mjmaca…
How to Use the Excel PMT Function
alphabench.com/data/excel-PMT-function.html

The PMT or Payment function is part of the family of financial functions in Excel. It is useful for calculating a steady stream of payments required to bring any loan balance to zero over a specific period of time. More simply, PMT is a loan payment calculator, and is well suited in Excel to explore different scenarios.

The PMT Function can also be used to evaluate leases, where effectively the loan does not have a 0 balance at the end of its life.

Calculate:
Mortgage loan payments
Auto loan payments
Personal Loan payments

About this tutorial

Matt Macarty published this 6:01 video tutorial on November 1, 2018. It has been watched 109,908 times on YouTube.

Duration
6:01
Published
November 1, 2018
Views
109,908
Likes
357

Tags

Share

This tutorial in other languages