In: Accounting
Joe’s Hardware is adding a new product line that will require an investment of
$ 1,476,000. Managers estimate that this investment will have a 10-year life and generate net cash inflows of $ 310,000 the first year, $ 280,000 the second year, and $ 230,000
each year thereafter for eight years. Compute the payback period. Round to one decimal place.
Payback Period = ( Last Year with a Negative Cash Flow ) + [( Absolute Value of negative Cash Flow in that year)/ Total Cash Flow in the following year)]
= 5 +( 196,000 / 230,000)
= 5.852173913 Years
Hence the correct answer is 5.9 Years
Note:
| Year | Investment | Cash Inflow | Net Cash Flow | |
| 0 | -14,76,000 | - | -14,76,000 | (Investment + Cash Inflow) |
| 1 | - | 3,10,000 | -11,66,000 | (Net Cash Flow + Cash Inflow) |
| 2 | - | 2,80,000 | -8,86,000 | (Net Cash Flow + Cash Inflow) |
| 3 | - | 2,30,000 | -6,56,000 | (Net Cash Flow + Cash Inflow) |
| 4 | - | 2,30,000 | -4,26,000 | (Net Cash Flow + Cash Inflow) |
| 5 | - | 2,30,000 | -1,96,000 | (Net Cash Flow + Cash Inflow) |
| 6 | - | 2,30,000 | 34,000 | (Net Cash Flow + Cash Inflow) |
| 7 | - | 2,30,000 | 2,64,000 | (Net Cash Flow + Cash Inflow) |
| 8 | - | 2,30,000 | 4,94,000 | (Net Cash Flow + Cash Inflow) |
| 9 | - | 2,30,000 | 7,24,000 | (Net Cash Flow + Cash Inflow) |
| 10 | - | 2,30,000 | 9,54,000 | (Net Cash Flow + Cash Inflow) |