Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please explain in excel 14 Tanaka Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $445,000

image text in transcribed

image text in transcribed

please explain in excel

14 Tanaka Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $445,000 is estimated to result in $160,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 $40,000. The press also requires an initial investment in spare parts inventory of $20,000, along with an additional $2,800 in inventory for each succeeding year of the project. The shop's tax rate is 22 percent and its discount rate is 9 percent. Refer to Table 10.7 Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) 10 points Skipped Print NPV Should the company buy and install the machine press? O Yes O No Year Seven-Year 1 2 Property Class Three-Year Five-Year 33.33% 20.00% 44.45 32.00 14.81 19.20 7.41 11.52 11.52 5.76 3 4. 14.29% 24.49 17.49 12.49 8.93 8.92 8.98 5 6 7 7 8 4.46

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Financial Management

Authors: Brigham, Daves

10th Edition

978-1439051764, 1111783659, 9780324594690, 1439051763, 9781111783655, 324594690, 978-1111021573

More Books

Students also viewed these Finance questions

Question

Create hy being extemfllly open: How can I [aim find change?

Answered: 1 week ago

Question

(2) How stretching are these goals?

Answered: 1 week ago

Question

(3) Who is performing well and who is not performing well?

Answered: 1 week ago