I need help with the retirement comparison.Assume that your 401k investments will earn a 3.5% APR, compounded quarterly.The college grad will set aside 10% of quarterly gross income for 401k investment with 30% matching funds from the employer. The high school grad just has the 10% of quarterly gross income with no matching funds.What do you put into excel to determine the balance on the 401k after 35 years of investment for you and the high school grad's income. If financial planners recommend having at least $700,000 in funds when you retire, how many years would it take each of you to reach that $700,000.

The college grad (you) has $75,510 annual median salary, while the high school grad has $35,000 median annual income.