PLEASE explain how to solve using excel, please show formulas.

Challenge question. In the chapter text, we dealt exclusively with a single lump sum, but often we may be looking at several lump-sum values simultaneously. Let's consider the retirement plan of a couple. Currently, the couple has four different investments: a 401 (k) plan, two pension plans, and a personal portfolio. The couple is 9 years away from retirement. They believe they have sufficient money in their plans today so that they do not have to contribute to the plans over the next 9 years and will still meet their $2 million retirement goal. Here are the current values and growth rates of their plans: 401(k):$89,000growingat7%.PensionPlanOne:$342,000growingat8%.PensionPlanTwo:$192,000growingat7.75%.PersonalPortfolio:$155,000growingat8.75%. Does the couple have enough already invested to make their goal in 9 years? Hint: View each payment as a separate problem, and find the future value of each lump sum 9 years from now. Then add up all the future values. What is the value of the 401(k)9 years from now? $ (Round to nearest cent.)