Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. we need to modernize how we move inventory around

We need to modernize how we move inventory around in our warehouse and will select...

60.1K

Verified Solution

Question

Finance

We need to modernize how we move inventory around in our warehouse and will select either a conveyor belt system or a forklift truck to handle our inventory. We must choose one, but not both, methods. (They are mutually exclusive). The conveyor belt system will cost $46,000 to install and will save us $18,000 each year for the next 5 years in operating costs. The forklift truck will cost $32,000 to purchase and will save us $14,000 each year for the next 5 years in operating costs.

a. Prepare an Excel spreadsheet to calculate $NPV, IRR%, and MIRR% at both ra=10% and ra=18% for each of these options.

b. Which option will we choose if our ra=10%? What criterion did you use to make your decision?

c. Which option will we choose if our ra=18%? What criterion did you use to make your decision?

d. Prepare a chart in Excel showing the NPV Profile for each of these options. Be sure to format

and label your chart appropriately.

e. Calculate rc%, the discount rate at which the 2 profiles cross over. What is the significance of

this rate?

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students