In: Accounting
Chapter 11 Exercise A4
Assume a company is going to make an investment of $450,000 in a machine and the following are the cash flows that two different products would bring in years one through four.
| Option A, Product A | Option B, Product B | |||
| $190,000 | $150,000 | |||
| 190,000 | 180,000 | |||
| 60,000 | 60,000 | |||
| 20,000 | 70,000 | |||
Which of the two options would you choose based on this payback method?
Option A should be selected.
Option A has a lower payback period than Option B.
Working
| Payback period calculation for Option A, Product A | |||||
| Year | Cash inflows | Cash outflows | Net Cash inflows | Cumulative Cash flow | |
| 0 | -$ 450,000 | -$ 450,000 | |||
| 1 | $ 190,000 | $ 190,000 | -$ 260,000 | ||
| 2 | $ 190,000 | $ 190,000 | -$ 70,000 | ||
| 3 | $ 60,000 | $ 60,000 | -$ 10,000 | ||
| 4 | $ 20,000 | $ 20,000 | $ 10,000 | ||
| Payback period (3 years + (10000/20000)) | 3.5 | Years | |||
.
| Payback period calculation for Option B, Product B | |||||
| Year | Cash inflows | Cash outflows | Net Cash inflows | Cumulative Cash flow | |
| 0 | -$ 450,000 | -$ 450,000 | |||
| 1 | $ 150,000 | $ 150,000 | -$ 300,000 | ||
| 2 | $ 180,000 | $ 180,000 | -$ 120,000 | ||
| 3 | $ 60,000 | $ 60,000 | -$ 60,000 | ||
| 4 | $ 70,000 | $ 70,000 | $ 10,000 | ||
| Payback period (3 years + (60000/70000)) | 3.86 | Years | |||