In: Accounting
Cash Payback Method
Lily Products Company is considering an investment in one of two new product lines. The investment required for either product line is $540,000. The net cash flows associated with each product are as follows:
Year | Liquid Soap | Body Lotion | ||
1 | $170,000 | $ 90,000 | ||
2 | 150,000 | 90,000 | ||
3 | 120,000 | 90,000 | ||
4 | 100,000 | 90,000 | ||
5 | 70,000 | 90,000 | ||
6 | 40,000 | 90,000 | ||
7 | 40,000 | 90,000 | ||
8 | 30,000 | 90,000 | ||
Total | $720,000 | $720,000 |
a. Recommend a product offering to Lily
Products Company, based on the cash payback period for each product
line.
Payback period for liquid soap | |
Payback period for body lotion |
b. The project with the net cash flows in the early years of the project life will be favored over the one with the net cash flows in the initial years.
Sollution a
a) Liquidity soap should be preferred | ||
Paback period for liquidity soap | 4 | years |
Paback period for body lotion | 6 | years |
working
Payback period | ||||
Liquid soap | Body Lotion | |||
Time | Amount | Cumulative | Amount | Cumulative |
0 | -$540,000.00 | -$540,000.00 | -$540,000.00 | -$540,000.00 |
1 | $170,000.00 | -$370,000.00 | $90,000.00 | -$450,000.00 |
2 | $150,000.00 | -$220,000.00 | $90,000.00 | -$360,000.00 |
3 | $120,000.00 | -$100,000.00 | $90,000.00 | -$270,000.00 |
4 | $100,000.00 | $0.00 | $90,000.00 | -$180,000.00 |
5 | $70,000.00 | $70,000.00 | $90,000.00 | -$90,000.00 |
6 | $40,000.00 | $110,000.00 | $90,000.00 | $0.00 |
7 | $40,000.00 | $150,000.00 | $90,000.00 | $90,000.00 |
8 | $30,000.00 | $180,000.00 | $90,000.00 | $180,000.00 |
Payback period | 4 Years | 6 Years |
Sollution b
The project with the higher net cash flows in the early years of the project life will be Favored over the one with the lower net cash flows in initial years |