Because of its inability to control film and personnel costs in its radiology department, Sanger General Hospital wants to replace its existing picture archive and communication (PAC) system with a newer version. The existing system, which has a current book value of $2,250,000, was purchased three years ago for $3,600,000 and is being depreciated on a straight-line basis over an eight-year life to a salvage value of $0. This system could be sold for $800,000 today. The new PAC system would reduce the need for staff by eight people per year for five years at a savings of $40,000 per person per year, and it would reduce film costs by $2,000,000 per year. The project would not affect the level of net working capital. The new PAC system would cost $9,000,000 and would be depreciated on a straight-line basis over a five-year life to a salvage value of $0. The economic life of a new system is five years, and the required rate of return on the project is 7 percent.
a) Should the existing PAC system be replaced? Use the
incremental NPV approach to evaluate the decision; assume the
hospital is a not-for-profit facility.
b) If the facility were a taxpaying entity with a tax rate of 30
percent, should the existing PAC system be replaced? Use the
incremental NPV approach to evaluate the decision. (Hint: see
Appendix F.)
Given, the current book value of Old system= $2,250,000
Price at which the old system is sold= $800,000
Savings in staff by replacement of old system= $40,000*8= $320,000
Reduction in film costs= $2,000,000
Price of new PAC system= $9,000,000
Life of the new PAC system= 5 years
a. It is given that the hospital is a not-for-profit facility. So, neither it would get an tax advantage at selling the old PAC system below its book value or have to pay any taxes for any increase in income.
Initial cash flow due to replacement of old system= -Price of new system is bought+ Price at which old system is sold= -$9,000,000+$800,000 = -$8,200,000
Increase in cash flow per year by replacing the old system= Savings in terms of staff+ Savings in film costs
=$320,000+$2,000,000= $2,320,000
Discounting the yearly incremental cash flow for the next 5 years at the required rate of return of 7% we have,
=$2,320,000/(1.07)+$2,320,000/(1.07^2)+$2,320,000/(1.07^3)+$2,320,000/(1.07^4)+$2,320,000/(1.07^5)
=$9,512,458.05
So, net incremental cash flow in buying the new machine= -$8,200,000+$9,512,458.05 = $1,312,458.05
Therefore, the hospital should buy the new PAC machine if it doesn't pay any taxes.
b. Given, tax rate= 30%
Tax advantage due to selling the old PAC machine at a price below the book value = 30%* ($2,250,000-$800,000)= $435,000
The old machine was bought at $3,600,000 and depreciated over 8 years while the new machine is being bought at $9,000,000 and is being depreciated over the next 5 years.
So change in depreciation costs= 9,000,000/5 - 3,600,000/8 = $1,800,000-450,000 = $1,350,000
Yearly incremental profit by buying the new machine= Savings in terms of staff+ Savings in film costs- Increase in depreciation costs
=$320,000+$2,000,000-$1,350,000
=$970,000
So, income tax paid on the incremental profit= 30%*$970,000= $291,000
Now, taking the incremental cash flow from the above part a and adjusting it for the yearly income tax paid we have,
=Savings in terms of staff+ Savings in film costs- Incremental income tax paid
=$320,000+$2,000,000-$291,000
=$2,029,000
Discounting the yearly incremental cash flow for the next 5 years at the required rate of return of 7% we have,
=$2,029,000/(1.07)+$2,029,000/(1.07^2)+$2,029,000/(1.07^3)+$2,029,000/(1.07^4)+$2,029,000/(1.07^5)
=$8,319,300.60
So, incremental cash flow in buying the machine= -Cost of buying the new machine+After tax Proceeds from the selling the old machine+ Present value of future cash flows due to buying the new machine
=-$9,000,000 + ($800,000+$435,000) + $8,319,300.60
=$554300.60
Therefore, the hospital should buy the new machine as there is a net positive cash flow.
Because of its inability to control film and personnel costs in its radiology department, Sanger General...
Sway's Back Store is considering a project which will require the purchase of $5 million in new equipment. The equipment will be depreciated straight-line to a book value of $0.5 million over the 5-year life of the project. Annual sales from this project are estimated at $950,000. The variable cost is 40% of the annual sales and there is an annual fixed cost of $100,000. Sway's Back Store will sell the equipment at the end of the project for a...
Cash flows estimation and capital budgeting: You are the head of finance department in XYZ Company. You are considering adding a new machine to your production facility. The new machine’s base price is $10,000.00, and it would cost another $2,280.00 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after three years for $1,850.00. The machine would require an increase in net...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $890,000, and it would cost another $16,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $662,000. The machine would require an increase in net working capital (inventory) of $15,000. The sprayer would not change revenues, but it is...
Important: Show your solutions! QUESTION 1: Consider the following two projects: Year Cash Flow (A) Cash Flow (B) -$364,000 -$52,000 25,000 46,000 68,000 22,000 68,000 21,500 458,000 17,500 Whichever project you choose, if any, you require a return of 11 percent on your investment. 1) Suppose these two projects are independent. Which project(s) should you accept based on: a. The Payback rule? Explain. (1096) b. The Profitability Index rule? Explain. (10%) c. The IRR rule? Explain. (10%) d. The NPV...
Fatima Corporation has the following information pertaining to the purchase of a new piece of equipment: Cash revenues less cash expenses $40,000 per year Cost of equipment Salvage value at the end of the year Increase in working capital requirements $70,000 $7,000 $30,000 Tax rate Life 30 percent 6 years Cost of capital is 11 percent. Required (use excel): a. Calculate the following assuming straight-line depreciation: i. Calculate the after-tax net income for each of the six years. ii. Calculate...
A company is considering a three-year project. New equipment will cost $200,000. The equipment falls in the MACRS three-year class (.3333, .4445, .1481, .0741) it will have a salvage value at the end of the project of $50,000. The project is expected to produce sales of $100,000 in the first year and sales will increase by $50,000 each year after that. Expense are expected to be 40% of sales. An investment in net-working capital of $5,000 is required at the...
You must evaluate the purchase of a proposed spectrometer for the R&D department. The base price is $120,000, and it would cost another $30,000 to modify the equipment for special use by the firm. The equipment falls into the MACRS 3-year class and would be sold after 3 years for $36,000. The applicable depreciation rates are 33%, 45%, 15%, and 7%. The equipment would require an $13,000 increase in net operating working capital (spare parts inventory). The project would have...
1. undersatnd how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c) Develop problem-solving and critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 2) New equipment cost $(200,000) 3) Equipment ship & install cost $(35,000) 4) Related start up cost $(5,000) 5) Inventory increase $25,000 6) Accounts Payable increase $5,000 7) Equip. salvage value before tax $15,000 8) Sales...
Plastic division has an expansion opportunity that costs 550,000, with a residual value of 50,000 and a useful life of 5 years. Assume Straight Line depreciation for accrual purposes and MACRS for taxes. The cost of capital (minimum required return) is 11 percent and the effective tax rate is 29 percent. The annual sales increase due to this project is 350,000 with 90 percent in cash for the year and a contribution margin ratio of 65 percent. The increase in...
LoRusso Co. i considering replacing an existing piece of equipment. The project involves the following: The new equipment will have a cost of $1,200,000, and it is eligible for 100% bonus depreciation so it will be fully depreciated at t 0 The old machine was purchased before the new tax law, so it is being depreciated on a straight-line basis. It has a book value of $200,000 (at year 0) and four more years of depreciation left ($50,000 per year)...