In: Accounting
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.
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 SolutionsConsider 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
Latest Questions
ADVERTISEMENT
|