Question

You recently went to work for Allied Components Company, a supplier of auto repair parts used in the after-market with products from Daimler AG, Ford, Toyota, and other automakers. Your boss, the CFO, has just handed you the estimated cash flows for two proposed projects. Project L involves adding a new item to the firm’s ignition system line; it would take some time to build up the market for this product, so the cash inflows would increase over time. Project S involves an add-on to an existing line, and its cash flows would decrease over time. Both projects have 3-year lives because Allied is planning to introduce entirely new models after 3 years.

Here are the projects’ after-tax cash flows (in thousands of dollars):

                                   0                      1                      2                      3

                                    |                       |                       |                       |

Project L                 -100                    10                   60                    90

Project S                  -100                    70                   50                    10

Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. The CFO also made subjective risk assessments of each project, and he concluded that both projects have risk characteristics that are similar to the firm’s average project. Allied’s WACC is 10%. You must determine whether one or both of the projects should be accepted.

1. What is the NPV_L?

NPVL  :

= -100 + (10 / 1.10¹) + (60 / 1.10²) + (90 / 1.10³)

= 26.30

2. What is the NPV_S?

NPVS  :

= -100 + (70 / 1.10¹) + (50 / 1.10²) + (10 / 1.10³)

= 12.47

3. Based on NPV, if Project L and Project S are INDEPENDENT, which should be accepted?
   1. Neither
   2. Both
   3. Project L
   4. Project S

4. Based on NPV, if Project L and Project S are MUTUALLY EXCLUSIVE, which should be accepted?
   1. Neither
   2. Both
   3. Project L
   4. Project S

5. What is the IRR_L?

6. What is the IRR_S?

7. Based on IRR, if Project L and Project S are INDEPENDENT, which should be accepted?
   1. Neither
   2. Both
   3. Project L
   4. Project S

8. Based on IRR, if Project L and Project S are MUTUALLY EXCLUSIVE, which should be accepted?
   1. Neither
   2. Both
   3. Project L
   4. Project S

9. Inherent in the NPV calculation is the assumption that cash flows can be reinvested at the project’s:
   1. Cost of Capital
   2. IRR Rate
   3. Tax Rate
   4. Yield to Maturity

10. Inherent in the IRR calculation is the assumption that cash flows can be reinvested at the project’s:
    1. Cost of Capital
    2. IRR Rate
    3. Tax Rate
    4. Yield to Maturity
    5. Both b and d

11. Calculate the Modified Internal Rate of Return (MIRR) for Project L

12. Calculate the Modified Internal Rate of Return (MIRR) for Project S

13. What is the Payback Period for Project L?

14. What is the Payback Period for Project S?

15. Which of the following is NOT a critical deficiency of regular payback?
    1. Ignores Time Value of Money (TVM)
    2. Ignores the Cash Flows after the Payback period
    3. Payback only tells us when we get our investment back, does not yield wealth creation data like NPV and IRR.
    4. Provides indication of project’s risk and liquidity

16. Find the crossover rate between project L and project S.

Answer 1

1.
Both

2.
Project L

3.
Both

4.
Project L

5.
Cost of Capital

6.
IRR Rate

7.
MIRR of Project L=MIRR({-100;10;60;90},10%,10%)=18.9020%

8.
MIRR of Project S=MIRR({-100;70;50;10},10%,10%)=14.3951%

9.
Payback period of Project L=2+(100-10-60)/90=2.33

10.
=1+(100-70)/50
=1.6000000

11.
Provides indication of project’s risk and liquidity

12.

Press the Cash Flow [CF] key to open the cash flow register
Type in 0
Enter
Hit down arrow once
Type -60
Enter
Hit down arrow once
Type 10
Enter
Hit down arrow once
Type 80
Enter

Press IRR
Press CPT
=24.1037%