7. Investment companies conduct surveys of how much money most workers have in their retirement plans each year. The latest figure shows that a typical worker close to retirement age has about $300,000 in their 401 (K) plan. If they can live for another 30 years after retirement, and with typical retirement, investment earning returns of 5%, how much money can they take out each year?

Answer the questions with Excel