Please show all formulas

1. Use the spread sheet to calculate the annual payments for a loan of $100,000 at 5% annual interest for 10 years. Then build an amortization schedule for this loan. 2, Develop an amortization schedule for a $100,000 loan @ 5% interest where the first payment will be $4,000 and then each payment will increase by $1,000 per year until the loan is paid off. Show and state the number of years it will take to pay off this loan 0