Time value and discount rates

a) You just won a lottery that promises to pay you $8,000,000 exactly 10 years from today. A company approaches you today, offering cash in exchange for your winning lottery ticket. What is the least you will sell your claim for if you can earn the following rates of return on similar-risk investments during the 10-year period? (1) 3% (2) 6% (3) 9%.

b) Rework part a under the assumption that the $8,000,000 payment will be received in 15 rather than 10 years.

c) On the basis of your findings in parts a and b, discuss the effect of both the size of the rate of return and the time until receipt of payment on the present value of a future sum.

**Please use Excel, show formulas