NEED TO KNOW HOW TO DO THEM IN EXCEL PLEASE

1. A loan is offered with monthly payments and a 13 percent APR. What's the loan's effective annual rate (EAR)? 2. A perpetuity pays $50 per year and interest rates are 9 percent. How much would its value change if interest rates decreased to 7.5 percent? Did the value increase or decrease? 3. If the present value of an ordinary, 6-year annuity is $8,500 and interest rates are 9.5 percent, what's the present value of the same annuity due? 4. If the future value of an ordinary, 7 -year annuity is $6,500 and interest rates are 8.5 percent, what is the future value of the same annuity due? 5. If you start making $75 monthly contributions today and continue them for four years, what is their future value if the compounding rate is 12 percent APR? What is the present value of this annuity? 6. Create the amortization schedule for a loan of $15,000, paid monthly over three years using a 9 percent APR