Question
In: Finance
0 1 2 3 4 5 6 7 Project A -$300 -$387 -$193 -$100 $600 $600...
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ||
| Project A | -$300 | -$387 | -$193 | -$100 | $600 | $600 | $850 | -$180 | |
| Project B | -$400 | $134 | $134 | $134 | $134 | $134 | $134 | $0 | |
| Project Delta | |||||||||
| #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | ||
| Crossover Rate = IRRΔ | #N/A | ||||||||
| Project MIRR Calculations at WACC = 18% | |||||||||
| WACC | 18.00% | ||||||||
| MIRRA | #N/A | ||||||||
| MIRRB | #N/A | ||||||||
Solutions
Expert Solution
1. NPV
The NPV of both projects. Discount each cash flow to Period 0 and find their sum.
PROJECT A
Period Cash Flow / Discounted factor Discounted cash flow
0 -300 (1.11)0 -300
1 -387 (1.11)1 -348.65
2 -193 (1.11)2 -156.64
3 -100 (1.11)3 -73.12
4 600 (1.11)4 398.24
5 600 (1.11)5 356.07
6 850 (1.11)6 454.44
7 -180 (1.11)7 -86.7
Total NPV 240.64
PROJECT B
Period Cash Flow / Discounted factor Discounted cash flow
0 -400 (1.11)0 -400
1 -134 (1.11)1 120.72
2 -134 (1.11)2 108.94
3 -134 (1.11)3 97.81
4 -134 (1.11)4 88.16
5 -134 (1.11)5 79.76
6 -134 (1.11)6 75.66
7 0 (1.11)7 0
TOTAL NPV 171.05
IRR
The IRR can't be solved through traditional means, equation or algebra. A financial calculator is needed to solve this problem.
Project A
Find the cash flow editor and input the following.
Peirod Cash Flow
0 -300
1 -387
2 -193
3 -100
4 600
5 600
6 850
7 -180
Solving for IRR gives us 18.0967%
jeff jeffy answered 1 year agoRelated Solutions
6 5 4 5 0 0 13 48 6 1 0 7 2 0 1 1...
6
5
4
5
0
0
13
48
6
1
0
7
2
0
1
1
0
2
11
5
11
27
4
0
6
Create Standard Deviation Chart (Normal Distribution
Curve)
exampleInput.txt 1 2 3 0 2 3 4 0 1 3 5 0 1 2 6...
exampleInput.txt
1 2 3
0 2 3 4
0 1 3 5
0 1 2 6
1 5 6 8
2 4 6 7
3 4 5 9 10
5 8 9
4 7 9
6 7 8
6
How can I detect when 'cin' starts reading from a new line. The
amount of numbers in each row is unknown. I need them in type 'int'
to use the data.
ID X Y 1 2 3 2 3 6 3 4 6 4 5 7 5...
ID
X
Y
1
2
3
2
3
6
3
4
6
4
5
7
5
8
7
6
5
7
7
6
7
8
8
8
9
7
8
10
12
11
Test the significance of the correlation coefficient.
Then use math test scores (X) to predict physics test scores
(Y). Do the following:
Create a scatterplot of X and Y.
Write the regression equation and interpret the regression
coefficients (i.e., intercept and slope).
Predict the physics score for each....
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6
6]
This is my dataset
Find mean, median, mode, variance, standard deviation,
coefficient of variation, range, 70th percentile,
3rdquartile of the data and skewness and define what
each of these statistics measure. For example, mean is a measure of
the central tendency, what about the rest?
Use Chebyshev’s rule to find...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4...
[4 5 5 2 4 4 6 3 3 7 5 3 6 3 4 4 6 5 4 5 3 7 5 5 4 2 6 5 6
6]
This is my dataset
Split the dataset in two equal parts. You have 30 datavalues.
If you split the data in two equal parts each part will contain 15
data values. Call the first part Y and second part
X.Draw scatter plot of the 2 datasets, X being on the horizontal...
DATA 3 8 2 15 2 2 0 0 4 5 2 7 0 1 5...
DATA
3
8
2
15
2
2
0
0
4
5
2
7
0
1
5
3
0
2
5
4
1
6
9
5
3
1
2
10
6
1
1
2
1
19
6
6
6
7
0
4
1
1
1
0
1
9
2
2
2
1
16
10
10
5
2
3
1
4
4
4
3
6
2
8
5
2
7
1
6
4
0
3
1
1
1
Background:
A group of...
Year Cash Flow 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 What...
Year Cash Flow
0 $0
1 $250
2 $400
3 $500
4 $600
5 $600
What is the present (Year 0) value if the opportunity cost
(discount) rate is 10 percent?
Add an outflow (or cost) of $1,000 at Year 0.
What is the present value (or net present value) of the
stream?
A = （1 −7 5 0 0 10 8 2 2 4 10 3 −4 8...
A =
（1 −7 5 0
0 10 8 2
2 4 10 3
−4 8 −9 6）
(1) Count the number of rows that contain negative
components.
(2) Obtain the inverse of A and count the number of columns that
contain even number of positive components.
(3) Assign column names (a,b,c,d) to the columns of A.
(4) Transform the matrix A into a vector object a by stacking
rows.
(5) Replace the diagonal components of A with (0,0,2,3). Hint:...
x (Bins) frequency 0 0 1 0 2 0 3 2 4 5 5 8 6...
x (Bins)
frequency
0
0
1
0
2
0
3
2
4
5
5
8
6
13
7
33
8
42
9
66
10
77
11
105
12
103
13
110
14
105
15
84
16
70
17
51
18
40
19
27
20
27
21
15
22
5
23
7
24
2
25
2
26
1
27
0
28
0
29
0
30
0
(7) On the Histogram worksheet, calculate all
frequencies of the distribution using the table shown....
Which project should D&A should pick? Project A: t 0 1 2 3 4 5 6...
Which project should D&A should
pick?
Project A:
t
0
1
2
3
4
5
6
7
8
9
10
CF
10,000
-55,000
155,000
125,000
119,000
113,500
201,500
123,000
-119,000
54,000
Project B:
t
0
1
2
3
4
5
6
7
8
9
10
CF
95,000
112,000
155,000
-125,000
119,000
-153,000
255,000
-113,000
139,000
39,000
The cost of capital (discount rate) for both projects is 7.89%
/year. Based on the given information, please calculate the present
value of the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Suppose you observe the following situation: State of Economy Probability of State Return if State Occurs...
- Merger Analysis TransWorld Communications Inc., a large telecommunications company, is evaluating the possible acquisition of Georgia...
- Journal Entries and Trial Balance Elite Realty acts as an agent in buying, selling, renting, and...
- In racket Assume that the elements of a list are indexed starting with 1. Write a...
- Describe System Development Life Cycle (SDLC) and how it is used.
- What symbolism do you find in the play,Oedipus?
- • Using the Scanner class to obtain input from the user. • Using printf to output...
ADVERTISEMENT