please help ill leave a like! Excel Online 5...

80.2K

Verified Solution

Question

Finance

please help ill leave a like!
image
image
image
Excel Online 5 tructured Activity; New project atalysis You mast evaluate the purchase of a proposed spectrometer for the RaD department. The base price is 5270,000 , and it would cost another $67,500 to modify the equipment for special use by the firm. The equipment falls inte the MACR5 3 -year class and would be sold after 3 years for 581,000. The applicable deprecaation rates are 33\%, 45%,15%, and 7\%. The equipenent would require an $7,000 increase in net operating working capital (spare parts inventory). The project would have no effect on revenues, but it should save the firm $53,000 per year in before-tax labor costs. The firmis marginal federal-plusistate tax rate is 40%=. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below: Open spreedsheet a. What is the initial investment outlay for the spectrometer, that is, what is the Year o project cash flow? Round your answer to the nearest cent, Negative amount should be indicated by a minus sign. b. What are the project's aninual cash flows in Years 1, 2 , and I? found your answerp to the nearest cent. In Year 15 Ini Year 25 In Year 35 C. If the WACC is 12%, should tha spectrometer be purchased? Calculation Mode Automutic Wonbook Statistics

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students