Please make a Feasibility analysis based on the scenario.

Rossco's Feasibility Analysis File Home Insert Page Layout Formulas Dsta Review View Developer Help T3 1David is considering the purchase of a new computer with the following estimated costs: initial 2 systems design, $54,000; hardware, $74,000; software, $35,000; one-time initial training, 11,000; system installation, $20,000, and file conversion, $12,000. A new reduction of three employees is expected, with average salaries of $40,000. The system will decrease average 5 yearly inventory by $150,000. Annual operating costs will be $30,000 per year. 7 The expected life of the machine is four years, with an estimated salvage value of zero. The 81 effective tax rate is 21%. All computer purchase costs will be depreciated using the straight- 9 line method over its four-year life. Rossco can invest money made available from the reduction 101 in inventory at its cost of capital of 10% All cash flows, except for the initial investment and 11 start-up costs, are at the end of the year. 13 REQUIRED 14 Use a spreadsheet to perform a feasibility analysis to determine whether Rossco should 15 purchase the computer. Compute the following as part of the analysis: initial investment, after- 16 tax cash flows for years 1 through 4, payback period, net present value, and internal rate of 7 return. Answer the question "should Ressco purchase the new computer and why? 18 s In oarder to conduct sensitivity analysis, create a spin buttom to allow the tax rate to be altered 201 from 15% to 30% at an increment of 1%. Also create a scroll bar to allow the cost of capital to 21 | be altered from 5% to 15% at an increment of 196. 24 27 Rossco Case Feasibility Ana lysis ) Type here to search