Do it on excel please

Q1. Your parents will retire 20 years from now. By then, in $ today (PV), they need a lump sum of $2,000,000. The annual rate of inflation for the next 20 years is 5% compounded semi- annually. There is an investment opportunity with a yield of 10% annually compounded monthly. Adjusted for inflation, what is the total fund they need by the year they become retired?

Q2. To achieve their retirement goal, how much should they deposit every month for the next 20 years? Ignore the effect of taxes