Scientific Frontiers Corporation manufactures scientific equipment for use in elementary schools. In December of 20x0 the company's management is considering the acquisition of robotic equipment , which would radically change its manufacturing process. The controller has collected the following data pertinent to the decision 1. The robotic equipment would cost $1,550,000, to be paid in December of 20x0. The equipment's useful life is projected to be eight years. The equipment is in the MACRS 5-year property class. The company will use the MACRS accelerated depreciation schedule. 2. The robotic equipment requires software, which will be developed over a two-year period in 20x1 and 20x2. Each software expenditure, which will amount to $30,000 per year, will be expensed during the year incurred. 3. A computer systems operator will be hired immediately to oversee the operation of the new robotic equipment. The computer expert's annual salary will be $60,000. Fringe benefits will cost $20,000 annually. 4. Maintenance technicians will be needed. The total cost of their wages and fringe benefits will be $180,000 per year. 5. The changeover of the manufacturing line will cost $80,000, to be expensed in 20x1. 6. Several employees will need retraining to operate the new robotic equipment. The training costs are projected as follows: 20x1 20x2 20x3 $40,000 30,000 21,000 7. An inventory of spare parts for the robotic equipment will be purchased immediately at a cost of $50,000. This investment in working capital will be maintained throughout the eight-year life of the equipment. At the end of 20x8, the parts will be sold for $50,000, 8. The robotic equipment's salvage value at the end of 20x8 is projected to be $77,500. It will be fully depreciated at that time. 9. Aside from the costs specifically mentioned above, management expects the robotic equipment to save $590,000 per year in manufacturing costs 10. Switching to the robotic equipment will enable Scientific Frontiers Corporation to sell some of its manufacturing machinery over the next two years. The following sales schedule is projected. Acquisition Cont of Equipment Sold 20x1 5205.000 20x2 360,000 Accumulated Depreciation at Time of Sale $ 122,000 237,000 Sales Proceeds $ 42,000 163,000 Check my was Regulatot o que baid 2011 9205,000 23 360.000 Depreciation Time of SALA 0122.000 237.000 talas Roc 43,000 10,000 11. Scientific Frontiers Corporation's tax rate is 30 percent 12. The company's after tax hurdle rate is 10 percent. Use Ext 16-9 for your reference. Required: Prepare a year-by year columnar schedule including all of the after-tax cash flows associated with the robotic equipment decision Assume that each cash flow will occur at year-end. (Negative amounts should be indicated by a minus sign) 1040 3041 202 200 2014 200 20T Type of Cash 1. Acquisition cost and depreciation taxshi 2. Software development 3. Computer expert's salary and fringe bent Maintenance technicians wages and bringeben 5. Changeover of line 6. Employee training 7. Investment in working capital care parts) Salvage value of equipment Taxect of gain on sale 9. Savings on manufacturing costs 10 Disposal of equipment Sales proceeds Tax effect of gain or lo Total after-tax cash flow EAC X Question 7 - Connect HW:Cho G Scientific Frontiers education.com/ext/map/index.html?_con=con&external_browser=08 apter 16 Acquisition Cost of Equipment Sold 20x1 $205,000 20x2 360,000 Accumulated Depreciation at Tine of Sale $ 122,000 237,000 Sales Proceeds $ 42,000 163,000 11. Scientific Frontiers Corporation's tax rate is 30 percent. 2. The company's after-tax hurdle rate is 10 percent Use Exhibit 16:9 for your reference. Required: Prepare a year-by-year columnar schedule including all of the after-tax c Assume that each cash flow will occur at year-end. (Negative amounts 20x0 Type of Cash Flow 1. Acquisition cost and depreciation tax shield 2. Software development 2 Computer expert's salary and fringe benefits 4. Maintenance technicians wages and fringe benefits 5. Chargeover of line 6. Employee training 7 Investment in working capital reports 8 Salvage value of equipment Tax effect of gain on sale 9. Savings on manufacturing costs 10 Dose of equum Sare proces Taxect of gains Total altercanow