In: Accounting
PLEASE DO PROBLEM
A machine can be purchased for $60,000 and used for five years,
yielding the following net incomes. In projecting net incomes,
straight-line depreciation is applied, using a five-year life and a
zero salvage value.
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||||||||||||||||
Net income | $ | 3,900 | $ | 9,900 | $ | 32,000 | $ | 14,700 | $ | 39,600 | ||||||||||
Compute the machine’s payback period (ignore taxes). (Round your intermediate calculations to 3 decimal places and round payback period answer to 3 decimal places.)
|
Year |
Net Income |
Depreciation |
Net Cash Flow |
Cumulative Cash Flow |
[Period] |
[A] |
[B] |
[C=A + B] |
[D = D + C] |
0 |
$ (60,000.00) |
$ (60,000.00) |
||
1 |
$ 3,900.00 |
$ 12,000.00 |
$ 15,900.00 |
$ (44,100.00) |
2 |
$ 9,900.00 |
$ 12,000.00 |
$ 21,900.00 |
$ (22,200.00) |
3 |
$ 32,000.00 |
$ 12,000.00 |
$ 44,000.00 |
$ 21,800.00 |
4 |
$ 14,700.00 |
$ 12,000.00 |
$ 26,700.00 |
$ 48,500.00 |
5 |
$ 39,600.00 |
$ 12,000.00 |
$ 51,600.00 |
$ 1,00,100.00 |
Time taken to recover $ 11,500 in year 5 = $11,500 / $ 51,600 = 0.223