Showing posts with label Calculating Payback. Show all posts
Showing posts with label Calculating Payback. Show all posts

Sunday, 3 August 2014

Problem 8-1 Calculating Payback [LO 1] Consider the following cash flows: Year Cash Flow 0 –$6,800 1 1,950 2 4,100 3 1,750 4 1,450

Problem 8-1 Calculating Payback [LO 1]
Consider the following cash flows:

Year Cash Flow
0 –$6,800        
1 1,950        
2 4,100        
3 1,750        
4 1,450        


Required:
What is the payback period for the above set of cash flows? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

  Payback period years  


Explanation:
To calculate the payback period, we need to find the time the project needs to recover its initial investment. After two years, the project has created:
 
$1,950 + 4,100 = $6,050
 
in cash flows. The project still needs to create another:
 
$6,800 – 6,050 = $750
 
in cash flows. During the third year, the cash flows from the project will be $1,750. So, the payback period will be 2 years, plus what we still need to make divided by what we will make during the third year. The payback period is:
 
Payback = 2 + ($750 / $1,750)
Payback = 2.43 years

Problem 8-9 Calculating NPV [LO 4] Consider the following cash flows: Year Cash Flow 0 –$ 32,000 1 14,200 2 17,500 3 11,600

Problem 8-9 Calculating NPV [LO 4]
Consider the following cash flows:

Year Cash Flow
0   –$ 32,000
1     14,200  
2     17,500  
3     11,600  


Requirement 1:
What is the NPV at a discount rate of zero percent? (Do not round intermediate calculations.)
Net present value $  

Requirement 2:
What is the NPV at a discount rate of 10 percent? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

  Net present value $  

Requirement 3:
What is the NPV at a discount rate of 20 percent? (Do not round intermediate calculations. Negative amount should be indicated by a minus sign.Round your answer to 2 decimal places (e.g., 32.16).)

  Net present value $  

Requirement 4:
What is the NPV at a discount rate of 30 percent? (Do not round intermediate calculations. Negative amount should be indicated by a minus sign. Round your answer to 2 decimal places (e.g., 32.16).)

  Net present value $  


Explanation:
1:
The NPV of a project is the PV of the outflows plus the PV of the inflows. At a zero discount rate (and only at a zero discount rate), the cash flows can be added together across time. So, the NPV of the project at a zero percent required return is:
 
NPV = – $32,000 + 14,200 + 17,500 + 11,600
NPV = $11,300
 
2:
The NPV at a 10 percent required return is:
 
NPV = – $32,000 + $14,200 / 1.10 + $17,500 / 1.102 + $11,600 / 1.103
NPV = $4,087.15
 
3:
The NPV at a 20 percent required return is:
 
NPV = – $32,000 + $14,200 / 1.20 + $17,500 / 1.202 + $11,600 / 1.203
NPV = –$1,300.93
 
4:
And the NPV at a 30 percent required return is:
 
NPV = – $32,000 + $14,200 / 1.30 + $17,500 / 1.302 + $11,600 / 1.303
NPV = – $5,441.97
 
Notice that as the required return increases, the NPV of the project decreases. This will always be true for projects with conventional cash flows. Conventional cash flows are negative at the beginning of the project and positive throughout the rest of the project.
   
Calculator solution:
 
Note: Intermediate answers are shown below as rounded, but the full answer was used to complete the calculation.
  
CFo
 –$32,000
CFo
 –$32,000
C01
 $14,200
C01
 $14,200
F01
 1
F01
 1
C02
 $17,500
C02
 $17,500
F02
 1
F02
 1
C03
 $11,600
C03
 $11,600
F03
 1
F03
 1
  I = 0%   I = 10%
  NPV CPT   NPV CPT
  $11,300.00   $4,087.15
   
CFo
 –$32,000
CFo
 –$32,000
C01
 $14,200
C01
 $14,200
F01
 1
F01
 1
C02
 $17,500
C02
 $17,500
F02
 1
F02
 1
C03
 $11,600
C03
 $11,600
F03
 1
