Must show work in excel and show excel formulas

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