In this video, I show how to create a loan amortization schedule in Google Sheets. This table will show the regularly scheduled payments, principal payments, and interest payments on an amortization loan such as a home loan, car loan, and personal loan. To create this table we will have to use the PMT function and IPMT function which I will also teach you in the video. Read through the full tutorial here: https://www.modernschoolbus.com/loan-...