Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve with Excel formatting Tanaka Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $480,000 is
Solve with Excel formatting
Tanaka Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $480,000 is estimated to result in $202,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 $73,000. (MACRS schedule) The press also requires an initial investment in spare parts inventory of $39,000, along with an additional $4,050 in inventory for each succeeding year of the project. The shop's tax rate is 24 percent and its discount rate is 9 percent. Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Should the company buy and install the machine press? No Yes \begin{tabular}{|cccc|} \hline \multicolumn{4}{|c|}{ Property Class } \\ \hline Year & Three-Year & Five-Year & Seven-Year \\ \hline 1 & 33.33% & 20.00% & 14.29% \\ 2 & 44.45 & 32.00 & 24.49 \\ 3 & 14.81 & 19.20 & 17.49 \\ 4 & 7.41 & 11.52 & 12.49 \\ 5 & & 11.52 & 8.93 \\ 6 & & 5.76 & 8.92 \\ 7 & & & 8.93 \\ 8 & & & 4.46 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started