2.
A.
Payback period for alternative A = 65/16.3 = 3.99 years
Payback period for alternative B = 55/15.1 = 3.64 years
Payback period for alternative C = 25/5.2 = 4.81 years
Payback period for alternative D = 80/21.3 = 3.76 years
The alternative B will be selected, because it has smallest payback period that is 3.64 years.
B .
Future worth of alternative A = 16.3*(1.09^6 - 1)/.09 - 65*1.09^6 = $13.62
Future worth of alternative B = 15.1*(1.09^6 - 1)/.09 - 55*1.09^6 = $21.36
Future worth of alternative C = 5.2*(1.09^6 - 1)/.09 - 25*1.09^6 = -$2.81
Future worth of alternative D = 21.3*(1.09^6 - 1)/.09 - 80*1.09^6 = $26.08
Alternative D will be selected because, it has higher future worth that is $26.08.
C.
Benefit cost ratio of alternative A = (16.3*(1-1/1.09^6)/.09)/65 = 1.124
Benefit cost ratio of alternative B = (15.1*(1-1/1.09^6)/.09)/55 = 1.232
Benefit cost ratio of alternative C = (5.2*(1-1/1.09^6)/.09)/25 = .933
Benefit cost ratio of alternative D = (21.3*(1-1/1.09^6)/.09)/80 = 1.194
The alternative B will be selected, because it has highest benefit cost ratio of 1.232.
2) [Problem 9-50) Consider four mutually exclusive alternatives: A B C D Cost $65 $55 $25...
please show excel formulas so I can understand the problem THANKS 9-50 Consider four mutually exclusive alternatives: (Α) A B C D Cost $75.0 $50.0 $15.0 $90.0 Uniform annual 18.8 13.9 4.5 23.8 benefit Each alternative has a 5-year useful life and no sal- vage value. The MARR is 10%. Which alternative should be selected, based on (a) The payback period (b) Future worth analysis (c) Benefit-cost ratio analysis
9-54 Three mutually exclusive alternatives are beine A considered: $500 $400 $300 200 100 Initial cost Benefit at end of the first 200 200 year Uniform benefit at end of 100 125 subsequent years Useful life, in years 4 At the end of its useful life, an alternative is not replaced. If the MARR is 10%, which alternative should be selected (a) Based on the payback period? (b) Based on benefit-cost ratio analysis? 9-54 Three mutually exclusive alternatives are beine...
Do not use Excel or tables 9-54 Three mutually exclusive alternatives are being considered: Initial cost Benefit at end of the first $500 $400 $300 200 200 200 100 4 year Uniform benefit at end of 100 125 subsequent years Useful life, in years At the end of its useful life, an alternative is not replaced. If the MARR is 10%, which alternative should be selected (a) Based on the payback period? (b) Based on benefit-cost ratio analysis?
Three mutually exclusive alternatives are being considered: Initial cost Benefit at end of the first $500 $400 $300 200 200 200 year Uniform benefit at end of 100 125 100 subsequent years Useful life, in years 4 At the end of its useful life, an alternative is not replaced. If the MARR is 10%, which alternative should be selected (a) Based on the payback period? (b) Based on benefit-cost ratio analysis?
Consider 3 mutually exclusive alternatives, each with a 10-year useful life. If the MARR (Minimum acceptable rate of return) is 14.5%, which alternative should be selected? Solve the problem using benefit-cost ratio analysis. Alternative Choice Choice Choice #1 #2 #3 Cost 810 131 305 62 145 36 Uniform Annual benefit
Consider three mutually exclusive alternatives, each with a 15-year useful life. If the MARR is 12%, which alternative should be selected? Solve the problem by using benefit-cost ratio analysis, Net Present Value, and Internal Rate of Return. A B C Cost $800 $300 $150 Uniform Annual Benefit 130 60 35
Need cash flow diagram 04) Three mutually exclusive alternative are being considered Initial Cost Benefit at the end of the first Year Uniform Annual Benefits at end of subsequent years Useful Life in years $500 $200 $100 $400 $200 $125 $300 $200 $100 At the end of its useful life, an alternative is not replaced. If MARR is 10%, which alternatives should be selected? a) Based on the payback period? b) Based on benefit-cost ratio analysis c) Benefit/Costs Analysis using...
8-14 A The following four mutually exclusive alternatives have no salvage value after 10 years. First cost Uniform annual benefit Computed rate of return $7500 $5000 $5000 $8500 1600 1200 1000 1700 16.8% 20.2% 15.1% 15.1% (a) Construct a choice table for interest rates from 0% to 100%. (b) Using 8% for the MARR, which alternative should be selected?
international genetic technologies inc. (InGen) is examining the following three mutually exclusive alternatives. 3) Using benefit-cost ratio analysis, a 10-year useful life and a MARR of 25%, determine which of the following mutually exclusive models should be selected. А в C D E Initial Cost $100 $200 $300 $400 $500 $37 $60 $83 $137 $150 Annual Benefits 4) A big box company is using a benefit-cost ratio analysis to select which one of the 3 alternatives shown below should be...
8-14 A The following four mutually exclusive alternatives have no salvage value after 10 years. A B C D First cost $7500 $5000 $5000 $8500 Uniform annual benefit 1600 1200 1000 1700 Computed rate of return 16.8% 20.2% 15.1% 15.1% (a) Construct a choice table for interest rates from 0% to 100%. (b) Using 8% for the MARR, which alternative should be selected? 9-59 Two equipment investments are estimated as follows: Year 0 - $15,000 5,000 5,000 5,000 5,000 5,000...