Question

In: Finance

Rogers, Inc., is considering replacing its existing assembly line with a new upgraded model. The CEO...

Rogers, Inc., is considering replacing its existing assembly line with a new upgraded model. The CEO of thecompany, John Rogers, makes $150,000 a year and is in the personal 35% marginal income tax bracket. Aconsulting company in Mr. Rogers’ neighborhood provided the following information about the economiceffects of the replacement:The cost of the upgraded assembly line is estimated to be $500,000 plus installation costs of $50,000.The technology on the upgraded model is more sophisticated than what is on the current model and theemployees would have to be trained how to operate it. The training would occur immediately at a cost$35,000. Training is a tax deductible expense and would be immediately deducted.The new assembly line would require fewer workers and less electricity. The projected before-tax costssavings are $120,000 the first year, increasing at a 3% rate over the ten-year economic life of the project.The new line would be depreciated using five-year MACRS (Year 1: 20%; Year 2: 30%; Year 3: 20%; Year4: 12%; Year 5: 12% and Year 6: 6% - rounded percentages). At the end of the ten-year project life,Rogers would have to pay $40,000 to remove the new model.The existing assembly line originally cost $150,000 eleven years ago. It has been depreciated on thestraight-line basis over fifteen years to a zero salvage value for income tax purposes. It could be soldtoday for $25,000 or operated for ten additional years, at which time it would cost $24,000 to remove.Rogers, Inc., is subject to an average corporate income tax rate of 28% and a marginal income tax rate of30% and uses a 15% after-tax cost of capital to evaluate investment proposals.Required:Clearly identify the after-tax cash flows at time 0, times 1 through 10, and time 10*. It might be easier touse the tax shield approach and consider the present values of the (a) and (b) components over the projects’lives. Determine the Net Present Value of the replacement proposal. Should Rogers replace the existingassembly line?

Solutions

Expert Solution

Particulars 0 1 2 3 4 5 6 7 8 9 10
Cost Saving Growth 3% 3% 3% 3% 3% 3% 3% 3% 3%
Depreciation 20% 30% 20% 12% 12% 6%
Tax Rate 30%
Kc 15%
Old Machinery
Orignal Life 15
Period Old 11
Orignal Cost 150000
Book Value 40000
Selling Value 25000
Loss on sale 15000 (It is Tax Deductible, therefore can be Setoff Later)
Cash Outflows
Price 500000
Installation cost 50000
Cost to be Capitalised 550000
Employee Training Cost 35000 (It is Tax Deductible, therefore can be Setoff Later)
Total Loss to be Setoff 50000
Total Cash Outflow 560000
Cash Inflows
Cost Savings 120000 123600 127308 131127.2 135061.1 139112.9 143286 147585 152012 156573
Add: Saving of cost of Removal (old) 24000
Less: Depreciation 110000 165000 110000 66000 66000 33000
Less: Cost Of removal (New) 40000
Earning Before Tax 10000 -41400 17308 65127.24 69061.06 106112.9 143286 147585 152012 140573
Less: Last year Loss Setoff 10000 0 17308 64092
Taxable Earning 0 -41400 0 1035.24 69061.06 106112.9 143286 147585 152012 140573
Less: Tax 0 0 0 310.572 20718.32 31833.87 42986 44275 45603.7 42171.8
Earning After Tax 10000 -41400 17308 724.668 48342.74 74279.02 100300 103309 106409 98400.9
Net Cash inflow 120000 123600 127308 66724.67 114342.7 107279 100300 103309 106409 98400.9
PV Factor 0.86957 0.756144 0.65752 0.571753 0.497177 0.432328 0.3759 0.3269 0.28426 0.24718
Present Value 104348 93459.36 83707.1 38150.05 56848.55 46379.68 37707 33772 30248 24323.2
PV of Inflow using 15% at Year 0 548942.4

Related Solutions

The company is considering a new assembly line to replace the existing assembly line. The existing...
The company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 3 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 6 more years. The new assembly line costs $120,000; requires $9,000 in installation costs and $5,000 in training fees; it has a 6-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 3 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 6 more years. The new assembly line costs $120,000; requires $9,000 in installation costs and $5,000 in training fees; it has a 6-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 3 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 6 more years. The new assembly line costs $120,000; requires $9,000 in installation costs and $5,000 in training fees; it has a 6-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 3 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 6 more years. The new assembly line costs $120,000; requires $9,000 in installation costs and $5,000 in training fees; it has a 6-year usable life and would be depreciated under the straight-line...
Lincon Company is considering a new assembly line to replace the existing assembly line. The existing...
Lincon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 2 years ago at a cost of $105,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 5 more years. The new assembly line costs $150,000; requires $5,000 in installation costs and $4,000 in training fees; it has a 5-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 3 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 6 more years. The new assembly line costs $120,000; requires $9,000 in installation costs and $5,000 in training fees; it has a 6-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 2 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 4 more years. The new assembly line costs $120,000; requires $8,000 in installation costs and $5,000 in training fees; it has a 4-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 2 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 4 more years. The new assembly line costs $120,000; requires $8,000 in installation costs and $5,000 in training fees; it has a 4-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 2 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 4 more years. The new assembly line costs $120,000; requires $8,000 in installation costs and $5,000 in training fees; it has a 4-year usable life and would be depreciated under the straight-line...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing...
Macon Company is considering a new assembly line to replace the existing assembly line. The existing assembly line was installed 2 years ago at a cost of $90,000; it was being depreciated under the straight-line method. The existing assembly line is expected to have a usable life of 4 more years. The new assembly line costs $120,000; requires $8,000 in installation costs and $5,000 in training fees; it has a 4-year usable life and would be depreciated under the straight-line...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT