Please SUBSCRIBE:
https://www.youtube.com/subscription_center?add_user=mjmacarty
Loan Amortization Schedule in Excel
http://alphabench.com/data/excel-amortization-tutorial.html

Download the file used by following the link above.

Calculate any loan payment here using PMT function:
https://alphabench.com/data/excel-pmt-function.html

Basic and advanced loan amortization tables in Excel. Demonstrates PMT, IPMT and PPMT functions. With visualization of balance and cumulative interest over the life of the loan. Also discusses the NPER function.

See how the finance of mortgage loans works. See the impact of extra payments on the life of the loan and total interest paid.

The file used can be downloaded at the link above.

Please take the opportunity to connect and share this video with your friends and family if you find it useful.