Reference no: EM131220549
Calculating Mutually Exclusive Projects
Trail Guides, Inc., is currently evaluating two mutually exclusive investment. After doing a scenario analysis and applying probabilities to each scenario, they have determine that the investments have the following distributions around the expected NPVs.
Profitability NPV A NPV B
15% -$40,000 -$15,000
20% -10,000 2,500
30% 20,000 20,000
20% 50,000 37,500
15% 80,000 55,000
Several members of the management team have suggested that Project A should be selected because it has a higher potential NPV. Other members have suggested that Project B appears to be more conservative and should be selected. They have asked you to resolve this question.
a. Calculate the expected NPV for both projects. Can the question be resolved with this information alone?
b. Calculate the variance and standard deviation of the NPVs for both projects. Which project appears to be riskier?
c. Calculate the coefficient of variation for both projects. Does this change your opinion from part b?
d. Calculate the probability of a negative NPV for both projects.
e. Which project should be accepted?
Can I get the solutions in Excel Format?
|
Management system for a software development project
: Describe 5 factors you would evaluate in trying to identify a database management system for a software development project.
|
|
Discuss the methodological issues and challenges
: Discuss the methodological issues and challenges that are unique to psychological research investigating effective treatments for psychological disorders - Explain the concepts of evidence-based practice and practice-based evidence and identify co..
|
|
Providing the function prototypes
: We have talk about the class declaration. That is, defining the member variables and providing the function prototypes. But what about the class definitions -- the actual implementation of the functions. Where and how can you implement the functio..
|
|
Incorporate its four basic transaction cycles
: You are part of a project management team evaluating accounting software packages that could be used by S&S (i.e., the case company referenced in Chapters 1 through 4), which would incorporate its four basic transaction cycles. Suggest five factors t..
|
|
Calculate the expected npv for both projects
: Calculate the expected NPV for both projects. - Calculate the variance and standard deviation of the NPVs for both projects. Which project appears to be riskier?
|
|
Future of technology further changing hci
: Discuss the technology's impact on social, ethical, and legal issues. How do you think the role of this technology has changed HCI since its inception? How do you see the future of this technology further changing HCI?
|
|
Assess the risks associated with integrating new ais system
: Implementing a new AIS system could prove to be beneficial or detrimental to an organization’s IT infrastructure. Assess the risks associated with integrating a new AIS system and suggest what management can do to minimize those risks.
|
|
How is architecture both a science and an art
: How is architecture both a science and an art? Are there any similarities between sculpture and architecture? Can architecture be functional and expressive?
|
|
How much total interest will sosa pay on this payment plan
: (Part Level Submission) Sosa Excavating Inc. is purchasing a bulldozer. The equipment has a price of $102,000. The manufacturer has offered a payment plan that would allow Sosa to make 15 equal annual payments of $14,185, with the first payment due o..
|