In: Finance
Relevant cash flows—No terminal value Central Laundry and Cleaners is considering replacing an existing piece of machinery with a more sophisticated machine. The old machine was purchased 3 years ago at a cost of $46,800, and this amount was being depreciated under MACRS using a 5-year recovery period. The machine has 5 years of usable life remaining. The new machine that is being considered costs $75,900 and requires $3,600 in installation costs. The new machine would be depreciated under MACRS using a 5-year recovery period. The firm can currently sell the old machine for $55,900 without incurring any removal or cleanup costs. The firm is subject to a tax rate of 40%. The revenues and expenses (excluding depreciation and interest) associated with the new and the old machines for the next 5 years are given in the table
New machine |
Old machine |
||||
Year |
Revenue |
Expenses (excluding depreciation and interest) |
Revenue |
Expenses (excluding depreciation and interest) |
|
1 |
$749,600 |
$720,600 |
$674,700 |
$660,400 |
|
2 |
749,600 |
720,600 |
676,700 |
660,400 |
|
3 |
749,600 |
720,600 |
680,700 |
660,400 |
|
4 |
749,600 |
720,600 |
78,700 |
660,400 |
|
5 |
749,600 |
720,600 |
674,700 |
660,400 |
Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes |
||||
Percentage by recovery year* |
||||
Recovery year |
3 years |
5 years |
7 years |
10 years |
1 |
33% |
20% |
14% |
10% |
2 |
45% |
32% |
25% |
18% |
3 |
15% |
19% |
18% |
14% |
4 |
7% |
12% |
12% |
12% |
5 |
12% |
9% |
9% |
|
6 |
5% |
9% |
8% |
|
7 |
9% |
7% |
||
8 |
4% |
6% |
||
9 |
6% |
contains the applicable MACRS depreciation percentages.) Note: The new machine will have no terminal value at the end of 5 years.
a. Calculate the initial investment associated with replacement of the old machine by the new one.
b. Determine the incremental operating cash inflows associated with the proposed replacement. (Note: Be sure to consider the depreciation in year 6.)
c. Depict on a time line the relevant cash flows found in parts (a) and (b) associated with the proposed replacement decision.
(A) Initial investment Amount
Particulars | Amount ($) |
Cost of New machine | 75900 |
Add : Installation cost | 3600 |
Less : sale of old machine | (55900) |
Initial investment require | $ 23600 |
(B) Incremental cash inflow
Cash inflow of old machine
on old machine already 3 year depreciation is provided.
particular | year1 | 2 | 3 | 4 | 5 |
revenue | 749600 | 749600 | 749600 | 749600 | 749600 |
less - exp | (720600) | (720600) | (720600) | (720600) | (720600) |
less - Dep | (5616) | (5616) | (2340) | 0 | 0 |
PBT | 23384 | 23384 | 26660 | 29000 | 29000 |
Less - tax 40% | 9353.60 | 9353.60 | 10664 | 11600 | 11600 |
PAT | 14030.40 | 14030.40 | 15996 | 17400 | 17400 |
Add - Dep | 5616 | 5616 | 2340 | 0 | 0 |
cash inflow | 19646.40 | 19646.40 | 18336 | 17400 | 17400 |
cash inflow of new machine
it is assumed that 4 th year's revenue is 6,78700 but you provided 78700 it seems wrong . if assumed amount is wrong then change 4 th year calculation only .
particular | year1 | 2 | 3 | 4 | 5 |
revenue | 674700 | 676700 | 680700 | 678700 | 674700 |
less - exp | (660400) | (660400) | (660400) | (660400) | (660400) |
less - Dep | (15900) | (25440) | (15105) | (9540) | (9540) |
PBT | (1600) | (9140) | 5195 | 8760 | 4760 |
Less - tax 40% | 640 | 3656 | (2078) | (3504) | (1904) |
PAT | (960) | (5484) | 3117 | 5456 | 2856 |
Add - Dep | 15900 | 25440 | 15105 | 9540 | 9540 |
cash inflow | 14940 | 19956 | 18222 | 14796 | 12396 |
increnental cash inflow
year | old machine | new machine | increment |
1 | 19646.40 | 14940 | -4706.4 |
2 | 19646.40 | 19956 | 309.6 |
3 | 19336 | 18222 | -1114 |
4 | 17400 | 14796 | -2604 |
5 | 17400 | 12396 | -5004 |
(C) here only 2nd year shows incremental cash inflows . therefore it is not beneficeal for replace the machine with new one