Question: Please solve the following question using excel and show all work. Thank you! One year ago, your company purchased a machine used in manufacturing for

Please solve the following question using excel and show all work. ThankPlease solve the following question using excel and show all work. Thank you!

One year ago, your company purchased a machine used in manufacturing for $95,000. You have learned that a new machine is available that offers many advantages and you can purchase it for $170,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin (revenues minus operating expenses other than depreciation) of $60,000 per year for the next 10 years. The current machine is expected to produce a gross margin of $22,000 per year. The current machine is being depreciated on a straight-line basis over a useful life of 11 years, and has no salvage value, so depreciation expense for the current machine is $8,636 per year. The market value today of the current machine is $65,000. Your company's tax rate is 38%, and the opportunity cost of capital for this type of equipment is 10%. Should your company replace its year-old machine? The NPV of replacing the year-old machine is $. (Round to the nearest dollar.) One year ago, your company purchased a machine used in manufacturing for $95,000. You have learned that a new machine is available that offers many advantages and you can purchase it for $170,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin (revenues minus operating expenses other than depreciation) of $60,000 per year for the next 10 years. The current machine is expected to produce a gross margin of $22,000 per year. The current machine is being depreciated on a straight-line basis over a useful life of 11 years, and has no salvage value, so depreciation expense for the current machine is $8,636 per year. The market value today of the current machine is $65,000. Your company's tax rate is 38%, and the opportunity cost of capital for this type of equipment is 10%. Should your company replace its year-old machine? The NPV of replacing the year-old machine is $. (Round to the nearest dollar.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!