Congratulations. You have just won first prize in a quantitative competition. You have the following choices to receive your winnings: Option I: Receive $3,000,000 immediately. Option II: Receive five $1,000,000 payments paid every other year beginning in year T=2. For example, you receive a $1 million dollars payment in year T=2, T=4, T=6, T=8, and T=10. a. What is the present value of each option if R=0.06? Which option would you choose? b. What is the present value of each option if R=0.12? Which option would you choose? c. What interest rate R will make the present value of both options equal? Hint: use Excel's Data - What If - Goal Seek analysis Show what you do to se up goal seek for c Also take snap shots from excel and how did you get the answers, please show work for c!!!

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter5: The Time Value Of Money
Section: Chapter Questions
Problem 22P
icon
Related questions
Question

Congratulations. You have just won first prize in a quantitative competition. You have the following choices to receive your winnings:

Option I: Receive $3,000,000 immediately.

Option II: Receive five $1,000,000 payments paid every other year beginning in year T=2. For example, you receive a $1 million dollars payment in year T=2, T=4, T=6, T=8, and T=10.

a. What is the present value of each option if R=0.06? Which option would you choose?

b. What is the present value of each option if R=0.12? Which option would you choose?

c. What interest rate R will make the present value of both options equal? Hint: use Excel's Data - What If - Goal Seek analysis

Show what you do to se up goal seek for c

Also take snap shots from excel and how did you get the answers, please show work for c!!!

Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Present Value
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College