FIN - Telluride Tours is currently evaluating two mutually exclusive investments

Question # 00011294 Posted By: expert-mustang Updated on: 03/31/2014 06:00 AM Due on: 03/31/2014
Subject Finance Topic Finance Tutorials:
Question
Dot Image

Telluride Tours is currently evaluating two mutually exclusive investments. After doing a scenario analysis and applying probabilities to each scenario, it has determined that the investments have the following distributions around the expected NPV.
Probability NPVA NPVB
15% -$34,000 -$12,750
20% -8,500 2,125
30% 17,000 17,000
20% 42,500 31,785
15% 68,000 46,750

Several member 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 more risky?
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 projected?
Dot Image
Tutorials for this Question
  1. Tutorial # 00010849 Posted By: expert-mustang Posted on: 03/31/2014 06:01 AM
    Puchased By: 3
    Tutorial Preview
    NPVA Projects has higher standard ...
    Attachments
    FIN_-_Telluride_Tours_Solutions.xlsx (13.72 KB)
    FIN_615_Chap_12_Problem_1.xlsx (11.78 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    Ba...tar Rating The homework was precisely done 08/09/2015

Great! We have found the solution of this question!

Whatsapp Lisa