Reference no: EM131135566
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?
Attachment:- Assignment.rar
|
Maintain higher inventories
: Searches related to Two industrial distributors each start out selling a single brand of motor and both achieve annual sales of $100,000 after one year. Over the next two years, both grow their annual sales to $1,000,000. The first distributor grows ..
|
|
When in rome do as the romans do
: What does this statement mean to you and how do you see this as a help or hindrance in developing collaborative relationships with patients, families, and other health care providers: "When in Rome do as the Romans do"?
|
|
Annual season preview where patrons
: The Art's Center has an annual season preview where patrons are able to purchase tickets early. There are six stations. An average of 63 patrons arrive per hour. Each station spends an average of 16 minutes with each order. However The Gallo Center d..
|
|
Most recent contribution format income statement
: Miller Company's most recent contribution format income statement is shown below: Total Per Unit Sales (32,000 units) $224,000 $7.00 Variable expenses 128,000 4.00 Contribution margin 96,000 $3.00 Fixed expenses 48,000 Net operating income $ 48,00..
|
|
What is the expected value of the npv
: Your company asked you to evaluate two potential projects. These projects are active for 10 years and have no salvage life. 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 proj..
|
|
Determine the temperature at which water in an uncovered pan
: Determine the temperature at which water in an uncovered pan boils in Denver. Answer: 94.6°C.
|
|
How often do you think the research enterprise is thwarted
: Please familiarize yourself of the on Organizing Information Technology Services and let's discuss the roles of the Specialized Groups and the IT Infrastructure for Research in an AcademicMedicalCenter. How often do you think the research enterpr..
|
|
Find the standard deviation of the measured concentration
: Enter the data into a spreadsheet. and construct a standard-additions plot of the data.
|
|
The total actual manufacturing overhead
: Burlington Brewery LTD. uses direct labor hours (DLH) in its predetermined overhead rate. At the end of the year, the actual labor hours (DLH) were 3,440 hours and the total actual manufacturing overhead was $147,360.
|