Help fill in box answers on excel

The Scoring Method (aka Decision Matrix) method - Use 8\% discount rate for NPV. Use Excel to calculate NPV and PP. - For ratings on NPV, use NPV/100 (Example: if NPV = \$550, use 5.5 for the rating on that project). Also, common mistake - do not divide NPV by 12 since all other data is annual. - Careful on this: For ratings on Payback Period, use the absolute value of the PP subtracted from 10 (Example: if PP=7 years, use (107)=3 for the rating on that project). This is because a project with a higher PP is less desirable and should get a lower score. Turn in an Excel file that shows your calculations of NPV and PP, your completed decision matrix, \& your written explanation of which project you chose and why