In: Finance
Britney Javelin Company is considering two investments, both of which cost $18,000. The cash flows are as follows: Use Appendix B and Appendix D. Year Project M Project N 1 $7,000 $6,000 2 8,000 7,000 3 7,000 12,000 a. Calculate the payback period for project M and project N. (Round the final answers to 2 decimal places.) Payback period Project M years Project N years b-1. Calculate the NPV for project M and project N. Assume a cost of capital of 8 percent. (Round "PV Factor" to 3 decimal places. Round the intermediate and final answers to the nearest whole dollar.) Net present value Project M $ Project N $ b-2. Which of the two projects should be chosen based on the NPV method? Project M Project N Both c. Should a firm normally have more confidence in answer derived based on NPV method or Payback method?
NPV method Pay back method
| WORKSHEET: | |||||
| PROJECT M: | |||||
| Year | Cash Flow | Cumulative Cash Flow | PVIF at 8% | PV at 8% | |
| 0 | $ (18,000) | $ (18,000) | 1 | $ (18,000) | |
| 1 | $ 7,000 | $ (11,000) | 0.926 | $ 6,482 | |
| 2 | $ 8,000 | $ (3,000) | 0.857 | $ 6,856 | |
| 3 | $ 7,000 | $ 4,000 | 0.794 | $ 5,558 | |
| $ 896 | |||||
| Payback period = 2+3000/7000 = | 2.43 | Years | |||
| NPV = | $ 896 | ||||
| PROJECT N: | |||||
| Year | Cash Flow | Cumulative Cash Flow | PVIF at 8% | PV at 8% | |
| 0 | $ (18,000) | $ (18,000) | 1 | $ (18,000) | |
| 1 | $ 6,000 | $ (12,000) | 0.926 | $ 5,556 | |
| 2 | $ 7,000 | $ (5,000) | 0.857 | $ 5,999 | |
| 3 | $ 12,000 | $ 7,000 | 0.794 | $ 9,528 | |
| $ 3,083 | |||||
| Payback period = 2+5000/12000 = | 2.42 | Years | |||
| NPV = | $ 3,083 | ||||
| ANSWERS: | |||||
| Project M | Project N | ||||
| a] | Payback period in years | 2.43 | 2.42 | ||
| b-1] | NPV = | $ 896 | $ 3,083 | ||
| b-2] | Based on NPV, Project N should be chosen, as it has higher NPV. | ||||
| c] | A firm should normally have more confidence in answer derived based on: | ||||
| NPV method |