Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Starset Machine Shop is considering a 4 - year project to improve its production efficiency. Buying a new machine press for $ 4 6 0

Starset Machine Shop is considering a 4-year project to improve its production efficiency. Buying a new machine press for $460,000 is estimated to result in $190,000 in annual pretax cost savings. The press falls in the 5-year MACRS class, and it will have a salvage value at the end of the project of $74,000. The press also requires an initial investment in spare parts inventory of $35,000, along with an additional $3,850 in inventory for each succeeding year of the project. The shops tax rate is 25 percent and its discount rate is 8 percent.
In Excel temlate (Tab Q6), show how you calculate each year's cash flow for the project and NPV.(Excel parts: 10 points)
Calculate the NPV of this project. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g.,32.16.)
An MACRS table with all 3 schedules.
Equipment Life (Years)
Year 357
133.33%20.00%14.29%
244.45%32.00%24.49%
314.81%19.20%17.49%
47.41%11.52%12.49%
511.52%8.92%
65.76%8.92%
78.92%
84.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

Bitcoin Technical Innovations From The Trenches

Authors: Sjors Provoost

1st Edition

9090360425, 978-9090360423

More Books

Students also viewed these Finance questions

Question

What guidance are you giving managers on pre- and post- briefing?

Answered: 1 week ago