How to Make an Amortization Table in Excel

1. Click on the 'Office' button in Excel 2007 and select 'New.'NOTE: If you do not have Excel 2007, click the 'Excel Amortization Schedule Template' link in the 'Resources' section below to download and save the amortization template. Continue to Step 4.
2. Scroll and select 'Schedules' on the left side of the template window.
3. Double-click to select and open the Amortization Schedule template that you want to use.
4. Input the 'Loan amount,' 'Annual interest rate,' 'Loan period in years,' 'Number of payments per year,' and 'Start date of loan.'
5. Press the 'Enter' key to complete each entry and see the Amortization Schedule automatically calculate in the table below.