on excel please

TE D Please set up the data sections below and find the solution to the 3 questions, Present Value of an Annuity Question Great news! You have made it to retirement! Unfortunately there is some bad news too. The doctors have found that you have a rare illness known as a "brain cloud" and that you have exactly ten years to live (they think). The silver lining is that this "brain cloud" has no symptons so you can live in great health until the day you pass on. Assuming you have a retirement nest egg of $740,000, sitting in an account that returns 7% annual interest annually, will you be to exhaust your account if you take out $110,000 every year by the time your mind clouds" over? (Notice that this is an annuity of ten equal payments. Data Section Future Value of an Annuity Question You start a new job which offers a 401k retirement plan in which you may deposit $3,000 per year. You like the job and think you may stay a while so you start the plan. How much will your retirement plan be worth in 25 years if your annual return is 8%? 1 2 Data Section 4 5 6