*SHOW ALL WORK USING AN EXCEL SPREADSHEET*

Assume the intrest rate is 8%

o. In 2013, Picasso's painting Le Rve was sold to hedge-fund manager Steven A. Cohen for $155 million. In 1941, 72 years earlier, the same painting sold for $7,000. Calculate the rate of return on this investment. What does this suggest about the merits of fine art as an investment: Bank Loan, Bond, and Stock Problems p. How much would you pay for a 10-year bond with a par value of $1,000 and a 7 percent coupon rate? Assume interest is paid annually q. How much would you pay for a share of preferred stock paying a S5-per-share annual dividend forever? r. A company is planning to set aside money to repay $150 million in bonds that will be coming due in eight years. How much money would the company need to set aside at the end of each year for the next eight years to repay the bonds when they come due? How would your answer change if the money were deposited at the be- ginning of each year? s. An individual wants to borrow $120,000 from a bank and repay it in six equal annual end-of-year payments, including interest. What should the payments be for the bank to earn 8 percent on the loan? Ignore taxes and default risk