must use excel/show your work/equations

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/2020 of $400,000 and 11/1/2020 of $200,000 to purchase merchandise. The Net Conribution Margin will be based on the weeks and opponent. What is the Present Value of this project on October 1, 2020 assuming a 15% required rate of return? Oct 1, 2020 Spend $400,000 on Inventory Nov 1, 2020 Spend $200,000 on Additional Inventory Oct 24, 2020 Nebraska Game: Net Margin $120,000 Oct 31, 2020 Penn State: Net Margin $95,000 Nov 7.2020 Rutgers: Net Margin $85,000 - Nov 14, 2020 Maryland: Net Margin $75,000 Nov 21, 2020 Indiana: Net Margin $150,000 Nov 28, 2020 Illinois: Net Margin $160,000