1. Richard is 65 years old and about to retire. He has $500,000 saves to supplement his pension and social security and would like to withdraw his savings in equal dollar amounts so that nothing is left after 15 years. How much does he have to withdraw each year is he earns 5% on his money? (Excel Format)

2. Sarah Wiggum would like to make a single investment and have $2 million at the time of her retirement in 35 years. She has found a mutual fund that will earn 4 percent annually. How much will Sarah have to invest today? If Sarah invests that amount and could earn a 14 percent annual return, how soon could she retire, assuming she is still going to retire when she has $2million? (Excel Format)