Question

In: Finance

Three proposals are under review for equipment replacement at ACME. ACME uses an MARR of 12.0%...

Three proposals are under review for equipment replacement at ACME. ACME uses an MARR of 12.0% when evaluating the economic contribution of investments. Data on the cost of each is shown below. Answer questions that follow based on this data.

Proposal Investment Amt 1 2 3 4 5
A 440,000 36,000 41,000 42,000 44,000 71,000
B 280,000 82,000 88,000 94,000 100,000 120,000
C 370,000 54,000 58,000 61,000 70,000

90,000

a. Using a rate of return method for analysis, what is the rate of return of the extra investment required to purchase the middle cost proposal in place of the lowest cost proposal?

b. Using a rate of return method for analysis, what is the rate of return of the extra investment required to purchase the highest cost proposal in place of the lowest cost proposal?   

c. Using a rate of return method for analysis, what is the rate of return of the extra investment required to purchase the highest cost proposal in place of the middle cost proposal?    

d. Which of the three proposals makes the best economic value for ACME provided ACME has the capital to invest?  

Solutions

Expert Solution

Please see the table below. The first column tells you which part (a), (b) or (c) is being answered in each line. The second last column highlighted in yellow is your answer. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output.

Part (d)

(C - B) produces the highest IRR (part (a)) above. Hence, the incremental investment, makes more sense in project C. Please examine the answer of Part (c). (A - C) has the least IRR. Hence, incremental investment in A over C is not advisable. Hence, between the three proposal, proposal C makes the best economic value for ACME provided ACME has the capital to invest


Related Solutions

Two mutually exclusive proposals, each with a life of 5 years, are under consideration. MARR is...
Two mutually exclusive proposals, each with a life of 5 years, are under consideration. MARR is 12%. Each proposal has the following cash flow profile: EOY NCF(A) NCF(B) 0 -$30,000 -$42,000 1 $9,300 $12,625 2 $9,300 $12,625 3 $9,300 $12,625 4 $9,300 $12,625 5 $9,300 $12,625 Determine which alternative the decsion maker should select using the internal rate of return method. Note: Need to use uncremental IRR analysis to calculate exact IRR Please give the written answer, not the excel...
A piece of equipment now is use at a plant is under consideration for replacement. It...
A piece of equipment now is use at a plant is under consideration for replacement. It has a market value of 8,000. This market value is expected to decline by 50% per period (from the previous period) until it reaches zero at the end of period 3. The estimated operating and repair cost for the next period is 26,000 and this is expected to grow at a rate of 15 percent per period. A replacement has been located that will...
Central Trailer Supply decided to also use NPV to review the three proposals for its new...
Central Trailer Supply decided to also use NPV to review the three proposals for its new trailer assembly line. Information on each proposal is the same and follows: Proposal X Proposal Y Proposal Z Initial investment in equipment $115,000 $130,000 $145,0000 Working capital needed 0 0 15,000 Annual cash saved by operations: Year 1 55,000 60,000 60,000 Year 2 55,000 40,000 60,000 Year 3 55,000 40,000 60,000 Year 4 55,000 10,000 60,000 Required: Determine each proposal's NPV. A rate of...
1. Discuss the THREE uses of Trial Balance with Literature Review and by providing example for...
1. Discuss the THREE uses of Trial Balance with Literature Review and by providing example for each use of Trial Balance. . (word range – 150 to 200) 2. Mr. Juma paid the rent three months in advance for his shop. Write a short note on prepaid expenses with Literature Review and by providing examples. (word range – 150 to 200) 3. Ms. Salma is yet to pay the salaries to her employees of last three months. Write a short...
Lancaster Corporation (replacement decision analysis) The Lancaster Corporation purchased a piece of equipment three years ago...
Lancaster Corporation (replacement decision analysis) The Lancaster Corporation purchased a piece of equipment three years ago for $250,000. It has an asset depreciation range (ADR) midpoint of eight years (i.e. use the 5-year MACRS schedule). The old equipment can be sold for $97,920. A new piece of equipment can be purchased for $360,000. It also has an ADR of eight years (again, use the 5-year MACRS schedule). Assume the old and new equipment would provide the following operating gains (or...
6-40 Replacement of Old Equipment Three years ago, the Oak Street TCBY brought a frozen yogurt...
6-40 Replacement of Old Equipment Three years ago, the Oak Street TCBY brought a frozen yogurt machine for $11,200. A salesman has just suggested to the TCBY manager that she replace the machine with a new $13,500 machine. The manager has gathered the following data: Old Machine New Machine Original Cost $11,200 $13,500 Useful Life in years             8             5 Current age in years             3             0 Useful life remaining in years             5             5 Accumulated depreciation...
Three options are under review for controlling neighborhood flooding during heavy rainstorms. All options are expected...
Three options are under review for controlling neighborhood flooding during heavy rainstorms. All options are expected to be in place for 50 years. The options differ both in cost and damage averted when a heavy rain event occurs. A promise has been made to build one option so ‘doing nothing’ is not a political acceptable alternative. When considering weather driven damage the usual method is to list the level of damage in currency terms and to state the likelihood that...
Three years from now (now =Year 0) the equipment that Dark Star Technologies uses to coat...
Three years from now (now =Year 0) the equipment that Dark Star Technologies uses to coat and protect the surfaces on its products will have to be replaced. Dark Star plans to operate the new equipment for 7 years (Years 4 to 10). The company is considering two procurement options. Option 1: MAKE the manufacturing equipment in-house. The yearly acquisition costs associated with developing the equipment in-house are as follows: Year 1 = $200,000, Year 2 = $700,000, Year 3...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT