Question: How do I code this in excel? You have just received notification that you have won the $1 million first prize in the Centennial Lottery.

How do I code this in excel? How do I code this in excel? You have just received notification

You have just received notification that you have won the $1 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday (assuming you're around to collect), 80 years from now. What is the present value of your windfall if the appropriate discount rate is 9 percent? $ 1,000,000 Future value Years Interest rate 80 9% Complete the following analysis. Do not hard code values in your answers. Your answer should be a positive value. Present value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

you have just received notification that you have won 3 million first prize in the centennial lottery. however the prize will be awarded on your 100th birthday, 60 years from now. what is the present...

Calculating Present Values [LO2] You have just received notification that you have won the 1 million first prize in the Euro Lottery. However, the prize will be awarded on your 100th birthday...

DONT USE EXCEL TO SOLVE ANYTHING, use relevant formulas to solveeach question.1. You have just received notification that you have won the $1million first prize in the Centennial Lottery. However, 1...

You have just received notification that you have won the $600,000 first prize in the Centennial Lottery to be awarded on your 100th birthday, which is 70 years from now. However, you have an option...

You have just received notification that you have won the $ 6 3 , 0 0 0 , 0 0 0 . 0 0 first prize in the Centennial Lottery. However, the prize will be awarded 1 0 years from now. What is the present...

You have just received notification that you have won the $2million first prize in the Centennial Lottery. However, the prizewill be awarded on your 100th birthday (assuming you??re around tocolle 2...

You have just received notification that you have won the $ 1 M first prize in the Lottery. However, the prize will be awarded on your 1 0 0 * birthday ( assuming you are around to collect ) ; 8 0...

You have just received notification that you have won the $2 million first Centennial Lottery. However, the prize will be awarded on your 100th birthda you're around to collect), 79 years from now....

i need the way to put it in excel You have just received notification that you have won the $1 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday...

You have just received notification that you have won the $2 million f Centennial Lottery. However, the prize will be awarded on your 100 th birt you're around to collect), 76 years from now. What is...

You are interested in pricing European and American put options on a stock using a four-period binomial model with notation and set-up as in Chapter 10 of the text. So = 20, u = 1.2, d = 0.82, h = 1,...

What motivated congress to pass the Sarbanes-Oxley Act (SOX) of 2002?

41. Dividend yield is the annual dividend paid by a company expressed as a percentage of the price of the stock (Dividend/Stock Price 100). The dividend yield for the Dow Jones Industrial Average...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

1. Why was data management so problematic at ARI? Automotive Resources International, better known as simply ARI, is the worlds largest privately-held company for vehicle fleet management services....

5-19 What is the total cost of ownership of technology assets and what are its cost components?

5-16 Compare the BYOD experiences of IBM and Intel. Why did BYOD at Intel work so well? Just about everyone who has a smartphone wants to be able to bring it to work and use it on the job. And why...