Scientific Frontiers Corporation manufactures scientific equipment for use in elementary schools In December of 20x0 the companys 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 The robotic equipment would cost $1,450,000, to be paid in December of 20x0 The equipments 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 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 $39,000 per year, will be expensed during the year incurred A computer systems operator will be hired immediately to oversee the operation of the new robotic equipment The computer experts annual salary will be $78,000 Fringe benefits will cost $29,000 annually Maintenance technicians will be needed The total cost of their wages and fringe benefits will be $225,000 per year The changeover of the manufacturing line will cost $89,000, to be expensed in 20x1 Several employees will need retraining to operate the new robotic equipment The training costs are projected as follows 20x1 $ 49,000 20x2 39,000 20x3 30,000 An inventory of spare parts for the robotic equipment will be purchased immediately at a cost of $59,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 $59,000 The robotic equipments salvage value at the end of 20x8 is projected to be $72,500 It will be fully depreciated at that time Aside from the costs specifically mentioned above, management expects the robotic equipment to save $680,000 per year in manufacturing costs 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 Cost of Equipment Sold Accumulated Depreciation at Time of Sale Sales Proceeds 20x1 $ 250,000 $ 140,000 $ 60,000 20x2 405,000 255,000 199,000 Scientific Frontiers Corporations tax rate is 30 percent The companys after tax hurdle rate is 12 percent Use Exhibit 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 ) Scientific Frontiers Corporation manufactures scientific equipment for use in elementary schools In December of 20x0 the companys 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 The robotic equipment would cost $1,450,000, to be paid in December of 20x0 The equipments 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 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 $39,000 per year, will be expensed during the year incurred A computer systems operator will be hired immediately to oversee the operation of the new robotic equipment The computer experts annual salary will be $78,000 Fringe benefits will cost $29,000 annually Maintenance technicians will be needed The total cost of their wages and fringe benefits will be $225,000 per year The changeover of the manufacturing line will cost $89,000, to be expensed in 20x1 Several employees will need retraining to operate the new robotic equipment The training costs are projected as follows 20x1 $ 49,000 20x2 39,000 20x3 30,000 An inventory of spare parts for the robotic equipment will be purchased immediately at a cost of $59,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 $59,000 The robotic equipments salvage value at the end of 20x8 is projected to be $72,500 It will be fully depreciated at that time Aside from the costs specifically mentioned above, management expects the robotic equipment to save $680,000 per year in manufacturing costs 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 Cost of Equipment Sold Accumulated Depreciation at Time of Sale Sales Proceeds 20x1 $ 250,000 $ 140,000 $ 60,000 20x2 405,000 255,000 199,000 Scientific Frontiers Corporations tax rate is 30 percent The companys after tax hurdle rate is 12 percent Use Exhibit 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 ) Scientific Frontiers Corporation manufactures scientific equipment for use in elementary schools In December of 20x0 the companys 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 The robotic equipment would cost $1,450,000, to be paid in December of 20x0 The equipments 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 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 $39,000 per year, will be expensed during the year incurred A computer systems operator will be hired immediately to oversee the operation of the new robotic equipment The computer experts annual salary will be $78,000 Fringe benefits will cost $29,000 annually Maintenance technicians will be needed The total cost of their wages and fringe benefits will be $225,000 per year The changeover of the manufacturing line will cost $89,000, to be expensed in 20x1 Several employees will need retraining to operate the new robotic equipment The training costs are projected as follows 20x1 $ 49,000 20x2 39,000 20x3 30,000 An inventory of spare parts for the robotic equipment will be purchased immediately at a cost of $59,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 $59,000 The robotic equipments salvage value at the end of 20x8 is projected to be $72,500 It will be fully depreciated at that time Aside from the costs specifically mentioned above, management expects the robotic equipment to save $680,000 per year in manufacturing costs 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 Cost of Equipment Sold Accumulated Depreciation at Time of Sale Sales Proceeds 20x1 $ 250,000 $ 140,000 $ 60,000 20x2 405,000 255,000 199,000 Scientific Frontiers Corporations tax rate is 30 percent The companys after tax hurdle rate is 12 percent Use Exhibit 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 ) 20x0 20x1 20x2 20x3 20x4 20x5 20x6 20x7 20x8 1 Acquistion cost and depreciation tax shield 2 software devolpment 3 computer expert salary and fringe benefits 4 maintence technicians wage and fringe benifts 5 Changeover of line 6 employee training 7 investment in working capital (spare parts) 8 Salvage value of equipment tax effect of gain on sale 9 Saving on manufacturing cost 10 disposal of equipment sales proceeds Tax effect of gain or loss total after tax cash flow

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 28, 2024

