Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. on january 1, you win $50,000,000 in the state lot

On January 1, you win $50,000,000 in the state lottery. The $50,000,000 prize will be...

60.1K

Verified Solution

Question

Accounting

On January 1, you win $50,000,000 in the state lottery. The $50,000,000 prize will be paid in equal installments of $6,250,000 over eight years. The payments will be made on December 31 of each year, beginning on December 31 of this year. The current interest rate is 5.5%. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

EXCEL SHEET:
Present value of an annuity
DATA
Sum of prize $50,000,000
Annual payment $6,250,000
Number of years 8
Interest rate 5.5%
Date of win January 1
Date of payments December 31 of each year
Using formulas and cell references, perform the required analysis, and input your answer into the Amount column. Transfer the numeric result for the green entry cell (B14) into the appropriate field in CNOWv2 for grading.
Amount Formula
PV of annual payments

Determine the present value of your winnings. Round your answer to the nearest dollar.

$ _____________

Answer & Explanation Solved by verified expert
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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1. What are the advantages and dis-advantages between and ETF and a mutual fund that invests...

Finance
Q

A magazine reported the mean annual household income of its readers to be $150,000 with a...

Basic Math
Q

Does phosphorylation of a signaling protein by an upstream kinase represent a signaling input or output?...

Biology
Q

------NOTE: PRIORITY TO BE ANSWERED IS THE CONLCUSION.------- Write your introduction (This includes principles, significance of the study,...

Biology
Q

15 What is the value of sin 270 A 0 B 1 C 1 D...

Geometry
Q

A health instructor surveyed all her students and tallied the results The first survey question...

Geometry
Q

Refer to the following figure Draw the sign diagram for f and find the relative...

Algebra
Q

Bonding employees who handle cash is an example of a) Independent internal verification b) Segregation...

Accounting
Q

16 Perez Company manufactures molded candles that are finished by hand. The company developed the...

Accounting
Q

Question 3 Q:16 The 2024 income statement and comparative balance sheet of (Click...

Accounting
Q

IOU Inc. has EBIT of $58,000, depreciation and amortization of $12,000, interest expenses of $21,000,...

Accounting
Q

Assume the following Information: The throughput time (manufacturing cycle time) Is: Multiple Choice 63 hours....

Accounting