Show Excel solution:

1. Nike has hired an external consultant like Crowe to provide a solution to their warehousing problem now that they sell so much in Nike.com. The project will cost the company $3,600,000 now, require $350,000 in support in year 1, and $220,000 in year 2. The company expects a benefit of $400,000 in year 1 increasing by 6% per year for the foreseeable future. What is the Discounted Payback period, if the company MARR is 9%? (Answer is not 8-9)

Nike has a plan to boost their sales with a new product for the upcoming Football season. This will be a short duration project. They think their cash flows are as such: Expenses: 10/1/2021 of $400,000 and 11/1/2021 of $170,000 to purchase merchandise. The Net Contribution Margin will be based on the weeks and opponent. What is the Present Value of this project on October 1, 2021 assuming a 15% required rate of return? (Answer is not 75,596)

10/1/21 $ (400,000.00)

11/1/21 $ (170,000.00)

10/9/21 Maryland $ 80,000.00

10/23/21 Indiana $ 110,000.00

10/30/21 Penn State $ 170,000.00

11/6/21 Nebraska $ 75,000.00

11/13/21 Pudue $ 90,000.00

11/20/21 Michigan State $ 150,000.00