Learn more:- https://www.exceltutorial.net/

Financial Functions Playlist:- https://youtube.com/playlist?list=PLhvn6aQRdimXjKB1EOoRWznYZtqRe7B2z

Many of us have a PPMT function in Excel and it may not be the most used function. PPMT is short for Principal Payments - Maturing Term, which means that PPMT calculates the principal part of payments.

The PPMT function in Excel is perfect for calculating mortgage loans or car loan payment plans.

In this video we will learn how to use PPMT Function in Excel to calculate a monthly payment on a mortgage loan with no downpayment.

Following is the syntax of PPMT Function;

= PPMT(rate, nper, pmt, pv)

Where;

• rate is the annual interest rate of the loan

• nper is the total number of monthly payments to be made on the loan

• pmt is the principal payment each month

• pv stands for present value, which is the loan amount.

The PPMT Function in Excel can be used to calculate a monthly payment on your mortgage with no downpayment and at anytime during a 30-year fixed rate term you can change the amortization schedule by adding or subtracting payments as well as changing from month to month payment plans.

Table of Content;

00:00 INTRODUCTION 00:20 PPMT Function in Excel 03:00 conclusion

Other Playlists:-

Cell References in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVC65nzr2BebSN9kPSdK6qH

Logical Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimWBCKHNrLEqubXDMaHeINU1

Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW

Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz ... https://www.youtube.com/watch?v=6qCfKlyYQOk