Question

Question 1 (25 points): An investor has two investment alternatives, Project A and Project B, that are mutually exclusive. Ot
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Correct Answer:

A

B

C

D =A*C

E =B*C

F =D+E

year

Cash outflow

Cash inflow

PV of $1 @ 10%

PV of cash outflow

Pv of cash inflow

PV of net cash flow

0

$      (5,000.00)

$                                -  

1.0000

$       (5,000.00)

$                          -  

$             (5,000.00)

1

$      (3,500.00)

$                                -  

0.9091

$       (3,181.82)

$                          -  

$             (3,181.82)

2

$      (2,500.00)

$                   3,000.00

0.8264

$       (2,066.12)

$             2,479.34

$                   413.22

3

$                   3,000.00

0.7513

$                      -  

$             2,253.94

$                2,253.94

4

$                   3,000.00

0.6830

$                      -  

$             2,049.04

$                2,049.04

5

$                   3,000.00

0.6209

$                      -  

$             1,862.76

$                1,862.76

6

$                   2,500.00

0.5645

$                      -  

$             1,411.18

$                1,411.18

7

$                   2,500.00

0.5132

$                      -  

$             1,282.90

$                1,282.90

8

$                   2,500.00

0.4665

$                      -  

$             1,166.27

$                1,166.27

8

8500

0.46650738

$                      -  

$             3,965.31

$                3,965.31

NPV project A

$                6,222.81

Project A

NPV1

$      6,222.81

NPV2

$        (118.01)

NPV1-NPV2

          6,340.82

npv1/(npv1-npv2)

0.981389178

r1

10.0%

r2

23.0%

r2-r1

13.0%

