Question

In: Finance

just won the lottery and has been given the choice of two payout options: Option #1:...

just won the lottery and has been given the choice of two payout options:

Option #1: He can receive $31,250 every six months for sixteen years.

Option #2: He can wait and receive $33,750 every six months for sixteen years with the first payment coming one and a half years from now.

The appropriate discount rate is 9 percent compounded semiannually.

present value of option 1? 2? and what option should be chosen and why?

Solutions

Expert Solution

Ans:- we will use the PV function of excel to find the Present value of annuities.

For:- option 1, Rate=9%/2, Nper=16*2, Pmt=-$31,250, FV=0

For:- Option 2, Rate=9%/2, Nper=16*2, Pmt=-33,750, FV=0, TYPE=1

Note:- In excel formula we put TYPE=0, when investment or withdrawal is made at the end of the period and TYPE=1, when investment or payment is made at the start of of the period. In option 2 we have assumed that withdrawal is made at the start of the period.

Present Value of Option 2 is calculated by Future Value / (1+r)^n, where r is the interest rate per period and n is the number of periods.

From the above analysis it clear that option1 should be chosen because it has a higher PV value than option 2.


Related Solutions

You just won a lottery. There are two payout options for you: Option 1: a lump...
You just won a lottery. There are two payout options for you: Option 1: a lump sum payment of $500,000 today; Option2: a payment of $20,000per year for the next thirty years(starting from next year until the end of the 30th year) If the required return is 5%, then what's the NPV of choosing the first payout option for winning this lottery? Hint: Please regard the(present) value of the second option as opportunity costs in this calculation.
Howie just won a law suit and has been given the choice of two payout options
Howie just won a law suit and has been given the choice of two payout options Option 1: He can receive \$25,000 every six months for twenty years. Option 2: He can wait and receive 527, 000 every six months for twenty years with the first payment coming one and a half years from now. The appropriate discount rate is 9 percent compounded semiannually Which option should be chosen ? Why should that particular option be chosen?
Jesse just won the state lottery. He has been given the option of receiving either $62.9...
Jesse just won the state lottery. He has been given the option of receiving either $62.9 million today or $5 million a year for the next 35 years, with the first payment paid today. Describe the process that Jesse should use to determine which payment option he prefers. Ignore all taxes and assume that Jesse will live for at least 40 more years.
Tony just won the actuarial lottery. He is allowed to select one of three payout options...
Tony just won the actuarial lottery. He is allowed to select one of three payout options in order to collect his winnings:(A) $575,000 payable six months from today.(B) $300,000 today plus an additional $300,000 payable two years from today.(C) $20,500 paid at the beginning of each six-month period for 40 years (with the first payment coming six months later).The nominal rate of interest, convertible semiannually, is 8%. Select the option (A, B, or C) that results in the highest present...
Juan just won $2.5 million in the state lottery. He is given the option of receiving...
Juan just won $2.5 million in the state lottery. He is given the option of receiving a total of $1.3 million now, or he can elect to be paid $100,000 at the end of each of the next 25 years. If Juan can earn 5% annually on his investments, from a strict economic point of view, which option should he take? Explain why.
You have just won the Kryshak lottery and you are given the following options to receive...
You have just won the Kryshak lottery and you are given the following options to receive your winnings: 1. A lifetime annuity of $480,000 per year, with the first payment occurring one year from today. Your life expectancy is 40 years. (You will receive 40 payments) 2. A payment of $461,050 per year for 30 years (30 payments) with the first payment made immediately. 3. $7,945,000 five years from now. If your opportunity cost is 9%, which should you pick...
Manuel just won the lottery and the prize was $ 1 million. You have the option...
Manuel just won the lottery and the prize was $ 1 million. You have the option of receiving a lump sum of $ 312,950 or $ 50,000 per year for the next 20 years. If Miguel can invest the single amount at 9% or invest the annual payments at 7%; Which one should I choose? a. one-time amount of 312,950 b. b. annual payments of 50,000
You are considering two different payment plans for the lottery you just won. Option 1 pays...
You are considering two different payment plans for the lottery you just won. Option 1 pays $10,000 today and Option B pays $20,000 at the end of ten years. Assume you can earn 6.5 percent on your savings. Which option will you choose if you base your decision on present values? Which option will you choose if you base your decision on future values? Explain why your answers are either the same or different..
Your girlfriend just won the Florida lottery. She has the choice of $50,000,000 today or a...
Your girlfriend just won the Florida lottery. She has the choice of $50,000,000 today or a 20-year annuity of $3,850,000, with the first payment coming one year from today. If the mutual fund of hers provides 4% of return each year for the next 20 years, which payment option is more attractive to her? a.   $50,000,000 b.   20-year annuity of $3,850,000 c.   The two are the same d.   Could not tell
Reese Feldman just found out he won $2,500,000 from the lottery. He has two options for...
Reese Feldman just found out he won $2,500,000 from the lottery. He has two options for receiving the prize. First, if he takes the money today, the state and federal government will take out 40% immediately. His second option is to receive a payout of 20 equal installments of $145,000 with the first payment occurring when Reese turns in the winning ticket. Each of these payments will be taxed at a combined state and federal rate of 27%. Assuming Reese...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT