In: Finance
Consider the following information:
| Cash Flows ($) | |||||
| Project | C0 | C1 | C2 | C3 | C4 | 
| A | –6,200 | 2,200 | 2,200 | 2,900 | 0 | 
| B | –1,500 | 0 | 1,000 | 3,200 | 4,200 | 
| C | –3,800 | 2,200 | 1,300 | 1,700 | 1,200 | 
a. What is the payback period on each of the above projects? (Round your answers to 2 decimal places.)
| Project | Payback Period | ||
| A | year(s) | ||
| B | year(s) | ||
| C | year(s) | ||
b. Given that you wish to use the payback rule with a cutoff period of two years, which projects would you accept?
| Project A, Project B, and Project C | |
| None | |
| Project A and Project C | |
| Project B and Project C | |
| Project A | |
| Project C | |
| Project B | |
| Project A and Project B | 
c. If you use a cutoff period of three years, which projects would you accept?
| Project A | |
| Project B | |
| Project A and Project C | |
| Project A, Project B, and Project C | |
| Project A and Project B | |
| Project C | |
| Project B and Project C | 
d. If the opportunity cost of capital is 12%, which projects have positive NPVs?
| Project A and Project B | |
| Project A and Project C | |
| Project A | |
| Project B | |
| Project A, Project B, and Project C | |
| Project C | |
| Project B and Project C | 
e. “If a firm uses a single cutoff period for all projects, it is likely to accept too many short-lived projects.” True or false?
| True | |
| False | 
f-1. If the firm uses the discounted-payback rule, will it accept any negative-NPV projects?
| Yes | |
| No | 
f-2. Will it turn down positive-NPV projects?
| Yes | |
| No | 
a.
| 
 Project  | 
 Payback Period  | 
| 
 A  | 
 2.62 Years  | 
| 
 B  | 
 2.16 Years  | 
| 
 C  | 
 2.18 Years  | 
Explanation:
Payback Period = A +B/C
Where,
A = Last period with a negative cumulative cash flow
B = Absolute value of cumulative cash flow at the end of the period A
C = Total cash flow during the period after A
| 
 Project A  | 
 Project B  | 
 Project C  | 
||||
| 
 Year  | 
 Cash Flow  | 
 ‘CUM Cash Flow  | 
 Cash Flow  | 
 ‘CUM Cash Flow  | 
 Cash Flow  | 
 ‘CUM Cash Flow  | 
| 
 0  | 
 ($6,200)  | 
 ($6,200)  | 
 ($1,500)  | 
 ($1,500)  | 
 ($3,800)  | 
 ($3,800)  | 
| 
 1  | 
 $2,200  | 
 ($4,000)  | 
 $0  | 
 ($1,500)  | 
 $2,200  | 
 ($1,600)  | 
| 
 2  | 
 $2,200  | 
 ($1,800)  | 
 $1,000  | 
 ($500)  | 
 $1,300  | 
 ($300)  | 
| 
 3  | 
 $2,900  | 
 $1,100  | 
 $3,200  | 
 $2,700  | 
 $1,700  | 
 $1,400  | 
| 
 4  | 
 $0  | 
 $1,100  | 
 $4,200  | 
 $6,900  | 
 $1,200  | 
 $2,600  | 
Payback period for Project A = 2 + $ 1,800/$ 2,900 = 2 + 0.6206896552 = 2.6206896552 or 2.62 years
Payback period for Project B = 2 + $ 500/$ 3,200 = 2 + 0.15625 = 2.15625 or 2.16 years
Payback period for Project C = 2 + $ 300/$ 1,700 = 2 + 0.1764705882 = 2.1764705882 or 2.18 years
b.
If cut-off period is of 2 years, none of the project is acceptable as all the projects have payback period more than 2 years.
c.
If cut-off period is of 3 years, all of the three projects are acceptable as all the projects have payback period less than 3 years. So Project A, Project B, Project C is acceptable.
d.
If opportunity cost of capital is 12 %, Project B and Project C have positive NPVs.
Explanation:
| 
 Project A  | 
 Project B  | 
 Project C  | 
||||||
| 
 Year  | 
 PV Factor Computation  | 
 PV Factor @ 12 % (F)  | 
 Cash Flow (CA)  | 
 PV (F x CA)  | 
 Cash Flow (CB)  | 
 PV (F x CB)  | 
 Cash Flow (CC)  | 
 PV (F x CC)  | 
| 
 0  | 
 1/(1+0.12)0  | 
 1  | 
 ($6,200)  | 
 ($6,200.00)  | 
 ($1,500)  | 
 ($1,500)  | 
 ($3,800)  | 
 ($3,800)  | 
| 
 1  | 
 1/(1+0.12)1  | 
 0.892857142857143  | 
 $2,200  | 
 $1,964.2857  | 
 $0  | 
 $0  | 
 $2,200  | 
 $1,964  | 
| 
 2  | 
 1/(1+0.12) 2  | 
 0.797193877551020  | 
 $2,200  | 
 $1,753.8265  | 
 $1,000  | 
 $797  | 
 $1,300  | 
 $1,036  | 
| 
 3  | 
 1/(1+0.12)3  | 
 0.711780247813411  | 
 $2,900  | 
 $2,064.1627  | 
 $3,200  | 
 $2,278  | 
 $1,700  | 
 $1,210  | 
| 
 4  | 
 1/(1+0.12)4  | 
 0.635518078404831  | 
 $0  | 
 $0.0000  | 
 $4,200  | 
 $2,669  | 
 $1,200  | 
 $763  | 
| 
 NPV  | 
 ($417.7250)  | 
 NPV  | 
 $4,244.0666  | 
 NPV  | 
 $1,173.2859  | 
|||
e.
“If a firm uses a single cutoff period for all projects, it is likely to accept too many short-lived Projects.”
True.
f-1.
No, the firm will not accept any project with negative NPV. Discounted payback period cannot be computed for such negative NPV projects.
f-2.
The firm may turn-down positive NPV project, if discounted payback period is higher than cut-off period.