Jack and Mary are both in their eighties. They're thinking of selling their house for $600,000 and moving into an apartment complex for seniors. The senior complex will cost $60,000 per year, payable in full at the beginning of each year. This payment covers all of their costs (food, rental, entertainment, and medical). Answer the following questions using two methods: i) setting up a proper table, ii) using an Excel function a. 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 the FV function) b. What is the longest they can live from the apartment proceeds before the money runs out? (try the NPER function) c. Repeats parts (a) and (b) above assuming that the interest rate is 7%. What do you conclude? Make sure you build a model that looks good in addition to being correct