View the step-by-step solution to:

Question

ACCT: 2100 Introduction to Financial AccountingSpring 2016Chapter 9 Take-Home QuizRequired: On March 17, 2016 you

won $527.25 million in the Powerball Lottery. The MultiStateLottery Association gave you the choice of 30 equal annual payments with the firstpayment of $17.575 million due on the day you claimed your prize. The remaining 29 paymentsfollow at one year intervals. Alternatively, you can elect to take as a lump sum payout on theday you claim your prize.Required:1. In general, how would you decide between future annual payments and a lump sum payout?2. Determine the lump sum payout that you would be offered if the Multi-State Lotteryassociation uses a discount rate of 4%.3. Assuming that the total payments remain unchanged, would you prefer that the paymentsincrease, decrease or remain constant through time? Explain your response.4. Assume instead the Lottery has offered you a payment of $21.7 million on the day you claimyour prize and 19 additional payments at one year intervals each increasing by 2%. Preparean Excel spread sheet to answer the following questions. In order to receive credit for youranswers, you must attach a copy of your spreadsheet using the “show formulas” option. Youmust also use Excel’s NPV function to calculate the present values.a. Calculate the 19 additional annual payments using the future value formula.b. Assuming a discount rate of 2%, calculate the lump sum payout you would receive.How do you know this answer is correct?c. Assuming a discount rate of 4% determine the lump sum payout.d. Assuming a discount rate of 8% determine the lump sum payout.e. Assuming the Multi-State Lottery Association offer you a lump sum payout of$334.15 million, determine the discount rate used by the Multi-State LotteryAssociation to compute the payout. Round your answer to the nearest percent.

ACCT: 2100 Introduction to Financial Accounting Spring 2016 Chapter 9 Take-Home Quiz 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. In general, how would you decide between future annual payments and a lump sum payout? 2. Determine the lump sum payout that you would be offered if the Multi-State Lottery association uses a discount rate of 4%. 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. 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. a. Calculate the 19 additional annual payments using the future value formula. b. Assuming a discount rate of 2%, calculate the lump sum payout you would receive. How do you know this answer is correct? c. Assuming a discount rate of 4% determine the lump sum payout. d. Assuming a discount rate of 8% determine the lump sum payout. e. Assuming the Multi-State Lottery Association offer you a lump sum payout of $334.15 million, determine the discount rate used by the Multi-State Lottery Association to compute the payout. Round your answer to the nearest percent.
Background image of page 1
Sign up to view the entire interaction

Top Answer

View the full answer
Answer to 3 and 4.xlsx

Question Three
$527.25
3.24339751 PVIF
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56
$162.56...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online