Code School for Kids

Excel's Loan Amortization

This tutorial demonstrates how to use Excel to create loan amortization table. It starts with a basic table using the IPMT and PPMT functions, and then goes through an advanced example that shows the effects of adding additional principal to the monthly payment.

You can download the file used in the video here