Microsoft has provided a template for loan amortization schedules that you can open in Excel and adjust to your needs. It allows you to see how much of each payment goes toward interest and ...