Use Excel please and please show formulas. Thank you! Warmack Machine Shop is considering...
90.2K
Verified Solution
Link Copied!
Question
Finance
Use Excel please and please show formulas. Thank you!
Warmack Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $530,000 is estimated to result in $220,000 in annual pretax cost savings. The press falls in the MACRS five year class, and it will have a salvage value at the end of the project of $89,000. The press also requires an initial investment in spare parts inventory of $26,000. The shop's tax rate is 35 percent and its discount rate is 9 percent. Property Class Three-Year 33.33% 44.45 14.81 7.41 Seven-Year 14.29% 24.49 17.49 12.49 8.93 8.92 8.93 4.46 Year Five-Year 20.00% 32.00 19.20 11.52 11.52 2 4 6 5.76 Compute the NPV and IRR of the project. Should the firm buy the machine press
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!
