Question 1 All calculations should be rounded to O decimals. Column G Description Months Played Notes Find # of months from the date drafted Use an Index / Match to find Team + Bonus Max. % Salary + (Salary x Bonus Max. %) H+1 Team + Bonus Max. % J Total Salary H K L M N o P Bonus Max. % % Team Total Salary F F G Date drafted Months (Day) Played 5 12 2 5 6 7 7 2 2 15 1 26 8 1 11 14 26 26 A B B D E Drafted Drafted 1 Player Position Salary (Year) (Month) 2 Amini Silatolu T $775,000.00 2016 3 Andrew Norwell G $2,746,000.00 2016 4 Ben Jacobs LB $775,000.00 2019 5 Cam Newton QB $13,166,666.00 2018 6 Captain Munnerlyn DB $900,000.00 2010 7 Charles Johnson DE $1,000,000.00 2019 8 Chris Manhertz TE $540,000.00 2008 9 Christian McCaffrey RB $465,000.00 2013 10 Colin Jones DB $775,000.00 2017 11 Curtis Samuel WR $465,000.00 2016 12 Daeshon Hall DE $465,000.00 2008 13 Damiere Byrd WR $540,000.00 2016 14 Daryl Williams OT $615,000.00 2010 15 Daryl Worley CB $560,000.00 2011 16 David Mayo ILB $615,000.00 2010 17 Demetrious Cox FS $465,000.00 2014 18 Devin Funchess WR $836,900.00 2019 19 Ed Dickson TE $1,950,000.00 2011 20 Fozzy Whittaker RB $850,000.00 2008 21 Graham Gano P $3,200,000.00 2011 4 9 Team Position Bonus Max. % Offence C 4% Offence CB 10% Defence DB 8% Defence DE 8% Defence DT 6% Defence FS 1% Defence G 6% Offence ILB 1% Special Tek 2% Defence LB 6% Offence OG 9% Offence OLB 4% Offence OT 5% Special Te Position 6% Offence QB 6% Offence RB 3% Offence T 6% Offence TE 3% Offence WR 2% 1 9 5 1 6 4 4 12 8 7 9 21 22 2 10 4 12 30 9 25 2 3 3