CAN YOU ANSWER SHOWING WORK NOT ON EXCEL

1. Answer the following questions assuming the interest rate is 8 percent.

Time Value of Money Problems

j. An investment costs $750,000 today and promises a single payment of $11.2 million in 23 years. What is the promised rate of return, IPR, on this investment?

k. What return do you earn if you pay $22,470 for a stream of $5,000 payments lasting ten years? What does it mean if you pay less than $22,470 for the stream? More than $22,470?

l. An investment promises to double your money in five years. What is the promised IRR on the investment?

m. The projected cash flows for an investment appear below. What is the investments IRR?

year	0	1	2	3	4	5
Cash flow	-$460	-28	75	160	280	190

n. In 1987, a Van Gough painting, Sunflowers (not reputed to be one of his best), sold at auction, net of flees, for $36 million. In 1889, 98 years earlier, the same painting sold for $125. Calculate the rate of return to the seller on this investment. What does this suggest about the merits of fine art as an investment?