PLEASE HELP ASAP

PLEASE HELP

Excel Onlene Structured Activity: New project analysis You must, evaluate the purchase of a proposed spectrometer of the R\&D departinent. The base price is $90,000, and it would cost another 518,000 to modify the equipment for specal use by the firm. The equipment falls in oo the MACRS 3-year class and would be sold after 3 years for $22,500, The applicahle depreciation rates ace 33%,45%,15%, and 7%. The equipment would require ) $12,000 increase in net operating working capital (spare parts iriventory). The propect would have no effect on tevemeer, but it should save the firm 533,000 per if in before-tax labor costs The firm's marginal federal plus-state tax rate as 40 5. The data has been collected in the Microsoft Excel Online file below. Open the s. Whidsheet and perform the requifed analysis to answer the questions below. Open spreadsheet a. What is the inital investment outloy for the spectroms fo, that is, what is the Year 0 piroject cash flow? found your answer to the nearest cent. Negative amoint alould be thedicaterl try a minus sign. You must evaluote the pramhisse of a proposed spectrometer ff the Rs. department. The base price is $90;000, and it would cost another $18,000 to modify the effect on revenues, but it should save thin firm- $33,000 per yef in before-tax labor costs. The firm's marginal federal plus-state tax rate is 405 . The data has been. colliected in the Microsoft Excel Online fle below. Open the sar fodsheet and perform the required analysis to answer the questions below: should be indicated by a minus sign. b. What are the project's aneual canh flowv in Years 1,2 fod 37 found your answers to the nearest cent. In Year 15 In Year 25 In Year 35 c. If the WACC is 14%, should the spectrometer be purcilfod