In: Accounting
Operating cash inflows Strong Tool Company has been considering purchasing a new lathe to replace a fully depreciated lathe that would otherwise last 5 more years. The new lathe is expected to have a 5-year life and depreciation charges of $2,020 in Year 1; $3,232 in Year 2; $1,919 in Year 3; $1,212 in both Year 4 and Year 5; and $505 in Year 6. The firm estimates the revenues and expenses (excluding depreciation and interest) for the new and the old lathes to be as shown in the following table
|
New Lathe |
Old Lathe |
||||
|
Year |
Revenue |
Expenses (excluding depreciation and interest) |
Revenue |
Expenses (excluding depreciation and interest) |
|
|
1 |
$40,300 |
$28,600 |
$36,500 |
$24,000 |
|
|
2 |
41,300 |
28,600 |
36,500 |
24,000 |
|
|
3 |
42,300 |
28,600 |
36,500 |
24,000 |
|
|
4 |
43,300 |
28,600 |
36,500 |
24,000 |
|
|
5 |
44,300 |
28,600 |
36,500 |
24,000 | |
. The firm is subject to a 40% tax rate on ordinary income.
a. Calculate the operating cash inflows associated with each lathe. (Note: Be sure to consider the depreciation in year 6.)
b. Calculate the operating cash inflows resulting from the proposed lathe replacement.
c. Depict on a time line the incremental operating cash inflows calculated in part b.
a. Calculate the operating cash inflows associated with the new lathe below: (Round to the nearest dollar.)
|
Year |
1 |
|
|
Revenue |
$ |
40,300 |
|
Expenses (excluding depreciation and interest) |
$ |
28,600 |
|
Profit before depreciation and taxes |
$ |
11,700 |
|
Depreciation |
$ |
2,020 |
|
Net profit before taxes |
$ |
9,680 |
|
Taxes |
$ |
3,872 |
|
Net profit after taxes |
$ |
5,808 |
|
Operating cash flows |
$ |
7,828 |
(Round to the nearest dollar.)
|
Year |
2 |
|
|
Revenue |
$ |
41,300 |
|
Expenses (excluding depreciation and interest) |
$ |
28,600 |
|
Profit before depreciation and taxes |
$ |
12,700 |
|
Depreciation |
$ |
3,232 |
|
Net profit before taxes |
$ |
9,468 |
|
Taxes |
$ |
3,787 |
|
Net profit after taxes |
$ |
5,681 |
|
Operating cash flows |
$ |
8,913 |
(Round to the nearest dollar.)
|
Year |
3 |
|
|
Revenue |
$ |
42,300 |
|
Expenses (excluding depreciation and interest) |
$ |
28,600 |
|
Profit before depreciation and taxes |
$ |
13,700 |
|
Depreciation |
$ |
1,919 |
|
Net profit before taxes |
$ |
11,781 |
|
Taxes |
$ |
4,712 |
|
Net profit after taxes |
$ |
7,069 |
|
Operating cash flows |
$ |
8,988 |
(Round to the nearest dollar.)
|
Year |
4 |
|
|
Revenue |
$ |
43,300 |
|
Expenses (excluding depreciation and interest) |
$ |
28,600 |
|
Profit before depreciation and taxes |
$ |
14,700 |
|
Depreciation |
$ |
1,212 |
|
Net profit before taxes |
$ |
13,488 |
|
Taxes |
$ |
5,395 |
|
Net profit after taxes |
$ |
8,093 |
|
Operating cash flows |
$ |
9,305 |
(Round to the nearest dollar.)
|
Year |
5 |
|
|
Revenue |
$ |
44,300 |
|
Expenses (excluding depreciation and interest) |
$ |
28,600 |
|
Profit before depreciation and taxes |
$ |
15,700 |
|
Depreciation |
$ |
1,212 |
|
Net profit before taxes |
$ |
14,488 |
|
Taxes |
$ |
5,795 |
|
Net profit after taxes |
$ |
8,693 |
|
Operating cash flows |
$ |
9,905 |
|
Year |
6 |
|
|
Revenue |
$ |
|
|
Expenses (excluding depreciation and interest) |
$ |
|
|
Profit before depreciation and taxes |
$ |
|
|
Depreciation |
$ |
|
|
Net profit before taxes |
$ |
|
|
Taxes |
$ |
|
|
Net profit after taxes |
$ |
|
|
Operating cash flows |
$ |
|
Answer (a): Operating Cash inflows from Old Lathe
| Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Revenue | $ 36,500 | $ 36,500 | $ 36,500 | $ 36,500 | $ 36,500 | |
| Less |
Expenses (excluding depreciation and interest) |
$ 24,000 | $ 24,000 | $ 24,000 | $ 24,000 | $ 24,000 |
| Less | Depreciation | $ - | $ - | $ - | $ - | $ - |
| Net profit before taxes | $ 12,500 | $ 12,500 | $ 12,500 | $ 12,500 | $ 12,500 | |
| Less: | Taxes @ 40% | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 | $ 5,000 |
| Net profit after taxes | $ 7,500 | $ 7,500 | $ 7,500 | $ 7,500 | $ 7,500 | |
| Add: | Depreciation | $ - | $ - | $ - | $ - | $ - |
| Operating Cash Flows | $ 7,500 | $ 7,500 | $ 7,500 | $ 7,500 | $ 7,500 | |
Answer (b): Operating Cash inflows from Proposed Lathe
| Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | |
| Revenue | $ 40,300 | $ 41,300 | $ 42,300 | $ 43,300 | $ 44,300 | $ - | |
| Less |
Expenses (excluding depreciation and interest) |
$ 28,600 | $ 28,600 | $ 28,600 | $ 28,600 | $ 28,600 | $ - |
| Less | Depreciation | $ 2,020 | $ 3,232 | $ 1,919 | $ 1,212 | $ 1,212 | $ 1,212 |
| Net profit before taxes | $ 9,680 | $ 9,468 | $ 11,781 | $ 13,488 | $ 14,488 | $ (1,212) | |
| Less: | Taxes @ 40% | $ 3,872 | $ 3,787 | $ 4,712 | $ 5,395 | $ 5,795 | $ (485) |
| Net profit after taxes | $ 5,808 | $ 5,681 | $ 7,069 | $ 8,093 | $ 8,693 | $ (727) | |
| Add: | Depreciation | $ 2,020 | $ 3,232 | $ 1,919 | $ 1,212 | $ 1,212 | $ 1,212 |
| Operating Cash Inflows | $ 7,828 | $ 8,913 | $ 8,988 | $ 9,305 | $ 9,905 | $ 485 |
Answer (c): Incremental Operating Cash Inflows
| Particulars | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |
| As per Old Lathe (A) | $ 7,500 | $ 7,500 | $ 7,500 | $ 7,500 | $ 7,500 | $ - |
| As per Proposed Lathe (B) | $ 7,828 | $ 8,913 | $ 8,988 | $ 9,305 | $ 9,905 | $ 485 |
| Incremental Cash Inflows (B)- (A) | $ 328 | $ 1,413 | $ 1,488 | $ 1,805 | $ 2,405 | $ 485 |