Please answer correctly in Excel Thnx if not do so

What is the accumulated amount of a 10-year annuity paying P 1,744at the end of each year, with interest at 4% compounded annually? AP 15,746debt is to be paid off in eight equal quarterly payments at 3% compounded quarterly. What should be the amount of each payment if payments are done every beginning of the month