1. using a spread sheet, calculate the annual payments on a loan for $100,000, 10-year loan, 5% per year interest. then build an amortization schedule for this loan. 2. develop an amortization for a $100,000 loan, 5% interest, the annual payments will begin at $4,000 and increase by $1,000 per year until the loan is paid. then answer this question: how many years will it take to pay off this loan?