Sunday 3 August 2014

Kerron Company is presented with the following two mutually exclusive projects. The required return for both projects is 19 percent. Year Project M Project N 0 –$140,000 –$355,000 1 63,500 152,500 2 81,500 180,000 3 72,500 137,500 4 58,500 110,000

Kerron Company is presented with the following two mutually exclusive projects. The required return for both projects is 19 percent.

Year Project M Project N
0 –$140,000      –$355,000     
1 63,500      152,500     
2 81,500      180,000     
3 72,500      137,500     
4 58,500      110,000     


Required:
(a)
What is the IRR for each project? (Do not round intermediate calculations. Enter your answers as a percentage rounded to 2 decimal places (e.g., 32.16).)

     IRR  
  Project M %  
  Project N %  


(b)
What is the NPV for each project? (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).)

         NPV  
  Project M $  
  Project N $  


(c) Which, if either, of the projects should the company accept?
   
  Project M


Explanation: (a)
The IRR for each project is:

  M: $140,000 = $63,500 / (1 + IRR) + $81,500 / (1 + IRR)2 + $72,500 / (1 + IRR)3 + $58,500 / (1 + IRR)4

Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:

IRR = 34.47%

  N: $355,000 = $152,500 / (1 + IRR) + $180,000 / (1 + IRR)2 + $137,500 / (1 + IRR)3 + 110,000 / (1 + IRR)4

Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:

IRR = 24.61%

The IRR decision rule implies we accept project M because the IRR for M is greater than the IRR for N.

(b)
The NPV for each project is:


  M: NPV = – $140,000 + $63,500 / 1.19 + $81,500 / 1.192 + $72,500 / 1.193 + $58,500 / 1.194
  NPV = $43,108.55

  N: NPV = – $355,000 + $152,500 / 1.19 + $180,000 / 1.192 + $137,500 / 1.193 + $110,000 / 1.194
  NPV = $36,709.17

The NPV criterion implies we accept project M because project M has a higher NPV than project N.

(c)
Accept project M since the NPV is higher. IRR cannot be used to rank mutually exclusive projects.
   
Calculator Solution:
 
Note: Intermediate answers are shown below as rounded, but the full answer was used to complete the calculation.
    
Project M      
CFo
 –$140,000
CFo
 –$140,000
C01
 $63,500
C01
 $63,500
F01
 1
F01
 1
C02
 $81,500
C02
 $81,500
F02
 1
F02
 1
C03
 $72,500
C03
 $72,500
F03
 1
F03
 1
C04  $58,500 C04  $58,500
F04  1 F04  1
  CPT IRR   I = 19
  34.47%   NPV CPT
    $43,108.55
   
Project N      
CFo
 –$355,000
CFo
 –$355,000
C01
 $152,500
C01
 $152,500
F01
 1
F01
 1
C02
 $180,000
C02
 $180,000
F02
 1
F02
 1
C03
 $137,500
C03
 $137,500
F03
 1
F03
 1
C04  $110,000 C04  $110,000
F04  1 F04  1
  CPT IRR   I = 19
  24.61%   NPV CPT
    $36,709.17

No comments:

Post a Comment