Hello! If possible can you please teach me in excel formulas? You have recently won the super...

80.2K

Verified Solution

Question

Advance Math

Hello!
If possible can you please teach me in excel formulas?
You have recently won the super jackpot in the Washington StateLottery. On reading the fine print, you discover that you have thefollowing two options:
Â Â
a.
You will receive 30 annual payments of $270,000, with the firstpayment being delivered today. The income will be taxed at a rateof 30 percent. Taxes will be withheld when the checks areissued.
b.
You will receive $550,000 now, and you will not have to paytaxes on this amount. In addition, beginning one year from today,you will receive $220,000 each year for 29 years. The cash flowsfrom this annuity will be taxed at 30 percent.
Using a discount rate of 6 percent, what is the present value ofyour winnings for each option?
Thank you!
Autumn

Answer & Explanation Solved by verified expert

3.7 Ratings (664 Votes)

Computation of present value of annuity factor The formula for present value of annuity factor 1 PVF R where PVF 1 1i n and R Discount rate in PVF is calculated See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

a.	You will receive 30 annual payments of $270,000, with the firstpayment being delivered today. The income will be taxed at a rateof 30 percent. Taxes will be withheld when the checks areissued.

b.	You will receive $550,000 now, and you will not have to paytaxes on this amount. In addition, beginning one year from today,you will receive $220,000 each year for 29 years. The cash flowsfrom this annuity will be taxed at 30 percent.