Answer in excel format

You have been hired by Nike Inc (NKE) to assess the viability of a new line athleisure wear. The expected sales and costs for this project are listed below. The initial investment for production equipment is straight-line depreciated over 7 years. There is a requirement for net working capital to get the project started which is recovered at the end of the project's life. There is also an expected salvage value for the equipment. Calculate the projected cash flows. Then determine if Nike Inc. will accept or reject this project. Assume the project has a life of only 4 years. Question 1 - Complete the pro forma income statement for the life of the project and calculate the Unlevered Net Income for each year