Question

In January 2007, the average price of an asset was $27,658. 6 years earlier, the average price was $21,008. What was the annu
Youre 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
Imprudential, Inc., has an unfunded pension liability of $800 million that must be paid in 19 years. To assess the value of t
You have just received notification that you have won the $3.5 million first prize in the Centennial Lottery. However, the pr
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1)

Function Arguments ? X RATE Nper 6 Pmto PV -21008 Fv27658 Type o 1 1 = -21008 = 27658 = 0 = 0.046901954 Returns the interest

Hence, correct option is 4.69%

*Please rate thumbs up

Add a comment
Know the answer?
Add Answer to:
In January 2007, the average price of an asset was $27,658. 6 years earlier, the average...
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 $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 $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 $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.)

  • Solve using excel commands/formula A1 You have just received notification that you have won the $1...

    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 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 80 Future value Years Interest rate 9% 10 Complete the following analysis. Do not hard code values in your answers. Your...

  • 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

  • Questions and Problems: 1. Simple Interest versus Compound Interest [LO1] First City Bank pays 9 percent...

    Questions and Problems: 1. Simple Interest versus Compound Interest [LO1] First City Bank pays 9 percent simple interest on its savings account balances, whereas Second City Bank pays 9 percent interest compounded annually. If you made a deposit of $7,500 in each bank, how much more money would you earn from your Second City Bank account at the end of eight years? 2. Calculating Future Values (LO1] For each of the following compute the future value Present Value Interest Years...

  • 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.

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