In: Finance
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 8.45 percent? (Do not round intermediate calculations and enter your answer in dollars, not millons of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.)
The present value of the windfall is calculated using the PV function as follows:-
=PV(rate,nper,pmt,fv)
=PV(8.45%,80,,1000000)
=1519.27