To create an amortization table or loan repayment schedule in Excel, you'll set up a table with the total loan periods in the first column, monthly payments in the second column, monthly principal ...