Acme corporation is considering two alternative injection molding machines, and MARR IS 15% per year. Plot the sensitivity of each alternative in Excel for the following three cases of varying Net Annual Revenue (NAR), where NAR = Annual Revenues - Annual Expenses: -50% 0% +100% Using annual worth (AW) analysis, which alternative has higher sensitivity to the Net Annual Revenue (NAR)? Show computations and paste an Excel spider chart. Item Alternative A Alternative B $500,000 $150,000 $75,000 $50,000 $375,000 $130,000 $80,000 $37,000 Capital investment Annual revenue Annual expenses Salvage value Useful life 5 vears 6 vears

Acme corporation is considering two alternative injection molding machines, and MARR IS 15% per year. Plot the sensitivity of each alternative in Excel for the following three cases of varying Net Annual Revenue (NAR), where NAR = Annual Revenues - Annual Expenses: -50% 0% +100% Using annual worth (AW) analysis, which alternative has higher sensitivity to the Net Annual Revenue (NAR)? Show computations and paste an Excel spider chart. Item Alternative A Alternative B $500,000 $150,000 $75,000 $50,000 $375,000 $130,000 $80,000 $37,000 Capital investment Annual revenue Annual expenses Salvage value Useful life 5 vears 6 vears

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 17EB: Caduceus Company is considering the purchase of a new piece of factory equipment that will cost...

See similar textbooks

Similar questions

Perform a present worth analysis of equal-service machines that have the costs shown on the next page, if the MARR is 10% per year. Revenues for all three alternatives are expected to be the same.
Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.
The Fence Company is setting up a new production line to produce top rails. The relevant data for two alternatives are shown below. Solve, a. Based on MARR of 8%, determine the annual rate of production for which the alternatives are equally economical. b. If it is estimated that production will be 300 top rails per year, which alternative is preferred and what will be the total annual cost?
Old Southwest Canning Co. has determined that any one of four machines can be used in a certain phase of its chili-canning operation. The first costsand annual operating costs (AOC) are estimated below, and all machines have a 5-year life. The MARR is 25% per year. (a) Determine which machine should be selected on the basis of a rate of return analysis. (b) Use a spreadsheet to perform PW analysis of each machine. Compare the machine selections with that of the ROR analysis.
PARC Co. has asked you to recommend a new nutcracker machine. After months of hard research, you have collected the following data: Data Life, Years First Cost (FC) Benefit, Yearly (AB) Benefit Gradient (ABG) O&M cost Gradient (M&OG) O&M Cost uniform annual Salvage Value O 21 years O 12 years O 18 years KRAX 6 O 24 years $202,000 73,000 1,200 600 18,000 42,000 SPLIT-NUT 9 $285,000 88,000 PARC Co. assumes MARR = 15%. Using the Net Present Worth (NPW) analysis: The analysis period if you are going to use NPW is close to: 1,300 1,100 34,000 48,000
A distribution company is considering three different alternatives to satisfy their customer's demands. Their options are to rent a ready distribution center (D01), Rent and mobilize a center (D02), or outsourcing (OS). The estimate for each method is shown. The lifetime for D01, D02, and OS are 3, 6, and 2 respectively. MARR is 0.04 per year. and the percentage of change for all of the cases are 0 % Note: all units are in thousand $ D01 D02 OS First Cost, $ -136 -973 0 Annual Operation Cost,$ -92 -59 -123 Salvage Value,$ 28 333 0 a: Calculate the Fw of D01? b) Calculate FW for D02 c )What is the FW for outsourcing? d: Which alternative will be selected? f: Draw the cash flow for all of these three alternatives. If contract value with subcontractor increases by 15 % every year calculate FW for Outsourcing. Is there any change in your previous decision on the basis of the new condition? If yes, which…
A process for producing the mosquito repellant Deet has an initial investment of $200,000 with annual costs of $50,000. Income is expected to be $90,000 per year. (a) What is the payback period at i = 0% per year? A i = 12% per year? (Note: Round your answers to the nearest integer.) (b) What is the annual breakeven production quantity for both payback periods (determined above) if net profit, that is, income minus cost, is $10 per gallon?
A precision lathe costs $11,300 and will cost $26,500 a year to operate and maintain. If the discount rate is 12% and the lathe will last for 4 years, what is the equivalent annual cost of the tool? (Enter your answer as positive value. Round your answer to the nearest cent.) The equivalent annual cost $
Answer using excel: Machine A costs $316 and produces a profit of $106 at the end of each year for 7 years, while Machine B costs $128 and produces a profit of $71 at the end of each year for 4 years. Assuming the operation continues indefinitely and the cost of capital is 13%. Calculate equivalent annual value (EAV) to determine the better option. Enter EAV for Machine A below.
A thermoplastic film manufacturer is trying to decide between 5 types of thermoforming molding processes to be added to its molding operation. The estimated costs and revenues are shown below. Compare them on the basis of the IRR method and determine which process should be selected if the company's MARR is 7% per year. Select the best alternative by performing an IRR incremental analysis. Justify your answer.
You must recommend one of two machines into an upgraded manufacturing line. You obtain estimates from salespeople from two companies. Salesman A gave the estimates in constant-value dollars, while salesman B provided in future (then-current) dollars. The company's MARR is equal to the real rate of return of 20% per year, and inflation is estimated at 4% per year. Use present worth analysis to determine which machine the engineer should recommend. A B First Cost $140.000 $ 25.000 10 $150.000 $ 43,000 10 Annual Cost Life (years)
A company is thinking of investing in one of two potential new products for sale. The projections are as follows: Year Revenue/cost £ (Product A) Revenue/cost £ (Product B)0 (150,000) outlay (150,000) outlay 1 24,000 12,0002 24,000 25,3333 44,000 52,0004 84,000 63,333 1.Calculate the payback period for both products in years and months, not as a decimal. Please present answer to nearest half a month.