Replace Equipment A machine with a book value of $82,500 has an estimated five-year life. A proposal is offered to sell the old machine for $48,000 and replace it with a new machine at a cost of $72,000. The new machine has a five-year life with no residual value. The new machine would reduce annual direct labor costs from $10,300 to $8,300. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Prepare a differential analysis dated June 2 on whether to continue with the old machine (Alternative 1) or replace the old machine (Alternative 2). If an amount is zero, enter "0". Use a minus sign to indicate costs, losses, or negative differential effect on income. Revenues: Proceeds from sale of old machine. Costs: Purchase price Direct labor (5 years) Differential Analysis Continue (Alt. 1) or Replace (Alt. 2) Old Machine June 2 Continue with Old Profit (Loss) Machine (Alternative 1). Replace Old Machine (Alternative 2) Differential Effects (Alternative 2)

Replace Equipment A machine with a book value of $82,500 has an estimated five-year life. A proposal is offered to sell the old machine for $48,000 and replace it with a new machine at a cost of $72,000. The new machine has a five-year life with no residual value. The new machine would reduce annual direct labor costs from $10,300 to $8,300. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. X Open spreadsheet a. Prepare a differential analysis dated June 2 on whether to continue with the old machine (Alternative 1) or replace the old machine (Alternative 2). If an amount is zero, enter "0". Use a minus sign to indicate costs, losses, or negative differential effect on income. Revenues: Proceeds from sale of old machine. Costs: Purchase price Direct labor (5 years) Differential Analysis Continue (Alt. 1) or Replace (Alt. 2) Old Machine June 2 Continue with Old Profit (Loss) Machine (Alternative 1). Replace Old Machine (Alternative 2) Differential Effects (Alternative 2)

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

