Association to compute the payout

Required: On March 17, 2016 you won $527.25 million in the Powerball Lottery. The Multi- State Lottery Association gave you the choice of 30 equal annual payments with the first payment of $17.575 million due on the day you claimed your prize. The remaining 29 payments follow at one year intervals. Alternatively, you can elect to take as a lump sum payout on the day you claim your prize.

Required:

1. 1. In general, how would you decide between future annual payments and a lump sum payout?
2. 2. Determine the lump sum payout that you would be offered if the Multi-State Lottery association uses a discount rate of 4%.
3. 3. Assuming that the total payments remain unchanged, would you prefer that the payments increase, decrease or remain constant through time? Explain your response.
4. 4. Assume instead the Lottery has offered you a payment of $21.7 million on the day you claim your prize and 19 additional payments at one year intervals each increasing by 2%. Prepare an Excel spread sheet to answer the following questions. In order to receive credit for your answers, you must attach a copy of your spreadsheet using the “show formulas” option. You must also use Excel’s NPV function to calculate the present values.
   1. a. Calculate the 19 additional annual payments using the future value formula.
   2. b. Assuming a discount rate of 2%, calculate the lump sum payout you would receive. How do you know this answer is correct?
   3. c. Assuming a discount rate of 4% determine the lump sum payout.
   4. d. Assuming a discount rate of 8% determine the lump sum payout.
   5. e. Assuming the Multi-State Lottery Association offer you a lump sum payout of million, determine the discount rate used by the Multi-State Lottery Association to compute the payout. Round your answer to the nearest percent.