Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Schultz Inc. is deciding to automate either its Molding department or its Finishing department. Funds are only available for one automation. You must decide which

Schultz Inc. is deciding to automate either its Molding department or its Finishing department. Funds are only available for one automation. You must decide which department will be automated. The original cost, net cash inflows, and hurdle rates are shown below for each project. Calculate the payback period, internal rate of return, and net present value for each project. The IRR is an interest rate. Your answer should be presented with two decimal places in this format x.xx%. Then decide which department you would choose to automate based on this information. Explain your answer in the explanation box for the department you would automate. Calculations and explanations can be given on this worksheet. Formulas must be used in the answer boxes for the payback period, IRR, and NPV to receive credit. Excel formulas are perfectly acceptable.

Molding Hurdle Rate: 7% Original Cost: $(925,000)

Net Cash Inflows: Year 1 $372,000

Year 2 340,000

Year 3 227,000

Year 4 209,000

Year 5 199,000

Year 6 159,000

Payback period:

Internal Rate of Return:

Net Present Value

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

Step: 3

blur-text-image

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

Accounting What The Numbers Mean

Authors: David Marshall, Wayne William McManus, Daniel Viele

7th Edition

0073011215, 9780073011219

More Books

Students also viewed these Accounting questions

Question

What are the purposes of promotion ?

Answered: 1 week ago