Question

Financial Management Please use formula and get calculation in detail. Acme industries is considering a proposed...

Financial Management

Please use formula and get calculation in detail.

Acme industries is considering a proposed project whose estimated NPV is $12million.This estimate assumes that economic conditions will be average. However, the CFO wanted to do a scenario analysis and obtained the following results:

Economic Situation       Probability NPV

Recession 5% -$70 million

Below Average 20% -$20 million

Average 50%   $12 million

Above Average 20% $20 million

Boom 5% $30 million

Calculate the project’s expected NPV, standard deviation, and coefficient of variation. For the standard deviation please use MS Excel.

Homework Answers

Answer #1

Solution :-

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Financial Management Please use formula and get calculation in detail. Acme industries is considering a proposed...
Financial Management Please use formula and get calculation in detail. Acme industries is considering a proposed project whose estimated NPV is $12million.This estimate assumes that economic conditions will be average. However, the CFO wanted to do a scenario analysis and obtained the following results: Economic Situation       Probability NPV Recession 5% -$70 million Below Average 20%                     -$20 million Average 50%                     $12 million Above Average 20%                     $20 million Boom 5% $30 million Calculate the project’s expected NPV, standard deviation, and coefficient...
SCENARIO ANALYSIS Huang Industries is considering a proposed project whose estimated NPV is $12 million. This...
SCENARIO ANALYSIS Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be “average.” However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($70 million) Below average 0.20 (25 million) Average 0.50 12 million Above average 0.20 20 million Boom 0.05 30 million Calculate the project’s expected NPV, standard deviation,...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($42 million) Below average 0.20 (20 million) Average 0.50 12 million Above average 0.20 20 million Boom 0.05 26 million Calculate the project's expected NPV, standard deviation, and coefficient...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($48 million) Below average 0.20 (16 million) Average 0.50 12 million Above average 0.20 24 million Boom 0.05 28 million Calculate the project's expected NPV, standard deviation, and coefficient...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($90 million) Below average 0.20 (24 million) Average 0.50 12 million Above average 0.20 14 million Boom 0.05 40 million Calculate the project's expected NPV, standard deviation, and coefficient...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario   Probability of Outcome   NPV Recession   0.05   ($42 million) Below average   0.20   (24 million) Average   0.50   12 million Above average   0.20   14 million Boom   0.05   38 million Calculate the project's expected NPV, standard deviation, and coefficient...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($34 million) Below average 0.20 (16 million) Average 0.50 12 million Above average 0.20 16 million Boom 0.05 38 million Calculate the project's expected NPV, standard deviation, and coefficient...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($48 million) Below average 0.20 (16 million) Average 0.50 12 million Above average 0.20 22 million Boom 0.05 28 million Calculate the project's expected NPV, standard deviation, and coefficient...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($38 million) Below average 0.20 (16 million) Average 0.50 12 million Above average 0.20 24 million Boom 0.05 40 million Calculate the project's expected NPV, standard deviation, and coefficient...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes...
Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However, the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results: Economic Scenario Probability of Outcome NPV Recession 0.05 ($78 million) Below average 0.20 (22 million) Average 0.50 12 million Above average 0.20 24 million Boom 0.05 32 million Calculate the project's expected NPV, standard deviation, and coefficient...