These are questions for my Financing class FIN3400. I am suppose to input the answers into an excel spreadsheet with the formulas displayed. Please help, I cannot figure out these two questions below.

1.You want to retire has a millionaire. How much do you need to put away each month if:

A.You use common stocks and have an average return of 10%?

B.You use corporate bonds and have an average return of 6%?

C.You use government bonds and have an average return of 4%?

D.You put your money in a CD at 2.5% interest rate?

(Please use your own age. If you are over 45, please solve for saving a $100,000.) - My age is 31

2.You are 30 years old today and planning to retire at age 62.You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years.

Your plan is to go live in the tropics, on the beach, and live on coconuts and fishing. Also, you need to conclude your retirement savings at age 55 because all your spare money then will be going to your children's education.

The question is how much money you will need to save each month between now and 55 so that you can quit contributing.The expected return on your investments over the whole period is 10% per year.Please ignore inflation.