This video deomonstrates Microsoft Excel’s ability to easliy create an amortization table based on a standard loan. I use a home loan to create the table and reiterate its value by increasing the payment to see how many years a removed from the backend of the loan.

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