Replace equipment A machine with a book value of $86,000 has an estimated five-year life. A proposal is offered to sell the old machine for $40,500 and replace it with a new machine at a cost of $67,000. The new machine has a five-year life with no residual value. The new machine would reduce annual direct labor costs from $10,300 to $9,700. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Prepare a differential analysis dated April 11 on whether to continue with the old machine (Alternative 1) or replace the old machine (Alternative 2). If an amount is zero, enter "0". Use a minus sign to indicate costs, losses, or negative differential effect on income.
Give typing answer with explanation and conclusion A new production system for a factory is to be purchased and installed for $154982. This system will save approximately 300,000 kWh of electric power each year for a 6-year period. Assume the cost of electricity is $0.10 per kWh, and factory MARR is 15% per year, and the salvage value of the system will be $9668 at year 6. Using the PW method to analyzes if this investment is economically justified A- calculate the PW of the above investment and insert the result below.
Please view the following video before answering this question. Video Solution: 05.02-PR010 Click here to access the TVM Factor Table Calculator Bailey, Inc., is considering buying a new gang punch that would allow them to produce circuit boards more efficiently. The punch has a first cost of $70,000 and a useful life of 15 years. At the end of its useful life, the punch has no salvage value. Annual labor costs would increase $2,200 using the gang punch, but annual raw material costs would decrease $12,000. MARR is 5%/year. Part a What is the future worth of this investment? $ eTextbook and Media Round entry to nearest dollar. The tolerance is ±2.
The management of Ballard MicroBrew is considering the purchase of an automated bottling machine for $69,000. The machine would replace an old piece of equipment that costs $17,000 per year to operate. The new machine would cost $7,000 per year to operate. The old machine currently in use could be sold now for a salvage value of $23,000. The new machine would have a useful life of 10 years with no salvage value. Required: 1. What is the annual depreciation expense associated with the new bottling machine? 2. What is the annual incremental net operating income provided by the new bottling machine? 3. What is the amount of the initial investment associated with this project that should be used for calculating the simple rate of return? 4. What is the simple rate of return on the new bottling machine? (Round your answer to 1 decimal place i.e. 0.123 should be considered as 12.3%.) 1. Depreciation expense 2. Incremental net operating income 3 Initial…
BAK Corp. is considering purchasing one of two new diagnostic machines. Either machine would make it possible for the company to bid on jobs that it currently isn't equipped to do. Estimates regarding each machine are provided below. Original cost Estimated life Salvage value Estimated annual cash inflows Estimated annual cash outflows Net present value. Machine A $76,600 Profitability index 8 years Which machine should be purchased? $19,900 $4,890 Machine A 0 Click here to view the factor table. Calculate the net present value and profitability index of each machine. Assume a 9% discount rate. (If the net present value is negative, use either a negative sign preceding the number eg-45 or parentheses eg (45). Round answer for present value to 0 decimal places, e.g. 125 and profitability index to 2 decimal places, e.g. 10.50. For calculation purposes, use 5 decimal places as displayed in the factor table provided.) should be purchased. Machine B $179,000 8 years 0 $40,400 $9,940 Machine…
Crane Corp. is considering purchasing one of two new diagnostic machines. Either machine would make it possible for the company to bid on jobs that it currently isn't equipped to do. Estimates regarding each machine are provided here. Original cost Estimated life Salvage value Estimated annual cash inflows Estimated annual cash outflows Net present value Machine A $77,000 8 years 0 Profitability index $19,900 $4,800 Machine A Which machine should be purchased? Click here to view the factor table. Calculate the net present value and profitability index of each machine. Assume a 9% discount rate. (If the net present value is negative. use either a negative sign preceding the number eg -45 or parentheses eg (45). Round answer for present value to 0 decimal places, e.g. 125 and profitability index to 2 decimal places, e.g. 10.50. For calculation purposes, use 5 decimal places as displayed in the factor table provided.) Machine B should be purchased. $188,000 8 years 0 $40,200 $9,860…
The management of Ballard MicroBrew is considering the purchase of an automated bottling machine for $55,000. The machine would replace an old piece of equipment that costs $14,000 per year to operate. The new machine would cost $6,000 per year to operate. The old machine currently in use could be sold now for a salvage value of $20,000. The new machine would have a useful life of 10 years with no salvage value. Required: 1. What is the annual depreciation expense associated with the new bottling machine? 2. What is the annual incremental net operating income provided by the new bottling machine? 3. What is the amount of the initial investment associated with this project that should be used for calculating the simple rate of return? 4. What is the simple rate of return on the new bottling machine? (Round your answer to 1 decimal place i.e. 0.123 should be considered as 12.3%.)
BAK Corp. is considering purchasing one of two new diagnostic machines. Either machine would make it possible for the company to bid on jobs that it currently isn't equipped to do. Estimates regarding each machine are provided here Original cost Estimated life Salvage value Estimated annual cash inflows Estimated annual cash outflows Machine A $75,500 8 years 0 Net present value Profitability index $20,000 $5,000 Click here to view PV table. Calculate the net present value and profitability index of each machine. Assume a 9% discount rate. (If the net present value is negative, use either a negative sign preceding the number eg -45 or parentheses es (45). Round answer for present value to 0 decimal places, eg. 125 and profitability index to 2 decimal places, eg. 10.50. For calculation purposes, use 5 decimal places as displayed in the factor table provided.) Machine A Which machine should be purchased? Machine A should be purchased Machine B $180,000 8 years 0 $40,000 $10,000 Machine B…
Your company is considering an expansion into a new product area. The company has collected the following information about the proposed product. (Note: You may or may not need to use all of this information, use only the information that is relevant.) The project has an anticipated economic life of 5 years. The company will have to purchase a new machine to produce the product. The machine has an up-front cost (T = 0) of $750,000. The machine will be depreciated on a straight-line basis over 5 years (that is, the company's depreciation expense will be $150,000 in each of the first five years (T = 1, 2, 3, 4, and 5). The company anticipates that the machine will last for at least five years, and that after five years, its before-tax salvage value will equal $100,000. If the company goes ahead with the project, it will have an effect on the company's net working capital. At the outset, T = 0, inventory will increase by $50,000 and accounts payable will increase by $30,000. At T =…
Oriole Corp. is considering purchasing one of two new diagnostic machines. Either machine would make it possible for the company to bid on jobs that it currently isn't equipped to do. Estimates regarding each machine are provided here. Original cost Estimated life Salvage value Estimated annual cash inflows Estimated annual cash outflows Click here to view PV table. Net present value Profitability index Machine A Which machine should be purchased? Machine A $76,700 8 years $20,100 $4,910 Machine A 0 Calculate the net present value and profitability index of each machine. Assume a 9% discount rate. (If the net present value is negative, use either a negative sign preceding the number eg -45 or parentheses eg (45). Round answer for present value to O decimal places, e.g. 125 and profitability index to 2 decimal places, e.g. 10.50. For calculation purposes, use 5 decimal places as displayed in the factor table provided.) 0 should be purchased. 6478 Machine B 1.08 $188,000 8 years 0…
Assume that your company is considering a new project and has collected the following information about the project. (Note: You may or may not need to use all of this information, use only the information that is relevant.) The project has an anticipated economic life of 4 years. The company will have to purchase a new machine. The machine will have an up-front cost of $2 million at Year O. The machine will be depreciated on a straight-line basis over 4 years (that is, depreciation expense will be $500,000 in each of Years 1-4). The company anticipates that the machine will last for four years, and that after four years, its salvage value will equal zero. If the company goes ahead with the proposed product, it will have an effect on the company's net operating working capital. At the outset, Year O, inventory will increase by $140,000 and accounts payable will increase by $40,000. At Year 4, the net operating working capital will be recovered after the project is completed. The project…
Give typing answer with explanation and conclusion The Bruin's Den Outdoor Gear is considering a new 6-year project to produce a new tent line. The equipment necessary would cost $1.29 million and be depreciated using straight-line depreciation to a book value of zero. At the end of the project, the equipment can be sold for 15 percent of its initial cost. The company believes that it can sell 23,500 tents per year at a price of $64 and variable costs of $25 per tent. The fixed costs will be $395,000 per year. The project will require an initial investment in net working capital of $193,000 that will be recovered at the end of the project. The required rate of return is 10.7 percent and the tax rate is 21 percent. What is the NPV? a) $848,697 b) $655,697 c) $572,631 d) $743,822 e) $677,778