Hello, please post the answer with the excel function used to solve the problem. Thank you.

Question 4: Employer contribution and retirement plan

(10 points)

You need to use the functions built in in excel to answer the question. Manually fill in the answer will receive 0 point

Assume you want to have $2,000,000 for your retirement when you are 65 years old. You are 25 years old now. Assume your salary is $5,500 per month and your employer will contribute 4% of your monthly salary to your retirement account every month.

How much will you need to contribute to your account every month in order to have 2,000,000 when you retire at the age of 65? Assume APR of 5%