How do I solve this question? We have to use Excel to solve it

Please use Excel financial functions or algebraic time value of money equations in your Excel cell formulas to answer these questions in your spreadsheet in order to receive credit for correct answers. Part 4. Should he stay or should he go? Landon Lowman, the redshirt sophomore 20-year-old star quarterback of the university football team, is approached about skipping his last two years of college and entering the professional football draft. Landon expects that his football career will be over by the time he is 32 years old. Talent scouts estimate that Landon could receive a signing bonus of $5 million today, along with a five-year contract for $3 million per year (payable at the end of each year). They further estimate that he could negotiate a contract for $6 million per year for the remaining seven years of his career. The scouts believe, however, that Landon will be a much higher draft pick if he improves by playing two more years of college football. If he stays at the university, he is expected to receive a $10 million signing bonus in two years, along with a five-year contract for $4 million per year. After that, the scouts expect Landon to obtain a five-year contract for $7 million per year to take him into retirement. Assume that Landon can earn a 7% return over this time. 1. What is the present value today (when Landon is 20) of the QB's future expected NFL earnings if he enters the NFL now? 2. What is the present value today (when Landon is 20) of the QB's future expected NFL earnings if he finishes his last 2 years of college enters the NFL 2 years from now? 3. Should Landon stay in college or go to the NFL now? 1) In the case of Landon enters the NFL now N(year) 0 1 2 3 4 5 6 7 8 9 10 11 12 Signing bonus Interest rate PV(in dollars) ($2,727,272.73) ($2,479,338.84) ($2,253,944.40) ($2,049,040.37) ($1,862,763.97) ($2,822,369.65) ($2,565,790.59) ($2,332,536.90) ($2,120,488.09) ($1,927,716.45) ($1,752,469.50) ($1,593,154.09) FV(in dollars) 3,000,000 3,000,000 3,000,000 3,000,000 3,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 5,000,000 $1,000,000.00 10% 2) In the case of he finishes his last 2 years of college and then enters the NFL 2 years from now? N(year) PV(in dollars) FV(in dollars) 0 ($3,756,574.00) 1 ($3,415,067.28) In college 2 ($3,104,606.62) In college 3 ($2,822,369.65) 5,000,000 4 ($2,565,790.59) 5,000,000 5 ($2,799,044.28) 5,000,000 6 ($2,544,585.71) 5,000,000 7 ($2,313,259.74) 5,000,000 8 ($2,102,963.40) 6,000,000 9 ($1,911,784.91) 6,000,000 10 6,000,000 11 6,000,000 12 6,000,000 Signing bonus $2,000,000.00 Interest rate 10% 1. What is the present value today (when Landon is 20) of the QB's future expected NFL earnings if he enters the NFL now? Answer) ($25,486,885.58) 2. What is the present value today (when Landon is 20) of the QB's future expected NFL earnings if he finishes his last 2 years of college enters the NFL 2 years from now? Answer) ($25,336,046.17) 3. Should Landon stay in college or go to the NFL now? Answer) Landon should go to the NFL now because the present value of first case, which is Landon enters the NFL now, is higher than the present value of the second case