Question: Please do work in excel with formulas. The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base

Please do work in excel with formulas. The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $1,720,000, and it would cost another $80,000 to install it. The machine falls into the MACRS 3-year class, and it would be sold after 3 years for $800,000. The MACRS rates for the first three years are 0.3333, 0.4445, and 0.1481. The machine would require an increase in net working capital (inventory) of $75,500. The machine would not change revenues, but it is expected to save the firm $420,000 per year in before-tax operating costs, mainly labor. Their marginal tax rate is 27%.

What is the Year-0 cash flow?

What are the cash flows in Years 1, 2, and 3?

What is the additional Year-3 cash flow (i.e., the after-tax salvage and the return of working capital)?

If the projects cost of capital is 10%, what is the NPV?

Should you pursue this project?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Please do work in excel with formulas. The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $1,720,000, and it would cost...

Q:

The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $ 1 , 7 2 0 , 0 0 0 , and it would cost another $ 8 0 , 0 0 0 to install...

Q:

please show step hy step The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $1,720,000, and it would cost another $80,000 to...

Q:

The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $ 1 , 7 2 0 , 0 0 0 , and it would cost another $ 8 0 , 0 0 0 to install...

Q:

The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $ 1 , 7 2 0 , 0 0 0 , and it would cost another $ 8 0 , 0 0 0 to install...

Q:

The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $ 1 , 7 2 0 , 0 0 0 , and it would cost another $ 8 0 , 0 0 0 to install...

Q:

The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $ 1 , 7 2 0 , 0 0 0 , and it would cost another $ 8 0 , 0 0 0 to install...

Q:

The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $ 1 , 7 2 0 , 0 0 0 , and it would cost another $ 8 0 , 0 0 0 to install...

Q:

The Cookie Company is considering adding a new automated baking machine to its production floor. The machine's base price is $ 1 , 7 2 0 , 0 0 0 , and it would cost another $ 8 0 , 0 0 0 to install...

Q:

1 2 3 4 5 6 7 8 9 10 HO 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 The Cookie Company is considering adding a new automated baking machine to its production floor. The ma $80,000...

Q:

Shine Company produces two types of control devices: Standard and Deluxe. The price for Standard and Deluxe is set based upon total manufacturing cost per unit. The following data pertains the two...

Q:

The rainfalls for a six day period for Omarama and Twizel are as follows a = 7, a = 10, a3 = 0, a = 0, as = 2, and ag = 5, t = 19, t = 18, t3 = 0, t4 = 1, ts=5, and to = 5, where a, and t, are the...

Q:

4 Which part of a cell: a has pores that control the movement of chemicals? b is made from cellulose? c contains green pigment? d is made from watery jelly? e contains cell sap?

Q:

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Q:

1. LaunchPad for Real Communication offers key term videos and encourages selfassessment through adaptive quizzing. Go to bedfordstmartins.com/realcomm to get access to: LearningCurve Adaptive...

Q:

2. The Kings Speech centers on Alberts address to the British people on September 3, 1939, at the outbreak of World War II, audio recordings of which are available online. Listen to them, and...

Q:

3. While in class, select a partner and give a one- to two-minute impromptu speech on a topic of your choice. Your partner will write down both negative and positive feedback to share with you, and...