Can you please show work with Excel formulas?

Q1) You invest $202 at the beginning of every year and your friend invests $202 at the end of every year. If you both earn an annual rate of return of 04.00%. a) how much will you have in your account after 31 years?

b) How much will your friend have in his account?

Q2) You currently have $4,416 in a retirement savings account that earns an annual return of 12.00%. You want to retire in 48 years with $1,000,000. How much more do you need to save at the end of every year to reach your retirement goal?

Q3) You currently owe $4,245 to your credit card that charges an annual interest rate of 20.00%. You make $106 of new charges every month and make a payment of $179 every month. What will your credit card balance be in three months?

Q4) You would like to retire in 18 years. The expected rate of inflation is 02.00% per year. You currently have a standard of living that requires $7,523 of monthly expenses. Assuming you want to maintain the same standard of living in retirement, what are your monthly expenses expected to be the first year of retirement?

Q5) You purchases a house for $414,209. You made a down payment of $20,000 and the remainder of the purchase price was financed with a mortgage loan. The mortgage loan is a 30 year mortgage with an annual interest rate of 08.00%. Mortgage payments are made monthly. What is the monthly amount of your mortgage payment?