Landon Lowman, star quarterback of the university football team, is thinking about forgoing his last two years of eligibility and making himself available for the professional football draft. Scouts estimate that Landon could receive a signing bonus of $1.5 million today along with a five-year contract for $3 million per year (payable at the end of the year). They further estimate that he could negotiate a contract for $5.5 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 out his eligibility. If he stays at the university, he is expected to receive a $2.5 million signing bonus in two years along with a 5-year contract for $5 million per year. After that, the scouts expect Landon to obtain a five-year contract for $6 million per year to take him into retirement. Please solve in Excel and show all formulas used. Thank you!