Using excel (show how to input information to get the answer).

You are 30 years old and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and then die dead broke. You determine that you will need $3000 per month for the 35 years. At age 62, you plan to go live in the tropics on the beach and live on coconuts, rum and fishing. You need to conclude your retirement savings at age 55 because all your spare money then will go to your kids education. Ignore inflation.

The question is how much money do you need to save each month between now and 55 so that you can quit contributing and have enough money for the $3000 per month starting at age 62. The expected return on your investments over the whole period is 10% per year.