Question

Problem 3 (40 Points) Acme Products has four alternatives for a conveyor system (CS1, CS2, CS3, CS4), as shown below. MARR is 15%. Us incremental cash flow analysis to determine the economically optimal system. Solve this problem in Excel, copy and paste the Excel model below, and provide interpretations. CS1 CS2 CS3 CS4 Capital Investment $350,000 $380,000 $340,000 $370,000 Net Annual Revenues $85,000 $95,000 84000 90000 Residual Value $101,000 $104,000 95000 102000 Study Period 6 Years 6 Years 6 Years 6 Years

          Problem 3 (40 Points)
Acme Products has four alternatives for a conveyor system
(CS1, CS2, CS3, CS4), as shown below. MARR is 15%. Us
incremental cash flow analysis to determine the economically
optimal system. Solve this problem in Excel, copy and paste the
Excel model below, and provide interpretations.
CS1 CS2 CS3 CS4
Capital Investment $350,000 $380,000 $340,000 $370,000
Net Annual Revenues $85,000 $95,000 84000 90000
Residual Value $101,000 $104,000 95000 102000
Study Period 6 Years 6 Years 6 Years 6 Years

Show more…

Problem 3 (40 Points)
Acme Products has four alternatives for a conveyor system
(CS1, CS2, CS3, CS4), as shown below. MARR is 15%. Us
incremental cash flow analysis to determine the economically
optimal system. Solve this problem in Excel, copy and paste the
Excel model below, and provide interpretations.
CS1 CS2 CS3 CS4
Capital Investment 350,000380,000 340,000370,000
Net Annual Revenues 85,00095,000 84000 90000
Residual Value 101,000104,000 95000 102000
Study Period 6 Years 6 Years 6 Years 6 Years

Added by Vanesa P.

Principles of Economics

Gregory Mankiw 8th Edition

Instant Answer

Solved by Expert Shelayah Robinson

Step 1

Calculate the net cash flows for each alternative by subtracting the capital investment from the net annual revenues for each year. For CS1: Year 1: $85,000 - $350,000 = -$265,000 Year 2: $85,000 - $350,000 = -$265,000 Year 3: $85,000 - $350,000 = -$265,000 Year Show more…

Show all steps

lock

Thanks for your feedback!

Problem 3 (40 Points) Acme Products has four alternatives for a conveyor system CS1, CS2, CS3, CS4, as shown below. Use incremental cash flow analysis to determine the economically optimal system. Solve this problem in Excel, copy and paste the Excel model below, and provide interpretations. CS1 CS2 CS3 CS4 Capital Investment $350,000 $380,000 $340,000 $370,000 Net Annual Revenues $85,000 $95,000 $84,000 $96,000 Residual Value $101,000 $104,000 $95,000 $102,000 Study Period 6 Years 6 Years 6 Years 6 Years

Play audio

Feedback

Powered by NumerAI

Shelayah Robinson and 87 other subject Microeconomics educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later