Question

In: Accounting

Consider investments A and B with cash flows given below n A B 0 -30000 -30000...

Consider investments A and B with cash flows given below

n

A

B

0

-30000

-30000

1

2000

11000

2

6000

10000

3

10000

10000

4

24000

8000

5

26000

5000

a) Find the IRR for each investment.

b) Find the incremental IRR, i.e., find IRR for B-A.

c) Plot the present worth of the cash flows of A and of B as a function of the interest rate, i.e., consister interest rates 5%,10%,15%,…, 40%. Identify the interest rate at which the two project have the same present worth. Observe that this interest rate is the same value as computed from the incremental IRR analysis.

Solutions

Expert Solution

a) A - 23.75% & B - 16.19% (use IRR formula in excel)

N A B
0 -$30,000.00 -$30,000.00
1 $2,000.00 $11,000.00
2 $6,000.00 $10,000.00
3 $10,000.00 $10,000.00
4 $24,000.00 $8,000.00
5 $26,000.00 $5,000.00
IRR 23.75% 16.19%

b) Incremental IRR B-A

= 16.19% - 23.75% = -7.56%

c)

Also in the last coloumn shown how by using IRR PW becomes Zero

At 40% interest rate PW of both project is near to same

Disconting Factor
N 5% 10% 15% 20% 25% 30% 35% 40% PV @ 23.75% PV @ 16.19%
0 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000 1.0000
1 0.9524 0.9091 0.8696 0.8333 0.8000 0.7692 0.7407 0.7143 0.8081 0.8607
2 0.9070 0.8264 0.7561 0.6944 0.6400 0.5917 0.5487 0.5102 0.6530 0.7407
3 0.8638 0.7513 0.6575 0.5787 0.5120 0.4552 0.4064 0.3644 0.5277 0.6375
4 0.8227 0.6830 0.5718 0.4823 0.4096 0.3501 0.3011 0.2603 0.4264 0.5487
5 0.7835 0.6209 0.4972 0.4019 0.3277 0.2693 0.2230 0.1859 0.3446 0.4722
Present Worth For Projec A under different discount %
Year Cash Flow 5% 10% 15% 20% 25% 30% 35% 40% PW @ 23.75%
0 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00
1 $2,000.00 $1,904.76 $1,818.18 $1,739.13 $1,666.67 $1,600.00 $1,538.46 $1,481.48 $1,428.57 $1,616.16
2 $6,000.00 $5,442.18 $4,958.68 $4,536.86 $4,166.67 $3,840.00 $3,550.30 $3,292.18 $3,061.22 $3,917.97
3 $10,000.00 $8,638.38 $7,513.15 $6,575.16 $5,787.04 $5,120.00 $4,551.66 $4,064.42 $3,644.31 $5,276.72
4 $24,000.00 $19,744.86 $16,392.32 $13,722.08 $11,574.07 $9,830.40 $8,403.07 $7,225.64 $6,247.40 $10,233.65
5 $26,000.00 $20,371.68 $16,143.95 $12,926.60 $10,448.82 $8,519.68 $7,002.56 $5,798.35 $4,834.30 $8,958.75
Total $38,000.00 $26,101.85 $16,826.28 $9,499.83 $3,643.26 -$1,089.92 -$4,953.96 -$8,137.93 -$10,784.20 $3.25
IRR 23.75%
Present Worth For Projec B under different discount %
Year B 5% 10% 15% 20% 25% 30% 35% 40% PW @ 16.19 %
0 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00 -$30,000.00
1 $11,000.00 $10,476.19 $10,000.00 $9,565.22 $9,166.67 $8,800.00 $8,461.54 $8,148.15 $7,857.14 $9,467.25
2 $10,000.00 $9,070.29 $8,264.46 $7,561.44 $6,944.44 $6,400.00 $5,917.16 $5,486.97 $5,102.04 $7,407.34
3 $10,000.00 $8,638.38 $7,513.15 $6,575.16 $5,787.04 $5,120.00 $4,551.66 $4,064.42 $3,644.31 $6,375.20
4 $8,000.00 $6,581.62 $5,464.11 $4,574.03 $3,858.02 $3,276.80 $2,801.02 $2,408.55 $2,082.47 $4,389.50
5 $5,000.00 $3,917.63 $3,104.61 $2,485.88 $2,009.39 $1,638.40 $1,346.65 $1,115.07 $929.67 $2,361.16
Total $14,000.00 $8,684.11 $4,346.33 $761.73 -$2,234.44 -$4,764.80 -$6,921.97 -$8,776.85 -$10,384.36 $0.46
IRR 16.19%

