In: Finance
Britney Javelin Company is considering two investments, both of which cost $46,000. The cash flows are as follows: Use Appendix B and Appendix D.
Year | Project M | Project N | ||||
1 | $24,000 | $19,000 | ||||
2 | 19,000 | 23,000 | ||||
3 | 16,000 | 20,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
a)
cash outflow for M and N = 46000 | ||||||
project M | project N | |||||
year | cashflow | cumulative cashflow | year | cashflow | cumulative cashflow | |
1 | 24000 | 24000 | 1 | 19000 | 19000 | |
2 | 19000 | 43000 | 2 | 23000 | 42000 | |
3 | 16000 | 59000 | 3 | 20000 | 62000 |
PROJECT M
Pay back period= 2 years +[ (46000-43000)/ (59000-43000) ] * 12
2 years + (3000/16000) * 12
2 years + .1875 * 12
2 years and 2.25 months
Payback period of M = 2 years and 2.25 months
PROJECT N
Pay back period= 2 years +[ (46000-42000)/ (62000-42000) ] * 12
2 years + (4000/20000) * 12
2 years + .2 * 12
2 years and 2.4 months
Payback period of N = 2 years and 2.4 months
b-1)
cash outflow for M and N = 46000 | ||||||||
project M | project N | |||||||
year | cashflow | pvf @ 8% | present value | year | cashflow | pvf @ 8% | present value | |
1 | 24000 | 0.926 | 22224 | 1 | 19000 | 0.926 | 17594 | |
2 | 19000 | 0.857 | 16283 | 2 | 23000 | 0.857 | 19711 | |
3 | 16000 | 0.794 | 12704 | 3 | 20000 | 0.794 | 15880 | |
Total present value | 51211 | Total present value | 53185 | |||||
(less) cash outflow | -46000 | (less) cash outflow | -46000 | |||||
Net Present Value (NPV) | 5211 | Net Present Value (NPV) | 7185 |
b-2)
Project M and Project N showing positive NPV. According to the NPV method the Britney Javelin Company can select the Project N, because which have higher NPV as compared to Project M.