2-4 needs to be done in excel to show the formulas if possible

2. One of your customers is delinquent on his accounts payable balance. You have mutually agreed to a repayment schedule of $400 per month. You will charge 1.3% per month intereston the overdue balance. If the current balance is $12,815, how long will it take for the account to be paid off? (Show the answer in months with two decimals.) 3. Suppose a small business borrows $20,000 for four years at 7.5%. The loan agreement calls for the company to pay the interest on the loan balance each year and to pay back the principal in four equal payments. Prepare an amortization schedule for the loan. How much interest will the company pay over the life of the loan? (Show the dollar amounts in dollars and cents.) 4. Elmo wants to buy a car that costs $30,000. He plans to pay $5,000 as a down payment and finance the rest. The dealer's bank quotes an interest rate of 3.9% APR for a 72-month loan with equal monthly payments. What will Elmo's monthly payment be? (Show the answer in dollars and cents.) What is the effective annual rate on the loan? (Show the answer as a percentage with two decimals.)