Find expected value of npv for each of the projects find

Reference no: EM13393106

Your company asked you to evaluate two potential projects. These projects are active for 10 years and have no salvage life. Both have the same upfront costs, but the revenue stream from each of the projects is subject to variation, so risk is involved.

You are given the following information:
Firm's cost of capital: 10%
Each project will require three years of investment before revenues are generated.
The following cost distribution is given:

	Probability of Outcome	Year 1 Investment Costs	Year 2 Investment Costs	Year 3 Investment Costs	Expected Annual Revenues in Year 4	Expected Rate of Increase in Annual Revenues
Project 1
Outcome A	20%	$1,000	$2,000	$1,000	500	2%
Outcome B	40%	$1,000	$2,000	$1,000	650	3%
Outcome C	40%	$1,000	$2,000	$1,000	850	4%
Project 2
Outcome A	10%	$1,000	$2,000	$1,000	675	2%
Outcome B	50%	$1,000	$2,000	$1,000	700	2.40%
Outcome C	40%	$1,000	$2,000	$1,000	725	2.80%

In a new worksheet in Excel, answer the following:
1. What is the expected value of the NPV for each of the projects?
2. What is the standard deviation of the NPV for each of the projects?
3. What is the coefficient of variation of the NPV for each of the projects?
4. Which project has a higher expected return? Which has more risk?
5. Which one would you recommend to your company? How does its attitude toward risk affect your answer?

Reference no: EM13393106

Questions Cloud

Write down the key attributes of the transformational style : change is considered by many as the new normal. effective change management must be part of an organizations dna. an

What are the advantages in using a computer spreadsheet : explain why no single approach will always work in a complex and competitive business world.what are the advantages in

Understanding supply chain and how the consumer can play a : understanding supply chain and how the consumer can play a critical role in the supply chain is an important part of

What is comparative advantage and how does it affect : nbspnbspnbsp what is comparative advantage and how does it affect businesses? nbspnbspnbsp what is the difference

Find expected value of npv for each of the projects find : your company asked you to evaluate two potential projects. these projects are active for 10 years and have no salvage

What is the breakeven point what decisions does the : what is the breakeven point? what decisions does the breakeven point help an organization to make?what financial

Three recent graduates of the computer science program at : 1.three recent graduates of the computer science program at the university of tennessee are forming a company that will

Which of the given is the total requirement uby sing an mrp : which of the following is the net requirement using an mrp program if the gross requirement is 10000 and the inventory

Develop a written proposal outlining a specific product or : develop a written proposal outlining a specific product or service idea you have as the product manager for triangle

User Account

All Pages