In: Accounting
Birch manufacturing is considering the addition of another product line to its offerings. Equipment needed to produce the new line will cost $192,410. Birch estimates that the net cash inflows from the new product line will be as follows: Years 1-10 $17,750 (each year) Years 11-15 $4,970 (each year) Year 16-20 $2,070
If the company can establish a steady customer base before production starts and the cash inflows will be $14,400 per year for years 1 – 15, what will be the payback period? (Round answer to 2 decimal places, e.g. 1.64.)
The payback period years?
Pay back peroid | ||
Year | Cash flow | Cumulative cash flow |
0 | ($192,410) | ($192,410) |
1 | $17,750 | ($174,660) |
2 | $17,750 | ($156,910) |
3 | $17,750 | ($139,160) |
4 | $17,750 | ($121,410) |
5 | $17,750 | ($103,660) |
6 | $17,750 | ($85,910) |
7 | $17,750 | ($68,160) |
8 | $17,750 | ($50,410) |
9 | $17,750 | ($32,660) |
10 | $17,750 | ($14,910) |
11 | $4,970 | ($9,940) |
12 | $4,970 | ($4,970) |
13 | $4,970 | $0 |
14 | $4,970 | $4,970 |
15 | $4,970 | $9,940 |
16 | $2,070 | $12,010 |
17 | $2,070 | $14,080 |
18 | $2,070 | $16,150 |
19 | $2,070 | $18,220 |
20 | $2,070 | $20,290 |
Payback period = 12 years | ||
Pay back peroid if company eastablish customer base | ||
Year | Cash flow | Cumulative cash flow |
0 | ($192,410) | ($192,410) |
1 | $14,400 | ($178,010) |
2 | $14,400 | ($163,610) |
3 | $14,400 | ($149,210) |
4 | $14,400 | ($134,810) |
5 | $14,400 | ($120,410) |
6 | $14,400 | ($106,010) |
7 | $14,400 | ($91,610) |
8 | $14,400 | ($77,210) |
9 | $14,400 | ($62,810) |
10 | $14,400 | ($48,410) |
11 | $14,400 | ($34,010) |
12 | $14,400 | ($19,610) |
13 | $14,400 | ($5,210) |
14 | $14,400 | $9,190 |
15 | $14,400 | $23,590 |
Pay back period = $192410/$14400 | ||
13.36 years | ||