Scientific Frontiers Corporation manufactures scientific equipment for use in elementary schools. In December of 20x0 the companys management is considering the acquisition of robotic equipment,

Scientific Frontiers Corporation manufactures scientific equipment for use in elementary schools. In December of 20x0 the companys 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.

The robotic equipment would cost $1,450,000, to be paid in December of 20x0. The equipments 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.
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 $39,000 per year, will be expensed during the year incurred.
A computer systems operator will be hired immediately to oversee the operation of the new robotic equipment. The computer experts annual salary will be $78,000. Fringe benefits will cost $29,000 annually.
Maintenance technicians will be needed. The total cost of their wages and fringe benefits will be $225,000 per year.
The changeover of the manufacturing line will cost $89,000, to be expensed in 20x1.
Several employees will need retraining to operate the new robotic equipment. The training costs are projected as follows:


20x1	$	49,000
20x2		39,000
20x3		30,000

An inventory of spare parts for the robotic equipment will be purchased immediately at a cost of $59,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 $59,000.
The robotic equipments salvage value at the end of 20x8 is projected to be $72,500. It will be fully depreciated at that time.
Aside from the costs specifically mentioned above, management expects the robotic equipment to save $680,000 per year in manufacturing costs.
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 Cost of Equipment Sold			Accumulated Depreciation at Time of Sale			Sales Proceeds
20x1		$	250,000		$	140,000		$	60,000
20x2			405,000			255,000			199,000

Scientific Frontiers Corporations tax rate is 30 percent.
The companys after-tax hurdle rate is 12 percent.

Use Exhibit 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.)

The robotic equipment would cost $1,450,000, to be paid in December of 20x0. The equipments 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.
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 $39,000 per year, will be expensed during the year incurred.
A computer systems operator will be hired immediately to oversee the operation of the new robotic equipment. The computer experts annual salary will be $78,000. Fringe benefits will cost $29,000 annually.
Maintenance technicians will be needed. The total cost of their wages and fringe benefits will be $225,000 per year.
The changeover of the manufacturing line will cost $89,000, to be expensed in 20x1.
Several employees will need retraining to operate the new robotic equipment. The training costs are projected as follows:


20x1	$	49,000
20x2		39,000
20x3		30,000

An inventory of spare parts for the robotic equipment will be purchased immediately at a cost of $59,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 $59,000.
The robotic equipments salvage value at the end of 20x8 is projected to be $72,500. It will be fully depreciated at that time.
Aside from the costs specifically mentioned above, management expects the robotic equipment to save $680,000 per year in manufacturing costs.
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 Cost of Equipment Sold			Accumulated Depreciation at Time of Sale			Sales Proceeds
20x1		$	250,000		$	140,000		$	60,000
20x2			405,000			255,000			199,000

Scientific Frontiers Corporations tax rate is 30 percent.
The companys after-tax hurdle rate is 12 percent.

Use Exhibit 16-9 for your reference.

Required:

The robotic equipment would cost $1,450,000, to be paid in December of 20x0. The equipments 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.
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 $39,000 per year, will be expensed during the year incurred.
A computer systems operator will be hired immediately to oversee the operation of the new robotic equipment. The computer experts annual salary will be $78,000. Fringe benefits will cost $29,000 annually.
Maintenance technicians will be needed. The total cost of their wages and fringe benefits will be $225,000 per year.
The changeover of the manufacturing line will cost $89,000, to be expensed in 20x1.
Several employees will need retraining to operate the new robotic equipment. The training costs are projected as follows:


20x1	$	49,000
20x2		39,000
20x3		30,000

An inventory of spare parts for the robotic equipment will be purchased immediately at a cost of $59,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 $59,000.
The robotic equipments salvage value at the end of 20x8 is projected to be $72,500. It will be fully depreciated at that time.
Aside from the costs specifically mentioned above, management expects the robotic equipment to save $680,000 per year in manufacturing costs.
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.