Question
Solve using excel commands/formula
A1 You have just received notification that you have won the $1 million first prize in the Centennial Lottery. However, the p
0 0
Add a comment Improve this question Transcribed image text
Answer #1

(1+i/n)Ant PV: FV r rate per period Present value1,013.63 $1000,000 (1+9%)^(80)

Add a comment
Know the answer?
Add Answer to:
Solve using excel commands/formula A1 You have just received notification that you have won the $1...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have just received notification that you have won the $2 million first prize in the...

    You have just received notification that you have won the $2 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. points What is the present value of your windfall if the appropriate discount rate is BA percent? (Do not found Intermediate calculations and round your answer to 2 decimal places, e.g. 32.16.) eBook Present value Print References

  • You have just received notification that you have won the $3 million first prize in the...

    You have just received notification that you have won the $3 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday (assuming you're around to collect), 61 years from now. What is the present value of your windfall if the appropriate discount rate is 6 percent? Multiple Choice $172,252.68 O $78,931.67 o $87,511.20 o $85,795.30 o o $84,079.39

  • Problem 5.11 Calculating Present Values (LO2 You have just received notification that you have won the...

    Problem 5.11 Calculating Present Values (LO2 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), 71 years from now. What is the present value of your windfall if the appropriate discount rate is 9 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Present value

  • You have just received notification that you have won the $1 million first prize in the...

    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), 71 years from now.    What is the present value of your windfall if the appropriate discount rate is 9 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)   

  • You have just received notification that you have won the $2 million first prize in the...

    You have just received notification that you have won the $2 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday (assuming you’re around to collect), 67 years from now.    What is the present value of your windfall if the appropriate discount rate is 9 percent? (Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.)

  • You have just received notification that you have won the $1.25 million first prize in the...

    You have just received notification that you have won the $1.25 million first prize in the Centennial Lottery. However, the prize will be awarded on your 100th birthday, 79 years from now. The appropriate discount rate is 6.4 percent. What is the present value of your winnings?

  • You just received notification that you have won the 1.25 million first prize in the centennial...

    You just received notification that you have won the 1.25 million first prize in the centennial lottery. However, the prize will be awarded on your 100th birthday, 79 years from now. The appropriate discount rate is 6.4 percent. What is the present value of your winnings

  • You have just been notified that you have won the $2 million lottery! The prize will...

    You have just been notified that you have won the $2 million lottery! The prize will be awarded on your 100th birthday which is 80 years from now. If the current discount rate is 5%, what is the present value of your windfall? Show your work.

  • 1. You have just received notification that you have won the $2 million first prize in...

    1. You have just received notification that you have won the $2 million first prize in the Monarch Lottery. However, the prize will be awarded on your 55th birthday, 34 years from now. The appropriate discount rate is 8% What is the present value of your winnings? A $69,598.77 B $146,090.61 C $147,698.22 D $133,333.33 E $142,000.00 2. The difference between an investment's market value and its cost is the __? A net present value B profitability index C internal...

  • In January 2007, the average price of an asset was $27,658. 6 years earlier, the average...

    In January 2007, the average price of an asset was $27,658. 6 years earlier, the average price was $21,008. What was the annual increase in selling price? O 5.16% O -4.48% O 4.69% O 4.22% O 5.63% You're trying to save to buy a new $220,000 Ferrari. You have $33,000 today that can be invested at your bank. The bank pays 6.0 percent annual interest on its accounts. How long will it be before you have enough to buy the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT