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

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

80.2K

Verified Solution

Question

Advance Math

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Other questions asked by students

With using sheltered instructions what would you do as a teacher, if the student was still...

Do the Courts have too much power to make policy from the bench? Consider issues such...

Problem 6-5 (LO 3) Consolidated income statement, affiliated firm for tax. On January 1, 2015, Dawn...

The President of the United States needed the assistance of Congress to declar war in...

The work done by battery to charge an uncharged parallel plate condenser of plate separation...

According to http://www.thehcf.org/antiidlingprimer.html, Americans waste approximately 3.8 million gallons of gasoline each day by voluntarily...

Use the graph to determine the equation of the vertical asymptote 5 4 3 2...

Step 1 of 4 Find the vertex of this function y x 4 3

10. On May 1, 2019, the city of Ramtha, which reports on a calendar-year basis,...

Note: Where applicable, use the present value tables provided in APPENDICES 1 and 2 that...

For a bond issue that sells for less than its par value, the market rate...

Carla Vista Incorporated management is considering investing in two alternative production systems. The systems are...

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.