IRR = r1+(npv1/(npv1-npv2) * (r2-r1)

22.76%

Working:

For the purpose of calculation of IRR, we have to assume a discount rate on which the npv of the project is less than zero .

A

B

C

D =A*C

E =B*C

F =D+E

year

Cash outflow

Cash inflow

PV of $1 @ 23%

PV of cash outflow

Pv of cash inflow

PV of net cash flow

0

$                                  (5,000.00)

$                   -  

1.0000

$              (5,000.00)

$               -  

$    (5,000.00)

1

$                                  (3,500.00)

$                   -  

0.8130

$              (2,845.53)

$               -  

$    (2,845.53)

2

$                                  (2,500.00)

$      3,000.00

0.6610

$              (1,652.46)

$ 1,982.95

$          330.49

3

$      3,000.00

0.5374

$                             -  

$ 1,612.15

$      1,612.15

4

$      3,000.00

0.4369

$                             -  

$ 1,310.69

$      1,310.69

5

$      3,000.00

0.3552

$                             -  

$ 1,065.60

$      1,065.60

6

$      2,500.00

0.2888

$                             -  

$      721.95

$          721.95

7

$      2,500.00

0.2348

$                             -  

$      586.95

$          586.95

8

$      2,500.00

0.1909

$                             -  

$      477.20

$          477.20

8

8500

0.1909

$                             -  

$ 1,622.48

$      1,622.48

NPV project A

$       (118.01)

Requirement 2:

A

B

C

D =A*C

E =B*C

F =D+E

year

Cash outflow

Cash inflow

PV of $1 @ 10%

PV of cash outflow

Pv of cash inflow

PV of net cash flow

0

$    (15,000.00)

$                                -  

1.0000

$    (15,000.00)

$                          -  

$           (15,000.00)

1

$      (4,000.00)

$                   4,500.00

0.9091

$       (3,636.36)

$             4,090.91

$                   454.55

2

$                     -  

$                   4,250.00

0.8264

$                      -  

$             3,512.40

$                3,512.40

3

$                   4,000.00

0.7513

$                      -  

$             3,005.26

$                3,005.26

4

$                   3,750.00

0.6830

$                      -  

$             2,561.30

$                2,561.30

5

$                   3,500.00

0.6209

$                      -  

$             2,173.22

$                2,173.22

6

$                   3,250.00

0.5645

$                      -  

$             1,834.54

$                1,834.54

7

$                   3,000.00

0.5132

$                      -  

$             1,539.47

$                1,539.47

8

$                   1,750.00

0.4665

$                      -  

$                 816.39

$                   816.39

8

$                11,000.00

0.4665

$                      -  

$             5,131.58

$                5,131.58

NPV project B

$                6,028.71

Working:

Project b

NPV1

$                6,028.71

NPV2

$                    (87.71)

NPV1-NPV2

                   6,116.42

NPV1/(NPV1-NPV2)

0.985660051

r1

0.1

r2

0.18

r2-r1

0.08

IRR = r1+(npv1/(npv1-npv2) * (r2-r1)

17.89%

Working:

A

B

C

D =A*C

E =B*C

F =D+E

year

Cash outflow

Cash inflow

PV of $1 @ 10%

PV of cash outflow

Pv of cash inflow

PV of net cash flow

0

$                                (15,000.00)

$                   -  

1.0000

$           (15,000.00)

$               -  

$ (15,000.00)

1

$                                  (4,000.00)

$      4,500.00

0.8475

$              (3,389.83)

$ 3,813.56

$          423.73

2

$                                                  -  

$      4,250.00

0.7182

$                             -  

$ 3,052.28

$      3,052.28

3

$      4,000.00

0.6086

$                             -  

$ 2,434.52

$      2,434.52

4

$      3,750.00

0.5158

$                             -  

$ 1,934.21

$      1,934.21

5

$      3,500.00

0.4371

$                             -  

$ 1,529.88

$      1,529.88

6

$      3,250.00

0.3704

$                             -  

$ 1,203.90

$      1,203.90

7

$      3,000.00

0.3139

$                             -  

$      941.78

$          941.78

8

$      1,750.00

0.2660

$                             -  

$      465.57

$          465.57

8

$    11,000.00

0.2660

$                             -  

$ 2,926.42

$      2,926.42

NPV project B

$          (87.71)

Project B should be accepted.

End of answer.

Please give a thumbs-up, it will be highly appreciated.

Thanks.

Add a comment
Know the answer?
Add Answer to:
Question 1 (25 points): An investor has two investment alternatives, Project A and Project B, that...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • There are six mutually exclusive investments alternatives. And investor can select one of them or non...

    There are six mutually exclusive investments alternatives. And investor can select one of them or non .the following analysis table shows incremental internal rate of return for each two alternatives (2.5 points) There are six mutually exclusive investment alternatives. An investor can select one of them or none. The following analysis table shows incremental internal rate of retum for each two altematives. (e-t. incremental internal rate of retum of Δ(B-A)-8%], which alternative should he select if MAR-12% Do Nothing A...

  • Consider the two mutually exclusive alternatives given in the table below. W NO Net Cash Flow Project A1 Project...

    Consider the two mutually exclusive alternatives given in the table below. W NO Net Cash Flow Project A1 Project A2 - $12,000 - $14,000 5,000 6,200 5,000 6,200 5,000 6,200 (a) Determine the IRR on the incremental investment in the amount of $2,000. The IRR on incremental investment is %. (Round to one decimal place.)

  • Consider the two mutually exclusive investment projects given in the table below for which MARR =...

    Consider the two mutually exclusive investment projects given in the table below for which MARR = 19%. On the basis of the IRR criterion, which project would be selected under an infinite planning horizon with project repeatability likely? Click the icon to view the cash flows for the investment projects. The rate of return on the incremental investment is %. (Round to one decimal place.) Which project would be selected on the basis of the IRR criterion? Choose the correct...

  • Questions 10-15 are based on the following information about two mutually exclusive investment alternatives. The MARR...

    Questions 10-15 are based on the following information about two mutually exclusive investment alternatives. The MARR is 12%. Initial Investment Annual Revenue Useful Life (Years) CMS FMS $20,000 $29,000 6,688 9,102 55 10. Which option should be selected as the base alternative? A. CMS B. FMS. C. Neither option is acceptable as a base alternative. D. Both options are acceptable base alternatives. E. I'm completely lost! Which option should be selected as the challenger alternative? A. CMS B. FMS. C....

  • 18. Comparing Investment Criteria Consider the following cash flows of two mutually exclusive projects for Tokyo...

    18. Comparing Investment Criteria Consider the following cash flows of two mutually exclusive projects for Tokyo Rubber Company. Assume the discount rate for both projects is 8 percent. Year Dry Prepreg Solvent Prepreg -$1,700,000 1,100,000 900,000 --$750,000 375,000 600,000 390,000 750,000 a. Based on the payback period, which project should be taken? b. Based on the NPV, which project should be taken? c. Based on the IRR, which project should be taken? d. Based on this analysis, is incremental IRR...

  • The following mutually exclusive investment alternatives have been presented to you. The life of all alternatives...

    The following mutually exclusive investment alternatives have been presented to you. The life of all alternatives is 10 years. A В C Capital investment Annual expenses $60,000 $90,000 $40,000 $30,000 $70,000 35,000 45,000 15,000 30,000 40,000 25,000 16,000 Annual revenues 50,000 52.000 38,000 28,000 Market value at EOY 10 15,000 10,000 10,000 39.0% 10,000 IRR ??? 7.4% 30.8% 9.2% After the base alternative has been identified, the first comparison to be made in an incremental analysis should be which of...

  • in the incremental analysis question, how did we calculate the IRR of these two alternatives (C-A)? can you show it to...

    in the incremental analysis question, how did we calculate the IRR of these two alternatives (C-A)? can you show it to me step by step? Solution The next largest investment is in Alternative C, so examine the incremental investment of C over A. In the table below the IRR of C-A is shown. Alternative C- A Capital $12,000 $14,400 $2,400 investment $2,500 $3,050 $550 Net annual ncome 13.48% 15.86% IRR 12.99% 15.86% > MARR, so Alternative C "wins." Solution The...

  • Question 2 (1 point) A tabulation of incremental cash flow between two different-life alternatives must be...

    Question 2 (1 point) A tabulation of incremental cash flow between two different-life alternatives must be prepared over the LCM of their lives. True False Question 3 (1 point) In evaluating mutually exclusive alternatives on the basis of rate of return, it is necessary to conduct an "Incremental ROR"in order to obtain the same ranking as the PW and AW methods True False Question 7 (1 point) When an incremental rate of return analysis is conducted correctly, the alternative identified...

  • 18. Comparing Inve 1. Comparing Investment Criteria Consider the following cash flows of two mutually! exclusive...

    18. Comparing Inve 1. Comparing Investment Criteria Consider the following cash flows of two mutually! exclusive projects for Tokyo Rubber Company. JCCS for Tokyo Rubber Company. Assume the discount rate for both proi ects is 8 percent. Year Dry Prepreg Solvent Prepreg -$1,500,000 900,000 700,000 725,000 -$650,000 345,000 570,000 360,000 a. Based on the payback period, which project should be taken? b. Based on the NPV, which project should be taken? c. Based on the IRR, which project should be...

  • Final Finishing is considering three mutually exclusive alternatives for a new polisher. Each alternative has an...

    Final Finishing is considering three mutually exclusive alternatives for a new polisher. Each alternative has an expected life of 10 years and no salvage value. Polisher 1 requires an initial investment of $20,000 and provides annual benefits of $4,465. Polisher 2 requires an initial investment of $10,000 and provides annual benefits of $1,770. Polisher 3 requires an initial investment of $15,000 and provides annual benefits of $3,580. MARR is 15%/year. Show the comparisons and internal rates of return used to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT