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

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

If you're looking for a way to create a loan amortization schedule in Excel, look no further! In this tutorial, we will show you how to do it with ease. Loan amortization is the process of paying off a loan over time through regular payments.

This spreadsheet will calculate your monthly payment, as well as how much of your payment goes towards interest and how much goes towards principal. Let's get started!

We Will use the following functions to create Loan Amortization schedule;

PMT Function

IPMT Function

PPMT Function

PMT Function Syntax:

= PMT ( rate, nper, pv, type)

Where;

rate is the loan's annual interest rate expressed as a decimal.

nper is the number of payments to make on the loan.

pv is the loan amount.

type is 0 for a loan payment that's due at the beginning of the period, and -l for a loan payment that's due at the end of the period.

For this tutorial we will use rate = .06, nper = 360, pv = 10000, type=0

IPMT Function Syntax:

= IPMT ( rate, per, pv, type)

Where;

rate is the loan's annual interest rate expressed as a decimal.

per is the number of payments between now and when the loan begins to be repaid.

pv is the loan amount.

type is 0 for an interest payment that's due at the beginning of the period, and -l for an interest payment that's due at the end of the period.

For this tutorial we will use rate = .06, per=12, pv=10000, type=0

PPMT Function Syntax:

= PPMT ( rate,per, pv, type)

Where;

rate is the loan's annual interest rate expressed as a decimal.

per is the number of payments between now and when the loan begins to be repaid.

pv is the loan amount.

type is 0 for a payment that goes towards principal at the beginning of each period, and -l for a payment that goes towards principal at the end of each period.

Table of Content;

00:00 INTRODUCTION 00:40 Loan Amortization Schedule 08:40 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=ntocCtVaTFU