In: Finance
X-treme Vitamin Company is considering two investments, both of which cost $11,000. The cash flows are as follows: Year Project A Project B 1 $ 15,000 $ 11,000 2 6,000 6,000 3 5,000 10,000 Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a-1. Calculate the payback period for Project A and Project B. (Round your answers to 2 decimal places.) a-2. Which of the two projects should be chosen based on the payback method? Project A correct b-1. Calculate the net present value for Project A and Project B. Assume a cost of capital of 8 percent. (Do not round intermediate calculations and round your final answers to 2 decimal places.)
a-1
Project A | ||
Year | Cash flow stream | Cumulative cash flow |
0 | -11000 | -11000 |
1 | 15000 | 4000 |
2 | 6000 | 10000 |
3 | 5000 | 15000 |
Payback period is the time by which undiscounted cashflow cover the intial investment outlay | |||||
this is happening between year 0 and 1 | |||||
therefore by interpolation payback period = 0 + (0-(-11000))/(4000-(-11000)) | |||||
0.73 Years |
Project B | ||
Year | Cash flow stream | Cumulative cash flow |
0 | -11000 | -11000 |
1 | 11000 | 0 |
2 | 6000 | 6000 |
3 | 10000 | 16000 |
Payback period is the time by which undiscounted cashflow cover the intial investment outlay | |||||
this is happening at the end of year 1 | |||||
therefore payback period is: | |||||
1 Years |
a-2
Choose Project B as it has smaller payback
b-1
Project A | ||||
Discount rate | 8.000% | |||
Year | 0 | 1 | 2 | 3 |
Cash flow stream | -11000 | 15000 | 6000 | 5000 |
Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 |
Discounted cash flows project | -11000.000 | 13888.889 | 5144.033 | 3969.161 |
NPV = Sum of discounted cash flows | ||||
NPV Project A = | 12002.08 | |||
Where | ||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||
Discounted Cashflow= | Cash flow stream/discounting factor |
Project B | ||||
Discount rate | 8.000% | |||
Year | 0 | 1 | 2 | 3 |
Cash flow stream | -11000 | 11000 | 6000 | 10000 |
Discounting factor | 1.000 | 1.080 | 1.166 | 1.260 |
Discounted cash flows project | -11000.000 | 10185.185 | 5144.033 | 7938.322 |
NPV = Sum of discounted cash flows | ||||
NPV Project B = | 12267.54 | |||
Where | ||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||
Discounted Cashflow= | Cash flow stream/discounting factor |