Question: Show me how to get this answer in microsoft excel. One year ago, your company purchased a machine used in manufacturing for $ 1 0

Show me how to get this answer in microsoft excel.
One year ago, your company purchased a machine used in manufacturing for $105,000. You have learned that a new machine is available that offers many advantages and you can purchase it for $145,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 $35,000 per year for the next 10 years. The current machine is expected to produce a gross margin of $21,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 $9,545 per year. The market value today of the current machine is $45,000. Your company's tax rate is 38%, and the opportunity cost of capital for this type of equipment is 12%. Should your company replace its year-old machine?
The NPV of replacing the year-old machine is $-21,144.(Round to the nearest dollar.)
Should your company replace its year-old machine? (Select the best choice below.)
A. No, there is a loss from replacing the machine.
B. Yes, there is a profit from replacing the machine.
 Show me how to get this answer in microsoft excel. One

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!