In: Finance
Your company is analyzing the potential purchase of a new set of tractors for over-the-road use with a MACRS depreciable life of 3 years. The new tractors will replace the existing tractors. Depreciation charges will be $27,500 in year 1; $38,000 in year 2; $11,500 in year 3; and $5,700 in year 4. Estimated revenues and expenses are shown in the following table for the new and the old tractors. The company will pay an estimated 34% tax rate. Assume expenses depreciation and interest.
New Tractor Old Tractor
Year Revenue Expenses Revenue Expenses
1 $400,000 $320,000 $350,000 $290,000
2 410,000 320,000 350,000 290,000
3 420,000 320,000 350,000 290,000
(A)Compute operating cash flows (best to set up a table) associated with both the new and the old tractors. Don’t forget to include depreciation in year 4.
(B)Determine the incremental (relevant) operating cash flows as a result of the tractors’ replacement (best to set up a table).
(C)From the results in part B, show the time line of incremental operating cash flows.
1- | ||||
New Machine | ||||
Year | 1 | 2 | 3 | 4 |
revenue | 400000 | 410000 | 420000 | 0 |
expense | 320000 | 320000 | 320000 | 0 |
depreciation | 27500 | 38000 | 11500 | 5700 |
operating profit | 80000 | 90000 | 100000 | -5700 |
less taxes-34% | 27200 | 30600 | 34000 | -1938 |
after tax profit | 52800 | 59400 | 66000 | -3762 |
add depreciation | 27500 | 38000 | 11500 | 5700 |
operating cash flow =after tax profit+depreciation | 80300 | 97400 | 77500 | 1938 |
Old Machine | ||||
Year | 1 | 2 | 3 | |
revenue | 350000 | 350000 | 350000 | |
expense | 290000 | 290000 | 290000 | |
depreciation | 0 | 0 | 0 | |
operating profit | 60000 | 60000 | 60000 | |
less taxes-34% | 20400 | 20400 | 20400 | |
after tax profit | 39600 | 39600 | 39600 | |
add depreciation | 0 | 0 | 0 | |
operating cash flow =after tax profit+depreciation | 39600 | 39600 | 39600 | |
2- | Incremental cash flow | |||
Year | 1 | 2 | 3 | 4 |
Operating cash flow new equipment | 80300 | 97400 | 77500 | 1938 |
Operating cash flow old equipment | 39600 | 39600 | 39600 | 0 |
incremental cash flow | 40700 | 57800 | 37900 | 1938 |
3- | Timeline of incremental cash flow | |||
Year | 1 | 2 | 3 | 4 |
Incremental cash flow | 40700 | 57800 | 37900 | 1938 |