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%


Related 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...
Matrix A2= [1 2 3; 4 5 6; 7 8 9; 3 2 4; 6 5...
Matrix A2= [1 2 3; 4 5 6; 7 8 9; 3 2 4; 6 5 4; 9 8 7] Note: TA2 is defined to be a linear transformation that maps any vector x to A2* x. That is TA2 = A2*x. Also the range of the Linear transformation represented by A2 is the same as the column space of A2. l) Find a basis for the null(TA2). m) Find nullity of A2, TA2 and A2tA2. n) Find rank(A2), rank(A2t),...
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?
Correct the code to prints the following: 0 1 2 3 4 5 6 7 8...
Correct the code to prints the following: 0 1 2 3 4 5 6 7 8 9 int[] numbers = new int[10]; for(int i=0; i < numbers.length; ++i)         numbers[i] = i * 3; for(int i=0; i < numbers.length; ++i)         System.out.print(numbers[i] / 2 + 1 + " "); System.out.println();
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:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT