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

  Maintaining the same level of sales and cogs

Williams & Sons last year reported sales of $127 million, cost of goods sold (COGS) of $105 and an inventory turnover ratio of 5.

  What are three risks that may affect future exchange rates

The company is Intel. After researching where does Intel does business, share which 2-4 countries are the most important to the business.

  What is the remaining maturity of these bonds

Sure Tea Co. has issued 7.6% annual coupon bonds that are now selling at a yield to maturity of 9.1% and current yield of 9.0246%. What is the remaining maturity of these bonds? (Do not round intermediate calculations. Round your answer to 2 decim..

  What is the net cost today of the cheapest option

You have just started your first job and you want to have the basic appliances (fridge, washer, dryer, etc.) in your apartment. You face the following choices

  Determining the simple random sample

In a pulse rate research, a simple random sample of 81 men results in a mean of 75 beats per minute, and a standard deviation of 12 beats per minute. Based on the sample results, the researcher concludes that the pulse rates of men have a standard..

  How much should a couple deposit

How much should a couple deposit at the end of each month into an investing plan that pays 7.5%, compounded monthly, so that they will have 800,000 in 30 years?

  Complements and conditional probability

A homeowner finds that there is a 0.15 probability that a flashlight does not work when turned on.

  Discuss the three theoretical levels of market efficiency

Discuss the three theoretical levels of market efficiency and tell which you feel applies to the U.S markets. Explain your selection. Do you feel some securities markets around the world are more efficient than others?

  After-tax cost of debt-ll incorporated

LL Incorporated's currently outstanding 8% coupon bonds have a yield to maturity of 5.3%. LL believes it could issue new bonds at par that would provide

  Calculate the equivalent annual cost of each alternative

Blooper Industries must replace its magnoosium purification system. Quick & Dirty Systems sells a relatively cheap purification system for $12 million.

  Define which one of the following statements is correct

Which one of the following statements is correct, all else held constant?

  What is the payback period of the project

Company XYZ has spent $250,000 to develop a new product - smart beehive. The company has spent $24,000 for a market research for figuring out the expected.

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