Deliverables: 1. Page 1. Cover page with your name, the class name, and Lynn University 2. Page 2. One-page executive summary where you tell me the order in which you would prioritize each project. 3. Page 3. Excel document where you copy and past your tables o Table 1. Selection Matrix o Table 2. Payback Period (*Use first year annual sales only) o Table 3. NPV Model 4. Formulas: o Selection Matrix: To calculate the weighted score use "=Sumproduct($C$5:$F$5,07:F7)" remember the "$" sign makes it an absolute reference o Payback Period: Use "Payback period = Investment/Sales" and "Rate of Return = 1/Payback Period" o NPV Model: To calculate NPV use "=NPV(rate, value1, value2)" Deliverables: 1. Page 1. Cover page with your name, the class name, and Lynn University 2. Page 2. One-page executive summary where you tell me the order in which you would prioritize each project. 3. Page 3. Excel document where you copy and past your tables o Table 1. Selection Matrix o Table 2. Payback Period (*Use first year annual sales only) o Table 3. NPV Model 4. Formulas: o Selection Matrix: To calculate the weighted score use "=Sumproduct($C$5:$F$5,07:F7)" remember the "$" sign makes it an absolute reference o Payback Period: Use "Payback period = Investment/Sales" and "Rate of Return = 1/Payback Period" o NPV Model: To calculate NPV use "=NPV(rate, value1, value2)