Please complete the following problems in Excel. Please show ALL calculations to arrive at the answer.

Determine the market price of a $500,000, ten-year bond issue with a yield of 12% and pays interest of $50,000 at the end of each year.

Compute the amount that a $40,000 investment today would accumulate at 10% by the end of 6 years.

Tom wants to retire at the end of this year (2014). His life expectancy is 20 years from his retirement. Tom has come to you, his CPA, to learn how much he should deposit on December 31, 2014 to be able to withdraw $60,000 at the end of each year for the next 20 years, assuming the amount on deposit will earn 8% interest annually.