2) You borrow $15,000 at 5% interest to finance the purchase of a used car. You must pay back the loan in equal annual installments in four years. Create the loan amortization table. The top of page 178 of the text has an excellent example. Note, the first step is to calculate your annual payment using the PMT financial formula in Excel