Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

must use Excel. please show work/equations used. 1 Nike is looking at an investment in automation for their Nike.com warehouse in Memphis to have drones

image text in transcribed

must use Excel. please show work/equations used.

1 Nike is looking at an investment in automation for their Nike.com warehouse in Memphis to have drones fry through the warehouse and collect inventory data, feed this to an Al system, and track their inventory better. The system will cost 6,500,000 and have an annual $200,000 expense with an 4% cost escalation clause. The system will save Nike $2,200,000 per year mostly in labor and they have a 2.5% inflation factor for labor. Assume Nike will pay 21% Tax on the increase in profits they make from this project. What is the IRR of this project over the 5 year life? 2

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

Financial Management Core Concepts

Authors: Ray Brooks, Raymond Brooks

1st Edition

0321155173, 9780321155177

More Books

Students also viewed these Finance questions