Assignment 7: Evaluation Criteria using IRR
Automated Welding Services, Inc. (AWS) business has been growing and they need to raise their automation to the next level. They have collected data on five alternative machines/processes for which the data is shown below. Only a single alternative will be selected. AWS uses a 5-year time horizon for project justifications. Submit your solution in a spreadsheet.
Determine which will offer the largest internal rate of return for AWS.
Using an internal rate of return criterion with an incremental analysis, determine which alternative will offer the largest monetary benefit to AWS if their MARR is 12%.
Determine the present worth of each alternative.
Investment in year 0
Annual Cash Flow
Salvage value in last year