F03
 1
  I = 20%   I = 30%
  NPV CPT   NPV CPT
  –$1,300.93   –$5,441.97

Problem 8-8 Calculating IRR [LO 3] Consider the following cash flows: Year Cash Flow 0 –$ 32,000 1 14,200 2 17,500 3 11,600

Problem 8-8 Calculating IRR [LO 3]
Consider the following cash flows:

Year Cash Flow
0   –$ 32,000  
1     14,200  
2     17,500  
3     11,600  


Required:
What is the IRR of the above set of cash flows? (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).)

  Internal rate of return %  


Explanation:
The IRR is the interest rate that makes the NPV of the project equal to zero. So, the equation that defines the IRR for this project is:
 
0 = – $32,000 + $14,200 / (1 + IRR) + $17,500 / (1 + IRR)2 + $11,600 / (1 + IRR)3
 
Using a spreadsheet, financial calculator, or trial and error to find the root of the equation, we find that:
 
IRR = 17.32%
   
Calculator solution:
 
Note: Intermediate answers are shown below as rounded, but the full answer was used to complete the calculation.
  
CFo
 –$32,000
C01
 $14,200
F01
 1
C02
 $17,500
F02
 1
C03
 $11,600
F03
 1
  IRR CPT
  17.32%

Problem 8-7 Calculating NPV and IRR [LO 3, 4] A project that provides annual cash flows of $2,800 for nine years costs $9,200 today. Requirement 1: At a required return of 11 percent, what is the NPV of the project? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

Problem 8-7 Calculating NPV and IRR [LO 3, 4]
A project that provides annual cash flows of $2,800 for nine years costs $9,200 today.

Requirement 1:
At a required return of 11 percent, what is the NPV of the project? (Do not round intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

  NPV   $  

Requirement 2:
At a required return of 27 percent, what is the NPV of the project? (Do not round intermediate calculations. A negative amount should be indicated by a minus sign. Round your answer to 2 decimal places (e.g., 32.16).)

  NPV   $  

Requirement 3:
At what discount rate would you be indifferent between accepting the project and rejecting it? (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).)

  Discount rate %  


Explanation:

A firm evaluates all of its projects by applying the IRR rule. Year Cash Flow 0 –$ 158,000 1 58,000 2 81,000 3 65,000

A firm evaluates all of its projects by applying the IRR rule.

Year Cash Flow
0 –$ 158,000       
1 58,000       
2 81,000       
3 65,000       


Requirement 1:
What is the project's IRR? (Do not round intermediate calculations. Enter your answer as a percentage rounded to 2 decimal places (e.g., 32.16).)

  Internal rate of return    %  

Requirement 2:
If the required return is 15 percent, should the firm accept the project?
No


Explanation:



Global Toys, Inc., imposes a payback cutoff of three years for its international investment projects. Assume the company has the following two projects available.

Global Toys, Inc., imposes a payback cutoff of three years for its international investment projects. Assume the company has the following two projects available.

Year Cash Flow A Cash Flow B
0 –$ 62,000      –$ 107,000     
1   25,500        27,500     
2   33,200        32,500     
3   27,500        26,500     
4   13,500        233,000     


Requirement 1:
What is the payback period for each project? (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).)

  Payback period  
  Project A years  
  Project B years  


Requirement 2:
Should it accept either of them?
 
Accept project A and reject project B  


Explanation: 1: 
Project A has cash flows of:
 
Cash flows = $25,500 + 33,200
Cash flows = $58,700
 
during the first two years. The cash flows are still short by $3,300 of recapturing the initial investment, so the payback for Project A is:
 
Payback = 2 + ($3,300 / $27,500)
Payback = 2.12 years
 
Project B has cash flows of:
 
Cash flows = $27,500 + 32,500 + 26,500
Cash flows = $86,500
 
during the first three years. The cash flows are still short by $20,500 of recapturing the initial investment, so the payback for Project B is:
 
Payback = 3 + ($20,500 / $233,000)
Payback = 3.09 years
 
2:
Using the payback criterion and a cutoff of 3 years, accept project A and reject project B.