Reference no: EM131144603
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.
|
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% |
The following cost distribution is given:
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?
What is difference between authentication and authorization
: What is the difference between authentication and authorization? What are six problems with using operational data for BI processing? What is an SQL injection attack? What is the difference between a database and a DBMS?
|
How we as a society deal with the risk of natural disasters
: How should we, as a society, deal with the risk of natural disasters ? - What should we do differently from what we do now .
|
How do you access the templates
: You are about to create your first PowerPoint presentation and you want to utilize the default templates to help you in your slide design. How do you access the templates?
|
Do you believe that having internet access
: Do you believe that having Internet access, as the author suggests, is not a convenience or luxury, but a human right? List one benefit that closing the digital divide might provide (e.g. economic growth).
|
What is expected value of the npv for each of the projects
: What is the expected value of the NPV for each of the projects - what is the standard deviation of the NPV for each of the projects?
|
Make an evaluation of a movie
: write about movie:- summary for the movie, thesis, unlike any other movies, what kind of movie, dialogue, acting. - definition- main body- Dialogue and Explain give some example.
|
Identify system stakeholders and formulate their needs
: Identify system stakeholders and formulate their needs. Create a use case based on relating functional requirements. Use technology and information resources to research issues in systems analysis and design.
|
Create two test users for testing purposes
: Create two test users for testing purposes (that will send and receive mail), use the following commands to add user accounts and to change user's password. Use the password Password for the testuser accounts.
|
Current facility managers have learned from predecessors
: What do you think current facility managers have learned from their predecessors? What similarities and differences can you see between Madison Square Garden and Maple Leaf Gardens? Why did modern universities build major sport and recreation complex..
|