Related Solutions

Consider two investments with the following sequences of cash flows: n Project A Project B 0...
Consider two investments with the following sequences of cash flows: n Project A Project B 0 -$167,000 -$158,500 1 $38,500 $90,300 2 $47,400 $47,500 3 $59,300    $16,000     4 $29,900     $20,300 5 $57,300     $26,500 a) Compute the IRR for each investment. b) At MARR = 9%, consider the acceptability of each project. c) If A and B are mutually exclusive projects, which project would you select on the basis of the rate of return on incremental investment?
Consider the investment project cash flows given below n CF 0 -220000 1 94000 2 144000...
Consider the investment project cash flows given below n CF 0 -220000 1 94000 2 144000 3 72000 a) Find the IRR for this investment. b) Plot the present worth of the cash flow as a function of the interest rate, i.e., consider interest rates of 5%,10%,15%,…, 30%. Identify the interest rate at which the present worth is zero. c) Assuming a MARR of 15%, is this investment acceptable?
Problem 5 (20pts) Consider two investments with the following cash flows: n Project A Project B...
Problem 5 (20pts) Consider two investments with the following cash flows: n Project A Project B 0 -100,000 -190,000 1 19,000 29,000 2 17,000 27,000 3 15,000 25,000 4 12,000 22,000 5 22,000 32,000 6 100,000 195,000 Suppose A and B are mutually exclusive, the MARR is 12%, the rate of return for project A and B is already given, which is 15% and 13% respectively. Determine which project should be selected using rate of return on incremental investment. In...
Mutually exclusive investments. The following are cash flows of two projects. Year  Project A Project B 0...
Mutually exclusive investments. The following are cash flows of two projects. Year  Project A Project B 0 $ (200) $ (200) 1 80 100 2 80 100 3 80 100 4 80 Calculate the NPV for both projects if the discount rate is 11%(Do not intermediate calculations.Round your answer to 2 decimal places) Suppose that you can only choose one of the these projects. Which would you choose ? project A Project B Neither
Consider the two projects with following cash flows denoted by (An, n). Project X: (-12000, 0),...
Consider the two projects with following cash flows denoted by (An, n). Project X: (-12000, 0), (6000, 1), (6000, 2), (6000, 3). Project Y: (-14000, 0), (7100, 1), (7100, 2), (7100, 3). If MARR is 20%, then which one of the following statements is correct: (using two decimal places) a) Project X is more costly one (i.e. high investment cost) b) IRR of project Y is less than 20% c) Incremental IRR of (Y-X) is 29.92% d) Project X is...
Suppose you are given the following two projects A and B with the cash flows below,...
Suppose you are given the following two projects A and B with the cash flows below, if the cost of capital is 10%, what is the Profitability Index (PI) of projects A and B? Year Project A Project B 0 -5000 -6000 1 1500 1500 2 2000 2500 3 3000 4000 4 3500 4000
Consider the following cash flows for the two investments. What are the payback periods on the two investments?
Q 2 Consider the following cash flows for the two investments. What are the payback periods on the two investments? Year Investment A Investment B 0 -$100 -$100 1 58 31 2 73 58 3 87 180 Question options: 1- Project A 1.58 years; Project B 2.53 years 2- Project A 1.46 years; Project B 2.21 years ''''''''''''''''''''''''''''' Q 3 You are in the lucky situation of having several customers that want to place large orders with your firm. Unfortunately...
Consider the following cash flows for two mutually exclusive investments : t=0 t=1 t=2 t=3 A...
Consider the following cash flows for two mutually exclusive investments : t=0 t=1 t=2 t=3 A ($1,212) $898 $543 $111 B ($911) $101 $234 $1,033 Given the cost of capital is 8% what is the internal rate of return of the better project?
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project...
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: -$1000, 375, 375, 375, 375,-100 Project B: -$1000, 900, 700, 500, -200, 200 The cost of capital for both projects is 10% 1. Find the NPV and MIRR of projects A and B. If project A and B are mutually exclusive. 2. Find the crossover rate for projects A and B. 3. What is the profitability index for projects A and B? How...
Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0...
Consider the following cash flows on two mutually exclusive projects: Year Project A Project B 0   –$ 68,000   –$ 83,000 1 48,000 47,000 2 43,000 56,000 3 38,000 59,000 The cash flows of Project A are expressed in real terms, whereas those of Project B are expressed in nominal terms. The appropriate nominal discount rate is 11 percent and the inflation rate is 5 percent. Calculate the NPV for each project. (Do not round intermediate calculations and round your answers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT