Click on “Click to Edit” below and then enter the amount of your debts in the A column and your interest rate in the B column, replacing the sample information already there. The E column will contain information about your total debt, the total amount of interest you pay every year, and the average interest rate on your debt. You will probably have to use the scroll bar below column D to see all the info.