Question

In: Finance

Your company is analyzing the potential purchase of a new set of tractors for over-the-road use...

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.

Solutions

Expert Solution

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

Related Solutions

Your company has purchased a large new truck-tractor for over the road use. It has a...
Your company has purchased a large new truck-tractor for over the road use. It has a cost basis of $209,697. Its MV at the end of 18 years is estimated as $1,271. Assume it will be depreciated using DDB method and the depreciation period is 18 years. What is the depreciation payment in year 4?
A construction company is purchasing a new Tractor for over the road use. The IRS classifies...
A construction company is purchasing a new Tractor for over the road use. The IRS classifies this as 3-year property. The truck costs $347000. a) Determine the depreciation allowance for each year using SLN method. b) Determine the depreciation allowance for each year using DDB method. c) Determine the depreciation allowance for each year using MACRS. d) Using a 10% MARR calculate the present worth of the depreciation for each of the 3 methods above.
A construction company is purchasing a new Tractor for over the road use. The IRS classifies...
A construction company is purchasing a new Tractor for over the road use. The IRS classifies this as 3-year property. The truck costs $297000. a) Determine the depreciation allowance for each year using SLN method. Year 1 $   Year 2 $   Year 3 $   Year 4 $   b) Determine the depreciation allowance for each year using DDB method. Year 1 $   Year 2 $   Year 3 $   Year 4 $   c) Determine the depreciation allowance for each year using MACRS....
A construction company is purchasing a new Tractor for over the road use. The IRS classifies...
A construction company is purchasing a new Tractor for over the road use. The IRS classifies this as 3-year property. The truck costs $280000. a) Determine the depreciation allowance for each year using SLN method. Year 1 $ Year 2 $ Year 3 $ Year 4 $ b) Determine the depreciation allowance for each year using DDB method. Year 1 $ Year 2 $ Year 3 $ Year 4 $ c) Determine the depreciation allowance for each year using MACRS....
Your company has purchased a large new trucktractor for​ over-the-road use​ (asset class​ 00.26). It has...
Your company has purchased a large new trucktractor for​ over-the-road use​ (asset class​ 00.26). It has a cost basis of ​$185000. With additional options costing ​$13000​, the cost basis for depreciation purposes is ​$198000. Its MV at the end of four years is estimated as ​$42000. Assume it will be depreciated under the​ GDS: a. What is the cumulative depreciation through the end of year two​? b. What is the MACRS depreciation in the third ​year? c. What is the...
1. Your company is analyzing the possible purchase of new equipment at a cost of $150,000....
1. Your company is analyzing the possible purchase of new equipment at a cost of $150,000. Assume straight-line depreciation and a 3-year depreciable life. It is estimated the equipment would save:$120,000 in Year 1$120,000 in Year 2$120,000 in Year 3$120,000 in Year 4Project operating costs are expected to be $40,000 each year. The firm’s income tax rate is 21 percent, and its required rate of return or cost of capital is 12 percent. Calculate the Net Present Value (NPV) of...
The operations manager for an auto supply company is evaluating the potential purchase of a new...
The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component.   Current manufacturing costs are fixed costs of $11,000 and a variable cost of $0.50 per unit.  The new machine would have fixed cost of $4,000 and a variable cost of $0.75 per unit. Each component is sold for $1.50 per unit. a.  Develop two separate models in your spreadsheet to calculate Total Profit for each option. (8 pts)             The...
A tractor for over-the-road hauling is purchased for $80,000.00. It is expected to be of use...
A tractor for over-the-road hauling is purchased for $80,000.00. It is expected to be of use to the company for 6 years, after which it will be salvaged for $3,600.00. Calculate the depreciation deduction and the unrecovered investment during each year of the tractors life. a. Use straight-line depreciation. Provide depreciation and book value for year 6. Depreciation for year 6 =? $ book value for year 6 =? $ b. Use declining-balance depreciation, with a rate that ensures the...
A tractor for over-the-road hauling is purchased for $75,000.00. It is expected to be of use...
A tractor for over-the-road hauling is purchased for $75,000.00. It is expected to be of use to the company for 6 years, after which it will be salvaged for $3,200.00. Calculate the depreciation deduction and the unrecovered investment during each year of the tractors life. a. Use straight-line depreciation. Provide depreciation and book value for year 6. b. Use declining-balance depreciation, with a rate that ensures the book value equals the salvage value. Provide depreciation and book value for year...
A tractor for over-the-road hauling is purchased for $90,000. It is expected to be of use...
A tractor for over-the-road hauling is purchased for $90,000. It is expected to be of use to the company for 6 years, after which it will be salvaged for $4,000. Calculate the depreciation deduction and the unrecovered investment during each year of the tractor's life. Use double declining balance switching to straight line depreciation. Please show excel equations if excel is used!
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT