Clients have asked you to help them plan for their retirement savings. The couple has just turned 50, and would like to retire on their 67th Birthday. They have saved the maximum in their 401k retirement plans since they became eligible. The sum of their various retirement investments is currently $700,000. The couple anticipates that either the husband or wife is likely to live until the age of 95. They would like to withdraw $100,000 at the beginning of each year during the first 10 years of retirement and $75,000 at the beginning of each year thereafter. Based on the mix of assets held by your clients, and historical returns for similar investments, you estimate an average annual rate of return of 7% on retirement fund assets both during the period of savings and during retirement. Required: A. Compute the value of invested assets this couple will need to hold in their retirement savings account at their retirement date in order to meet their anticipated withdrawals during retirement. B. Compute the amount that this couple will need to place in their retirement savings account during each of the years until retirement in order to meet this retirement savings goal. Excel Formulas must be used