Find the present value of option

Assignment Help Finance Basics
Reference no: EM132648726

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!

Reference no: EM132648726

Questions Cloud

How will use qualitative analysis in giving supporting data : How you will use quantitave analysis and qualitative analysis in giving supporting data and information for the achievement of best marketing strategy.
Analyze the selected ratios profitability-financial strength : Ratio Research: Use the template to analyze the selected ratios (profitability, financial strength, valuation, management effectiveness
Describe potential benefits and challenges to training : The Department of Defense has committed considerable national resources to the establishment of a robust LVC training environment. Provide your assessment.
Make a statement of cash flow will be necessary to : 6000 in order to adjust the companies net income to a cash basis using the direct method on the statement of cash flow's it will be necessary to
Find the present value of option : You have just won first prize in a quantitative competition.
How would the discontinuation of product line b affect : Product line B appears unprofitable, and management is considering discontinuing the line. How would the discontinuation of Product line B affect net income?
What is the current price of the bond : If the yield to maturity is 7.8 percent, what is the current price of the bond?
What is the faas approach to system safety : What is the FAA's approach to system safety and air carrier certification? Watch the FAA TV: Flight Standards Service Overview video (10:00) and find out.
Describe the advantages of a retrospective rating plan : Describe the advantages of a Retrospective Rating Plan and which benefit can impact the insured the most and why?

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd