Question
In: Finance
34) The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows...
34)
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
| Year 1 | Year 5 | Year 10 | |||||||||||||||||
| Cash Inflow | Probability | Cash Inflow | Probability | Cash Inflow | Probability | ||||||||||||||
| $ | 65 | 0.40 | $ | 50 | 0.35 | $ | 40 | 0.30 | |||||||||||
| 80 | 0.20 | 80 | 0.30 | 80 | 0.40 | ||||||||||||||
| 95 | 0.40 | 110 | 0.35 | 120 | 0.30 | ||||||||||||||
The expected value for all three years is $80.
Compute the standard deviation for each of the three years.
(Do not round intermediate calculations. Round your answer
to 2 decimal places.)
Solutions
Expert Solution
Solution :
Standard Deviation for Year 1 = 13.4164 %
= 13.42 % ( when rounded off to two decimal places )
Standard Deviation for Year 5 = 25.0998 %
= 25.10 % ( when rounded off to two decimal places )
Standard Deviation for Year 10 = 30.9839 %
= 30.98 % ( when rounded off to two decimal places )
Please find the attached screenshot of the excel sheet containing the detailed calculation for the solution.
jeff jeffy answered 8 months agoRelated Solutions
The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows are...
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
Year 1
Year 5
Year 10
Cash Inflow
Probability
Cash Inflow
Probability
Cash Inflow
Probability
$
35
0.40
$
20
0.35
$
10
0.40
60
0.20
60
0.30
60
0.40
85
0.40
100
0.35
110
0.20
The expected value for all three years is $60.
Compute the standard deviation...
The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows are...
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
Year 1
Year 5
Year 10
Cash Inflow
Probability
Cash Inflow
Probability
Cash Inflow
Probability
$
55
0.40
$
40
0.35
$
30
0.30
80
0.20
80
0.30
80
0.40
105
0.40
120
0.35
130
0.30
The expected value for all three years is $80.
Compute the standard deviation...
The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows are...
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
Year 1
Year 5
Year 10
Cash Inflow
Probability
Cash Inflow
Probability
Cash Inflow
Probability
$
50
0.40
$
30
0.35
$
20
0.30
70
0.20
70
0.30
70
0.40
90
0.40
110
0.35
120
0.30
The expected value for all three years is $70.
Compute the standard deviation for...
The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows are...
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
Year 1
Year 5
Year 10
Cash Inflow
Probability
Cash Inflow
Probability
Cash Inflow
Probability
$
65
0.20
$
50
0.25
$
40
0.30
80
0.60
80
0.50
80
0.40
95
0.20
110
0.25
120
0.30
The expected value for all three years is $80.
Compute the standard deviation...
The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows are...
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
Year 1
Year 5
Year 10
Cash Inflow
Probability
Cash Inflow
Probability
Cash Inflow
Probability
$
85
0.40
$
60
0.35
$
50
0.30
110
0.20
110
0.30
110
0.40
135
0.40
160
0.35
170
0.30
The expected value for all three years is $110.
Compute the standard deviation...
The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows are...
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
Year 1
Year 5
Year 10
Cash Inflow
Probability
Cash Inflow
Probability
Cash Inflow
Probability
$
90
0.40
$
80
0.35
$
70
0.30
100
0.20
100
0.30
100
0.40
110
0.40
120
0.35
130
0.30
The expected value for all three years is $100.
Compute the standard deviation...
The Oklahoma Pipeline Company projects the following pattern of inflows from an investment. The inflows are...
The Oklahoma Pipeline Company projects the following pattern of
inflows from an investment. The inflows are spread over time to
reflect delayed benefits. Each year is independent of the
others.
Year 1
Year 5
Year 10
Cash Inflow
Probability
Cash Inflow
Probability
Cash Inflow
Probability
$
105
0.40
$
95
0.20
$
90
0.40
120
0.20
120
0.20
120
0.40
135
0.40
145
0.60
150
0.20
The expected value for all three years is $120.
Compute the standard deviation...
consider the following three projects. All three have an initial investment of $300,000 Net Cash Inflows...
consider the following three projects. All three have an initial
investment of $300,000
Net Cash Inflows
Project L
Project M
Project N
Year
Annual
Accumulated
Annual
Accumulated
Annual
Accumulated
1
$75,000
$75,000
$25,000
$25,000
$150,000
$150,000
2
75,000
150,000
75,000
100,000
150,000
300,000
3
75,000
225,000
200,000
300,000
4
75,000
300,000
250,000
550,000
5
75,000
375,000
350,000
900,000
6
75,000
450,000
7
75,000
525,000
8
75,000
600,000
Required
1.
Determine the payback period of each project. Rank the projects
from...
A company estimates the following net cash inflows and outflows for a capital investment project that...
A company estimates the following net cash inflows and
outflows for a capital investment
project that is currently under consideration.
year Cash flow
0 (575,000)
1 45,800
2 99,000
3 104,300
4 118,700
5 130,400
6 129,000
7 116,500
8 77,200
9 55,000
10 12,500
Calculate the ARR and NPV of the project.
The MB Company is considering investment in one of the following mutually exclusive projects.Cash inflows of...
The MB Company is considering investment in one of the following
mutually exclusive projects.Cash inflows of foreseeable next four
years are given below (cash inflows 000 dollars)
Probabilty Project K Project L
0.15 4250 4250
0.2 4750 5250
0.3 5250 6250
0.2 5750 7250
0.15 6250 8250
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- C++ 11.7: Customer Accounts Write a program that uses a structure to store the following data...
- Question 5 a) Students’ attitude towards teachers and class is a major cause of plagiarism. Some...
- 32. What is empirical research ? 37. Which research positions require a college degree and which...
- In java Step 1) Assume that you have tracked monthly BSIT inquires for 10 months. Save...
- 1.) Motors and generators a) In a homopolar motor (like Faraday’s motor), what happens to the...
- If you are to be responsible in Supply Chain and Logistics management for a company in...
- This is for Python programming, and I am trying to use 2 for loops to ask...
ADVERTISEMENT