Question

You have recently won the super jackpot in the Washington State Lottery. On reading the fine...

You have recently won the super jackpot in the Washington State Lottery. On reading the fine print, you discover that you have the following two options:

a.

You will receive 31 annual payments of $310,000, with the first payment being delivered today. The income will be taxed at a rate of 28 percent. Taxes will be withheld when the checks are issued.

Calculate PV of winnings assuming 7% discount rate

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

File Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum Calibri ー E ゴWrap Text General ta copy ▼ в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Font Alignment Number Styles Cells GR230 GP GQ GR GS GT GU GV GW GX GY GZ 216 217 218 219 220 221 IT IS A CASE OF PRESENT VALUE OF ANNUITY DUE USING EXCEL PMT YEARS RATE TAX RATE NET PMT USING FORMULA 310000 31 7% 28% PV- A/r (1-1/(1+r)An)*(1+r) PV 223200/0.07 (1-1/(1+0.07)A31) (1+0.07) PV-$ 29,92,897.99 223 224 225 226 227 228 229 230 231 232 233 234 /4 | CALCULATOR , LOAN OPTIONS 223200 310000 (1-0.28) PRESENT VALUE $29,92,897.99 PV(GR222,GR221,-GR224,,1) CAP STRU VALUE BOX DILUTION DOLLAR COST AVG -MORTGAGE.. EXPO Sheet1 . Sheet2. Sh rences: x261 福 130% 08:50 19-01-2019

Add a comment
Know the answer?
Add Answer to:
You have recently won the super jackpot in the Washington State Lottery. On reading the fine...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have recently won the super jackpot in the Washington State Lottery. On reading the fine...

    You have recently won the super jackpot in the Washington State Lottery. On reading the fine print, you discover that you have the following two options: a. You will receive 31 annual payments of $340,000, with the first payment being delivered today. The income will be taxed at a rate of 28 percent. Taxes will be withheld when the checks are issued. b. You will receive $620,000 now, and you will not have to pay taxes on this amount. In...

  • You have recently won the super jackpot in the Washington State Lottery. On reading the fine...

    You have recently won the super jackpot in the Washington State Lottery. On reading the fine print, you discover that you have the following two options: a. You will receive 32 annual payments of $220,000, with the first payment being delivered today. The income will be taxed at a rate of 25 percent. Taxes will be withheld when the checks are issued. b. You will receive $635,000 now, and you will not have to pay taxes on this amount. In...

  • Submitted Problem 4-54 Calculating Annuities You have recently won the super jackpot in the Washington State...

    Submitted Problem 4-54 Calculating Annuities You have recently won the super jackpot in the Washington State Lottery. On reading the fine print, you discover that you have the following two options. 12 points awarded a. You will receive 31 annual payments of $200,000, with the first payment being delivered today. The income will be taxed at a rate of 28 percent Taxes will be withheld when the checks are issued Scored b. You will receive $615,000 now, and you will...

  • You have just won the Georgia Lottery with a jackpot of $37,000,000. Your winnings will be...

    You have just won the Georgia Lottery with a jackpot of $37,000,000. Your winnings will be paid to you in 26 equal annual installments with the first payment made immediately. If you feel the appropriate annual discount rate is 11%, what is the present value of the stream of payments you will receive?

  • You have just won the NC Lottery with a jackpot of $40,000,000. Your winnings will be...

    You have just won the NC Lottery with a jackpot of $40,000,000. Your winnings will be paid to you by dividing the $40,000,000 into 26 equal annual installments with the first payment made immediately. If you feel the appropriate annual discount rate is 4.7%, what is the present value of the stream of payments you will receive? $22,816,344 $23,888,712 $23,295,080 $24.703,188

  • Suppose you have just won a $5 million lottery today. When you win the lottery, you...

    Suppose you have just won a $5 million lottery today. When you win the lottery, you generally receive payments of the lottery jackpot over twenty years. Therefore, your $5 million lottery winnings consist of twenty annual payments of $250,000 each. But wait! Don’t forget about the taxes. The IRS will take 25 percent of each check, so you are left with $187,500 each year. Assume that the annual interest rate is 3%. So, if someone offered you a lump-sum of...

  • Suppose you have just won a $5 million lottery today. When you win the lottery, you...

    Suppose you have just won a $5 million lottery today. When you win the lottery, you generally receive payments of the lottery jackpot over twenty years. Therefore, your $5 million lottery winnings consist of twenty annual payments of $250,000 each. But wait! Don’t forget about the taxes. The IRS will take 25 percent of each check, so you are left with $187,500 each year. Assume that the annual interest rate is 3%. So, if someone offered you a lump-sum of...

  • Your recently lost a demand in kansas satet court. After reading the fine print you discovered you have the following t...

    Your recently lost a demand in kansas satet court. After reading the fine print you discovered you have the following two options to pay: a) you will have to do 31 annual payments of 250000 with the first payment being delivered today. b) you will have to pay 530000 now. In addition beginning one year from today, you will pay 200000 each year for 30 years. Using a discount rate of 5.85 percent, witch option should you select? Explain answer.

  • You have won the lottery. You will receive $2,550,000 today, and then receive 40 payments of...

    You have won the lottery. You will receive $2,550,000 today, and then receive 40 payments of $1,275,000 These payments will start one year from now and will be paid every six months. A representative from Greenleaf Investments has offered to purchase all the payments from you for $20 million. The appropriate discount rate is an APR of 10 percent compounded daily. Assume there are 12 months in a year, each with 30 days. What is the present value of the...

  • You have just won $20,000 in the state lottery, which promises to pay you $1,000 (tax...

    You have just won $20,000 in the state lottery, which promises to pay you $1,000 (tax free) every year for the next twenty years. The interest rate is 5%. In reality, you receive the first payment of $1,000 today, which is worth today. (Round your response to the nearest penny) The value of the second $1,000 payment is worth Stoday (Round your response to the nearest penny) Your total lottery winnings are actually worth $20,000 to you today

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT