Question: Please show solution and steps using excel (in details please) attach the excel file if that is possible Staunch company is considering expanding its range

Please show solution and steps using excel (in details please) attach the excel file if that is possible

Please show solution and steps using excel (in details please) attach theexcel file if that is possible Staunch company is considering expanding its

Staunch company is considering expanding its range of industrial machinery products by manufacturing machine tables, saddles, machine bases, and other similar parts. Several combinations of new equipment and personnel could serve to fulfill this new function. Option l: New machining center with three operators Option 2: New machining center with an automatic pallet changer and three operator Option3 : New machining center with an automatic pallet changer and two-sharing operators Staunch company has estimated the investment costs and additional revenues in the following table. Machining Center Design Options Option 2 Option 3 Option 1 $230,000 $280,000 $210,000 Investment: Total investment Annual benefits: Year1 Year1: Net revenues Year2-5: Net revenues Market value in year 5 $40,000 Constant $100,000 $60,000 Constant $120,000 $30,000 =13% per year $90,000 If the MARR=15%, which option would be selected? On the same excel spreadsheet use excel functions to: a- Calculate the Present Worth of each option and choose the best alternative b- Calculate the Annual Worth of each option and choose the best alternative C- Calculate the IRR of each option and choose the best alternative

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!