1. Fred and Wilma are both in their eighties. Theyre thinking of selling their house for $500,000 and moving into an apartment complex for seniors. The senior complex will cost $50,000 per year, payable in full at the beginning of each year. This payment covers all of their costs (food, rent, entertainment, and medical).
   1. If they can earn 6% annually on the proceeds from their house and if they live for 10 more years, how much will they be able to leave to their children as an inheritance? Try solving this problem using a table and using Excel formulas / equations.
   2. What is the longest they can live from the apartment proceeds before the money runs out?
   3. Solve part a and b again assuming that the interest rate is 7%.