Determine using the internal rates of return criterion

Reference no: EM13263093

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. Provide Spreadsheet formulas.

1. Determine which will offer the largest internal rate of return for AWS.

2. Determine using the internal rates of return criterion with an incremental analysis which will offer the largest monetary benefit to AWS if their MARR is 12%.

3. What is the difference between parts a and b?

Altern- ative	Investment in year 0	Annual Cash Flow	Salvage value in last year
A1	$50,000	$18,000	$0
A2	$250,000	$85,000	$75,000
A3	$350,000	$110,000	$175,000
A4	$600,000	$150,000	$400,000
A5	$800,000	$175,000	$600,000

Reference no: EM13263093

Questions Cloud

Compute the resistance ratiomeasured between their ends : Two conductors are made of the same material and have the same length. Conductor A is a solid wire of diameter 1.5 mm. What is the resistance ratio RA/RB, measured between their ends

What about if we keep the 95 percent confidence level : In our example of research on lipstick, where E = $2 and S = $29, what sample size would we require if we desired a 99 percent confidence level? What about if we keep the 95 percent confidence level, but decide that our acceptable error is $4?

What is the different between quality and quality assurance : Mr. Dhar Baratula is a good speaker because he speaks confidently, clarity and good explaining and he has a high position as the manufacturedirector of medical crop.

Calculate the force the floor exerts on the passenger : An elevator is moving up at a constant velocity of 2.5 m/s Calculate the force the floor exerts on the passenger, Calculate the force the floor exerts on the passenger

Determine using the internal rates of return criterion : Determine using the internal rates of return criterion with an incremental analysis which will offer the largest monetary benefit to AWS if their MARR is 12%.

Changes in a dna molecule may have no effect on the protein : the following changes in a DNA molecule may have no effect on the protein for which the DNA codes

What is the energy output of the machine per second : An electric motor with a 2.7-hp output drives a machine with an efficiency of 35%. What is the energy output of the machine per second

Determine what mah capacity should the batteries have : A student project requires a 6 V DC power supply that can source 300 mA. The batteries for the power supply must last for a minimum of 8 hours of continuous operation. NiMH rechargeable batteries in AA size are to be used.

What is the portfolio beta : Susan Richmand has $150,000 invested in a 2-stock portfolio. $43,600 is invested in Stock X and the remainder is invested in Stock Y. X's beta is 1.70 and Y's beta is 0.80. What is the portfolio's beta?

User Account

All Pages